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



Simplified Multi-Platform Database Management

Databases are the components that utilize the most resources in the data center. Unfortunately, there are not enough database professionals to always proactively manage the workload and issues often go unnoticed until there are serious problems.

Author: Per Christopher Undheim



Performance Improvement with Multiple Database Files for SQL Server and Oracle

In this tip, we will run several tests using different numbers of data files for SQL Server and Oracle databases to see if more files improves the performance.

Author: Pablo Echeverria



How to find Nth Highest Record using DENSE_RANK SQL Server Function

In this article, we look at how to find nth record in a SQL Server table by using the dense_rank SQL Server function along with several examples.

Author: Harris Amjad



Rethinking SQL Explicit Transactions

This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables.

Author: Jared Westover



How to Add a Column to a SQL Server Table

In this article, learn how to add a new column to an existing SQL Server table using the SSMS GUI or by using T-SQL to add the column.

Author: Manvendra Singh



How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop

Learn how to build scatter plots in Power BI and use the clustering option to automatically find clusters within the report data for easy visualization.

Author: Harris Amjad



How to Comparatively Assess Buy-Sell Models with SQL Server

This article presents a framework for comparing buy-sell models for securities using data stored in SQL Server and compares models via the compound annual growth rate metric.

Author: Rick Dobson



Managing Hung Jobs in SQL Server Agent Job and Oracle Job Scheduler

In this article, we look at how to automatically handle scheduled jobs that hang in both SQL Server and Oracle.

Author: Pablo Echeverria



Steps to Quickly Configure an AWS RDS SQL Server instance

Learn how to configure and deploy a new Amazon AWS RDS SQL Server instance with this step-by-step article.

Author: Rajendra Gupta



Create a SQL Alias using SQL Server Synonyms to access to Tables, Views, User-Defined Functions, Stored Procedures

In this article, we look at how to create and use synonyms in SQL Server to access other database objects.

Author: Aubrey Love



Getting Started with Cloud Databases

This article covers some basic information about moving your databases to the cloud and things to know.

Author: Daniel Calbimonte



SQL Server Agent Jobs Schedules - Review, Cleanup, and Special Cases

This article covers various scripts you can use to help manage and troubleshoot SQL Server Agent job scheduling.

Author: Svetlana Golovko



Saving changes is not permitted in SQL Server Management Studio error

When working in SQL Server Management Studio (SSMS) I got the error message "saving changes is not permitted" when I tried to change a table. Learn how to solve this problem.

Author: Atif Shehzad



SQL Variables for Queries and Stored Procedures in SQL Server, Oracle and PostgreSQL

Learn about the differences in SQL Server, Oracle and PostgreSQL on how to use variables for ad hoc queries and stored procedures.

Author: Andrea Gnemmi



Getting Started with SqlQueryStress for SQL Server Load Testing

Learn how to install and use SqlQueryStress to help with tune your SQL Server databases, stored procedures, indexes, and more.

Author: Jared Westover



Change SQL Server Table Structures with SQL ALTER TABLE

In this article, we look at how to make changes to SQL Server table structures using T-SQL commands to add, delete and change columns in a table.

Author: John Miner



Resolving could not open a connection to SQL Server errors

Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.

Author: Jugal Shah



How to Create a Bar Chart with SQL Code

In this article, we look at how to build a simple bar chart using SQL code along with a couple examples of how you can do this with your data.

Author: Aubrey Love



Create, Read, Update and Delete Data in SQL Server Tables

Learn the basics to create, read, update and delete data in SQL Server tables with these various examples.

Author: Jan Potgieter



Azure Cloud Data Orchestration, Ingestion and Data Preparation

In this article, we look at things to consider when selecting tools and developing your data processing strategy when working with various technologies in the Azure cloud.

Author: Maria Zakourdaev



How To Retrieve the Last Non-NULL Value in SQL Server

In this article, we show different ways of using SQL to get the last non-NULL value from a set of records so the result set always includes a valid value.

Author: Koen Verbeeck