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

Oracle

Aman Sharma in Oracle

Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation

Oracle SQL query parsing explained - the query processing workflow from SQL statement to execution plan, the difference between hard...

05 September 2016 16 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

Using Computed Columns and Scalar Functions in SQL Server for Text Transformations and Anagrams

Use SQL Server computed columns with scalar functions to precompute text transformations - shown through two worked examples: finding textonyms...

31 August 2016 15 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

BI

Adam Aspin in BI

Direct Query with Power BI

Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify...

10 August 2016 30 min read

T-SQL Programming

Joe Celko in T-SQL Programming

Formatting SQL Code – Part the Second

When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is...

10 August 2016 15 min read

Database Administration

Robert Sheldon in Database Administration

SQL Server Access Control: The Basics

No technology yet invented can in any way allow us to neglect the task of ensuring the security of the...

02 August 2016 17 min read