Three years ago, a client asked me a question I now hear at least once a month: "Should we run our SQL Server on Azure or AWS?" It sounds simple. It isn't. The team had already short-listed AWS RDS ...

Microsoft delivered fixes for issues affecting everything from Windows to Office, .NET, and SQL Server, and several patches that should be deployed ASAP. Microsoft this week released 139 updates ...

Microsoft releases SQL Server 2025 CU2 with bug fixes and performance improvements. Update addresses backup, disaster recovery, replication, storage and resource governor issues. Regular cumulative ...

The system-to-administrator ratio is commonly used as a rough metric to understand administrative costs in high-scale services. With smaller, less automated services this ratio can be as low as 2:1, ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

The increasing adoption of AI technologies is presenting new challenges for our customers’ data estate and applications. Most organizations expect to deploy AI workloads across a hybrid mix of cloud, ...

It's important to plan for security before you configure your replication topology. This tutorial shows you how to better secure a replication topology. It also shows you how to configure distribution ...

A single installation of SQL server is called an instance. An instance can house many individual databases. These individual databases can either be system databases or user databases. In the context ...

A database is an essential component of any modern application, providing a repository for storing and retrieving large amounts of information. Building a database can seem daunting, but it can be ...

Part of the SQL Server 2022 blog series. Today, we are excited to announce the public preview of SQL Server 2022. Anyone can now download SQL Server 2022 preview to try the new features in this ...

Welcome to this Microsoft solutions workshop on SQL Server 2019 Lab. SQL Server 2019 is a modern data platform designed to tackle the challenges of today's data professional. SQL Server 2019 is not ...