I’m working on a research project of building a replication framework from relational database to document oriented (non-relational/nosql) database system. This is to fulfill the research requirement of the MSc degree. The POC would be developed to demonstrate the solution by using MS SQL Server (relational) and mongoDB (document oriented). I would like to hear any comments/thoughts about this from the community.
I started a discussion on this in LinkedIn mongoDB user group and received couple of valuable comments. Many thanks for those who given the comments.
You can see them here.
Showing posts with label New Trends. Show all posts
Showing posts with label New Trends. Show all posts
Tuesday, July 10, 2012
Friday, March 16, 2012
Multi-Subnet Clustering
This is a new feature in SQL Server 2012. However Windows 2008 has this feature. With the introduction of the new feature, SQL Server can have a cluster node in a different subnet. Subnet is a virtual grouping concept available in network. Subnet will enable network administrators to manage networks effectively over geographical areas.
Since the subnet is a geographical network concept, now SQL Server clustering can be used as DR (Disaster Recovery) solution than ever before.
More information can be found here.
Since the subnet is a geographical network concept, now SQL Server clustering can be used as DR (Disaster Recovery) solution than ever before.
More information can be found here.
Friday, March 2, 2012
VLDBs backup in few seconds
VLDB - Very Large Databases, like several Gigs of databases. (50GB, 100GB, etc) How about managing backups? You may need to spend 20-30 hours to take a full backup of such DBs. Of course SQL Server 2008 has improved backup system than its earlier versions. Another alternative method would be to use third party tools like, LiteSpeed or RedGate backups. But stills you can't make it in few seconds. How about a system to take such a large DB backup in a few seconds? ANSWER is to use SAN snapshot backup.
Tuesday, October 11, 2011
Introduction to Parallel Programming and MapReduce
This is a very good article published by Google to undsertand the conecpts and practical usage of Parallel Programming and MapReduce.
http://code.google.com/edu/parallel/mapreduce-tutorial.html
http://code.google.com/edu/parallel/mapreduce-tutorial.html
Subscribe to:
Posts (Atom)
How to interpret Disk Latency
I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...
-
This can happen due to many factors like lack of indexes, out of dates statistics, if it returns a large number of records, etc. I observed...
-
There are several ways to get database sizes in a server. Following three system tables has the information to get database sizes. sys . sy...
-
This post is for SQL Server Database Administrators who have find difficulty in some situations when identifying slow running queries. The D...