Daily Coping 6 Aug 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-08-06
35 reads
Updating SQL Server container memory limits on the fly
When running multiple SQL Server containers on a Docker host we should always be setting CPU and Memory limits for each container (see the flags for memory and cpus...
2021-08-18 (first published: 2021-08-06)
341 reads
Daily Coping 5 Aug 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-08-05
24 reads
Interview Tip: Know your resume
Seriously. Make a point of reading your resume before submitting it, and again before an interview. I’ve been helping with ... Continue reading
2021-08-20 (first published: 2021-08-05)
258 reads
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL Server on Kubernetes – Designing and Building a Modern Data Platform available now at Apress...
2021-08-04
27 reads
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL Server on Kubernetes – Designing and Building a Modern Data Platform available now at Apress...
2021-08-20 (first published: 2021-08-04)
320 reads
Gathering More Digital Data with Tile Slim
After my wallet misadventures, I ordered a Tile Slim to track my wallet. It came a few days later and I walked through the setup. As you can see...
2021-08-04
20 reads
Accessibility is not just about slides
Although I don’t write about it much on this website, I am on the autism spectrum, and I have ADHD. I need to sit at the front of a...
2021-08-04
37 reads
Daily Coping 4 Aug 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-08-04
22 reads
Architect a disaster recovery for SQL Server on AWS: Part 1
New blog post - Architect a disaster recovery for SQL Server on AWS: Part 1
Customers often ask for guidance on choosing the right HA or DR solution for SQL...
2021-08-03
99 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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