When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...

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.

PowerShell can save you a lot of time on Windows admin tasks, but to use it effectively you need to understand how it works. Here’s a crash course in Windows PowerShell scripting basics to get you ...

Windows PowerShell has long been an IT administrator’s best friend — but only if you know how to use it properly. Created by Microsoft nearly two decades ago, this object-oriented automation engine ...

Microsoft announced the general availability of SQL Server 2019 and SQL Server Big Data Clusters at its Ignite conference on Monday. SQL Server 2019 builds on intelligent query processing features ...