Daily Coping 22 Jun 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-06-22
26 reads
Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz ... Continue reading
2021-06-22
137 reads
Suggested Topics in Power Virtual Agents
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a guided, no-code graphical interface. In this video you will learn how
2021-07-07 (first published: 2021-06-22)
155 reads
Abuse, Patience, and Understanding
I’ve been struggling with an author for a few months. I tried to work throughs some issues, and I couldn’t get anywhere. This was very frustrating, and I spoke...
2021-06-21
205 reads
Daily Coping 21 Jun 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-06-21
48 reads
SSIS Logging – Linking sysssislog with custom log
I was working on an ETL solution, which was expected to run for hours. It has become extremely important to track the errors properly, so as to debug the...
2021-07-05 (first published: 2021-06-21)
482 reads
Azure Arc
Azure arc is another great stuff coming with Microsoft Azure, as we were expecting Azure cloud Microsoft has great DevOps options and nice for everyone. Azure has multiple subscribtion...
2021-06-20
70 reads
Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements
The next batch of exciting updates to the block editor is live on WordPress.com. Powerful duotone image editing, a persistent list view to edit your page or post, and...
2021-06-18
30 reads
Troubleshooting Backup Compression for Encrypted Databases
For years, I thought that native backups of databases using Transparent Data Encryption (TDE) couldn’t be compressed. Between TDE being limited to Enterprise Edition until SQL Server 2019 and...
2021-06-18
47 reads
Are You a Diverse User Group or Event?
One of the things that I’ve seen crop up at various points in my career is a question of diversity. I know there are many people that don’t think...
2021-07-02 (first published: 2021-06-18)
181 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