Hands off dbatools updates
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-06-01 (first published: 2018-05-25)
2,438 reads
Blog Posts
Mobile Azure
Microsoft Azure offers up a lot of technologies that you can play around with. One thing that you might not...
2018-06-01
274 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
231 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
119 reads
SQLSaturday Orlando 2018 Registration is Open
We’ve just opened up registration and the call for speakers for our 12th SQLSaturday here in Orlando. We did #1...
2018-06-01
657 reads
You know everything about GROUP BY. Do you?
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...
2018-06-01 (first published: 2018-05-25)
5,850 reads
Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler
This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux...
2018-05-31 (first published: 2018-05-22)
2,095 reads
Birthday Musings and Deploy Using PoshSSDTBuildDeploy
Hello!
It is my birthday: another year older, another year not necessarily wiser. I’m planning on spending the evening watching the BBC and eating pizza. There are worse ways to...
2018-05-31
45 reads
dbachecks – Save the results to a database for historical reporting
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...
2018-05-31 (first published: 2018-05-23)
3,069 reads
Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger
It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure is...
2018-05-31
484 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