SQL Server 2008 Diagnostic Information Queries (April 2012)

Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...

Stress Thoughts-Part 3

It’s not fair. I hear it a couple times a day. Sometimes they are right, sometimes not, but it’s how...

The Encryption Primer

SQL Server has a number of encryption features that allow you to better secure your data. This session will examine...

TinyInt problem in SSAS

If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...

Transforming Event Log Data

Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...

Unstructured Data in SQL Server

More and more of our data does not fit neatly into a structured, relational model of rows and columns of...

Why I am excited about SQL Server 2012 (Part 2)

Earlier this month I published a blog entry on this same subject.  In honor of the local Minneapolis launch event,...

Exporting data to CSV file using SQLCMD/BCP

When it comes to exporting data there are different options available in SQL Server, such as SQL Server Integration Services,...

FILESTREAM and Snapshot Isolation Mode in SQL 2008

FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.

In SQL 2008 R2 however...

http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot...

Inserting UniCode / Special characters in tables

Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...