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.

Get Free SQL Tips

MSSQLTips.com solves real world problems and improves the careers of SQL Server DBAs, Developers, Business Intelligence Pros and Cloud Pros with free tips, tutorials, web casts, videos and more. Join Today!

Author: The MSSQLTips.com Team

Efficient monitoring and management of SQL Server farms

SQL Server DBAs are being asked to monitor and manage a constantly growing number of instances. Properly addressing these needs from a technical, business and user perspective is time consuming and stressful while leaving many issues unnoticed until...

Author: Per Christopher Undheim

SQL Server Index Maintenance Checklist

In this article we look at things to consider when working with indexes in SQL Server to make sure you get the biggest benefit when using indexes.

Author: Greg Robidoux

SQL Server PIVOT and UNPIVOT Examples

In this article learn how to use PIVOT and UNPIVOT in SQL Server to transform your data output along with examples.

Author: Daniel Calbimonte

Build Distributed Availability Groups to migrate SQL Server databases to a different AD Domain - Part 2

In this article we continue building Distributed Availability Groups to migrate SQL Server databases to a different Active Directory domain.

Author: Edwin Sarmiento

Coding ETL Tools in the Microsoft Data Platform - Part 2

In this article we will look at code intensive solutions for ETL activity when working with the Microsoft data platform such as T-SQL, Azure Functions and Azure Data Bricks.

Author: Koen Verbeeck

My Favorite T-SQL Enhancements in SQL Server 2022

A few of the most useful changes in SQL Server 2022 so far are GREATEST, LEAST, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES and I will cover each one and show practical use cases.

Author: Aaron Bertrand

Compute and Display Candlestick Charts in SQL Server and Python

This tip extends prior coverage of candlestick charts by taking advantage of financial time series data stored in SQL Server and charted via Python.

Author: Rick Dobson

PowerShell for the DBA - CMDLETs and Advanced Functions

In this article we learn about the basics of PowerShell cmdlets, what they are, how to use them and what is available specifically for SQL Server.

Author: Alejandro Cobar

Snowflake for Microsoft SQL Server Developers - Transactions - Part 1

In this article we explore how to use transactions and a comparison of transactions in SQL Server versus Snowflake.

Author: Sergey Gigoyan

Comparing SQL Server Full Text Search and Oracle Text Search

In this article we look at SQL Server Full Text Search and Oracle Text Search to compare the similarities and differences of how they work.

Author: Pablo Echeverria

Synapse Analytics vs Snowflake for Delta Format Files, Machine Learning, Table Relationships and Constraints

When evaluating Synapse Analytics and Snowflake for your Lakehouse Platform you may be interested in knowing how Synapse and Snowflake handle Delta Format Files, Machine Learning workloads, table relationships, constraints and more.

Author: Ron L'Esteve

Implementing Fact-to-Dimension Mapping on Lakehouse using Synapse Mapping Data Flow

In this article we cover a common fact processing task which is fact-to-dimension mapping and how this can be done with Azure Synapse Analytics.

Author: Fikrat Azizov

Getting Started with Query History and Table Designer in Azure Data Studio

In this article we look at how to add the query history extension to Azure Data Studio as well as how to build tables using the table designer.

Author: Rajendra Gupta

How to Write a SQL SELECT Statement

In this article we look at how to use the SQL SELECT statement to query data from a SQL Server table along with several different examples.

Author: Jim Evans

Configuring Distributed Availability Groups Between Failover Clusters on Different Active Directory Domains Part 1

In this article we look at how to use Distributed Availability Groups to migrate SQL Server databases to a different Active Directory domain.

Author: Edwin Sarmiento

SQL Database Overview

Learn about what a SQL database is, what is stored in a database and how to interact with a database.

Author: Daniel Calbimonte

Recover Script from Recently Closed Tab in SSMS You Forgot to Save

Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.

Author: Joe Gavin

Steps for Upgrading Always On SQL Servers and Skipping Versions

In this article we look at a checklist you can follow to upgrade an Always On SQL Server environment from one version of SQL Server to a later version.

Author: Jim Evans

SQL Server CLR Table Valued Function

Learn how to create table valued functions (TVF) using common runtime language (CLR) in SQL Server along with a couple of simple examples to get you started.

Author: Daniel Farina

How to Avoid Making Remote Desktop Connections to SQL Server

In this article we learn how to avoid having to make remote desktop connections to SQL Server and still be able to install, patch, read error logs and manage SQL Server.

Author: Eric Blinn

Power BI Desktop - What is it and how do I use it?

Learn about Power BI Desktop the stalwart development tool used for the bulk of report and dashboard design work in Power BI.

Author: Scott Murray