T-SQL Tuesday #137–Notebook Uses
It’s actually my month to host T-SQL Tuesday, and I came up with the notebook idea last year. Aaron Nelson (b | t) sent me a link to a...
2021-04-13
59 reads
Daily Coping 13 Apr 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-13
44 reads
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives us the ability to run full blown linux distributions on our Windows 10 desktop. This...
2021-04-15 (first published: 2021-04-13)
320 reads
Everyone Run a SQL Saturday in 2021
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events. I am reaching out to some people that have run events in the past, but...
2021-04-16 (first published: 2021-04-12)
252 reads
Modern Data Warehouse & Reverse ETL
An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...
2021-04-12
35 reads
Modern Data Warehouse & Reverse ETL
An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...
2021-04-14 (first published: 2021-04-12)
867 reads
Daily Coping 12 Apr 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-12
26 reads
Setting up Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In my prevous post we looked at what TDE is and how it...
2021-04-12
289 reads
Snowflake in Azure
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that is Azure SQL Database or Azure Database for MySQL for your relational database, it does not matter...
2021-04-12
30 reads
Regression Testing SQL Saturday Naming
I started a poll today on the naming for future SQL Saturdays. You can answer here: https://twitter.com/way0utwest/status/1380524526455390209 The current votes (51 votes) look like this: That’s interesting, as I...
2021-04-09
31 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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