Most Popular

Intent-based Networking – A Must for SDN

SDN is about making networking more flexible and agile through programming network elements. Such programming needs to be done in a standard way. Hence, standardizing the southbound protocol that directly commands a network element to forward traffic is important. So is the northbound protocol through which different applications tell an SDN controller the WHAT and […]

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

How to Identify and Fix SQL Server Index Fragmentation

Although SQL Server automatically maintains indexes after any INSERT, UPDATE, DELETE, or MERGE operation, some index maintenance activities on your databases may still be required, mostly due to index fragmentation. Fragmentation happens when the logical order of pages in an index does not match the physical order in the data file. Because fragmentation can affect […]

Read More

SQL Server Express as a Production Database

There are a lot of misperceptions and misinformation about Microsoft’s SQL Server® Express edition. Some of these misperceptions are holdovers from the limitations of previous releases, and others stem from misunderstandings about the product’s features and licensing. In this article, I’ll tackle some of the myths about using SQL Server Express as a production database, […]

Read More

Playing Operation with Systems

We live in a hectic world of day-to-day operations and aggressive business requirements that must be facilitated and made possible by IT — often in a vacuum. And we do all this while being expected to keep operations running consistently, repeatedly, and without interruption. These are the challenges, and rightfully so, the woes, of the […]

Read More