The developers at my company use a product called Team City to run their build server – a server that compiles source code into an installable package for testing, release, etc. Team City uses a database backend to keep track of things. I don’t have much experience with it, but it seems pretty flexible. We […]
During a recent migration from SQL 2000 to SQL 2008, I needed to move logins from the old server to the new server. We use mixed mode authentication, so we had both Windows and SQL logins that needed to be moved. My first attempt was using SSIS. I created a package on the 2008 server […]
The big replication project that I spent a couple weeks planning and testing for arrived last weekend. To recap, I needed to set replication of a rather large database with SQL 2000 as the publisher and distributor and a new SQL 2008 cluster as the subscriber. As I wrote previously, I had tested this out […]
When I get a notification from one of my SQL Servers that a job failed or something is broken, I leap into action. Those alerts are like the Batsignal for a DBA. They are a big deal and I don’t want to see them unless whatever caused it really is a big deal. So I […]
I’ve been working lately on migrating a MySQL database to SQL Server. As part of this process, once the database has been migrated, an update of the program using the database is run, which makes some changes to the structure of the database. I designed a nice little SSIS package to migrate the data from […]