A Month of PowerShell – Day 2 (Variables and Operators)

Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Month of PowerShell – Day 1 (Getting Started)

Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know...

Adding new data files to a log shipped database

I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site,...

Ghost Cleanup

T-SQL Tuesday #38 – Standing Firm

This month’s T-SQL Tuesday is hosted by Jason Brimhall. Being as this is January, lots of people are making New...

Ghost Cleanup process

I’ve been digging deeper into the Ghost Cleanup process recently, and quite naturally my quest lead to Paul Randal’s blog....

TSQL Tuesday #37 – Joins and Implicit Conversions

Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this...

T-SQL Tuesday #36 – Community

Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...

Does a Clustered Index really physically store the rows in key order?

 The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is...

Dealing with orphaned users

The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...