Tag: sql server

SQL Server: Consolidation Tactics and Best Practices

My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I spend just over two hours sharing my experiences and knowledge of consolidating numerous clients over the years. I had a lot of fun working on this course and owe so much to Paul Randal […]

Know Backups and Know Restores – SQL Server Restores

A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving factor behind me building this session was the response I got from talking to a dozen or so DBA’s about disaster recovery. I asked how many have ever performed a restore where you had to […]

PASS Summit 2012 – Networking

I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle Washington and attended the largest Microsoft SQL Server convention in the world. My first year was all about attending sessions and learning new things. Year two was about attending technical sessions and hanging out with […]

When Things That Are Supposed to Protect You Try to Kill You

This past week I was presented with a very unique issue.  A call came in with a production issue on a tier one application.  Unfortunately it was on a system that utilizes SQL 2000 SP4.  Having a rather small toolset to use for support I had to rely on Perfmon, sysprocesses and the usual old […]