Auto-suggesting foreign keys and data model archaeology
If you can understand the data model then you can understand the intent of the application developers.
Who Likes NULL?
The use of NULL values in a database can be controversial. Today Steve talks about his views on this concept.
How to Fix sp_BlitzIndex Aggressive Indexes Warnings
Either you've got too many indexes, or not enough. Here's how to tell.
Creating Compound Interest Calculations in SQL
This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills
Using Parameters for SQL Server Queries and Stored Procedures
One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.
Missing Data
Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.
Importing Tricky CSV Files with PowerShell
A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Lokasari TLP/WA 08216977701
Komp. Lokasari Plaza, Jl. Raya Mangga Besar No.81 Blok B 45, Tangki, Kec. Taman...
Bank BCA TLP/WA 08216977701
Jl. Daan Mogot No.48C 6, RT.6/RW.3, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
BCA KCU CIKARANG CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu,...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers