SQLSaturday #66 - Colorado Springs 20112/12/2011 12:00:00 AMSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat66Colorado SpringsCO882Data Realizedhttp://www.datarealized.com/http://www.sqlsaturday.com/files/9c96c827-a67a-41be-b010-865e07b76add.jpg60170899Red Gate Softwarehttp://www.red-gate.comhttp://www.sqlsaturday.com/files/0b418d2e-a6a1-40d2-8e95-33e09a55fca4.jpg60170986Quest Softwarehttp://www.sqlserverpedia.comhttp://www.quest.com/images/common/quest_logo.gif60170908Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/ignite_confio_logo.gif60170934Telerikhttp://www.telerik.comhttp://www.sqlsaturday.com/files/adb9bf3c-3187-401d-bb0d-3fc9f0690e3c.png60170943SQL Server Magazinehttp://www.sqlmag.com/http://www.sqlsaturday.com/files/20fb4060-b26e-4c9c-b5dc-964f88a67cf8.jpg60170946Webucatorhttp://www.webucator.com/database/sql.cfmhttp://www.sqlsaturday.com/files/c598cdca-149c-4ad3-81fe-c3b4d57f98f1.jpg40100948SAPIEN Technologies, Inchttp://www.sapien.com/http://www.sqlsaturday.com/files/3a6a3e57-30d6-47bd-b0b8-0eebd6549017.png40100903SQL Sharehttp://sqlshare.com/http://www.sqlsaturday.com/files/06d1c38f-993d-436b-bc99-36970f4a7a58.jpg40100883Wroxhttp://www.wrox.com/WileyCDA/Section/id-105001.htmlhttp://www.sqlsaturday.com/files/7088c6de-ae6a-4b1c-9337-eaf9ea5fbbef.gif40100932Gerasus Softwarehttp://www.gerasus.com/http://www.gerasus.com/images/logo.png40100880O'Reilly Media, Inc.http://ug.oreilly.com/http://www.sqlsaturday.com/files/cf10f8e2-faf1-4402-901e-924d40b898f3.gif401001051Chris Gosnell Photographyhttp://www.chrisgosnellphoto.com/http://www.sqlsaturday.com/files/b37ebcb0-f77d-4bdd-a1d7-81132c816615.jpg401003401Bill FellowsBill has been a professional developer for the past 13 years and has had the pleasure and pain of working with a variety of RDBMS. He's been involved with SQL Server since 2000 and has lost far too many hairs to DTS and SSIS, He was the organizer of SQL Saturday 53 and is in the process of planning the next on. When not milking yaks or fighting crime, Bill finds himself employed as the lead database developer for a financial services company.@billinkcbillinkchttp://billfellows.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@billinkc48483726Break BreakBreak@katsqlhttps://api.twitter.com/1/users/profile_image?screen_name=@katsql48483442Carlos BossyCarlos Bossy is a MCTS SQL Server 2008 BI Developer with 25 years of experience in software and database development. Carlos is an independent consultant and focuses on developing Business Intelligence solutions including data warehouses, predictive analytics, data integration and reporting. He has been working with SQL Server for 10 years and is very enthusiastic about its powerful features. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies.@carlosbossyhttp://www.linkedin.com/in/carlosbossyhttp://www.carlosbossy.comhttps://api.twitter.com/1/users/profile_image?screen_name=@carlosbossy48483467Chris RandallChris Bio@cfrandallhttp://www.linkedin.com/in/christophershawhttps://api.twitter.com/1/users/profile_image?screen_name=@cfrandall48483276Dean RichardsDean Richards is a Senior DBA for Confio Software and has helped hundreds of companies solve database performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments.@ConfioDeanhttp://www.linkedin.com/profile?viewProfile=key=18302796locale=en_UShttps://api.twitter.com/1/users/profile_image?screen_name=@ConfioDean48483149Doug LaneDoug (MCTS) is a BI, database, and sometimes ASP.NET/C# developer with ten years experience using Microsoft web and database products in the agriculture, insurance, taxonomy, and healthcare industries. He currently works for University Physicians, Inc. as a business inteligence developer.
@douglane4http://www.linkedin.com/in/douglane4 http://www.upicolo.orghttps://api.twitter.com/1/users/profile_image?screen_name=@douglane448483120Gabriel VillaGabriel is a MCPD, ASP.NET Developer, and a MCTS, SQL Server 2008 Database Development, originally from El Paso, Texas with over 10 years of professional experience with Microsoft technologies. He has developed desktop, web and database systems for the medical, retail, imports distributors and automotive industries. He recently moved to Colorado Springs with his wife and three kids and is developing for a retail furniture software company.@extoferhttp://www.linkedin.com/in/extoferhttp://extofer.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@extofer48483379Glenn BerryGlenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.@GlennAlanBerryhttp://www.linkedin.com/pub/glenn-berry/10/a61/6b8http://sqlserverperformance.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GlennAlanBerry48483723Lunch\Meet the experts\WIT Lunch\Meet the experts\WITLunch\Meet the experts\WIT@katsqlhttps://api.twitter.com/1/users/profile_image?screen_name=@katsql48483146Mark HalsteadMark Halstead is the SQL Server technical lead dba for Xtivia working in the Virtual-DBA group. He had been with Xtivia, Inc. for 5 years and has worked with SQL Server for more than 15 years. He has worked in IT for 20+ years specializing in database administration.@halstead_markhttp://www.linkedin.com/profile/view?id=4935448trk=hb_tab_pro_tophttp://www.virtual-dba.com/https://api.twitter.com/1/users/profile_image?screen_name=@halstead_mark48483133Meredith Ryan-SmithMeredith Ryan-Smith has 11 years experience in IT with responsibilities ranging from ‘manning’ the help desk to VMS-VAX cluster administration. Most recently she has served as the senior production database administrator for The Bell Group, a supplier to the jewelry industry. Within the PASS community she is the chair person for the Women In Technology Virtual Chapter and has spoken at several SQL Saturdays.@coffegrlhttp://www.linkedin.com/profile/view?id=10839821trk=tab_prohttp://meredithryansmith.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@coffegrl48483729Networking NetworkingNetworking@katsqlhttps://api.twitter.com/1/users/profile_image?screen_name=@katsql48483720Networking Session 4 Networking Session 4Networking Session 4@katsqlhttps://api.twitter.com/1/users/profile_image?screen_name=@katsql48483721Networking Session 5 Networking Session 5Networking Session 5@katsqlhttps://api.twitter.com/1/users/profile_image?screen_name=@katsql48483722Networking Session 6 Networking Session 6Networking Session 6@katsqlhttps://api.twitter.com/1/users/profile_image?screen_name=@katsql48483310Randy KnightRandy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for Match.com, one of the largest and most successful dot coms.
@randy_knight http://www.linkedin.com/in/randyknighthttp://www.sqlsolutionsgroup.comhttps://api.twitter.com/1/users/profile_image?screen_name=@randy_knight48483072Steve JonesSteve Jones has been working with SQL Server since 1991 and been a DBA in a variety of large and small companies and industries. In 2001 Steve founded SQLServerCentral with two partners and has been publishing technical articles and facilitating discussions among SQL Server professionals ever since. He currently is the full time editor of SQLServerCentral, owned by Red Gate Software.@way0utwesthttp://www.linkedin.com/in/way0utwesthttp://modernresume.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@way0utwest48483391Ted MaloneTed Malone is currently a Principal Software Architect for EMC's Infrastructure Management Division (IMG). Ted has primary responsibility for managing the team that creates the EMC IMG Infrastructure Insight product, which is a management tool that brings advanced Business Intelligence to IT Management software. Ted is also a member of the IMG CTO Council and is responsible for driving product interoperability within the IMG product suite.@tedmalonehttp://www.linkedin.com/in/temalonehttp://www.sqltrainer.com/blog.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@tedmalone48483739TJ BeltTJay Belt is a seasoned IT professional with over a decade of technical experience. Currently serving as a Database Administrator with Imagine Learning; a company whose goal is to teach English to the children or the world. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst, and DBA. Prior to Imagine Learning, he worked at several software companies, working at internal customer sites in the United States.@tjaybelthttp://www.linkedin.com/in/tjaybelthttps://api.twitter.com/1/users/profile_image?screen_name=@tjaybelt48483330Tom NormanTom Norman, Sql Server Database Administrator, TSYS. Tom has been working with Sql Server since 1998. He has worked internationally with Sql Server. His current responsibilities include Replication, Performance and Server Compliance of all Production databases in the US and UK. Tom and his team are currently working on a project to upgraded several products to Sql Server 2008 R2 and bring them into PCI compliance. Tom is the past President of the Denver Sql Server User Group.@tjnorman57http://www.linkedin.com/pub/tom-norman/3/803/114https://api.twitter.com/1/users/profile_image?screen_name=@tjnorman5748483198William PearsonBill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution.@Bill_Pearsonhttp://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85ehttp://www.databasejournal.com/article.php/1459531https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson484830723072Steve JonesBlue RoomThe Modern Resume - Building Your BrandLearn 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 AM2/12/2011 9:45:00 AM31203120Gabriel VillaYellow RoomSecuring your SQL ServerBecome 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 PM2/12/2011 1:15:00 PM31333133Meredith Ryan-SmithYellow RoomHelpdesk to DBA in 60-ish minutesMost ‘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 AM2/12/2011 11:15:00 AM31463146Mark HalsteadBlue RoomSQL Server Performance tuningSQL Server performance tuning with an emphasis on finding the bottlenecks, Query design problems and database design problems. 2/12/2011 1:30:00 PM2/12/2011 2:30:00 PM31493149Doug LaneGreen RoomMake it fast, make it pretty (SSRS)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 PM2/12/2011 1:15:00 PM31983198William PearsonBlue RoomBecoming DAX: An IntroductionThe 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 AM2/12/2011 11:15:00 AM32763276Dean RichardsGreen RoomBest Practices for SQL Server on VMWareMore 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 AM2/12/2011 9:45:00 AM33103310Randy KnightYellow RoomVisual Studio 2010 Database Projects 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 PM2/12/2011 2:30:00 PM33303330Tom NormanGreen RoomPolicy Based ManagementPolicy 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 AM2/12/2011 11:15:00 AM33793379Glenn BerryGreen RoomHardware 201: Selecting Database HardwareThe 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 PM2/12/2011 2:30:00 PM33913391Ted MaloneGreen RoomManaging the Data Tier Application LifecycleIntroduced 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 PM2/12/2011 4:15:00 PM34013401Bill FellowsBlue Room45 new 2005/2008 TSQL features in 45 minutesToo 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 PM2/12/2011 1:15:00 PM34423442Carlos BossyBlue RoomA Data Mining SolutionOne 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 PM2/12/2011 4:15:00 PM34673467Chris ShawBlue RoomWelcomeWelcome 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 AM2/12/2011 8:15:00 AM37143714Chris ShawGreen RoomWelcomeWelcome\Keynote2/12/2011 8:00:00 AM2/12/2011 8:15:00 AM37153715Chris ShawYellow RoomWelcomeWelcome\KeyNote2/12/2011 8:00:00 AM2/12/2011 8:15:00 AM37163716Chris ShawBlue RoomNetworking Session 1Networking Session 12/12/2011 8:15:00 AM2/12/2011 8:45:00 AM37173717Chris ShawGreen RoomNetworking Session 2Networking Session 22/12/2011 8:15:00 AM2/12/2011 8:45:00 AM37183718Chris ShawYellow RoomNetworking Session 3Networking Session 32/12/2011 8:15:00 AM2/12/2011 8:45:00 AM37193719Chris RandallYellow Room'Beyond BIDS' - Caring for and Feeding a SQL ServeAre 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 AM2/12/2011 9:45:00 AM37203720Networking Session 4 Networking Session 4Blue RoomNetworking Session 4Networking Session 42/12/2011 9:45:00 AM2/12/2011 10:15:00 AM37213721Networking Session 5 Networking Session 5Green RoomNetworking Session 5Networking Session 52/12/2011 9:45:00 AM2/12/2011 10:15:00 AM37223722Networking Session 6 Networking Session 6Yellow RoomNetworking Session 6Networking Session 62/12/2011 9:45:00 AM2/12/2011 10:15:00 AM37233723Lunch\Meet the experts\WIT Lunch\Meet the experts\WITBlue RoomLunch\Meet the experts\WITLunch\Meet the experts\WIT2/12/2011 11:15:00 AM2/12/2011 12:15:00 PM37243724Lunch\Meet the experts\WIT Lunch\Meet the experts\WITGreen RoomLunch\Meet the experts\WIT 2Lunch\Meet the experts\WIT 22/12/2011 11:15:00 AM2/12/2011 12:15:00 PM37253725Lunch\Meet the experts\WIT Lunch\Meet the experts\WITYellow RoomLunch\Meet the experts\WIT 3Lunch\Meet the experts\WIT 32/12/2011 11:15:00 AM2/12/2011 12:15:00 PM37263726Break BreakBlue RoomBreak 1Break 12/12/2011 1:15:00 PM2/12/2011 1:30:00 PM37273727Break BreakGreen RoomBreak 2Break 22/12/2011 1:15:00 PM2/12/2011 1:30:00 PM37283728Break BreakYellow RoomBreak 3Break 32/12/2011 1:15:00 PM2/12/2011 1:30:00 PM37293729Networking NetworkingBlue RoomNetworking 7Networking 72/12/2011 2:30:00 PM2/12/2011 3:00:00 PM37303730Networking NetworkingGreen RoomNetworking 8Networking 82/12/2011 2:30:00 PM2/12/2011 3:00:00 PM37313731Networking NetworkingYellow RoomNetworking 9Networking 92/12/2011 2:30:00 PM2/12/2011 3:00:00 PM37323732Networking NetworkingBlue RoomNetworking 10Networking 102/12/2011 4:15:00 PM2/12/2011 5:00:00 PM37333733Networking NetworkingGreen RoomNetworking 11Networking 112/12/2011 4:15:00 PM2/12/2011 5:00:00 PM37343734Networking NetworkingYellow RoomNetworking 12Networking 122/12/2011 4:15:00 PM2/12/2011 5:00:00 PM37353735Break BreakBlue RoomBreak 4Break 42/12/2011 3:00:00 PM2/12/2011 3:15:00 PM37363736Break BreakGreen RoomBreak 5Break 52/12/2011 3:00:00 PM2/12/2011 3:15:00 PM37373737Break BreakYellow RoomBreak 6Break 62/12/2011 3:00:00 PM2/12/2011 3:15:00 PM37393739TJ BeltYellow RoomDocumentation. You know you love itWe 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 PM2/12/2011 4:15:00 PM