Category Archives: Database Design

An Interview Experience with Microsoft

Posted on November 17, 2015 by uday arumilli

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

Database Design Concepts

Posted on October 24, 2015 by uday arumilli

Database Design Concepts People who work in database systems should have some knowledge in database design concepts. This article let you understand the high level process in designing a new relational database system. These concepts will help you in designing, … Continue reading →

Posted in Database Design, Miscellaneous, SQL Development, SQL Server DBA | Tagged , , , , , , , | 8 Comments

Stored Procedure Code Review Checklist

Posted on October 16, 2015 by uday arumilli

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