Wednesday, August 19, 2009

SQL User Group Meeting on 27th Aug


Welcome to this month's SQL Server user group meeting on 27th Aug at Microsoft. The agenda for this meeting is to:

  • Understand the architecture and implementation of Change Data Capture and Change Tracking

  • The presentation will focus on 2 different Auditing functions provided by SQL Server 2008, compare both the features and how easy it is to implement these in our application.

  • What is MDX, Multi-Dimensional, Testing MDX with the Query Tool in SQL Server Management Studio and Basic Elements of an MDX Query

  • The presentaiton would give an idea to how to work with Cube and use MDX(es) to retrieve data. Thinking Multidimensional, Testing MDX with Query Tool in SQL Server Management Studio and Basic Elements of an MDX Query would be some of the topics covered in this session.

    Speaker Profile:

    Prem Shanker, Sr. Software Engineer (Business Intelligence) ,Credit Suisse

    Prem Shanker Pandey is a senior software engineer working with Credit-Suisse. He has been working on ETL/ Data warehouse technologies for last 3 years and has deep understanding of implementation of SSAS, SSIS & SSRS 2005/2008.

    His day to day activities include work/enhance/modify SSAS cubes, performance tuning, Load data from various sources for SSAS cube using SSIS (integration Services), Write/optimizes MDX queries (SSRS reporting).

    Prior to his current position, he was working with Perot System, Singapore and used to provide Consulting, Application Development and maintenance services to Jurong Town Corporation, Singapore Police Force etc.

    Sudhir Chawla, Sr. Consultant (SQL SERVER) ,Credit Suisse

    Sudhir Chawla is a Consultant with Zensar and working for Credit Suisse. His day to day activities include SQL Server 2005 query tuning, performance enhancement, develop SSRS reports, Monitoring database and .Net technology.

    He has around 10 years of experience of various domains, like HR, Finance, Cruise, CRM etc. Prior to this he has worked with NEC and Siemens, Singapore.

    Download demo script and Presentation
    After the meeting presentation will be available for download along with demo scripts. Watch out for the download link.

    SQL SERVER 2008 R2 is released.
    Important to note that Microsoft has released SQL Server 2008 R2 Aug CTP on 12th August to public, so if you are interested then download it now from

    To play around with GEMINI, click here

    If you have any specific query regarding CDC, please write to me and I will try to address that in the UG meeting.

    Hope to meet you all during the meeting on 27th August, Thursday at 7PM.



    No comments: