SQL Server Tips, Articles and Training

SQL Replication Error - the row was not found at the Subscriber when applying the replicated UPDATE command

Learn how to fix replication error the row was not found at the Subscriber when applying the replicated UPDATE command for Table with Primary Key(s).

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.

Popular Right Now

1 - List SQL Server Login and User Permissions with fn_my_permissions

2 - SQL Server Derived Table Example

3 - List SQL Server Login and User Permissions with fn_my_permissions

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

Learn Power BI Today

Get Free SQL Tips

TSQL

SQL FROM Query Examples and Syntax

Learn about the SQL FROM clause to create tables, alter tables, views, aliases, join tables, subqueries, and DELETE FROM in queries.

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.

TSQL

Build Conditional SQL Server Logic - SQL IF, BEGIN, END, ELSE, ELSEIF

Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.

Application Development

SQL Server Connection String Examples with PowerShell

In this article we look at different parameters and options that can be used with connection strings to connect to a SQL Server instance and database.

Error Handling

SQL RAISERROR to Better Handle Errors

Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution.

Tutorial

SQL Statistical Window Functions PERCENTILE_DISC and PERCENTILE_CONT

In this part of the tutorial we look at using PERCENTILE_DISC, PERCENTILE_CONT, CUME_DIST and PERCENT_RANK functions.

Tutorial

SQL Server Integration Services SSIS Control Flow Example

In this section, we will give an overview of the objects you can add to the control flow when working with SSIS.

Tutorial

Perfmon Counters for CPU Usage, Memory, Disk and Network Performance

In this part of the tutorial we look at some common Windows OS counters to use to collect data.

Whitepaper

Understanding Disaster Recovery Options for SQL Server

This white paper provides some practical guidance to help system and database administrators tasked with creating business continuity and disaster rec

Webcast

Tuning Problematic SQL Server Queries with Minimal Changes

A common problem with tuning problematic SQL Server queries is the inability to make immediate code changes to fix performance problems when productio

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.