Blog : What’s On Our Mind?

Sharing Our Point of View
stack.jpg
What are stacking instances and how can you use them to save money and extract more value from your SQL Server? A database engine instance, commonly referred to by database professionals as “an instance,” is a copy of the SQL Server executable that runs as an operating system service, managing several system and user databases. The applications connect to an instance to perform any work in the database that it manages. Most SQL Server users are only using one instance per server, but with a little math—courtesy of…
date_format.jpg
Regular readers of my blog know that from time to time I use the blog as a forum to answer questions I get via e-mail. Today, we address a popular theme – dealing with DB2 date data… Q:I have a DATE column in a DB2 table, but I do not want it to display the way DB2 displays it by default. How can I get a date format retrieved from a column in a table from DB2 database in the format MM/DD/YYYY? A:The simplest way to…
rdbms.jpg
A study, commissioned by Dell Software, shows traditional relational database management systems remains popular among corporate users despite claims and hype to the contrary. Although many various industry reports and prognosticators have stated that unstructured data is growing explosively, fueling the urgent need for technologies to work with it, structured data remains relevant, if not essential, to organizations. Structured data is now growing at a rate faster than unstructured data, according to the report. Structured Data Remains Popular Dell Software found: Although the growth of unstructured data has garnered most…
Galera Cluster
You need your application to stay up and available in case of software/OS crash, network issues, or hardware failure. Simple Master/Slave replication is not Highly Available, since there will be some delay in your application’s availability even under the best of circumstances. Master/Master also has its share of downsides (Primary Key collisions and data drift just to name a couple) that are also amplified when you have network related issues. We could even consider using GTID based replication for data integrity across replication chain and…