SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

BI

Mid April Free Training from PASS VCs

Apr 11th, 2011
by Aaron Nelson.
Comments are off for this post

www.sqlpass.orgBuilding Applications That A DBA Will Love
All About Analysis Services
_____________________________________________________________

Building Applications That A DBA Will Love
April 12, 2011, 12 PM Eastern
Presenter: Andy Warren
Attendee URL: LiveMeeting

It’s natural for the focus to be on the end user when we build applications, but it’s important and worthwhile to build into our design some things that make it easier for the DBA to provision, tune, and support the product we deliver. So what does a DBA care about? Performance of course, but also security, scalability, space usage, and yes, even documentation. This presentation will cover tips in a number of areas that address the concerns of the DBA, and we’ll talk about why you should care about making the DBA happy too!

Andy Warren

Andy Warren is a SQL Server consultant and trainer who occasionally writes some code too. He’s on the PASS Board of Directors, was a founding partner in SQLServerCentral.com, started the SQLSaturday event format, and is currently a SQL Server MVP. Andy blogs at www.sqlandy.com, and can be reached via Twitter as @sqlandy and on LinkedIn at www.linkedin.com/in/sqlandy.

How do I attend?
Attendee URL: LiveMeeting
_____________________________________________________________

Efficient and effective processing of OLAP CUBES with AMO and XMLA
Fri April 15th 12PM EST (US)
Speaker: Steve Simon

Topic Description:

Within the financial industry, rapid and effective decision making is critical to our client relationships. Analytical tools such as OLAP cubes help make this a reality. In many 24 X 7 enterprises, data capture and cube updates occur on an ongoing basis throughout the business day. We are able to achieve this through the innovative utilization of SQL Server Integration Services (SSIS). This intermediate level hands-on presentation will show the attendee how we have utilized Analysis Management Objects (AMO) commands and SSIS to ‘fire’ our OLAP CUBE updating processes. The presentation will discuss the high level concepts behind Analysis Management Objects (and the XMLA that is generated from the commands) and the scenarios under which we can benefit from their usage. Topics covered will be the updating of dimensions, measures, partitions, the cube and more.

Bio:

Steve Simon is an Assistant Vice President with State Street Corporation in Boston. He has been involved with database design and analysis for over 26 years. Steve has presented papers at eight North American PASS Summits (in Orlando, Seattle WA (4), Denver CO (2) and San Francisco CA), two at PASS Europe 2009 and one at PASS Europe 2010. He has just recently presented his PASS 2008 Summit presentation in Johannesburg South Africa. Steve is actively involved with the SQL Server community within the Boston area and is a regular presenter at the New England Code Camps and SQL Saturday events and participates actively on many of the Microsoft User Forums. He is also the Virtual Chapter leader of the Professional Association for SQL Server (PASS) Oracle – SQL Server Virtual Chapter and is a PASS regional mentor. He will also be presenting a data mining paper at SQL Teach in Montreal between May 31st , 2011 and June 3rd 2011.

URL: https://www.livemeeting.com/cc/usergroups/join?id=RPN4J9&role=attend&pw=J%25%7E*7r%229d

Early December 2010 Free Training From PASS VCs

Dec 6th, 2010
by Aaron Nelson.
Comments are off for this post
  • pass_logoUnderstanding 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

End of October Free Training from PASS Virtual Chapters

Oct 22nd, 2010
by Aaron Nelson.
Comments are off for this post

pass_logo

Applied MDX
Refactoring SQL Applications
Implementing SQL Server in a utility model
WIT Monthly Conference-Call
_____________________________________________________________

Applied MDX
Monday October 25th 12 pm EDT (GMT-4)
Kevin Geoff

Learning the basics of MDX is one thing – learning how to incorporate MDX into custom OLAP applications is another.  In this presentation, I’ll show several examples of MDX inside SSRS reports, PerformancePoint Services dashboards, and even inside of Excel.   We’ll also look at using MDX inside of OLAP calculated members and data-driven KPIs.  The attendee will come away with different perspectives on how MDX is necessary to create flexible OLAP reporting.

Kevin Geoff
Kevin is a 2010 SQL Server MVP ,2005-2008 .NET/C# MVP ,SQL Server/Business Intelligence senior instructor and courseware author – SetFocus, LLC ,Columnist for CoDe Magazine (Baker’s Dozen Productivity Series), and a Developer/consultant in the industry since 1987

How do I attend? Live Meeting link

_____________________________________________________________Refactoring Refactoring SQL Applications
Tuesday October 26th 12 pm EDT (GMT-4)
Jeremiah Peschka

Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.

