New Hotness: sys.sql_modules
I’m still old school in many ways. And they’re not the ways that let you get away with wearing wayfarers, or...
2010-09-15
527 reads
Using Excel As A Reporting Services Datasource
It’s been said that Excel is the poor man’s database. I don’t know about that, but I can tell you...
2010-09-15
917 reads
Baton Rouge SQL Server User Group Tonight
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
526 reads
2010-09-15
909 reads
Slides and Files: A PowerShell Primer
Here are the slides and scripts from last night's presentation at Midlands PASS Chapter. The presentation was intended to introduce...
2010-09-15
1,029 reads
Reading Recommendations (Twitter is cool)
Twitter is an amazing beast. More and more I find myself getting useful information and ideas from Twitter. For someone...
2010-09-15
863 reads
Policy Based Management - Disable Autoclose
I posted recently about my run-in with autoclose and my online friend Jorge Segarra (Blog|@SQLCHICKEN) left a great comment on...
2010-09-15
1,636 reads
Project Phoenix: Early September Awards Announced
9/14/2010 Two more eligible developers and deserving projects have been selected. Any proposals submitted but not selected this time will...
2010-09-15
716 reads
Book Review: Blink: The Power of Thinking Without Thinking
I read Blink: The Power of Thinking Without Thinking by Malcolm Gladwell on a recommendation by Andy Leonard. Easy recommendation...
2010-09-15
949 reads
Index Black Ops Part 1 – Locks and Blocking
As I mentioned in the my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the...
2010-09-15
1,408 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