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 - SQL Server script to rebuild all indexes for all tables and all databases

2 - Upgrade and Migrate SSIS Catalog and SSISDB to a New Server

3 - SQL Server LIKE Syntax with Wildcard Characters

Learn Power BI Today

SQL Server Performance Tuning Checklist

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.

SQL Server Management Studio

Learn about SQL SSMS Ports for SQL Server

Learn about network ports used for SQL Server and how to find and use the correct port to connect to SQL Server using SSMS or any application.

Tutorial

SQL Server Recovery Models

In this section we look at the different recovery models for databases and how this impacts the types of database backups.

Tutorial

Simple way to export data from SQL Server

This section covers how to quickly export data from SQL Server using the SSIS export wizard.

Tutorial

SQL DATEPART Function Use and Examples

Learn how to use the SQL Server DATENAME function to return an integer value for a specific part of a date such as day, hour, month, etc.

Whitepaper

How to Build a SANless SQL Server Failover Cluster Instance in Google Cloud Platform

Learn how to build a SQL Server Failover Cluster Instance (FCI) on the Google Cloud Platform (GCP).

Webcast

The flexibility of hybrid options with Azure SQL Managed Instance

Learn how Azure SQL Managed Instance can support your hybrid approach. You will learn how to leverage the link feature for Azure SQL Managed Instance

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.