Update Your Scripts!
I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:
As...
2016-03-15 (first published: 2016-03-09)
3,022 reads
Quick PS script to get SQL Server Configuration Aliases - Syndication – WaterOx Consulting
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
804 reads
Notes from SQLSaturday Tampa 2016
Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...
2016-03-09
619 reads
Tuga IT 2016 – Registrations are open
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...
2016-03-09
602 reads
Notes From the February 2016 OPASS Meeting
I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...
2016-03-09
644 reads
SSC Editorial: Lessons From Little Green Army Men
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
529 reads
SSC Editorial: Spousal Surcharges
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
484 reads
SQL server on Linux
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,266 reads
Consider removing the NON EMPTY key word from the COLUMNS axis
You might have seen error message like this from a SQL job that pulls data from an OLAP cube using...
2016-03-14 (first published: 2016-03-08)
2,252 reads
SQL Server on Linux!
Looks outside: pigs are flying!
In an announcement yesterday, SQL Server will be made available on Linux. The private preview of...
2016-03-08
913 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