On the Second Day…

  Yesterday, I introduced the 12 Days of pre-Christmas.  In that first article, I gave you a gift to help maintain your msdb undercarriage.  Today I want to continue...

On the Second Day…

 
Yesterday, I introduced the 12 Days of pre-Christmas.  In that first article, I gave you a gift to help maintain...

Cross-database Queries by Contained Users

Cross-database Queries by Contained Users
http://www.necromaticmedia.com/2007/11/containment/

I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on...

Big Data and Hadoop Part 1

Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools...

Next Gen File System ReFS(Resilient File System) and SQLServer !

“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server...

On the First Day…

Many of us have heard the song “The Twelve Days of Christmas.”  Some are familiar with how that song has some connection with the Holiday season for Christians.  Fewer...

On the First Day…

Many of us have heard the song “The Twelve Days of Christmas.”  Some are familiar with how that song has...

Solution to VSTA editor error in SSIS 2012

The script task in SSIS 2012 is a great tool when you need to use C# or VB code to...

SQL Server Training–New York New York!

For those that read my blog regularly you will know that I over the last couple of years I have...

Using XQuery to remove duplicate values or duplicate nodes from an xml instance

Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...