Piiiiiiiigs, er DBAs, in Space!
If you don't get the reference, it was a set of skits on the old Muppet Show and it starred...
2011-10-13
998 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
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
PASS Summit Attendees: Remember to Network and Maintain
Previously, when I had attended conferences, I had used them to attend as many seminars or talks as I could...
2011-10-10
1,416 reads
Advanced Persistent Threats and Us
In a blog post from last year, Richard Bejtlich (blog | twitter) talked about a concept called an Advanced Persistent Threat...
2011-10-07
1,326 reads
Detecting Security Updates on Vista/Windows 7/2008/2008R2
When trying to detect whether updates have been installed or not, there were several places we investigated:
HKLM\Software\Microsoft\Windows\CurrentVersion\UninstallHKLM\Software\Microsoft\WindowsNT\CurrentVersion\HotFixHKLM\Software\Microsoft\UpdatesSome updates still write to...
2011-10-06
2,718 reads
Two Great Talks on the State of Internet Security
Recently I've started following the public work of Mikko Hypponen (blog | twitter), the Chief Research Officer of F-Secure. I've known...
2011-10-05
1,044 reads
Have end users who need an introduction to SQL Server book?
At the beginning of this year, my introductory text to SQL Server, appropriately titled Introduction to SQL Server, became available for sale....
2011-09-19
1,340 reads
Looking to interact with those proficient in Japanese
In the 1970s my mother and her younger sister married U.S. Marines. Both came to the States when their husbands...
2011-09-12
806 reads
Don't Wait to Start Blogging
I was reading a post by Jonathan Fields (blog | twitter) about making bad guitars. Okay, so what does that have to...
2011-08-15
2,255 reads
Have the Time? Get in the Game.
This year there's a two step process for electing members to the Professional Association for SQL Server (PASS) Board of Directors...
2011-08-11
895 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