ALTER INDEX….ABORT!
I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...
2016-10-06
495 reads
Notes about Postponing SQLSaturday Orlando Due to the Hurricane
We’ve been monitoring the weather all week, thinking that today was the day we had to decide. We didn’t want...
2016-10-05
424 reads
MOSL – Memory Optimised Scripts Library
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...
2016-10-05
546 reads
This Week In Data – Episode 7 (The Importance of Data Testing)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-05
442 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears to be the right year to do this....
2016-10-05
54 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...
2016-10-05
911 reads
Microsoft certification changes
A recent Microsoft blog post announced that they are releasing five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties. ...
2016-10-05
784 reads
Where Do We Go To Share?
No one reads blogs any more.
Twitter is dying.
Facebook is broken.
LinkedIn? Please.
G+. Is that even on any more?
Where do we go...
2016-10-05
487 reads
Floor, Round, and Ceiling
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...
2016-10-05
657 reads
Overview of Published Articles – 2016Q3
Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...
2016-10-05
526 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