In order to emulate a DB2/iSeries<->SQL Server setup that I deal with at work, I installed DB2 Express-C on SuSE Linux Enterprise Server 10. The DB2/Linux Server details, as well as a sample database and table name, are as follows: IBM DB2 DatabaseNetwork NameLUCASTCP …

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 …

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 …

I've always been slightly jealous of PostgreSQL's network data types, speficially, it's IPv4-supporting cidr type. I wondered if Microsoft would ever implement a similar type (I'm still wondering) but until they do, I'll work with the ghetto I've got: User-Defined Datatypes, which were introduced in SQL Server 2005. …

Before I start, I thought I would mention that I've always thought there was something a little suspicious about simple-talk.com. I couldn't quite put my finger on it, but.. ok for instance, one of their bloggers, "Phil Factor" (FILLFACTOR -- get it?), kinda freaks me out. Maybe it's his avatar. Image not …

I'd forgotten about this lil trick. select eUserName from eAttribute GROUP BY eUserName HAVING COUNT( eUserName) > 1

Reference for me. Reference for you. sp_MSforeachtable @command1="EXEC sp_changeobjectowner '?','dbo'"

For as many times as I have read about sending e-mails using SQL Server triggers, I've rarely come across actual code samples. After someone asked for a "Triggers for Dummies" example in a Facebook SQL group, I created the following example which uses a trigger to alert a manager that an expensive item has …