Infrastructure at your Service

All posts by Nathan Courtine

Nathan Courtine
Consultant

Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer’s Degree in Computer Science from the ENSISA (Ecole Nationale Supérieure d'Ingénieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services / Banking, etc.
Nathan Courtine

Personal road trip – PowerShell Conference EU 2017

By | Database Administration & Monitoring | No Comments

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… Then, lights turned on and all the speakers stood up and come behind the scene. As you may see, they came from all around the worlds to bring us the best of PowerShell!   This Open Ceremony…

 
Read More
Nathan Courtine

Configure easily your Stretch Database

By | Database Administration & Monitoring | No Comments

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. This mechanism offers to use low-cost hard drives available in Azure, instead of fast and expensive local solid state drives. Indeed SQL Database Server resources are solicited during data transfers and during remote queries (and…

 
Read More
Nathan Courtine

Manage Azure in PowerShell (RM)

By | Database Administration & Monitoring, Hardware & Storage, Operation systems | No Comments

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 the same time in Azure, they are different and managed differently: in PowerShell cmdlets are specific to RM. In order to be able to communicate with Azure from On-Premises in PowerShell, you need to download and install the Azure…

 
Read More
Nathan Courtine

Generate Azure VM with Resource Manager deployment in PowerShell

By | Database Administration & Monitoring, Hardware & Storage, Operation systems | No Comments

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 not the initial goal, and it already exists a very good Microsoft topic on this subject. In this blog, we will generate a new Windows Azure Virtual Machine using Resource Manager deployment with PowerShell from On-Premise. Remember,…

 
Read More
Nathan Courtine

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

By | Database Administration & Monitoring | No Comments

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 with a SQL Server instance I will proceed this installation on SQL Server 2014 running under Windows Server 2012 R2. To be coherent with the other RDBMS examples, all the manipulation will be made on Windows core. Yes, it is…

 
Read More
Nathan Courtine

syspolicy_purge_history job and PowerShell ExecutionPolicy

By | Database Administration & Monitoring | No Comments

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? And what is it for? Since SQL Server 2008, a new feature called Policy Based Management has been added. When your policies are run, the results are stored in the msdb. But without a purge mechanism, msdb will keep growing. So…

 
Read More
Nathan Courtine

Configurer les “Bonnes Pratiques” de Windows Server avec PowerShell

By | Database Administration & Monitoring | No Comments

PowerShell est un outil en ligne de commande dorénavant intégré à tous les environnements Windows. Cet outil est extrêmement puissant, et avec le vent en poupe, puisqu’il permet de simplifier l’exécution et l’automatisation des tâches de configuration et d’administration. Dans mon travail d’Administrateur de bases de données, j’effectue de nombreux Audits d’environnements afin de vérifier, par exemple, si les bonnes pratiques sont bien appliquées. C’est pourquoi j’ai été très vite confronté à PowerShell, afin de…

 
Read More
Nathan Courtine

SQL Server Database failed to generate a checkpoint

By | Database Administration & Monitoring | One Comment

Last time, I experienced a strange error when I tried to perform an integrity check or a simple checkpoint of a database: One or more recovery units belonging to database ‘mydatabase’ failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure. The log scan…

 
Read More
Nathan Courtine

Manipulate Stretch database feature by script

By | Database Administration & Monitoring | No Comments

On November 30th, I presented the Stretch Database feature in “Les Journées SQL Server 2015” in Paris. I explained how to manage by script this new feature in SQL Server 2016 CTP 3.0 I decided to share you my demonstration into a blog.   I – Enabling the feature at the instance level First, you need to enable the “Remote Data Archive” option at the instance level. To check if the options is enabled: sp_configure…

 
Read More
Nathan Courtine

SQL Server 2016 CTP2: Stretch database feature – Part 2

By | Database management | No Comments

In my previous blog SQL Server 2016 CTP2: Stretch database feature – Part 1, I explained how to prepare your instance and your database to enable the Stretch feature for your table. Now I present you how to enable the feature for your tables! Prerequisites Enabling Stretch Database at the table level requires ALTER permissions on this table.   Limitations For the moment in the SQL Server 2016 CTP2, there are several and important limitations,…

 
Read More