A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
2020-08-31
7,286 reads
This tip looks at using artificial intelligence models with SQL Server to predict outcomes.
2020-08-21
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,961 reads
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,838 reads
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
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
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,736 reads
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
9,946 reads
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
2020-02-28
32,409 reads
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
82,834 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers