The Showdown
Today we have a guest post from Steve Jones.
I survived SQL in the City in LA, and thanks to everyone...
2011-10-31
1,559 reads
PASS Board Of Elections: Rob Farley
Be Part Of The Solution, Not The Problem
<disclaimer >
Now that BoD season is in full swing and I’m not running for...
2011-10-31
2,077 reads
Managing SQL Server in a Virtual World (rough) Notes, Thanks to Quest Presenter Jason Hall
Managing SQL Server in a Virtual World Notes (View Complete Slide Show)
Hosted by MVP Kevin Kline, Quest Software
Guest presenter...
2011-10-31
2,765 reads
PASS Summit 2012
Yes, I know you just got back from the 2011 Summit. Kinda like I just got back from vacation. But...
2011-10-31
1,471 reads
Two of a Kind
Here’s one that I haven’t run into before. A colleague scheduled a meeting with someone else in the organization to...
2011-10-31
1,674 reads
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about it, I wanted to try to better understand if...
2011-10-31
4 reads
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about...
2011-10-31
1,923 reads
Tales from the Query Processor
http://www.flickr.com/photos/socal_jim/2070088596/Hello Dear Reader! I've been a bit behind on the blogging but wanted to give you a bit of a...
2011-10-31
1,514 reads
Logical CPU, Physical CPU and hyper threading
Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.
-- Hardware information from...
2011-10-30
11,579 reads
Creating a Table Report with Dynamic Columns
Over time, similar reports may be designed from variations of common queries and datasets. Creating one report to meet all...
2011-10-30
2,761 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