Expert SQL Server 2008 Encryption
Encryption is a tough subject, but it’s one that’s fascinated me for years. I downloaded PGP when it came out...
2009-10-26
1,060 reads
One Week until PASS 2009
It's one week until the PASS Summit. At this time next week I'll be on a plane, heading to Seattle...
2009-10-26
683 reads
SQLSaturday Sensation in NJ
Well, it's a wrap! Saturday has come and gone, but memories will go on. It was great to see so...
2009-10-26
758 reads
My Eval Results from SQLSaturday #21
I presented Social and Not So Social Networking for the DBA. Of the attendees, 16 submitted an eval. Here are...
2009-10-25
560 reads
Business Cards – Again
I posted some thoughts on business cards awhile back, had used up the ones I had and was time to...
2009-10-25
684 reads
SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,881 reads
Phil Factor SQL Speed Phreak Competition
If you have a database application that is running slowly, or is straining the server, what do you do? After...
2009-10-25
3,166 reads
Red Gate Has 10th Birthday
I first met Simon Galbraith, one of the co-owners of Red Gate Software at PASS in 2002, when they had...
2009-10-24
410 reads
Tricks and issues Part 1
Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see...
2009-10-23
654 reads
SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
2009-10-23
7,096 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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