Jeremiah Peschka
Jeremiah is an Emerging Technology Expert with Quest Software. Jeremiah works with different software to identify new techniques and trends in the world of data storage. Over the course of his career, Jeremiah has worked as a system administrator, developer, and DBA. Previously, Jeremiah spent 2 years at Cass Information Systems, a utility billing provider.

Jeremiah is involved in the Professional Association for SQL Server. When he is not volunteering with the development community, Jeremiah can be found blogging about data storage, relational databases, and software development at http://facility9.com. He can also be found on Twitter as @peschkaj.

How do I attend? Live Meeting link

_____________________________________________________________

Implementing SQL Server in a utility model
Wednesday October 27th 12 pm EDT (GMT-4)
Jason Massie

A SQL Server as a Service(SQLaaS) in a utility computing model can be a robust platform providing self service provisioning, better utilization of hardware and power, lower administrative overhead and chargeback capabilities. It can allow your internal and external customers to forget about the database and focus on developing and deploying apps that add value to your core business. In this session, we will cover key benefits of offering the DB in a utility computing model which could be part of your larger SOA strategy. Next, we will look at some key considerations from the DBA and IT decision maker’s perspective that will drive the infrastructure design. Several different architectures will be discussed along with their business driven considerations. We will look at SQL Server 2008 r2 features that are well suited for a utility model as well as SQL Server vNext and 3rd party tools. Lastly, we will look at areas that may require custom development to meet your specific needs.

Jason Massie
Jason has 10 years experience as a DBA and currently manages the Oracle and SQL Server DBA teams for Terremark. He is a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. You can read more about him at http://jasonmassie.com and contact him at jmassie at terremark.com

How do I attend? Live Meeting link

_____________________________________________________________

Women In Technology Conference Call
Wednesday October 27th 3pm CDT/1pm PDT (GMT-5/GMT-7)

Please email Wendy Pastrick ( email | twitter ) for dial in information

  • This will be our final call before the PASS Summit.
  • Final planning for our PASS presence: Welcome Reception,  WIT Luncheon, Chapter Lunch
  • Discussion about roles in the chapter
  • At the end of the meeting, we offer Open Mic time for people to share news or ask open ended questions

Mid October Free Training from PASS Virtual Chapters

Oct 19th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoIntroduction to PowerShell
Getting started with Steam Insight and Complex Event Processing Applications
Using Microsoft BI Tools to Access Oracle Applications Data
_____________________________________________________________

Introduction to PowerShell
Wednesday October 20th 12 pm EDT (GMT-4)
Chad Miller

Chad will get us started with an introduction to PowerShell as a command line for one-off tasks or automation in the DBA world. Basic PS principles and syntax will be covered. Get your proverbial DBA feet wet with a tool that can make your database and sysadmin life better than it was before! Bigger, stronger, faster. (Cue Bionic Man theme)

Chad Miller
Chad hails from the land of rocket launches, oranges, and alligators where he started the Tampa PowerShell User Group. Chad is the DBA for SQL Server and Manager of Database Administration for a shop supporting SQL Server, Oracle, and Informix, acts as coordinator for the SQL Server PowerShell Extensions CodePlex project, and maintains an active blog at http://sev17.com/author/chad-miller/ .

How do I attend? Registration for the event is now open.
*When you register you’ll get a calendar reminder for the event.
_____________________________________________________________

Getting started with Steam Insight and Complex Event Processing Applications
Wednesday October 20th 12 pm EDT (GMT-4)
Chris Coneybeer

Today we find our systems and users need to be able to quickly collect, analyze, and act upon data that is being streamed from an unlimited number of devices or systems in our enterprises. Frequently, this raw data is being collected from many different sources such as sensors on production lines, usage events from a website, or even just consumption data from a power meter. Generally this raw data goes through a time consuming process of collection, aggregation, and then querying before it can be used for business process decisions. SteamInsight is a new platform included with SQL Server 2008 R2 that is used to build Complex Event Processing (CEP) applications that are used to monitor these raw data streams. Using StreamInisght your applications will have the ability to analyze, correlate, and use the data contained in streams while it is in-flight. This is done by creating adapters that are responsible for monitoring streams and then writing queries against the adapters. During this session we will discuss what StreamInsight is, what stories it addresses in system architectures, and then we will look at some examples of using the Stream Insight platform and getting started with your own queries.

