Skip to main content

Posts

Showing posts from September, 2012

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer

To verify the SQL Server setup compliance with Microsoft Best Practices has become more easier now. Microsoft has provided “SQL Server 2008 R2 Best Practices Analyzer” tool. One can install following two components on Server or any remote machine (additional settings will required in 2nd case) 1) Microsoft® SQL Server® 2008 R2 Best Practices Analyzer 2) Microsoft Baseline Configuration Analyzer 2.0 On Execution tool will detail out the compliance report as per the Microsoft’s best recommended practices. To tune any SQL Server we can use this as startup point…   

Cassandra Setup on Linux ( Ubuntu 12.04)

I thought, setting up Distributed, NOSQL, Big Data must be a complex process. However, when I actually did it for cassandra, I found it like installing some simple OS package !!!.. Cassandra is too simple to setup and play around it. I found it more like plug and play engine. The Cassandra database very well explained in Book : O’Reilly Cassandra: The Definitive Guide, Nov 2010   So, Here is how to do it…. A) Pre requisites : jdk1.6 or grater version.        If you don’t have, you can download and configure it. How ? B) Cassandra on Linux           1. Create user for cassandra root@PTS0012:/usr/lib# id cassandra uid=506(cassandra) gid=0(root) groups=0(root) root@PTS0012:/usr/lib# 2. Create Dir for cassandra database root@PTS0012:/usr/lib# mkdir -p /var/log/cassandra root@PTS0012:/usr/lib# chown -R cassandra /var/log/cassandra root@PTS0012:/usr/lib# mkdir -p /var/lib/cassandra root@PTS0012:/usr/lib# chown -R cassandra /var/lib/cassandr