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,397 reads
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
7,397 reads
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
3,609 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,806 reads
In this article we cover different ways to convert a SQL Server numeric value into a string value.
2022-07-08
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,258 reads
In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.
2022-03-07
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
5,629 reads
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
5,235 reads
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
2021-12-31
If you're a data analyst, you already know that SQL isn't just a nice-to-have...
By Steve Jones
Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar...
By Steve Jones
insoucism – n. the inability to decide how much sympathy your situation really deserves,...
Comments posted to this topic are about the item The Costs and Rewards of...
Comments posted to this topic are about the item Manage Elastic jobs in Azure...
Comments posted to this topic are about the item Takeaways from Data Grillen 2024
When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?
See possible answers