SQL Server Tips, Articles and Training

Mastering SQL Server Local and Global Temporary Tables

In this article, we walk through the syntax for SQL Server local and global temporary tables and also use cases for when and how to use them.

Azure Synapse Analytics and Power BI Integration

In this article, learn how to integrate Power BI reports with data from Azure Synapse Analytics in this step-by-step tutorial.

Microsoft Fabric Lakehouse OPTIMIZE and VACUUM to Cleanup Parquet Files

In this article, we will explain how the OPTIMIZE and VACUUM commands can assist in maintaining the tables in the Microsoft Fabric Lakehouse.

Popular Right Now

1 - Setting Up Alerts for All SQL Server Agent Jobs

2 - SQL Server script to rebuild all indexes for all tables and all databases

3 - Crosstab queries using PIVOT in SQL Server

SQL Server Tutorials

Calculating Costs for Microsoft SQL Server

Get Free SQL Tips

Professional Development Certifications

AZ 104 Exam Preparation for Microsoft Azure Administrators

Get ready for and pass the Microsoft Azure Administrators AZ-104 Exam with this study guide with lots of useful resources.

DevOps

How to use GitHub Actions to Deploy Database Changes After a Commit

In this article, we look at how to use GitHub Actions to deploy database changes after a commit to the Main branch in a GitHub repository.

Stored Procedures

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

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.

Availability Groups

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.

Azure Synapse Analytics

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

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.

Application Development

Develop a Simple Web Application in ASP.NET with SQL Server

In this tip, we will work through a simple ASP.NET solution to create web pages to work with a SQL Server database.

Power BI

DAX CASE Statement Functionality with IF, SWITCH and SWITCH True

DAX does not have a CASE statement, so we look at other options that have similar functionality such as IF(), SWITCH(), and SWITCH(TRUE()).

Encryption

Always Encrypted: Enhancements in SQL Server

Learn how to use Always Encrypted to encrypt SQL Server data along with some of the changes that have been made since its first release in 2016.

Tutorial

SQL Server Triggers DELETED Table

In this section we learn about the pseudo table DELETED that can be used with triggers when an UPDATE or DELETE occurs so you can see the prior values

Tutorial

Introduction to SQL Server Profiler

In this tutorial we look at what the SQL Server Profiler tool is and how this can be used to track down issues.

Tutorial

Working With Pre and Post Deployment Scripts

This section covers scripts that can be part of the database project deployment that get run pre or post depolyment in a database project in Visual St

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

Best Practices for Cloud-Based Modern .NET Apps and SQL Server

A new set of best practices have emerged to accommodate this new generation of applications. In this interactive session, you will learn some techniqu

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.