SQL Server Tips, Articles and Training

Data Quality Management Issues in Time Series Analysis Resolved with Python

In this tutorial, we delve into critical aspects of data quality management when working with time-series data and we will use Python to demonstrate.

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.

Popular Right Now

1 - SQL Server Trigger Example

2 - Query SQL Server Agent Jobs, Job Steps, History and Schedule System Tables

3 - SQL Server Windows Authentication with Users and Groups

Get Free SQL Tips

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

Calculating Costs for Microsoft SQL Server

Python

Python String Function Examples - Concatenate, Split, Replace, Upper, Lower

Learn how to manipulate strings in Python with these string functions: concatenate, split, replace, upper, lower, and more.

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.

SQL Server Management Studio

Export Data from SSMS to Excel

Learn various ways to quickly export data from a SQL Server Management Studio query window into an Excel file.

Power BI

Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX

Learn how to use DAX logic in Power BI to enable calculating values for previous year's weeks compared to that of the current year.

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

Introduction to Numeric Regular Expressions for T-SQL

In this tutorial we look at how to write regex to find numbers using T-SQL.

Tutorial

Schedule Data Collection with Windows Performance Monitor

In this section we look at how to schedule automatic data collection of perfmon counters.

Tutorial

INSERT INTO new SQL table with SELECT INTO

This section shows how to create a new table by using SELECT INTO.

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

A Beginners Guide to Query Store

Come join us to level up on your SQL Server 2022 knowledge by understanding how Query Store can help make your environment better!

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.