SQL Server 2012 Reporting Services Blueprints – Review
Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe...
2013-12-12
779 reads
SQL Saturdays: Day 4
Well, we talked about user groups... Let's talk about their big brother; SQL Saturdays. @SQLCenturion runs them here in OKC. They...
2013-12-12
475 reads
A Full Backup Includes Everything (with a caveat)
Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something...
2013-12-11
835 reads
SQL Server 2014 Backup to URL
I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location....
2013-12-11
1,723 reads
First Week As The DBA Whitepaper Published
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
838 reads
Database Snapshot failed due to disk space issue
Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML...
2013-12-11
1,099 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to stay in the Nation’s capitol for more than just...
2013-12-11
11 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to...
2013-12-11
833 reads
TheSQLPro YouTube Channel
That’s right, it’s time to take this blog up a notch! Last week I posted a video about using Hyper-V...
2013-12-11
615 reads
Thoughts on December 2013 Power Query Updates
Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates. The...
2013-12-11
922 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