What steps are there to move to safe automated database deployments?
Database deployments are scary, you have all this data and if you drop the wrong table, run the wrong delete statement or have an error in a stored procedure...
2019-06-10
9 reads
What steps are there to move to safe automated database deployments?
Database deployments are scary, you have all this data and if you drop the wrong table, run the wrong delete statement or have an error in a stored procedure...
2019-06-10
111 reads
Leverage AWS System Manager Sessions
Use Case
Leveraging aws system manager sessions can help with aws development, by eliminating the need to RDP for work that can be done via a PowerShell session. In addition,...
2019-06-10
33 reads
Easy Open Event Log Files
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...
2019-06-07
7 reads
Easy Open Event Log Files
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...
2019-06-07
13 reads
Easy Open Event Log Files
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...
2019-06-07
267 reads
Gone Fishing…
It's SQLIntersection time, and also time to meet a new member of the family. He's old enough for social media, though...
2019-06-07
26 reads
Mitre’s ATT&CK Security Framework
Mitre’s ATT&CK security framework was mentioned often at the Techno Security and Digital Forensics Conference. I admit that I’m not well-versed on it, yet. However, its purpose makes sense....
2019-06-07
59 reads
How to get Authentication Token for Dynamics 365 Finance and Operations on-premise and cloud deployments to run REST API using Powershell and the client credentials grant method
Before being able to run REST APIs to do specific tasks programmatically in Dynamics 365 for Finance and Operations (hereby known as D365FO), the application needs to be able...
2019-06-07
389 reads
Working with Arrays in Azure Data Factory
(2019-June-06) I remember I had a professor at my university who very often would encourage his students to learn and get more experienced with simple things first. Learn the basics...
2019-06-25 (first published: 2019-06-07)
49,779 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