Setup AD for AlwaysOn Listener

Setup AD for AlwaysOn Listener

When you create a new Availability Group there are a couple of administrative tasks that should be completed before creating your Availability Group within SQL Server. This will elevate any domain permission issues when you are trying to create your Availability Group...
How to Enable TDE on Availability Group

How to Enable TDE on Availability Group

Transparent Data Encryption(TDE) encrypts SQL and azure database files by encrypting data at rest. In a situation where your physical media such as data, log and backup files get stolen the malicious party can restore/attach the database and retrieve data. TDE...
What’s New in SQL Server 2017

What’s New in SQL Server 2017

You may have heard a lot of talk about some new features and enhancements coming with SQL Server 2017 and for good reason. From database administrators to developers and report writers, there’s something new and exciting for just about everyone. While the...
Linked Server Push Pull Blog

Linked Server Push Pull Blog

There are times when a Developer or DBA needs to determine the best performance options with transferring data through a linked server from point A to point B but may not know the best way to do it. In the following example, I am going to show you the differences...