Considerations When Using SQL Server 2016 Dynamic Data Masking

SQL Server 2016 introduced a new security feature called Dynamic Data Masking.  With the General Data Protection Regulations, (GDPR) breathing heavy down most IT in America’s neck, its good timing. “Data Masking” is a term that has a strict definition, but different results when we actually discuss the technology behind it.  The main goal is to […]

Read More Considerations When Using SQL Server 2016 Dynamic Data Masking
November 15, 2017

Tags: , , One Comment

Azure SQL Database- Automatic Index Management

As I begin my education in SQL Server 2017, as well as Azure SQL Database, my attention was caught by the optimizer improvements and especially automatic tuning. Often referred to with features starting with the naming convention of “dynamic” in Oracle, many automatic features either thrill or frustrate DBAs, no matter what the platform.  The […]

Read More Azure SQL Database- Automatic Index Management
November 9, 2017

Tags: , One Comment

Linux for the SQL Server DBA- Part II

So we’ve covered a few basics of a Linux host in Part I– The File System Users, groups Basic Commands with basic arguments And file and directory permissions Hopefully, what I share next will build on the first post and enhance your knowledge as you move forward with Linux. Reading the contents of a directory, […]

Read More Linux for the SQL Server DBA- Part II
October 19, 2017

Tags: , , One Comment

Preparing an AzureEnvironment- Part I

Azure is the second most popular cloud platform to date, so it’s where Delphix naturally is going to support second on our road to the cloud.  As I start to work with the options for us deploying Delphix, there are complexities I need to educate myself on in Azure.  As we’re just starting out, there’s […]

Read More Preparing an AzureEnvironment- Part I
March 30, 2017

Tags: , ,