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

SQL Server Management Studio 20 New Features and Functionality

SQL Server Management Studio 20 New Features and Functionality

Learn about some of the new features and functionality of SQL Server Management Studio 20.

SQL Server TRY CATCH, RAISERROR and THROW for Error Handling

SQL Server TRY CATCH, RAISERROR and THROW for Error Handling

Learn about SQL Server error handling using TRY CATCH, RAISERROR, and THROW for stored procedures, triggers, and user-defined functions.

PostgreSQL CREATE TABLE Examples

PostgreSQL CREATE TABLE Examples

Learn about PostgreSQL CREATE TABLE command to create tables and temporary tables along with various options and syntaxes for creating tables.

SQL Server Management Studio Shortcuts

Review SQL Table Attributes in SQL Server Management StudioReview SQL Table Attributes in SQL Server Management Studio

In this tip, we look at ways to quickly get table attributes such as columns, data types, indexes, constraints, and more when using SSMS.

DevOps

GitHub Options to Prevent Saving Passwords in Application CodeGitHub Options to Prevent Saving Passwords in Application Code

In this article, we look at various GitHub options to help prevent saving sensitive data like passwords in application code files.

Power BI

Getting Started with Microsoft Power BI TrainingGetting Started with Microsoft Power BI Training

Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.

Power BI Charts

Power BI Treemap Chart Step-by-Step TutorialPower BI Treemap Chart Step-by-Step Tutorial

Learn how to use and format the treemap visual in Power BI in this step-by-step tutorial.

Power BI

How to Sort String Date Values on a Power BI Slicer VisualHow to Sort String Date Values on a Power BI Slicer Visual

In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.

Artificial Intelligence

Large Language Models with Azure AI Search and Python for OpenAI RAGLarge Language Models with Azure AI Search and Python for OpenAI RAG

Infuse Azure SQL data with retrieval augment generation (RAG) for large language models (LLMs) such as GPT to provide answers to complex questions.

Availability Groups

Analyzing Unplanned Availability Group Outages and Failovers using AGDiagAnalyzing Unplanned Availability Group Outages and Failovers using AGDiag

Learn how to use the AGDiag tool to troubleshoot and analyze SQL Server Always On Availability Group issues.

Microsoft Fabric

Microsoft Fabric Monitoring with Metrics App and Data ActivatorMicrosoft Fabric Monitoring with Metrics App and Data Activator

Learn about Metrics App and Data Activator for monitoring and taking necessary administrative action to control Microsoft Fabric capacity.

Import and Export

SQL Bulk Insert Command ExamplesSQL Bulk Insert Command Examples

Learn about the SQL Server BULK INSERT command and how to use it to import text data in a SQL Server database table.

TSQL

Query SQL Server Data Based on Various Date and Time FunctionsQuery 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.

Stored Procedures

SQL Server RETURN and OUTPUT Clause in Stored ProceduresSQL Server RETURN and OUTPUT Clause in Stored Procedures

In this article we look how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.

TSQL

SQL CASE Statement in Where Clause to Filter Based on a Condition or ExpressionSQL CASE Statement in Where Clause to Filter Based on a Condition or Expression

Learn about different ways you can use a CASE statement in the WHERE clause for a T-SQL statement with these several examples.

Tutorial

SQL UNICODE Function Use and ExamplesSQL UNICODE Function Use and Examples

Learn how to use the SQL Server UNICODE function to return the unicode value for a particular character.

Tutorial

SQL Server Spatial IndexesSQL Server Spatial Indexes

In this section we look at another type of SQL Server index, spatial indexes.

Tutorial

SQL Server Analysis Services 2016 (SSAS) TutorialSQL Server Analysis Services 2016 (SSAS) Tutorial

In this tutorial we will explore how to get started working with SQL Server Analysis Services 2016 (SSAS).

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

Amp Up Your SQL Server databases on AWSAmp Up Your SQL Server databases on AWS

Don't miss this informative webinar to learn about a simpler, faster, and cheaper solution for SQL Server backups in AWS.

Webcast

Modernize in place with SQL Server 2022 and AMD  Modernize in place with SQL Server 2022 and AMD

Learn about the latest SQL Server 2022 and on-premises innovation. This includes tips and tricks to take advantage of your upgrade while staying compa