SQL Server Tips, Articles and Training

SQL Server resources to solve real world problems for DBAs, Developers and BI Pros - all for free. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server.

Sandi Hamilton, Allyson Sandifer and David Bermingham

High Availability Protection for Critical Applications: The Human Factor

Providing SQL Server high availability and disaster recovery protection does not have to be a complicated endeavor, but it's important to understand the roles within your organization and manage appropriately.

Author: Sandi Hamilton, Allyson Sandifer and David Bermingham

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.

Author: Sergey Gigoyan

Secrets to Fast, Easy High Availability for SQL Server in Amazon Web Services

Moving SQL Server from an on-premises data center to a public cloud such as AWS can enable your business to be more agile and more responsive to changing market requirements and customer needs.

Author: SIOS

SQL Server Date Video Tutorial

In this video tutorial we will look at the different data types that SQL Server offers for storing date and times in a database table. We will compare the differences for the data types as well as do a storage test to determine the difference...

Author: Aaron Bertrand

Analyze Historical Weather Data with SQL Server

In this article we look at how to import weather related data into SQL Server that can be used for analysis or supporting applications.

Author: Rick Dobson

Subset in R including List, Data Frame, Matrix and Vector

In this article we will examine the R Language subsetting operators, types of subsetting and differences in behavior for different R objects like vectors, lists, and data frames.

Author: Matteo Lorini

Power BI Performance Optimization Tips - Part 1

In this article we look at some tips on how to improve the performance of Power BI using smaller data models and computed columns options.

Author: Kenneth A. Omorodion

Sync SQL Server Change Tracking Tables without Changing Data

In this article I cover how to mark a record so it can be re-synchronized to a secondary system without changing the data values of the original record, thus maintaining data integrity.

Author: Jim Evans

Optimize SQL Server estate monitoring with Redgate's SQL Monitor

How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?

Author: Jeremy Kadlec

Copy Data from and to Snowflake with Azure Data Factory

In this tip we will show how you can create a pipeline in ADF to copy the data from a .csv file in Azure Blob Storage to a table in Snowflake, and vice versa.

Author: Koen Verbeeck

Using Azure DevOps CI CD to Deploy Azure Data Factory Environments

In this article I will demonstrate an end-to-end process of how to create an Azure Data Factory multi-environment DevOps CI/CD by using GitHub for source control repos synced to working and master branches.

Author: Ron L'Esteve

SQL Server MSDB Database Tutorial

In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database...

Author: Eric Blinn

SQL Server 2017 Unattended Installation on a Windows Server 2016 Failover Cluster via Command Line Part 2

In this second part of this series, we look at how to add a node to an existing SQL Server 2017 failover clustered instance

Author: Edwin Sarmiento

How to Put on Your Candidate Marketing Hat During Your Job Search

Learn about candidate marketing where you intentionally influence your overall marketability as a candidate to be more marketable and credible for roles you're applying for.

Author: Cate Murray

Create Azure Data Factory inventory using Databricks

Learn how to build a catalog of your different Azure Data Factory objects such as pipelines, activities, datasets and more.

Author: Fikrat Azizov

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.

Author: Greg Robidoux

Getting started with SQL Server stored procedures

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

Author: Greg Robidoux

Using SQL Server DMVs to Identify Missing Indexes

In this article we look at the SQL Server DMVs that can be used to identify missing index information that SQL Server collects based on executed queries.

Author: Greg Robidoux

SQL Server RegEx Capabilities Using Python

In this article we look at how to get regex features in SQL Server by using Python and T-SQL.

Author: Ian Fogelman

Compare Artificial Intelligence Models Built with T-SQL

This tip looks at using artificial intelligence models with SQL Server to predict outcomes.

Author: Rick Dobson

SQL Server Database and Database File Monitoring with PowerShell

As we continue our series on monitoring SQL Server with PowerShell in this section we collect database information for each monitored instance.

Author: Alejandro Cobar

Simple way to create tables in SQL Server using Excel

In this tip we look at an easy way to build DDL for SQL Server tables using an Excel template to generate the T-SQL for the table structure.

Author: Greg Robidoux

Understanding SQL Server Physical Joins

In this tip we cover different types of physical joins that occur in SQL Server such as nested loops join, merge join and hash join.

Author: Arshad Ali

Power BI Personalization

In this article we look at how to use the personalization feature for Power BI reports to match an individuals specific needs without having to duplicate the report.

Author: Scott Murray

Overcoming Your Interview Angst

Check out this article for 9 key tips and mindsets to overcome the job interview jitters.

Author: Erica Woods

Melissa Data Quality Solutions for SSIS

For organizations relying on the SQL Server, Melissa's solutions directly integrate with SSIS, so the learning curve is minimal. You can drag and drop Melissa components in SSIS to validate, cleanse, append and enhance data.

Author: Jeremy Kadlec

SQL Server 2017 Unattended Installation on a Windows Server 2016 Failover Cluster via Command Line Part 1

In this article we look at how to do an unattended command line install of SQL Server 2017 on a Windows Server 2016 failover cluster.

Author: Edwin Sarmiento

How to Sync Two SQL Server Databases – Part 3

In this article we cover some code that we can use to make database schemas match by comparing the objects in the databases.

Author: Mircea Dragan

SolarWinds Database Performance Analyzer for SQL Server

With the time constraints SQL Server DBAs face to resolve performance issues, they need a tool to support business critical applications. SolarWinds Database Performance Analyzer (DPA) is an end to end tool to collect data and recommend corrections.

Author: Jeremy Kadlec

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.

Author: Ian Fogelman

SQL Server Agent Job Monitoring for Last Execution with PowerShell

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.

Author: Alejandro Cobar

Snowflake Tutorial

In this tutorial we will go over the basics of Snowflake, introducing the product and features which makes it stand out against its competitors. We look at how to load and query data as well as how to use Power BI to create reports using the Snowflake...

Author: Koen Verbeeck