PASS Summit 2011 Day -2 (Monday), part 2
Today was a good day. I posted about the first part of today earlier, and we left off there with...
2011-10-11
519 reads
Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.
Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don’t have...
2011-10-11
1,257 reads
Using Custom Code Functions in Reporting Services Reports
Reporting Services is one of those tools that just keeps on giving. I’ve been using SSRS since the early beta...
2011-10-11
2,865 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,308 reads
Hardware 301: Diving Deeper into Database Hardware
On Wednesday, October 12, at 10:15AM, I am going to get the pleasure of presenting my Hardware 301: Diving Deeper...
2011-10-11
1,105 reads
Resource Governor clamps down on Greedy Reports
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,309 reads
PASS Summit 2011: Day One
After getting a little lost from the rail to the hotel, I finally got to sleep Sunday night after a...
2011-10-10
517 reads
New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,351 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2011-10-10
912 reads
MADPASS Follow-Up
A couple weeks back, I drove out to Madison to present at the MADPASS user group. These guys have a...
2011-10-10
531 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