SQL Server Tips, Articles and Training

Express a Number or Currency in Words with T-SQL Code

This SQL script allows you to take a number and convert the number to words, and convert a currency value into words.

Normalization in SQL to Reduce Data Redundancy

Learn about the various levels of normalization in SQL for a data model with these explanations and examples.

Best Practices for Docker to run SQL Server on a Mac

Check out this consolidated list of things you can (or should) do when using Docker to run SQL Server on a Mac.

Popular Right Now

1 - SQL RAISERROR to Better Handle Errors

2 - Export Data from SSMS to Excel

3 - What MAXDOP setting should be used for SQL Server

SQL Server Tutorials

Learn Power BI Today

Get Free SQL Tips

PostgreSQL

Migrate a SQL Server Database to a PostgreSQL Database

Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.

Application Development

Advanced Features of DAB (Data API Builder) to Build a REST API

Get guidance on the advanced features of DAB (Data API Builder) and how to set up a production-ready environment.

TSQL

Create Document Templates in a SQL Server Database Table

Learn how to create document templates in a database table and use SQL to replace specific keywords in the templates for content customization.

Azure

Getting Started with Azure CLI to Manage Azure Resources

Learn about Azure CLI and how to manage your Azure resources using commands instead of using the Azure portal.

Microsoft Fabric

Microsoft Fabric Warehouse - Configure Access and Permissions

In this step-by-step article, learn how to configure access and permissions to a Microsoft Fabric warehouse.

DevOps

Automating SQL Deployments using GitHub Actions - Part 2

This article demonstrates more complex scenarios and best practices for automating SQL deployments using GitHub Actions on an Azure SQL database.

Query Store

Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes

Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.

Microsoft Fabric

Configure Microsoft Fabric Database Mirroring for Snowflake

In this tip, we explore how to configure mirroring for a Snowflake database to be available in Microsoft Fabric.

Indexing

Add Indexes to Improve SQL DELETE Performance

This article examines whether creating indexes can help when deleting data from a SQL Server table.

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.

Power Apps

Schedule Automated Emails using Outlook and Power Automate

Learn how to automate the sending and scheduling of emails using Power Automate.

TSQL

SQL WHERE IS NOT NULL for SELECT, INSERT, UPDATE and DELETE

Learn how to use IS NOT NULL for a WHERE clause in SQL along with examples of how this can be used for SELECT, INSERT, UPDATE, and UPDATE.

Tutorial

SQL Server Heap

In this section we discuss what a table is called that does not have a clustered index.

Tutorial

SQL STRING_ESCAPE Function Use and Examples

Learn how to use the SQL Server STRING_ESCAPE function to allow special characters to be included in a string such as a line feed or carriage return.

Tutorial

Create a New SSIS Package

In this section we will walk through creating a new SSIS package and adding it to an existing project.

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

Validating and Enriching SQL Server data with Unison

Data has a great value when it is clean, however many datasets are plagued with invalid, inaccurate, and duplicate records. With Unison by Melissa, ta

Webcast

Exploring the Benefits of Single Server Protection High Availability in Windows Environments

Attend this webinar and learn about Single Server Protection High Availability (SSP-HA).