SQLSaturday #36 - Wheeling 2010 5/1/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat36 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 457 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 507 Regional Economic Development Partnership Gold Sponsor http://www.TakeMeHomeOhioValley.com http://www.johnsterrett.com/img/REDlogo.gif 60 170 378 Red Gate Software Silver Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm?utm_source=ugutm_medium=uglogoutm_content=wheelingutm_campaign=redgate http://www.johnsterrett.com/img/RGOnWhite.png 60 170 519 ColdCypress, LLC Silver Sponsor http://www.coldcypress.com http://www.coldcypress.com/images/logo.gif 60 170 482 ProTech Professional Technical Services, Inc. Bronze Sponsor http://www.protechtraining.com http://www.johnsterrett.com/img/ProTech.gif 60 170 502 Quest Software Bronze Sponsor http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 545 Idera Bronze Sponsor http://www.idera.com http://www.johnsterrett.com/img/idera.jpg 60 170 349 West Virginia Northern Community College Hosting Sponsor http://www.wvncc.edu/CampusWheeling/AboutWheelingCampus.htm http://www.johnsterrett.com/img/WNCCLogo.jpg 40 100 573 Apress Media Swag Sponsor http://www.apress.com http://www.apress.com/resource/weblogo/Apress_120x60.gif 40 100 574 InformIT Media Swag Sponsor http://www.informit.com http://www.johnsterrett.com/img/InformIT.jpg 40 100 1017 John Sterrett Beginner Room3 If you are interested in learning how Analysis Services, Integration Services and Reporting Services can provide Business Intelligence this meeting is for you. We will start with the basic concepts of data warehousing including key terms and definitions. Next, we will cover some sample business cases while we walk through the process of designing a data warehouse. Once this session is complete you will be able to develop your first cube. 5/1/2010 10:15:00 AM 5/1/2010 11:15:00 AM 1226 Joe Harford Beginner Room3 It’s no secret that social networking is here to stay. Rather than shutting down all social networking at work organizations should put policies, procedures and training in place for responsible tweeting, blogging, etc. These policies should include responsible ways to use the media rather than abuse it. Included in this presentation will be ways to structure your policies. These methods will help your organization use social networking to promote your brand and educate consumers about new products and services. 5/1/2010 1:30:00 PM 5/1/2010 2:30:00 PM 1284 Joe Kuemerle SQL Server Room 1 Learn to protect data in your application by leveraging the built in encryption functionality in SQL Server 2005/2008 by taking a brownfield application and bringing it up to modern standards. Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008. 5/1/2010 1:30:00 PM 5/1/2010 2:30:00 PM 1285 Joe Kuemerle Development Room 2 It’s a contracting market. Companies are reducing costs across the board. With outsourcing and off-shoring achieving success, how can today’s in-house developer prove his value to the business? Technical expertise is valuable to product and technical management. However, it’s the developer’s understanding of the business and his role in generating revenue that’s invaluable. This presentation explains various techniques developers can use to increase their business savvy, proving they are providing value and not just an expense. 5/1/2010 9:00:00 AM 5/1/2010 10:00:00 AM 1298 Jeremiah Peschka SQL Server Room 1 'Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server. Session Goals After this session, attendees will: Know how to query SQL Server to gain insight into its internal state Understand the primary components of SQL Server and how they relate Apply their understanding of internals to daily queries to improve application and database performance' 5/1/2010 9:00:00 AM 5/1/2010 10:00:00 AM 1299 Jeremiah Peschka Development Room 2 Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit. Learn how to work effectively with diverse inputs. Learn how to avoid common pitfalls of dynamic SQL. Develop an understanding of real world uses for dynami 5/1/2010 11:30:00 AM 5/1/2010 12:30:00 PM 1398 Tim Beamer SQL Server Room 1 SQL Server is the database engine supporting the Line-of-Business applications that run your business, so how do you make sure it is always up and providing those critical services? This session will look at several alternatives for designing and implementing a highly availble architecture for your SQL environment. Options will be presented to give a range of availability scenarios based on Service Level Agreements, as well as budget. 5/1/2010 10:15:00 AM 5/1/2010 11:15:00 AM 1399 Tim Beamer SQL Server Room 1 Nobody wants to have a catastrophic event, but bad things happend to good datacenters. Whether it's 42 inches of snow, 18 inches of rain, extended power outage, whatever, your business needs to be able to operate. We'll start at a general level in terms of how to build your DR plan and then drill specifically into what you need to do to restore database services to an operational state. We'll draw on information from the High Availability session and add additional color commentary on what the most important things are to consider when building, and most importantly testing your DR plan. 5/1/2010 2:45:00 PM 5/1/2010 3:45:00 PM 1504 Bronwyn Altizer SQL Server Room 1 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. 5/1/2010 11:30:00 AM 5/1/2010 12:30:00 PM 1560 Matt Van Horn Beginner Room3 I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports. 5/1/2010 4:00:00 PM 5/1/2010 5:00:00 PM 1561 Matt Van Horn Beginner Room3 Walkthrough on using SQL Reporting Services 2008 and Business Development Studio to develop reports in both tabular and graphical formats. I will cover grouping, sorting, formulas, drill down reports, and formatting for both printed and interactive versions. 5/1/2010 2:45:00 PM 5/1/2010 3:45:00 PM 1632 Allen White Development Room 2 Most administrative functions consist of repetitive sequences of tasks which just take time. PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time. This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments. 5/1/2010 1:30:00 PM 5/1/2010 2:30:00 PM 1639 David Hoerster Development Room 2 Exposing your data to client applications is a common requirement across most applications; however, there are many ways to accomplish this. Each application seems to implement it a different way which leads to inconsistency across your application spectrum. With the release of the .NET Framework 3.5, Microsoft has introduced WCF Data Services (was ADO.NET Data Services) which is a collection of classes and standards to allow you to expose your data consistently and securely to your client applications. We'll focus on WCF Data Services in .NET 4, in which Microsoft has beefed up the offering, and also the data protocol known as OData. 5/1/2010 4:00:00 PM 5/1/2010 5:00:00 PM 1787 John Hidey Development Room 2 This session will walk you though building your first Silverlight data driven application. 5/1/2010 10:15:00 AM 5/1/2010 11:15:00 AM 1818 Von Scarberry Development Room 2 I will explore in depth the different techniques of how SSRS can streamline you applications reporting. This will include how SSRS differs from other reporting tool like Crystal Reports and Active Reports. I will cover export format streaming to PFD, Excel, and Word. I will also cover dynamic reporting in detail. Finally, I will cover best practices and reusability across ASP.net, winforms, and SSRS reporting server. 5/1/2010 2:45:00 PM 5/1/2010 3:45:00 PM 1830 Lunch Provided by Panera SQL Server Room 1 Lunch will be provided by Panera. We will have box lunches. 5/1/2010 12:30:00 PM 5/1/2010 1:30:00 PM 1831 Lunch Provided by Panera Development Room 2 Lunch Provided by Panera - 1st Floor Main Ballroom 5/1/2010 12:30:00 PM 5/1/2010 1:30:00 PM 1832 Lunch Provided by Panera Beginner Room3 Lunch is provided by Panera. We will ahve box lunches. 5/1/2010 12:30:00 PM 5/1/2010 1:30:00 PM