SQL Code Guard v2.7 and SQL Server 2008R2: bad news and good news

Hi all!
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I...

Tales of a DBA fed up with NOLOCK. Part 2

Feb 16, 2015

Dear Diary,

A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were...

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...

A Handy function

If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...

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...

Kill–use this weapon carefully in SQL SERVER . TIP #90

When we heard “Kill” then first impression of this word is very bad. We always scare with this word.
In...

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...

Simple-Talk Article

In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated...

Speaking on Streamlining SQL Server Implementations Across Organization - Silicon Valley!!

Speaking on Streamlining SQL Server Implementations Across Organization - Silicon Valley!!