SQL Server Tips, Articles and Training

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

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

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

Popular Right Now

1 - SQL Server Bulk Insert for Multiple CSV Files from a Single Folder

2 - Reading and Writing data in Azure Data Lake Storage Gen 2 with Azure Databricks

3 - Capturing SQL Server Deadlocks using Extended Events

SQL Server Performance Tuning Checklist

Calculating Costs for Microsoft SQL Server

Learn Power BI Today

Data Warehousing

Data 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 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 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 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 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 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 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 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 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 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 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 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?

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 Examples

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

Tutorial

Using 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 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 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 DBA

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