PASS Summit 2009 - PowerShell and Performance
Over the weekend I received the great news that I've been selected to present a new session, Gather SQL Server...
2009-06-15
361 reads
Better Know A SSIS Transform – The Pivot Transform
This is part 1 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-06-15
1,700 reads
Notes on SQLSaturday #12 in Portland
I didn’t attend, but wanted to get this written down somewhere!
I’m just catching up on email, Ken Starnes said all...
2009-06-15
545 reads
Update on PASS Selection
I received my notification from the PASS Program Committee on Friday evening,
and found out that I will not be...
2009-06-15
605 reads
What I Learned at PASS
There’s a contest going on at PASS looking for answers to “Best Thing I Learned at PASS”. I don’t want...
2009-06-15
1,074 reads
Finding a New Laptop Bag – Progress!
Way back on May 19 I wrote about my search for a new laptop bag to replace my somewhat tattered...
2009-06-14
722 reads
SQLSaturday #19 Call for Speakers and Registration – East Iowa, October 10, 2009
Michelle Ufford (aka SQLFool) is leading the first SQLSaturday in Iowa at the University of Iowa in Iowa City on...
2009-06-14
765 reads
What I’ve Read and Recommend to Others – SQL Server 2008 Part 1
I read, a lot. I’ve been a prolific reader all my adult life.
I use to split my reading between...
2009-06-14
1,138 reads
Thanks, Brian!
This past Tuesday, Brian Knight visited the St. Louis SQL Server User Group to present on SSIS. The day ended...
2009-06-14
565 reads
PowerShell Whitepaper Published
My first whitepaper for Microsoft, Understanding and Using PowerShell Support in SQL Server 2008 has been published. It was a...
2009-06-13
394 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