Database management, Oracle Oracle tuning silver bullet: add an order by to make your query faster 01.04.2015 by Oracle Team By Franck Pachot . You have read all Cary Millsap work about Oracle database performance tuning. You know that there are no silver bullets. Reducing the response time requires a methodical approach in order to analyze the response time(…)
Hardware & Storage Weird issue with sys.fn_hadr_backup_is_preferred_replica() function 30.03.2015 by Microsoft Team A couple of days ago, I faced a weird backup issue with SQL Server AlwaysOn and availability groups at one of my customer (thank to him to point out this issue 🙂 ). After installing our DMK tool (Database(…)
Operating systems Windows Cluster vNext and cloud witness 29.03.2015 by Microsoft Team The next version of Windows will provide some interesting features about WFSC architectures. One of them is the new quorum type: “Node majority and cloud witness” which will solve many cases where a third datacenter is mandatory and missing to(…)
Database management, Oracle Index on SUBSTR(string,1,n) – do you still need old index? 27.03.2015 by Oracle Team By Franck Pachot . In a previous post I’ve shown that from 12.1.0.2 when you have an index on trunc(date) you don’t need additional index. If you need the column with full precision, then you can add it(…)
Database management, Oracle Standard Edition on Oracle Database Appliance 25.03.2015 by Oracle Team By Franck Pachot . The Oracle Database Appliance is really interresting for small enterprises. It’s very good hardware for very good price. It’s capacity on demand licensing for Enteprise Edition. But small companies usually go to Standard Edition for(…)
Application integration & Middleware QlikView Tips & Tricks – part II 19.03.2015 by Morgan Patou In a previous blog entry, I started to share some Tips & Tricks about the installation and configuration of some QlikView components/software. I will try to complete this list with some other interesting things(…)
Database management SQL Server: Change Data Capture for Oracle 19.03.2015 by StĂ©phane Savorgnano This new feature has been introduced in SQL Server 2012 and needs an Enterprise Edition. It uses a Windows Service which scans Oracle Logs and tracks DML changes from Oracle tables into SQL Server change tables. In other words,(…)
Application integration & Middleware A funny story with recompile hint at statement level 18.03.2015 by Microsoft Team Last night, I had an interesting discussion with one of my MVP French friend that faces a weird situation where a query that uses a statement level RECOMPILE hint produces an execution plan that disappointed him. He told me we(…)
Database management Use a wallet to encrypt Oracle client passwords 17.03.2015 by Nicolas Jardot In our more and more connected world, security is a big concern. Storing password is a very important topic because if a machine is compromised, we can assume that any password stored in clear text are also compromised. I had(…)
Database management, Oracle 12c: shutdown abort a PDB? 16.03.2015 by Oracle Team By Franck Pachot . Can we shutdown abort a PDB? Let’s try: SQL> show con_id CON_ID ------------------------------ 3SQL> shutdown abort; Pluggable Database closed. But is it really a shutdown abort? The shutdown abort we know in non-CDB – or(…)