Posts Categorized: Technical Blog

Oracle Database: Query to List All Statistics Tables

If you were a big fan of manual database upgrade steps, perhaps you would have come across this step many times in your life while reading MOS notes, upgrade guides, etc. Upgrade Statistics Tables Created by the DBMS_STATS Package If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by executing the following…

Ambari Blueprints and One-Touch Hadoop Clusters

For those who aren’t familiar, Apache Ambari is the best open source solution for managing your Hadoop cluster: it’s capable of adding nodes, assigning roles, managing configuration and monitoring cluster health. Ambari is HortonWorks’ version of Cloudera Manager and MapR’s Warden, and it has been steadily improving with every release. As of version 1.5.1, Ambari added support for a declarative configuration (called a Blueprint) which makes it easy to automatically create repeatable clusters in the cloud. I’ll give an example of how to use Ambari Blueprints, and compare them with existing one-touch deployment methods for other distributions.

Instant REST API For Any Database

Not so long ago, I was playing with ElasticSearch, which has the interesting characteristic of having a REST API as its primary interface. Sure, it’s a little more stilted and awkward than any native interface but, on the other hand, it’s a nice universal type of API. Any language that can make a http request…

Expanding the Couchbase Collector for Diamond

The code For the impatient ones, the couchbase collector can be found in github: Couchbase Collector Follow the instructions in the README file to get it installed under your diamond! Intro If you have been involved with metric collections at any point you may have heard of BrightCove’s Diamond. Diamond is literally a little piece…

List of SQL Server Databases in an Availability Group

After migrating some databases to SQL Server 2012 and creating Availability Groups for some databases, we have noticed that some of our maintenance scripts were failing with the following error: The target database (‘MyDB1′) is in an availability group and is currently accessible for connections when the application intent is set to read only. For…

Oracle Passwords: How to Use Punctuation Symbols

You can’t make a password strong enough. But at least you can try. Having at least one upper case character, one lower case character, one number, one punctuation mark or symbol, and greater than 8 characters, you can have a password which can be considered something decently safe, probably.

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as oracle-rdbms-server-11gR2-preinstall RPM can be used to configure the server, right? So simple that I did not read the documentation. However, I did review Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit…

Why is Affinity Mask Negative in sp_configure?

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value. name                                minimum     maximum     config_value run_value ———————————– ———– ———– ———— ———– affinity mask                       -2147483648 2147483647  -1066394617  -1066394617 Affinity mask is a SQL Server configuration option which is used to assign processors to specific threads for improved…

Page 4 of 59« First...23456...102030...Last »