Azure SQL Database Online Columnstore Unicorn and Rainbow Theory
As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...
2019-02-21
183 reads
All About SQL
Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
187 reads
Automating T-SQL for Azure SQL Database via Logic Apps
Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?...
2019-02-06
224 reads
SQL Server Looking into Differential Backups
I seem to be writing solely about Azure so to shake things up a bit I am going back to...
2019-02-05
184 reads
Classify your Azure SQL Database
Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you...
2019-02-04
191 reads
Azure SQL Database Roadmap
I do not usually link straight to other blog posts or technical papers but I really had to with this...
2019-01-24
305 reads
Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-01-23
1,607 reads
Azure SQL Database – Reduce the workload before initiating another service objective update
Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...
2019-01-21
234 reads
Moving off SQL Server 2008 / R2 – What can Azure offer?
You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that...
2019-01-15
254 reads
Azure SQL DB VS SQL Server For the DBA
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
313 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers