Friday Followup For December 6, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-06
368 reads
Presentation Update: New BI Features in SharePoint 2013
It’s time for another free webinar!!
Whether you like it or not SharePoint is here to stay! With every release of...
2013-12-06
1,236 reads
Junior DBAs - Where to start?
I personally would start with your local user groups. Getting to know people and networking may be your best bet...
2013-12-06
435 reads
How To Get The TableDiff Utility
Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables...
2013-12-05
2,581 reads
SQL Server Quickie #8 – Hash Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2013-12-05
658 reads
Power Query Preview November Update
As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft...
2013-12-05
1,519 reads
Webcast Today: Surviving The First Week As The New DBA
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m...
2013-12-05
693 reads
Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data...
2013-12-05
1,249 reads
A quick hint – evaluating 2 tables in one IF BEGIN END block
Have you ever wanted to evaluate 2 tables in one IF BEGIN END block, I firstly wrote this:-
Which always evaluated...
2013-12-05
395 reads
Blocked processes: Quick Tips
Sometimes activity monitor just isn't fast enough. Maybe it's not telling you what a specific query is doing. Below is...
2013-12-05
475 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