SQL Server 2016 real-time operational analytics
SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both...
2016-08-24
679 reads
1 Day Workshop – Columnstore Deep Dive (in German) on 6th of October 2016
To support more and more people jumping to Columnstore INdexes, OH22 have decided to open another public 1-day deep dive...
2016-08-24
418 reads
Master Data Services Insufficient Memory Error
A business case that requires the usage of Master Data Services finally landed in my desk. As part of delivering...
2016-08-24
640 reads
Copying an on-premise Database to an Azure SQL Database
Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud....
2016-09-06 (first published: 2016-08-24)
1,839 reads
Finding the Right Path
What is this gaping hole in the coverage of Extended Events? To be honest, it is not a very complicated topic or very difficult gap to fill. It's just...
2016-08-24
11 reads
Finding the Right Path
I have a fairly large backlog of articles that are in progress or that are planned for my series about...
2016-09-05 (first published: 2016-08-24)
1,493 reads
10 on Tech Podcast – To The Cloud and Back Again
On episode of one of our favorite podcasts – 10 on Tech from ActualTech Media – recently focused on a discussion with James...
2016-08-24
436 reads
Resolve Microsoft SQL Server Error Code 824
Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the...
2016-09-01 (first published: 2016-08-23)
3,135 reads
SSMS - Connection Color with SQL Prompt & SSMSBoost
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you...
2016-08-23
231 reads
I am speaking at SQL Saturday Pittsburgh 2016!
I will be presenting my third SQLSaturday session at the upcoming Pittsburgh #545 Saturday, Aug. 13th, 2016. My session, Stretch Database and Managed Backups: Cloud Services for your SQL...
2016-08-23
10 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