Splitting CSV strings in SQL 2016
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,745 reads
Pluralsight courses available with MSDN Subscription
One of the benefits of having an MSDN Subscription is that you have free access to some Pluralsight courses.
To verify this,...
2016-09-08
580 reads
SQL Sentry Does It Again–Plan Explorer 3.0
Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry...
2016-09-08
430 reads
Speaking at IT/Dev Connections 2016
I’m happy to announce that I’m speaking at this year’s IT/Dev Connections conference held at the ARIA Resort in Las Vegas...
2016-09-08
353 reads
SA Spoof
This is nothing new but it’s still a fun idea.
The problem:
The vendor app we just purchased (and are told we...
2016-09-08
492 reads
Are you going to SQL Saturday Denmark? #SQLSaturdayDenmark
Are you going to SQL Saturday Denmark, which is running on Saturday 17th September? If you are David Postlethwaite or @postledm...
2016-09-08
435 reads
Sql Server Special Table Types
Special
Table Types
Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...
2016-09-08
208 reads
Reminder: Webinar today
This is a reminder that I’ll be giving a webinar today on managing SQL Server Agents jobs in a SQL...
2016-09-08
396 reads
Sql Server - Finding Duplicate Indexes
If you are reading this article, I assume
that you have basic knowledge of Index, its types and usage.
Over the...
2016-09-08
203 reads
Recap of My 24HOP Session – From XML to JSON
Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...
2016-09-08
210 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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