Tag Archives: sql server

Finding the Default Trace File

Posted on May 7, 2012 by way0utwest

A post more for me than for anyone else, since I’ll look for something in the default trace and I often need this snippet of code: select path from sys.traces where is_default = 1 That returns something like this: path … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Finding the Default Trace File

Learn XML

Posted on May 3, 2012 by way0utwest

I first learned a lot about XML from the PDC conference in Denver in 1998. I attended a number of sessions and thought this was a great technology that would soon dominate the data exchange markets. At the time I was developing … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Learn XML

You need to run DBCC CheckDB regularly

Posted on April 30, 2012 by way0utwest

You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware problem or driver issue. Corruptions don’t disappear and you can’t necessarily Corruptions can be caused by numerous factors, and it … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on You need to run DBCC CheckDB regularly

Creating a Symmetric Key in SQL Server

Posted on April 25, 2012 by way0utwest

Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and resource usage, much better than asymmetric keys. Creating a symmetric key is fairly simple, using DDL that’s easy to understand. … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment