Wait Stats Baseline Comparison – Idera Diagnostic Manager
Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes...
2016-02-22
692 reads
2016-02-21
283 reads
Introduction to Big Data
So you’ve been working as a DBA or a BI developer for several years now. You know your stuff very...
2016-02-21
364 reads
More SQL Saturday Precon News(Real-time Dashboards)!!!!
As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. ...
2016-02-19
1,251 reads
2016-02-19
520 reads
The Easy Phone Restore
This is hardware week for me, with a new phone coming in the mail. This was a warranty replacement for...
2016-02-18
769 reads
Flash sale – Discount for Chicago SQL Saturday Precon – This Afternoon Only
I’m running a flash sale discount for my upcoming Chicago SQL Saturday Precon called ‘SQL Server Infrastructure Tuning for Availability...
2016-02-18
462 reads
Azure SQL Database Error
I was on SQL Cruise where I was scheduled to present a session on Azure SQL Database. I recorded all...
2016-02-18
452 reads
CONVERT and HEX
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-02-17
8,186 reads
Azure SQL Database security
Life we be so much easier if we could just trust everyone, but since we can’t we need solid security...
2016-02-17
984 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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