TinyInt problem in SSAS

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

Presenting at SQL Saturday #111

On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...

The Encryption Primer

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

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

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

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

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

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