How to Persuade Your Company to Change
Like a lot of developers and database administrators, I do a fair amount of short-term problem solving during the course of my normal work week. I get to join...
2019-07-19
24 reads
Power BI Monthly Digest – July 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI
2019-07-19
39 reads
One Way to Find Broken Code on Your Server
Before we approached our last major SQL Server upgrade, I was curious about what might break. Yes, I had used the DEA to check our code against deprecated or...
2019-07-19
57 reads
Azure SQL Database SLA Updates
I am sure many missed the updates to Azure SQL Database SLA (Service Level Agreement). It used to be 99.99% across all tiers but split between two different high-availability...
2019-07-19
216 reads
ASF 024 video invitation
I’m happy to announce that the next episode of “Ask SQL Family” podcast is coming. This time our guest is an amazing woman, not only in AI and Power...
2019-07-19
13 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
112 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
15 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
160 reads
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-07-17
17 reads
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-08-09 (first published: 2019-07-17)
290 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