SSIS Variable and Parameter Analysis
Use T-SQL to analyse the usage of all variables and parameters in an SSIS project, including the identification of any unused variables and parameters.
2020-06-23
6,334 reads
T-SQL
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)
2,558 reads
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,631 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
9,734 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
30,635 reads
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
76,486 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,428 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
21,112 reads
Blogs
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
T-SQL Tuesday #174: Job Interview Questions
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Forums
getting logged in user name to the pc that running the report
hi all, is there anyway in SQL to getting logged in user name to...
What is the monkey type?
Monkey type is a free online typing practice website that offers a variety of...
SQL JOB add/modified
Is there a trigger to notify when a new SQL Agent job is created/modified?
Question of the Day
Full Text Editions
In which editions can I use Full-Text and semantic search?
See possible answers