Source Control for the Reluctant DBA
This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I...
2016-07-13
936 reads
Getting Started with Database DevOps, DLM, and New Tools
Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh...
2016-07-13
579 reads
Azure SQL Data Warehouse is now GA
The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available. Here is the official...
2016-07-13
598 reads
Thanks, Karla
I heard the news this week, and I’m still sad. Karla Landrum is leaving PASS after five years of acting...
2016-07-13
501 reads
Live from @LearningTree London - Security Day - Day 2
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...
2016-07-13
387 reads
SQL Server – How to retrieve SQL plans from Cache
Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache....
2016-07-13
665 reads
SQLskills Training
Well I finally accomplished a goal of mine– that being to complete the training for SQL Server Performance Tuning and...
2016-07-12
197 reads
T-SQL Tuesday #80 – SQL Birthday Present
It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and...
2016-07-12
778 reads
Power BI Custom Visuals Class (Module 07 – Enhanced Scatter)
In this module you will learn how to use the Enhanced Scatter Power BI Custom Visual. This new-and-improved scatter chart...
2016-07-12
1,152 reads
T-SQL Tuesday #080 – The Gift of the Basics
This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s...
2016-07-12
531 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