Blog : What’s On Our Mind?

Sharing Our Point of View
By JP Chen May 26th 2016
Checking the SQL Server Agent Status
SQL Server Agent is a Windows service that executes the scheduled administrative jobs such as index maintenance, update statistics, database integrity checks, in addition to the application specific jobs. The SQL Server Agent service must be running in order for these job to executed on their scheduled time. What if you are working on an application upgrade that requires you to stop the SQL Server Agent from running and then restart it once the upgrade is completed? What are the commands…
By Eric Russo May 25th 2016
stretchDB_desktop
The world is moving towards the cloud and when I talk with decision makers around the world, there is one thing that comes up on top of the mind – how can I embrace the cloud adoption within my company. Yes, there are a select few who still love being on the on-premise infrastructure because of the investments they have already made. But that number is reducing faster than you can ever think off. I am amazed that the day for learning something completely new seems to…
By Eric Russo May 24th 2016
Columnstore
In a traditional index, also called as B-Tree index, rows are stored in a page and called a row store index. ColumnStore index is a non-conventional index where only one column is stored in a page. This feature was introduced in SQL Server 2012 but is still largely unknown. According to codeproject.com, in general, there are a few benefits to ColumnStore index: Since ColumnStore Index is stored in separate pages, only required pages are fetched from the disk. Query processing is faster Frequently accessed columns remain in memory Enhanced query…
By Dilip Kumar May 19th 2016
MySQL Replication
In the world of software development, an often-overlooked component which drives dynamic, data-driven websites is the underlying database. While it is not technically ignored, this is the one element that does not receive as much consideration in an e-commerce website. There are many database technologies that can be used, often coming in the form of either closed-source, proprietary systems or open-source, community-developed systems. Examples of the former include Oracle and SQL Server, and representatives of the latter include MySQL and PostGRESQL. Both have their advantages and disadvantages, but…