Database Administration & Monitoring SQL Server Tips: Find sql logins when “windows authentication only” is enabled 05.02.2016 by Stéphane Haby A customer asks me to find all sql logins enabled on servers where windows authentication only is enabled. The goal is to clean sql logins on all servers through the CMS (central management server). In some cases, sql logins are(…)
Database Administration & Monitoring SQL Plan Directives strikes again 04.02.2016 by Oracle Team By Franck Pachot . 12c SQL Plan Directives, a side effect, a bad application design, a bug... and the occasion to show how to quickly troubleshoot. An application has long response time since 12c migration. No blind guesses, no reason(…)
Database Administration & Monitoring About OCR backup 04.02.2016 by Oracle Team By Mouhamadou Diaw Last day Franck and me were discussing about OCR backup Let’s take a 2 nodes RAC. We can see that OCR backup is automatically done by oracle in only one node on local (with a certain frequency(…)
Database Administration & Monitoring EDB Postgres Advanced Server 9.5 new features – Profiles 03.02.2016 by Daniel Westermann The just released version of EDB Postgres Advanced Server 9.5 introduces profiles very much the same as in Oracle. Lets have a look at it. As in Oracle there is a default profile: (enterprisedb@[local]:5445) [postgres] > x Expanded display(…)
Database management Introduction to MongoDB 03.02.2016 by DevOps MongoDB is an open source NoSQL database management system document-oriented. MongoDB allows the manipulation of structured and unstructured data. It is schema-less and can be used to store a large data volume. This blog is explaining the main principle of(…)
Database Administration & Monitoring DBI Tail v1.2 now released ! 01.02.2016 by Middleware Team Dear IT colleagues, We regularly have to read log file contents either to understand software functioning or for debugging purpose. Most of the time we access same log files located in same servers. It is very painful to login every(…)
Database Administration & Monitoring, Operating systems Windows failover cluster 2016 : new site awareness feature 01.02.2016 by Microsoft Team After my first two blogs about cloud witness and domain-less dependencies features shipped with Windows Server 2016, it’s time to talk about another pretty cool feature of the WSFC : site awareness that will also benefit to our(…)
Database Administration & Monitoring Installing EDB Postgres Advanced Server 9.5 31.01.2016 by Daniel Westermann Some days ago EnterpriseDB released EDB Postgres Advanced Server 9.5. As usual this release contains all new features that have been introduced with PostgreSQL 9.5 plus the additions that are documented in the release notes.
Database Administration & Monitoring The Postgres Plus® Cloud Database 29.01.2016 by Daniel Westermann In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud(…)
Database Administration & Monitoring awrrpt and spreport in multitenant 27.01.2016 by Oracle Team By Franck Pachot . Yesterday I was giving my 'Interpreting AWR Reports' Prezi at Oracle Midlands. There is a point where I explain that I always check the 'Captured SQL account for ...% of Total DB Time (s)' in order(…)