T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay
Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the...
2011-12-13
626 reads
Blog Posts
T-SQL Tuesday #025 – Tips and Tricks
And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.
If you’re an avid writer, you might...
2011-12-13
740 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,196 reads
CPU-Z 1.59 Released
One of my favorite free tools for getting some processor and memory specific information from a Windows computer (whether is...
2011-12-12
1,251 reads
More Culture-The Failure Wall
Ran across this during my daily reading, a post by Jeff Stibel on Why I Hire People That Fail. The...
2011-12-12
786 reads
Presenting at IT Pro Camp in January 2012
My first outing of the new year will be at the IT Pro Camp here in Orlando, working on some...
2011-12-12
649 reads
Replication Bookmarks
I started a list of the resources I frequent the most in the MSDN Library SQL Server Books Online - Replication,...
2011-12-12
1,117 reads
SQL Traces and c2 auditing are different
Sometimes end users interchange the terms : C2 auditing and Traces.
They server different purposes.
c2 auditing records all attempts (successfull and...
2011-12-12
852 reads
Top SSAS white papers
These are my favorite SSAS white papers released by Microsoft, with many from SQLCAT. I’ll keep this post updated with new...
2011-12-12
5,714 reads
Working with SQL Server Third Party Vendors
I ran across Denny Cherry’s (@MrDenny) blog on Fixing Vendor Performance Problems in which he outlines three methods of dealing...
2011-12-12
1,172 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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