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. 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

Managing Azure Databricks with the Azure Cloud Shell Command Line Interface

Managing Azure Databricks with the Azure Cloud Shell Command Line Interface

Learn how the Databricks Command Line Interface (CLI) allows you to perform a variety of tasks from the command line versus the Azure Portal.

Rounding Numbers to the Nearest Integer with T-SQL

Rounding Numbers to the Nearest Integer with T-SQL

In this article, we look at how to use T-SQL to round to the nearest integer using round, ceiling, floor, and the banker's rounding rule.

Parameter Sniffing Issue with Temporary Tables in SQL Server 2022

Parameter Sniffing Issue with Temporary Tables in SQL Server 2022

We look at how parameter sniffing can still be an issue in SQL Server 2022 when using temporary tables and one way to resolve the issue.

Amazon AWS

SQL Athena Introduction - How it works, Use Cases and AdvantagesSQL Athena Introduction - How it works, Use Cases and Advantages

Learn about Amazon Athena, how it works, why you would use it, and some of the advantages of Athena over traditional relational databases.

Microsoft Fabric

Microsoft Fabric PersonasMicrosoft Fabric Personas

Learn about personas when working with Microsoft Fabric to help filter the options and features that best meet your needs.

Google Cloud

Configuring a Virtual Private Cloud (VPC) for Google Cloud Platform (GCP)Configuring a Virtual Private Cloud (VPC) for Google Cloud Platform (GCP)

Learn how to use the Google Cloud Platform to share a VPC for multiple projects and how we can connect to GCP from on-premises.

Security

SQL Server Static Data Masking with DataVeilSQL Server Static Data Masking with DataVeil

Learn how to use production-like data for testing and development, but mask sensitive data quickly and efficiently with DataVeil.

Artificial Intelligence

Large Language Models (LLMs) to train artificial intelligence (AI) tools such as ChatGPTLarge Language Models (LLMs) to train artificial intelligence (AI) tools such as ChatGPT

Learn about Large Language Models (LLMs) and how they are used to train artificial intelligence (AI) tools such as ChatGPT.

Backup

SQL Server Database Snapshots for Rapid RestoresSQL Server Database Snapshots for Rapid Restores

In this article, we look at using SQL Server database snapshots to quickly revert a database to a prior state to streamline testing and development.

Indexing

Query Performance Degraded after Rebuilding Clustered Columnstore IndexQuery Performance Degraded after Rebuilding Clustered Columnstore Index

In this article, we look at why SQL Server performance degraded after rebuilding a Clustered Columnstore Index and how to resolve it.

Encryption

Easy and Cost Effective way to Encrypt Every SQL Server DatabaseEasy and Cost Effective way to Encrypt Every SQL Server Database

Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.

Power BI Charts

Build Clustered Column Chart and Clustered Bar Chart in Power BI DesktopBuild Clustered Column Chart and Clustered Bar Chart in Power BI Desktop

Learn how to create clustered column charts and clustered bar charts in Power BI along with why you would choose one over the other.

Security

List SQL Server Login and User Permissions with fn_my_permissionsList SQL Server Login and User Permissions with fn_my_permissions

In this article we look at how to list SQL Server permissions for a login or a user using the system function fn_my_permissions.

TSQL

SQL NOT IN OperatorSQL NOT IN Operator

This article covers the SQL NOT IN operator and explains the functionality and use cases with several NOT IN examples.

TSQL

Learn the SQL WHILE LOOP with Sample CodeLearn the SQL WHILE LOOP with Sample Code

In this article we will look at examples of a SQL Server WHILE loop in T-SQL and discuss alternatives like a CTE and cursor.

Tutorial

Download, Install and Update SQL Server Management Studio Download, Install and Update SQL Server Management Studio

In this part we look at how to download, install and update SQL Server Management Studio.

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

SQL Server Trigger After UpdateSQL Server Trigger After Update

In this section we learn how to create a trigger for when data is updated along with an example of how to use the inserted and deleted pseudo tables.

Tutorial

SQL Server Trigger After UpdateSQL Server Trigger After Update

In this section we learn how to create a trigger for when data is updated along with an example of how to use the inserted and deleted pseudo tables.

Whitepaper

Controlling Cloud Costs without Sacrificing Availability or PerformanceControlling Cloud Costs without Sacrificing Availability or Performance

The objective of this white paper is to help prevent cloud services sticker shock from occurring.

Webcast

Easily Encrypt SQL Server Databases and Backups - All Versions and EditionsEasily Encrypt SQL Server Databases and Backups - All Versions and Editions

SQL Server database encryption should be a best practice, but it can seem daunting to implement. You might be faced with the prospect of upgrading you