The powerpoint for my SQL Server Security Basics session
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned...
2015-10-05
545 reads
Non-Clustered Index
In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...
2015-10-04
336 reads
Non-Clustered Index
In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...
2015-10-04
494 reads
SQL Saturday 467 - Precon - Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
478 reads
SQL Saturday 467 – Precon – Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
313 reads
Load Testing Your Storage Subsystem with Diskspd – Part III
In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output...
2015-10-04
3,654 reads
Presentation Downloads from SQL Saturday Columbus GA 2015
Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL...
2015-10-03
514 reads
Standing Desk Update
It’s been a long time since I wrote about my workspace, however I made a change recently. This was the...
2015-10-02
369 reads
Standing Desk Update
It’s been a long time since I wrote about my workspace, however I made a change recently. This was the...
2015-10-02
624 reads
Speaker of the Month: October 2015
Working on my third year of “Speaker of the Month” posts now. The good news, I haven’t run out of...
2015-10-02
474 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