Additional Articles


Masking Data in Practice

Phil Factor takes a strategic look at common SQL data masking techniques, and the challenges inherent in masking certain types of sensitive and personal data, while ensuring that it still looks like the real data, and retains its referential integrity, and distribution characteristics.

2021-01-11

SQL Server Error Log

The SQL Server error log is a great source of information for DBAs for monitoring errors and the operation of the server. In this article, Greg Larsen explains the details and how to configure the SQL Server error log.

2021-01-08

The Joy of Realistic Generated Fake Database Data

Have you ever had to demonstrate a database-driven application, and longed to have the real data to do so? To do what, precisely? Well, so you can then scroll through the customers who have used the system, demonstrate the accounting and audit, browse through the products, maybe even demo the customer tracking system with comments, complaints and so on. All this is possible, using realistic, fake data.

2021-01-08

Blogs

2020 Advent of Code–Day 1

By

This series looks at the Advent of Code challenges. I started the Advent of...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)

By

Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series

By

Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

Read the latest Blogs

Forums

How to find index usage by stored procedure?

By SQL Guy 1

Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...

Odd things with Report Builder (also tried VS 2019)

By kevlray

This is kinda hard to explain, maybe I can make sense of it. So...

PBM policy to check empty passwords

By Lou

Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers