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

Datawarehouse Trends – In-memory

What does the emergence and growth of In-memory databases mean for  Datawarehouse? 
 1)  In-Memory database server systems are  fast.  Consideration should be given to...