Encrypting Connections to SQL Server

I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...

SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox

In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...

SQLSaturday Site Wish List

Overall I find the site to be useful and responsive, but sometimes I see small things that I wish were...

Speaker Selection for SQLSaturday Orlando–More!

More speakers from Florida! Scott Klein lives in Seattle now, but we still consider him an honorary Floridian according to...

SQL MVP Available for your Database Needs...

Introducing Windows Server 2012 – Get the FREE eBook!

Introducing Windows Server 2012 - can be downloaded for free here.
This book provides the early, high-level information you need to begin preparing...

SQL Cruise! SQL Saturdays! Summit! SQL-SQL-SQL!

We’re drawing to the end of our third season of DBAs@Midnight (our weekly webshow by DBAs, for DBAs), and to the...

Not enough available space on destination..495GB available!

I bought a USB hard disk recently that I wanted to use to backup some VMware Workstation and some Hyper-V...

Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value

Not another comma separated string blog post I hear you say! I know that this topic has probably been done...

SQL Error 18456

18456 is probably one of the most common errors people come across and in this article we try to cover...