There’s a new version of SQL Server released and we’re mainly an on-premises SQL Server shop. We’ve been using Integration Services (SSIS) for years now for all our ETL and data integration needs. With Microsoft’s focus on cloud (Azure and Fabric), does it make sense to upgrade our SSIS packages? Are there any new features?
2026-03-27
In this next installment, we look at using dbt to seed a Fabric Warehouse.
2026-03-25
3,206 reads
There’s not much to database keys, right? When you build a new table, you add a column to act as the primary key, then set it to auto-generate. Done. That’s all there is to know…right?
2026-03-25
Introduction SQL Server 2025 introduced new features, including vectors. The main purpose of vectors is to create a new semantic search with the help of AI. Modern AI models represent text as vectors (embeddings) that capture semantic meaning. Similar meanings produce vectors that are close to each other in this vector space, allowing AI systems to […]
2026-03-23
8,914 reads
Parallelism can reduce concurrency. This is a strong reason not to allow SQL Server to execute queries aggressively in parallel mode. In this tip, I will set up a demo to show that parallelism reduces query performance on a server with high concurrency.
2026-03-23
Learn how you can add transactional replication to an AG to move data to an Azure SQL Database.
2026-03-20
2,415 reads
Every few years, someone asks a familiar question: do we really still need to disable the sa account in SQL Server? After all, it’s 2026. SQL Server has better encryption, better auditing, better defaults, and more security features than ever before. Surely this old guidance belongs in the past?
2026-03-20
Answering a couple of questions from the previous posts about dropping columns.
2026-03-18
1,998 reads
SQL Server Management Studio keeps adding features, but unless you look you probably don’t notice. In this article, we look at the new Query Hint Recommendation Tool in SSMS 2022 and how this can be used.
2026-03-18
You know you shouldn't have production data in test environments. But every time you look at fixing it, the options feel impossible: enterprise tools that cost six figures and take months to implement, or DIY scripts that sort of work until they don't. Join this webinar on Mar 18 to learn more.
2026-03-18 (first published: 2026-03-09)
You kick off a distributed job expecting it to finish in minutes — but...
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Comments posted to this topic are about the item Representing Money
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Which types of currency does the money data type represent?
See possible answers