T-SQL Tuesday #127–Non SQL Tricks
Today is T-SQL Tuesday, with this month being hosted by Ken Fisher. This is an interesting topic, looking at tips, but ones outside of SQL Server. Since many of...
2020-06-09
121 reads
Tips and Tricks Azure Databricks
It has been a while since I posted an entry for TSQL Tuesday, which, for today is hosted by Kenneth . The subject being a non SQL Server tip. For...
2020-06-09
227 reads
T-SQL Tuesday #127 - Non-SQL Tips & Tricks
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Kenneth Fisher (blog | twitter) asks us for non-SQL tips &...
2020-06-09
29 reads
TSQL Tuesday 127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
19 reads
TSQL Tuesday #127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
20 reads
Social: A Small Step to Address Poor Past Behavior
Tl;Dr – This is about changing your main branch in git to main. However, please read and think about what I am saying here. When I started working with...
2020-06-08
56 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
18 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
297 reads
Data On Wheels – Merging Two Great Minds
I am very excited to announce that my daughter, Kristyna Hughes, will be joining the Data On Wheels team. Our fates and paths to this point seem parallel though...
2020-06-08
142 reads
Power BI FAQ
Power BI has become hugely popular and I find common questions about functionality and features, so I thought I would put in this blog some of those questions with...
2020-06-23 (first published: 2020-06-08)
628 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