SQL Saturday #486 Richmond – A Window Into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-03-19
546 reads
Failover all databases to other server
Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way...
2016-03-18
846 reads
Previewing the new SSRS 2016 portal
Ran into an issue with the “Preview New Reporting Portal” link on a fresh install of 2016 giving me a...
2016-03-18
447 reads
Calculating Some Max Mirror Stats
This turned out to be quite a challenge. I couldn’t find anything that made this very clean and straight forward...
2016-03-18
419 reads
SQL 2012 SP3 and entity framework conflict
the problem
An issue with SQL Server 2012 SP3 was identified that impacted EF4/5 due to additional datatypes in the dll....
2016-03-18
7,501 reads
TFS Work-Item Fancy Filtering
If you want to create a TFS query that would identify work items that have changed, but were not changed...
2016-03-18
425 reads
Weird Things Happen with Windows Users
This will be no surprise to those who have been working with SQL Server for a long time, but it...
2016-03-18
744 reads
SQL Server Management Studio Preview
You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of...
2016-03-18
720 reads
Thoughts on the March 17, 2015 PASS Town Hall
I listened to most of the town hall today. The main topic was the just voted on changes to the...
2016-03-18
600 reads
What Database am I in?
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-03-17
576 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