Although it was a rainy day so many attendees were there to participate SQL Server Universe Monthly User Group Meeting. At the beginning Dinesh’s TV interview was on the screen until the meeting begins. And then we had 3 sessions one on Data migration to Dynamics, one on execution plan myths, and last one was about Paging Results in SQL ...
If you have so many documents in your collection in MongoDB database. Sometimes you may want to retrieve few documents. But if we run find() we cant have nice output. You may need to have nice indentation and line breaks. You may want results in more readable way. Then you can use pretty(). Who can read this?? If you use pretty() you can take nice output with Mongo Shell.
Some times we need to take backups or we need to copy databases to another servers for administrative purposes. But sometimes just copying files is not enough. In MongoDB Shell they support to copy database from remote instance to current one with a single command. ( Just like Single Click in Windows ) For this demo I made alive two ...
Recently I went to Unity Plaza to buy a laptop for one of my friends who is going to university. So she doesn't wanted a computer with high specs. She just wanted to surf and do her day to day stuffs with laptop. Because of that I was looking for a Core i3 without dedicated VGA but little bit ...
In Queries we need to rank and number records. SQL Server gives you few functions to rank your records. RANK Rank we can use to rank data in normal way. In this ranking if we have two 1 next one will have rank 3. Name Marks Rank John 75 1 Mark 75 1 Steve 64 3 Gates 54 4 USE ...
Recently I went to Unity Plaza to buy a laptop for one of my friends who is going to university. So she doesn't wanted a computer with high specs. She just wanted to surf and do her day to day stuffs with laptop. Because of that I was looking for a Core i3 without dedicated VGA but little bit ...
WoW! This is my first video that I have created. Today, right now I uploaded it to YouTube and I hope to create few more videos also. It seems funny! So this videos describes how to install MongoDB on Ubuntu or on any debian using deb file(deb package). And you don't need to use apt-get install command to do ...
Yesterday while I was doing some test for performance team, I renamed a collection. Actually I renamed system.profile into "Profiling_28-08-2013". Then I couldn't access it. I couldn't delete that collection use db.Profiling_28-08-2013.drop(). After renaming MongoDB shell can't access that object. 1. JavaScript execution failed: ReferenceError: <Part of collection name> is not defined 2. JavaScript execution failed: SyntaxError: Unexpected token ...
Thanks Foster and Tom for this great book! Since the trend in the industry is towards Big Data and Data Science, I was reading and learning about them. When I found this book, I felt like I found something valuable. And I couldn't wait until start reading this book. This book's introduction says that this book will not be ...
Recently I went to Java Meetup. And it was all about Garbage Collector. So I learned lot more about Garbage Collectors. So Dr. Daya's suggestions was not to declare variable in higher scopes unless we really know what we do. For a example, don't declare class level variables if we are only using it inside on method. Then I was ...
Recently I downloaded Red Hat Enterprise Linux 6.0 to install on my home server. And I'm a person who haven't used Optical Drive for ages. On my laptop even DVD Drive doesn't work properly. So every time I use USB Drive (Pen Drive) to install any operating system because my server doesn't have a optical drive. Although I call ...
It's time to learn about Data Warehousing. I was really interested about Data Science. But I really didn't had much idea about Enterprise reporting, or analysis. But this book give much more than Microsoft SQL Server BI tool (Business Intelligence). It helped me to learn basics, some of theories about Data Warehousing. Because I learned things from the scratch, ...
History in Linux terminal is very usefull if you get used to it. If you have to ssh long hostname, or long file paths you don't need to type them again and again. You can just grep your history and rip what you want like this. Lets say I want my ssh commands I want to get. history | ...
Long time ago I have posted about how to use Titan with Cassandra. But it will only use a database called "titan". Sometimes you may want to use two different databases in Cassandra backend. In that case we have to use Cassandra Specific Configurations. You can find all of Cassandra specific Titan Graph Configurations here. To change the database(I'm ...
