Category Archives: SQL Server DBA

SQL Server Health Check HTML Report

SQL Server Health Check HTML Report is useful to quickly get the performance snapshot of a database instance. After going through the overall system parameters, except the minor issues we can clearly state that the both instances are optimally performing. Index maintenance and the database log file maintenance are the critical activities to be considered. Please make note that the HC report tool is not reporting the SQL code issues and its scope is restricted to the database system level performance. Continue reading

Posted in Performance Tuning, SQL Scripts, SQL Server DBA | Tagged , , , , , | 49 Comments

Latest SQL DBA Interview Questions and Answers

The post Latest SQL DBA Interview Questions and Answers takes you through the latest SQL DBA interview experiences shared by blog followers. You can also share your interview experience and we can provide you the answers: Q. Can we perform … Continue reading

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , | 1 Comment

Are we heading Towards Recession Again

The post “Are we heading towards recession again?” is mainly intended for SQL Developers and DBA’s. Global economy growth sustainability, corporate targets, investments, stock market, oil price, unemployment, dollar value and major Bank balance sheets may decide the recession. Since … Continue reading

Posted in Miscellaneous, SQL Development, SQL Server DBA | Tagged , , , , | 23 Comments