Posts Tagged ‘database’

Previous articles covered what Azure Resource Manager is, along with how to setup an Azure Resource Group project within Visual Studio 2015 to deploy an ASP.NET Web Application to Azure as an App Service Web App. Being able to deploy an application to Azure is just the first step. In order to really use ARM […]

As More companies’ debate on adopting a Big Data Solution. Some of the discussion that comes across is whether to use Hadoop or Spark, NoSQL database or continue using their current RDBMS. The ultimate question is “is this technology for us?”  NoSQL database are highly scalable, provide better performance, designed to store and process a […]

  Ah, the never-ending task of transposing rows into columns and columns into rows in an Oracle table! There was always a fairly standard max-decode solution for this until Oracle came up with their elegant pivot and unpivot standard functions in 11g. Recently, I had a close encounter with these pivot functions and learned a […]

One of the most effective ways to improve application performance is to implement data caching. Most of the applications are relatively retrieving the same data from external sources like database of web service and if that source data is never or seldom changes then application is just wasting CPU time and I/O querying the source […]

One of the most asked questions in a project from the client was how feasible is it to use Database as the intermediary transport layer for Websphere Message Broker. No doubt there is a long term benefit in using WMQ but the question is more short sighted as per the immediate benefits of leveraging the […]

60,000 people will convene to watch 3,600 partners and customers speak in sessions at Oracle OpenWorld this week. Oracle’s rockstar, chief executive Larry Ellison, kicked off Oracle OpenWorld on Sunday evening, highlighting a shift to “in-memory technology to speed up by as much as 100 times the databases that are the foundation of the company’s business.” Ellison presented: […]

Below are step by step instructions that will show you how to install SQL Server 2012 Management Studio Express on a Windows 7 PC client, and also create your very own local SQL Server on a Windows 7 PC.

I found the CRN article describing Amazon’s adding their Relational Database Services to its Free Usage Tier.    What I find interesting is that when AWS became a household name (OK, industry wide name)  about two years ago, my first thought was that vendors like IBM, Oracle, JBoss, and Liferay ought to just add the db […]