Scripting out SQL Server Logins

I regularly move logins between servers.  Mostly this is between production and our DR site.  I’ve used the code in KB246133 many, many times but it’s pretty limited.  I started with that and wrote the script below. There is a user-defined function that’s created in master.  You…

Playing with Google Voice

I put my name down for the Google Voice trial a few months back.  I recently received my invitation and configured my account.  The entire process was painless and it has some interesting benefits: I’m in the process of starting a new business and needed a work number.  At…

Storing My Files in the Cloud

(Written on my snappy new Windows 7 RC installation.  Operating systems are so much faster before they get those pesky applications installed.) I’ve been gradually transitioning all my file storage and backup to online services, aka “The Cloud”.  I’m nearly done and thought I’d share what I’…

Scriptio available on CodePlex

Scriptio is a little utility I wrote when I was unhappy with the scripting features in SQL Server 2005.  The biggest problem I faced was that I couldn't script a DROP and CREATE in the same file.  I'm pretty sure that's finally fixed.  The utility gives you all kind of…

Terminals: A Great RDP Client

One of the joys of being a consultant is trying to keep track of remote desktop connection information for a dozen clients.  Each one has multiple servers so the combination of clients, machines, user names and passwords add up quickly.  Recently I've been using Terminals to manage all my RDP…

ReadTrace for SQL Server 2005

Microsoft just released an updated Read80Trace that works on SQL Server 2005.  The name is simplified to just ReadTrace.  ReadTrace is a command-line utility that analyzes a SQL Server trace file and summarizes performance.  The new version has a more graphical interface.  The original was one of the most helpful…