Presenting for Omaha SQL Server Users Group Wednesday
I am pleased to be presenting a highly interactive session tomorrow evening that is a full end-to-end setup and management...
2015-03-03
429 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on "getting more agile" I am going to look at unit testing...
2015-03-03
410 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing and why we need to do it.
My code is...
2015-03-03
19 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
67 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
58 reads
How to Fix Latch Problems when Working with Ascending Keys in SQL Server
Traditionally, we want our Clustered Index to have the following attributes:
Narrow: So that our clustered index and the non-clustered indexes that point...
2015-03-03
681 reads
50 Shades of Brown – The Series
That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to...
2015-03-03
671 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
180 reads
Simple-Talk Article
In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated...
2015-03-03
843 reads
SQL Server, Error message 1785, and cascading deletes: How it kills kittens
I've been gone for a bit, forgive the long delay. Who would have thought the hatred for a cascading delete...
2015-03-03
1,121 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