SQLSaturday Returns to NYC 2015!
November 25, 2014 - Good
news in Gotham! Well you asked for it! You
wanted it! You waited for it! And now it's...
2014-11-25
1,533 reads
TempDB Configuration Best Practices
1. Do not change collation of TempDB from the SQL Server instance collation. 2. Do not change the TempDB database owner from sa. 3. Do not drop the TempDB...
2014-11-24
25 reads
Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !
The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes...
2014-11-24
22 reads
Cumulative Update – 3 for SQL Server 2012 Service Pack 2 Is Now Available !
The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released...
2014-11-24
23 reads
Placeholders for Emergencies
A long time ago I worked in a large corporation where we managed lots of servers, each of which performed...
2014-12-03 (first published: 2014-11-24)
6,818 reads
Capturing DB Usage stats – sp_spaceused simulation using DMV’s.
SP_SPACEUSED
sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by...
2014-12-01 (first published: 2014-11-24)
6,837 reads
Last Weeks Top “Reading” Links #110
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-24
896 reads
Exam Prep 70-463: Just the facts, ma’am
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-02 (first published: 2014-11-24)
7,993 reads
TempDB Configuration Best Practices
1. Do not change collation of TempDB from the SQL Server instance collation.
2. Do not change the TempDB database owner...
2014-11-24
5,491 reads
Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !
The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-11-24
740 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