This December–SQL Server Consolidation and Virtualization
This December (5th - 7th) I will be presenting SQL server Consolidation and Virtualization: Hands-On for Learning Tree in New York....
2012-10-19
933 reads
A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
638 reads
this is what I do when I install SQL. How about you?
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
879 reads
Address Clean-up for Mail Merge using SSIS
Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...
2012-10-19
748 reads
MDX #19 – There is more to do to concatenate row values into column
Continuing from MDX #18 – Easy to concatenate row values into column in MDX.
I have not accomplished the goal of concatenating...
2012-10-19
1,459 reads
Visio 2010 Workaround: Application Hangs when opening ‘Database Model Diagram’ template
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’. The program VISIO.EXE version 14.0.6122.5000 stopped interacting with Windows...
2012-10-18
53 reads
Visio 2010 Workaround: Application Hangs when opening ‘Database Model Diagram’ template
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’.
The...
2012-10-18
1,189 reads
Awarded – Microsoft Community Contributor Award 2012
Today, I’ve received an email from Microsoft stating that I’ve been awarded Microsoft Community Contributor. This is the first time...
2012-10-18
1,689 reads
DBA Study Guide
http://www.flickr.com/photos/caledonia09/4999119065/
Hello Dear Reader, over here at Pragmatic Works we’ve been growing like weeds. For the most part we are looking...
2012-10-18
2,444 reads
On Source Control
A mention today from Jamie Thomson in his blog on source control. I left a comment, but it was long,...
2012-10-18
1,607 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