Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
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 It was a deep dive into the code of SQL Server and Slava shows us how they achieve a universal platform regardless the operating system. On my mind, the challenge was how to…
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 to Quickly compare the total cost of ownership (TCO) of your on-premises infrastructure with a comparable Azure deployment using the TCO…
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 want to test if an index would benefit one or more queries without affecting the production workload. In other words: Wouldn’t it be…
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 installed the Data Migration Assistant(DMA). Make sure that the .Net Framework 4.5 is installed on your machine before starting the installation…
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 download the CU on Microsoft website and I begin my patching campaign on all SQL server 2016 instances. The first one is…
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 You must use the OPatch utility version 11.2.0.3.4 or later to apply this patch. Verifying my opatch version, I see that I…
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 my operating system root@dbserver /etc $ cat redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) root@dbserver ~ $ uname…
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 this vision, Microsoft SQL Server 2016 – via its on-premises, cloud, or hybrid deployment options – provides customers with significantly lower total cost of…
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 pg_hba.conf lrwxrwxrwx. 1 postgres postgres 59 Jun 30 10:19 pg_hba.conf postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] When you add or modify an entry in this file,…
By Franck Pachot . The Oracle Database Appliance is shipped with a bare-metal installation which may not be the latest version. You may want to have it virtualized, or get the latest version to avoid further upgrade, or install an earlier version to be in the same configuration as another ODA already in production. The easiest for all cases is…
By Franck Pachot . I described in an earlier post on AWR views how the dictionary views were using metadata and object links to show information from other containers. But this mechanism cannot work for fixed views (aka V$) because they don’t have their definition in the dictionary. The big difference is that most of V$ views are available long…
By William Sescu The ODSM is a quite powerful tool for managing the Oracle Unified Directory, and quite a lot of default settings are very reasonable. But there is one that disturbed me from the beginning. It is the ODSM Session Timeout. You might see a message like the following. Or maybe this one. It just says, that the page…
