Last Weeks Top “Reading” Links #57
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-11
1,168 reads
For the Aspiring DBA
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...
2013-11-18 (first published: 2013-11-11)
1,490 reads
PowerShell – Service Comparison GUI Tool
Service Comparison GUI Tool does comparison of all the services of any given two servers. The output is a grid view...
2013-11-11
1,685 reads
Testing network throughput with iperf
Have you ever wondered if that black box in your datacenter called the network is performing as well as it...
2013-11-20 (first published: 2013-11-11)
2,210 reads
Notes From SQLSaturday #248
For once the drive from Orlando to Tampa went smoothly, no delays due to accidents or construction or UFO’s, a...
2013-11-11
612 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 1
A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly...
2013-11-11
1,048 reads
PASS Data Architecture VC presents Steve Simon–Challenges to Designing Financial Warehouses
Please join the Data Arch VC with Steve Simon this Thursday Nov 14th at noon central for a great look...
2013-11-11
614 reads
A better way to find missing indexes
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a...
2013-11-11
992 reads
My SQLRally Experience
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got...
2013-11-11
791 reads
SSRS Map Layers Parameter
With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If...
2013-11-15 (first published: 2013-11-11)
1,513 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