Technology Survey One-day workshop with Slava Oks for SQL Server on Linux 13.07.2017 by Stéphane Haby Few weeks ago, David Barbarin and I went to the Tugar IT in Lisbon to follow the workshop from Slava Oks: Bringing SQL Server to Linux: Experience(…)
Database Administration & Monitoring Azure Compare Total Cost of Ownership (TCO) with comparable Azure deployment 13.07.2017 by Microsoft Team Microsoft Azure allows you to quickly deploy infrastructures and services to meet all of your business needs. You can run Windows and Linux based applications in 36 Azure datacenter regions, delivered with enterprise grade SLAs. Microsoft Azure offer you(…)
Database Administration & Monitoring Can I do it with PostgreSQL? – 15 – invisible indexes 12.07.2017 by Daniel Westermann It has been quite a while since the last post in this series. Today we'll look at what you know from Oracle as: Invisible indexes. In case you wonder what they might be useful for: Imagine you(…)
Database Administration & Monitoring, Database management Migration to SQL Server 2016 with deprecated data types and Full-Text 11.07.2017 by Stéphane Haby A few weeks ago, I prepared a migration from SQL Server 2008 to SQL server 2016, I came across a case with deprecated data types and a Full-Text activated on these columns. To simulate this scenario, I downloaded and(…)
Database Administration & Monitoring, Database management SQL Server 2016: patching CU with R Services 11.07.2017 by Stéphane Haby As a good DBA, I begin to be up to date with all Cumulative Update (CU) by my customers. It is the first time that I run an update for SQL Server 2016 with the CU 3. I(…)
Database Administration & Monitoring Grid Infrastructure 11.2.0.3 PSU: My Opatch version check is failing 08.07.2017 by Oracle Team Mouhamadou Diaw Last day I was configuring grid infrastructure 11.2.0.3 for a standlone server. After the installation, I decided to apply the Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) – 16742216 In the documentation it is marked(…)
Database Administration & Monitoring Grid Infrastructure 12.2: Are all Redhat 7 kernels compatible? 08.07.2017 by Oracle Team By Mouhamadou Diaw In this blog I am going to share an issue I had when installing grid infrastructure 12.2 on Redhat 7.3. I was configuring grid infrastructure 12.2 for a standlone server. Below the release and the version of(…)
Cloud, Database management Oracle Database to SQL Server 2016 TCO Analyzer 08.07.2017 by Oracle Team Today, many enterprises are striving to transform their IT organization from a cost center into a strategic asset and looking for ways to get more value from their application and data platform investments. To deliver on(…)
Application integration & Middleware DA 7.2 UCF Transfer failing with SSL 05.07.2017 by Middleware Team This is a blog following the one I already wrote ealier: https://www.dbi-services.com/blog/documentum-administrator-ucf-troubleshooting/ The first one was for “how to find the error” and not how to resolve it. In this blog I will talk about an(…)
Database Administration & Monitoring, Database management PostgreSQL 10 Beta 1 : pg_hba_file_rules view 30.06.2017 by Joël Cattin This short blog to share a helpful stuff with the pg_hba.conf file : The pg_hba.conf file is the central configuration file to control client authentication. It is located in the database cluster’s data directory : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] ll(…)