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

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

In this session Prakash will walk through the process implemented to alleviates many of the pain points for deploying, managing,...

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

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

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

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

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

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

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