Skip to main content


Showing posts from June, 2015

5 commands to handle Mongod Process

This year mongodb added into my skill set. Experts saying since last 10 years social media applications are most populars in the market which changes platforms, database and technology. This creates noSQL, hadoop and lots of new platforms for big data. Initially I want to say "MongoDB is a rapidly growing database in database market shares". This is a noSQL or what we are saying non-relational database . It become popular to develop rapid applications/ e-commerce sites/ online systems/ social media applications.  I am going to share my 1 st post on mongodb database. Now you will get more stuffs every week. Here is 5 most usefull mongodb configuration commands. All these are 1st day commands to start on mongodb database. Before starting to work on mongodb database, 1st we have to start command prompt with mongodb bin folder . How to start mongdb server. How to configure Data path. How to configure port. How to configure log. How to properly shut down mongodb serve

Top 10 NoSQL Database Design Funda

Design your Database schema in according to user requirement . Optimize your schema for most frequent use case. Combine objects into one documents if you will use them together, otherwise separate them. Duplicate the data because disk space is cheaper than computing time . Basically avoid joins however do while writing, not during reads. Don't insert mixed data-type values into one common fields, it can degrade performance. Do complex aggregation in schema. Do Capped Collection for fast writing on collection. Use Natural/default Order to read collection. Create index in Background . (offline). Avoid not in and not equal to operation . $ne and $nin .

sqlserver_start_time in dm_os_sys_info : sql server 2005

I was trying to get last server start time through DMV sys . dm_os_sys_info on all sql servers instance where groups was 2005+2008+2008r2+2012+2014. I got the result quickly excluded from one sql server 2005 instance it populated error.. Msg 207, Level 16, State 1, Line 1 Invalid column name 'sqlserver_start_time' . I think Microsoft was forgot to add this column in 2005. I managed it through. SELECT crdate FROM sysdatabases WHERE [name] = 'tempdb'. and xp_readerrorlog  Apart from this SYSDATETIME () was also not present in 2005 but now this is available …

Scalability, Horizontal and Vertical scalability

What is Scalability? Wikipedia say "Scalability is the ability of a system, network, or process to handle a growing amount of work in a capable manner or its ability to be enlarged to accommodate that growth." In Database point of View: Scalability is the ability or feature that should be able to support very large databases with very high request rates at very low latency. In General meaning "scalable database" is the ability of database which can add resources on any way to manage performance easily on growing database or requests. There are two types of Scalability vertical and horizontal. Vertical Scalability: 1.)     Increase capacity by adding more resources (memory or additional CPU ) to machine. 2.)     Usually it requires downtime. 3.)     It saves power consumption, less data-center cost and additional cost finance wise. Horizontal Scalability: 1.)     Horizontal Scalability is the ability to increase capacity by connecting mult

5 Important mySQL Development scripts

During database review most useful object I used information_ schema and show tables. Now I feel ease to work on mysql, either from command line or most popular tool workbench.  Since 2014 mysql added into my skill set and till now 3-4 projects.  Last year I have posted   5-important-shortcut-and-tips-to-work on workbench and today I am sharing  5 more commands what I am using for development and review on mysql database projects. 1.        How to insert or populate data in one table from another table? 2.        How to update one table from another table? 3.        How to create and use temporary table? 4.        How to Check Table Property from command line? 5.        How to check all indexes from one table? How to insert or populate data in one table  from another table? insert into user2  SELECT * FROM setting.user; How to update one table from another table? UPDATE temp p, word pp SET, pp.describe = p.describe WHERE =;