Please turn JavaScript on

Articles - SQLServerCentral

Get updates from Articles - SQLServerCentral via email, on your phone or read them on follow.it on your own custom news page.

You can filter the news from Articles - SQLServerCentral that get delivered to you using tags or topics or you can opt for all of them. Unsubscription is also very simple.

See the latest news from Articles - SQLServerCentral below.

Site title: SQLServerCentral – The #1 SQL Server community

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.81 / day

Message History

Data build tool (dbt) is an open-source command line tool that helps engineers transform data using SQL scripts.  However, there are limitations to what can be done with the Structure Query Language (


Read full story
Introduction

SQL Server 2025 introduces a new way to compare strings. In the past, it was necessary to integrate T-SQL with Python or use CLR to apply fuzzy matching. Now, SQL Server 2025 includes a feature that helps us find similar words. This feature is smarter at finding information to check the data quality. Also, it detects inconsistencies and human errors in the d...


Read full story

I upgraded our primary OLTP box to SQL Server 2022 about eight months ago, mostly for the Query Store plan-forcing improvements. The T-SQL additions were supposed to be a side dish. They turned out to be the reason half my team is finally happy with their code reviews. Below are the five 2022-era functions I actually reach for every week, what they replaced in our codebase, a...


Read full story

Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses.  It already assumes that data is extracted and loaded into raw tables.  The dbt core framework is written in Python...


Read full story