Subject: AB’s SQL Server day – May 29th, Saturday at Microsoft (Gurgaon)

Dear IT Professional, & cordially invite you to next dose of AB’s SQL Server day on 29th May 2010 (Saturday) at Microsoft Gurgaon from 10.30 am to 2 pm. Register at

Sarabpreet Singh & Rakesh Mishra will present power-packed sessions. This is a community event and is absolutely free. Session details are as follows:

10.30 am to 10.45 am – Introduction to SQLServerGeeks by Sarabpreet Singh (Regional Mentor – SQLServerGeeks)

Topic 1:                 Loading Excel data into SQL Server
Speaker:              Rakesh Mishra
Time:                     10.45 am to 12 noon
Abstract:              There are many scenarios where you need to import\load excel data into SQL Server. In this session I’ll introduce some techniques to effectively load excel data into SQL Server using different tools i.e., SSIS, Linked Server & OpenRowSet. I’ll also talk about which tool to use under what circumstances.


12 noon to 12.30 pm – Refreshments & Networking

Topic 2:                 Introduction to SQL Server Profiler & Performance Monitor
Speaker:              Sarabpreet Singh
Time:                     12.30 pm to 1.45 pm
Abstract:              Performance tuning is an on-going process. The first step of tuning is to know what’s going on inside SQL Server. Monitoring plays a vital role, effective monitoring helps a DBA to identify and resolve the issue before anyone notice it.
I’ll introduce two basic monitoring tools i.e., SQL Server Profiler and Performance Monitor (PerfMon). I’ll also talk about How to use these tools? When to use these tools? How to synchronize a System Monitor log with a SQL Server Profiler trace to get a clear picture and narrow down the performance issue to a specific area?
1.45 pm to 2 pm – Closing note by Sarabpreet Singh

Date:                     29th May 2010, Saturday
Time:                     10.30 am to 2 pm (Please be at the venue sharp at 10.30 am)
Venue:                 Microsoft, CyberGreen towers, DLF Phase III, 9th Floor, Gurgaon
Contact:               Rishu Mehra: +91 9818562858 or Priyank: +91 9015741876
Registration link:
Note: Registration is a must.
We look forward to your participation. Please forward this email to your friends & colleagues to make them aware of the event. Do spread the word by blogging about it and posting it in relevant forums. Your efforts in spreading the word will be highly appreciated.

Thanks & Regards