TechNet Virtual Labs
There is an excellent site called TechNet Virtual Labs that enables you to quickly and easily evaluate Microsoft’s newest products and...
2011-12-14
1,087 reads
Blog Posts
Temporary Post Used For Theme Detection (34836190-9a25-42fe-be54-415469756264 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (4211c8dc-abcd-4ab4-b505-10f305aa9533 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2011-12-14
548 reads
2011-12-14
627 reads
Will You Buy Refurbished? Part 1
A couple months back the laptop my wife uses was fading away, the internal power connector was broken/barely working and...
2011-12-14
644 reads
Adding Servers to SQL CMS (Central Management Server) using Powershell
One challenge I’ve had recently is getting a list of servers imported in to a CMS (Central Management Server). While...
2011-12-13
5,159 reads
CPU Count
I document the CPU Count for SQL Server inventory management.
Using a powershell script , iterate through all the SQL Servers and...
2011-12-13
1,003 reads
SQL Saturday 99 – Emergent Networks Interview
Welcome to the fifth of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-13
656 reads
The Shredder Challenge
The Shredder Challenge was a contest sponsored by DARPA to find ways of putting shredded documents back together. Take a...
2011-12-13
852 reads
T-SQL Tuesday #025 – Holiday Gifts
Tis the Season It is the season for TSQL Tuesday. More importantly it is the season for giving and reflection. And whether you celebrate Christmas or Chanukkah or Kawanzaa...
2011-12-13
14 reads
T-SQL Tuesday #025 – How to view the size of all your databases – #TSQL2sDay
It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday...
2011-12-13
880 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