We were having trouble installing SQL 2005 Enterprise x64 on our clustered system. It would get to an "Inspecting Configuration" screen, and then bomb out with fairly useless errors and "memory cannot ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

I have been at this for two days, and it has completely killed all my productivity. Microsoft has been less than helpful, despite having spent non-trivial cash on a support incident.<BR><BR>Here's the ...

Note: this requires sysadmin privileges on your SQL Server instance. Note: if you want to compile the assembly yourself from code, go ahead. Make sure your target ...

As the end-of-support deadline for SQL Server 2005 draws near (April 12, 2016), you are probably starting to think about your upgrade strategy. Upgrading SQL Server is a multistage effort that takes ...

SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL ...