SQL Server Tips, Articles and Training

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.

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.

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.

Popular Right Now

1 - Using MERGE in SQL Server to insert, update and delete at the same time

2 - Determining space used for all tables in a SQL Server database

3 - Understanding SQL Server fixed database roles

SQL Server Tutorials

Get Free SQL Tips

SQL Server Performance Tuning Checklist

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.

Python

Time Series Forecasting using Python Prophet

Learn how to use the Python library Prophet for time series forecasting to predict a target variable over a period.

Replication

SQL Replication Error - the row was not found at the Subscriber when applying the replicated UPDATE command

Learn how to fix replication error the row was not found at the Subscriber when applying the replicated UPDATE command for Table with Primary Key(s).

TSQL

SQL Quick Reference Guide

This guide outlines aspects of working with SQL along with several links to resources to help you better understand how to use the SQL language.

Full Text Search

How to Enable and Disable Full Text Search for SQL Server Databases

Learn how to enable or disable full text search for a specific database on a SQL Server instance where Full Text Search components have been setup.

Full Text Search

How to Enable and Disable Full Text Search for SQL Server Databases

Learn how to enable or disable full text search for a specific database on a SQL Server instance where Full Text Search components have been setup.

Power BI

Schedule, Export and Email Power BI Reports using Power Automate

Learn how to schedule, export and email specific parts of Power BI Reports using Power Automate.

Tutorial

SQL Server BACKUP DATABASE command

Learn about different options that can be used when creating a full database backup with several examples.

Tutorial

SQL DATEADD Function Use and Examples

In this section we will at different examples of how to use the SQL Server DATEADD function to add days or time to an existing date.

Tutorial

Windows Performance Monitor Tutorial

In this tutorial we will demonstrate how you can use the functionality that is available within Performance Monitor (PerfMon) to monitor your system.

Whitepaper

Secrets to Fast, Easy High Availability for SQL Server in Amazon Web Services

Learn how to quickly build a two-node HA cluster for SQL Server in the AWS cloud.

Webcast

Five ways to improve data security on Azure SQL Managed Instance

Join this webinar to learn what it means to secure data within a managed service like Azure SQL Managed Instance and the basics of securing your SQL d

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.