Every SQL Server developer has heard it: "Don't use NOLOCK in production!" But this common rule isn't as simple as it seems. Sometimes, what seems like a bad practice can actually be the right choice. Let's explain what NOLOCK really does in simple terms. When you use NOLOCK, you're telling SQL Server "just show me […]
2024-12-09
5,079 reads
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re wondering what you’re missing, and whether you should be on SQL Server Enterprise Edition. Here are 3 warning signs to watch out for.
2024-12-09
2024-12-06
1,513 reads
Learn how to use Fivetran HVR software to ETL data into your One Lake Storage from a PostgreSQL database.
2024-12-06 (first published: 2024-11-27)
1,617 reads
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
2024-12-06
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (Data Manipulation Language) uses those declarations to change their contents or to invoke them. It does not change structures and schema objects.
2024-12-04
As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.
2024-12-02
3,645 reads
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
2024-12-02
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
2024-11-29 (first published: 2014-04-07)
50,979 reads
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series.
2024-11-29
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
By Steve Jones
This is kind of a funny page to look at. The next page has...
A while ago I blogged about a use case where a pipeline fails during...
I have a table I didn't design that has tons of repeating groups in...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers