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

by souLTower

SQLServerCentral.com

Data cleanup

Learn how to clean bad characters from lots of data in this article.

SQL Server is Lagging a Bit

by Steve Jones

SQLServerCentral.com

Editorial

The SQL:2016 standard is out in draft and SQL Server lags a bit.

Generating HTML from SQL Server Queries

by Additional Articles

SimpleTalk

HTML

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

by Steve Jones

SQLServerCentral.com

Editorial

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

by Bogdan SAHLEAN

SQLServerCentral.com

SQL Server

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

by Additional Articles

Database Journal

Transaction Log

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.