Running a SQL Server container from scratch
I’ve been interested (obsessed?) with running SQL Server in containers for a while now, ever since I saw how quick and easy it was to spin one up. That...
2021-05-24 (first published: 2021-05-17)
659 reads
Encryption in SQL Server #1 – Column Level Encryption
For one reason or another data security and encryption has been coming up quite a bit in my day to day work recently and I’ve started to realise that...
2021-05-21 (first published: 2021-05-17)
462 reads
Career: Talk To References
As we try to get through these strange times in the world, I am starting to see a bit more career movement in 2021 than I saw for much...
2021-05-21 (first published: 2021-05-14)
187 reads
This Saturday: #DataWeekender, DataSaturday Southwest
Geeked to be speaking 2x on Saturday May 14, my second time speaking at #DataWeekender and at the very first Data Saturday Southwest 2021.
My Certification Exams Inside Out is one...
2021-05-14
22 reads
Daily Coping 14 May 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-05-14
21 reads
A Very Simple Blocking Alert
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
2021-05-13
21 reads
A Very Simple Blocking Alert
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
2021-05-24 (first published: 2021-05-13)
748 reads
WIT Mental Health and Wellness Videos Posted
I was honored to speak at the WIT Mental Health and Wellness day last week and found myself caught up in the other presentations the rest of the day....
2021-05-13
27 reads
Daily Coping 13 May 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-05-13
16 reads
#PowershellBasics: Comments and comment based help
I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the same reasons and then some. So first of all...
2021-05-13
89 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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