SQL Server Tips, Articles and Training

SQL Server Temporary Stored Procedures

Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.

Microsoft Fabric Lakehouse Table Maintenance Options for High Performance - Part 1

In this tip, we'll discuss the various maintenance options for ensuring performance doesn't degrade for lakehouse tables when using Microsoft Fabric.

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.

Popular Right Now

1 - REPLACE versus TRANSLATE for SQL Server Text Data Manipulation

2 - DROP TABLE IF EXISTS Examples for SQL Server

3 - Adding Users to Azure SQL Databases

SQL Server Performance Tuning Checklist

SQL Server Tutorials

Calculating Costs for Microsoft SQL Server

SQL Server Agent

SQL Server Agent Jobs, Automation and Email Notification

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

Microsoft Excel Integration

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.

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.

Integration Services Development

Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS

This article looks at several ways to handle the SSIS error: cannot convert between Unicode and non-Unicode string data types.

Power BI Charts

Power BI Dynamic X and Y Axis Using Groupings in Field Parameters

Learn how to dynamically select what should be on the X or Y axis of a Power BI chart in this step-by-step article.

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.

Tutorial

Purpose of Triggers in SQL Server

This section covers why triggers are useful and why you would want to use a trigger versus some other process.

Tutorial

SQL CONCAT Function Use and Examples

The CONCAT function in SQL Server helps you concatenate multiple strings, dates and numbers into a combined string.

Tutorial

SQL Server Management Studio Overview (SSMS)

This gives an overview of what SQL Server Management Studio is and what it is used for.

Whitepaper

SQL Server Performance Tuning Checklist

This SQL Server checklist will serve as a starting point to help determine what steps might make sense as part of a performance improvement effort.

Webcast

Amp Up Your SQL Server databases on AWS

Don't miss this informative webinar to learn about a simpler, faster, and cheaper solution for SQL Server backups in AWS.

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.