Maximize View of SQL Server Query Plans with Full Screen Option

In this tip we look at how to save an execution plan for future review as well as using the full screen mode to see more of a query plan at one time.

Using Simple Linear Regression to Make Predictions

The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis.

SQL Server Agent Job Monitoring for Last Execution

In this article we continue our series of using PowerShell to monitor SQL Server by collecting the last run information for SQL Server Agent Jobs.

SQL Server Bulk Insert for Multiple CSV Files from a Single Folder

Check out this article to see how to quickly import into SQL Server many files with the same structure using T-SQL.

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.