Cloud, SQL Server Azure SQL Managed instances, Business Critical Tier and high availability 28.12.2018 by Microsoft Team 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(…)
Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Development & Performance Pass summit – day 4 09.11.2018 by Christophe Cosme 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(…)
Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Database management Pass summit – dbi visit day 3 08.11.2018 by Christophe Cosme 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(…)
Big Data, Business Intelligence, Cloud Pass summit – dbi visit day 1 06.11.2018 by Christophe Cosme 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(…)
Cloud, Database management, DevOps, SQL Server First steps into SQL Server 2019 availability groups on K8s 04.10.2018 by Microsoft Team 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(…)
Cloud Adding a timeout in monitoring probes 28.09.2018 by Oracle Team A few months ago day, as I was writing the documentation for a monitoring probe, I suddenly realized that that probe, along with others I wrote during that time to monitor Documentum installations, had all a big, unexpected flaw. Indeed,(…)
Cloud, Database Administration & Monitoring, DevOps, Operating systems, Oracle Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning. 18.09.2018 by Oracle Team Introduction : Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted. Oracle ASM Filter Driver (Oracle(…)
Cloud, Oracle ATP vs ADW – the Autonomous Database lockdown profiles 09.08.2018 by Oracle Team 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.
Cloud, Database Administration & Monitoring Google Cloud Spanner – inserting data 19.07.2018 by Oracle Team By Franck Pachot . In a previous post I've created a Google Cloud Spanner database and inserted a few rows from the GUI. This is definitely not a solution fo many rows and here is a(…)
Cloud, Database Administration & Monitoring Google Cloud Spanner – no decimal numeric data types 16.07.2018 by Oracle Team By Franck Pachot . Google Cloud Spanner is a distributed relational database focused on scalability without compromising consistency and integrity. It is available only as a managed service in Google Cloud. Basically, the idea is to keep the scalability advantages(…)