Category Archives: Database Design

Clustered Index On UniqueIdentifier Column

Hello all, It’s been a year since we posted a blog. It’s been the busiest year of my life. However, we strongly believe that learning is a journey and it should be a continuing process. Coming to the point, recently … Continue reading

Posted in Database Design, Performance Tuning, SQL Development | Tagged , , , , | 2 Comments

Having Database and Web Server on single EC2 Instance

Having Database and Web Server on single EC2 Instance: On this post we’ll see advantages and disadvantages of Having Database and Web Server on single EC2 Instance. Recently when I was working with one of the client, they were planning for … Continue reading

Posted in Database Design, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , | Leave a comment