In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements...
2023-01-09 (first published: 2022-12-22)
377 reads
Today’s coping tip is to listen wholeheartedly to someone else, without judging them. I get the chance to talk with lots of people. I make it a point when...
2022-12-21
24 reads
When you first look at the encryption hierarchy for TDE in SQL Server it can be a bit daunting. There seem to be a lot of objects involved and...
2023-01-04 (first published: 2022-12-21)
344 reads
I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
260 reads
Today’s coping tip is to do something helpful for a friend or family member. Easy one for me. My daughter came home from University yesterday, and I took time...
2022-12-20
22 reads
SAVE THE DATE: VMUG Ireland Relaunch Event February 9th, 2023 Location: Dublin VMUG Ireland is back! We are hosting a VMUG Relaunch event in Dublin on February 9th, 2023....
2022-12-20
30 reads
This post introduces you to the Pure Storage FlashArray OpenMetrics Exporter. It shows you how to get started quickly using Docker Compose so you can monitor your Pure Storage...
2023-01-04 (first published: 2022-12-20)
345 reads
TDE is referred to as a “transparent” form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The...
2022-12-19
115 reads
Today’s coping tip is to give kind comments to as many people as possible today. Not an easy tip for me to follow as I’ve been a little home...
2022-12-19
23 reads
Watch this week's video on YouTube
How do you keep track of your daily work accomplishments?
If you are like me, you wait until the end of the week and then...
2022-12-19
19 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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