SQL Server Tips, Articles and Training

Performance Impact of SQL Server Check Constraints

This article explores check constraints in SQL Server and the impact they have or don't have on performance.

Microsoft Fabric Announcements at Microsoft Ignite 2023

Learn about the general availability announcement of Microsoft Fabric including pricing, and mirroring.

Send an Alert when a SQL Server Database Configuration Changes

Capture when a SQL Server database change is made, who made the change, and when it was made with DDL Triggers.

Popular Right Now

1 - What MAXDOP setting should be used for SQL Server

2 - Find MAX value from multiple columns in a SQL Server table

3 - Resolving could not open a connection to SQL Server errors

SQL Server Data Quality in 2023

SQL Server Tutorials

Calculating Costs for Microsoft SQL Server

Azure Data Factory

How to make the most of Azure Data Factory?

Learn how Azure Data Factory provides a cloud-based data integration service that orchestrates and automates data movement and transformation.

TSQL

SQL GROUP BY Alias - An Oracle feature that would be great in SQL Server

Learn about using an alias in the GROUP BY clause for complex SQL Server code instead of having to rewrite the code in the GROUP BY.

SQL Server Agent

Monitor for Hung SQL Server Agent Jobs

Learn how to set up an automated process to alert you about long-running SQL Server Agent jobs and the ability to stop the job if needed.

Power BI

Getting Started with Microsoft Power BI Training

Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.

Artificial Intelligence

OpenAI API Introduction

In this article, we start diving into the OpenAI API and how to set up a development environment, create an OpenAI account, and generate an API key.

Amazon AWS

Limit Data Scanning and Excess Query Plans in Amazon Athena

Learn how to manage and control the amount of data used for Amazon Athena queries to limit excessive query runs.

Power BI Charts

Area Chart in Power BI to Understand Data Changes Over Time

Learn how to create an area chart in Power BI to understand the intensity of a change and cumulative total values over time.

Microsoft Fabric

What are Kusto Query Language (KQL) databases in Microsoft Fabric?

Learn how to get started with the KQL database service in Microsoft Fabric to perform time-series analysis on large data sets.

Performance Tuning

Solving Date Range SQL Server Query Performance Issues with OPTION RECOMPILE

Learn how to get the SQL Server optimizer to use different indexes for a query depending on parameters to improve performance.

Power BI

Calculate Working Days in Power BI

Learn how to calculate real working days between two dates for a Power BI report by excluding weekends and holidays with these handy functions.

TSQL

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.

TSQL

SQL Server NOT Equal Operators

Learn about writing TSQL statements using the not equal operator along with various examples of using not equals.

Tutorial

Who Uses SQL Server Management Studio and Why

In this section we look at the various uses of SSMS and the different types of SQL professionals that might use SSMS.

Tutorial

Precise Alphabetic Filtering With Regular Expressions for T-SQL

In this tutorial we look at more complex expressions to find specific text patters using regex with T-SQL.

Tutorial

Excluding Characters With Regular Expressions with T-SQL

In this section we look at how to exclude data using the NOT symbol for regex.

Tutorial

Excluding Characters With Regular Expressions with T-SQL

In this section we look at how to exclude data using the NOT symbol for regex.

Whitepaper

Calculating Costs for Microsoft SQL Server

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

Webcast

Monitoring SQL Server - What, When, and How?

SQL Server DBAs have a lot of things to worry about - backups, performance, storage, etc. Learn how to collect, gather and visualize the trends.