SQL Server Tips, Articles and Training

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.

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.

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.

Popular Right Now

1 - SQL Date Format examples using SQL FORMAT Function

2 - How to Grant Permissions to run SQL Server Profiler for a non System Admin User

3 - Using Group Managed Service Accounts with SQL Server

Learn Power BI Today

Calculating Costs for Microsoft SQL Server

SQL Server Tutorials

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.

Azure Data Factory

Managing Failed Pipeline Runs in Azure Data Factory

In this article, we look at how to setup different ways to handle pipeline failures and notifications when working with Azure and Azure Data Factory.

Apache Spark

Learning Spark SQL String Functions with Explanations and Code Examples

Learn how to use different Spark SQL string functions to manipulate string data with explanations and code examples.

Python

Using SQLAlchemy to work with Databases vs SQL Server Management Studio

Learn about SQLAlchemy to work with databases and database objects versus using SQL Server Management Studio (SSMS) or other native SQL tools.

Power BI

Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX

Learn how to use DAX logic in Power BI to enable calculating values for previous year's weeks compared to that of the current year.

Tools

Getting Started with SQL Server Developer Edition

In this article we take a look at the SQL Server Developer Edition and what it is, how it can be used and where it can be used.

Power BI

Concatenate Strings in Power BI Using Power Query M Language

In this article we look at how to concatenate data in Power BI with examples of combining text, numbers, dates and more.

Tutorial

MySQL to SQL Server Data Migration

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

Tutorial

Generate INSERT statement in Management Studio

Learn how to auto generate an INSERT statement by using the features in SQL Server Management Studio.

Tutorial

DML Triggers in SQL Server

Learn how to create DML or Data Manipulation Language triggers. These occur after data has been changed either via an INSERT, UPDATE or DELETE operati

Whitepaper

Secrets to Fast, Easy High Availability for SQL Server in Amazon Web Services

Learn how to quickly build a two-node HA cluster for SQL Server in the AWS cloud.

Webcast

Monitor the performance of Azure SQL Database, Amazon RDS for SQL Server, and SQL Server

Attend this webinar to learn how to manage the performance of SQL Server not only on-premises using a single tool.

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.