Pinned Tabs
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...
2016-10-10 (first published: 2016-09-27)
2,053 reads
Part 1 - Detecting and Monitoring Memory Pressure
I will be writing
this article in four parts because this topic is huge and amount of information
can be overwhelming for...
2016-09-27
501 reads
TSQLCircleLive: What will be the result of the query below? Explai...
TSQLCircleLive: What will be the result of the query below? Explai...: select case when null = null then 'True' else 'False'...
2016-09-27
366 reads
SSMS 2016& Azure SQL DBs
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,506 reads
SQL Relay 2016
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and...
2016-09-27
505 reads
Future DBA – Hive Big Data 2
In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is...
2016-09-27
411 reads
What will be the result of the query below? Explain your answer?
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
155 reads
Different types of ANSI standard joins
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
310 reads
What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
190 reads
Query Store and What Happened Earlier On Your Server
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,876 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