SQLSaturday#59 Update! - 3 weeks to go.....the after PASS East Coast Special!
SQLSaturday#59 Update!
Well, the event is now less than 3 weeks away (better finish my presentation 🙂 and there are 450+ attendees...
2010-11-01
571 reads
Android Adventures–Part 1
I’ve used a Blackberry for the better part of 10 years, loyalty built because as a phone and an emailing...
2010-11-01
392 reads
Finding Your Dream Job
My pre-conference session for the SQL Rally conference in the spring is called “Finding Your Dream Job”. Chris Shaw ( LinkedIn...
2010-11-01
659 reads
November Question: What steps do you include in your database maintenance?
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-01
1,440 reads
Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server
Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation...
2010-11-01
710 reads
Leaving (for) Las Vegas
Tomorrow I’m off to Las Vegas for SQL Connections. Since tomorrow is also T-SQL Tuesday #012, I’m writing a pre-trip...
2010-11-01
429 reads
“Wear Your SQL Saturday Shirt Day”
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country...
2010-11-01
879 reads
Vote for Our SQL Rally PreCon
VOTE VOTE VOTE VOTE VOTE VOTE VOTE!!!!!!!!!!
Vote here: http://www.zoomerang.com/Survey/WEB22BD59JCQBT
Honestly, I want each of reading my blog to vote for our...
2010-11-01
493 reads
SQLServerCentral.com Track at SQL Server Connections This Week
If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...
2010-11-01
632 reads
Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)
Below is a longer version of the equivalent Technet Article under Security TechCenter > Learn > Security Columns > MVP Articles > Database Security Best PracticesThe security of...
2010-10-31
5,341 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