Monday Night Networking at Summit 2016
It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.
For those of...
2016-10-10
549 reads
Power BI Custom Visuals Class (Module 20 – Word Cloud)
In this module you will learn how to use the Word Cloud Power BI Custom Visual. The Word Cloud is...
2016-10-18 (first published: 2016-10-10)
1,838 reads
Making the case for CamelCase naming
Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...
2016-10-17 (first published: 2016-10-10)
3,870 reads
Migrating Database Collation - The Red Gate Way
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
360 reads
Mastering Index – Nonclustered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Nonclustered Index. Take...
2016-10-10
479 reads
Azure SQL Database – TDE
I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...
2016-10-10
458 reads
PASS Speaker Idol 2016 – Todd Kleinhans
I am grateful and thankful I got selected to speak again at Speaker Idol. It has been a crazy and...
2016-10-09
365 reads
SQL Server 2016 Query Store - Gentle Introduction - 1
Query Store is perhaps one of the path breaking features to release in SQL Server 2016. This post will give...
2016-10-09
553 reads
Fixing non-deterministic error when creating indexed view
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
148 reads
Fixing non-deterministic error when creating indexed view
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
3,882 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