In case you’re wondering about the title T-SQL Tuesday, it’s a monthly collection of SQL Server related content where a bunch of bloggers contribute posts related a specific topic. This month’s topic hosted by Michael Coles is Large Object data types or also know as Blobs. In this blog post I’ll demonstrate working with blob…
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 of databases I use SMO (pronounced smoh or S-M-O). One of the easiest things…
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 with the application of a SQL Server 2008 service pack. So, I attempted to install SQL…
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 for SNP features by querying the registry of the remote server. The registry keys involved…
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 running SQL Server 2008 with 64 GB of memory. We recently encountered a problem installing 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 the product from a distance attending several presentations at various SQL Server conferences, but never…
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 Scalable Network Pack (SNP). Windows 2003 SP2 introduces the “helpful feature” of the TCP Chimney…
