SQL Server Tips, Articles and Training

Troubleshoot SQL Server Always On Availability Groups with SQL LogScout

Learn about SQL LogScout which is a log analysis tool to help troubleshoot SQL Server errors by using the available log files on the system.

Read Data Stored in a Lake Database using Azure Synapse Analytics

In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs.

SQL Server Agent Jobs, Automation and Email Notification

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

Popular Right Now

1 - Granting View Definition Permission to a User or Role in SQL Server

2 - Build a Secure SQL Server REST API in Minutes

3 - Identify SQL Server TCP IP port being used

Calculating Costs for Microsoft SQL Server

Learn Power BI Today

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

Cloud Strategy

Serverless Microservice Computing Concepts and Architecture

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

Python

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.

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.

Functions System

Multiple Ways to Concatenate Values Together in SQL Server

In this article we look at how to concatenate SQL Server data using various methods using concatenation operator, functions CONCAT and CONCAT_WS.

Functions System

Format numbers in SQL Server

In this article we cover different ways to format numbers in SQL Server using various functions like CAST, CONVERT, ROUND, CEILING, FLOOR and FORMAT.

Functions System

SQL WAITFOR Command to Delay SQL Code Execution

In this article, we look at the SQL Server WAITFOR command to allow delays in processing either for a specified time or a set amount of time.

Tutorial

Eliminating bookmark (key/rid) lookups

Lookups occur when not all of the data is pulled at the same time. We look at when this occurs and how you can improve performance.

Tutorial

INFORMATION_SCHEMA.COLUMNS

The INFORMATION_SCHEMA.COLUMNS view allows you to get information about all columns for all tables and views within a database.

Tutorial

SQL CHARINDEX Function Use and Examples

Learn how to use the SQL Server CHARINDEX function along with several examples of how this might be used.

Whitepaper

Calculating Costs for Microsoft SQL Server

This white paper looks at how costs can be controlled with a sufficient understanding of the Microsoft SQL Server licensing process.

Webcast

Evolution of Data Analytics - What You Should Know

Learn about the evolution of the data platform architecture from data warehouses to data lakes to data lakehouses to unlock insights quicker.

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.