Definitely, failover clustering is a hot topic within the SQL community – specifically if you are trying to obtain high availability and minimize data loss. My latest title SQL Server 2008 Management ...

Installing SQL Server on Windows Server 2008 R2 64-bit is not as simple as it appears Most of my test servers are still 32-bit machines. It’s not until recently that I have started to use 64-bit ...

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 ...

This week we will discuss how to troubleshoot different assembly errors that we get while troubleshooting installs for SQL Server. I’ll focus this article more on SQL Server and Windows systems.

SQL Server 2012/2014 delivers compelling new capabilities that make an upgrade worthwhile. Many IT professionals agree that the AlwaysOn Availability Group (AG) feature offers the most value with its ...

Arthur Fuller recounts his less-than-smooth installation of SQL Server 2005 Express Edition and offers a few suggestions based on what he learned along the way. Like thousands of developers, I eagerly ...

Our Sales Department has some contact management software (ACT 2005 for Workgroups) that requires SQL Server 2000. The only OS we have that will support that is Small Business Server 2003- which also ...

I've installed Horizon View, VMware's Virtual Desktop Infrastructure (VDI) product, dozens of times over the past decade. With each release, for the most part, the installation process gets easier and ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).