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

PASS

Late September Free Training from PASS VCs

pass_logoThe DBA and Virtualization Virtual Chapters hope that last weeks 24 Hours of PASS got you in the mood for more free training.  Here’s what they have on tap for you this week:
Top 10 SQL Server Mistakes and Mis-steps
Storage and Virtualization for the DBA

_____________________________________________________________

Top 10 SQL Server Mistakes and Mis-steps
September 22nd 12:00 PM EDT (GMT -4)

Presenter: Tim Ford

From Tim Ford’s (@SQLAgentMan’s) continuing blog series on the same topic comes a presentation in which we’ll go over common mistakes made by new and seasoned SQL Server Professionals alike. Learn how to avoid these issues before they happen and correct matters after you’ve seen them in your environments.

Tim Ford
Tim is a Microsoft SQL Server MVP and SQL Server Professional with Next Wave Logistics, has been working with SQL Server since 1999. He is also an author of SQL-centric articles for MSSQLTips.com, SQLServerCentral, and Simple-Talk.com and just completed a book on the topic of SQL Server DMVs with Louis Davidson. He is the host for the annual Quizbowl at the PASS Summit each Fall. 

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

_____________________________________________________________

Storage and Virtualization for the DBA
September 23rd 12:00 PM EDT (GMT -7)

Presenter: Denny Cherry

This is a preview of Denny’s full day PASS Summit pre-conference session in which Denny disccusses how storage can be one of the biggest bottlenecks when it comes to database perfomance and how to troubleshoot storage performance issues and tie the virtual platforms to the storage array so that you can maximize the storage performance for your SQL Servers and the virtual environment.

Denny Cherry
Denny has over a decade of experience managing SQL Server, including MySpace.com’s over 175 million user installation, one of the largest in the world.  Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting.  Denny currently holds several Microsoft Certifications related to SQL Server as well as being a Microsoft MVP.  Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management.

Live Meeting Link:
https://www.livemeeting.com/cc/usergroups/join?id=J8RZQ8&role=attend&pw=RFxB5D%2FsM

Mid September Free Training from PASS VCs

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

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

Columbus and Edmonton Code and Slides

I spoke in Columbus, GA and Edmonton, um…, somewhere in Canada on back to back nights this Tuesday and Wednesday. (I’m kidding, I know it’s in Alberta, and you guys like the Jets right? ;-) ) I used the same slide deck for both sessions; well, for Edmonton I didn’t even use a slide deck, but the scripts I covered were a little different.

image I’ve recently learned that if you only have PowerPoint 2007 you’ll need to download this viewer because I built the slides in PowerPoint 2010. Here are the scripts for Columbus and Edmonton.

I think both events went really well and got a lot of people saying: ‘Hey, this PowerShell stuff could work in my environment’. I really hope they catch the fever! I’d love to speak to each of these groups next year and see what questions they come up with and see how much they’re using it. I’ve got a more advanced session that I will be debuting a little later this year so hopefully I’ll get to share it with them too.

Huge thanks to Jonathan Boulineau ( twitter ) and Colin Stasiuk ( blog | twitter ) for all they do for their groups all year long.