The Powershell Challenge–Notes and Observations
It’s been a month and a half in real time since I started the Powershell Challenge. In that time, I...
2014-01-03
1,218 reads
Reblog: December 27 to January 2
Photo credit – Scott Howard
I’ve always been a fan of the feeling when I find an old blog post that’s got...
2014-01-03
366 reads
Speaker of the Month, January 2014
A whole new year. Cool.
I was at SQL Saturday DC, #233, at the beginning of December. I sat through several...
2014-01-03
755 reads
Day 10 – Retention of XE Session Data in a Table
Gathering event information is a pretty good thing. It can do wonders for helping to troubleshoot. What do you do if you need or want to be able to...
2014-01-03
15 reads
Day 10 – Retention of XE Session Data in a Table
This is the tenth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-03
922 reads
Throwing Spaghetti At The Wall Isn’t The Worst Plan
I get a lot of email about job opportunities, almost none of which interest me enough to call back about...
2014-01-03
290 reads
Friday Followup For January 3, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-03
413 reads
2013 – A Year In Review
It is in our nature as humans to look back in order to understand where we have been.
Warning – some of...
2014-01-03
731 reads
Setting up the Min and Max Memory options on the fly – Word of caution !
Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...
2014-01-02
835 reads
Reflections on 2013
2013 was a year of incredible growth, change, and challenge for me. This last year has been an amazing roller coaster...
2014-01-02
627 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