SQL Server Tips, Articles and Training

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros - all for free. The content we serve is all human written and based on our authors' real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.


Today's Resources

Machine Learning Introduction: KNN Model

Machine Learning Introduction: KNN Model

This tip will introduce and implement the K-Nearest Neighbors model in Python to give you a better understanding of how machine learning works.

Optimize SQL LIKE Wildcard Searches

Optimize SQL LIKE Wildcard Searches

Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.

SQL Server Agent Job History Retention Settings

SQL Server Agent Job History Retention Settings

This article looks at how to change SQL Server Agent history retention using SQL Server Management Studio GUI and T-SQL scripts.

Recent Tips

Artificial Intelligence

AI Chatbot with Message History using LangChain and SQLAI Chatbot with Message History using LangChain and SQL

In this tutorial, you will learn how to create a message history and a UI for a LangChain chatbot application.

TSQL

Combine Multiple Columns Performance Comparison - SQL UNPIVOT, UNION ALL vs CROSS APPLYCombine Multiple Columns Performance Comparison - SQL UNPIVOT, UNION ALL vs CROSS APPLY

Learn how to combine multiple columns from an SQL Server table into one column using three different methods to see the most efficient approach.

Database Administration

SQL Server Metadata for Stored Procedures, User-Defined Functions and ViewsSQL Server Metadata for Stored Procedures, User-Defined Functions and Views

Learn how to use SQL Server metadata to better manage SQL code for things like stored procedures, user-defined functions, views, and more.

Power BI

Power BI in One HourPower BI in One Hour

In this article, learn how to build a Power BI report from start to finish with a real-life example using COVID-related data.

Cloud Strategy

Predictive Analysis and Descriptive Analysis with Azure Stream Analytics, Machine Learning and Power BIPredictive Analysis and Descriptive Analysis with Azure Stream Analytics, Machine Learning and Power BI

In this article, we look at how to build an Azure streaming data collection and analysis process to analyze and predict stock prices.

Microsoft Fabric

Query Microsoft Fabric GraphQL API from an External AppQuery Microsoft Fabric GraphQL API from an External App

This tip covers executing a Microsoft Fabric query using GraphQL API from an external application and how this can be used for data sharing.

Reporting Services Security

SQL Server Reporting Services SecuritySQL Server Reporting Services Security

This article examines SQL Server Reporting Services security and what you should know from the Configuration, Web Service, Folder, and Report Level.

Professional Development Interviewing

What Job Seekers Should Know about AI and Virtual RecruitersWhat Job Seekers Should Know about AI and Virtual Recruiters

Learn some tips and tricks when working with AI/virtual recruiters during the recruitment process and things you should know.

Power BI

Power BI Quick Reference GuidePower BI Quick Reference Guide

Check out this structured reference guide to just about anything you want to know about Power BI and Power BI report development.

Python

Introduction to Creating Interactive Data Visualizations with Python matplotlib in VS CodeIntroduction to Creating Interactive Data Visualizations with Python matplotlib in VS Code

In this tip, we present a step-by-step guide on how to present your data interactively using matplotlib and Python in VS Code.

Tools

Getting Started with SQL Server Developer EditionGetting Started with SQL Server Developer Edition

In this article we take a look at the SQL Server Developer Edition and what it is, how it can be used and where it can be used.

TSQL

Find Mismatched Data between SQL Server Tables using LEFT JOIN, EXCEPT, NOT IN and NOT EXISTSFind Mismatched Data between SQL Server Tables using LEFT JOIN, EXCEPT, NOT IN and NOT EXISTS

In this tip we look at various ways to find mismatched SQL Server data between two tables using LEFT JOIN, EXCEPT, NOT IN and NOT EXISTS.

Tutorial

SQL Server RESTORE FILELISTONLYSQL Server RESTORE FILELISTONLY

The RESTORE FILELISTONLY option allows you to see a list of the files that were backed up inside the backup file.

Tutorial

Creating a DimensionCreating a Dimension

There are two types of dimensions database dimension and cube dimension and we will cover this in this section.

Tutorial

Avoid Using Not Equal in WHERE ClauseAvoid Using Not Equal in WHERE Clause

In almost all cases when we use the <> operator index seeks will not be performed and instead a table or index scan is required.

Whitepaper

Why Clustering for SQL Server High AvailabilityWhy Clustering for SQL Server High Availability

This white paper covers the basics of high availability for SQL Server- what it is, what it is not and how to leverage clustering to achieve your requ

Webcast

Availability Options for SQL Server in AWSAvailability Options for SQL Server in AWS

Learn about availability options on AWS, ways to optimize cloud storage and cost, and choosing the right options for SQL Server.

Webcast

Easily Create Non-Sensitive Copies of Production DatabasesEasily Create Non-Sensitive Copies of Production Databases

Learn how to obfuscate sensitive data and personally identifiable information (PII), all while ensuring the data remains useful for testing and analys