December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL...
2011-11-30
12 reads
Blog Posts
Download: Troubleshooting a day – Nov 2011
As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here....
2011-11-30
1,437 reads
Forgiving Mistakes
My main phone line at the house has been on the fritz for about 3-4 weeks. Yes, we still have...
2011-11-30
2,435 reads
GO statement breaks SSIS Execute SQL Task
I have lost an hour today trying to find a bug in my SSIS package, and it was so small...
2011-11-30
6,838 reads
It was a pleasure to work with the NomCom
With the announcement of the official slate for the BoD election for this year, the job of the NomCom is...
2011-11-30
2,571 reads
PASS Board Elections
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,330 reads
Saxophone Fire and Bad Words
There is nothing like having two children to remind you how strange, funny, and complicated language can be. Try answering...
2011-11-30
1,602 reads
SQLRally 2012 - Dallas Registration Is Open!
Want 2 days of Microsoft SQL Server training where you can hand-pick what you're learning about for the low price...
2011-11-30
2,041 reads
SQLRally 2012 Registration Open
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the...
2011-11-30
1,493 reads
Start Documenting Your Day! Why Now?
I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about...
2011-11-30
1,538 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