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

Powershell – Adding accounts to Local Security Policy

 
One of the challenges I’ve had over the years is figuring out a way to add the SQL Service accounts...

SQL in the City: Free SQL Server Event in London

Red Gate Software has announced “SQL in the City: London,” to be held on Friday, July 13, 2012, at the...

SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL

Introduction
Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A...