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

Vote for your favorite MSSQLTips authors

Vote now and vote often for your favorite Rookie and Author of the Year! Voting ends January 31st.

Author: MSSQLTips

Database Monitoring and Management - Manage more, better and for less

As database environments grow more complex and DBA resources are scarcer, IT organizations face many challenges to properly support the demands of the business units. Multiple database platforms, tools and time-consuming troubleshooting only increases...

Author: Per Christopher Undheim

Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1

This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema.

Author: Andrea Gnemmi

Find Updated Columns in Update Transaction with New BitWise Operators in SQL Server 2022

Learn about the new bitwise operators in SQL Server 2022 along with a practical example of how to use these new operators.

Author: Jeffrey Yao

Create and Format a Bullet Chart in Power BI

In this article, we will go through the steps to create and format a bullet chart in Power BI.

Author: Harris Amjad

Steps to add a new disk to SQL Server failover cluster instance and move a user database to it

In this article, we look at the steps to add another disk to an existing Windows Failover Cluster used for SQL Server and also how to move an existing database to this new disk.

Author: Muhammad Kamran

Understanding Cloud Transformation Roles and Responsibilities

This article provides a clear overview of the key cloud roles and responsibilities involved in cloud platform transformation and administration. These roles include leadership, development, and support personas at both cloud and traditional levels that all play a role in advancing an organization's evolutionary and revolutionary goals.

Author: Ron L'Esteve

Transfer data from MySQL database to Microsoft SQL database

In this article, we look at how to migrate data from MySQL to SQL Server and how to keep the data between the two databases synchronized.

Author: Jan Potgieter

SQL Server Monitoring On-premises and Cloud for Management and DBAs

The use of SQL Server in the cloud continues to grow, but there is still the need to manage on-premises installations. Learn about one tool that can help you manage all of your SQL Server installations whether they are on-premises or in the cloud to help you be more productive and save money at the same time.

Author: Eric Blinn

Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory

Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.

Author: Temidayo Omoniyi

Evaluating SQL Server Filtered Indexes in a Multi Table SQL Join

In this tip, we look at filtered indexes and how to create them in SQL Server as well as how to get a filtered index to work when pulling data back from more than one table.

Author: Jared Westover

Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS

This article looks at several ways to handle the SSIS error: cannot convert between Unicode and non-Unicode string data types.

Author: Hadi Fadlallah

Query SQL Server Data Based on Various Date and Time Functions

This simple reference guide shows you various ways to query SQL Server data based on various date and time clauses.

Author: Joe Gavin

SQL Server Data Mining for Leveraged Versus Unleveraged ETFs as a Long-Term Investment

This article covers how to download data into a SQL Server database to do a comparison of whether leveraged versus unleveraged ETF are a better long-term investment.

Author: Rick Dobson

Encrypt SQL Server Stored Procedures to Protect Source Code

In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.

Author: Aubrey Love

Extend your Power BI Reports with Analysis Services 2022 Data

This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.

Author: Koen Verbeeck

ELT Data from SQL Server to MongoDB using SSIS

In this article, we look at different ways to transfer data from SQL Server to MongoDB when using SQL Server Integration Services.

Author: Hadi Fadlallah

Twitter API to Execute Queries and Analyze Data in SQL Server

Learn how to load Twitter data to a SQL Server database using Python code and the Twitter API to execute queries and analysis in SQL Server.

Author: Levi Masonde

Connect Power BI to Azure Data Lake Gen2 Storage for Reporting

Learn how to connect Azure Data Lake Gen2 storage to Power BI to develop reports and charts using files stored in Azure.

Author: Temidayo Omoniyi

How To Fix SQL Server Always On Availability Group Database Not Synchronized

In this article, we look at how to resolve the issue of an Always On Availability Group database not synchronizing and how to fix this issue.

Author: Vincent Jiang

SQL Server Function Examples with JSON Files

This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.

Author: Rick Dobson

SQL Server vs Oracle: Connect from Visual Studio 2019 ASP.NET Core Web Application

Learn how to use SQL Server or Oracle as the backend database for a simple .Net Core Web Application.

Author: Pablo Echeverria