Category Archives: General

General information

Day 19 MyIASM Storage engine

Posted on May 19, 2018 by

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it is used for Read intensive operations. As described in yesterday this Engine was default till MySQL 5.5 and is widely … Continue reading →

Posted in General, History, Internal, MySQL, Others | Tagged , , , , | Leave a comment

Day 12 INFORMATION_SCHEMA database

Posted on May 12, 2018 by

Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because it is not stored any data directly, it provides information about metadata and other information which mysql has – data … Continue reading →

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

Day 11 MySQL System Database

Posted on May 12, 2018 by

Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are some system database MySQL has which will also contains very important information. Now on we will spend some time on … Continue reading →

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

Day 6: MySQL Programs

Posted on May 6, 2018 by

On day 5 we understand how to install MySQL or upgrade to latest version. Today we will discuss once installation is done we will be having multiple executable programs by which MySQL Runs, every RDBMS has its executable. MySQL programs are … Continue reading →

Posted in General, Installation, MySQL, Others | 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

Good Bye 2012 and welcome 2013

Posted on January 19, 2013 by

Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company … yeah If you read my last year good bye Blog I have indicated about my interest for changing the company took … Continue reading →

Posted in Computers and Internet, General, Personal | Tagged | Leave a comment

Denali – Blog a Day Series : May, 2012

Posted on April 23, 2012 by

Denali   Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is also available now. http://www.microsoft.com/sqlserver/en/us/default.aspx After Sql server 2008 (compatibility 10) and sql server 2010 /sql server 2008 R2 … Continue reading →

Posted in Computers and Internet, Denali, General, Whats New | Tagged , | Leave a comment

Last updated datetime of Sql Server files

Posted on January 18, 2012 by

*This is related to physical file size of a MDF or LDF file not internal allocation. One of our user asked that the ldf file is not changing, on checking the last modified date time, user was asking this. Its … Continue reading →

Posted in General, Internal, Transaction Log, What I learned today | Tagged , | Leave a comment

Good Bye 2011

Posted on December 31, 2011 by

Good Bye 2011 Hey there, this year is going to an end and just want to recall what all happened this year in my life both personally (cannot disclose much J) and professionally. The good news about this year is … Continue reading →

Posted in Basic, General, Others, Personal | Tagged | Leave a comment