When working with my customers on SQL Server security, I constantly get the same question, “What are some best practices for hardening my SQL Server implementation?” Over the years, I have come up ...

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 Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

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.

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder. FileTables is a new feature introduced in SQL Server 2012. It's a ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

The Linux version of Microsoft SQL Server 2016 v.Next is a viable option for customers who want to deploy the RDBMS on an open source platform, but the early previews lack some features of the core ...