Database Administration & Monitoring 12cR2: Upgrade by unplug/plug in the Oracle Cloud Service 19.11.2016 by Oracle Team By Franck Pachot . 12.2 is available in the Oracle Public Cloud DBaaS. If you have a 12.1 DBaaS service, there's no button to upgrade it. I'll describe all the possible upgrade procedures and the first one, and the most(…)
Database Administration & Monitoring First installation of SQL Server on Linux REHL 7.2 17.11.2016 by Microsoft Team As you certainly know Microsoft announced yesterday the first preview of SQL Server vNext on Linux. Obviously we are far from a final version suitable for production and the list of unsupported features will probably be good indicator of the(…)
Database Administration & Monitoring, Technology Survey SQL Server 2016 SP1 and unlocked enterprise features! 16.11.2016 by Microsoft Team Starting with the release of SQL Server 2016 SP1, you will probably notice that the standard edition will benefit from a lot of features previously available only on Enterprise edition. Such features concern different areas as performance,(…)
Database Administration & Monitoring, Technology Survey Run SQL Server everywhere! 16.11.2016 by Microsoft Team Running SQL Server everywhere is not a dream anymore! Microsoft has just announced the first release of SQL Server CTP1 on Linux today! But that’s not all! SQL Server Vnext is also available on Windows,(…)
Database Administration & Monitoring 12cR2: CREATE_FILE_DEST for PDB isolation 16.11.2016 by Oracle Team By Franck Pachot . Two years ago I filled an OTN idea to 'Constrain PDB datafiles into specific directory' and made it an enhancement request for 12c Release 2. When you provision a PDB, the PDB(…)
Database Administration & Monitoring 12cR2 Single-Tenant: Multitenant Features for All Editions 14.11.2016 by Oracle Team By Franck Pachot . Now that 12.2 is there, in the Oracle Public Cloud Service, I can share the slides of the presentation I made for Oracle Open World:(…)
Database Administration & Monitoring 12cR2 new index usage tracking 13.11.2016 by Oracle Team By Franck Pachot . A common question is: how to know which indexes are not used, so that I can drop them. If you tried to use index monitoring you probably have seen the limits of it which make it(…)
Database Administration & Monitoring 12cR2 has new SQL*Plus features 11.11.2016 by Oracle Team By Franck Pachot . 12cR2 is there. What's new in SQL*Plus? For sure, you can't expect lot of things from it. The new command line is the SQL*Developer sqlcl which aims to be 100% compatible with SQL*Plus with lot of(…)
Database Administration & Monitoring Oracle 12cR2: MAX_PDBS 11.11.2016 by Oracle Team By Franck Pachot . Oracle database 12.2 is there on the Database Cloud Service, in multitenant. In EE High Performance or Extreme Performance, you have the multitenant option: you can create 4096 pluggable database (instead of 252 in 12.1). If(…)
Database Administration & Monitoring Oracle 12cR2: Pluggable database relocation 11.11.2016 by Oracle Team By Franck Pachot . Here is, in my opinion, the most beautiful feature of the multitenant architecture. You know how I love Transportable Tablespaces. But here: No need to put the source in read/only No need to export/import the metadata(…)