Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
7,306 reads
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
7,306 reads
Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses. And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]
2022-10-18 (first published: 2022-09-02)
10,790 reads
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
556 reads
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
4,307 reads
Markdown documents are becoming increasingly more popular and relevant with the emergence of notebooks. Markdown is a markup language for creating formatted text. It is widely used in tools for collaboration, tools for creating documentation and notebooks. Formatting is easy to understand, readable, simple to adopt, and agnostic. I can use a markdown document on […]
2021-11-29
9,246 reads
Article shows how R Services can help database administrators with their daily work
2019-02-22 (first published: 2017-02-07)
2,970 reads
Using R with Power BI, SSRS or RTVS for easier data visualization
2019-02-15 (first published: 2017-01-24)
4,319 reads
Using R integration for analyzing sales data in WideWorldImporters database
2019-02-08 (first published: 2017-01-17)
4,766 reads
This article shows four ways you can use when installing missing R packages for Microsoft R Services.
2019-02-01 (first published: 2016-09-29)
5,632 reads
General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.
2019-01-25 (first published: 2016-09-15)
8,498 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
Hello Everybody, I have a database on which I try to empty a file...
My knowledge of Extended Events is limited, but I am trying to capture some...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers