Scoring Outliers in Non-Normal Data with R
Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?
Azure Automation Methods
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
Replace Bad Characters in Table
Learn how to clean bad characters from lots of data in this article.
Generating HTML from SQL Server Queries
You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.
Classifying Sensitive Data
The ability to protect, and perhaps handle, sensitive data separately from other data is becoming more important. Steve Jones discusses the process and asks if it's something you perform on a regular basis.
Filegroup Restoring and Database Consistency
In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.
How to Read the Transaction Log File
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
Improving Replication
If you have ideas for how to improve replication, Steve Jones is asking for them.
The Forgotten Editorial
Phil Factor reflects on the occasional benefits of document loss, whether accidental or less so.
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