SQL Server Tips, Articles and Training

SQL Server Agent Jobs, Automation and Email Notification

Learn how to set up, create jobs, and send email notifications using SQL Server Agent.

How to Visualize Time Series Data using Microsoft Excel

In this article, we look at how to visualize time-series data using Excel with a walkthrough of how this is done with a sample dataset.

Serverless Microservice Computing Concepts and Architecture

Learn about the concept of serverless microservices and how this architecture could be used to support your applications.

Popular Right Now

1 - SMTP Test from PowerShell

2 - Power BI Conditional Formatting for Matrix and Table Visuals

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

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

Calculating Costs for Microsoft SQL Server

Learn Power BI Today

Replication

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).

TSQL

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.

Power BI

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

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.

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.

Install and Uninstall

How to install SQL Server 2022 step by step

In this article, we cover how to install SQL Server 2022.

Functions System

SQL Server PIVOT and UNPIVOT Examples

In this article learn how to use PIVOT and UNPIVOT in SQL Server to transform your data output along with examples.

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 MSDB Database Location

In this part of the tutorial we look at things to know about the MSDB database like the location of the files, moving the MSDB database files and the

Tutorial

SQL Server Filegroup Backups

Learn about filegroup backups for a database. This covers what a filegroup backup is and when and how to create.

Tutorial

SQL Server Extended Events vs Profiler vs Trace

In this section we look at why you should be using Extended Events instead of running a SQL Trace or using Profiler.

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

Development Best Practices for SQL Server

Learn about development best practices for SQL Server in this webinar.

Webcast

Microsoft Fabric: What it is and why you would use it

Learn about Microsoft Fabric and whether this platform is the right choice for your data environment.