[!INCLUDEssNoVersion] Remote BLOB Store (RBS) is an optional add-on component that lets database administrators store binary large objects in commodity storage solutions instead of directly on the ...

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 ...