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

Convert Excel Workbooks to CSV with Microsoft Fabric

Convert Excel Workbooks to CSV with Microsoft Fabric

Learn how to convert a list of Excel files to CSV and move them to a separate folder with a Data Factory pipeline in Fabric's Data Lake.

Microservice Application with Azure Container Apps, Dapr and Bicep

Microservice Application with Azure Container Apps, Dapr and Bicep

Learn how to create a microservice application with Azure container apps and Dapr using Bicep to develop infrastructure code and deploy templates.

Aggregate Functions in Power BI including Running Total, Running Average and Max

Aggregate Functions in Power BI including Running Total, Running Average and Max

This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.

Data Warehousing

Data Warehouse Considerations - SCD Type 2 vs Overwrite Dimension TablesData Warehouse Considerations - SCD Type 2 vs Overwrite Dimension Tables

How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.

TSQL

Calculate a Moving Average with T-SQL Windowing FunctionsCalculate a Moving Average with T-SQL Windowing Functions

Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.

Microsoft Fabric

Execute Stored Procedures in the Microsoft GraphQL APIExecute Stored Procedures in the Microsoft GraphQL API

This tip explores leveraging existing SQL Server stored procedures within the Microsoft GraphQL API.

Cloud Strategy

Build a Streaming Data Architecture with Apache Kafka and ZookeeperBuild a Streaming Data Architecture with Apache Kafka and Zookeeper

In this article, we look at how to use Apache Kafka and Zookeeper to process and load streaming data.

Microsoft Fabric

CRUD Operations in Microsoft Fabric using GraphQL API MutationsCRUD Operations in Microsoft Fabric using GraphQL API Mutations

In this tip, we dive into advanced features of the GraphQL API in Fabric and cover how to use mutations to create, update, or delete data in Fabric.

Professional Development Career Planning

Preparing a New DBA to Take Over a SQL Server EnvironmentPreparing a New DBA to Take Over a SQL Server Environment

When handing over your duties as a DBA to someone else, here are several things that can be done to make the transition more successful.

Power BI

Power BI to Visualize and Profile Data for Data QualityPower BI to Visualize and Profile Data for Data Quality

In this article, we look at how to use Power BI to help visualize and profile data in a database for data quality monitoring.

Reporting Services Development

Display SSRS Report in .NET Core ApplicationDisplay SSRS Report in .NET Core Application

Learn how to display a report from SSRS in a .Net Core Application with a practical example.

Azure

Azure Database for MySQL Flexible Server Administrative TasksAzure Database for MySQL Flexible Server Administrative Tasks

This tip explores the administrative tasks and operational items required for a MySQL flexible server running on Azure.

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.

TSQL

Advanced testing with WAITFOR in SQL Server client toolsAdvanced testing with WAITFOR in SQL Server client tools

Learn about the WAITFOR command in SQL Server to delay processing for a period of time and how this could be used for testing.

TSQL

Many Uses of SQL CASE Expression in a JOIN ClauseMany Uses of SQL CASE Expression in a JOIN Clause

In this article, we look at the many uses of the SQL CASE expression and whether you should ever use CASE in a JOIN.

Tutorial

What is a nested transaction?What is a nested transaction?

Learn about nested transactions and how these can be used to rollback multiple changes if there are issues with the processing.

Tutorial

SQL STUFF Function Use and ExamplesSQL STUFF Function Use and Examples

Learn how to use the SQL Server STUFF function along with several examples.

Tutorial

Using Regular Expressions to Find Special Characters with T-SQLUsing Regular Expressions to Find Special Characters with T-SQL

In this tutorial we look at how we can find special characters using regex with T-SQL.

Whitepaper

SQL Server Performance Tuning ChecklistSQL Server Performance Tuning Checklist

This SQL Server checklist will serve as a starting point to help determine what steps might make sense as part of a performance improvement effort.

Webcast

Accelerate SQL Server Application Migrations to AWS using Migration Hub OrchestratorAccelerate SQL Server Application Migrations to AWS using Migration Hub Orchestrator

Migration Hub Orchestrator (MHO) to accelerate your cloud migration to Amazon RDS / EC2 using backup and restore or rehosting Windows .NET application

Webcast

Things I Wish I Knew as a DBAThings I Wish I Knew as a DBA

Join this webinar to learn SQL Server DBA best practices to avoid making mistakes and learn from my lessons.