In addition, organizations may choose to “transition” to SQL Server 2008 by first installing a new installation and then migrating SQL Server databases and objects from the legacy environment to the ...

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

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

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

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

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

According to Rikalous, installing Business Intelligence Development Studio is necessary. Upon installing SQL Server 2008 you need to select the Client tools option under the Client tools section of ...