Most Popular

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

Top Virtualization and IT Blogs

Discover, Alert, Remediate and Troubleshoot: Who does that anyways? In the past few weeks, I’ve introduced DART as the skills that virtualization admins need to develop and grow in order to become masters of their virtual universe. DART is an acronym for the skills of discovery, alerting, remediation, and troubleshooting. And they are basic skills […]

Read More

Designing a Monitoring Solution: Where Are Your Eyes?

Contemporary monitoring solutions are no different from any other distributed application in your environment. Even a small-scale deployment can include multiple components: often, these include a Web server, an application server, and a database server. And as with any distributed application, you need to consider placement for each component. More specifically, when you are charged with designing a monitoring […]

Read More