SQL Server Tips, Articles and Training

SQL Quick Reference Guide

This guide outlines aspects of working with SQL along with several links to resources to help you better understand how to use the SQL language.

Rank and Sort Data Based on Multiple Columns in Power BI with DAX

This article describes two approaches to allow you to rank and sort data based on multiple columns in Power BI.

Power BI Calculations without Complex DAX using Power Query Editor

Learn how to use the standard calculation options in the Power Query Editor of Power BI without having to write complex DAX calculations.

Popular Right Now

1 - Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI

2 - Bulk Insert Data into SQL Server

3 - Build a Secure SQL Server REST API in Minutes

Disaster Recovery in the Cloud: Understanding Challenges and Strategies for SQL Server

SQL Server Performance Tuning Checklist

Get Free SQL Tips

Artificial Intelligence

Google Gemini - Generative AI Tool for SQL Professionals

This article looks at using Google's artificial intelligence tool Gemini to build and explain T-SQL code.

Professional Development Certifications

AZ-500 Microsoft Azure Security Exam Study Guide

Check out this article for lots of study links and resources to help you pass the Microsoft exam AZ-500 Microsoft Azure Security Technologies.

Python

Python Variables and Data Types

Learn about different data types using Python along with how to create and use variables in Python.

Microsoft Fabric

Automatic Table Maintenance in Microsoft Fabric Warehouse - Checkpointing and Statistics - Part 2

Learn about table maintenance in the Fabric Warehouse such as Checkpointing and Statistics and what you should know about these maintenance tasks.

TSQL

Replace a SQL WHILE Loop with Set Based Logic in T-SQL

This article shows ways to replace a SQL WHILE loop with set-based logic to improve SQL Server performance when dealing with a lot of data.

Dynamic Management Views and Functions

Data Management Views (DMVs) Comparison for SQL Server 2019 and Azure SQL Database

In this article, we look at Data Management Views (DMVs) differences between a SQL Server 2019 instance and Azure SQL Database.

Deprecated Features

How to Manage SQL Server Deprecated Features

Learn about deprecated features in SQL Server, if it is bad to use them, and what you should do if you are using them.

Azure Data Factory

Gaining Insights from Azure Data Factory Per Pipeline Billing Details

In this article, learn how to configure per pipeline billing in Azure Data Factory to view and analyze per-pipeline costs.

Indexing

SQL Server Filtered Index Essentials Guide

Learn about using filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index.

Reporting Services Development

SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports

Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.

TSQL

Advanced report examples in SQL Server using PIVOT and GROUPING SETS

In this article we look at how to pivot SQL Server data and also rollup and calculate group values by using PIVOT and GROUPING SETS.

Functions System

Learn how to convert data with SQL CAST and SQL CONVERT

Learn how to convert SQL Server data to different data types such as string, date, integer and numeric using the CAST and CONVERT functions.

Tutorial

SQL Server Prepared Statement

Learn about prepared database statements and the potential impact on database performance.

Tutorial

Precise Alphabetic Filtering With Regular Expressions for T-SQL

In this tutorial we look at more complex expressions to find specific text patters using regex with T-SQL.

Tutorial

MySQL to SQL Server Data Migration

In this chapter we will discuss how to migrate your data from MySQL to SQL Server.

Whitepaper

Calculating Costs for Microsoft SQL Server

This white paper looks at how costs can be controlled with a sufficient understanding of the Microsoft SQL Server licensing process.

Webcast

Applying DevOps for Data and AI Innovation

In this webinar we cover DevOps which is a delivery method to bring development and operations teams together to deliver software and technology updat

Webcast

SQL Server Maintenance Tasks You Probably Aren't Doing

This webinar will cover a series of SQL Server maintenance items that are much less popular, but still important and should be a part your DBA tasks.