Chris Coneybeer
Chris is a C#/SQL developer with over 10 years of development experience working with Microsoft stack. Currently Chris works as an independent developer for small business and working in the banking industry as a contractor. Since his move the Phoenix area Chris has discovered the value and rich experience that community provides by sharing ideas and having open discussions. Chris enjoys working on connected systems and finding ways to leverage data for technology workers. During the years he has worked with VB6, VB.NET, C#.NET, ASP/ASP.NET, AJAX, XML, WCF, SSRS, SSIS, T-SQL, and other assorted technologies. His current interests include WCF, EF and WF improvements in the 4.0 framework along with SQL2008R2. Chris is the Vice-President of the Southeast Valley .NET User Group (SEVDNUG) in Chandler Arizona which supports local .NET developers through regular meetings and events. Recently he also gotten more involved with the Phoenix Connected Systems User Group(PCSUG) as Membership Director and is working with the leadership to grow the reach of the group.

How do I attend? Live Meeting link

_____________________________________________________________

Using Microsoft BI Tools to Access Oracle Applications Data
Wednesday October 20th 12 pm EDT (GMT-4) 

Daryl Orts

One of the challenges in using Microsoft’s BI tools (Reporting Services, Analysis Services, Excel, PowerPivot) to access Oracle applications data lies in building metadata models to make sense of the data.  Whether you’re accessing the data directly in the transaction database or building a data warehouse, you’ll need data models that make sense of the Oracle database schema.

This beginner to intermediate level presentation will discuss design approaches for building these models, including commercial products available from the presenter,  Noetix Corporation

How do I attend? Live Meeting link

Early October Free Training from PASS VCs

Oct 10th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoEnsure Business Continuity with SQL Server, Windows Server 2008 R2 and Hyper-V Live Migration
Maps Integration into Reporting Services
Use PowerShell to Get the Most out of SQL Server
Women in Technology discussion at SQL Saturday #49
_____________________________________________________________

Ensure Business Continuity with SQL Server, Windows Server 2008 R2 and Hyper-V Live Migration
October 12th 12:00 PM EDT (GMT -4)
Presenter: Ross Mistry

See ways to reduce deployment time and adapt to changes in hardware utilization or capacity requirements quickly, with minimal downtime, using SQL Server and Windows Server 2008 R2 Hyper-V Live Migration. The session will also focus on SQL Server Virtualization alternatives, high availability strategies within a virtualized environment and a real life demonstration of moving a SQL Server Virtual Machine from one physical host to another with Live Migration. Finally, the session will also include case studies based on designs at the Microsoft Technology Center.

Ross Mistry

Ross Mistry is an Enterprise Architect at Microsoft, bestselling author and a former SQL Server MVP. Ross focuses on designing and implementing SQL Server solutions for Microsoft’s largest customers at the Microsoft Technology Center in Silicon Valley. Ross is a frequent speaker at SQL Server community events such as SQL PASS, SQL Europe PASS, Connections and SQL Bits. His recent books include; Introducing SQL Server 2008 R2 (MSPress), Windows Server 2008 R2 Unleashed (SAMS) and SQL Server 2008 Management and Administration (SAMS). You can follow him on twitter @RossMistry.

How do I view the presentation?
Attendee URL:  Live Meeting link

_____________________________________________________________

Maps Integration into Reporting Services
October 12th 12:00 PM EDT (GMT -4)
Presenter: Matt Smith

The purpose of this presentation is to display the functionality of Bing maps integration into SSRS on SQL 2008 R2. Topics include how to use geospatial data, create map layers, and drill through actions to enhance usability of reporting.

Matt Smith

A Technology professional with over 5 years experience in various areas of software from database development and architecture to application development . Primary focus is on Business Intelligence. Industries include automotive, finance, healthcare, hospitality, education and real estate.  Matt takes pride in thinking outside the box, building customer relationships, and his liaison abilities between the technical and business worlds. Personal interests include anything sports or outdoor related, photography, salt water aquariums, and family.

How do I view the presentation?
Attendee URL: Live Meeting Link
_____________________________________________________________

Use PowerShell to Get the Most out of SQL Server
October 13th 12:00 PM MDT (GMT -6)
Presenter: Allen White

PowerShell is the new scripting environment from Microsoft for managing server environments.  Because PowerShell supports the .Net Framework, accessing SQL Server in a scripting environment is easier than ever before.  Whether you need to access data or manage SQL Server, PowerShell makes it possible.  This session will give an introduction to PowerShell, explain the basic ADO.Net objects required to connect with SQL Server, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective.

Allen White

Allen is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He’s spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT.  Allen has been awarded Microsoft’s MVP Award for the last four years. He’s active in the Ohio North SQL Server User’s Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at sqlbolg.com

How do I view the presentation?
Attendee URL: Live Meeting Link
_____________________________________________________________

Women in Technology discussion at SQL Saturday #49
October 16th 4:00 PM EDT (GMT -4)
Presenter: Kathi Kellenberger

This is a general round table discussion about women in technology. This presentation is open to men as well.

Kathi Kellenberger

Kathi, former SQL Server MVP, is a Data Technology Specialist with Microsoft in St. Louis. She is author of “Beginning T-SQL 2008″ (Apress) and co-author of “Professional SQL Server 2005 Integration Services” (Wrox) and “SQL Server MVP Deep Dives” (Manning) as well as over two dozen technical articles. Before joining Microsoft, Kathi was a DBA for Bryan Cave LLP, an international law firm. She has involved with the PASS community for several years, winning the PASSion award in 2008.

How do I view the presentation?
Sign up to attend SQL Saturday #49

End of September Free Training from PASS VCs

Sep 27th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoNext-Level SQLCLR: Parallel Processing and Bulk Load
SSRS R2: The New Stuff
_____________________________________________________________

Next-Level SQLCLR: Parallel Processing and Bulk Load
September 28nd 12:00 PM EDT (GMT -4)
Presenter: Adam Machanic

The power of SQLCLR as a performance tool has been well-documented at this point; certain queries, when re-written the right way using SQLCLR components, can run an order of magnitude more quickly. If you’re already using SQLCLR, or need that extra push, attend this session to discover how to take things one step further using advanced techniques and a custom SQLCLR component that will help you leverage the power of parallelism to burn through your rows more quickly than you ever thought possible. This session includes some of the material that will be covered in Adam Machanic’s full-day PASS Summit post-conference seminar, “A Day of Doing Many Things at Once: Multitasking, Parallelism, and Process Distribution.” More information on the seminar is available here: http://sqlpass.eventpoint.com/topic/details/AD311P

Adam Machanic

Adam is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including “SQL Server 2008 Internals” (Microsoft Press, 2009) and “Expert SQL Server 2005 Development” (Apress, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.

How do I attend?
Attendee URL: LiveMeeting Link
_____________________________________________________________

SSRS R2: The New Stuff
September 29th 12:00 PM EDT (GMT -4)
Presenter: Mike Davis

In this session Mike shows you the new features in Reporting Services 2008 R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts. Learn how to drill down from the US level to the state level using the map controls.

Mike Davis

Mike is a MCTS, MCITP, Senior BI consultant, and Trainer at Pragmatic Works.  He is an author of two Business intelligence books.  Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

URL: https://www.livemeeting.com/cc/usergroups/join?id=H2JWQQ&role=attend&pw=tS3%24Gtj%60z

Mid September Free Training from PASS VCs

Sep 9th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoThere’s going to be over 30 hours of free online SQL Server training next week and you’re not going to want to miss out!
Indexes and Other Free Performance Boosts
Building your 1st Performance Point Dashboard in SharePoint 2010
24 Hours of PASS: Summit Preview
_____________________________________________________________

Indexes and Other Free Performance Boosts
September 14th 12:00 PM EDT (GMT -4)
Presenter: Jeremiah Peschka

The database is often viewed as a major performance bottleneck. There are a number of quick, easy, painless techniques that can increase the performance of an application not just by a small amount, but by orders of magnitude. These techniques include simple indexing techniques, T-SQL techniques, and general database application design patterns that give great gains in performance. In this session, you will learn how to look at a database to identify these problem areas and how to resolve common issues that you will encounter.

Jeremiah Peschka

Jeremiah (blog|twitter) is a Database Expert with Quest Software. He is a SQL Server MVP, user group leader, and PASS Director at Large. Jeremiah has a passion for spreading knowledge and writing about himself in the third person. When not using a computer, Jeremiah can be found playing guitar, reading, writing, wandering around central Ohio, or speaking at various SQL Server events.

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=DJ8WK2&role=attend
_____________________________________________________________

Building your 1st Performance Point Dashboard in SharePoint 2010
September 14th 12:00 PM EDT (GMT -4)
Presenter: Adam Jorgensen

Many of you have seen the coolness that is PerformancePoint in SharePoint 2010. Come get hands on with Adam as we go through the ins and outs of creating your first dashboard.  See some of the cool visualizations you can use and how they work together to create a cool user experience.

Adam Jorgensen

Adam, MBA, MCDBA, MCITP: BI has over a decade of experience leading organizations around the world in developing and implementing enterprise solutions. His passion is finding new and innovative avenues for clients and the community to embrace business intelligence and lower barriers to implementation. Adam is also very involved in the community as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups for Business Intelligence and other organizations. He regularly speaks at industry group events, major conferences, Code Camps, and SQLSaturday events on strategic and technical topics.

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=K5S9BK&role=attend&pw=B%3B4%2F%7D38%3Br
_____________________________________________________________

One more quick note.  There’s this little online event going on the following day called the 24 Hours of PASS and this time it’s been rearranged to be timed better for the massive amount of Data Professionals in the Eastern half of the US [and Canada, Puerto Rico, The Bahamas, Bermuda, Virgin Islands, Netherland Antilles, & Brazil, etc… yeah them places too]

24 Hours of PASS: Summit Preview

Join an exceptional lineup of SQL Server and BI experts from around the world as they present a sneak peek of PASS Summit 2010 in 24 free live webcasts September 15-16.

This installment of 24 Hours of PASS delivers the hottest SQL Server and BI content directly to your computer – with a twist. Instead of running continuously for 24 hours, the September event divides the webcasts across 2 days, with each day beginning at 12:00 GMT (UTC). Check out what time it starts in your neck of the woods.

Dig into data warehousing, MDX, KPIs, and DTS-to-SSIS migration. Learn best practices for sizing database hardware and performance tuning. Get an in-depth look at PowerShell, storage for the DBA, and the latest T-SQL enhancements. And see how to manage teams, make your presentations rock, prepare for your next job, and more.

Tune in to hear your favorite MVPs and PASS Summit speakers, including Kalen Delaney, Andy Leonard, Kevin Kline, Brad McGehee, Allen White, and many more.

Register today for your top picks – or plan to attend them all!

Think the 24 Hours of PASS lineup is impressive? You won’t want to miss PASS Summit 2010 in Seattle, WA, Nov 8-11. The 24 Hours of PASS program gives you a glimpse at the unmatched technical content PASS Summit has to offer across more than 160 technical sessions, 14 pre/post-conference seminars, and invaluable networking opportunities.

Early September Free Training from PASS VCs

Sep 3rd, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoIntroduction to SQL Server Statistics
Designing High Performance I/O for SQL Server
Data Mining with PowerPivot 2010
_____________________________________________________________

Introduction to SQL Server Statistics
September 7th 12:00 PM EDT (GMT -4)
Presenter: Andy Warren

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.

Andy Warren

Andy Warren is a SQL trainer focusing on basic administration and performance tuning, he runs the free SQLShare.com training site, is currently a SQL Server MVP, blogs daily at SQLAndy.com, started the SQLSaturday franchise, is co-President of the Orlando SQL Server Users Group, serves as a member of the Board of Directors of PASS, and was a founding partner in SQLServerCentral.com. In his remaining free time he’s working on a book for first time managers.

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=2CHB5C&role=attend&pw=W%5Dw5%22K45B

_____________________________________________________________

Designing High Performance I/O for SQL Server
September 8th 12:00 PM EDT (GMT -6)
Presenter: Jimmy May

This session attempts to describe the “full story” of SQL Server I/O.  We will start at the hardware level working our way up the stack through Windows and into the SQL Server storage engine.  I aim to provide in depth information about all aspects related to the fundamentals of high performance storage design for SQL Server and best practices on this complex subject.

Jimmy May

Jimmy is a Sr. Program Manager for the SQL Server Customer Advisory Team.  He is the manager of the SQL Server Customer Lab where customers from around the world bring the biggest, fastest, & most interesting SQL Server apps for tuning.  He is a founder of both the Indiana Windows User Group (http://www.iwug.net) and Indianapolis Professional Association for SQL Server (http://www.indypass.org).  Jimmy recently moved to Redmond from Indianapolis, Indiana with his lovely bride, Phyllis, and Fannie May the Wonder Dog.  Subscribe to and read his SQL Server performance and personal productivity blog at http://blogs.msdn.com/jimmymay.  Contact him at jimmymay@microsoft.com or aspiringgeek@live.com.  Jimmy is also part of the rich & robust SQL Server community on Twitter:  www.twitter.com/aspiringgeek.

Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=S29G25&role=attend
_____________________________________________________________

Data Mining with PowerPivot 2010
September 8th 12:00 PM EDT (GMT -4)
Presenter: Mark Tabladillo

Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies.

Mark Tabladillo

Mark provides consulting and training for data mining with Solid Quality Mentors. He has taught statistics at Georgia Tech and for the graduate business school of the University of Phoenix. In addition to his Microsoft certifications (MCAD .NET and MCT), Mark has years of deep experience with the SAS System, and has presented at many local, regional, and national technical conferences.  Mark produces a data mining resource and blog at http://www.marktab.net

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=2J4ZPD&role=attend&pw=8QN%40qdzgQ

← Earlier Posts