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.
Together with Oracle Database 12c, Oracle has introduced a new administration console named Oracle Enterprise Manager Express (Oracle OEM Express). This “light” version of Enterprise Manager Database Console – which is not supported in Oracle 12c anymore – is a management product built into Oracle Database 12c. There is no installation or management required, the database creation with dbca enables OEM…
Last week, I gave you some news about SQL Server 2014 (here). SQL Server 2014 Community Technology Preview 1 (CTP1) now is available for download on TechNet here (you need a TechNet subscription). Attention: Only the new feature “in-memory OLTP – codename Hekaton” has been added to this CPT. 😕 I hope that other features will soon come with the…
In my consultant’s activity at dbi services, I had the opportunity to test the new databasion version Oracle 12c. As an Enterprise Manager Cloud Control 12c fan, when the 12.1.0.3.0 Oracle database plugin was made available, I decided to test the Cloud 12c behavior with the Oracle 12c database and also CDB and PDB (Container Database and Pluggable Database). Before…
Let’s talk about my third day at TechEd 2013. I started with a session about: Windows Server 2012 R2 and High Availability The goal of High Availability is to deal with possible points of failure in your infrastructure. There are multiple ways to manage HA on the market: Server Server redundancy deployments Run server inside a clustered VM Backup Monitor…
As you probably know, the multitenant databases is the new feature of Oracle 12c to solve the dilema of applications segregation. Thanks to a multitenant container database, it allows to manage many databases as one taking advantage of resources consolidation. A perfect way to manage several applications in a single container. However are these plugglable databases that isolated as expected?…
Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternström, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance. There are 3 three…
En dehors de l’annonce de Flex ASM, ASM évolue peu dans Oracle 12c. La plus intéressante des améliorations pour les administrateurs de bases de données en cluster est l’introduction de la gestion des “Password Files” dans ASM. C’est l’objet de ce posting. Rappel Tout d’abord, un retour sur l’utilité du Password File et des éléments de configuration: Orapwd est l’outil pour…
Finally after some months … The Oracle’s long-awaited 12c database (12.1.0.1) is now available for download on OTN and Oracle E-delivery ( http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html). Without any surprise the first platforms are Linux and Solaris! Weird, but until now no “official” announcement from Oracle has been made… Have a look on all new features integrated in this release: http://docs.oracle.com/cd/E16655_01/server.121/e17906/chapter1.htm#NEWFTCH1
I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I’m beginning with the SQL Server In-Memory OLTP project “Hekaton”! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.…
A few weeks ago, I went to the Swiss Database Days 2013 and followed the “Practical SQL Server Performance Troubleshooting” workshop. During this workshop, I have seen a different way of troubleshooting, but I was surprised to see that some participants were not aware that some basic SQL Server Best Practice do not depend on the instance settings. This blog…
Good news for all SQL Server DBAs: DMVs and DMFs poster are now available for SQL Server 2012. You can download them here. You can choose between 2 formats: pdf and xps. What’s new? You will notice the new category AlwaysOn: You can see the ColumnStore Index in the Partitioning section: If you want to know more about the new…
Microsoft has just published the Fourth Cumulative Update (CU4) for Microsoft SQL Server 2012 SP1. If this CU covers an issue you are experiencing, you should install it quickly. Otherwise, it is not mandatory. Which issues are covered by CU4? This CU4 contains 39 Hotfixes: 24 for the Engine 3 for SSIS 7 for SSAS 5 for SSRS If you…
