SQLSaturday #145 - Nashville 201210/13/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. #sqlsat145David Lipscomb University - Swang Business CenterOne University Park DriveNashvilleTN372042339Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702650Iderahttp://www.idera.comhttp://www.idera.com/campaign_images/idera_logo_notag.png601702652SQL Sentry, Inc.http://www.sqlsentry.nethttp://www.sqlsentry.net/images/icons/sqlsentrylogo100-transparent.png601702694CTS, Inc.http://www.askcts.com/http://www.sqlsaturday.com/files/f4c30480-2646-4977-9873-13e0bd85ee42.png601702696Vaco Technologyhttp://www.vaco.comhttp://www.sqlsaturday.com/files/4024a953-24df-4e0d-adac-f85325d70ffc.jpg601702705Quest Softwarehttp://www.quest.com/http://www.quest.com/images/common/quest_logo.gif601702756Teknetexhttp://www.teknetex.comhttp://www.sqlsaturday.com/files/d4cb9100-5462-4ae3-9dbb-fe3caa7ecd6b.png601702761Sapien Technologieshttp://www.sapien.comhttp://www.sqlsaturday.com/files/6edd630a-4bb7-4015-bc31-9c1823b33310.jpg601702493PASS Headquarters http://www.sqlpass.orghttp://www.sqlsaturday.com/images/PASS_logo.jpg601702553Fusion-iohttps://www.fusionio.comhttp://www.sqlsaturday.com/files/497ac7a8-c0c1-4cc6-ae77-e332c26a0283.png601702618Aspect Consultinghttp://www.aspect-consulting.comhttp://www.aspect-consulting.com/media/17527/aspect_logo.jpg601702290Joes 2 Proshttp://www.joes2pros.com/index.phphttp://joes2pros.com/www/wordpress/wp-content/uploads/2012/05/logo/j2p-logo.png601702277CozyRochttp://www.cozyroc.comhttp://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601702661Soaring Eagle Consulting, Inc.http://www.soaringeagle.bizhttp://www.sqlsaturday.com/files/cb514907-9805-4862-9bf2-593056747f59.jpg601702214@Bill_Pearson (Island Technologies Inc.)http://digital-duke.comhttp://digital-duke.com/wp-content/Digital-Duke.comWhiteBak.jpg401002224Steve Hughes - Data on Wheelshttp://www.dataonwheels.comhttp://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png401009773Adam BelebczukAdam Belebczuk is a Developer turned Accidental DBA for Banyan Technology of Elyria, OH. Adam has over 8 years of experience in IT ranging from customer service to server/network administration to software and database development. Adam is an MCITP DBA 2005/2008, and specializes in SQL Server development and performance tuning.@nfdotcomhttp://www.linkedin.com/in/itacbhttp://www.SQLDiablo.comhttps://api.twitter.com/1/users/profile_image?screen_name=@nfdotcom484811218Allen WhiteAllen is a Practice Manager for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last five years. He's President of the Ohio North SQL Server User's Group and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.
@SQLRunrhttp://www.linkedin.com/profile/view?id=16846136locale=en_UStrk=tab_prohttp://www.upsearch.com/sqlhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLRunr484811032Craig UtleyCraig Utley is a Mentor with SolidQ and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT) where he focused on Business Intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0, when he helped write Microsoft's first data warehousing course. Since then he has consulted at a variety of businesses worldwide on their BI solutions as an independent consultant, a ProClarity consultant, and a member of SQLCAT.@CraigUtleySQLhttp://www.linkedin.com/in/craigutleyhttp://www.learnmicrosoftbi.comhttps://api.twitter.com/1/users/profile_image?screen_name=@CraigUtleySQL48489595Daniel EvansDan Evans has been working with Business Intelligence solutions for over 15 years and focuses on Microsoft platforms. He's a TDWI certified business intelligence professional (CBIP) with mastery in business analytics, architecture, and strategy. He currently works at Avanade as a Director of the Business Intelligence Service Line and is Market Lead for the Southeast US. Dan is the President of the Memphis PASS chapter and speaks regularly at PASS chapters, TechEd and TDWI.@danthebimanhttp://www.linkedin.com/pub/dan-evans-cbip/0/613/495https://api.twitter.com/1/users/profile_image?screen_name=@danthebiman48488803David Klee’m a developer specializing in .Net, SQL, and SSRS development for over five years of the eighteen years I have spent in the IT Industry. I have experience working for some big companies in Financial, Healthcare, and Insurance. I have written some custom reporting solutions and web applications for Large Companies in the Tampa Bay area using .Net, SSRS, and SQL. I’m currently a Sr. Developer at AgileThought that is leader in software development and system integration services in Tampa FL.@bisqldavehttp://www.linkedin.com/in/davidakleehttp://davidklee.nethttps://api.twitter.com/1/users/profile_image?screen_name=@bisqldave484811790Denny CherryDenny Cherry specializes as an independent consultant working with platforms such as SQL Server, VMware’s vSphere, Hyper-V, and enterprise storage platforms such as EMC’s CLARiiON, DMX, VNX, VNXe, vMAX, vBlock, Celerra, etc. as well as IBM’s XVI array and NetApp’s filers in addition to a variety of server hardware platforms including blade systems such as Cisco’s UCS platform and C series servers. I have over 12 years of experience working with enterprise solutions in a variety of capacities.@mrdennyhttp://www.linkedin.com/in/mrdennyhttp://www.mrdenny.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mrdenny484811686Eddie WuerchEddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the Principal Database Architect and DBA team lead at a leading SaaS company located in Indianapolis, Indiana. Eddie and his team manage the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the application. In addition to holding MCITP certifications in SQL Server 2005 and 2008 development and administration, @eddiewhttp://www.linkedin.com/in/eddiewuerchhttp://indydba.com/https://api.twitter.com/1/users/profile_image?screen_name=@eddiew484810753Gareth SwanepoelGareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for almost 20 years. He enjoys solving the complex problems that his clients encounter when deploying SQL Server in a data warehouse environment. He is a member of the Pragmatic Works SEAL Team with a focus on Fast Track Data Warehouses, PDW and Infrastructure Tuning. Current projects include contributing content for the upcoming SQL Server 2012 Pro Admin book.@GarethSwanhttp://www.linkedin.com/in/garethswanhttp://www.mygareth.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GarethSwan484811087Geoff HitenMicrosoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in high-availability and high-performance SQL systems. Geoff was a PASS Board Director for 2011.@sqlcaftsmanhttp://www.linkedin.com/profile/view?id=5834715trk=tab_prohttps://api.twitter.com/1/users/profile_image?screen_name=@sqlcaftsman48488776Glenn BerryGlenn works as a Database Architect at Avalara 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 the book SQL Server Hardware, and blogs regularly at http://sqlserverperformance.wordpress.com.
@GlennAlanBerryhttp://www.linkedin.com/profile/view?id=38447276trk=tab_prohttp://sqlserverperformance.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@GlennAlanBerry484810978J.D. PellerinJ.D. works as a Database Administrator at HealthSpring in Nashville, Tennessee.http://www.linkedin.com/pub/j-d-pellerin/4/853/11048489164Jason StrateJason Strate, Digineer Inc, is a DBA with over fifteen years of experience. He is a recipient of the Microsoft Most Valuable Professional (MVP) for SQL Server since July, 2009. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Certification exams for SQL Server 2008.@stratesqlhttp://www.linkedin.com/in/jasonstratehttp://www.jasonstrate.comhttps://api.twitter.com/1/users/profile_image?screen_name=@stratesql484810778Jeffrey GarbusJeff has been in the SQL Server business for over 20 years, training and consulting, with an emphasis on performance and tuning. He has written over a dozen books, and hundreds of magazine articles. He has spoken at a week of SQL Saturdays. http://www.linkedin.com/in/jeffgarbushttp://mssqlperformance.blogspot.com/48489398Joe MurphreeI am currently the SR DBA and Manager of the DBA team at HealthSpring which is where I have worked for the past 5 years. I have been a DBA for 7 years now managing mostly MS SQL Server. I have presented multiple times to the Nashville SQL Users group on topics such as Statistics in-depth and Indexes in-depth. I have most recently attended the SQLSkills IE2 Performance Tuning class as well.@joewebbhttp://www.linkedin.com/in/josephkwebbhttps://api.twitter.com/1/users/profile_image?screen_name=@joewebb48489165Jonathan BoulineauJon Boulineau is a 12 year it veteran currently working as a DBA for a Fortune 500 company. In addition to his work as a DBA he has survived phases as a network engineer, systems administrator, and developer in his career. He resides in Columbus, GA with his wife and four children.@jboulineauhttp://jonathanagardner.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jboulineau484810388Joseph D'AntoniKaren López, Joey D'Antoni@jdantonhttp://joedantoni.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484811215Josh FennessySenior Business Intelligence Consultant at BlueGranite, Inc., Josh Fennessy has been working with the Microsoft BI stack exclusivley for the last 5 years. He has earned MCITP in both SQL 2005 and SQL 2008 versions of the tools. Josh is also the chapter leader of the West MI SQL Server Users Group.
When he's not building BI solutions, he enjoys spending time with his 6 year old son, slinging lead at the range, and exercising (but never in his underwear. Promise!)@joshuafennessyBhttp://www.joshuafennessy.comhttps://api.twitter.com/1/users/profile_image?screen_name=@joshuafennessy48489095Karen 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=@datachick48489388Kathi KellenbergerKathi Kellenberger recently joined Pragmatic Works as Sr. Consultant. Kathi is a speaker, author, trainer and a former SQL Server MVP. She is the author of “Beginning T-SQL 2008” and co-author of “Professional SQL Server 2005 Integration Services,” and 'Beginning T-SQL 2008.' Kathi has been a volunteer with the PASS organization since 2005, winning the PASSion award in 2008 for her work on the Program Committee. In her free time, Kathi loves spending time with friends and family.@auntkathihttp://www.linkedin.com/in/kathikellenbergerhttp://www.pragmaticworks.comhttps://api.twitter.com/1/users/profile_image?screen_name=@auntkathi484811230Kevin BolesKevin is a SQL Server expert, working exclusively with the product since version 6.5. With almost 20 years of database experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 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=@TheSQLGuru484811658Kieth MayerKeith Mayer is a Technical Evangelist at Microsoft focused on Windows Infrastructure, Data Center Virtualization, Systems Management and Private Cloud. Keith has over 17 years of experience as a technical leader of complex IT projects, in diverse roles, such as Network Engineer, IT Manager, Technical Instructor and Consultant. He has consulted and trained thousands of IT professionals worldwide on the design and implementation of enterprise technology solutions. @KiethMayerhttp://www.linkedin.com/in/keithmhttp://KeithMayer.comhttps://api.twitter.com/1/users/profile_image?screen_name=@KiethMayer484811657Louis DavidsonLouis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. For more information please visit drsql.org @drsqlhttp://www.linkedin.com/in/louisdavidsonhttp://drsql.orghttps://api.twitter.com/1/users/profile_image?screen_name=@drsql48488778Mark StaceyMark founded Pragmatic Works South Africa, the first Pragmatic Works international franchise, and works tirelessly to cross the business / technical boundaries in Business Intelligence, working in both Sharepoint and SQL.
He has published a book (Sharepoint 2010 BI), founded the BIDN user group in Johannesburg, and, a rarity, frequently speaks at both SQL Saturday and Sharepoint Saturday events.
@MarkGStaceyhttp://www.linkedin.com/in/MarkGStaceyhttps://api.twitter.com/1/users/profile_image?screen_name=@MarkGStacey484810896Pam ShawPam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa.@http://www.linkedin.com/in/pshaw1129http://www.linkedin.com/in/pshaw1129https://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw112948489690Rick MorelanRick Morelan is the author of the “Joes 2 Pros” book SQL series designed to prepare the reader to pass the Microsoft exam 70-433 for SQL Developers. Rick has previously worked at Microsoft for more than 10 years and has obtained SQL Certifications in versions 7.0, 2000, 2005 and 2008. Rick has presented at SQL Saturdays in the USA, Canada, and India. Currently Ricks Joes2Pros YouTube channel has 1,800 subscribers, gets about 1000 views per day, with over 600,000 total video views since 2010. @Joes2Proshttp://Joes2Pros.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Joes2Pros48489012Rob VolkRob Volk does deranged things with SQL Server, so you don't have to. A DBA in the Metro Atlanta area for the past 10 years, 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_r484810936Robert CainRobert C. Cain (http://arcanecode.com) is a Microsoft MVP SQL Server, MCTS Certified in BI, and works as a Senior Consultant for Pragmatic Works. He is also a technical contributor to Plurasight Training, co-author of Volumes 1 and 2 of 'SQL Server MVP Deep Dives', as well as the upcoming 'Professional SQL Server 2012 Administration'. A popular speaker, Robert has presented at events such as TechEd, SQL Rally, and numerous SQL Saturdays.@arcanecodehttp://www.linkedin.com/in/arcanecodehttp://arcanecode.comhttps://api.twitter.com/1/users/profile_image?screen_name=@arcanecode48489579Sanil MhatreSanil Mhatre is a SQL Server 2008 MCTS with a Master’s degree in Information Systems. As a Database Developer, he currently focuses on the SQL Server platform for a large financial services company in St. Louis.Starting as a Java Developer, Sanil turned his interests toward databases while migrating an application from DB2 to Oracle enjoys switching hats between database development and administration across multiple database platforms. He is an active member of the STLSSUG. @SQLSuperguruhttp://sqlwithsanil.com/https://api.twitter.com/1/users/profile_image?screen_name=@SQLSuperguru48489625Sarah BarelaSarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has more than 15 years of administrative experience with SQL Server. She specializes in the administration of enterprise environments with large numbers of SQL Servers. Her latest interests lay in applying cloud technologies to SQL Server Environments. She has been a guest speaker at a number of PASS chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQL Saturday events and PASS Summits@sarahspacehttp://www.linkedin.com/profile/view?id=9178986trk=tab_prohttp://www.sqlsarah.nethttps://api.twitter.com/1/users/profile_image?screen_name=@sarahspace484810833Tim FordTim Ford is the Lead Database Administrator and SQL Server Subject Matter Expert for Spectrum Health. Since 2010 he's been taking 15 students along with other community speakers teaches SQL Server, networks, and relaxes on SQL Cruises (sqlcruise.com). Tim is a community speaker, volunteer, and author. His book with Louis Davidson: Performance Tuning with SQL Server Dynamic Management Views is now widely available; as an avid telecommuter, he rarely wears pants.@SQLAgentManhttp://www.linkedin.com/in/timothyfordhttp://www.thesqlagentman.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLAgentMan484811659Wayne SnyderWayne Snyder specializes in Business Inteliigence Solutions, and is an international speaker, author, and PASS volunteer. He is a SQL Server MVP, co-author of Knight's 24 Hour SQL 2012 SSIS Trainer, and author of the popular Learnkey SQL Server Training series. He is a Distinguished Architect for Mariner(www.mariner-usa.com), who, on the weekend, he sings and plays keyboards for the regional band - soundbarrier(www.soundbarrierband.com).@SQLWaynehttp://www.linkedin.com/profile/view?id=1492209locale=en_UStrk=tab_prohttp://www.mariner-usa.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLWayne48488835William E. Pearson IIIBill 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-3a4a3451f85ehttps://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85Ehttps://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson484887768776Glenn Berry1-108Hardware 301: Diving Deeper into Database HardwareMaking the right hardware selection decisions is extremely important for database scalability. Having properly sized and configured hardware can both increase application performance and reduce capital expenses dramatically. Unfortunately, there are so many different choices and options available when it comes to selecting hardware and storage subsystems, it is very easy to make bad choices based on outmoded conventional wisdom. This session will give you a framework for how to pick the right hardware and storage subsystem for your workload type. You will learn how to evaluate and compare key hardware components, such as processors, chipsets, and memory.10/13/2012 9:45:00 AM10/13/2012 10:45:00 AM87788778Mark Stacey6-112Slowly changing dimensions- an integrated approachThere are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension.
In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services10/13/2012 11:00:00 AM10/13/2012 12:00:00 PM88038803David Liebman6-112BI in the CloudIn this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.10/13/2012 8:30:00 AM10/13/2012 9:30:00 AM88358835William E. Pearson III4-100Bridging the Chasm: BI Theory vs. PracticeA Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.10/13/2012 9:45:00 AM10/13/2012 10:45:00 AM90129012Rob Volk2-110Revenge: 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, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!10/13/2012 9:45:00 AM10/13/2012 10:45:00 AM90959095Karen Lopez1-108Database Design ThrowdownKaren and Tom debate about options and best practices of common and advanced design issues, such as:
* Natural vs. Surrogate keys *NULL vs NOT NULL
* Agile Database Design
* Database Refactoring
* How much does Size Matter?
* Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.10/13/2012 11:00:00 AM10/13/2012 12:00:00 PM91649164Jason Strate1-108Extended 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. 10/13/2012 2:30:00 PM10/13/2012 3:30:00 PM91659165Jonathan Gardner5-102Adventures in Project ManagementProjects that run long, run over budget, or flat out fail always get management's attention, and not good attention. This session will cover the project management process and demonstrate how it can help deliver higher quality results on time and on budget.
Case studies and real world examples will arm managers and team leads with tools including communication management plans, requirements documentation, stakeholder management plans, and change management. These tools will help mitigate and manage common project pitfalls like status update meetings, gold plating, and scope creep.
At the end of the session attendees will be armed with the knowledge necessary to streamline projects and how to deliver a top quality work product.
10/13/2012 2:30:00 PM10/13/2012 3:30:00 PM93889388Kathi Kellenberger1-108SQL Server 2012 T-SQLYou have heard all about AlwaysOn, BI Semantic Model, and Power View. Did you know that SQL Server 2012 has a host of new T-SQL features? Attend this session to learn more about the Sequence object, new functions and enhancements to the OVER clause.
10/13/2012 1:15:00 PM10/13/2012 2:15:00 PM93989398Joe Murphree5-102Beginners guide to Table ExpressionsCommon Tables Expressions (CTE) were introduced in SQL 2005. If you have only heard about them and would like to know more about how they work and there benefits this class is for you.
What you will learn:
* The structure and syntax of a CTE
* Benefits of using a CTE vs derived or temp tables
* Recursive CTE’s
* DML with CTE’s
10/13/2012 3:45:00 PM10/13/2012 4:45:00 PM95799579Sanil Mhatre2-110Parameter sniffing - make it work for you !Parameter Sniffing is usually thought of as the bad guy, in association with a performance problem in your database. Contrary to the popular belief, Parameter Sniffing is usually the good guy, continuously working under the hood to help your database applications run faster. However, it can sometimes go wrong, causing severe performance degradation of your queries.
In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.
10/13/2012 11:00:00 AM10/13/2012 12:00:00 PM95959595Daniel Evans4-100What's new in BI for SQL Server 2012Many new features of SQL Server 2012 enable businesses to leverage Business Intelligence efforts. Come learn what's new in SQL Server 2012 for BI and the new capabilities with Tabular models, PowerPivot and Power View.10/13/2012 2:30:00 PM10/13/2012 3:30:00 PM96259625Sarah Barela3-114Bulletproof: Hardening your SQL Server from AttackRecent major security breaches have not only exposed customer data, but also the system vulnerabilities DBAs must overcome daily. As data protection is a DBA’s primary responsibility, establishing an impenetrable environment to host the data is the first step towards risk-free security. How can DBAs ensure SQL Servers are fortified against the latest threats and vulnerabilities? In this session, we will go through the process of hardening your SQL Server from attack from Windows Server to the database level step-by-step. I will share will share with you how establish security baselines and monitor for changes to your security foundation. This session will provide specific actions for you to take back and apply to your servers.10/13/2012 2:30:00 PM10/13/2012 3:30:00 PM96909690Rick Morelan2-110Do SQL XML queries have to scare me?I have seen days of amazing C# XML library coding work replaced by 2 lines of a FOR XML statement in SQL. Built into SQL is the power to make XML do pretty much whatever you need it to. Learn how to use the XML data type and built-in XQuery functions. You will also see how to join (or “bind”) a SQL table to an XML stream to produce a single result set. 10/13/2012 1:15:00 PM10/13/2012 2:15:00 PM97739773Adam Belebczuk3-114SQL Server 2012 AlwaysOn Readable SecondariesOne of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you're just curious about AlwaysOn, then you won't want to miss this session.10/13/2012 8:30:00 AM10/13/2012 9:30:00 AM98199819Jonathan Boulineau2-110T-SQL: Beyond the BasicsIf you've been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better.10/13/2012 8:30:00 AM10/13/2012 9:30:00 AM99599959Mark Swofford5-102I Shoulda Taken That Left Turn at Albuquerque...The first 24 months are extremely important in our careers when we’ve been offered the opportunity to take on the ‘DBA’ role. To be successful, it takes a solid foundation of general concepts, career development, training, fearlessness, confidence, and mentorship from more experienced professionals.
Organization, planning, and having a roadmap to where you are going will be crucial to your success. This session will bring these topics together so you can set your GPS to success avenue.
10/13/2012 9:45:00 AM10/13/2012 10:45:00 AM1014110141David Klee3-114Virtualizing 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 David Klee (@kleegeek) 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 gotcha’s will be discussed in this dynamic dialog session.10/13/2012 1:15:00 PM10/13/2012 2:15:00 PM1038810388Joseph D'Antoni5-102You Wouldn't Let HR Manage Your DBs...So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel.10/13/2012 1:15:00 PM10/13/2012 2:15:00 PM1075310753Gareth Swanepoel4-100The Fangorn Forest - ColumnStore IndexesIn the fantasy world of Middle-earth live the Ents. The Ents are tall tree-people who help the Fellowship by parallelizing the fight against Saruman. Come and learn how the new SQL 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations in the same way. I will be doing a deep dive into the inner workings of ColumnStore indexes.If you are a production DBA who needs to find out about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments or if you are a BI developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is for you.10/13/2012 3:45:00 PM10/13/2012 4:45:00 PM1077810778Jeffrey Garbus2-110Rewriting bad T-SQL CodeThis session provides 2 case studies of poorly performing T-SQL code, and works through rewrites into better performing code.10/13/2012 2:30:00 PM10/13/2012 3:30:00 PM1083310833Tim Ford6-112The Periodic Table of Dynamic Management ObjectsTaking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yield interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!10/13/2012 3:45:00 PM10/13/2012 4:45:00 PM1089610896Pam Shaw4-100Taking the Scary out of Monster ReportsSo the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
10/13/2012 1:15:00 PM10/13/2012 2:15:00 PM1093610936Robert Cain4-100The Decoder Ring for Data Warehousing / BIBusiness Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. 10/13/2012 11:00:00 AM10/13/2012 12:00:00 PM1097810978J.D. Pellerin3-114Custom SQL Server Transaction Log ShippingUsing a custom database transaction log shipping process instead of the built in SQL Server transaction log shipping component. Custom database transaction log shipping has several advantages, including:
a) The SQL Server instances need not have any connectivity to one another
b) Applying of the transaction log backups can be suspended for weeks and then enabled, with the log shipped database being brought as
current as the most recent transaction log backup.
While transaction log backups are suspended, the Log Shipped Database can be placed in standby/Read Only mode, for querying.
c) Using custom database transaction log shipping also allows more control over each part of the process.
10/13/2012 3:45:00 PM10/13/2012 4:45:00 PM1103211032Craig Utley4-100Why BI Projects Fail--And What You Can Do About ItIs your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.10/13/2012 8:30:00 AM10/13/2012 9:30:00 AM1108711087Geoff Hiten1-108Bad SQLGood Code, Bad Code. It can be the difference between a server running smoothly and an unresponsive piece of junk. This session digs into what makes some SQL code perform faster and scale better. Session is almost all interactive demo.10/13/2012 3:45:00 PM10/13/2012 4:45:00 PM1121511215Josh Fennessy5-102New Models! An Introduction to Tabular Mode SSASIn this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.10/13/2012 11:00:00 AM10/13/2012 12:00:00 PM1121811218Allen White1-108Gather SQL Server Performance Data with PowerShellWe all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.10/13/2012 8:30:00 AM10/13/2012 9:30:00 AM1123011230Kevin Boles3-114Indexing Deep DiveAnother in TheSQLGuru's very popular 'Deep Dive' series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.10/13/2012 11:00:00 AM10/13/2012 12:00:00 PM1165711657Louis Davidson6-112Quiz BowlA rough cut preview of the SQL PASS opening session game show of SQL and general trivia.10/13/2012 1:15:00 PM10/13/2012 2:15:00 PM1165811658Kieth Mayer6-112Virtualizing SQL Server with Windows Server 2012 aWindows Server 2012 has been acclaimed by industry pundits as the most ambitious release of a Microsoft Server OS since Windows 2000! Windows Server 2012 is now available, and now is a great time to start evaluating it for your next project. Attend this session to learn what’s new in Windows Server 2012 and Hyper-V in Scalability, Virtualization, Storage, Networking and Manageability and get a jump start in preparing for how best to leverage Windows Server 2012 in your environment for SQL Server database workloads.10/13/2012 9:45:00 AM10/13/2012 10:45:00 AM1165911659Wayne Snyder6-112Deeper into Tabular Models - M-to-M and the 'W'You will need to understand how many-to-many relationships work in tabular models. While different than dimensional models, you can be successful in getting many of the behaviors you will need. Understanding how filters propagate is necessary requisite. We will use a 'W' diagram to understand how this occurs in tabular models. Then we will learn how to force filter propagation, called cross-filtering. Then we will cross-filter conditionally, based on what the user has chosen for filters. If time permits we will also learn how to handle large numbers of fact rows, both in development and production.10/13/2012 2:30:00 PM10/13/2012 3:30:00 PM1168611686Eddie Wuerch3-114TempDB Performance Troubleshooting and OptimizingEvery SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.10/13/2012 9:45:00 AM10/13/2012 10:45:00 AM1177211772Joe Webb5-102Professional DevelopmentImagine trying to steer a car blindfolded. How about shooting a jump shot without being able to see the goal. It's not easy, is it? Yet, that's exactly what your team is doing if you are not providing clear and effective feedback about their work and behavior.
In this session, you'll learn how to provide effective feedback to your peers and direct reports. You'll learn how to deliver feedback that encourages the behavior that you'd like to see repeated and provides recommended changes for behavior that is subpar or not acceptable. You'll also lean how to customize your feedback based on different personality types. 10/13/2012 8:30:00 AM10/13/2012 9:30:00 AM1179011790Denny Cherry2-110TBA - Introductory SQL SessionTBA10/13/2012 3:45:00 PM10/13/2012 4:45:00 PM