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

SQL Server 2012 Synopsis - Mission Critical Applications Combined With The Fantastic 12 New Features or "The Baker's Dozen" as described by Microsoft this Week

Notes by Hugo S., Print Screens from three Microsoft Presentations

7 December, 2011 with Additions combined from early February 2012 day-long...

SQL Server Database Mirroring Tips and Tricks, Part 3

One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that...

Stress Thoughts–Part 2

One thing I’ve learned is that even losing one hour of sleep or just not sleeping well degrades my ability...

X on XMLA: ii. Basic Structure of XMLA

The second post in the XMLA series focuses on the basic structure of XMLA.  At its heart, XMLA is XML. ...

Off to Vegas for DevConnections

A few last minute prep items for DevConnections and I leave in a few hours for Las Vegas. My first...