SQL Server Tips, Articles and Training

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.

Time Series Forecasting using Python Prophet

Learn how to use the Python library Prophet for time series forecasting to predict a target variable over a period.

Popular Right Now

1 - SQL Date Format Options with SQL CONVERT Function

2 - Calculate Working Days in Power BI

3 - SQL Server Connection String Examples with PowerShell

Learn Power BI Today

Get Free SQL Tips

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

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.

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.

TSQL

REPLACE versus TRANSLATE for SQL Server Text Data Manipulation

Learn to replace text in SQL Server strings using the REPLACE function and the TRANSLATE function and how these could be used for data manipulation.

TSQL

Understanding SQL Ranking Functions ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE()

Learn about the different ranking functions in SQL Server along with how to use each of these: ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE().

Triggers

An Introduction to SQL Triggers

Learn about SQL Server triggers and how to use them for inserts, updates, and deletes on a table, along with step-by-step examples.

Tutorial

SQL Server 2017 and Python Basics

In this tutorial overview, we look at how Python can be used within SQL Server and the items that will be covered.

Tutorial

Insert inital seed data into the table in SSDT

Learn how to insert an initial set of data in a table that is part of the SSDT SQL Project.

Tutorial

My First SQL Server Business Intelligence Project Tutorial

This tutorial provides an overview for your first SQL Server BI Project. It will teach you how to get the right type and amount of data for accurate a

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

Learn How to Simplify SQL Server Migrations to AWS

Join this webinar to learn how to use AWS Migration Hub Orchestrator to simplify and accelerate SQL Server migration to Amazon EC2 and Amazon RDS.

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.