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

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

This article explains how to repair the MDF file using the native repair methods and how to use a Reliable MDF file Repair ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

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

If you’re looking for a popular database management system (DBMS) platform, Microsoft SQL Server is a solid choice. Research from Gartner shows it’s among the most widely deployed platforms in 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 ...

Lansweeper has issued a stark warning to enterprise administrators regarding the looming issue of outdated Microsoft SQL Server instances. Company Chief Strategy Officer Roel Decneut revealed (via The ...