Using a series of demos drawn from his latest book, Bill guides you through the maze of issues you'll face as you connect to, manage, and monitor SQL Server instances—including the new SQL Express ...

Is it possible to have a SQL Server 2005/2008 instance respond under multiple "aliases" for the same server.<BR><BR>Eg. You've got SQL Server installed, and an ...

Hey all, got a strange questions. I've recently been handed a project to build a SQL server setup to accommodate 60, production, instances of MS SQL. We're on the verge of landing a big customer who ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...

SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. SQL Server 2005 reaches its end-of-life milestone on April 12, the ...

Microsoft announced on Oct. 30 that it expanded SQL Server passive use rights for organizations licensing SQL Server with Software Assurance (SA) coverage. Organizations with SA coverage on SQL Server ...

Microsoft signaled the end of support today for its SQL Server 2005 product. The 10-year-old server has fallen out of Microsoft's "extended support" product lifecycle phase. SQL Server 2005 will no ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Kenneth Harris, a NASA veteran who worked on ...