We are back again this month. We are going to post pone this month UG a week , that is to first week of August. You know why ? We have a fantastic SQL Server guest for UG this month. He voluntarily wanted to take a session for Chennai folks. It’s none other than the Mr. Amit Bansal. He will be visiting Chennai first week of August , we have postponed our UG on first weekend of August so that Amit can gave a wonderful session for you folks.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30 AM to 02:00 PM
Date: 06 August 2011
Performance Troubleshooting – Tempdb Database by VidhyaSagar
An overview of troubleshooting tempdb database issues and some of the best practices related to tempdb database to keep your server up and running fine
UnderStanding Datetime Data type by Madhivanan
All about data time data type, session covers from how it stores to how can you retrieve date time in different ways.
Database Unit Testing by Amit Bansal.
Abstract: Unit testing, while a well understood concept in application development, has not yet been embraced in the database community. Join this sessions to learn and see the advantages of Test Driven Database Development. Unit tests in the database world are tests of a database’s programmability objects like stored procedures, functions, and triggers. VSTS toolset delivers a comprehensive database unit testing framework, bringing the same first-class unit testing capabilities many application developers enjoy today to the data community. This session will explain what exactly database unit testing is, show you how to go about developing database unit tests using the framework, and will walk you through how to leverage its rich capabilities to develop an effective database unit testing strategy inside of your organization. Amit will also show a couple of VSTS features like Data compare and Schema compare that greatly enhances the productivity of a Database Developer
Vidhya & Madhi are familiar to Chennai UG so Mr. Amit’s profile is below
Amit Bansal is the CTO of eDominer Systems & Peopleware India. A veteran in SQL Server, he is one of the most sought after consultant, trainer, writer, speaker & evangelist on SQL Server & Business Intelligence. A seasoned speaker; he speaks at major summits and conferences of Microsoft worldwide including TechED, TechReady, MCT Summits, MSDN & TechNet conferences. Over the last 8 years, he has consulted, trained & mentored more than 6000 IT professionals on SQL Server & Business Intelligence and worked with top notch blue chip companies worldwide including Microsoft, Infosys, Wipro, RBS, HCL, HP, Siemens, IBM, Accenture, etc. He has delivered more than 400 workshops on SQL Server & Business Intelligence. Apart from holding many Microsoft credentials, he is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server. He is also one of the first Microsoft Certified Trainer in India. Amit has worked with Microsoft in India and US as a Subject Matter Expert in various capacities participating in OD sessions, technical reviewing, etc. He is also a very active community lead in Asia Pacific. Visit www.amitbansal.net to know more. Subscribe to Amit’s blog and be a member of his technical forum at www.SQLServerGeeks.com – an exclusive SQL Server portal.
Forum – http://www.SQLServerGeeks.com
Twitter – http://www.twitter.com/A_Bansal
FaceBook – http://www.facebook.com/people/Amit-Bansal/525339346
LinkedIn – http://www.linkedin.com/pub/amit-bansal/7/121/755
Blog – http://www.SQLServergeeks.com/Blogs
Company Site – http://www.PeoplewareIndia.com