The SQL Server architecture is essentially the same on either platform. One difference is that the new feature of SQL Server 2008 R2 named Master Data Services is only available with the 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 ...

Ok, by now my first upgrade experience with Katmai is well-documented. So I thought I’d pass along some of my other experiences and some of the things I’ve learned. My Vista upgrade: I have a copy of ...

In-Depth Laying the Groundwork for Microsoft SQL Server 2008 Redmond's new database server is a complex product often running mission-critical apps. You can't afford to not get it right. By Josh Jones ...

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

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

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

I am installing SQL server 2000 (standard edition) to support several different 'Administrative' packages I use at work.<BR><BR>Namely, Altiris, Mcafee Management Console, OpenManage to name a ...

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.