Tag Archives: sql server

How many calls – A T-SQL Question

Posted on December 22, 2011 by way0utwest

I got a call from a friend recently that was looking for some query help. He was actually using Access, which I haven’t used in years. He knew a little T-SQL, so he could convert anything I gave him to … Continue reading →

Posted in Blog | Tagged , , | 6 Comments

Creating a Service Master Key in SQL Server

Posted on December 19, 2011 by way0utwest

The basis for all the encryption in SQL Server is the Service Master Key, which is the top of the encryption hierarchy. You can see the image below from Books Online of how this is setup. The service master key … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Creating a Service Master Key in SQL Server

How to change the SQL Server service account

Posted on December 15, 2011 by way0utwest

It’s easy. First you click here: Then you find the SQL Server 2008 or 2008 R2 program group Open those and then pick the SQL Server Configuration Manager. You might get a UAC message asking if you want to make … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Working with SQL Server Third Party Vendors

Posted on December 12, 2011 by way0utwest

I ran across Denny Cherry’s (@MrDenny) blog on Fixing Vendor Performance Problems in which he outlines three methods of dealing with the. His list is basically Work with the vendor Do nothing Fix it yourself Denny recommends that you do … Continue reading →

Posted in Blog | Tagged , | Comments Off on Working with SQL Server Third Party Vendors