Lost in Translation – Deprecated System Tables – sysremotelogins
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-29
1,856 reads
Interview questions for SQL Server Performance Tuning Specialists
If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.
I have...
2012-11-29
10,161 reads
HDInsight: Trying again
And I thought this would be so easy.
Latest attempt. I just did an uninstall of HDInsight. Then I found all...
2012-11-29
1,933 reads
Tables without a Clustered Index
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the...
2012-11-29
1,548 reads
Chicago: The Travels of a SQL Server Consultant
As regular readers of my blog will now as part of role as a SQL Server consultant and SQL Server...
2012-11-29
2,128 reads
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,476 reads
NY SQL Server User Group Meeting - Bill Pearson
Thursday, November 29, 2012, brings us the November
meeting of the NY SQL
Server User Group, with BI expert, SQL MVP and...
2012-11-28
1,828 reads
Significant Achievements
As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...
2012-11-28
740 reads
HDInsight: First Pass
I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But,...
2012-11-28
898 reads
The Last DBCC CHECKDB Date and Restores
I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For...
2012-11-28
3,458 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