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

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

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

SQL server 2005 Database Mail stopped functioning after installing Service Pack 3

Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time...

SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)

In the next few weeks there will be an update to the SQL Server Parallel Data Warehouse (PDW) called “Appliance Update 3?...