PASS Summit 2011 Session Evaluations
Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...
2011-12-15
1,085 reads
Why Do I Blog? #meme15
As I mentioned in a post last week, a new meme has been born. This one is dedicated to discussing...
2011-12-19 (first published: 2011-12-15)
1,559 reads
Why I Blog – #Meme15
A fellow blogger and SQL guy, Jason Strate (@stratesql) started a meme on Social Networking as a result of a...
2011-12-15
575 reads
How many times the T-SQL inside the CTE is executed?
Introduction
Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...
2011-12-19 (first published: 2011-12-15)
11,580 reads
How to change the SQL Server service account
It’s easy. First you click here:
Then you find the SQL Server 2008 or 2008 R2 program group
Open those and then...
2011-12-15
21,854 reads
Will You Buy Refurbished? Part 2
Yesterday I shared the small adventure of buying a refurbished laptop. While I was at Compusa looking at laptops I...
2011-12-15
867 reads
PASS Board of Directors – Who I’m Voting For
I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...
2011-12-15
673 reads
#meme15 – Why Do You Blog?
Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15. The overall topic of #meme15 will be social networking, obviously...
2011-12-15
622 reads
SQL Saturday 99 – SSWUG Interview
Welcome to the fifth of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-15
811 reads
Why I blog #Meme15
I’d seen various #meme tweets on twitter but it wasn’t until I saw this blog by John Sansom (Blog|Twitter) that...
2011-12-15
483 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