This tutorial shows how to create an Always On availability group for SQL Server on Azure Virtual Machines (VMs) within multiple subnets. The complete tutorial creates a Windows Server Failover ...

Welcome to this Microsoft solutions workshop on SQL Server 2019 Workshop. In this course you will learn how to solve modern data challenges with SQL Server 2019 using a hands-on lab approach. This ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...

The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...

There are a variety of commercial security tools 1 available to audit Microsoft (MS) SQL Server databases. However, there can be instances when their application is not practical, including: For ...

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of ...

Development hiring managers and potential interviewees may find these open-ended SQL Server proficiency interview Q&As useful. The first installment of this TechRepublic series focused on C# developer ...