Speaking at SQL Saturday #227 Charleston this weekend
I am proud to be selected to speak at this weekend’s first ever SQL Saturday in Charleston, SC. I am...
2013-10-11
580 reads
One Down
Yesterday was our first 2013 SQL in the City event in Pasadena, CA. I was excited and nervous, with 3...
2013-10-10
794 reads
Coast to Coast with SQL Saturday
Last month I blogged about the SQL Crazy train making a whistle stop in Providence Rhode Island. A couple of weeks prior to that, you may have read this...
2013-10-10
10 reads
Coast to Coast with SQL Saturday
Last month I blogged about the SQL Crazy train making a whistle stop in Providence Rhode Island. A couple of...
2013-10-10
673 reads
PASS Summit 2013
The PASS Summit 2013 is almost here! Check out all the great sessions and speakers. I feel very fortunate to be able to speak...
2013-10-10
636 reads
Looking for a new SQL Server book? Look no further…
So I know it’s been a while since I last posted on this blog, but I promise I haven’t been...
2013-10-18 (first published: 2013-10-10)
3,353 reads
What Queries are Causing My Waits?
In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once...
2013-10-15 (first published: 2013-10-10)
4,275 reads
SQL Server Analysis Services Activity Viewer 2012 1.1 Stable Released
This morning I am happy to announce the release of a stable version of SSAS Activity Viewer 2012. The build number is 1.1.0.0. The new features have been highlighted...
2013-10-10
20 reads
Leveraging LinkedIn to Contribute to the DBA Community & Attract Opportunities with Internationally-Oriented Organisations
LinkedIn has matured over the past decade and I can
sincerely say it is well worth the time setting up your...
2013-10-09
1,270 reads
I’ve refreshed a test database from prod but now the users can’t access it.
This happens to me all the time. I get a request from a developer to overwrite the test copy of...
2013-10-16 (first published: 2013-10-09)
2,674 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