Most Popular

Can Data Keep Pace with DevOps and Agile?

Provisioning a new server has become increasingly easy with virtualization. Provisioning data, however, can be more challenging, especially in Agile shops where the volume of environments required to support dev and testing can easily go beyond the abilities of your IT operations to keep up. Is there any way to make it easier? We brought […]

Read More

Using Oracle Cost-based Optimizer Hints: Part 2

This article series will focus using Oracle cost-based optimizer (CBO) hints, and this second article on producing a series of hints that will replicate an exact explain plan. In Part 1, we discussed the OUTLINE produced by DBMS_XPLAN.Display(FORMAT=>’OUTLINE’),   I find the IGNORE_OPTIM_EMBEDDED_HINTS to be an interesting hint to appear here.  This hint says to ignore all hints.  […]

Read More

Using the USER Pseudo-Column in Oracle Views

The USER pseudo-column is quite useful when you are using remote data access methods. For example, you may not want all remote users to see all rows in a table. To solve this problem, you must think of remote users as special users within your database. To enforce the data restriction, you need to create […]

Read More

The Five Commandments of Tomorrow’s Network

  Recently, I’ve been giving some thought  to the roadblocks I discover when I attempt network automation and orchestration, and how those roadblocks impact the software-defined data center idea as a whole. As a result, I have a few suggestions for how to prepare a network – and the thought process – for the future. Thou shalt document thy […]

Read More

Best Practices for Virtualizing SQL Server

It wasn’t that long ago that many companies thought that you couldn’t virtualize SQL Server because it was too resource intensive. However, with the advances that both Microsoft and VMware have made to Hyper-V and vSphere respectively today’s virtualization platforms are more than capable of running almost every enterprise workload – including SQL Server. This […]

Read More