Natural vs Artificial Primary Keys
There has been a long standing debate over the use of a natural primary key vs an artificial one. I...
2016-08-29
1,295 reads
Sql Server - Index Utilization Report
Index Utilization Report
One day my manager came and told me that he need Index Utilization Report.
He felt that during...
2016-08-29
576 reads
Why SQL Server Database Is In Recovery Mode?
The SQL Server whenever it restarts all the databases goes into the recovery mode. In this state the database comes...
2016-08-29
11,804 reads
Remote Desktop Workflow Improvements
Remote server management is a fact of life for folks involved with sql server. Since we work so often with...
2016-08-29
181 reads
Making Start-Demo work with multi-line commands without a backtick
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
544 reads
Remote Desktop Workflow Improvements
Remote server management is a fact of life for folks involved with sql server. Since we work so often with...
2016-08-29
666 reads
CISL 1.3.1 is released
I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!
Do...
2016-08-28
608 reads
When should I use a CTE?
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
779 reads
Understanding the Different States of SQL Database
Overview
There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in...
2016-08-27
551 reads
Organizing a SQL Saturday – Part 1 – Why Do It?
To kick off this series, I thought it would be worthwhile to discuss why it is I step up to...
2016-08-26
444 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