I’m presenting at the PASS Business Analytics Conference
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA...
2013-12-19
658 reads
How to Set Up Managed Backups in SQL Server 2014
Earlier this week I introduced the concept of Managed Backups (and caused less of a turmoil than I thought I...
2013-12-19
2,862 reads
Transactions: Rolling back part of a transaction.
In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...
2013-12-19
684 reads
To All Recruiters - Canned Emails Kill Kittens: Day 9
Small disclaimer
I'm going to file this one under rant. Let me first say that there are some wonderful recruiting agencies...
2013-12-19
652 reads
Active Directory and SQL Server Questions Answered
I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can...
2013-12-24 (first published: 2013-12-18)
3,437 reads
Data Architecture VC hosts Nigel Sammy: TSQL Tips and Tricks
Please join the Data Architecture Virtual Chapter as they host SQL Server MVP Nigel Sammy his take for T-SQL Tips...
2013-12-18
607 reads
Traveling in 2013
It was a busy year for me. As I look back at my speaking CV for 2013, here’s what I...
2013-12-18
810 reads
Increasing database unit tests connection timeout period in VS 2012
Have your ever had a timeout error in a visual studio 2012 unit test like below?
How to get around this...
2013-12-18
1,040 reads
Power BI Q&A Preview Now Live On Your Data
With the recent updates to the Power BI preview and Q&A features added I thought I would do a quick...
2013-12-18
1,070 reads
Speaking in 2014
I love that I get to travel around and learn from my #sqlfamily. We’re still filling in the majority of...
2013-12-18
672 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