Windows Power Plans and CPU Performance
Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans...
2010-09-28
2,357 reads
Find the largest tables in a database
From time to time, I need to find the largest tables in terms of rows / used space / total space etc....
2010-09-28
33,398 reads
Open-Source Databases are Not Free, MySQL has a High Cost, According to MySQL.com Itself
After having a few heated discussions on Facebook in reference to Open-Source Relational Databases, I would like to refer those...
2010-09-28
1,201 reads
Knight's Microsoft Business Intelligence 24-Hour Trainer released
Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release. In this book you will learn about...
2010-09-28
976 reads
To Be There Or Not To Be There
Are you ready for Seattle? Have you registered for the PASS Summit? Hopefully with some good reasons you will be...
2010-09-28
682 reads
Performing a Cross Join (Cartesian Product) in SSIS
There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS. One of...
2010-09-28
4,392 reads
Do You Have Influence? Part 3
I talked about the basics of Influence in Part 1 and Part 2, today I’m trying something harder, showing you...
2010-09-28
718 reads
SQLSaturday #52 Report
I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate,...
2010-09-28
548 reads
Lessons from a Great Mentor
On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He...
2010-09-28
933 reads
SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
2010-09-28
2,016 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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