SQL Provision

A Re-Introduction to HIPAA and SOX

  • Article

SQL Provision can help organizations ensure compliance with regulations such as HIPAA and SOX. But what exactly are these legislations asking of DBAs and how does this impact the work you do? Robert Sheldon provides an overview of the two US regulations in this four-part series.

2019-03-12

2,407 reads

Back to Basics; Masking Address Data

  • Article

Protecting Personable Identifiable Information is central to the compliance of numerous regulations which your organization may be subject to. In this article Grant Fritchey starts with the basics of obfuscating address data with the data masking technology in SQL Provision.

2019-03-07

3,101 reads

Protecting Credit Card Data when Testing

  • Article

Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can help you protect credit card data while maintaining characteristics and distribution of the real thing.

2019-03-05

2,916 reads

Blogs

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Read the latest Blogs

Forums

How to send queued emails

By dubem1-878067

After an upgrade,   sql server stopped sending emails.   Problem is not solved but during...

TLS 1.2 and Database mail

By miapjp

Hi, We use office 365, and just recently received an email from them saying...

Left join not pulling all from left table

By jeffshelix

T has 57,000 distinct rows Z has over a million.  I did row over...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers