dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users....
2017-06-28 (first published: 2017-06-19)
1,709 reads
Anthony Nocentino Blog
dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools....
2017-06-19
16 reads
PowerShell Remoting in Multi-Platform Environments – Use Cases
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In...
2017-06-12
757 reads
PowerShell Remoting in Multi-Platform Environments – Use Cases
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In this post, we’re going to leverage that configuration and...
2017-06-12
4 reads
Speaking at SQL Saturday Pensacola!
I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing...
2017-05-26
348 reads
Speaking at SQL Saturday Pensacola!
I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!
If you don’t know what SQLSaturday is, it’s a...
2017-05-26
16 reads
PowerShell Remoting in Multi-Platform Environments using OpenSSH
So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going...
2017-05-25
542 reads
PowerShell Remoting in Multi-Platform Environments using OpenSSH
So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going down that path together. In this post I’m going...
2017-05-25
17 reads
Why PowerShell?
Why do I use PowerShell?
Well, here’s a little back story…last year I was involved in a Pluralsight Play by Play...
2017-05-09
678 reads
Why PowerShell?
Why do I use PowerShell? Well, here’s a little back story…last year I was involved in a Pluralsight Play by Play with Jason Helmick and Jeffrey Snover for launch of...
2017-05-09
9 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