How to get IO statistics of SQL Server database files
This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
2022-11-18
9,930 reads
T-SQL
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,736 reads
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
9,501 reads
Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
4,180 reads
Manage Your Business Rules in T-SQL Query
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)
11,223 reads
Different ways to Convert a SQL INT Value into a String Value
In this article we cover different ways to convert a SQL Server numeric value into a string value.
2022-07-08
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,673 reads
Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data
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
SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
6,989 reads
Quantifier predicates
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
Blogs
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers