Enabling the SQL Server Agent in Linux Containers
At SQL Saturday Holland a few weeks ago I was (surprise, surprise) chatting about containers and mentioned that I hadn’t...
2017-11-06 (first published: 2017-10-25)
1,772 reads
The DBA Who Came In From The Cold
Event Organisers
Over the last few weeks I’ve spoken at a few conferences, the last of those being SQL Relay.
For those of...
2017-10-23
296 reads
Limiting resources available to containers
One question that I get asked regularly is, “can you limit the host resources to individual containers?”
This is a great...
2017-10-04
463 reads
Monday Coffee: Long hours worked
Last week I asked the following question on twitter: –
I had a load of responses from a lot of DBAs...
2017-10-02
287 reads
Friday Reading 2017-09-29
Another busy week almost over and today I’m heading to Utrecht for SQL Saturday Holland! Never been to Utrecht before...
2017-09-29
510 reads
The docker kill command
When running demos and experimenting with containers I always clear down my environment. It’s good practice to leave a clean...
2017-10-06 (first published: 2017-09-28)
1,583 reads
An analytical mind
Last week I was reading this article in which a Professor argues that students should be allowed to take smartphones...
2017-09-25
382 reads
Monday Coffee: Should I learn powershell?
This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH
It had a massive...
2017-09-18
818 reads
Friday Reading 2017-09-15
Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years...
2017-09-15
376 reads
Creating Hyper-V VMs with Powershell
This month’s T-SQL Tuesday is hosted by Rob Sewell (b|t) and surprise, surprise, it focuses on Powershell so I thought...
2017-09-12
409 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