SQL Server Problems We Don’t Have Anymore

There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.

SQL Server Interview Questions for Developers on Querying

In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers.

Getting started with SQL Server stored procedures

In this article we look at different examples of creating SQL Server stored procedures.

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.