Using PowerShell And SSMS Registered Servers

One of the interesting things about the PowerShell provider for SQL Server is that it is integrated so well into the entire environment. As a case-in-point, you can use the PowerShell provider for SQL Server 2008 to read the registered servers in SQL Server Management Studio (SSMS) and then run a command against them. Here’s…


I Love Data

As a DBA, we’re kind of like cooks. We don’t eat all the food we cook, so to speak. We make data available to others more than we use it ourselves. But I do love the way data can be used to find things out. I was reading a news article this morning that just…


Setting Up a Killer Demo

I do a lot of presentations, and I’m often asked how I make sure that the demonstrations go off without a hitch. I have a few tricks I use in case you have to do presentations as well. Here is some of the setup I do to make things go smoothly: 1. Use a Virtual…


Quote of the Day – Stating the Obvious

I can’t tell you how many times I’ve come into a troubleshooting or performance tuning project, only to find that “it isn’t plugged in” type issues. It reminded me of this quote: Sometimes the first duty of intelligent men is the restatement of the obvious. – George Orwell


Consolidation Strategies

Can you run SQL Server on a Virtual Machine? Sure. Should you? Well..that’s another story. You most certainly can run SQL Server in a virtualized environment – but in most of the cases that I deal with, simply having more Instances of SQL Server installed suits the purpose better. While virtualization allows you to completely…


Security Warning for sp_replwritetovarbin

There’s a new Microsoft security bulletin you should be aware of before you take off on vacation. It isn’t an open exploit; you have to be an authenticated user to try it. Not only that, if you have all the latest service packs or SQL Server 2008 you don’t have the issue. It has to…


Remote Connectivity

By now you’ve probably seen all the news reports about the bad weather, or perhaps you don’t need the news – you’re stuck in it as well. Here in Seattle we’re simply not used to this kind of snow level down below the mountains. We have lots of steep hills that have now got over…


There are no absolutes – including this one

Today’s quote of the day is one I use quite often: Always and never are two words you should always remember never to use. – Anonymous


SQL Server Management Studio Startup Options

I get asked all the time if there is a way to start up SQL Server Management Studio (SSMS) using a certain connection, or to go directly to a certain script file. There are many options you can set in the “Tools | Options” menu for startup, but you can set a lot of them…


Compliance Whitepaper for SQL Server

If you have to deal with any kind of compliance regulattions, you should check out this whitepaper, authored by my good friend JC Cannon. It’s a “keeper bookmark”: Microsoft SQL Server 2008 Compliance Guide Whitepaper It covers almost as much as the compliance training I’ve had at other companies!