Free Online SQL Server Training for the Week of November 24, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-22
357 reads
It sure would be grand to have interesting interviews
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
540 reads
Friday Followup For November 22, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-22
477 reads
Free Online SQL Server Training for the Week of November 24, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-25 (first published: 2013-11-22)
5,340 reads
How many heap tables do you have? :Quick Tips
Nothing exciting, just a general script. How can you see what heaps you have laying around?
exec sp_MSforeachdb @command1 ='
use [?]
SELECT...
2013-11-22
904 reads
JFK
“There is little value in ensuring the survival of our nation if our traditions do not survive with it. And...
2013-11-21
636 reads
Guest blog post at SQLAuthority – How many vCPUs are too many?
Last night my first guest blog pots over at SQLAuthority has gone live! It is the next in the “Notes...
2013-11-27 (first published: 2013-11-21)
1,398 reads
Powershell in a Month – Day 3 – Commands
This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month...
2013-11-21
1,338 reads
Power BI for Office 365 video
A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power...
2013-11-28 (first published: 2013-11-21)
2,072 reads
Learn About PCI Today
I’ll be presenting PCI for the SQL DBA today at 1 pm EST for the PASS Security Virtual Chapter. Depending...
2013-11-21
629 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