We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time...
2011-11-07
683 reads
Blog Posts
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time to jump back in the deep end. If you...
2011-11-07
8 reads
What is #SQLFamily?
There’s a large group of people that mean a lot to me. Some of them I know well, and others...
2011-11-07
759 reads
Blogging from 37,000ft
Im currently on my way to Sql Rally nordic and looking forward to a few days of full on SQL...
2011-11-06
635 reads
Execution plan warnings–All that glitters is not gold
In a previous post, I showed you the new execution plan warnings related to implicit and explicit warnings. Pretty much...
2011-11-06
847 reads
New version of SQL Treeo SSMS productivity add-in was released
Hi,
new, second version of SQL Treeo productivity add-in was released.
For little reminder, here are main features of this add-in:
Create...
2011-11-06
2,433 reads
Free SQL Server Learning Resources
As a learner I have got chance to know lots of free and precious SQL Server resources in last few...
2011-11-05
2,503 reads
Protected: SQLSaturday #86 in Tampa–Tomorrow!
This post is password protected. To view it please enter your password below:
Password:
2011-11-04
393 reads
SQL Tribal Knowledge
Ever felt like trying your hand at writing? November is National Novel Writing Month (or NaNoWriMo for our savvy readers). ...
2011-11-04
538 reads
SQLSaturday #86 in Tampa–Tomorrow!
With a little bit of luck I’ll be arriving in Orlando today around 9 am as I return from SQLConnections...
2011-11-04
534 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