Introducing Azure Data Studio

(Last edited on 9 January 2020) Note: This was originally written for the book SQL Server 2017 Administration Inside Out, but did not meet the publishing deadline. A revised version is now included in the book SQL Server 2019 Administration Inside Out, but because I wrote both sections, there’s no plagiarism happening here. A new
-> Continue reading Introducing Azure Data Studio

A trillion and one

Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in SQL Server, using a clustered columnstore index to maximise the compression. (Short version: it’s very slow to query. Don’t do it. Bad things happen. I have an ongoing investigation with Ewald Cress about the evil
-> Continue reading A trillion and one