I'm Back!
I've been gone... wow. Since March 31st of this year?! Let's fix that.
So what has been holding me back?
Kids? I...
2016-09-23
382 reads
TGI SQL Friday: Weekly Roundup 23rd September
Its been another Learning Tree week for me this week and a very interesting one at that. I'm on the...
2016-09-23
521 reads
Mastering Index - Filtered Index
Mastering Index - Filtered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Filtered Index. Take...
2016-09-23
623 reads
SQL QUERY NIGHTMARE
Last week, we faced a basic and yet the only major problem that sql developers/admin had to deal with and...
2016-10-07 (first published: 2016-09-23)
4,339 reads
Why SQL Cruise?
I was riding the elevator up from lunch today, at work. I am relatively new at my job and do...
2016-09-23
494 reads
More Azure Database Creation in Powershell
I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at...
2016-09-22
588 reads
Organizing a SQL Saturday – Part 3 – The Venue
You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you...
2016-09-22
420 reads
I’m Speaking! SQL Saturday #548 – Kansas City
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home...
2016-09-22
461 reads
sp_WOxCompliant Update
I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What...
2016-09-22
490 reads
Have you Upgraded From SQL Server 2005?
My first Learning Tree SQL Server Newsletter that was sent out back in August was titled SQL Server 2016: Keeping...
2016-09-22
471 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