Flyway Tips: Multiple Projects
One of the nice things about Flyway Desktop is that it helps you manage your database code as a project and see what changes are being built. However, many...
2026-03-16 (first published: 2026-03-04)
174 reads
What DevOps Look Like in Microsoft Fabric
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps) is an integrated data and analytics platform designed for modern data-driven workloads, such as data...
2026-03-16 (first published: 2026-03-04)
336 reads
T-SQL Tuesday #192: What career risks have you taken?
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may not know the history, T-SQL Tuesday started back in December 2009 when Adam Machanic (Blog |LinkedIn)...
2026-03-03
24 reads
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI, Today on Day 3 I would like to write about LLM models — Open Source...
2026-03-13 (first published: 2026-03-03)
362 reads
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure Data Factory instance (or Azure Synapse Pipelines) and you have a couple of linked services...
2026-03-11 (first published: 2026-03-03)
438 reads
Deployment Pipelines in Fabric – What Are They?
In the realm of software development and content creation, the deployment pipeline serves as a crucial bridge between innovation and implementation. Whether you are fine-tuning code, testing new features,...
2026-03-11 (first published: 2026-03-03)
392 reads
Ad Hoc SQL Server Help
I just need a few hours of your time… We get a variation of this request a LOT. So now it’s time to do something about it! Ad Hoc...
2026-03-02
37 reads
TempDB Internals – What’s New (SQL Server 2016 to 2022)
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-02
9 reads
TempDB Internals – What’s New (SQL Server 2016 to 2022)
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-09 (first published: 2026-03-02)
508 reads
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
continuing from Day 1 where we covered the history of AI and GPT family, today on Day 2 i would like to discuss what came next after Generative AI...
2026-03-02
26 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers