Blog | May 4, 2015

Microsoft SQL Server 2014 In-Memory OLTP - “Hekaton”

Posted By: Ramdas Baghel

In order to leverage the changing hardware landscape, Microsoft has for the first time introduced the concept of In-Memory OLTP, popularly known as Hekaton. This will make OLTP transactions faster than ever.

Blog | Apr 22, 2015

Understanding Backups with SQL Server AlwaysOn High Availability Mirrors

Posted By: Jeremy Johns

One of the great benefits of the AlwaysOn scenario is the ability to offload backup operations from the primary server to one of the secondary replicas. Simply stated, any replica (up to four) can be utilized for backup operations as long as it can communicate with the primary replica and it is in a SYNCHRONIZED or SYNCHRONIZING state.

Blog | Apr 17, 2015

R12 Trading Community Architecture (TCA): What is it and do I have to pay for it?

Posted By: Harish Durgapal 

Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information related to your organization’s business partners. This architecture is essentially a “new and improved” Data Model. It is not a licensable module/application which has to be purchased individually.

Blog | Apr 10, 2015

Three Reasons to Upgrade to SharePoint 2013

Posted By: Alan Markey

This article will address the three major reasons why you should consider upgrading to SharePoint 2013 from the previous versions.

Blog | Apr 8, 2015

Oracle 12c for Pro Newbies: Plug and Play (Part 1)

Posted By: Ankur Raina

Before we plan to create a pluggable database (PDB), we need to create a CDB (container database). This can be generally done in two ways:
i. Using the DBCA (Oracle prefers using this approach as it is more an automated one)
ii. Using the CREATE DATABASE statement (DBAs use this as it allows more control)

Blog | Mar 17, 2015

SQL Server Performance Troubleshooting – Missing Indexes

Posted By: Bob Lane

As DBA’s it is not unheard of to hear that “an application running slow” . When a particular query can be identified, the Database Engine Tuning Advisor can be used to look into the query plan. However, many a times the users don’t have the visibility into what is being run. This is where the DMVs can be extremely useful in identifying the most important missing indexes.

Blog | Mar 10, 2015

SQL SERVER RESOURCE BOTTLENECK – CPU -The first in a four part series.

Posted By: Vikas Agarwal

When you fire a query, the SQL optimizer decides the best execution plan after considering the cost effectiveness.. [Re]Compilation is CPU Intensive and to leverage the system resources SQL stores the recently used execution plan in the system memory.

Blog | Mar 5, 2015

How to Capture Deadlocks in MySQL Instance

Posted By: Ravi Bhatia

As the deadlocks are internally resolved by MySQL instance by rolling-back the failed transactions, it becomes critical to log such actions and report such issues to dilute their impact on the applications and minimize the deadlock from happening again.

Blog | Feb 12, 2015

Essentials - SQL Server 2012 Integration Services Upgrade

Posted By: Vivek Saurabh Sharma

Are you considering upgrading SQL Server Integration Services to Version 2012? 

If yes, then this is the blog that will help you understand the details of the process.  We have attempted to put the essential pieces together to explain the same process we went through with a recent upgrade done for one of our clients.