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

Explore Pandas in Python to Analyze and Manipulate Tabular Data

Explore Pandas in Python to Analyze and Manipulate Tabular Data

Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.

Capture SQL Server Database Object Changes

Capture SQL Server Database Object Changes

Learn how to capture SQL Server database object changes and an easy way to compare the before and after of these database object changes.

PostgreSQL VACUUM, AUTOVACUUM, and ANALYZE Processes for Deleted Data

PostgreSQL VACUUM, AUTOVACUUM, and ANALYZE Processes for Deleted Data

PostgreSQL has a unique way of dealing with deletes and in this article, we look at the concepts of VACUUM, AUTOVACUUM, and ANALYZE.

Application Development

Getting Started with Kiota for Building API ClientsGetting Started with Kiota for Building API Clients

Learn how to build an API using Microsoft Kiota and how popular programming languages like Python can be used to write the API.

Application Development

Implement Microservices with Ocelot API-Gateway in .NETImplement Microservices with Ocelot API-Gateway in .NET

Learn how to build a microservice using the Ocelot API-Gateway in .NET in this step-by-step article.

Artificial Intelligence

Machine Learning Introduction: KNN ModelMachine 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.

TSQL

Optimize SQL LIKE Wildcard SearchesOptimize 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

SQL Server Agent Job History Retention SettingsSQL 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.

Azure Databricks

What is Databricks?What is Databricks?

Learn about the Databricks ecosystem: Dataframes, Spark SQL, SQL Warehouse, Streaming Data, Graph Query Language, and Machine Learning.

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.

Database Configurations

SQL Server Connection Strings using SqlClient, OLDEDB and ODBCSQL Server Connection Strings using SqlClient, OLDEDB and ODBC

In this article we look at different ways to define a connection string to connect to SQL Server using SqlClient, OLDEDB and ODBC connections.

Application Development

Develop a Simple Web Application in ASP.NET with SQL ServerDevelop a Simple Web Application in ASP.NET with SQL Server

In this tip, we will work through a simple ASP.NET solution to create web pages to work with a SQL Server database.

Functions System

SQL WAITFOR Command to Delay SQL Code ExecutionSQL WAITFOR Command to Delay SQL Code Execution

In this article, we look at the SQL Server WAITFOR command to allow delays in processing either for a specified time or a set amount of time.

Tutorial

Types of SQL Server BackupsTypes of SQL Server Backups

In this tutorial we look at the different types of backups that can be created for SQL Server.

Tutorial

SQL Server Management Studio Object ExplorerSQL Server Management Studio Object Explorer

In this part we look at how to open Object Explorer when using SSMS.

Tutorial

How To Launch a SQL Server Profiler SessionHow To Launch a SQL Server Profiler Session

In this section we look at how to lauch the SQL Server Profiler tool to begin capturing data.

Whitepaper

How to Build a SANless SQL Server Failover Cluster Instance in Google Cloud PlatformHow to Build a SANless SQL Server Failover Cluster Instance in Google Cloud Platform

Learn how to build a SQL Server Failover Cluster Instance (FCI) on the Google Cloud Platform (GCP).

Webcast

SQL Server Performance Benchmarking and Optimization on AWSSQL Server Performance Benchmarking and Optimization on AWS

Learn about SQL Server Performance Benchmarking and Optimization on AWS for a successful migration to the cloud.

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