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

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

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