Nathan Courtine

Automate CNOs and VCOs for SQL Server AAG

During the installation of a new SQL Server environment in a Project, we wanted to automate the whole process deployment and configuration when installing a new SQL Server Always On Availability Group (AAG). This installation requires to prestage cluster(…)

Restore S3 Object with AWSPOWERSHELL

AWS S3 offers different Storage Classes, allowing to optimize cost among others. For instance, some classes are used for archiving purposes: S3 Glacier and S3 Glacier Deep Archive. It means the(…)

Transparent Data Encryption – Certificate in master database: is it really a good practice?

As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That's why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on(…)

PASS SUMMIT 2017 – SQL Server Security

Today is the first day of the PASS SUMMIT 2017 in Seattle (WA). The weather is cloudy and we have only 11°C… but where is the problem? Everything happens inside! (at the Convention(…)

Personal road trip – PowerShell Conference EU 2017

Welcome to PowerShell Conference EU 2017 Started on April, 5th at 9:00 AM, I was immersed in a wonderful and amazing Open Ceremony among light effects and an epic music. Indeed, using PowerShell is always an epic moment…(…)

Configure easily your Stretch Database

In this blog, I will present you the new Stretch Database feature in SQL Server 2016. It couples your SQL Server On-Premises database with an Azure SQL Database, allowing to stretch data from one ore more tables to Azure Cloud.

Manage Azure in PowerShell (RM)

Azure offers two deployment models for cloud components: Resource Manager (RM) and Classic deployment model. Newer and more easier to manage, Microsoft recommends to use the Resource Manager. Even if these two models can exist at(…)

Generate Azure VM with Resource Manager deployment in PowerShell

Recently, there is a new way to manage the Azure infrastructure with Resource Manager. It brings many advantages regarding the classic deployment. The differences between these two deployments will not be covered in this blog because it is(…)

The (almost) same sample schema for all major relational databases (4) – MSSQL

In previous posts, my colleague Daniel Westermann explained how to install the “Dell DVD Store Database Test Suite” into PostgreSQL, Oracle and MySQL. This time, this is my job to present you how to proceed(…)

syspolicy_purge_history job and PowerShell ExecutionPolicy

Since SQL Server 2008, Microsoft has introduced a system job called “syspolicy_purge_history”. This job is installed and enabled by default, and it contains three steps scheduled at 02:00 AM:   What is this job?(…)