Most Popular

Virtualization Basics: Troubleshooting

No more shooting from the hip This week, I’ll take you through troubleshooting, a skill that allows admins to drill down into an incident to gain understanding about its underlying cause and any related effects.  Last week, I went over remediation, describing it as the skill that allows virtualization admins to keep their jobs. If […]

Read More

Tips for Custom Application Monitoring

Custom applications play a vital role in all kinds of organizations, including education, government, healthcare, IT, and more. In order to adapt to the latest technologies, there are many changes businesses must make, especially the method they use to reach out to their customers. Most interactions between the customer/client and the organization takes place via tailor-made […]

Read More

Merits of a SQL Server Performance Analyzer vs. Performance Monitor(s)

Abstract SolarWinds® Database Performance Analyzer (DPA) is a performance analysis product unlike other resource-focused health and alerting monitors; it allows a comprehensive determination of why a particular TSQL statement or stored procedure is slow or creating a performance issue. DPA achieves its performance analysis using wait-based analytics vs. resource utilization/consumption approach. By using this technology, […]

Read More

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