TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates...
2018-07-18
244 reads
Performance Tuning Exercise: Lazy Table Spool
Folks, it’s time for a bit of a performance tuning exercise. Below is a real world situation where a stored...
2018-07-18
23,311 reads
Is this a SQL Provision Cloned Database?
As I work with SQL Provision, I keep finding new questions and concerns from clients and customers. Recently I had...
2018-07-18
699 reads
Data lakes and swamps, oh my
I was lamenting to my friend and fellow MVP Shamir Charania (blog | Twitter) that I didn’t have a topic for...
2018-08-01 (first published: 2018-07-18)
2,981 reads
Working Hard in Baton Rouge
I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays...
2018-07-18
419 reads
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the...
2018-07-31 (first published: 2018-07-18)
3,034 reads
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored in temporary tables. Microsoft introduced table variables for the...
2018-07-18
32 reads
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored...
2018-07-18
2,066 reads
Creating SQL images in Azure with ACR Build – Part One
Whenever I’ve pushed images up to an Azure Container Registry I’ve been building them locally (using Docker for Windows) and...
2018-07-18
366 reads
Schedule an Extended Event to run at a Specific Time
When you are using the extended event to capture some data for troubleshooting purpose, you may want to start or...
2018-08-01 (first published: 2018-07-18)
5,351 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers