SQL In The City: London 2012, Recap
Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...
2012-07-17 (first published: 2012-07-16)
2,090 reads
The Scary DBA
Querying Information from the Plan Cache, Simplified
One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...
2012-07-02
1,504 reads
The New Phone Book Is Here!
I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....
2012-06-27
1,611 reads
Problems with my new book
First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...
2012-06-26
836 reads
Does Encryption Affect Seeing Statements in Deadlock Graphs?
Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...
2012-07-03 (first published: 2012-06-25)
2,274 reads
PASS Summit 2012
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....
2012-06-19
792 reads
PASS Nomination Committee
For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...
2012-06-13
814 reads
Guest Blog
I was given the opportunity to put together a guest blog post for the MVP blog. I did a little...
2012-06-05
945 reads
How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,338 reads
Never, Ever Use Clustered Indexes
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,379 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