SQL This, Not That – Episode 2
When creating a table with a column that will hold the name of a stored procedure that feeds an EXEC...
2009-04-30
1,439 reads
Suggested Reading: Microsoft SQL Server 2008 Administration with Windows PowerShell
Suggested Reading: Microsoft SQL Server 2008 Administration with Windows PowerShell
My earliest forays into writing powershell for SQL Server found me...
2009-04-30
2,271 reads
SQLSaturday #15 is May 2nd, 2009 in Jacksonville
My friend Brian Knight is leading the 2nd annual SQLSaturday in Jacksonville on May 2nd. Right now it looks like...
2009-04-29
1,329 reads
SQL Saturday Atlanta Recap
I had a great time at SQL Saturday Atlanta last weekend. I drove from Orlando to Atlanta on Friday with...
2009-04-29
1,535 reads
RE: Career Development and Training by Lynn Pettis
Thank you, Lynn, for your previous post. I have reinforced in my first blog posting on SSC about certification as...
2009-04-29
1,775 reads
The #1 Secret to Building Your Skill Set is...
Self-Discipline
Yes, I've said it: self-discipline.
I'm reading a book called Disciplines of a Godly Man by R. Kent Hughes. Now...
2009-04-29
1,985 reads
The Industry’s Best IT Certification
The Best 10 IT Certification
Every IT Technology has the importance and positive values to use for the business.So the people...
2009-04-29
1,599 reads
Google G1 Update - Protecting the Screen
Well it didn't take long. On a conference call a couple weeks ago, trying to juggle the phone, the laptop,...
2009-04-29
1,791 reads
Starting Conversations - Part 3
If you haven't already, start with Part 1 and Part 2. In Part 2 I mentioned that I have hired...
2009-04-28
1,420 reads
European PASS Conference 2009 Has 254 Attendees
The 2009 European PASS Conference, which was held April 22-24, 2009, had 254 attendees from 22 different countries. In spite...
2009-04-28
1,629 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