This article guides you through enabling the Microsoft Entra-only authentication with Azure SQL feature within Azure SQL Database and Azure SQL Managed Instance. If you are looking to provision a SQL ...

Looking for a Stellar Repair for MS SQL review? You’ve come to the right place. I recently got hands-on with the SQL database recovery software and explored its key features, ease of use, pricing, and ...

It’s the week of Fabcon Europe and you’re about to be overwhelmed with new Fabric feature announcements. However there is a new blink-and-you’ll-miss-it feature that appeared in the latest version of ...

Following up on my previous article on SQL Server Fill Factor, it became clear that Page Splits demand a more dedicated and technical exploration. This article serves as that in-depth dive into their ...

Below is a cheat sheet that can be used for configuring SQL Server audit policies to log and detect potentially malicious behavior. It also includes some TSQL cheats for viewing the current audit ...

If you are asking “GUI-what?”, not to worry, you aren’t alone. A GUID is a Globally Unique Identifier that helps manage the relational data in the Common Data Service for Apps and SQL Server.

Yesterday I worked with a friend saving PowerApps data to SQL Server in the cloud. Using the SQL Server connector, we connected to a table with a primary key GUID and two additional varchar fields.

If you are designing a system for high throughput and want to minimize blocking, it’s important to know in advance exactly what kind of locking behaviour to expect. On SQL Server, Microsoft Dynamics ...