Rights for one table
I ran across a thread that was asking how to grant rights to a person for one table only, and...
2010-09-16
1,343 reads
Do You Have Influence? Part 1
Most people blog because it’s fun, rewarding, good way to improve writing skills, be cool, and it looks good on...
2010-09-16
1,013 reads
Notes from the Sep 13, 2010 oPASS Meeting
Jack led the meeting tonight, spending a good amount of time on SQLSaturday, and Kendal Van Dyke did his marketing...
2010-09-16
597 reads
Hardware 201:Selecting and Sizing Database Hardware for OLTP Performance
I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot...
2010-09-16
823 reads
What is all that hot air? Oh I'm speaking all over the place!
Many of you have been wondering where I will be speaking next. So I apologize for not replying to you...
2010-09-16
492 reads
Let PASS help you get a job!
With so many folks out there struggling and loking for new opportunities you may want to take some time away...
2010-09-16
337 reads
Ready Set Go
I thought I would pass along something I learned this week about batches in TSQL. I always knew about the...
2010-09-16
380 reads
Presenting At Sarasota SQL Server Users Group On Sept. 21
On Tuesday, September 21, I'll be at the Sarasota SQL Server Users Group to present Paging DR Availability, You're Wanted...
2010-09-15
429 reads
September PASSMN Meeting Next Week
Ever feel like you are all alone? Maybe a little isolated? This month’s PASSMN meeting might bring up these feelings...
2010-09-15
629 reads
Know a young IT go-getter? Get her nominated!
Yesterday, I told our Groupies: I feel give-y today. Is there anything you’d like me to promote for you? Wendy...
2010-09-15
480 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