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

Delivering Migration Projects on Time

I did a couple great sessions yesterday for the awesome Dallas Oracle User Group, (DOUG.)  It was the first time I did my thought leadership piece on Making Sense of the Cloud and it was a great talk, with some incredible questions from the DOUG attendees! This points me to a great [older] post on things […]

Read More Delivering Migration Projects on Time
April 28, 2017

Tags: , ,

The Chicken Before the Egg of Cloud Migrations

For over a year I’ve been researching cloud migration best practices.  Consistently there was one red flag that trips me that I’m viewing recommended migration paths.  No matter what you read, just about all of them include the following high level steps: As we can see from above, the scope of the project is identified, requirements laid […]

Read More The Chicken Before the Egg of Cloud Migrations
April 18, 2017

Tags: , ,

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: , ,