Category Archives: Basic

Day 9 Variables

In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing on other variables, there are Global Variables and Session/Local Variables which reflects the state of the MySQL and we can … Continue reading

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

Day 4: MySQL Architecture Continue…

MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL works on following options: Option/configuration file (my.cnf) System variables (Local /Global) Status variables My.cnf option file will have various Groups and … Continue reading

Posted in Basic, DB Design, High Avaliability, MySQL, Others, RDBMS, Replication, What I learned today | Tagged , | Leave a comment

SQL Server 2016 …whats new…WOW!!!

Hey there…. I wrote on SQL Server 2016 in my earlier blog Lets See and Whats new, during that time I knew that SQL Server 2016 will be good. but when I explore and see it now looks like it is a REVOLUTION for … Continue reading

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

Index Rebuild VS Reorganize

Posted in Basic, Index, Others, Troubleshooting | Tagged | Leave a comment

Normalization & Denormalization

Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should write a short blog on it. Normalization: For any database the way data is stored using different data models … Continue reading

Posted in Basic, DB Design, Others | Tagged | Leave a comment

RAID (Redundant Array Independent Disk)

RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk sql server is no exception. Generally all activity happens on memory as memory is very fast compared to Disk. Earlier … Continue reading

Posted in Basic, Books, Free Stuff | Tagged | Leave a comment

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may get an error an en eventvwr as “Could not open error log file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG’. Operating system error … Continue reading

Posted in Basic, Error Log, Limitation | Tagged , | Leave a comment

More IMPORTANT miscellaneous info

This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff. Okay, continue with Miscellaneous Info here is some more important stuff/ information about sql server. >>Ghost cleanup task runs every 5minuts … Continue reading

Posted in Basic, Experts, Limitation, Others | Tagged , | Leave a comment

Command Prompt connectivity –U option

When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows authentication and sql authentication. -E option is used for windows authentication where you domain windows login which you have connected … Continue reading

Posted in Basic, Limitation | Tagged , , | Leave a comment

Good Bye 2011

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