(Allan Hirt) This one is going to be a short post. One of the big capabilities of SQL Server 2019 – the ability to deploy AGs using containers – is not shipping when SQL Server 2019 is released.

(Kenneth Fisher) If you can help it you probably shouldn’t be using triggers. But if you have to use a trigger you definitely don’t want to use more than one.

(Paul White) I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. All data in a batch is represented by an eight-byte value in this particular normalized format, regardless of the underlying data type.

(Pinal Dave) I have been working as a SQL Server Performance Tuning Consultant for over 10 years. During the last 10 years, I have worked with over 100s of clients helping them with Comprehensive Database Performance Health Check. My experience says that most of the performance problems occur becaus

(Kendra Little) This morning, I received the following question from a user:

(blobeater) You can read about columnstore indexes here (https://azure.microsoft.com/en-gb/blog/transforming-your-data-in-azure-sql-database-to-columnstore-format/).

(Daniel Farina) You work as a SQL Server Database Administrator. In your company there is a database application that has grown to a point that needs to be moved to a new server with more resources. You perform the server migration and everything goes fine without any issues.

(Gerald Britton) In this article, I’ll explore the use of snapshot isolation using row versioning as an alternative to the classic ANSI SQL transaction levels.

(Chris Webb) I’ve just learned some really interesting new Power Query/M optimisation tricks!

(Grant Fritchey) It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents.