Deploying to Azure Without Writing JSON Arm Templates
Reading Time: 6 minutes (not a minute longer)
TLDR; ARM templates are a great way to deploy to Azure, setting up...
2018-06-19
307 reads
Blog Posts
Deploying to Azure Without Writing JSON Arm Templates
Reading Time: 6 minutes (not a minute longer)
TLDR; ARM templates are a great way to deploy to Azure, setting up a template that can deploy an entire environment from...
2018-06-19
15 reads
Installing SSDT for Visual Studio 2017
I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it....
2018-06-19
3,944 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...
2018-06-19
22 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...
2018-06-19
12 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. ...
2018-06-19
645 reads
Plan Metrics Without the Plan: Trace Flag 7412
I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag...
2018-06-19 (first published: 2018-06-11)
1,802 reads
Removing a secondary replica database in Always On SQL Environment
Removing a database from an Always On availability group is pretty straight forward and can be accomplished by either ssms...
2018-06-19
136 reads
South Florida Vacation Notes
I extended my trip to SQLSaturday South Florida for a couple days vacation. If I’m going to drive 3-1/2 hours...
2018-06-19
340 reads
SQL Saturday Houston is this weekend
I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the...
2018-06-19
322 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