Database management Transparent data encryption, key management and backup strategies 26.03.2014 by Microsoft Team Transparent Data Encryption requires the creation of a database key encryption. The database key is a part of the hierarchy of SQL Server encryption tree with at the top of the tree the DPAPI. Then if we traverse the(…)
Database management, Oracle The consequences of NOLOGGING in Oracle 23.03.2014 by Oracle Team By Franck Pachot . While answering to a question on Oracle forum about NOLOGGING consequences, I provided a test case that deserves a bit more explanation. Nologging operations are good to generate minimal redo on bulk operations (direct-path(…)
Application integration & Middleware Oracle APEX: redirect all pages to one 21.03.2014 by Alain Lacour This blog will explain how to proceed in order to redirect all the application pages to one single page, prior to their processing and rendering, with Oracle APEX 4.0 and above. In some cases, like security checks, you may(…)
Database management SQL Server 2014: Buffer pool extension – an interesting new feature 20.03.2014 by Microsoft Team Buffer pool extension (aka BPE) is an interesting feature of SQL Server 2014. Database administrators already know that memory is one of the key assets available for SQL Server. This is especially true for buffer pool memory, which plays(…)
Database management, Oracle Investigating Oracle lock issues with event 10704 14.03.2014 by Oracle Team By Franck Pachot . Did you ever encounter unexplained Oracle lock issues? They may be coming from unindexed foreign keys (which is worse in 11g). It’s not easy to monitor. Of course you can check Oracle locks from V$LOCKED_OBJECT, but(…)
Database management Troubleshooting: ORA-29283 when oracle is member of a group with read/write privileges 11.03.2014 by Oracle Team Recently, I worked on an Oracle database migration for a customer and I faced a strange behavior when accessing a file stored on the file system of the Oracle database. The database has been migrated on a new server, and(…)
Database management SQL Server 2014: Deleting files of a hekaton table 06.03.2014 by Microsoft Team A recurrent question I have often heard about Hekaton objects is the following: Is an accidental deletion of the compilation files of a hekaton table on the file system irreversible and could this compromise the execution of SQL Server?(…)
Database management, Oracle Oracle 12c In-Memory option: waiting for 12.1.0.2 04.03.2014 by Oracle Team By Franck Pachot . Oracle has announced a big feature that should come in the next 12c patch set: the In-Memory option. It will soon be in beta version, so nothing will be published about it until it(…)
Database management SQL Server 2014 : SELECT ALL USERS SECURABLES & DB admins 26.02.2014 by Microsoft Team Microsoft will introduce four new security permissions in SQL Server 2014. One of them called SELECT ALL USERS SECURABLES is the subject of this post. As explained by Microsoft SQL Server 2014 will allow a database administrator to manage(…)
Database management, Oracle Oracle Partitioned Sequences – a future new feature in 12c? 20.02.2014 by Oracle Team By Franck Pachot . Disclaimer: I'll talk about an undocumented feature that appeared in Oracle 12c - undocumented except if you consider that being exposed in DBA_SEQUENCES as the PARTITION_COUNT is a kind of documentation. So, as the syntax is(…)