Connect with your SQL Community on Slack
Slack is a popular tool for team interaction. To describe it quickly, it's a feature-rich persistent chat room, with threads,...
2025-09-25 (first published: 2017-05-04)
613 reads
Will Assaf
Easily query your GitHub Contribution activity
For a variety of reasons, including your Microsoft MVP activity reports, you might want to summarize your GitHub activity across multiple repos. For contributors to Microsoft open-source docs on GitHub,...
2025-06-20 (first published: 2025-06-05)
304 reads
Migrate datetime data to datetimeoffset with AT TIME ZONE
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft Learn Docs article at the recommendation of my colleague Randolph West, who guessed (accurately) I...
2024-05-22 (first published: 2024-05-03)
419 reads
Tips, ideas, and recommendations on your technical blog
This technical blog is hardly the ideal, but I'll use this space here to summarize some of the guidance that my colleague Randolph West and I presented at a...
2023-11-13 (first published: 2023-10-27)
392 reads
Updated training list for a new DBA
Met an eager young volunteer at SQLSatBR over the weekend who inspired me to update a blog post that hadn't been refreshed in a few years. See the [UPDATED] Training...
2023-08-18 (first published: 2023-07-31)
623 reads
SQLSat Baton Rouge 2023!
Looking forward to #jambalaya at #SQLSatBR on July 29! Register today: sqlsatbr.comI hope to see as many people as possible that weekend, I'll be there at the Friday night...
2023-07-22 (first published: 2023-07-21)
42 reads
SQL Server 2022 Administration Inside Out
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This book is far more than a quick update. We've rewritten and refreshed large portions of...
2023-03-25 (first published: 2023-03-24)
138 reads
30 Interview Questions for a Database Administrator and Developer
This blog post summarizes the type of technical questions I would ask candidates for a Microsoft SQL Server data platform administrator and database developer role.Hopefully this helps both candidates...
2023-03-08 (first published: 2023-02-28)
1,343 reads
Q&A on certification exams, exam prep, and test-taking skills
Part 2 of 2. This blog post is co-authored by Ajayi Anwansedo, PhD and William Assaf, who met and worked together at The Futures Fund, a STEM non-profit which offers introductory coding and...
2023-02-03 (first published: 2023-01-23)
298 reads
Exam Cram with DataWeekender talk - Think Like a Certification Exam
Fresh off of a two-part, co-authored blog series on certification exams and test-taking prep, I've got a fresh batch of fun sample questions for the January 2023 Data Weekender Exam...
2023-01-24
30 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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