Collation considerations to create robust queries
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
207 reads
Blog Posts
Notes on the May 2018 SQLOrlando Meetup
Late writing notes!
55 registered, 28 attended. Not bad, and about on track for expected 50% drop. Really, 28 made for...
2018-06-11
291 reads
Query To Retrieve Statistics Data: dm_db_stats_histogram
Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced:...
2018-06-11 (first published: 2018-05-29)
2,169 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem
My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index...
2018-06-11 (first published: 2018-05-29)
1,654 reads
Understanding Cosmos DB
Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that...
2018-06-11
435 reads
Double Win- Watch DeWitt and Help SQLSoldier's Loved Ones!
Brent Ozar (blog/@BrentO) is sponsoring a special webcast in a couple weeks, with an amazing presenter:
https://www.brentozar.com/archive/2018/06/announcing-a-very-special-sqlfamily-webcast-with-dr-david-dewitt/
The webcast (“SQL Query Optimization....
2018-06-09
830 reads
Making Sense of the Power BI Ecosystem Presentation Materials
I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in...
2018-06-09
363 reads
Building a Personal VPN Azure Solution
Since joining Denny Cherry & Associates Consulting, I tend to travel about once a month. This isn’t a huge amount and...
2018-06-08
458 reads
Interview questions: What’s the first thing you would do if a user reports slowness.
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...
2018-06-08 (first published: 2018-05-28)
4,099 reads
Project Euler
I like having problems to practice solving in computer science. It can be a fun hobby, and it exercises your...
2018-06-08
1,391 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