What Do You Mean There is No Current Database Backup?!?
Yet another late night/early morning tale...
The LOG backups for multiple databases on a server failed overnight (not all databases, but...
2015-12-03
980 reads
Atlanta BI Edition SQL Saturday Precon
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...
2015-12-03
920 reads
Goodness-of-Fit Testing with SQL Server, part 3.1: Skewness, Kurtosis and the Jarque-Bera Test
By Steve Bolton
…………In the last installment of this series of amateur self-tutorials on using SQL Server to identify probability distributions,...
2015-12-02
1,685 reads
Why I Joined Microsoft
If you follow me in social media, you may have seen my announcement that I’ve joined Microsoft. Late in October...
2015-12-02
608 reads
Idera #SQLChat with John Morehouse
Please join Idera tomorrow for a #SQLChat on Twitter. The December #SQLChat will take place Tuesday, December 9 at 11...
2015-12-02
505 reads
Webinar – Lowering SQL Server Licensing Costs
On Tuesday, December 15th, Bala Narasimhan and I are presenting a webinar where we will walk through real-world examples that...
2015-12-02
459 reads
Ending My Loop in PowerShell Early
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I...
2015-12-02
780 reads
Sentiment Analysis with Power BI
I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted...
2015-12-09 (first published: 2015-12-02)
4,240 reads
DBA Myths: Database file extentions
Every now and again I hear or read that the only file extensions for a SQL Server database are mdf,...
2015-12-10 (first published: 2015-12-02)
2,341 reads
SQLSatDC - Down in DC - 12/5
Saturday, December 5, 2015: SQLSaturday#470 is on track to be an extraordinary event in DC this Saturday, with a fantastic...
2015-12-02
1,174 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