Articles - SQLServerCentral

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 (

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...

The post Vibe coding and databases: the hidden risks of AI-generated database code appeared first on SQLServerCentral<...

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...

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...