SQL Server Tips, Articles and Training

SELECT TOP 10 SQL Examples

In this article, we look at various ways to use SQL SELECT TOP to return a certain number or percentage of rows when selecting data.

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.

Popular Right Now

1 - Update Statistics for All Tables and Databases in a SQL Server Instance

2 - Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI

3 - Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error

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

SQL Server Tutorials

Calculating Costs for Microsoft SQL Server

Microsoft Fabric

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.

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.

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.

SQL Server 2019

SQL Server 2019 Express Step by Step Download, Install and Configure

Learn how to download, install and configure SQL Server 2019 Express Edition in this step-by-step article.

SQL Server Management Studio Configuration

SQL Server Management Studio Dark Mode

Learn how to configure SQL Server Management Studio to use dark mode in this step by step article.

Tutorial

SQL Server Extended Events Tutorial

In this section of the tutorial we cover a brief overview of Extended Events in SQL Server along with the topics we will cover in this tutorial.

Tutorial

How to create a SQL Server backup

Learn about different ways to create a database backup.

Tutorial

Using try catch in SQL Server stored procedures

Error handling is a key part of stored procedure development and this section covers how to build error handling logic.

Whitepaper

How to Build a SANless SQL Server Failover Cluster Instance in Google Cloud Platform

Learn how to build a SQL Server Failover Cluster Instance (FCI) on the Google Cloud Platform (GCP).

Webcast

Understanding the Availability Chain and its Impact on SQL Server

Learn about the chain of availability and how to determine your risk of downtime and failure for each link in your critical business applications.

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.