SQLSaturday #187 - Richmond 20133/9/2013 12:00:00 AM(GMT-05:00) Eastern Time (US and Canada)SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat18728 Westhampton WayRichmondVA231732799University of Richmondhttp://spcs.richmond.edu/http://sqldatapartners.files.wordpress.com/2012/10/uofrcontinuingstudies.jpg401002937B2B Solutionshttp://www.b2bsol.comhttp://sqldatapartners.files.wordpress.com/2013/01/b2b_rgb-copy-with-more-space-170-x-60-pixels.jpg601703038CapTechhttp://www.captechconsulting.com/http://upload.wikimedia.org/wikipedia/commons/2/2a/CTV_logo_2012_jpg.jpg601703048Nimble Storagehttps://www.nimblestorage.comhttp://www.nimblestorage.com/images/logo.png601703057Red Gate Softwarehttp://redg.at/VIt4x0http://www.red-gate.com/assets/images/common/logo.png601703017COZYROChttp://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601703022Dell Software Grouphttp://www.quest.com/http://i.imgur.com/BAdC3.png601702844Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702861PASS Headquartershttps://www.sqlpass.orghttp://www.sqlsaturday.com/images/PASS_logo.jpg601702926SLAIT Consultinghttp://www.slaitconsulting.com/http://img33.imageshack.us/img33/4460/slaitconsultinglogo.jpg601703080Embarcaderohttp://www.embarcadero.com/products/db-powerstudiohttp://sqldatapartners.files.wordpress.com/2013/02/embarcadero.jpg601702984Ntirety, Inchttp://www.ntirety.comhttp://www.ntirety.com/packages/theme_businesstheme/themes/businesstheme/images/NT-Logo2.png601702989Iderahttp://www.idera.comhttp://www.idera.com/images/Logo-Idera.png601702783SQL Data Partners LLChttp://www.sqldatapartners.comhttp://i1.wp.com/sqldatapartners.files.wordpress.com/2012/08/logosmallmodified.jpg401002892Wayne Sheffieldhttp://blog.waynesheffield.com/waynehttp://www.gravatar.com/avatar/a7a0ce0513a3a79e6bfe3bbe0bcf5852.png401003061xSQL Softwarehttp://www.xsql.comhttp://www.xsql.com/images/xSQLSoftware.png401003006Padgett Business Serviceshttp://www.smallbizaccountingrichmondva.comhttp://data.gointranet.com/unitloc/sbp/images/PadgettLogo.gif401002880Pluralsighthttp://Pluralsight.comhttp://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png4010011905A.J. MeeA.J. Mee is a Principal Technology Solutions Professional for Microsoft Corporation. He leads Microsoft's pre-sales practice around Business Intelligence (BI), serving 300+ Enterprise customers in the Mid-Atlantic region of the US (PA/DE/NJ/DC/MD/VA). In his role, he is primarily responsible for aligning specific customer requirements around BI empowerment and democratization to Microsoft's industry-leading BI platform. He joined Microsoft in 2006 as part of its acquisition of ProClarity. http://www.linkedin.com/pub/aj-mee/0/413/111484812439Andy LeonardAndy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer and Consultant and developer, SQL Server database and data warehouse developer, community mentor, SQLBlog.com blogger, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); and data warehouse development using SQL Server.@AndyLeonardhttp://www.linkedin.com/in/andyleonardhttp://linchpinpeople.comhttps://api.twitter.com/1/users/profile_image?screen_name=@AndyLeonard484812630Brandon LeachBrandon is a veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he fell in love with SQL Server and database development and administration. Currently he is manages 89+ SQL Servers for Network Health in Medford, Ma. He works closely with the developement, infrastructure, and management in and out of IT to make sure the needs of the business and its future goals are met.@SQLServerNerdhttp://network-health.orghttps://api.twitter.com/1/users/profile_image?screen_name=@SQLServerNerd484814095CapTech ConsultingCapTech is a national technology consulting firm offering a full suite of services including management consulting, systems integration, and data management. We design, implement and integrate IT systems for America’s most respected companies. CapTech is proud to be counted among Inc. Magazine's Inc. 5000, reserved for the nation's fastest growing private companies for the 5th consecutive year. Working within our clients’ cultures, we tailor business solutions to their unique needs.@jessicammosshttp://www.captechconsulting.com/https://api.twitter.com/1/users/profile_image?screen_name=@jessicammoss484813278Geoff JohnsonGeoff has written SQL queries and designed custom reports for non-profit organizations (mainly churches) for nearly ten years, first in MS Access and now for several years in T-SQL. He frequently trains the customers of Shelby Systems, Inc, in T-SQL, ActiveReports, and SQL Server Reporting Services. His greatest job satisfaction is implementing a BI solution that saves his clients hours of painstaking effort and delivers meaningful information that empowers ministry.@chaunticleer86http://www.linkedin.com/pub/geoff-johnson/7/351/670http://selectstatements.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@chaunticleer86484813112Grant FritcheyGrant Fritchey is a SQL Server MVP with over 20 years of experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has developed in VB, VB.NET, C# and Java. Grant volunteers at PASS and is president of the Southern New England SQL Server Users Group (SNESSUG). He has authored books for Apress and Simple-Talk and joined Red Gate Software as a Product Evangelist in January 2011. Grant blogs at www.scarydba.com.@gfritcheyhttp://www.linkedin.com/in/scarydbahttp://www.scarydba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@gfritchey484812145Jason HallJason leads SQL Sentry's Client Services team, which provides customers with help desk support, troubleshooting, and defect resolution. Jason's certifications include: MCSE, MCP + Internet, MCSD, MCPS, and MCPD Enterprise App. Development.@SQLSaurushttp://www.linkedin.com/in/jasonryonhallhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLSaurus484812241Jessica MossJessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence. Jessica's expertise includes dimensional modeling, ETLs, semantic modeling, report design, and helping customers across industries successfully implement and enhance their business intelligence solutions. Jessica enjoys sharing her knowledge with the central Virginia community, speaks regularly at user groups, code camps, and conferences, and has co-authored five technical books.@jessicammosshttp://www.jessicammoss.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jessicammoss484813105John WelchJohn Welch has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an SSAS Maestro, and a frequent presenter on SQL Server BI topics. He also contributes to the BIDS Helper and ssisUnit open source projects.@john_welchhttp://www.linkedin.com/in/johncwelchhttp://agilebi.com/jwelchhttps://api.twitter.com/1/users/profile_image?screen_name=@john_welch484812261Joseph D'AntoniJoey D'Antoni is a frequent speaker at SQL Saturday events. He is a SQL Server Architect at Comcast in West Chester, Pennsylvania with 10+ years of experience working on a wide variety of database platforms. His specialties include DR, HA and Virtualization.
@jdantonhttp://joedantoni.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484812822Karen LopezKaren López is Sr. Project Manager and Architect at InfoAdvisors. As a Microsoft MVP, Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. She specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com. Karen wants you to Love Your Data.@datachickhttp://linkedin.com/in/karenlopezhttp://blog.infoadvisors.comhttps://api.twitter.com/1/users/profile_image?screen_name=@datachick484812131Kevin BolesKevin Hazzard is a consultant, author and Microsoft Windows Azure MVP from the Richmond, Virginia. He serves as a Director at CapTech Consulting where he designs and implements large-scale SQL Server databases and .NET services for Fortune 500 clients, focusing on the health care, retail, manufacturing and communication industries. Kevin is the lead author of Metaprogramming in .NET by Manning, a book that concerns the value of adaptable software design.@keklinehttp://www.linkedin.com/in/keklinehttps://api.twitter.com/1/users/profile_image?screen_name=@kekline484812662Matt VelicMatt Velic is a Database Developer for Sanametrix, both living and working in Washington, DC. He enjoys learning about SQL Server (naturally), interacting with the community, and making sure that everyone has the resources available to succeed. Matt is a blogger, helped run communications and volunteers for SQLSaturday events in DC, and moderated the first day of Lightning Talks at the 2010 PASS Summit.@mvelichttp://www.linkedin.com/in/mattvelichttp://mattvelic.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mvelic484811958Melissa CoatesMelissa Coates is a Business Intelligence developer based in Charlotte, NC. As a Senior Consultant with Intellinet, she specializes in delivering BI and Data Warehousing solutions. Formerly a CPA, Melissa is ridiculously proud to be an IT geek. Her background gives her a valuable blend of technical, business, and training skills. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie. Melissa blogs at http://www.sqlchick.com. @sqlchickhttp://www.linkedin.com/in/melissacoatesprofilehttp://www.sqlchick.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlchick484811824Michael Corey Michael Corey, Founder of Ntirety. Michael is a frequent speaker at technology conferences throughout the world. Michael is a VMware vExpert , Oracle ACE, and is on Talkin’ Cloud 200 Computing Executives and Experts List. Michael is a past president of the IOUG; he helped found the Professional Association of SQL Server. He is a frequent blogger for Database Trends Applications. He written numerous articles and books published on topics as Microsoft SQL Server to Tuning Oracle.@Michael_Coreyhttp://www.linkedin.com/pub/michael-corey/1/795/66bhttp://michaelcorey.ntirety.com/https://api.twitter.com/1/users/profile_image?screen_name=@Michael_Corey484812472Mike HillwigNative Pittsburgher and Boston resident Mike Hillwig is a senior SQL DBA for a provider of private cloud-based solutions for the financial industry He's been working with SQL Server since version 7. He's got a background in infrastructure and networking. In his current role, Mike's portfolio of SQL servers grows weekly, sometimes daily. He's quite passionate about automating administrative tasks..@mikehillwighttp://www.linkedin.com/in/mikehillwighttp://crankydba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mikehillwig484814160Nimble StorageThis is a sponsor supported session.http://www.nimblestorage.com484812488Panel DiscussionJessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence. Jessica's expertise includes dimensional modeling, ETLs, semantic modeling, report design, and helping customers across industries successfully implement and enhance their business intelligence solutions. Jessica enjoys sharing her knowledge with the central Virginia community, speaks regularly at user groups, code camps, and conferences, and has co-authored five technical books.@jessicammosshttp://www.jessicammoss.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jessicammoss484811929Paul OsterPaul Oster has worked with SQL Server and XML for over 10 years. He has developed XML/EDI systems and integrated SQL/XML/EDI based systems with various companies in Norway, Finland, Germany, Sweden, England, France, Canada, Brazil and the United States. He is currently a Database Administrator/Architect at McGuireWoods. He formerly served as Systems Manager for Lydall in Ct, Systems Manager at Penn Warehousing in Philadelphia and IT/Systems Director at CrossGlobe Group in Glen Allen, Va@PaulRizzaSQLhttp://www.linkedin.com/in/prizzahttps://api.twitter.com/1/users/profile_image?screen_name=@PaulRizzaSQL484813031Philip NoakesMr. Noakes is a certified IT Professional in SQL Server Business Intelligence and SQL Server Development. He has over six years of experience in consulting on all facets of SQL Server and delivering BI solutions.
Jessica M. Moss, a SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions and authored technical content for multiple magazines, websites, and five technical books.484813386Rafael SalasRafael is a speaker, published authored and blogger with more than a decade of relevant IT experience across multiple industries. He specializes in Business Intelligence and information architecture and is the recipient of multiple industry awards, including Microsoft Most Valuable Professional (MVP) and The Data Warehouse Institute best practices. Rafael is also an active member in the SQL Server technical community and maintains a blog at www.rafael-salas.com.@RafSalashttp://www.linkedin.com/in/rafaelsalashttp://www.rafael-salas.com/https://api.twitter.com/1/users/profile_image?screen_name=@RafSalas484812187Rob VolkRob Volk does deranged things with SQL Server, so you don't have to. A DBA in the Metro Atlanta area since 2001, he has also abused other database and programming platforms elsewhere and elsewhen. In his spare time he accomplishes more than he does on the job, just don't tell his boss.@sql_rhttp://www.linkedin.com/pub/rob-volk/1/ba8/134http://weblogs.sqlteam.com/robv/https://api.twitter.com/1/users/profile_image?screen_name=@sql_r484812532SHANNON LOWDERLook no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.@Shannon Lowderhttp://linkedin.com/in/slowderhttp://about.me/shannonlowderhttps://api.twitter.com/1/users/profile_image?screen_name=@Shannon Lowder484812270Stacia MisnerStacia Misner has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft’s business intelligence technologies since 2000. She is a SQL Server MVP, MCITP, MCTS, and has authored or co-authored multiple books about Microsoft business intelligence technologies. Erika Bakse has helped develop training curricula for SQL Server BI and is co-author of Microsoft SQL Server 2008 Step by Step.@StaciaMisnerhttp://www.linkedin.com/in/staciamisner http://blog.datainspirations.comhttps://api.twitter.com/1/users/profile_image?screen_name=@StaciaMisner484812777Steve 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/way0utwesthttps://api.twitter.com/1/users/profile_image?screen_name=@way0utwest484812768Thomas LaRockThomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas holds a MS degree in Mathematics from WSU. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MCM and MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).@https://twitter.com/#!/SQLRockstarhttp://www.linkedin.com/in/sqlrockstarhttp://thomaslarock.comhttps://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/#!/SQLRockstar484812708Tim ChapmanTim Chapman is a Microsoft Certified Master (MCM) and works as a dedicated field engineer (PFE) at Microsoft specializing in performance tuning and high availability. Originally from Louisville, KY Tim now resides in Chapel Hill, NC. Tim has over 12 years of database architecture, programming, and administration experience. @chapmandewhttp://www.linkedin.com/pub/tim-chapman/5/242/896http://blogs.msdn.com/b/timchapman/https://api.twitter.com/1/users/profile_image?screen_name=@chapmandew48481181911819SQLSaturday 187C112Welcome, Instructions, etc.3/9/2013 8:30:00 AM3/9/2013 8:45:00 AM1181911819SQLSaturday 187C114Welcome, Instructions, etc.3/9/2013 8:30:00 AM3/9/2013 8:45:00 AM1181911819SQLSaturday 187A201Welcome, Instructions, etc.3/9/2013 8:30:00 AM3/9/2013 8:45:00 AM1181911819SQLSaturday 187E303Welcome, Instructions, etc.3/9/2013 8:30:00 AM3/9/2013 8:45:00 AM1181911819SQLSaturday 187C200Welcome, Instructions, etc.3/9/2013 8:30:00 AM3/9/2013 8:45:00 AM1181911819SQLSaturday 187Auditorium (1st Floor)Welcome, Instructions, etc.3/9/2013 8:30:00 AM3/9/2013 8:45:00 AM1182011820SQLSaturday 187C112Lunch Break, Vendor Sessions, Networking3/9/2013 12:30:00 PM3/9/2013 1:30:00 PM1182011820SQLSaturday 187C114Lunch Break, Vendor Sessions, Networking3/9/2013 12:30:00 PM3/9/2013 1:30:00 PM1182011820SQLSaturday 187E303Lunch Break, Vendor Sessions, Networking3/9/2013 12:30:00 PM3/9/2013 1:30:00 PM1182111821SQLSaturday 187C112Registrations3/9/2013 7:45:00 AM3/9/2013 8:30:00 AM1182111821SQLSaturday 187C114Registrations3/9/2013 7:45:00 AM3/9/2013 8:30:00 AM1182111821SQLSaturday 187A201Registrations3/9/2013 7:45:00 AM3/9/2013 8:30:00 AM1182111821SQLSaturday 187E303Registrations3/9/2013 7:45:00 AM3/9/2013 8:30:00 AM1182111821SQLSaturday 187C200Registrations3/9/2013 7:45:00 AM3/9/2013 8:30:00 AM1182111821SQLSaturday 187Auditorium (1st Floor)Registrations3/9/2013 7:45:00 AM3/9/2013 8:30:00 AM1182211822SQLSaturday 187C112Raffle3/9/2013 5:15:00 PM3/9/2013 5:45:00 PM1182211822SQLSaturday 187C114Raffle3/9/2013 5:15:00 PM3/9/2013 5:45:00 PM1182211822SQLSaturday 187A201Raffle3/9/2013 5:15:00 PM3/9/2013 5:45:00 PM1182211822SQLSaturday 187E303Raffle3/9/2013 5:15:00 PM3/9/2013 5:45:00 PM1182211822SQLSaturday 187C200Raffle3/9/2013 5:15:00 PM3/9/2013 5:45:00 PM1182211822SQLSaturday 187Auditorium (1st Floor)Raffle3/9/2013 5:15:00 PM3/9/2013 5:45:00 PM1182411824Michael CoreyC200Virtualizing SQL Server 2012: Doing IT Right A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA how to virtualize a business critical application like SQL server 2012. It will be based upon experience learned using VMWare as the virtualization platform. But many of the lessons taught will carry over to any virtualized platform. 3/9/2013 3:00:00 PM3/9/2013 4:00:00 PM1190511905A.J. MeeC114SQL Server 2012's Net-New BI Capabilities Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including: · Power View · BI Semantic Model (BISM) · Data Quality Services · Master Data Management · Columnstore Index3/9/2013 1:45:00 PM3/9/2013 2:30:00 PM1192911929Paul RizzaC112Upgrading to SSIS 2012As the newest version of SQL Server, 2012 is introducing many new BI features. This session will look at what has changed in SSIS 2012 and how to best leverage these new features to get the most for your ETL effort! 3/9/2013 11:15:00 AM3/9/2013 12:15:00 PM1193711937Paul OsterA201SQL Server and XML Imports and ExportsThe discussion will cover beginner and intermediate SQL Server based XML for data export. The discussion will start by covering basic XML generation via SQL Server and XML schema validation, moving on to intermediate XML export. It will then go into a more advanced topic of utilizing XSLT to create robust data import scripts via xlst and xquery/xpath.3/9/2013 1:45:00 PM3/9/2013 2:30:00 PM1195811958Melissa CoatesC112Dashboards...How To Choose Which MSBI ToolCompare and contrast how each Microsoft BI tool satisfies requirements for visualization, interactivity, data sources, formatting, printing, and exporting. We'll explore the strengths and limitations of each tool for creating dashboards scorecards with PerformancePoint, Reporting Services, Excel, and Power View. This session will help you with things to consider when selecting one tool in the Microsoft BI stack versus another.3/9/2013 10:00:00 AM3/9/2013 11:00:00 AM1213112131Kevin KlineAuditorium (1st Floor)Team Leadership FundamentalsConsidering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, communication skills and project/job tracking skills. Attendees will learn:
1. What are the fundamental ways that a new leader can build credibility and trust with their team?
2. What are the unique ways in which IT people are motivated?
3. How can a leader effectively communicate with their IT team using a variety of communication channels?
4. How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?
3/9/2013 1:45:00 PM3/9/2013 2:30:00 PM1213212132Kevin KlineAuditorium (1st Floor)Top 10 Admininistrator Mistakes on SQL ServerSQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.3/9/2013 8:45:00 AM3/9/2013 9:45:00 AM1214512145Jason HallA2015 Common SQL Server Performance IssuesI spend a large portion of each day looking through performance reports and dashboards from various organizations around the world. I've identified some very common performance problems and/or misunderstandings that tend to have easy, though not always obvious, solutions.
I intend to share the whys and hows of these issues with anyone who would like to attend during a SQL Saturday session.3/9/2013 8:45:00 AM3/9/2013 9:45:00 AM1214612146Jason HallC200Recipe for a happy DBAIn a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid and beginning execution plan analysis.
3/9/2013 4:15:00 PM3/9/2013 5:15:00 PM1218712187Rob VolkC200Revenge: The SQL Part 2: The Sequel!In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!3/9/2013 10:00:00 AM3/9/2013 11:00:00 AM1224112241Jessica MossC112Getting Reports on Your ScheduleToo often reports sent on a daily basis end up in a mail filter. Only a small percentage of the reports are actually necessary for someone to take action. How happy would your users be if you could only provide the report when they actually needed to look at it? You can, by using subscriptions and alerts in Reporting Services 2012. This session will provide a comparison of regular subscriptions, data-driven subscriptions, and data-driven alerts in Reporting Services 2012 in SharePoint Integrated mode. Attend this session to learn how to provide reports that will be read rather than filtered.3/9/2013 8:45:00 AM3/9/2013 9:45:00 AM1226112261Joseph D'AntoniE303SQL 2012 -- All About HA and DRHave you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.3/9/2013 10:00:00 AM3/9/2013 11:00:00 AM1227012270Stacia MisnerC112(Way Too Much) Fun with Reporting Services Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She'll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?3/9/2013 3:00:00 PM3/9/2013 4:00:00 PM1243912439Andy LeonardC114“I See a Control Flow Tab. Now What?” (Level 100)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. 3/9/2013 10:00:00 AM3/9/2013 11:00:00 AM1244012440Andy LeonardAuditorium (1st Floor)Using BIML as an SSIS Design Patterns Engine Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.3/9/2013 4:15:00 PM3/9/2013 5:15:00 PM1247212472Mike HillwigE303How Not to Be a Cranky DBAMike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.3/9/2013 3:00:00 PM3/9/2013 4:00:00 PM1248812488Panel DiscussionAuditorium (1st Floor)Women in Technology: Breaking the Glass CeilingJoin us for this Women in Technology (WIT) panel to discuss career tips, promotion opportunities, and moving your profession forward. Each member will share their background and then will answer questions in an interactive QA session. Both men and women are welcome to attend this informative event!3/9/2013 12:30:00 PM3/9/2013 1:30:00 PM1253212532SHANNON LOWDERC200OnPremise to AzureDuring this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.3/9/2013 11:15:00 AM3/9/2013 12:15:00 PM1260912609Kevin BolesA201Common TSQL MistakesWe are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FORTY times now and it is always very highly rated!3/9/2013 4:15:00 PM3/9/2013 5:15:00 PM1261012610Kevin BolesA201Windowing Functions: THE Reason to Upgrade to 2012For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!3/9/2013 10:00:00 AM3/9/2013 11:00:00 AM1263012630Brandon LeachE303A DBAs Guide to HIPAAIn this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve.
We'll also dive into several features in SQL Server that can help in this endeavor. 3/9/2013 1:45:00 PM3/9/2013 2:30:00 PM1265912659Kevin HazzardC114Creating an Extensible Data Quality FoundationData Quality (DQ) tools are typically expensive and difficult to integrate into your ETL and governance plans but it doesn't have to be that way. During this fun, highly-interactive session, Kevin Hazzard (Microsoft Windows Azure MVP and author of the book Metaprogramming in .NET), will show you how to implement a modular, highly resilient DQ foundation from the tools you already own, no matter which version of SQL Server you're using today. At the end of this discussion, Kevin will give you a copy of his schema and his standard DQ function library that you can use in your own databases.3/9/2013 8:45:00 AM3/9/2013 9:45:00 AM1266212662Matt VelicC200Build your own Virtual LabIf you don't have the chance to work on different kinds of projects, it can be tough to grow all the necessary skills to further your career. Take control of the situation by building a virtual lab at home.
We'll begin the session by talking about why you might want to build a lab, and what you'll need to complete the task - nothing more than your home computer and free software. We'll review the basics of virtualization as it relates to VirtualBox. Finally, we'll dive into an example of building a Windows Server 2012 cluster, and talk about how you can use these networking and server skills to advance your SQL Server education.3/9/2013 8:45:00 AM3/9/2013 9:45:00 AM1270812708Tim ChapmanA201Writing faster queriesPoor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.3/9/2013 11:15:00 AM3/9/2013 12:15:00 PM1270912709Tim ChapmanE303SQL Server Index InternalsHave you ever wondered what an index actually looks like and performs under the covers? In this talk I'll discuss Index Internals, and how SQL Server creates, maintains, and uses indexes internally for normal operations. I’ll be discussing topics such as index data structures, query optimization (briefly) and maintaining indexes and statistics. 3/9/2013 8:45:00 AM3/9/2013 9:45:00 AM1276812768Thomas LaRockAuditorium (1st Floor)Choose Your Own Adventure: Performance TuningLife is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join SQL Server MCM and MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure.3/9/2013 3:00:00 PM3/9/2013 4:00:00 PM1277712777Steve JonesAuditorium (1st Floor)Branding Yourself for a Dream JobEveryone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.3/9/2013 11:15:00 AM3/9/2013 12:15:00 PM1277912779Steve JonesA201The Encryption PrimerLearn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.3/9/2013 3:00:00 PM3/9/2013 4:00:00 PM1282212822Karen LopezAuditorium (1st Floor)Database Design Contentious IssuesA highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.3/9/2013 10:00:00 AM3/9/2013 11:00:00 AM1303113031Philip NoakesC112Realizing the Power of Microsoft ReportingOnce you’ve loaded your data into a star schema and built an Analysis Services 2008 R2 cube around it, you are ready to harness the power of multi-dimensional analysis. Then, what are your next steps? You need to decide how to create and display reports. Should you go with Reporting Services, PowerView or another reporting tool? This session will explore and demonstrate the different reporting options for deriving business intelligence.
(Co-presented with Jessica Moss)
3/9/2013 1:45:00 PM3/9/2013 2:30:00 PM1310513105John WelchC114Moving Big Data - SSIS, Pig, and SqoopWondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.3/9/2013 4:15:00 PM3/9/2013 5:15:00 PM1310613106John WelchC114Unit Testing SSIS PackagesUnit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. You will also see how to automate the testing of SSIS packages, using the open source ssisUnit framework. The session will cover several of the common questions about automated unit testing, including how to handle test data , how to set up the environment for multiple developers, and how to make tests flexible.3/9/2013 11:15:00 AM3/9/2013 12:15:00 PM1311213112Grant FritcheyC200Query Tuning in the CloudsJust because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud.3/9/2013 1:45:00 PM3/9/2013 2:30:00 PM1311313113Grant FritcheyE303Database Backups for the Accidental DBAYou've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session.3/9/2013 4:15:00 PM3/9/2013 5:15:00 PM1321813218Melissa CoatesC114So You Want To Be A Rockstar Report Developer?You don't want to settle for being an average Report Developer, right? In this highly interactive session we'll discuss various development, standardization, deployment, and documentation practices that will make your SSRS development life easier, your output of higher quality, increase maintainability, and ultimately save you time. Audience participation and sharing of experiences is encouraged as we cover choices you have for datasets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session focuses primarily on SQL Server Reporting Services 2012, although some concepts may apply to other BI tools as well. Join us for this this session and take your reporting skills to the next level!3/9/2013 3:00:00 PM3/9/2013 4:00:00 PM1327813278Geoff JohnsonE303Intro to Common Table ExpressionsCommon Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables.3/9/2013 11:15:00 AM3/9/2013 12:15:00 PM1338613386Rafael SalasC112Waiter, There's a Fly In My Data Dealing with bad data is a painful and expensive experience. In this session we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals. You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component. 3/9/2013 4:15:00 PM3/9/2013 5:15:00 PM1409514095CapTech ConsultingA201Implementing CapTech's Data Management FrameworkIt can quickly become overwhelming to track all of your SQL Server Integration Services (SSIS) packages for loading data. Trying to figure out ‘what ran when’ and ‘who did what’ are tasks we've all had to face. CapTech Consulting has successfully solved these common data management problems by implementing a data management framework for multiple organizations. Come to this lunchtime session to learn how to implement your own SSIS framework and to never worry about your SSIS packages again!3/9/2013 12:30:00 PM3/9/2013 1:30:00 PM1416014160Nimble StorageC200How Flash-Optimized Storage Accelerate Performance and Simplify Storage For Virtualized EnvironmentsThis presentation will explore the evolution of storage architectures, reviewing the technology inflection points and core business drivers that have propelled the transitions from direct attached to monolithic to modular storage solutions. We are at the beginning of the next major technology inflection driving enterprise storage. Solid state drives (SSDs) promise to solve the performance challenges inherent in spinning disks, rendering traditional storage architectures obsolete. But SSDs by themselves are not the solution. The next decade will be dominated by storage architectures designed from the ground up to leverage the best characteristics of flash and disk. Will these new solutions be able to simultaneously deliver high performance and high capacity primary storage? And can they improve data protection, improving recovery point and recovery time objectives with far less cost and complexity? Learn the answer and examine real-world case studies in this informative session.3/9/2013 12:30:00 PM3/9/2013 1:30:00 PM