Sharon Dooley’s Lightening Talk and the WIT Luncheon

At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her...

SQL Server, EarthQuakes and the End…Of DBAs?

SQL Server, EarthQuakes and the End…Of DBAs?
What does the advent and integration of VMs, SSDs, and the Cloud mean for...

Book Status #1: Indexing for Performance

As some of you may know, I am writing a book on indexing.  So far I’ve written and submitted four...

Mobile Commerce and SQL Performance Tuning

I was reading through Gartners Top Predictions and one prediction captured my attention:
 “By 2014, over 3 billion of the world's...

Shrinking Transaction Logs

I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space...

Computed Columns and UDFs

I wrote about the basics of computed columns and also using CASE in a computed column recently, but there’s a...

PASS Regional Mentor

Wow, how time flies by.  It seems like just a month ago I was made the PASS Regional Mentor for...

Strong Manager or Weak Manager?

Here’s the link to my editorial on SSC last week. I was pleasantly surprised by the discussion, and was interested...

Using PowerShell to Monitor SQL Server

By Ian Treasure
Over the past few years, I have used a number of approaches to monitor SQL Server. For example,...

TRUNCATE_ONLY is not a recognized BACKUP option

Executing the code below in SQL Server 2008 will throw an error message:
 
BACKUP LOG ‘MyDatabase’ WITH TRUNCATE_ONLY

Msg 155, Level 15,...