Data Engineering – Learn from the experts

  • Biggest sql server event

    One of the Biggest SQL Server Events in Chennai — Click Here for more information

  • March 2010 UG Scheduled

    We are ready for March month session. Please go-ahead and register for the same. Venue: Microsoft Training centre, Radhakrishnan Salai, Chennai Landmark: Opposite to President hotel Timings: 10:00 AM to 01:00 PMDate: 27th March 2010

  • Configure DB Mail Profile in SQL Agent for Automated Alerts

    In the recent times I have seen so many people asking the same question in MSDN forums on how do I activate database mail for the use of SQL server agent alerts system. So I am taking a chance to document it by using screen shots which can help others. Normally what the newbies tending…

  • February 2010 UG Presentation materials

    We have conducted our UG this month on 27th Feb 2010 and it went fine. We could see some more new faces this time, that’s really good. You can download the presentation materials and scripts used during the presentation to play with it. Incase if you need any clarification you are welcome to contact the…

  • Index fragmentation Report

    I had to prepare the list of tables having more than 60% fragmentation. I wrote this query to get those information. The below query will give the list of all the fragmented tables in a particular database having more than 60% fragmentation. This will work for SQL 2005 and beyond.

Got any recommendations?