Advertisements

Archive

Archive for December, 2012

2012 in review

December 31, 2012 Leave a comment

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

600 people reached the top of Mt. Everest in 2012. This blog got about 5,000 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 8 years to get that many views.

Click here to see the complete report.

Advertisements
Categories: Casual

What is Document Stores?

December 26, 2012 2 comments

In my last article I explained Key-Value Stores. I’ll explain about Document Stores which is one of the subcategory of NoSQL Databases. As name explains this category is store of semi-structured documents which supports formats like JSON. Attractively rather than calling rows they call individual row as document. Read more…

What is Key-Value Stores?

December 25, 2012 2 comments

In my previous article I explained about categories of NoSQL Databases and in this series of articles I’ll explain all four categories in details.

Let’s look at the essentially key-value stores. Which are really the most common and the most foundational, and also the most general purpose of NoSQL Database. They are not necessarily the most popular because Key-Value stores tend to be less exotic as compare to other NoSQL Databases. But they tend to fit so many different purposes especially well suited to a great variety of applications. Read more…

NoSQL Categories Breakdown

December 25, 2012 2 comments

As covered in my [last post]. In the era of Big Data, good old RDBMS concepts are no longer the right concepts for many unstructured and semi-structured database jobs. Here is another attempt to explain NoSQL with their Architecture and Categories. Read more…

PowerShell script to backup a database and restore on other server.

December 16, 2012 18 comments

Many a times as a DBA when we need to refresh our QA or Dev environment with Production environment, we need to have a full backup of Production database and then manually we need to restore them in other environments. The following is  a simple power shell script to just take a full backup with copy only option and then restore it on other server. Read more…

%d bloggers like this: