Azure DevOps–Using Variable Groups
I was in a webinar recently and saw a note about variable groups. That looked interesting, as I’ve started to find that I may have lots of variables in...
2020-11-06 (first published: 2020-11-02)
250 reads
2020-11-01
35 reads
Azure SQL Database administration Tips and Hints Exam (DP-300)
Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during the journey of study I watched many courses, videos, and articles, and...
2020-10-31
34 reads
Azure SQL Database administration Tips and Hints Exam (DP-300)
Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during the journey of study I watched many courses, videos, and articles, and...
2020-10-31
345 reads
Persistent Server Name Metadata When Deploying SQL Server in Kubernetes
In this post, we will explore how a Pod name is generated, Pod Name lifecycle, how it’s used inside a Pod to set the system hostname, and how the...
2020-10-31
15 reads
Persistent Server Name Metadata When Deploying SQL Server in Kubernetes
In this post, we will explore how a Pod name is generated, Pod Name lifecycle, how it’s used inside a Pod to set the system hostname, and how the...
2020-11-06 (first published: 2020-10-31)
215 reads
Quick Start to Using Influxdb on Macos
Intro
OSS 2.0 is a release candidate at this time, so this may change once it’s released.
It wasn’t quite clear to me how to get up and running quickly with...
2020-11-05 (first published: 2020-10-31)
754 reads
Hadoop Workflow Automation using Apache spark and Oozie
Introduction The real-time data representation often requires quality content. In most cases, users flooded with multiple options or methodologies that may overwhelm the user to opt for the right...
2020-10-30
27 reads
Hadoop Workflow Automation using Apache spark and Oozie
Introduction The real-time data representation often requires quality content. In most cases, users flooded with multiple options or methodologies that may overwhelm the user to opt for the right...
2020-10-30
54 reads
Error: 8623 - The query processor ran out of internal resources and could not produce a query plan
Unfortunately a common error in many of our client environments is this:
--
Error: 8623, Severity: 16, State: 1. The query processor ran out of internal resources and could not produce...
2020-11-05 (first published: 2020-10-30)
1,213 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