Jonathan Lewis Hacking Indexes Indexes are expensive to maintain so we want to get the greatest benefit we can from them and make sure... 03 October 2016 14 min read
David Njoku JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar... 03 October 2016 11 min read
Anju Garg Migrate Oracle Database To ASM Using ASMCMD Introduction Oracle Database 10g Release 1 introduced Automatic Storage Management (ASM), a new framework for managing Oracle database files. ASM... 29 September 2016 9 min read
Jonathan Lewis Investigating Indexes Rebuilding indexes is an activity that you shouldn’t need to do often. There are always a few special cases –... 28 September 2016 16 min read
Anju Garg Oracle Database 12.1.0.2c: Hot Cloning Of Pluggable Databases Cloning of a Pluggable Database (PDB) in Oracle Multitenant is a great feature and is very useful. Oracle Database 12c Release 1 has... 20 September 2016 8 min read
BI Robert Sheldon in BI More Power BI to your Elbow Power BI Desktop continues to evolve. There have been many improvements to the reporting side that together make it easier... 20 September 2016 14 min read
David Njoku JSON For Absolute Beginners: Part 3 – Storing JSON in Oracle Welcome to part three in this series of articles about Oracle and its uneasy romance with JSON. Uneasy? Well, that’s... 16 September 2016 7 min read
BI Adam Aspin in BI Power BI for Data Modelling Power BI has a lot of uses, but one of the most interesting of them is to model and shape... 16 September 2016 24 min read
Database Administration William Brewer in Database Administration Database Cloud Backup Cribsheet Several database backup providers are now offering ‘Database Backup to the Cloud’, or ‘Backup As A Service’ (BaaS). There is... 12 September 2016 14 min read
Anju Garg Oracle Database 12.1.0.2c : Hot Cloning of Non-Container Databases In the initial release of Oracle 12c (12.1.0.1c), a non-Container Database (non-CDB) could be converted to a pluggable database (PDB)... 05 September 2016 7 min read
Jonathan Lewis Text Indexes The Oracle database has many features that are not spoken of frequently and a recent note by Connor McDonald reminded... 05 September 2016 14 min read
Aman Sharma Understanding SQL Query Parsing – Part 1 Introduction When it comes to tuning a badly-performing query, there are many things that need to be checked. There may... 05 September 2016 14 min read
Database Administration Shel Burkow in Database Administration In-Memory OLTP: Row Visibility in SQL Server’s MVCC SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by... 05 September 2016 15 min read
Jonathan Lewis Massive Deletes – Part 4 In the previous installment of this series I produced some figures highlighting the main differences between doing a large delete... 05 September 2016 10 min read
T-SQL Programming Uwe Ricken in T-SQL Programming DELETE Operation in SQL Server HEAPs You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have... 05 September 2016 14 min read
David Njoku JSON For Absolute Beginners: Part 2 – Why Use Oracle? In this short series of articles, we’ll be talking about JSON and its integration with the Oracle database. The first... 02 September 2016 5 min read
David Njoku JSON For Absolute Beginners: Part 1- Introduction Hi, meet my friend JSON. Chances are you’ve heard of it, perhaps you have a vague idea of what it’s... 02 September 2016 5 min read
Blogs Phil Factor in Blogs The SQL of Textonyms The task of finding textonyms in SQL involves importing a list of common words and doing transformations on every word... 31 August 2016 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Predicates With Subqueries The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the... 25 August 2016 12 min read
Database Administration Robert Sheldon in Database Administration SQL Server for Linux Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform,... 25 August 2016 11 min read
