SQLSaturday #66 - Colorado Springs 2011 2/12/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat66 Colorado Springs CO 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 882 Data Realized Platinum Sponsor http://www.datarealized.com/ http://www.sqlsaturday.com/files/9c96c827-a67a-41be-b010-865e07b76add.jpg 60 170 899 Red Gate Software Gold Sponsor http://www.red-gate.com http://www.sqlsaturday.com/files/0b418d2e-a6a1-40d2-8e95-33e09a55fca4.jpg 60 170 986 Quest Software Gold Sponsor http://www.sqlserverpedia.com http://www.quest.com/images/common/quest_logo.gif 60 170 908 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 934 Telerik Bronze Sponsor http://www.telerik.com http://www.sqlsaturday.com/files/adb9bf3c-3187-401d-bb0d-3fc9f0690e3c.png 60 170 943 SQL Server Magazine Bronze Sponsor http://www.sqlmag.com/ http://www.sqlsaturday.com/files/20fb4060-b26e-4c9c-b5dc-964f88a67cf8.jpg 60 170 880 O'Reilly Media, Inc. Swag Sponsor http://ug.oreilly.com/ http://www.sqlsaturday.com/files/cf10f8e2-faf1-4402-901e-924d40b898f3.gif 40 100 883 Wrox Swag Sponsor http://www.wrox.com/WileyCDA/Section/id-105001.html http://www.sqlsaturday.com/files/7088c6de-ae6a-4b1c-9337-eaf9ea5fbbef.gif 40 100 903 SQL Share Swag Sponsor http://sqlshare.com/ http://www.sqlsaturday.com/files/06d1c38f-993d-436b-bc99-36970f4a7a58.jpg 40 100 932 Gerasus Software Swag Sponsor http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 40 100 946 Webucator Swag Sponsor http://www.webucator.com/database/sql.cfm http://www.sqlsaturday.com/files/c598cdca-149c-4ad3-81fe-c3b4d57f98f1.jpg 40 100 948 SAPIEN Technologies, Inc Swag Sponsor http://www.sapien.com/ http://www.sqlsaturday.com/files/3a6a3e57-30d6-47bd-b0b8-0eebd6549017.png 40 100 1051 Chris Gosnell Photography Photograhy http://www.chrisgosnellphoto.com/ http://www.sqlsaturday.com/files/b37ebcb0-f77d-4bdd-a1d7-81132c816615.jpg 40 100 3072 Steve Jones Track 1 Blue Room Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job. 2/12/2011 8:45:00 AM 2/12/2011 9:45:00 AM 3120 Gabriel Villa Track 3 Yellow Room Become aware of some commonly overlooked practices in securing you SQL Server databases. Learn about physical security, passwords, privileges and roles, restricting or disabling system stored procedures and preventative best practices. And most importantly, discuss the most commonly used security threat: SQL injection and learn how to prevent them. 2/12/2011 12:15:00 PM 2/12/2011 1:15:00 PM 3133 Meredith Ryan-Smith Track 3 Yellow Room Most ‘accidental DBAs’ start their foray in to database administration in a similar way. You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all. I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available. 2/12/2011 10:15:00 AM 2/12/2011 11:15:00 AM 3146 Mark Halstead Track 1 Blue Room SQL Server performance tuning with an emphasis on finding the bottlenecks, Query design problems and database design problems. 2/12/2011 1:30:00 PM 2/12/2011 2:30:00 PM 3149 Doug Lane Track 2 Green Room Designing a fast, elegant report for Reporting Services can be challenging. In this session, we'll cover design methods you can start using right away to create faster reports with fewer headaches and in less time. We'll also look at how to deal with potentially frustrating aspects of report appearances like border behavior, multi-column layouts, and unwanted blank pages. 2/12/2011 12:15:00 PM 2/12/2011 1:15:00 PM 3198 William Pearson Track 1 Blue Room The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate largely upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions. 2/12/2011 10:15:00 AM 2/12/2011 11:15:00 AM 3276 Dean Richards Track 2 Green Room More and more companies are virtualizing with VMWare, and SQL Server databases are moving in that direction as well. This presentation will explore the fundamentals of running SQL Server in a VMWare environment. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks and cover best practices for maintaining optimum performance in a SQL Server / VMWare environment. 2/12/2011 8:45:00 AM 2/12/2011 9:45:00 AM 3310 Randy Knight Track 3 Yellow Room Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been. 2/12/2011 1:30:00 PM 2/12/2011 2:30:00 PM 3330 Tom Norman Track 2 Green Room Policy Based Management, what is this? What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers. 2/12/2011 10:15:00 AM 2/12/2011 11:15:00 AM 3379 Glenn Berry Track 2 Green Room The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD. 2/12/2011 1:30:00 PM 2/12/2011 2:30:00 PM 3391 Ted Malone Track 2 Green Room Introduced with SQL Server 2008 R2 and Visual Studio 2010, Data Tier Applications (DACs) help to simplify the development lifecycle of SQL Server database applications. DACs can be integrated into larger Visual Studio application projects and make for a very integration application development lifecycle. In this session, you will learn about DACs and how to use Visual Studio to build SQL Server Data Tier Applications. This session will also discuss creating DACs from existing database structures and will demonstrate how to integrate existing databases into Visual Studio application solutions. 2/12/2011 3:15:00 PM 2/12/2011 4:15:00 PM 3401 Bill Fellows Track 1 Blue Room Too busy to read BOL to figure out what they've added? This purely demo based presentation will give you a taste of what new language features are available to make your life easier. Sure, you might know about CTEs and windowing functions, but what about the new data types (geospatial, xml, etc), DMOs and query hints. Stop in and see if I can rattle off a feature a minute. 2/12/2011 12:15:00 PM 2/12/2011 1:15:00 PM 3442 Carlos Bossy Track 1 Blue Room One of my clients, the Department of Human Services, wants to predict which children that leave foster care will have to return to foster care at later date. Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to develop a data mining model using Analysis Services from conception to deployment using internal and external data, and you will see how to get and display results. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications. 2/12/2011 3:15:00 PM 2/12/2011 4:15:00 PM 3467 Chris Shaw Track 1 Blue Room Welcome to SQL Saturday #66. We will be covering the schedule for the day and what attendee's can expect from the training and from the 'Special Networking Events'. 2/12/2011 8:00:00 AM 2/12/2011 8:15:00 AM 3714 Chris Shaw Track 2 Green Room Welcome\Keynote 2/12/2011 8:00:00 AM 2/12/2011 8:15:00 AM 3715 Chris Shaw Track 3 Yellow Room Welcome\KeyNote 2/12/2011 8:00:00 AM 2/12/2011 8:15:00 AM 3716 Chris Shaw Track 1 Blue Room Networking Session 1 2/12/2011 8:15:00 AM 2/12/2011 8:45:00 AM 3717 Chris Shaw Track 2 Green Room Networking Session 2 2/12/2011 8:15:00 AM 2/12/2011 8:45:00 AM 3718 Chris Shaw Track 3 Yellow Room Networking Session 3 2/12/2011 8:15:00 AM 2/12/2011 8:45:00 AM 3719 Chris Randall Track 3 Yellow Room Are you a Business Intelligence developer? Have you built a SQL Server Reporting Services, Analysis Services or Integration Services solution? Have you deployed to a test server and are wondering 'Now what?' Or are you a production SQL Server DBA who's been informed that since SSAS, SSIS or SSRS have 'SQL' in their name, you have to take over the day-to-day management of a SQL BI project? This fast-paced session will look at what it takes to manage and administer projects created with the SQL Server BI products. We'll look at the management tools, deployment lifecycles, security capabilities and disaster recovery processes for these products. We'll see why, if you're a developer, you might still need your DBA, or if you're a DBA, you might 2/12/2011 8:45:00 AM 2/12/2011 9:45:00 AM 3720 Networking Session 4 Networking Session 4 Track 1 Blue Room Networking Session 4 2/12/2011 9:45:00 AM 2/12/2011 10:15:00 AM 3721 Networking Session 5 Networking Session 5 Track 2 Green Room Networking Session 5 2/12/2011 9:45:00 AM 2/12/2011 10:15:00 AM 3722 Networking Session 6 Networking Session 6 Track 3 Yellow Room Networking Session 6 2/12/2011 9:45:00 AM 2/12/2011 10:15:00 AM 3723 Lunch\Meet the experts\WIT Lunch\Meet the experts\WIT Track 1 Blue Room Lunch\Meet the experts\WIT 2/12/2011 11:15:00 AM 2/12/2011 12:15:00 PM 3724 Lunch\Meet the experts\WIT Lunch\Meet the experts\WIT Track 2 Green Room Lunch\Meet the experts\WIT 2 2/12/2011 11:15:00 AM 2/12/2011 12:15:00 PM 3725 Lunch\Meet the experts\WIT Lunch\Meet the experts\WIT Track 3 Yellow Room Lunch\Meet the experts\WIT 3 2/12/2011 11:15:00 AM 2/12/2011 12:15:00 PM 3726 Break Break Track 1 Blue Room Break 1 2/12/2011 1:15:00 PM 2/12/2011 1:30:00 PM 3727 Break Break Track 2 Green Room Break 2 2/12/2011 1:15:00 PM 2/12/2011 1:30:00 PM 3728 Break Break Track 3 Yellow Room Break 3 2/12/2011 1:15:00 PM 2/12/2011 1:30:00 PM 3729 Networking Networking Track 1 Blue Room Networking 7 2/12/2011 2:30:00 PM 2/12/2011 3:00:00 PM 3730 Networking Networking Track 2 Green Room Networking 8 2/12/2011 2:30:00 PM 2/12/2011 3:00:00 PM 3731 Networking Networking Track 3 Yellow Room Networking 9 2/12/2011 2:30:00 PM 2/12/2011 3:00:00 PM 3732 Networking Networking Track 1 Blue Room Networking 10 2/12/2011 4:15:00 PM 2/12/2011 5:00:00 PM 3733 Networking Networking Track 2 Green Room Networking 11 2/12/2011 4:15:00 PM 2/12/2011 5:00:00 PM 3734 Networking Networking Track 3 Yellow Room Networking 12 2/12/2011 4:15:00 PM 2/12/2011 5:00:00 PM 3735 Break Break Track 1 Blue Room Break 4 2/12/2011 3:00:00 PM 2/12/2011 3:15:00 PM 3736 Break Break Track 2 Green Room Break 5 2/12/2011 3:00:00 PM 2/12/2011 3:15:00 PM 3737 Break Break Track 3 Yellow Room Break 6 2/12/2011 3:00:00 PM 2/12/2011 3:15:00 PM 3739 TJ Belt Track 3 Yellow Room We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge. 2/12/2011 3:15:00 PM 2/12/2011 4:15:00 PM