Zero Width Characters
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
563 reads
Blog Posts
SQL Server on VMware Boot Camp at VMworld 2018
I am extremely proud to announce that I am presenting in conjunction with VMware Corp. an all-day boot camp for...
2018-07-21
388 reads
Finding Inconsistent Key Values–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-07-20 (first published: 2018-07-11)
1,848 reads
Friday Reading 2018-07-20
Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.
I’ve...
2018-07-20
338 reads
My #SQLCareer Day–July 19
I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but...
2018-07-20
475 reads
Silly Photos at Work
Someone I stumbled across this picture of @brento on my drive.
This might be the best one:
And this was a good...
2018-07-20
327 reads
The need for having both a DW and cubes
I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...
2018-07-20
18 reads
T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...
2018-07-20 (first published: 2018-07-10)
2,194 reads
Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio
In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers...
2018-07-19
898 reads
Code I Can’t Live Without–T-SQL Tuesday #104
Bert Wagner has a good invitation this month, a T-SQL Tuesday question about code, specifically code you can’t live without....
2018-07-19 (first published: 2018-07-10)
3,707 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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