Category Archives: Future DBA

Apache Hadoop Ozone+HDDs and Kubernetes

As Hadoop is already a great on BIG Data, now as you know hadoop has addition stuff in it with concept called “Ozone” works with HDFS Datanode plugin and HDDs. “Ozone is designed to scale to tens of billions of … Continue reading

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

Day 1: MySQL History

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

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:)

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

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

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

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

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

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

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