Today I’ve written the exam 70-453 (Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008) and I’ve cleared the exam. I would like to share the information regarding this exam. While preparation I’ve searched for these information but I got very limited information on this, so I think this could be helpful for you.
Monthly Archives: October 2009
Presenter at Community Tech Days (CTD)
Yesterday I and Deepak have presented “SQL Server Query tuning” topic in Community Tech days. Community TechDays is a 11-city Roadshow conducted by the technology community in India on a quarterly basis for Developers, Infrastructure Professionals, Architects, Project Managers and Students.. This is the second time they have conducting this event. We have huge number of audiences compared to last time. Almost 1000 registrations were done and we got 400 participants right there. It was a good experience meeting everyone and we had a nice time. Most of them requested us to post the presentation and scripts in our websites, so I’m sharing the content with you folks. Please feel free to contact us if you have any concerns or comments
. Hopefully we are expecting everyone in the next community tech days .
Variable and Assignment enhancements – SQL Server 2008
Variable and assignment enhancements are small plus points in SQL Server 2008. We have around 4 things to discuss under this and they are below. All of these are mostly helpful to developers.
- Declare Statement
- Compound Assignment Operators
- Row Constructors
- Table Valued Parameter (TVP) Lets discuss on this titles one by one Read more »