From XML to JSON – script
Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is...
2016-02-28
703 reads
Because loyalty is a two-way street
Moving a dog to Australia with no money at hand
I always had plans to move to Brisbane, Australia, where my...
2016-02-27
244 reads
Mandatory Sql Server properties to configure on a new instance
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice...
2016-02-26
19 reads
Mandatory Sql Server properties to configure on a new instance
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice...
2016-02-26
23 reads
Mandatory Sql Server properties to configure on a new instance
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the...
2016-02-26
688 reads
Some Sql Server properties to configure on a new instance
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the...
2016-02-26
574 reads
Fix a Network Binding Order Warning
Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in...
2016-03-03 (first published: 2016-02-26)
1,728 reads
The Jarvis–Standing Desk Update
I started using a standing desk a few years back. While visiting the Redgate Software office, I saw one of...
2016-02-26
1,974 reads
Announcing Workshops – Columnstore Deep Dive (in German)
To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days...
2016-02-26
889 reads
SQL 2012 Identity Columns Feature
Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this...
2016-02-25
1,455 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