Database Fundamentals #18: The SELECT Statement
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
826 reads
Blog Posts
Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,575 reads
Monitoring Azure SQL Database
There are a number of options to monitor Azure SQL Database. In this post I will briefly cover the built-in...
2018-07-23 (first published: 2018-07-06)
2,455 reads
Off on Holiday
Another break for me. This might actually be the first year I use all my vacation allowance.
In any case, I’m...
2018-07-23
844 reads
Power BI Monthly Digest – July 2018
This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of...
2018-07-23
879 reads
Processes can dramatically improve your work until they don’t.
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
178 reads
PsPing your Azure SQL Server
PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...
2018-07-23
670 reads
Set up Instant File Initialization for SQL Server
When a space growth operation is done within SQL Server (create, restore, auto-grow) the engine places zeros across the file...
2018-07-23
135 reads
Taking the Linux plunge
I’m a Windows guy.
Kinda have had to be, given my profession as a SQL Server DBA. But recently I’ve become...
2018-07-23
310 reads
Why Availability Databases Are Not Synchronizing?
If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...
2018-07-23
947 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