Summit Submission Feedback Response
I’m It Survival Tips for the Lone DBA – Level 100
(Not Accepted: Higher rated session selected)
Track: Professional Development
As others have done I...
2016-06-28
221 reads
Does my database have data type drift?
Over the years I have come to see that every database has what I call data type drift. Simply put,...
2016-07-13 (first published: 2016-06-28)
2,515 reads
Better ReadyRoll Script Naming
One of the things that I like about ReadyRoll is that the product will automatically build new scripts that are...
2016-06-28
632 reads
CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,859 reads
Power BI Custom Visuals Class (Module 05 – KPI Indicator)
In this module you will learn how to use the KPI Indicator (This is kind of like saying “ATM Machine”...
2016-07-05 (first published: 2016-06-28)
2,680 reads
Slidedeck ITPROceed – Power BI Status Update
I uploaded my slidedeck from the ITPROceed event to Docs.com. For the abstract, see the blog post Speaking about Power...
2016-06-28
535 reads
BREXIT…IT professionals need a plan… much like the UK government
The events that have unfolded over the last few days since the shock result that the BRExit referendum delivered, has,...
2016-06-28
496 reads
The Desktop Rebuild–Part 2
You can read part 1, but that’s more about the (initial) hardware changes. This one looks at getting moving on...
2016-06-27
546 reads
Monday Morning SQL Break – June 27, 2016
The best way to make the most of the week is to set your goals. One of the things I...
2016-06-27
896 reads
Debuting Talks at the Summit
This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for...
2016-06-27
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