Using Data Scanning to Identify and Classify Sensitive Columns
SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases.
2021-08-04
Additional Articles
Beautify HTML Tables in Emails for SQL Database Mail
In this article we look at how to format HTML tables sent via SQL Server Database Mail to make the emails and data easier to read.
2021-08-02
Overcoming Database DevOps challenges - Part 1
When integrating database changes into a DevOps process, the biggest challenge is to standardize and coordinate the different approaches to application and database development. Discover the key tools & training resources to help you and your team.
2021-08-02
How to enable SQL Server trace flags
DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to enable SQL Server trace flags.
2021-07-30
Share your favorite Redgate tool – win technical training from Pluralsight!
Level up your skills with Redgate’s latest competition. Redgate is giving you the chance to win a 3-month subscription to Pluralsight, the technical skills platform. To enter, visit the Redgate Forums and answer the question ‘What’s your favorite Redgate tool and why?’
2021-07-30
How Does Microservices Architecture Change Database Deployment?
Grant Fritchey discusses the relationship between microservices architecture and database deployment and how these two important pieces of the DevOps puzzle, can work together, or against each other in the future.
2021-07-28
How to query blob storage with SQL using Azure Synapse
How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.
2021-07-28
How to Compare Two SQL Prompt Styles
A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code.
2021-07-26
Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
Managing SQL Server transaction log size
The SQL Server transaction log must be managed to keep a database running and performing well. In this article, Greg Larsen explains how to manage the transaction log size.
2021-07-23
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Anyone have a SQL Server 2014 Developer Edition DVD?
Hi all, I’m looking for a SQL Server 2014 Developer Edition DVD. Does anyone...
How have you encouraged communication at work?
I do have a question. At work, some groups of people have an inordinate...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers