Category Archives: Performance Tuning

An Interview Experience with Microsoft

An Interview Experience with Microsoft R&D One of my close friend recently joined Microsoft R&D as a “Senior SDE (Software Development Engineer). He was very excited as it’s his dream place to work and he also wants to share his … Continue reading

Posted in Database Design, High Availability, Interview Q&A, MSBI, Performance Tuning, SQL Development, SSIS, SSRS | Tagged , , , , , , , , , , , , , , | 50 Comments

Stored Procedure Code Review Checklist

Stored Procedure Code Review Checklist In any enterprise environment developing a database system includes the database code review. We have to document and follow the best practices in designing and developing database code. Most of the time while interacting with … Continue reading

Posted in Database Design, Interview Q&A, Miscellaneous, Performance Tuning, SQL Development | Tagged , , , , , , | 1 Comment

How to become an Expert in your Career

How to become an Expert in your Career In Previous Post we can understand what are the various Paths in Database Career. Recently we conducted an interview for a SQL Developer with 6-8 years of experience. We could hardly shortlisted … Continue reading

Posted in Database Design, Miscellaneous, MSBI, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , | 32 Comments