Category Archives: Future DBA

Day 1: MySQL History

Posted on May 1, 2018 by

Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and SQL Initially – PHP DB Extension to open source – not suitable for DBMS – Developed in(C & C++) … Continue reading →

Posted in Experts, Future DBA, History, Imp dates, MySQL, Others, RDBMS, What I learned today, Whitepapers | Tagged | Leave a comment

Count_Big() function

Posted on January 22, 2018 by

Learned new function for count while going through the channel 9 video for salva. where for a very big table count it gave an error :   Count_Big() – BOL: Returns the number of items in a group. COUNT_BIG works … Continue reading →

Posted in BIGDATA, General, Others, What I learned today | Tagged , | Leave a comment

Happy New Year… Late:)

Posted on January 13, 2018 by

Yeah I know its new year and i am back from quite some time. during these days i was learning things but could not able to make time to blog about it. This year would like to write more on … Continue reading →

Posted in Future DBA, General, Others | Tagged , | Leave a comment

Future DBA – Big Data -MongoDB 2

Posted on October 4, 2016 by

In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a concept called sharding with replication, so here using sharding it uses a cluster like configuration and data will be load-balance- equally … Continue reading →

Posted in BIGDATA, Future DBA, Others | Tagged , | Leave a comment

Future DBA – Big Data -MongoDB 1

Posted on October 3, 2016 by

We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution and can be used for data warehousing. can manage big data/heavy data There is another BIG Data system called MongoDB, … Continue reading →

Posted in BIGDATA, Others | Tagged , | Leave a comment

Future DBA – Hive Big Data 2

Posted on September 27, 2016 by

In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is quite difficult so with the help of Vendors -Cloudera/Hortonworks/MapR we can integrate the tools/utility in a GUI way and can be … Continue reading →

Posted in BI, BIGDATA, Future DBA, NoSQL | Tagged , , | Leave a comment

Future DBA – Hadoop Big Data 1

Posted on September 26, 2016 by

In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on continue to that hadoop is mostly for big data and the on hadoop is stored in HDFS with named node … Continue reading →

Posted in BIGDATA, Others | Tagged , | Leave a comment

Future DBA – Hadoop Big Data

Posted on September 21, 2016 by

As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to know BIGDATA as well, and when we talk about BIGDATA we should be aware of HADOOP. I have gone through … Continue reading →

Posted in Future DBA, NoSQL, Others | Tagged , | Leave a comment

Operational Analytics -SQL Server 2016

Posted on September 20, 2016 by

What is Operational Analytics:- Operational Analytics is a combination of two words “Operational” and “Analytics”. so your OLTP system is a operational system where day to day task eg order table keeps on updating. and Analytics is a OLAP where analysis … Continue reading →

Posted in Future DBA, Others, sql 2016, Whats New | Tagged , | Leave a comment

Future DBA part 2

Posted on September 15, 2016 by

I do not say you should be expert in other technologies but you should be aware of what it is and whats the purpose and whats its characteristics and basics. when we talk of RDBMS (DBMS) like SQL most of … Continue reading →

Posted in Future DBA, Others | Tagged | Leave a comment