Data Engineering – Learn from the experts

  • November 2012 UG Presentation Materials

    This time the event is totally taken care by Ram. Unfortunately me and Madhi are stuck with some work so we are not able to turn up for the event. Hope Ram has filled 3 hours with transaction log internals.

  • SQL Server 2012 Performance Dashboard Report

    Performance dashboard is developed for SQL Server 2005 which provides useful information about the server, in simple it will give you an performance overview of entire SQL Server. If you worked with SQL Server 2005 then you might be familiar with this tool. Unfortunately they didn’t provide or updated the tool to work with SQL…

  • Performance View on INNER JOIN and OUTER JOIN

    Hope you guys are getting ready for Diwali Festival :-). Before you guys start with the festival event I thought of writing an article on performance.  Couple of days ago one of the developer came to me and said he was using  an INNER join in his query and he is getting delay in results,…

  • What’s new in DTA – SQL Server 2012

    DTA stands for Database Tuning Advisor which has introduced from SQL Server 2005. This utility helps the end user to tune their query and give them suggestions for better performance. It takes T-SQL query or profiler trace as workload, based on this it will analyze and give you the recommendation. Now in SQL Server 2012…

  • November 2012 UG Meeting Scheduled

    Looking for November 2012 month UG meeting? Oh yeah! we have scheduled for November month meeting, it’s going to be conducted on 17th November 2012 between 09:30 AM to 01:00 PM. Please feel free to pass this information to all your colleagues \ friends and those who are interested in SQL Server. It’s a free…

Got any recommendations?