Windows Azure Platform Training Kit Update

MS has released January 2010 update to the Windows Azure Platform Training Kit & Training Course.The Windows Azure Platform Training Kit & Course includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Windows Azure platform, including: Windows Azure, SQL Azure and the Windows Azure AppFabric.
Download the Windows Azure Platform Training Kit.
Visit the Windows Azure Platform Training Course on MSDN.
The January update provides new and updated demo scripts and a new Windows Phone 7 hands-on labs for the Windows Azure Platform. These new demo scripts demonstrate how to use Windows Azure Connect, Web and Worker Role Enhancements, Windows Azure Virtual Machine Roles, and the "Rafiki" application (a keynote demo at PDC10). Additionally, this kit includes an improved mechanism for installing Visual Studio code snippets.
Some of the specific changes with the January update of the training kit includes:

• [New demo script] Windows Azure Connect


• [New demo script] Web and Worker Role Enhancements


• [New demo script] Windows Azure Virtual Machine Roles


• [New demo script] “Rafiki” Application


• [[New lab] Windows Phone 7 and The Cloud


• [[New lab] Use Access Control Service to Federate with Multiple Business Identity Providers


• [[Updated] All Identity HOLs have been refreshed


• [[Improved] Visual Studio code snippets installation


• [[Fixes] Several bug fixes in demos and labs

Release: January 2011 Update
Version: 2.3

SqlServer 2008 Performance Optimization Training

This 2 day seminar covers best of the best concepts and practices from popular courses offered by Solid Quality Mentors. Theoretically any one can go through the technical stuff and learn their own. The seminar focuses completely on providing real world experience by using practical demos and scenarios derived from customer engagements. The seminar is uniquely structured. Sessions are discussion based and designed to be an interactive between instructor and participants for an optimal learning experience.

Target audience

This seminar is intended for following audiences:

• SQL Developers – Professionals responsible for writing optimal SQL Query
• SQL DBA – Professionals responsible for performance of the server
• Programmers – Any language programmer who deals with SQL Server

Yes. It is happening in major cities in India and all over the world . do not miss the opportunity.

Agenda

Day 1: Performance T-SQL with Solid Foundation

• Don’t Lie to Me. O Liar!  – Resolutions to Popular Misconceptions

There are plenty of myths regarding SQL Server features, some of them were true at times and others were pure imaginations. This Myth Buster session will talk about myths and will bust them – Scientifically!

• 5 Point Subquery – The Unknown Tricks and Tips of Subqueries

The age old topic of Subquery is in fact never old. Subqueries are most confusing to people who claim to know them well. This session talks about unknown tricks and tips that only advanced users would know. Learning them is like doing 6 digit multiplications without using paper or calculators.

• Your Joins, My joins, Our Joins – The Relation between External and Internal Joins

The SQL Server Engine looks at the Join very differently from how we look at it. We think that there are Cross Join, Inner Join and Outer Join. SQL Server Engine thinks there are Loop Join, Merge Join and Hash Join. Learn where and how the bridge is completed.

• 3 ‘Real’ Idiots of SQL – Triggers, Views and …!

Triggers and Views are very cool advanced features. When they get in the hands of the ‘not so smart’ developers, they have the potential of transforming into weapons of mass destructions. The reality of Trigger and Views are revealed here in this session. Hopefully, it will convince you to not use them in future coding.

• SolidQ Quiz Hour – One Contestant (Instructor) and Multiple Quiz Masters (All of You)

Here is your chance to ask your questions to the instructor which are so far not covered in any of the sessions. You can ask as many questions as you like as well bring your real world problems. The instructor will guide you towards attaining resolutions to your problems.

Day 2: Performance Tuning T-SQL with Solid Advanced Technique

• The Good, The Bad and The Ugly Side of Index – Evils of Index and Workarounds

The myth about Index is that it improves performance. The even bigger myth about Index is that it reduces performance. The reality is confusing and developers are lost trying to balance the performance of various queries involving multiple tables. In this session, learn what you should not do with Indexes. Once you master the wisdom of where and how to create them, the mystery of Indexes will be solved.

• Blood veins and Heartbeats! – The Intelligence of Statistics

This session is the soul of these two days of training. The mystery of SQL Server Engine will be opened wide in front of us. We will go over each and every detail which leads engine to give optimal performance to the query. We will also answer few important questions about statistics and its optimal settings.

• Sniffing Parameters is Injurious to Health! – Optimize Your Query for Unknown Values

Ever wondered why recompiling your query works faster? Ever wondered why restarting SQL Server Services improves the performance. Ever wondered how distribution of the data changes the cache plan. Here is your chance to learn the same and optimize any query for any of the unknown variable.

• Fast, Faster and The Fastest! – Turbo Fast Queries Techniques

This is the grand finale of two days. We will take a query which is already running in zero (0) millisecond and optimize it further by three levels. Each level will be more difficult than others and the end result will be stunning. This unique session will teach you interesting lessons at each level of optimization and will run the query faster than its original seep of zero (0) millisecond.

• SolidQ Quiz Hour – One Contestant (Instructor) and Multiple Quiz Masters (All of You)

This session will cover up any loose ends of the two days seminar. The best participant will also get a unique gift from the instructor.

To join the seminars drop an email to the following address. Himabvejella@gmail.com and IndiaInfo “at” SolidQ.com. If you specify MUGH in Title, you will avail special discount in overall rates on specified price. Yes, a more than 20% by using MUGH I promise. If you register using MUGH you will be eligible to win MS Freesoftwares, MSDN VS2010 license  and windows7 Ultimate DVD .

Current Schedule

• Chennai, India: Sep 24-25, 2010
• Colombo, Sri Lanka: Oct 4-5, 2010
• TBD, USA: Nov 15-16, 2010
• TBD, USA: Nov 17-18, 2010
• Hyderabad, India: Nov 27-28, 2010
• Pune, India: Dec 4-5, 2010

Complete Information in http://www.solidq.in/Training/DirectionsSeminar.aspx

If you have any questions please feel free to contact me . Please note that the lunch and snacks for the 2 days will be provided.
The Venue
Western Amrutha Castle, 5-9-16, Opp. Secretriat, Saifabad, Khairatabad, Hyderabad.
Hurry up the seats are limited only.

Training in Hyderabad for SQL Server 2008 and SharePoint 2010

Solid Quality Mentors,India Launches Public Training in Hyderabad for SQL Server 2008 and SharePoint 2010. Join Microsoft MVPs Pinal Dave of SQL Authority.com and Joy Rathnayake for the real-world information you need to get the most from your SQL Server and SharePoint implementations.

Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning (Pinal Dave—May 12-14, 2010)
This intensive, 3-day course gives attendees an in-depth look at query optimization and performance tuning in SQL Server 2005 and 2008. Designed to prepare SQL Server developers and administrators for a transition to SQL Server 2005 or 2008, the course covers best practices for a variety of essential tasks for maximizing performance.

SharePoint 2010 (Joy Rathnayake—May 10-11, 2010)
This comprehensive 2-day workshop—featuring five hands-on labs—begins with an overview of the Microsoft SharePoint 2010 environment and its underlying components. Day 1 focuses on SharePoint for the ITPro, showing you how to create and extend SharePoint Web Applications, work with content databases, manage authentication, manage sites, and much more. Day 2, focusing on development on the SharePoint Server 2010 platform, discusses the various solutions and code modules that developers can use to enhance SharePoint’s out-of-the-box functionality.

The fee for the SQL course is INR 14,000/person for the whole 3-day convention.AND INR 11,000/person for SharePoint 2010. At the rate of 1 USD = 44 INR, this fee converts to less than USD 300. At this rate, it is totally possible to fly from anywhere from the world to India and take the training and still save handsome pocket money. It would be even better if you register using the discount code “MUGH“, for you will instantly get an INR 3000 discount, reducing the total cost of the training to INR 11,000/person for whole 3 days course, INR 8000 per person for whole 2days course. This is a onetime offer and will not be available in the future. This offer is exclusively for the MUGH members only.
Fees & Registration
SQL Server 2005/2008 Query Optimization &Perf Tuning: Rs. 14,000
per participant
Day 1: Strengthening the Basics & SQL Server 2005/2008 Features
• Subqueries, Ranking Functions, Joins, and Set Operations
• Table Expressions
• TOP and APPLY
• SQL Server 2008 Enhancements

Day 2: Query Optimization & Performance Tuning, Part 1
• Logical Query Processing
• Query Tuning
• Introduction to the Query Processor
• Common Query-Coding Practices that Cause Poor Performance

Day 3: Query Optimization & Performance Tuning, Part 2
• SQL Server Indexing and Index Maintenance
• Plan Guides, Query Hints, UDFs, and Computed Columns
• SQL Server Execution Plans
• Real-World Index & Optimization Tips

SharePoint 2010: Rs. 11,000
per participant

Day 1: SharePoint 2010 Introduction and ITPro Overview
• SharePoint 2010 Introduction and New Features
• Working with SharePoint Web Applications and Sites
• Hands-on Lab: Creating a New Web Application, Site Collections, Configuring Navigation, and More
• Understanding and Configuring Workflow Services, Search, and Disaster Recovery
• Hands-on Lab: Out-of-the Box Workflows, Search & Indexing, and Backup & Restore
• Understanding SharePoint Designer 2010
• Hands-on Lab: Lists and Libraries, External Content Types, and Workflow Designer

Day 2: SharePoint 2010 Developer Overview
• Overview of SharePoint Development
• Developing Web Parts
• Hands-on Lab: Developing a Web Part using LINQ to SharePoint
• Understanding Business Connectivity Services (BCS)
• Hands-on Lab: Creating an External Content Type and Retrieving Data from SQL through BCS

• Comprehensive hands-on training
• 1:1 computers
• A/C class rooms with LCD projector
• Printed course materials
• Lunch and Tea provided

To register, contact:
Solid Quality India Pvt. Ltd.
Mangesh Pawar

Phone: (O) 022-4090-7376 | (M) 95940-43399 | (F) 022-4090-7379
MPawar@SolidQ.com or IndiaInfo@SolidQ.com

Please note that there is service tax of 10.2% for each participant fee

The Venue
Timings 10am-6pm
Training Center
Abridge Solutions, #90/B/C/3/1,
Ganesh GHR & MSY Plaza,
Vittalrao Nagar,
Near Image Hospital,
Madhapur, Hyderabad – 500 081.

Some of the feedback
“With his real-world experience in query tuning, Pinal uncovered some T-SQL query tuning myths that were very important and effective to know… With his excellent demos, he proved most of the tips to improve query performance were wrong. Thanks!”

“Pinal has extensive knowledge in his teaching materials and actual business implementation in real-life environments. The course is very interactive, which is a plus.”

“I was delighted with Joy’s presentation and technical skills.”

“The training was very helpful. The way Joy involved all of us was really commendable… he made it really interesting.”

How is it benificial for MUGH Members
Note: The participants who are registered only from MUGH has chance to win Windows 7 DVDs, MCTS Vouchers, T-Shirts and Goodies as free apart from Rs3000 discount per course per person.
This is the high quality training and your amount will be returned if you are not satisfied with the training.I know that SharePoint 2010, SQLServer 2008 is now hot in the market, as the software boom is coming again,this can be good opportunity to learn and update technology for a very reasonable cost.