This Week In Data – Episode 11 (Debunking Popular Cloud Myths)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-02
477 reads
Looking Back: #sqldinner at #sqlsummit 2016
Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide...
2016-11-02
581 reads
Live 360–SQL in Orlando
I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...
2016-11-10 (first published: 2016-11-02)
920 reads
Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...
2016-11-02
18 reads
Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
212 reads
A Data Professional’s Story – PASS Summit 2016
This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...
2016-11-11 (first published: 2016-11-02)
1,241 reads
Query Store custom SSMS performance dashboard
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
3,295 reads
New indexes, hypothetically
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...
2016-11-02
874 reads
Trick or Treat...Have I got an IT Training treat for you...
It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...
2016-11-02
496 reads
SQL Server DMA v2.0 – Migration Time
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
594 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