Recording SQL Server Configuration Settings.
(I’m ‘standing in for Brad, who is busy ..er.. somewhere, and I found this unpublished piece by Brad and I....
2011-11-03
1,429 reads
Find Recently Run Queries
If you have ever closed a query window by accident only to wish you could get back your work an...
2011-11-03
4,005 reads
Dimensional Modeling Financial Data in SSAS pt2
Unary Operator and Aggregating over time
In my last post I discussed how to arrange all of the GLs into a...
2011-11-03
3,287 reads
Latest post from Bill Gates featuring Hans Rosling’s animated bubble graphs
I just caught a tweet from Bill Gates with yet another fascinating presentation from Hans Rosling on the Gates Notes...
2011-11-02
788 reads
My PASS Summit 2011 Experience
The 2011 PASS Summit is in the rear view mirror (has it really been almost three weeks now?)...and as always...
2011-11-02
951 reads
SQL Saturday #87 Report
I drove the over 250 miles from my home in Edwardsville, IL, to attend the SQL Server 87 in Louisville,...
2011-11-02
1,345 reads
Correction of my unfair and incorrect words against SQLWorkshops.com
On October 18, 2011 I have made unfair and incorrect words on Twitter, Facebook, LinkedIn,
and Xing against the owners of...
2011-11-02
778 reads
Salaried employee vs contractor
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and...
2011-11-02
4,132 reads
Presenting Tomorrow (Thursday) via Webinar - SQL Server Security
I have the privilege of being able to give a webinar tomorrow, November 3, at 11 AM EDT. It will...
2011-11-02
1,089 reads
Presenting at SQL Saturday #96
I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC...
2011-11-02
793 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