UPDATE: Just use my PowerShell script, Copy-SqlLogin. You just gotta execute one line and DBA's love it.

To my knowledge, Microsoft has not yet updated their Knowledge Base to inform administrators how to migrate SQL Server logins to SQL Server 2008. The good news is that the SQL Server 2005 login migration knowledge …

My technical partner-in-crime, Brandon, created this PowerShell script last year in an effort to help him understand PowerShell a bit more. He noted that while it may not all be best practices SQL-wise, he tried his best to use as much PowerShell as possible.

#Powershell to backup and restore a SQL database from …

While attempting to add a new Indexing Server to my firm's SharePoint farm using the SharePoint Products and Technologies Configuration Wizard, I ran into the following error when clicking Retrieve Database Names:

************** Exception Text ************** System.Data.SqlClient.SqlException: Line 1: Incorrect syntax …

This has come up a few times for me, so I'm documenting this mostly for myself. Sometimes, clicking on the SharedServices1 link results in:

Error: Access Denied Current User You are currently signed in as: MOSSERVER\AdminLogin

Surprisingly, I was using a domain admin account and still ran into this error. According to …

Recently, a friend of mine asked to write a script to compare two SQL Server tables using mostly VBScript. The very thought made me shudder; I wanted desperately to compare the tables in SQL Server but ultimately, the company's requirements prevented us from doing so. Here were the stipulations:

• First, the script …

Many people are not aware that VMware Server's resource intensive Web Access/Web MUI is not required to administer VMware Server 2. As I detailed in a previous post, the same Windows-only thick client used to administer ESX Server, Virtual Infrastructure Client (VIC) 2.5, can also be used for administration.

While the …