Moving Forward with Nuclear
We use a lot of power in our computing infrastructure. And while I’m mindful of the concerns over safety, environment,...
2009-04-24
899 reads
SQL Server Security Basics: Why Would I Use SQL Server Authentication?
The standard best practice answer when it comes to connecting to SQL Server is to use Windows authentication. However, SQL...
2009-04-24
3,827 reads
PASS Summit Sessions Submitted
It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see...
2009-04-24
672 reads
Book Review: The Speed of Trust
I finally finished up reading the Speed of Trust and have to say I struggled with it. I'm a big...
2009-04-23
802 reads
Building Something Fun
A little further off topic than usual today, something not about technology and work for a change. Woodworking is one...
2009-04-23
1,412 reads
Spring Still Not Really Hitting Montreal Yet, thus More Time to Hunt Down Useless Indexes
Hopefully, by the time we have our annual family vacation in May, the Cherry Blossoms will be out – until then...
2009-04-23
760 reads
Simple Maintenance Tasks for Non-Production Databases
Log File Sizes:
It's not unusual to see cases where database backups are taken from production and restored to a development or QA environment....
2009-04-23
1,348 reads
Want a SQLSaturday Polo or Tshirt?
I've had a few requests for these, so I'll take orders through May 8, 2009. The polo is a very...
2009-04-23
833 reads
The Twitter Ripples
I saw this post on The Business of Software Blog about a use of Twitter to spread the word for...
2009-04-23
648 reads
The Google Containers
After my editorial on portable data centers, I had a number of people knock down the idea, saying it doesn’t...
2009-04-23
818 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