SQL Provision

Creating Test Data

  • Editorial

Test data is hard to come by, and I agree with Brent Ozar: " I get so frustrated when I hear trainers/presenters/bloggers/idealists talk about how developers should be using purpose-built-from-scratch data sets with no real customer data in ’em. The real world just rarely works that way." I agree, and I know this is a […]

5 (1)

2020-01-09

280 reads

Dealing with Server Objects, Settings and Features when Provisioning Databases

  • Article

If we want the behavior and performance of our test databases to mimic that observed in production, then we must consider not only the database but also the server. Grant Frtichey reviews the server-level objects, settings and features that we may need to consider, and then shows how to 'synchronize' the linked servers, user logins and SQL Agent jobs, as part of an automated provisioning process, using SQL Provision.

2019-07-26

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

Azure Data Engineer Associate

By

You can read about all the new role based qualifications from Microsoft here –...

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Update table and then executeJob in loop

By khushbu

I need to write a query which will first update the table, then execute...

Using two different backup products for each of data and log

By Fal

  To shorten a long story, my organisation has decided to have a vendor...

Compare sql-2012 and sql-2016 settings

By rohitkocharda

Hi everyone, W are just doing a migration from sql 2012 enterprise  to sql...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers