Notes from Mission Critical Environments in SQL Server 2012, Webinar by Marc Theoret
The other day I sat in while Marc Theoret gave a great overview of the what is coming in SQL...
2011-12-11
1,439 reads
Blog Posts
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,704 reads
A PASS Board Of Directors Endorsement
One of the requirements for the PASS Board of Directors application was a collection of recommendations - 3 from volunteers, 3...
2011-12-09
900 reads
My Recipe for Chocolate Pie
One of our small holiday traditions is that we bake at least one home made dessert. Hard to beat the...
2011-12-09
659 reads
PASS Board Of Directors Voting Open Through Dec. 20
Voting for the 2011 PASS Board of Directors elections started earlier this week and if you were a PASS member...
2011-12-09
684 reads
PASS Speaking Results
I got the PASS speaking results today on the new speaker portal. They posted the top sessions as well, overall...
2011-12-09
1,114 reads
Re-blog – December 2 – December 8
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-09
562 reads
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,186 reads
SQL Database Status with sys.databases
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column...
2011-12-09
859 reads
SQL Server MVP Deep Dives Volume 2 – My Review
Volume 1 was packed full of knowledge and a very welcome edition to my bookshelf! With the bar already set...
2011-12-09
850 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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