Database management SQL Server 2016: In-Memory OLTP enhancement 17.07.2015 by Stéphane Savorgnano The CTP2.1 has been released for some weeks and it is time to check which interesting enhancements have been already deployed for the In-Memory OLTP feature. I will first have a look to the memory optimized table. Memory Optimized(…)
Database management Dealing with SSRS subscription schedules in AlwaysOn environment 16.07.2015 by Microsoft Team A couple of days ago, I had the opportunity to work with AlwaysOn 2014 infrastructure that included a report server (SSRS) in native and scale-out mode. As you know, dealing with SSRS and availability groups is not an easy task(…)
Database management Clustered columnstore index and memory management 10.07.2015 by Microsoft Team Few weeks ago, I had the opportunity to give a session about the clustered columnstore index feature (CCI) at our In-Memory event dedicated to In-Memory technologies for Microsoft SQL Server, Oracle and SAP HANA. During our session, I explained(…)
Database management, Oracle RESULT_CACHE hint expiration options 05.07.2015 by Oracle Team By Franck Pachot . The result cache is very nice when base tables are static: get the result without any buffer get, without any join or sorts. But as soon as any DML occurs on one of the tables(…)
Database management, Oracle Multitenant vs. schema based consolidation 30.06.2015 by Oracle Team By Franck Pachot . If you want to install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions: have one database and multiple schema have multiple databases have(…)
Database management, Oracle Oracle Log Writer and Write-Ahead-Logging 28.06.2015 by Oracle Team By Franck Pachot . I posted a tweet with a link to a very old document – 20 years old – about ‘internals of recovery’. It’s a gem. All the complexity of the ACID mecanisms of Oracle are(…)
Database management, Oracle Oracle Database Cloud Service – My first trial 27.06.2015 by Oracle Team By Franck Pachot . The cloud has been annouced, I want to try. From the cloud.oracle.com/database website, there is Trial only for the ‘Database Schema Service’ so I asked fot it, received an e-mail with connection info and it(…)
Database management, Oracle RAC buffer states: XCUR, SCUR, PI, CI 25.06.2015 by Oracle Team By Franck Pachot . In RAC, blocks are copied across instances by the Global Cache Service. In single instance, we have only two status: CR for consistent read clones where undo is applied, and CUR for the current version(…)
Database management, Oracle Multithreaded 12c and ‘connect / as sysdba’ 24.06.2015 by Oracle Team By Franck Pachot . In Oracle 12c you can run Oracle processes as operating system threads, lowering the number of OS processes. But you can’t use OS authentification: you need to provide a password. Here is a way to(…)
Database management, Oracle Buffer pool advisory in AWR 23.06.2015 by Oracle Team By Franck Pachot . In Oracle memory advisors: how relevant ? I said that advisors are calculating their recommendations from statistics cumulated since the begining of the instance, even in AWR which is supposed to cover only a(…)