Azure SQL Database Alerting
It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...
2017-11-16
509 reads
All About SQL
Folks Who Have Made a Difference
TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today...
2017-11-14
315 reads
SQL Server 2017 – Interleaved Execution
I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...
2017-11-20 (first published: 2017-11-09)
853 reads
Azure SQL Database Compatibility Levels
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
521 reads
Microsoft MVP!?
What? Is probably the most common reply out there and if it is then that is how I felt when...
2017-11-02
413 reads
Azure SQL Database Automatic Tuning – Questions Answered
I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...
2017-11-01
377 reads
SQL Server Phantom Reads
With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...
2017-11-08 (first published: 2017-10-26)
1,615 reads
Query Store – SQL Server 2017 vs Azure SQL Database
I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...
2017-11-02 (first published: 2017-10-24)
2,061 reads
Connecting to Azure SQL Database Primary Endpoint – Failover Groups
When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...
2017-10-19
692 reads
SQL Server: What will REPAIR do?
So I had a corruption issue and I was thinking about running repair but I wanted to know what would...
2017-10-24 (first published: 2017-10-16)
2,074 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