SQL Server Tips, Articles and Training

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.

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.

Popular Right Now

1 - SQL Server DBCC CHECKDB Overview

2 - Steps to Drop an Orphan SQL Server User when it owns a Schema or Role

3 - SQL Server Move Database Files Step By Step

SQL Server Tutorials

Learn Power BI Today

SQL Server Performance Tuning Checklist

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.

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.

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.

Power BI

Combine Text Strings in Power BI Using DAX

Learn various ways to concatenate strings in Power BI such as using CONCATENATE, COMBINEVALUES and using an ampersand.

Full Text Search

How to Enable and Disable Full Text Search for SQL Server Databases

Learn how to enable or disable full text search for a specific database on a SQL Server instance where Full Text Search components have been setup.

Tutorial

SQL Server Management Studio Object Explorer

In this part we look at how to open Object Explorer when using SSMS.

Tutorial

SQL Server Partial Backups

Learn about partial backups, what they are and how to create a partial database backup in SQL Server.

Tutorial

SQL Server Release Dates and Lifecycle

This section give an overview of how Microsoft supports each version when new versions are released.

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

Empowering Education: Enhancing System Availability with SIOS Solutions

Learn about the roles of High Availability and Disaster Recovery for uninterrupted learning experiences in education-related systems.

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.