SQLSaturday #159 - Kansas City 20128/4/2012 12:00:00 AM(GMT-06:00) Central Time (US and Canada)SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat159Cerner Corporation's Riverport Campus6711 NE Birmingham RdKansas CityMO641172337Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702447House of Brick Technologieshttp://www.houseofbrick.comhttp://davidklee.net/hob_sqlsat_logo.png601702537Cerner Corporationhttp://www.cerner.comhttp://www.sqlsaturday.com/files/83734561-a577-4326-ac20-6caa0a806406.jpg601702374Quest Softwarehttp://www.quest.com/http://www.quest.com/images/common/quest_logo.gif601702270CozyRochttp://www.cozyroc.comhttp://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601702296Steve Hughes - Data on Wheelshttp://www.dataonwheels.comhttp://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png401002368Craig Purnellhttp://www.craigpurnell.comhttp://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg401002450David Kleehttp://www.davidklee.nethttp://davidklee.net/dknet_sqlsat_logo.png401009466Andy GalbraithAndy aka Abhi has several years of BI experience including planning, design, development and implementation in business database applications.Andy has worked primarily as a consultant holding positions primarily in the Energy,Banking,Media,Consulting. Currently Working on Cloud development Project. @Andythiruhttps://api.twitter.com/1/users/profile_image?screen_name=@Andythiru48489365Bill FellowsBill Graziano is a SQL Server consultant that specializes in tuning OLTP systems and database administration. He’s a SQL Server MVP and serves on the Board of Directors for PASS (The Professional Association for SQL Server). He runs a SQL Server web site for DBAs and developers at www.SQLTeam.com. Bill has presented at PASS and numerous regional and local events around the country.@billinkcbillinkchttp://blog.billfellows.nethttps://api.twitter.com/1/users/profile_image?screen_name=@billinkc48489704Christopher PriceChris Price is a Business Intelligence Consultant with Pragmatic Works. He has his M.B.A from the University of South Florida and has worked as a professional software developer since 1999. For the past couple of years his attention has been focused on the Microsoft Business Intelligence stack. His interested span the BI stack from SSIS and SSAS to Performance Point. @bluewater79http://chrisshaw.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@bluewater79484810059Dave ValentineDave Valentine is a Development DBA with over 10 years of experience with SQL Server and Development technologies, specializing in Business Intelligence and ingenious solutions. Dave has also been an Adjunct Professor at Metropolitan State University for the past 10 years educating students in Database Management, Web Development, and Java Programming.
@IngeniousSQLhttp://linkd.in/LiTa36http://www.ingenioussql.com/https://api.twitter.com/1/users/profile_image?screen_name=@IngeniousSQL48489383David KleeDavid Klee (@kleegeek) is a SQL Server performance and virtualization expert. With over fifteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis.@kleegeekhttp://www.linkedin.com/in/davidakleehttp://davidklee.nethttps://api.twitter.com/1/users/profile_image?screen_name=@kleegeek484810392Doug LaneDoug (MCITP, MCTS, MCSE) has 10+ years’ experience with Microsoft web and database products. He is currently a Business Intelligence developer at University Physicians, Inc., specializing in the SQL Server BI stack. He blogs about SQL Server with an emphasis on BI and adheres to the philosophy that BI should be fun. Doug regularly delivers presentations at SQL Server user group meetings and SQLSaturdays and serves as VP of Membership for the Denver SQL Server User Group.@douglane4http://www.linkedin.com/in/douglane4 http://www.douglane.nethttps://api.twitter.com/1/users/profile_image?screen_name=@douglane448489945Frank KearneyFrank Kearney is a solutions architect for Valorem Consulting specializing in Business Intelligence. He has been working in IT since 1996 and with the Microsoft business intelligence tools since SQL Server 2000. @fkearneyhttp://www.linkedin.com/in/frankkearneyhttp://frankkearney.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@fkearney48489891Jason KassayJason has been a software developer for over 10 years and currently works at EZFacility, providing scheduling, management, full-service billing, and membership solutions for the sports, health, and fitness industries. He has worked primarily with .Net (C# and VB) and SQL Server as well as HTML, CSS, and Javascript. When he is not coding or spending time with his awesome family, you will find him either running (to train for the zombie apocalypse) or stopping hockey pucks as a goaltender.@jasonkassayhttp://www.linkedin.com/in/jasonkassayhttp://DidItSave.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jasonkassay48489806John MorehouseJohn Morehouse is currently a Database Developer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and has been working with Microsoft SQL Server for over 5 years in a variety of roles. In his spare time, you can find John running after his son or working on his 112 year old house. @sqlrushttp://www.linkedin.com/in/sqlrushttp://sqlrus.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlrus484810362Juan SotoJuan Soto is President of IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases and is a frequent blogger for Microsoft's official Access blog at http://blogs.office.com/b/microsoft-access and at SQL Saturday's across the US. To learn more about Juan, please visit his blog at AccessExperts.net/blog@jsoto22http://www.linkedin.com/in/juansotohttp://www.AccessExperts.nethttps://api.twitter.com/1/users/profile_image?screen_name=@jsoto2248489791Karen LopezKaren Lopez is Sr. Project Manager and Architect at InfoAdvisors, Inc. 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. Karen 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. @datachickhttp://linkedin.com/in/karenlopezhttp://blog.infoadvisors.comhttps://api.twitter.com/1/users/profile_image?screen_name=@datachick48489866Kevin BolesKevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds many SQL Server related certifications and is also an MCT and MVP. Kevin teaches occasionally and has been a very successful independent consultant for many years. His passion is the relational engine, especially scalability, performance analysis and tuning.@TheSQLGuruhttp://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru484810066Meagan LongoriaMeagan Longoria is a business intelligence professional in the Kansas City area with over 5 years of experience working with Microsoft SQL Server and other business intelligence solutions. She is currently employed at Zillner in Lenexa, KS. In her spare time, she enjoys hanging out with her English bulldog named Buster. @mmariehttp://www.linkedin.com/in/meaganlongoriahttps://api.twitter.com/1/users/profile_image?screen_name=@mmarie48489482Nathan HeaivilinJust a DBA who wants to give back to the community in the way they have given to me and helped my development over the years.@SQLHeavenhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLHeaven484810055Rick KruegerRick Krueger is a SQL Server indie based in the Twin Cities with 17 years of software and database development experience, working with SQL Server since 1998 (6.5). Don’t let his developer credentials (MCPD) and background fool you, he knows a thing or two about SQL, and is currently focusing on Development DBA work. Rick has recently started tweeting as @DataOgre to get more involved in the SQL Community.
http://www.linkedin.com/in/premierappshttp://www.premierapps.comhttps://api.twitter.com/1/users/profile_image?screen_name=48489407Rowland GoslingMy career spans twenty one years and a dozen database platforms including Progress, Oracle, DB/2 and SQL Server (since 4.2). I've worked for Boeing at Kennedy Space Center, LearJet and a national magazine publisher. Today I head up a team of data professionals working with 14TB of data across three environments for the financial services industry.
@bigsqlhttp://www.linkedin.com/profile/edit?goback=%2Enmp_*1_*1_*1_*1_*1_*1trk=spm_pichttps://api.twitter.com/1/users/profile_image?screen_name=@bigsql484810464Rushabh MehtaRushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. Rushabh served as PASS President for the 2010/2011 term. He has worked with Microsoft SQL Server since 1998 and has designed and developed BI systems on the Microsoft platform since 2001. Rushabh is a SQL Server MVP and frequent speaker at large conferences and PASS Chapters around the world. As Immediate Past President, Rushabh continues to serve on the PASS Board.@rushabhmehtahttp://www.linkedin.com/in/rushabhbmehtahttps://api.twitter.com/1/users/profile_image?screen_name=@rushabhmehta484810971Smoothies Ice coldXtivia provides end-to-end solutions to meet your business needs48489485Steven WakeSteve Wake is a BI Consultant at Pragmatic Works with more than 15 years of experience in various IT organizations. Steve started his IT career as a COBOL programmer. In 2002 he decided to become an SSRS and C# developer. After learning as much as possible about SSRS he has learned SSIS and SSAS to increase his toolset. Steve is also very involved in the community, speaking and being elected President of the Denver SQL Server User Group in 2011. He blogs at wakebi.com @stevewake on Twitter.@stevewakehttp://www.linkedin.com/in/b5lurkerhttp://wakebi.comhttps://api.twitter.com/1/users/profile_image?screen_name=@stevewake484810531Tamera ClarkTamera Clark has been involved in the IT industry for over ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter. Tamera is currently a Database Engineer in the Nashville, Tennessee area. When not playing with computers, she enjoys tending her garden and experimenting in the kitchen.@tameraclarkhttp://tameraclark.comhttps://api.twitter.com/1/users/profile_image?screen_name=@tameraclark48489367Thomas 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 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/#!/SQLRockstar484893639363SQLSaturday 159Sports BarWrap upEvent wrap up and give aways8/4/2012 4:00:00 PM8/4/2012 4:30:00 PM93639363SQLSaturday 159AmazonWrap upEvent wrap up and give aways8/4/2012 4:00:00 PM8/4/2012 4:30:00 PM93639363SQLSaturday 159DanubeWrap upEvent wrap up and give aways8/4/2012 4:00:00 PM8/4/2012 4:30:00 PM93639363SQLSaturday 159ColumbiaWrap upEvent wrap up and give aways8/4/2012 4:00:00 PM8/4/2012 4:30:00 PM93639363SQLSaturday 159MissouriWrap upEvent wrap up and give aways8/4/2012 4:00:00 PM8/4/2012 4:30:00 PM93639363SQLSaturday 159SeineWrap upEvent wrap up and give aways8/4/2012 4:00:00 PM8/4/2012 4:30:00 PM93639363SQLSaturday 159HudsonWrap upEvent wrap up and give aways8/4/2012 4:00:00 PM8/4/2012 4:30:00 PM93649364SQLSaturday 159Sports BarLunch Break8/4/2012 12:15:00 PM8/4/2012 1:00:00 PM93649364SQLSaturday 159AmazonLunch Break8/4/2012 12:15:00 PM8/4/2012 1:00:00 PM93649364SQLSaturday 159DanubeLunch Break8/4/2012 12:15:00 PM8/4/2012 1:00:00 PM93649364SQLSaturday 159ColumbiaLunch Break8/4/2012 12:15:00 PM8/4/2012 1:00:00 PM93649364SQLSaturday 159SeineLunch Break8/4/2012 12:15:00 PM8/4/2012 1:00:00 PM93649364SQLSaturday 159HudsonLunch Break8/4/2012 12:15:00 PM8/4/2012 1:00:00 PM93659365Bill FellowsAmazon2012 TSQL SweetsThe 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.8/4/2012 8:00:00 AM8/4/2012 9:15:00 AM93679367Thomas LaRockSports BarChoose 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 Microsoft MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure.8/4/2012 11:00:00 AM8/4/2012 12:15:00 PM93839383David KleeHudsonVirtualizing Business Critical SQL ServersEveryone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and this session will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotchya’s will be discussed in this dynamic dialog session.8/4/2012 2:45:00 PM8/4/2012 4:00:00 PM94079407Rowland GoslingSports BarStorage Design and SQL Server Performance This discussion will be about storage design and how it affects SQL Server's performance. Topic will include Solid State Drives (SSDs), SAN and Direct Attached Storage (DAS) and how the perform using RAID 5,RAID 6 and RAID 10. We will also cover File Groups, Files and entry level Table Partitioning.
8/4/2012 2:45:00 PM8/4/2012 4:00:00 PM94669466Andy ThiruHudsonSQL Azure Intro and What's NewIn this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure 8/4/2012 8:00:00 AM8/4/2012 9:15:00 AM94829482Nathan HeaivilinColumbiaIntroduction to Execution PlansEver wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.8/4/2012 9:30:00 AM8/4/2012 10:45:00 AM94859485Steven WakeDanubeSSIS 2012: More Than Just a Pretty UISSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven't seen what has been updated in SSIS 2012, this will be the session to cover the most!8/4/2012 8:00:00 AM8/4/2012 9:15:00 AM97049704Christopher PriceSeineIntroduction to Master Data Services 2012 Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.8/4/2012 11:00:00 AM8/4/2012 12:15:00 PM97069706Christopher PriceSeineIntegrating DQS, MDS and Your Data Warehouse With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.8/4/2012 9:30:00 AM8/4/2012 10:45:00 AM97919791Karen LopezDanubeModel-Driven Database DesignModel-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as 'Who does what?', 'Why are we doing this?', 'Do I have to Use a GUI?' and 'Just who do you think you are?'. Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment.8/4/2012 1:00:00 PM8/4/2012 2:15:00 PM98069806John MorehouseSports Bar10 Things That Every DBA Should Know!Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things that he's seen in the trenches that every DBA should know and understand. 8/4/2012 8:00:00 AM8/4/2012 9:15:00 AM98079807John MorehouseMissouriSocial Networking Is Alive!Social Networking is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don't have any fear as this session is for you! Social networking can be a very confusing place and when you don't know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We'll be covering Facebook, LinkedIn and Twitter. 8/4/2012 11:00:00 AM8/4/2012 12:15:00 PM98339833David KleeSports BarDatabase Health and PerformanceSure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.8/4/2012 9:30:00 AM8/4/2012 10:45:00 AM98669866Kevin BolesColumbiaParallel Query Execution Deep DiveWhat exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.8/4/2012 1:00:00 PM8/4/2012 2:15:00 PM98689868Kevin BolesColumbiaSQL Server 2012 Column Store IndexTake your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.8/4/2012 2:45:00 PM8/4/2012 4:00:00 PM98919891Jason KassayDanubeThe Accidental ProgrammerMost people in the database world have heard of the term, 'The Accidental DBA', those programmers who out of nowhere get thrown into working with databases. Well what about the other side of the coin? What about those DB Developers and DBA's who have to write code? This presentation is a best practices guide for working with SQL Server in a .Net environment. It covers optimizing your code to reduce database requests, standard object oriented concepts such as data abstraction and encapsulation, tier architecture, security, and translating SQL data result sets into strongly typed class objects in .Net.8/4/2012 11:00:00 AM8/4/2012 12:15:00 PM99459945Frank KearneyColumbiaBuilding your first PowerView reportSo have you heard about this new fangled BI tool called PowerView from Microsoft? Well if you haven't then this is the session for you. During this session we will take a look at PowerView and discuss all the cool things it can do. Once we get all the talk'n out of the way, we walk through building your first PowerView report.8/4/2012 8:00:00 AM8/4/2012 9:15:00 AM1005510055Rick KruegerSports BarFreaky Fast Database Development TipsJoin Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, macros, and add-ins. We guarantee you will see something you haven’t seen before, or your money back.
Co-Presenter: Dave Valentine (@IngeniousSQL) 8/4/2012 1:00:00 PM8/4/2012 2:15:00 PM1005910059Dave ValentineAmazonSSRS: Reporting on ReportsBusiness Intelligence gets a lot of press these days, but do you often wonder to yourself as you are writing a report, ‘Who is going to use this’? Learn about the rich information that SSRS is already capturing for you about your reports: who is running them and how often, how long do they take to execute, how much time is spent in data retrieval vs rendering, which parameters were passed in, and more… Co-Presenter: Rick Krueger (@DataOgre)8/4/2012 2:45:00 PM8/4/2012 4:00:00 PM1006610066Meagan LongoriaAmazonReporting Services tips for the Stephen Few fanDo you opt for bullet charts over big, round gauges? Do 3-D pie charts make you sad? Have you ever redesigned a graph to get a better data-to-ink ratio? Whether you answered yes to all of these questions or you are unfamiliar with all of the above terms, come to this session to learn about helpful features and tools available when using Reporting Services to visually represent data in an efficient and effective manner. We will also discuss common challenges faced in the workplace when trying to implement the ideals in real life.8/4/2012 11:00:00 AM8/4/2012 12:15:00 PM1007110071Jason StrateSeineDiscovering the Plan CacheExecution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery. 8/4/2012 8:00:00 AM8/4/2012 9:15:00 AM1007210072Jason StrateDanubeExtended Events, Work Smarter Not HarderThere are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes. 8/4/2012 2:45:00 PM8/4/2012 4:00:00 PM1015310153Karen LopezAmazonDatabase Design ThrowdownA highly interactive debate between Thomas LaRock and Karen Lopez about options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys *NULL vs NOT NULL * Quality vs Performance...and others. Bring your votes, your debates, and your opinions.8/4/2012 9:30:00 AM8/4/2012 10:45:00 AM1015410154Andy GalbraithHudsonMaintain Your DBs with Help from Ola HallengrenOne of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.8/4/2012 1:00:00 PM8/4/2012 2:15:00 PM1036210362Juan SotoMissouriSo you want to be a computer consultant?Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way.
In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out.8/4/2012 1:00:00 PM8/4/2012 2:15:00 PM1039210392Doug LaneDanubeDevs are from Mars, Report Servers are from VenusAt first, you loved working with Reporting Services, but now the honeymoon's over. What good are charts and tables when Reporting Services won't tell you what's wrong, renders too slow, and messes up your layout? You may be thinking about seeing other reporting products, but don't give up.
In this couples therapy for you and SSRS, rekindle your love by reviewing how reports perform best, seeing what RS has been trying to tell you (but you haven't been listening), and discovering new and simple tricks you never knew reports could do. You'll learn about:
• Dealing with blank extra pages
• Designing reports for high performance
• Powerful properties for precise layout and appearance
• Troubleshooting using the execution log
• ..a8/4/2012 9:30:00 AM8/4/2012 10:45:00 AM1043310433Andy ThiruHudsonSQL Azure Data Sync and What's NewIn this session, you will get introduced to SQL Azure Data Sync and learn how to get started. We will explore how to migrate data from an existing on-premise SQL Server database to SQL Azure and bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers.
What you will learn:
• Overview of SQL Azure
• How to Get Started with SQL Azure Data Sync
• Cloud to cloud synchronization
• Enterprise (on-premises) to cloud
• Cloud to on-premises.
• Bi-directional or sync-to-hub or sync-from-hub synchronization
8/4/2012 11:00:00 AM8/4/2012 12:15:00 PM1046410464Rushabh MehtaSeineSSIS 2012 Management Considerations and Best PractSQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages8/4/2012 2:45:00 PM8/4/2012 4:00:00 PM1046510465Rushabh MehtaSeineIntroduction to Data Quality ServicesData Quality Services (DQS) has been introduced as part of the Microsoft SQL Server 2012 stack. In this session, we will take a first look at DQS and how it can transform the way we enable and set data quality standards to ensure clean data.8/4/2012 1:00:00 PM8/4/2012 2:15:00 PM1046710467Bill GrazianoHudsonUnderstanding the Procedure Cache: Writing EfficieWhen is a query plan reused? When will dynamic SQL give better performance results than stored procedures? What are the benefits of a compiled query plan? When should you turn on forced parameterization? What is the most efficient way to write SQL for reports that might have wildly different WHERE clauses? Why is my stored procedure very slow sometimes? How efficient is the SQL from LINQ? How efficient is the SQL from ORM tools?8/4/2012 9:30:00 AM8/4/2012 10:45:00 AM1047710477Christopher ShawColumbia'What is the Best Disaster Recovery Solution?'It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is. 8/4/2012 11:00:00 AM8/4/2012 12:15:00 PM1053110531Tamera ClarkAmazon45 Minutes to Build Your First Reporting ServicesDoes this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data! 8/4/2012 1:00:00 PM8/4/2012 2:15:00 PM1097110971Smoothies Ice coldSports BarSmoothie breakCool down with smoothies courtesy of Xtivia8/4/2012 2:15:00 PM8/4/2012 2:45:00 PM1097110971Smoothies Ice coldAmazonSmoothie breakCool down with smoothies courtesy of Xtivia8/4/2012 2:15:00 PM8/4/2012 2:45:00 PM1097110971Smoothies Ice coldDanubeSmoothie breakCool down with smoothies courtesy of Xtivia8/4/2012 2:15:00 PM8/4/2012 2:45:00 PM1097110971Smoothies Ice coldColumbiaSmoothie breakCool down with smoothies courtesy of Xtivia8/4/2012 2:15:00 PM8/4/2012 2:45:00 PM1097110971Smoothies Ice coldSeineSmoothie breakCool down with smoothies courtesy of Xtivia8/4/2012 2:15:00 PM8/4/2012 2:45:00 PM1097110971Smoothies Ice coldHudsonSmoothie breakCool down with smoothies courtesy of Xtivia8/4/2012 2:15:00 PM8/4/2012 2:45:00 PM