Table Variable Deferred Compilation (SQL 2019)

I have explored the SQL Server 2019, Intelligent Query Processing Feature – “Table Variable Deferred Compilation”.

The script contains some theory at the top and links to read.
After that, there are required queries to run on SQL Server 2019.
This way we can see the feature in action and look at it's strengths and caveats.

Tracking use of Deprecated SQL Server Features

Phil Factor explains how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax, during development, and Dynamic Management Views and Extended Events to track its use on working databases.

SQL Server TempDB Tutorial

In this article we cover many different questions about the SQL Server TempDB database to give a better understanding of what is and what it is used for.

Automate Database Restore for SQL Server

In this article we look at how to automate a SQL Server database restore using a PowerShell script.

Post SQL Server Installation steps with PowerShell

I bet, each DBA would change some settings after the SQL Server installation as per their company standard . I wrote this PowerShell script for one of my client who has below standards: Port should be 1433, static Disable SQL telemetry* & SQLWriter services Change recovery model to FUll for all databases except tempdb and […]

Lock Scenarios Using sys.dm_tran_locks

Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.

Getting Started with Data Masker for SQL Server: I Want to Mask A Database

Grant Fritchey explains what's involved in masking a SQL Server database. It can seem a daunting task, but it all becomes a lot more logical if you start from a plan, based on agreed data classifications, and then use a tool like Data Masker to implement the masking, and track progress.

Installing SQL Server 2019 using the Azure Cloud Shell

Introduction Microsoft released SQL Server on Linux, starting from SQL Server 2017. SQL Server 2019 (15.x) has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. Platform File System Red Hat Enterprise Linux 7.3, 7.4, 7.5, 7.6, or 8 Server XFS […]

How to Move System Databases to a New Physical Directory

What is the easiest way to move SQL Server system databases. Let me walk you through it!

The IDENTITY Column Property

There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.