Converting Dates to Integers
While working on a project recently, I came across a conversion that was trying to convert a date to an...
2010-10-05
821 reads
SQLRally Event Flyer is Ready
The SQLRally marketing team put this flyer together last week. We’ll be trying to get Chapters and SQLSaturdays to link...
2010-10-04
337 reads
SQL Server Database Maintenance Checklist
In this blog post, I continue my series of SQL Server Health Checklists that I am developing for a new...
2010-10-04
3,629 reads
Slides & Samples for my SQLbits workshop & session
As announced in my SQLBits workshop & session last week in York/UK, you can find the
session/workshop material here.
Have fun!
-Klaus
2010-10-04
417 reads
Drawn By the BI Sirens
Patrick Is the lead Singer
Sirens. Their sweet songs lured sailors to their deaths in tales of yore. Alas, I too...
2010-10-04
693 reads
SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
427 reads
Return of Index Analysis
Now that I’ve finished going through some of the details for sys.dm_db_index_operational_stats, it’s time to take that information and incorporate...
2010-10-04
451 reads
SQL Saturday in New England
Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I’ve...
2010-10-04
398 reads
How to Tell if Execution Plans are Reused
I try to watch the search phrases that point people to the blog because sometimes, you get a sense of...
2010-10-04
449 reads
SQLSaturday #52 – Colorado Recap
I had the good fortune of being able to travel to Denver for SQLSaturday #52 the weekend of September 25,...
2010-10-04
672 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