SQL Development

5 Common Mistakes Every Database Developer Must Avoid Being a developer is an awesome experience – trust us. You are an architect and the builder of your dreams. A developer shapes the way the requirements get translated into a working product which customers will enjoy using it. Most developers are passionate in the work they do and love doing programming. It is in their DNA, they are always thinking about logic even outside the working hours. In our opinion, developers are highly creative seeing ways to do things which others don’t see them comin...
SQL Server Tip: Optimizer using Index Scan and not Seek! Other than coding, most of the time developers have to troubleshoot problems from their environments. Developers in SQL world would mostly face problems around error message, getting required output via T-SQL query and unpredictable performance of query.  One fine day somewhere in the world a one developer was troubleshooting a performance problem – just like any one of us. He noticed, even after a table has index on a column and if they use that column in where clause, SQL Server was...

Check out more tips and tricks in this development video: