Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Early December 2010 Free Training from PASS Virtual Chapters

By Aaron Nelson,

  • Understanding Join Operators
  • How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads
  • Using OLAP to Optimize and Maintain Predictive Analytics Models

--------------------------------------------------------------------------------
Understanding Join Operators
December 7, 2010 12 PM noon Eastern Time (GMT -5)
Ami Levin

SQL Server implements three different physical operators to perform joins. In this session, we will examine how each of these operators works, including its advantages and challenges. Using real life examples, we will better understand the logic behind the optimizer's decisions on which operator to use for various joins. Finally, we will learn how to avoid some common join related pitfalls and how to get better performance from our queries.

Ami Levin
Ami is a Microsoft SQL Server MVP, with over 20 years of experience in the IT industry. For the past 12 years, he has been consulting, teaching and speaking on SQL Server worldwide. He manages the Israeli SQL Server user group, leads the local support forum, and is a regular speaker at Microsoft conferences. Ami is the CTO and co-founder of DBSophic, a company that develops workload tuning solutions for SQL Server applications.

How do I attend? Live Meeting link

--------------------------------------------------------------------------------
Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads
December 8, 2010 12 PM noon Mountain Time (GMT -7)
Glenn Berry

SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to both 2005, 2008 and 2008 R2), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

Glenn Berry
Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, full text search, and SQL Azure.

How do I attend? Live Meeting link

--------------------------------------------------------------------------------
Using OLAP to Optimize and Maintain Predictive Analytics Models
December 10, 2010 12 PM noon Eastern Time (GMT -5)
Eugene Asahara

In complex Predictive Analytics (PA) scenarios where it is being applied to a complex system or the players involved are actually trying to undermine the predictions (ex: credit card fraud), the sophistication of the PA must be taken up a notch or two. In this Webcast I will describe techniques for building sophisticated PA systems on the Microsoft BI Stack by using OLAP to:
- Analyze, validate, and optimize PA models.
- Manage and Monitor the performance of the PA models in a Performance Management style.
- Surface PA results to end users in a manner that allows them to work through the ambiguity that remains around predictions.

Eugene Asahara
Eugene specializes in high-end Analysis Services implementation and performance tuning, predictive analytics, and overall BI architecture. He has thirteen years of experience on the Microsoft BI stack; including one year on the SSAS product team and seven years as a Lead DB/BI Architect at Microsoft Consulting Services. Aside from consulting on BI engagements by day Eugene develops bleeding-edge BI software by night. Many of his thoughts around BI and that bleeding-edge space can be found at www.softcodedlogic.com.

How do I attend? Live Meeting link

Total article views: 966 | Views in the last 30 days: 1
 
Related Articles
FORUM

Microsoft SQL Server Management Studio Question

Microsoft SQL Server Management Studio Question

BLOG

Predictions for 2014

I love technology predictions because they are usually so wildly inaccurate that at the end of the y...

BLOG

Microsoft Releases Updated White Paper on Troubleshooting SQL Server 2008 Performance

Microsoft has finally updated their classis Troubleshooting SQL Server Performance white paper for S...

FORUM

microsoft sql server management studio is unable to load this document. Class not registered

microsoft sql server management studio is unable to load this document. Class not registered

BLOG

Microsoft Master Data Services in SQL Server 2012

Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Micro...

Tags
free training    
pass    
virtual chapters    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones