Friday Followup For November 15, 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-11-15
487 reads
A Tour of the Transaction Log: Part 3 Reading Log Backups
In part one and two of our Tour of the Transaction Log articles we focused on reading events from the...
2013-11-15
1,489 reads
Checking your users and groups in Command Window.
As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...
2013-11-15
530 reads
Fill Factor, Why Do You Taunt Me? Part 1
Like all the arbitrary numbers we hear in the SQL community such as the 30% fragmentation and 1000 pages. These...
2013-11-15
752 reads
Powershell in a Month – Day 2, Help
This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a...
2013-11-14
1,252 reads
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
925 reads
VMware vCPU Ready Time Equivalent in Hyper-V
Jonathan Keyahias (b | t | l) from SQLskills has released a new blog post outlining the metric that Microsoft’s Hyper-V product...
2013-11-14
1,024 reads
SQL Server Data Tools BI (SSDT-BI) for SQL Server 2014
Last month I blogged that SQL Server Data Tools for SQL Server 2014 CTP2 now available. You can download that here....
2013-11-14
4,936 reads
Throwback Thursday #1: SQL Inspire
What Is Throwback Thursday?
One of my hobbies is being a turntablist. In high school I took a job just so...
2013-11-14
834 reads
Free Online SQL Server Training for the Week of November 17, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-14
463 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