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

Troubleshooting Database mail

Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to...

When SQLCommunity disappoints....

Everyone who is involved in, and follows me in the SQL Server Community, and my blog, knows, that I am one...

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

May 2012 – Monthly SQL Server Checklist

They say, “April showers bring May flowers.”  But what if it doesn’t bring May flowers?  What if instead you get...