Identifying Contention in TempDB

It has been a number of years since I have seen a TempDB contention issue in a system that I support. When I came across this one, luckily during a load test and not a production environment, it was a great refresher.  The offending application in this case is SharePoint 2010, but the problem was…

0

What do you mean you won’t let us install you?

I recently came across an puzzling SQL install issue.  Actually, it was more of a “SQL won’t let me install” issue with SQL 2008 R2. When running the SQL installer for a failover cluster, one of the prerequisite checks is that cluster validation has been run successfully on the Windows cluster.  If that test does…

0

PASS Summit 2011: My Recap and Advice on Takeaways

This was my first time attending the PASS Summit as a Microsoft employee, but I have been to the summit 6 times before.  I had typically gone to the summit simply for educational purposes and steered clear of a lot of networking and social events. This year I added more networking into the mix.  Instead…

2

Implementing Log Shipping for Many Databases

In my previous post, I discussed using log shipping as a method for migrating databases to reduce application downtime.  Using Management Studio to configure log shipping for each database is fine… until you have a large number of databases to implement.  Here I will describe some sample scripts that will utilize a reference table and…

5

Minimizing DB Migration Downtime Using Log Shipping

A common and often unpleasant task for DBA involves moving databases between physically separate SQL instances.  This could be due to a data center move, hardware refresh, SQL Server version upgrade, server  onsolidation, company merger, and more.  Whether you have a small number of large databases or a large number of small databases, this task…

0

Backup Compression Confusion

“When I use backup compression, I notice the backup file is very large but then once the backup is complete the file is much smaller.  Is this how it is supposed to work?” In the past few weeks I have seen this question pop up a number of times, so I thought I would write…

0

Introduction

I am a SQL Server Premier Field Engineer who has been with Microsoft since March, 2011.  Before joining Microsoft, I worked as a DBA for over 13 years. My primary technical expertise is with SQL Server (starting with version 6.0), but I have also managed DB2, Sybase, and Oracle systems. Most of the systems I have supported have been large scale OLTP…

0