Infrastructure at your Service

All Posts By

Nathan Courtine

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
Nathan Courtine

SQL Server 2016 CTP2: Stretch database feature – Part 1

By | Database management | No Comments

SQL Server 2016 CTP 2 has introduced some interesting new features such as Always Encrypted, Stretch database, the configuration of the tempdb in the SQL Server installation, aso… Regarding the configuration of the tempdb in SQL Server 2016 CTP 2, I recommend you a good article called SQL Server 2016 CTP2 : first thoughts about tempdb database from David Barbarin. In this article, I will focus on the Stretch database feature! What is the Stretch…

Read More
Nathan Courtine

Get the main information from SQL Server databases with PowerShell

By | Database management | One Comment

As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell, I will present you this time how to retrieve the SQL Server databases information with PowerShell. Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your comments! Retrieve SQL Server databases information I use the SMO objects to access the instance…

Read More
Nathan Courtine

Get SQL Server Network Configuration with PowerShell

By | Database management | One Comment

This blog is part of a set which try to automate the SQL Server administration with PowerShell. It explains how to retrieve the network configuration of a SQL Server instance with PowerShell. I will refer to my previous blog Get SQL Server services with PowerShell. I presented how to get the SQL Server Engine service. I will assume the service has already been retrieved. Disclaimer: I am not a developer but a SQL Server dba….

Read More
Nathan Courtine

Get the main Administration Information from SQL Server with PowerShell

By | Database management | No Comments

In my previous blog Get SQL Server services with PowerShell, I presented you the first step of the SQL Server administration through an automated process. This blog is a follow-up of the previous one, and it will focus on retrieving information of a SQL Server instance with PowerShell Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your…

Read More
Nathan Courtine

Get SQL Server services with PowerShell

By | Database management | 2 Comments

SQL Server Configuration Manager and SQL Server Management Studio are the main tools to administrate the components of SQL Server. They are very convenient to use and pretty complete. But as soon as you wish an automated process, these tools have their limitations. Nevertheless, there is still the solution: PowerShell! This blog introduces a first step towards an automation process of SQL Server administration. I will retrieve all SQL Server services related to a specific…

Read More
Nathan Courtine

Get the main information from Windows Server with PowerShell

By | Database Administration & Monitoring | No Comments

This blog will present you a way to retrieve Windows Server main information via PowerShell. The goal is to be able to automate the extraction of information for different purposes: audit, report generation, dashboards…   Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your comments!     Computer System information First, I initialize the WMI object containing…

Read More
Nathan Courtine

Managed Backup with SQL Server 2014

By | Database management | One Comment

In a previous blog post called Backup a SQL Server database from On-Premise to Azure, I presented the different tools to backup your on-premise databases on Azure Storage. SQL Server Managed Backup to Windows Azure was one of these tools. In my opinion, Managed Backup is a great tool. That is why I decided to dedicate an entire blog to this feature. Understanding Managed Backup Managed Backup is a new feature introduced in SQL Server…

Read More
Nathan Courtine

How to store SQL Server data files in Azure Storage

By | Database management | One Comment

A new functionality, introduced with SQL Server 2014, enables to store data files from a SQL Server database in Windows Azure Storage. In this posting, I will show how it works.   Accessing Azure Storage The Azure Storage account is named “dbiservices”, and is composed of the “datafiles” container. This container does not contain blobs yet. If you are not familiar with the Windows Azure Storage terms, you should read this Introduction to Microsoft Azure…

Read More