MVPs
I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...
2017-01-20
670 reads
Adding Application Name to Invoke-SqlCmd2
In a previous post, I expressed some frustration over Invoke-SqlCmd not setting an Application Name for its ODBC connection, leaving us with the generic .NET SqlClient Library when looking at active sessions...
2017-01-20
68 reads
What is a Database Master Key?
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-01-19
17,117 reads
Webinar: Introducing Minion CheckDB!
Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two...
2017-01-19
833 reads
Help me raise money for cancer research #tourneeminerale
In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be...
2017-01-19
563 reads
SQL Server - Monitoring Table Size
There are many situations when we want to know the size of our database tables or just need a list...
2017-01-19
713 reads
Speaking at PowerShell Virtual Group of PASS
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session...
2017-01-19
11 reads
Speaking at PowerShell Virtual Group of PASS
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for...
2017-01-19
356 reads
Find and fix SQL Server databases with empty owner property using dbatools PowerShell module
A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”....
2017-01-19
1,140 reads
SQL Server 2016 Bug in R Integration?
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using...
2017-01-26 (first published: 2017-01-19)
1,473 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...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
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