Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

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

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

This role installs, configures, and starts Microsoft SQL Server. The role also optimizes the operating system to improve performance and throughput for SQL Server by applying the mssql Tuned profile.