Always on AG Dashboard report
This script can be used to generate Dashboard report for Always-on AG databases. Script can be placed in SQL Agent to generate report.
2020-05-22 (first published: 2020-05-12)
3,169 reads
T-SQL
Delete Data from SQL Server Table in Batches
In this tip we cover a T-SQL script that allows you to batch delete older data from tables and save the deleted records to an archive table.
2020-03-31
Tagging SQL Server Changes in SQL Monitor
How to use RAISERROR() in T-SQL to send annotations to SQL Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics.
2020-03-30
Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,878 reads
Introduction to STRING_SPLIT function in SQL
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
10,596 reads
Mean Median Mode using SQL and DAX
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
2020-02-28
34,483 reads
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
89,091 reads
Handling Aggregations on a Poorly Designed Database
When the database design is not great, you may have to write some creative queries to get what you need.
2020-02-17
3,465 reads
Calculate Moving Averages using T-SQL in SQL Server
Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]
2020-02-04
23,161 reads
Prevent SQL Server Blocking using Lock_Timeout
In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.
2020-01-24
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
What Is The Most Important Element Of A Great User Experience?
Hello everyone, I have been exploring different website designs and digital products recently, and...
BCA KCU SOEKARNO HATTA | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227...
BCA KCU PASURUAN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111 @BCA...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers