Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric
Learn how updates and concurrency can work in Fabric with Delta Parquet data.
2024-10-02
1,376 reads
Articles
Casino night is back at PASS Summit 2024!
Back by popular demand, casino night from SQL Server Central will return to PASS Summit this year. Casino night will take place on November 5 after the welcome reception. Tickets will be allocated at random via a lottery.
2024-10-02
Microsoft Fabric and PySpark: Coding tricks to improve your solutions
PySpark has some unconventional syntaxes which provide power to the development process, making it easier.
2024-10-02
Converting Old Running Total Code to Window Functions
This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.
2024-09-30
2,627 reads
SQL Index Rebuild vs Reorganize Comparison
This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.
2024-09-30
Diving Deeper into the Import Extension in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built...
2024-09-27
996 reads
Bad Data and Dirty Databases
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under the title, “Don’t Warehouse Dirty Data!” It’s been referenced quite a few times over the decades but is nowhere to be found using Google these days. The point is, if you have written a report using data, you have no doubt felt the pain of dirty data and it is nothing new.
2024-09-27
The PASS Data Community Summit Session Schedule is LIVE!
Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase.
2024-09-27
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes
This article explores how raising the Cost Threshold for Parallelism (CTFP) affects missing index recommendations in SQL Server along with examples.
2024-09-25
GIT Configuration and Automated Release for Azure Data Factory
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
2024-09-23 (first published: 2023-10-16)
2,870 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers