Infrastructure at your Service

Windows Azure Archives - Blog dbi services

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

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
Stéphane Savorgnano

SQL Server 2016 CTP3.0: Stretch Database enhancements

By | Database management, Technology Survey | No Comments

Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and enhancements that I will sow you in this blog.   In previous versions of SQL Server 2016 CTP 2.x, before to be allowed to Enable Stretch Database, you had to enable the “Remote Data Archive” option for the…

 
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
Stéphane Haby

Azure DocumentD8: Microsoft goes to NoSQL

By | Technology Survey | No Comments

Azure DocumentDB is a documentary database service and as like its name suggests, it is aMicrosoft Azure Cloud service. Since the last summer, developers have access to this new service, and now it is available for all. The Redmond Company offers for the first time a “NoSQL” database. This is not the only service that has come; it is associated to Azure Search, a full text search service.   Why NoSQL? Is first and foremost…

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

Deploying a SQL Server database to Azure

By | Database management | One Comment

Deploying an SQL Server database to a Windows Azure virtual machine is a feature introduced with SQL Server 2014. It can be useful for an organization  that wants to reduce its infrastucture management, simplify the deployment, or have a fast virtual machine generation. Concept This new feature is a wizard which allows either to copy or migrate an On-Premise SQL Server database to a Windows Azure virtual machine. The following schema explains the main process…

 
Read More
Nathan Courtine

Backup a SQL Server database from On-Premise to Azure

By | Hardware & Storage | No Comments

SQL Server database backup & restore from On-Premise to Azure is a feature introduced with SQL Server 2012 SP1 CU2. In the past, it could be used with these three tools: Transact-SQL (T-SQL) PowerShell SQL Server Management Objects (SMO) With SQL Server 2014, backup & restore can also be enabled via SQL Server Management Studio (SSMS). Concept This feature is quite similar to a “classic” backup & restore tool. Indeed, the main different lies in…

 
Read More
Microsoft Team

IT Pro TechDays 2013 in Lausanne: BYOD, SQL Server & SharePoint

By | Technology Survey | No Comments

I had the opportunity to attend the IT Pro day at the Microsoft Techdays in Lausanne. Let me give you a few insights on my day there. Being a SharePoint specialist but also ramping up on Microsoft SQL Server I tried to balance between SQL and SharePoint related sessions. BYOD As usual, the day started with a Keynote focusing on an overview of the new Windows 8.1 and Windows Server 2012 R2 features. Well… it…

 
Read More