I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...
2023-01-30 (first published: 2023-01-18)
82 reads
Today’s coping tip is to say positive things to the people you meet today. In general, I don’t encounter a lot of people on any day, but I do...
2023-01-18
18 reads
Today’s coping tip is to get moving. Ideally do something outside. Taking time to walk the dogs outside, heading to the dog park to get them, and me, some...
2023-01-18
25 reads
I’m honored to be heading back to SQL Bits 2023. I was selected to deliver one session, in the professional development track. With so many people submitting, I’m not...
2023-01-17
34 reads
The question of encryption seems to be coming up a lot recently. I’ve had a number of people asking me about how to go about encrypting SQL Server. SQL...
2023-01-25 (first published: 2023-01-17)
468 reads
In my experiments with the Flyway CLI (fwcli), I’m finding some interesting behavior, some of which is catching my by surprise. This post looks at the baseline command and...
2023-01-16
41 reads
Today’s coping tip is to learn something new and share it with others. I do this all the time. It’s a part of my job, and I did this...
2023-01-16
25 reads
Today I have uploaded SQL Server Quickie #44 to YouTube. This time I’m talking about SQL Server on Docker.
2023-01-23 (first published: 2023-01-16)
234 reads
Foreword
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me....
2023-01-16
22 reads
Cosmos DB is a powerful, fully-managed, globally distributed, and multi-model database service provided by Microsoft Azure. One of its key features is the ability to create and execute stored...
2023-01-23 (first published: 2023-01-13)
12,084 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