My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out...
2011-12-28
843 reads
Learn SQL 2012
Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time...
2011-12-28
1,626 reads
PASS Update #69 (The Wrap Up)
Next week marks the end of my third and final year serving on the PASS Board of Directors. I’ve struggled...
2011-12-27
667 reads
Why doesn’t my gauge show correct values?
Here is an issue I encountered recently while using gauge in reporting services.
There are three gauges in the report one...
2011-12-27
1,026 reads
In 2012, It’s Me and Vanilla Ice
Like many others, I’m planning a few changes for my life for next year. I’m a believer in finding one’s...
2011-12-27
1,208 reads
Revamping Surat User Group
Dear Friends, we had a user group meeting last week – I and Vinay Pugalia was here. We have discussed many...
2011-12-26
598 reads
SQL MCM Study Group
Over the last few days, you may have noticed that there’s been a bit of talk about a SQL Server...
2011-12-26
936 reads
Backing up the Service Master Key
Making a backup of your Service Master Key (SMK) should be one of the first things that you do if...
2011-12-26
5,165 reads
SQL Server 2008 R2 RTM Cumulative Update 11
On December 19, 2011, Microsoft released SQL Server 2008 R2 RTM Cumulative Update 11 (CU11), which is Build 10.50.1807.0. I...
2011-12-26
1,475 reads
Webcast: Putting a Better SQL Server in Production
Webcast: Putting a Better SQL Server in Production
Production Line
Webcast:Putting a Better SQL Server in Production
Date: Wednesday, January 18, 2012 3:00...
2011-12-26
1,246 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