Baton Rouge SQL Server User Group
I will be speaking at the February Baton Rouge SQL Server User Group meeting on Wednesday the 8th. The session...
2012-02-06
682 reads
Blog Posts
Building or Buying a Desktop Based Development and Test Database Server
Back in April of 2011, I wrote a post that compared the merits of using an ancient, but actual rack...
2012-02-06
1,424 reads
Introduction to XML DML (Part 3) - Using the modify() method: delete
This is the last part of a 3 part blog which will attempt to show some different ways of how...
2012-02-06 (first published: 2012-02-02)
10,313 reads
Kindle Fire Update
We’ve had two of them since right after the launch and overall I’m pleased. They get used quite a bit...
2012-02-06
580 reads
Meme Monday - Working with Deadlines.....
Hi, all! It's been a while, since I posted a blog entry, and is directly related to today's Meme Monday...
2012-02-06
1,910 reads
Meme Monday: Deadlines
Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some...
2012-02-06
1,220 reads
SQL Rally 2012 Vote For Me!
Hello Dear Reader! Last year I tossed my hat in the ring on the world of Presenting. This was a...
2012-02-06
772 reads
Why Every DBA is a Clown
It’s late, really late and you’ve got a mountain of work to get through to meet the deadline. To add...
2012-02-06
997 reads
A Script A Day - Day 5 - Database Owner Permissions
Today's script will list all principals with membership in the db_owner fixed database role.
/* ----------------------------------------------------------------- Database Owner Permissions ----------------------------------------------------------------- For more SQL resources, check...
2012-02-05
1,138 reads
SQL Express and the Curse of the Perfmon Counters
On a dark and spooky night in the land of SQL Server make-believe, a young warrior was asked to slay...
2012-02-05
1,152 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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