Category Archives: SQL Server

Hello SMO (F#) World!

Reading The F# Survival Guide has motivated me to write my version of an F# "Hello World!" utility. What I mean by that is to write something simple that I’ve written in other programming languages as a learning exercise. In my world … Continue reading

Posted in SQL Server

Installing SQL Server 2008 on Windows 7

When Installing SQL Server 2008 on Windows 7 RTM, I encountered a couple of issues. Supposedly you can install SQL Server 2008 RTM on Windows 7. You’ll receive various warnings about compatibility issues which can be ignored and are fixed … Continue reading

Posted in SQL Server

Check for Windows Server 2003 Scalable Networking Pack

I’ve previously blogged about the issues with Windows Server 2003 Scalable Networking Pack included in Windows 2003 Service Pack 2. I keep finding servers in my environment with the feature enabled, so I created a short Powershell script to check … Continue reading

Posted in SQL Server

SQL Server 2005 Installation and the Power of 2

My colleague John O’Shea ran into an unusual issue installing SQL Server 2005 on 4-socket, 6-core machines, which I thought I would share…   We’ve started using DL 580 G5 4 socket 6-core machines and deployed a few of these boxes … Continue reading

Posted in SQL Server

Installing Visual Studio Team System 2008 Database Edition

I’ve been following Visual Studio Database Edition (VSDB) aka Data Dude, since the initial release over two years. The best overview of VSDB I’ve seen recently is a presentation given by Gert Drapers at PDC2008. Until recently I’ve only been able to look at … Continue reading

Posted in SQL Server | 1 Comment

Disable Windows Server 2003 Scalable Networking Pack

For the last several months I’ve been having Windows 2003 Server Pack 2 applied to all SQL Server in my envronment in order to bring them inline with a single build and have ran into an issue with Windows Server 2003 … Continue reading

Posted in SQL Server | 3 Comments