I’m speaking at SQL Saturday #108 on the Microsoft campus in Redmond today. This post is just for those who would like the scripts & slides from today’s demos. Enjoy!
If someone had told me two years ago that this Saturday I’d be speaking for the second time this year [let alone in my entire life] on the Microsoft campus in Redmond I’d have suggested they seek professional (ahem, psychiatric) help. A surprise to us all, I survived the community vote and will be speaking at SQL Saturday #108 in Redmond, WA this weekend. I’m very excited that A) at least *some* people aren’t tired of hearing me speak [yet] and B) I get to speak on the Microsoft campus!!!!! The folks at Idera are sending Wes Brown ( blog | twitter ) and myself out to this event as part of their ACE program. If you’ve never been to one of Wes’ sessions, you need to go. I offer a money back guarantee that you will laugh at least once during his session. The reason I bring all this up is that they are now recruiting a fresh crop of ACEs for 2012. If you’d be interested in finding out more about the ACE program, drop David Fargo ( twitter | email ) a line by this Friday and tell him that you’d like to hear more. Start Time Capitol Hill – Room: Room 2003 Montlake – Room: Room 2007 Pioneer Square – Room: Room 2011 Queen Anne – Room: Room 2015 07:45 AM Registration Registration Registration Level: Beginner Registration Registration Registration Level: Beginner Registration Registration Registration Level: Beginner Registration Registration Registration Level: Beginner 08:45 AM Buck Woody KeyNote Level: Beginner Buck Woody KeyNote Level: Beginner Buck Woody KeyNote Level: Beginner Buck Woody KeyNote Level: Beginner 09:45 AM Steve Stedman Unleashing Common Table Expressions in SQL Server* Level: Intermediate Paul Turley Dashboard Design: Making Reports Pop Level: Intermediate Brad McGehee Inside the SQL Server Transaction Log Level: Intermediate John Huang Parallel Task Scheduling with T-SQL Level: Advanced 11:00 AM Mark Simms The Elephant in the Room (Hadoop for DBAs) Level: Intermediate Wil Sisney 5 SSIS Tricks to Take You from Beginner to Awesome Level: Beginner Mark Tabladillo Enterprise Data Mining with SQL Server Level: Intermediate Hugo Kornelis Advanced indexing Level: Advanced 12:00 PM lunch Session Presentations by Red-Gate and Quest. Level: Beginner lunch Session Presentations by Red-Gate and Quest. Level: Beginner lunch Session Presentations by Red-Gate and Quest. Level: Beginner lunch Session Presentations by Red-Gate and Quest. Level: Beginner 02:00 PM Piotr Palka Database lifecycle with Visual Studio 2010 and TFS Level: Beginner Donabel Santos SQL Server Reporting Services – Beyond the Basics Level: Intermediate Merrill Aldrich PowerShell 101* Level: Beginner Argenis Fernandez Troubleshooting SQL Server with SysInternals Tools Level: Advanced 03:15 PM Dev Nambi Database Development: Keep It Agile, Not Fragile* Level: Intermediate Douglas Barrett Data Warehousing Update Level: Advanced Aaron Nelson PowerShell for Data Professionals Level: Intermediate Diane Robey Merge Replication for High Availability Level: Intermediate 04:30 PM Rick Morelan Basic Performance Tips and Gotchas* Level: Beginner David Eichner SRS Report Builder for Business Intelligence Level: Beginner Kevin Kline Top 10 Admin Mistakes on SQL Server Level: Intermediate Wesley Brown Fundamentals of SAN, NAS and IP Storage Level: Intermediate 05:30 PM Prize Drawings Prize Drawings, thank yous. Level: Beginner Prize Drawings Prize Drawings, thank yous. Level: Beginner Prize Drawings Prize Drawings, thank yous. Level: Beginner Prize Drawings Prize Drawings, thank yous. Level: Beginner
Atlanta MDF presents: SQL Saturday #111 Pre-Conference Sessions SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve managed to schedule 3 awesome pre-con sessions for the Friday before (April 13). They will cover a broad spectrum of topics: Performance Tuning, SSIS, and SSRS. Registration is limited, so go take a look and see if you or someone from your company can benefit from this great training opportunity. Also don’t forget that we will have an absolutely amazing lineup of presenters for Saturday! We’ll be announcing the final schedule for SQL Saturday #111 by Monday, February 13th. Registration is open, and we’re already halfway to capacity, so head out to SQLSaturday.com to reserve your seat. _____________________________________________________________ Andy Leonard and Matt Masson– A Day of SSIS – http://dayofssis.eventbrite.com/ A Day of SSIS was developed by Andy Leonard to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions. The training is focused around lectures and emphasizes a practical approach. The target audience for this training is database professionals, application developers, and business intelligence practitioners interested in acquiring or expanding their existing SSIS skill set. No experience with SQL Server or SQL Server Integration Services is required before attending this training. It is helpful (but not required) that students possess some knowledge of and experience with relational databases. SQL Server knowledge / experience will be more helpful than experience and knowledge with other technologies. _____________________________________________________________ Adam Machanic – No More Guessing! An Enlightened Approach to Performance Troubleshooting – http://nomoreguessing.eventbrite.com/ Scratching your head, you stare at the screen. Should you rebuild an index? Create a new one? Reboot the server? Why is this query so slow?!? Figuring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution―or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. Yet finding the root cause of most performance issues is a simple exercise, once you understand where to look and when. In this full day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues. All of this will be illustrated through complete demonstrations that will teach you how to drill from high-level problem detection all the way to specific spot in a query plan or deeper―pinpointing the exact problem and helping you to quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting. _____________________________________________________________ Jessica Moss – Learn SSRS in a Day – http://ssrsinaday.eventbrite.com/ SQL Server MVP, Jessica M. Moss, presents an exciting, introductory, full day training session on SQL Server Reporting Services 2008 R2. In the three-part class, Jessica will teach you how to build reports from the ground up. In Part 1, learn the basics of report development, including picking a report development tool and creating your first report. Part 2 delves into visualizations, groupings, and drill-down functionality. Finally, Part 3 highlights core administration tasks in Reporting Services. In addition, Jessica will point out industry-wide best practices for report development and show numerous live demos using a variety of data sources. Friday, April 13, 2012 Georgia State University – Alpharetta 3775 Brookside Pkwy Alpharetta, GA Register for pre-conference sessions by March 15 for $99! ($109 after March 15) For registration to the Saturday Event and more information visit http://www.sqlsaturday.com/111/eventhome.aspx.