SQLSaturday #80 - Wheeling 2011 7/23/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat80 Wheeling WV 26003 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 1243 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1301 Redgate Silver Sponsor http://redg.at/hImdeA http://www.sqlsaturday.com/files/98485fd3-4d2b-49ff-8d00-1f05932d3834.jpg 60 170 1390 Remote DBA Experts Silver Sponsor http://www.remotedbaexperts.com 60 170 1220 CozyRoc LLC Bronze Sponsor http://cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1242 Idera Bronze Sponsor http://www.alertlogic.com http://www.sqlsaturday.com/images/resized%20-%20idera_logo.png 60 170 4098 William E. Pearson III Track 2 Room 2 In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …” 7/23/2011 2:40:00 PM 7/23/2011 3:40:00 PM 4104 William E. Pearson III Track 2 Room 2 As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence. 7/23/2011 1:30:00 PM 7/23/2011 2:30:00 PM 4408 Paul Hiles Track 3 Room 3 DMVs - Dynamic Management Views and Functions are the DBA’s looking glass into the internals of SQL Server. They will give a DBA a snapshot on how the database is performing and potential problem areas. In this session, we will review a number of DMVs describing the types of information that can be captures and how it might be used. This review will include index statistics, query performance, memory utilization to name a few. 7/23/2011 9:10:00 AM 7/23/2011 10:10:00 AM 4410 Paul Hiles Track 1 Room 1 DBA’s traditionally have a library of T-SQL scripts which they use in automating their job. PowerShell, Microsoft’s newest scripting language, can take those T-SQL scripts to the next level. PowerShell and the SMO (Server Management Objects) library allow a DBA to create scripts that will interact with the OS and SQL Server at the same time. In this session we reveal the power of automating SQL Server with PowerShell by reviewing a number of scripts that have been migrated from T-SQL to PowerShell. This session will include scripts that will backup databases, interrogate a server, and script out objects from a database. 7/23/2011 11:30:00 AM 7/23/2011 12:30:00 PM 4430 Allen White Track 3 Room 3 How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data. 7/23/2011 10:20:00 AM 7/23/2011 11:20:00 AM 4431 Allen White Track 3 Room 3 The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action. 7/23/2011 2:40:00 PM 7/23/2011 3:40:00 PM 4464 James Gaines Track 2 Room 2 Automating Database source code control and deployments 7/23/2011 3:50:00 PM 7/23/2011 4:50:00 PM 4466 Craig Purnell Track 1 Room 1 Review of Database Mirroring in the context of operations in the real world. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; discussion of the pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location. 7/23/2011 2:40:00 PM 7/23/2011 3:40:00 PM 4467 Craig Purnell Track 1 Room 1 NoSQL (or, more correctly NoRel) is a moniker applied to a family of non relational software systems for storing data and/or documents that powers some of the largest sites on the internet. Amazingly enough, some of these platforms have been around a very long time. A high level discussion of some of the pros and cons of this technology compared to traditional systems like Oracle and SQL Server. A survey of the most popular 'NoSQL' platforms and who uses them. 7/23/2011 3:50:00 PM 7/23/2011 4:50:00 PM 4511 Joey Dantoni Track 2 Room 2 Interested in high availability, but don't know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs. This will include a brief on what is coming down the pipe in Denali. Of course, SQL Server will be included in this process. 7/23/2011 11:30:00 AM 7/23/2011 12:30:00 PM 4539 Andy Leonard Track 3 Room 3 In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application. 7/23/2011 1:30:00 PM 7/23/2011 2:30:00 PM 4540 Andy Leonard Track 3 Room 3 This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up. 7/23/2011 11:30:00 AM 7/23/2011 12:30:00 PM 4554 Ed Wilson Track 1 Room 1 Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences. 7/23/2011 9:10:00 AM 7/23/2011 10:10:00 AM 4639 Matthew Velic Track 2 Room 2 So you’re ready to dump that Excel “database” and join the SQL Server crowd? Matt Velic will guide you on a whirlwind tour of Transact-SQL. You’ll learn a little about its history, what Data Definition Language (DDL) and Data Manipulation Language (DML) are, and how to write basic statements of your own. Finally, Matt will leave you with some resources that will take your T-SQL skills to the next level. 7/23/2011 9:10:00 AM 7/23/2011 10:10:00 AM 4693 Shannon Lowder Track 3 Room 3 A brief introduction to your life as a DBA. From the topics you'll want to be familiar with, to choosing third party tools to help you do your job with less effort, this is the bootstrap guide to getting started as a DBA. Download session here: http://prezi.com/ezadmrybl4ks/lessons-learned-starting-your-career-as-a-dba. 7/23/2011 3:50:00 PM 7/23/2011 4:50:00 PM 4719 Ed Wilson Track 1 Room 1 Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences. 7/23/2011 10:20:00 AM 7/23/2011 11:20:00 AM 4757 None None Track 1 Room 1 Registration Breakfast 7/23/2011 8:30:00 AM 7/23/2011 8:45:00 AM 4757 None None Track 2 Room 2 Registration Breakfast 7/23/2011 8:30:00 AM 7/23/2011 8:45:00 AM 4757 None None Track 3 Room 3 Registration Breakfast 7/23/2011 8:30:00 AM 7/23/2011 8:45:00 AM 5089 Bronwyn Altizer Track 2 Room 2 Using Wait Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues. 7/23/2011 10:20:00 AM 7/23/2011 11:20:00 AM 5090 Abi Chapagai Track 1 Room 1 In SQL Server 2005 and later version of SQL Server, there are different technologies that are used to server as High Availability Solutions and they can be implemented as Disaster Recovery Solutions. Many critical systems need to be online 24x7 with very minimum downtime, if possible, without any downtime. To achieve this need, we can implement high availability solutions that are available in SQL Server. Which we want to implement? There are several of them: Replication, Database Mirroring, Log Shipping, Failover Clustering, and Replication. In this session, we will be talking about these technologies, their usage, advantages, and disadvantages using one over the other. 7/23/2011 1:30:00 PM 7/23/2011 2:30:00 PM