On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has some connection with the Holiday season for Christians. Fewer...
2012-12-13
20 reads
On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has...
2012-12-13
841 reads
Solution to VSTA editor error in SSIS 2012
The script task in SSIS 2012 is a great tool when you need to use C# or VB code to...
2012-12-13
3,692 reads
SQL Server Training–New York New York!
For those that read my blog regularly you will know that I over the last couple of years I have...
2012-12-13
1,031 reads
Using XQuery to remove duplicate values or duplicate nodes from an xml instance
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,565 reads
The Great DBA Getaway
Free, at last!
It’s holiday season which means it’s a time for you all to buy me gifts super busy time for Data...
2012-12-12
1,037 reads
PASSMN–Passing the Baton: A Board Transition Story
Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team. I have been...
2012-12-12
777 reads
Working with Excel Destinations in SSIS - 0xC0202025, 0x80040E21
Working with Excel in SSIS is not fun and something I whole-heartedly discourage. With that said, I had a not...
2012-12-12
1,532 reads
You Need to Manage Passwords
I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded...
2012-12-18 (first published: 2012-12-12)
2,735 reads
Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,046 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