Infrastructure at your Service

Tag

Azure Archives - Blog dbi services

David Barbarin

Deploying SQL Server on Azure virtual machine with Terraform

By | Cloud, DevOps, SQL Server | 2 Comments

We are entering now to the infrastructure as code world and provisioning a SQL Server infrastructure is not excluded from the equation. This is especially true when it comes the Cloud regardless we are using IaaS or PaaS. One great tool to use in such scenario is certainly terraform and I introduced it during the last PowerSaturday pre-conference named “DBA modern competencies”. Installation paradigms in the cloud differ from what we usually do on-premises either…

Read More
Stéphane Savorgnano

How to migrate from on-premise to an Azure SQL Database

By | Cloud, Database management | No Comments

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don’t deal with every day. As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which gives the ability to manage your databases directly from the Cloud with the performance of your choose, reliability, security and…

Read More
Stéphane Savorgnano

How to create an Azure SQL Database

By | Cloud, SQL Server | No Comments

Azure SQL Database is a relational database-as-a-service (DBaaS) which gives us the possibility to create application with a performant database without to take care of the relying infrastructure. Azure SQL Database is based on the latest stable version of Microsoft SQL Server Database Engine. We have the choose between 2 purchasing models: a vCore-based purchasing model and a DTU-based (Database Throughput Unit) purchasing model. 3 Deployment options possible: single database: has its own set of…

Read More
David Barbarin

Windocks, SQL Server and Azure in our internal CI pipeline

By | Cloud, DevOps, Docker, Kubernetes, SQL Server | One Comment

During the last DevOps Day in Geneva, I presented a sample of our CI implementation related to our MSSQL DMK maintenance product. It was definitely a very good experience for me and good opportunity to get feedback from DevOps community as well. During the session I explained our CI pipeline includes SQL Server containers both on AKS (K8s as managed service in Azure) and Windocks. I got questions from some of attendees who asked me…

Read More
Mehdi Bada

Docker EE – UCP 3.1.2 installation failed in Azure

By | DevOps, Docker | No Comments

Docker EE 2.1 is a Containers-as-a-Service (CaaS) platform on-premise or in the cloud. To manage your cluster of containers, Docker EE allows you to install UCP (Universal Control Panel). When you plan to install the UCP 3.1.2 in Azure, the installation fails during the deployment of the UCP service. You will get the following error message. [[email protected] ~]$ docker logs ucp-reconcile   If you google the error message you will get a lot of answers…

Read More
Microsoft Team

How To Create A New Container Group Using Azure CLI

By | Cloud | No Comments

Steps To Create A New Container Group Using Azure CLI Before starting to create a container group, a MSDN account is needed to use the Azure platform, please refer to your manager for further information. In this tutorial, the Azure CLI command-line tool will be install on Windows and we will deploy a website running the open source GHOST platform. Choose the right operating system to install the command-line tool. The information can be found here. When the installation…

Read More
David Barbarin

Azure SQL Managed instances, Business Critical Tier and high availability

By | Cloud, SQL Server | No Comments

Last blog of this year 2018 with SQL databases and Cloud Azure and this is not trivial choice. <Speculation mode> I would say year 2019 could be important for all stakeholders. Cloud transformation has begun in many forms at customer shops and we heard about some big actors who are coming in Switzerland including Azure or Google. Data Platforms services will not be an exception in some degree of magnitude … <end of speculation mode>….

Read More
Christophe Cosme

Pass summit – dbi visit day 3

By | Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

The Microsoft data platform is evolving The third day began with the Keynote help by Rohan Kumar the Corporate Vice President of Azure Data by Microsoft The main message was “Hybrid data platform is the way for the future” and Microsoft is working in this direction. The use of AI and analytic to transform the customer business is also a key driver for the Microsoft data platform, which is building to enable this easily. Rohan…

Read More
Christophe Cosme

Pass summit – dbi visit day 1

By | Big Data, Business Intelligence, Cloud | No Comments

Designing Modern Data and Analytic Solution in Azure After having explained the pros and cons of Azure and the decision drivers for going to an Azure Architecture, some interesting messages were delivered like the decoupling of the storage and compute aspect on Azure, even if some of services still combine both. Another message that we all know but is essential to remind on a regular basis is that cost control is an important aspect. Developers…

Read More
David Barbarin

First steps into SQL Server 2019 availability groups on K8s

By | Cloud, Database management, DevOps, SQL Server | No Comments

A couple of weeks ago, Microsoft announced the first public CTP version of next SQL Server version (CTP2). It is not a surprise, the SQL Server vNext becomes SQL Server 2019 and there are a plenty of enhancements as well as new features to discover. But for now, let’s start with likely one of my favorites: availability groups on Kurbernetes (aka K8s). As far I may see from customers and hear from my colleagues as well,…

Read More