Your SQL Server database just failed, can you restore the backup?

It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...

“Thou Shall Not Shrink the Database” #TSQL2sDay

This month, Chris Shaw (Blog | @sqlshaw)  is leading the charge on the T-SQL Tuesday.  This event is basically a blogging...

T-SQL Tuesday #30 TOP 5 Rules for the SQL Community *Screw Ethics

Chris Shaw (@SQLShaw|Blog) is hosting T-SQL Tuesday this month.  It has been a while since I participated and this month...

T-SQL Tuesday #30 - Ethics and the DBA

  This latest installment of T-SQL Tuesday #30, is hosted by SQL MVP, Chris Shaw who asks us to write on a...

Picking Technical Conference Sessions (#SQLRally Edition)

Conferences are awesome. They are full of people and sessions. Almost…TOO many sessions. How on Earth do you get in...

T-SQL Tuesday #30 – Ethics

This month the topic is hosted by Chris Shaw, and his topic is ethics.
The blog party is the second Tuesday...

Denali — Day 8: Startup Parameter

Denali – Day 8: Startup Parameter

Startup Parameters means you are providing the parameter to sql server at the start of sql...

Workspace database server was not found

You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It...

My Garden Update

It’s been just over two months since I started my small  home garden. The initial work to clear the area...

How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS

In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type.  What are these, and how do you deal with them in SQL...