Infrastructure at your Service

Category Archives: Cloud

Diawo Mayaki

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, 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 is done, launch the command…

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 – day 4

By | Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Development & Performance | No Comments

Optimizing Multi-Billion Row Tables in Tabular in 2018   I wanted to attend the session moderated by Marco Russo to see his approach of optimizing performance in Tabular model The first thing to understand is how the data is stored and organized in a Tabular model. It is of course using the xVelocity in-memory capabilities with the Vertipac column storage layout engine. It organizes the data, compressing  it by column,  in combination with a dictionary…

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
David Barbarin

Connecting to Azure SQL Managed Instance from on-premise network

By | Cloud, Database Administration & Monitoring | No Comments

A couple of weeks ago, I wrote up about my first immersion into the SQL Server managed instances (SQLMIs), a new deployment model of Azure SQL Database which provides near 100% compatibility with the latest SQL Server on-premises Database Engine. In the previous blog post, to test a connection to this new service, I installed an Azure virtual machine on the same VNET (172.16.0.0/16) including SQL Server management studio. For testing purpose, we don’t need more,…

Read More
Oracle Team

ATP vs ADW – the Autonomous Database lockdown profiles

By | Cloud, Oracle | No Comments

By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services. To show how this is old, here is how they were defined in the Oracle7 Tuning Book: The definition has not changed a lot. But the technology behind DSS/DWH has improved. Now, with In-Memory Column Store, Smart…

Read More