SQLSaturday #144 - Sacramento 2012 7/28/2012 12:00:00 AM (GMT-08:00) Pacific Time (US and Canada); Tijuana SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat144 Courtyard Marriott Midtown Sacramento 4422 Y Street Sacramento CA 95817 2334 Idera Platinum Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 2452 DesignMind Platinum Sponsor http://www.designmind.com/ http://www.sqlsaturday.com/files/8c0b8a15-ef61-49f3-a7ff-78fe28fa9a8b.jpg 60 170 2477 ScaleArc Platinum Sponsor http://www.scalearc.com http://www.scalearc.com/images/logourl/170_60.jpg 60 170 2344 Nimble Storage Gold Sponsor http://www.nimblestorage.com/ http://www.sqlsaturday.com/files/3e4725d4-3a89-45cd-8c1d-a2bada62796b.PNG 60 170 2081 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2091 Esurance Gold Sponsor http://www.esurance.com http://blog.esurance.com/wp-content/uploads/esurance-is-an-allstate-company.jpg 60 170 2092 Robert Half Technology Silver Sponsor http://www.roberthalftechnology.com/ http://sac.sqlpass.org/Portals/78/SQLSaturday/Images/RobertHalf.jpg 60 170 2262 Red Gate Software Silver Sponsor http://www.red-gate.com http://www.red-gate.com/assets/images/common/logo.png 60 170 2265 McAfee Silver Sponsor http://www.mcafee.com http://i126.photobucket.com/albums/p109/Beebs_photo/mfe_primary_logo_rgb.jpg 60 170 2373 Quest Software Silver Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2268 CozyRoc LLC Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2233 Cisco Systems Post Event Party Sponsor http://www.cisco.com http://sac.sqlpass.org/Portals/78/SQLSaturday/Images/Cisco.jpg 60 170 2346 O'Reilly Media, Inc. Raffle Sponsor http://ug.oreilly.com/ http://oreilly.com/images/orn_logos/sm.ora.logo.plain.gif 40 100 2347 SAPIEN Technologies, Inc. Raffle Sponsor http://www.sapien.com/ http://www.sapien.com/assets/img/logo3.png 40 100 2465 McGraw-Hill Raffle Sponsor http://www.mhprofessional.com/ http://www.mhprofessional.com/images/leanrmore_logo.gif 40 100 2466 Murach Raffle Sponsor http://www.murach.com/ http://www.murach.com/images/logos/MurachWhiteLogo.jpg 40 100 2484 Wrox Raffle Sponsor http://www.wrox.com/ http://sac.sqlpass.org/Portals/78/WroxLogo.gif 40 100 2483 Repo Remarketing Personal Sponsor http://www.reporemarketing.com http://www.reporemarketing.com/images/logo_164x67.jpg 40 100 2455 retracement Blog Sponsor http://tenbulls.co.uk http://retracement.files.wordpress.com/2012/07/retracement_sponsor_logo.png 40 100 2029 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 2364 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 8798 Angel Abundez Angel Abundez is a Business intelligence consultant with DesignMind. He is passionate about Business Intelligence, Visualization, and improving business processes using SQL Server, SharePoint, and ASP.NET. Angel’s worked with SQL Server since 2007 and is excited about the new visualizations coming out with PowerPivot, Power View, and SharePoint. He is currently the Co-Lead of the Bay Area BI User Group and is an active speaker in the SQL Server community. @AngelStreamline http://www.linkedin.com/in/angelrdp http://www.angelsbiblog.com https://api.twitter.com/1/users/profile_image?screen_name=@AngelStreamline 48 48 10538 Benjamin Nevarez Benjamin Nevarez is a database professional based in Los Angeles and author of “Inside the SQL Server Query Optimizer”, published by Red Gate books. He has more than 15 years of experience with relational databases, and has been working with SQL Server since version 6.5. Benjamin has also been the technical editor of the two latest books by Kalen Delaney including “SQL Server 2008 Internals”. He has been a speaker at several technology conferences, including the PASS Summit and SQL Connections. @BenjaminNevarez http://www.benjaminnevarez.com/ https://api.twitter.com/1/users/profile_image?screen_name=@BenjaminNevarez 48 48 10534 Carlos Bossy Carlos Bossy (MCTS SQL Server 2008 BI, CBIP) is a an independent consultant with 25 years in software and database development. Carlos focuses on Business Intelligence solutions that include developing data models for BI, data warehouse strategies, predictive models, data mining, real-time BI, analytics, reporting, and data warehouse performance tuning. He has worked with SQL Server for 12 years and is very enthusiastic about its powerful features. @carlosbossy http://www.linkedin.com/in/carlosbossy http://www.carlosbossy.com https://api.twitter.com/1/users/profile_image?screen_name=@carlosbossy 48 48 9803 Denise McInerney Denise McInerney began her career as a SQL Server DBA in 1998. Denise's focus is design and performance tuning OLTP databases that support web-based applications. She is currently employed as a Staff DBA at Intuit in Mountain View, CA. Her primary job is to design, tune and manage databases that support one of the company’s eCommerce web sites. Denise has been an active PASS volunteer since 2003 and currently serves on the organization's Board of Directors. @denisemc06 http://weblogs.sqlteam.com/denisem https://api.twitter.com/1/users/profile_image?screen_name=@denisemc06 48 48 9286 Eric Freeman Eric Freeman works as a Senior Business Intelligence Analyst at Esurance, an Allstate Company. He has 10+ years of experience working on Microsoft SQL Server with an emphasis on Performance Tuning, ETL and Data Warehousing. He is President of PASS’ Sacramento Chapter- Sacramento SQL Server User Group, and holds an MCTS in Business Intelligence. @sqlelf http://www.linkedin.com/profile/view?id=25325218 https://api.twitter.com/1/users/profile_image?screen_name=@sqlelf 48 48 8680 Harry Chandra Harry Chandra is a SQL Server Database Administrator for a software company in Portland, Oregon with a Bachelor of Arts Degree in Information System from Portland State University. He's been working with various releases of SQL Server for over 4 years. His main focus is in Administration and High Availability for SQL Server, although he has always strived to expand his knowledge into other area of SQL Server. He is a member of the Portland SQL Server User Group and SQL Pass member. @SQLDude503 http://www.linkedin.com/pub/harry-chandra/38/219/324 http://blogs.h2dclan.com https://api.twitter.com/1/users/profile_image?screen_name=@SQLDude503 48 48 9392 Helen Norris Helen Norris is an Associate Vice President for Technology Services at California State University, Sacramento. Helen has almost 30 years experience working in IT in a variety of industries including higher education, advertising and consumer product delivery. Originally from Ireland, Helen has earned a Bachelor's degree in Mathematics from Trinity College, Dublin, Ireland, and a Master's degree in Computer Resource Management and Business Administration from Webster University in St. Louis. @hpnorris http://www.linkedin.com/in/helennorris https://api.twitter.com/1/users/profile_image?screen_name=@hpnorris 48 48 10535 Ike Ellis Ike Ellis has 17 years of experience with SQL Server. He's spoken at TechEd, written articles, given podcasts, and is a current Microsoft MVP. @ellisteam1 http://www.linkedin.com/in/ikeellis http://www.ellisteam.net https://api.twitter.com/1/users/profile_image?screen_name=@ellisteam1 48 48 8334 Janis Griffin Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database applications. Before coming to Confio, Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As a Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning. @DoBoutAnything http://www.linkedin.com/pub/janis-griffin/0/914/aba https://api.twitter.com/1/users/profile_image?screen_name=@DoBoutAnything 48 48 9916 Jason Horner Jason has been working with SQL Server since version 6.5 and currently hold's several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains. @jasonhorner http://www.linkedin.com/in/jasonhorner http://sqlgunslinger.blogspot.com/ https://api.twitter.com/1/users/profile_image?screen_name=@jasonhorner 48 48 9976 John Morehouse John 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. @sqlrus http://www.linkedin.com/in/sqlrus http://sqlrus.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlrus 48 48 10469 Jonathan Amen Jonathan Amen is a SQL Server Business Intelligence and DBA professional with over 7 years experience. Jon had been solving complex business questions for years before transitioning from the analyst to the developer side of the business intelligence equasion. Currently Jon is working at CoreLogic in Sacramento where his duties include both development and administration of an SSAS driven data warehouse, SSRS server and reports, many SSIS packages, as well as the common tasks of a DBA. http://www.linkedin.com/profile/view?id=39510773trk=tab_pro 48 48 9878 Kalen Delaney Please see bio from other session @sqlqueen http://www.sqlserverinternals.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlqueen 48 48 8219 Mark Gschwind Mark Gschwind is VP of Business Intelligence at DesignMind, a Microsoft Gold consulting partner based in San Francisco. He has been a BI Consultant since 1995, implementing Data Warehousing, OLAP, Reporting and Data Mining solutions to over 46 clients. He is an MCP and is certified in Oracle Essbase. He has presented MDS to other SQL Saturday events, as well as local PASS chapters. http://www.linkedin.com/pub/mark-gschwind/6/288/933 http://www.designmind.com/ 48 48 9415 Meredith Ryan Meredith Ryan-Smith has more than 10 years experience in IT with responsibilities ranging from ‘manning’ the help desk to VMS-VAX cluster administration. Most recently she has served as the senior production database administrator for The Bell Group, a supplier to the jewelry industry. Within the PASS community she is the chapter leader for the Women in Technology Virtual Chapter, is on the board of the Albuquerque SQL Server User Group and has spoken at several SQL Saturdays. @coffegrl http://www.linkedin.com/profile/view?id=10839821trk=tab_pro https://api.twitter.com/1/users/profile_image?screen_name=@coffegrl 48 48 9025 Michael Fal Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his a Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion. @Mike_Fal http://www.linkedin.com/pub/michael-fal/13/b70/b97 http://www.mikefal.net https://api.twitter.com/1/users/profile_image?screen_name=@Mike_Fal 48 48 8921 Mitchell Bottel Mitchell Bottel is a senior database administrator and owner of Innovative IT Consulting. He has 11 years of IT experience, focusing on SQL Server for the last seven years with an emphasis on database administration and high availability solutions. He has authored blog posts on the SQLServerPerformance website and written White Papers on using Dynamic Management Views. @SacSQLDude http://mitchespitch.com/ https://api.twitter.com/1/users/profile_image?screen_name=@SacSQLDude 48 48 8329 Prakash Heda Prakash Heda works as Sr. DBA at Advent Software. His expertise includes Performance Tuning, Virtualization, High Availability, SAN and Windows Administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP; He is an active member of PASS, frequent presenter at user groups, SQL Saturdays, and other community events @prakashheda http://www.linkedin.com/in/prakashheda/ http://www.sqlfeatures.com/ https://api.twitter.com/1/users/profile_image?screen_name=@prakashheda 48 48 8260 Randy Knight Randy Knight (MCITP) has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He is currently the owner and Principal Consultant for SQL Solutions Group, a Utah-based SQL Server consultancy. He is a nationally known speaker and trainer, having presented at SQL Saturday, Code Camp, User Groups and the inaugural PASS SQLRally. @randy_knight http://www.linkedin.com/in/randyknight http://www.sqlsolutionsgroup.com/blog https://api.twitter.com/1/users/profile_image?screen_name=@randy_knight 48 48 10399 Slavik Markovich Slavik Markovich is VP and CTO for Database Security at McAfee and has over 20 years of experience in infrastructure, security and software development. Slavik co-founded Sentrigo, a developer of leading database security technology acquired by McAfee in April, 2011. Prior to co-founding Sentrigo, Slavik served as VP RD and Chief Architect at db@net, a leading IT architecture consultancy. Slavik is a regular speaker at industry conferences and a creator of several open-source tools. @slavikm http://www.slaviks-blog.com https://api.twitter.com/1/users/profile_image?screen_name=@slavikm 48 48 10185 Steve Jones Steve 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. @way0utwest http://www.linkedin.com/in/way0utwest https://api.twitter.com/1/users/profile_image?screen_name=@way0utwest 48 48 10387 Thomas Keller Tom Keller is an independent SQL and .Net consultant in the Sacramento area. He has worked with Microsoft SQL Server as an administrator, integrator and developer since 1995. He is a member of the PASS Sacramento Chapter (Sacramento SQL Server User Group), and holds a Bachelor of Electrical Engineering. @tomkeller02 http://www.linkedin.com/in/tomkellerconsulting http://www.tomkellerconsulting.com/ https://api.twitter.com/1/users/profile_image?screen_name=@tomkeller02 48 48 10818 Varun Singh Varun is a technologist who has written articles software for PC Quest, CHIP, and more. He created India's top online brands- TechTree Tech2. He has hosted tech shows on TV (CNBC TV18, CNN-IBN and ET Now). He led large Web Application Dev. teams as CTO at Network 18. He built the highly scalable infrastructure for IN.com, MoneyControl.com and more. His experience led him and his team to identify the challenges of databases and which ultimately led to the formation of ScaleArc. http://www.linkedin.com/in/varunsinghs http://www.scalearc.com/ 48 48 10805 WIT Panel WIT Panelists:Denise McInerney of Intuit, San Francisco, CA; Meredith Ryan of The Bell Group, Albuquerque, NM; Janis Griffin of Confio Software, Boulder, CO; Helen Norris of Cal State Sacramento, CA; Kalen Delaney, SQL Server MVP, Author, Editor, Pacific Northwest @denisemc06 http://wit.sqlpass.org/ https://api.twitter.com/1/users/profile_image?screen_name=@denisemc06 48 48 8219 8219 Mark Gschwind BI Track Magnolia Room A recent survey by Information Week found that data qality is the greatest barrier to BI adoption in enterprises. MDS addresses this challenge with modelling, validation, alerting and security capabilities. In this presentation, you will learn how to configure MDS to model your data to ensure correctness, update it with changes from your ERP, and alert users to data conditions that require attention. You will get tips on best practices and on how to engage uses with an MDM project. By learning this tool, and its new features in 2012, BI professionals will gain a valuable new skill that addresses the greatest risk to success for BI projects - data quality. 7/28/2012 4:00:00 PM 7/28/2012 5:00:00 PM 8260 8260 Randy Knight SQL Dev Track Azalea Room If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why 'SQL that works' is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that 'worked great in dev' but caused major issues when it hit production. 7/28/2012 4:00:00 PM 7/28/2012 5:00:00 PM 8329 8329 Prakash Heda DBA Track Camellia Room This session will demo some of the key high availability features of SQL 2012 in action... What is SQL Server AlwaysOn What is AlwaysOn Availability Group FCI AlwaysON VS WSFC SQL Cluster Live Demo of: Configure 3 node always on FCI instance Configure Availability Groups with Always ON dashboard Automatic manual failover using Virtual Name Readable secondaries Taking backups from secondaries 7/28/2012 1:30:00 PM 7/28/2012 2:30:00 PM 8334 8334 Janis Griffin Misc Track Gardenia Room SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies. 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 8680 8680 Harry Chandra DBA Track Camellia Room In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. What are the parts and modes of database mirroring. You will also be introduce to log shipping and how it works. We will have a demo part of the session where we will go through every step of how to set up mirroring and log shipping. By the end of this session, you should have a general understanding and ability to deploy database mirroring and log shipping to meet your High Availability and Disaster Recovery requirement. 7/28/2012 4:00:00 PM 7/28/2012 5:00:00 PM 8798 8798 Angel Abundez BI Track Magnolia Room Today's executives and information workers want to use mobile devices to get at their business information, make critical decisions, and thrive. Let's help them get there with SQL Server Reporting Services and SharePoint. Tablets are common place now, and smart phones have been in place for years, but have we devoted enough attention to make effective use of the new form factors? Let's discuss how our design approach changes when we want to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We'll look at iPad and other mobile devices, SSRS and SharePoint, BI Developer and Business User, with emphasis on data visualization best practices. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 8921 8921 Mitchell Bottel Misc Track Gardenia Room In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment. 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 9025 9025 Michael Fal Misc Track Gardenia Room When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases. 7/28/2012 1:30:00 PM 7/28/2012 2:30:00 PM 9261 9261 Michael Fal DBA Track Camellia Room Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 9286 9286 Eric Freeman SQL Dev Track Azalea Room Do you ever find yourself frustrated writing query, after query, after query? In this session we will go over two fairly simple methods to write fast(er) and reliable T-SQL code. What is macro scripting? Come find out how you can spend a little bit of time today and how it can save you a lot of time in the future. We will also go 'over' some of the new features in SQL 2012 window functions and how to save time using them. Yes, there will be a live demo. 7/28/2012 1:30:00 PM 7/28/2012 2:30:00 PM 9392 9392 Helen Norris Misc Track Gardenia Room From Geek to Grand poo-bah: how technical folks can move into management. This session will discuss how a technical professional can prepare him or herself to move into the management ranks. 7/28/2012 2:45:00 PM 7/28/2012 3:45:00 PM 9415 9415 Meredith Ryan DBA Track Camellia Room Let's cover the basics of setting up and monitoring SQL server Replication. I will focus on configuring transactional replication including options for the distributor, and where to run your log reader agents - but rest assured we will touch on merge and snapshot replication as well. 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 9803 9803 Denise McInerney SQL Dev Track Azalea Room Incorrect, inaccurate and misleading data can get into a database in a variety of ways. It causes bugs, impacts customers and hurts business. This session will explain how DBAs and developers can proactively ensure the data coming into a transactional system is clean and correct. The topics covered will include table design, the pitfalls of NULL, “garbage in”, transactions, change management, and coding standards. The presentation will draw on the speaker's years of personal experience managing busy e-commerce databases supporting multi-million dollar businesses. The speaker will use real-life examples and demos to illustrate the many ways that OLTP data quality can be compromised. 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 9878 9878 Kalen Delaney DBA Track Camellia Room Many experienced DBAs are aware that there are many undocumented commands and traceflags in SQL Server, and some DBAs may even keep track of all references to such options whenever they read about them in an article or blog posts, or hear about them at a conference. In this session, I’ll not only tell you about some of my favorite undocumented features, I’ll also tell you some of my tricks for discovering more undocumented secrets. 7/28/2012 2:45:00 PM 7/28/2012 3:45:00 PM 9916 9916 Jason Horner SQL Dev Track Azalea Room this session is a whirlwind tour of the spatial features introduced in Sql Server 2008. We will cover the basics of working with spatial data including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 9976 9976 John Morehouse Misc Track Gardenia Room 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. 7/28/2012 4:00:00 PM 7/28/2012 5:00:00 PM 10185 10185 Steve Jones DBA Track Camellia Room There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion. 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 10387 10387 Thomas Keller SQL Dev Track Azalea Room How do you find information that was saved misspelled, or when your search is misspelled? Fuzzy-string processing! And if your information is in a database, the best place to do that processing is in the database. But there are some performance lessons to learn along the way. This session graphically illustrates the Damerau-Levenshtein Distance algorithm, and explains how it was optimized for T-SQL, using www.fuzzy-string.com and Confio Ignite. 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 10399 10399 Slavik Markovich SQL Dev Track Azalea Room SQL injection remains one of the most widely-used tactics used by hackers to exploit security vulnerabilities of databases in order to get at sensitive information or to gain further system access to wreak havoc with more attacks. Though the majority of SQL injections are fairly simple and familiar, the more advanced ones can evade detection by some conventional security measures. I will offer up an in-depth analysis of some sophisticated SQL injection hacks and attacks, and offer up some best practices on how to harden your applications and databases against them in order to keep business-critical information safe. 7/28/2012 2:45:00 PM 7/28/2012 3:45:00 PM 10469 10469 Jonathan Amen BI Track Magnolia Room Practical tips and tricks to solve every day Reporting Services administration and development issues. Real world administration questions / issues along with real world scripts and solutions. Typical development issues with simple answers. 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 10534 10534 Carlos Bossy Misc Track Gardenia Room SQL Server 2012 has made it easier to make the move to Business Intelligence and in this session Carlos Bossy will present three new features you can (and should) implement immediately. The new Analytics functions in T-SQL, Columnstore indexes, and the Tabular model are powerful features that will give your users the ability to analyze data in a faster, more effective manner. Each of these features was targeted at casual or beginning BI developers and DBAs who more familiar with traditional relational database models. You will leave this session with a good understanding of the next steps to take to get on the fast-track to BI. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 10535 10535 Ike Ellis BI Track Magnolia Room This is a 100-level session, filled with tips and tricks to make you a better DBA and database developer. We'll talk about everything from using automated tools, to common table expressions, and windowing functions. Come learn from MVP Ike Ellis about easy things you can do to be a better DBA. 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 10537 10537 Carlos Bossy BI Track Magnolia Room Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way an organization functions. In this non-technical session Carlos Bossy will discuss the components of a BI project, including the data warehouse, reporting and analysis, predictive models, and the promise of Big Data. He will show how to determine its measures of succes and ROI, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI Analytics Strategy so that you leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions. 7/28/2012 2:45:00 PM 7/28/2012 3:45:00 PM 10538 10538 Benjamin Nevarez BI Track Magnolia Room This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach. 7/28/2012 1:30:00 PM 7/28/2012 2:30:00 PM 10602 10602 Eric Freeman DBA Track Camellia Room Raffle- Main Lobby 7/28/2012 5:00:00 PM 7/28/2012 7:00:00 PM 10602 10602 Eric Freeman BI Track Magnolia Room Raffle- Main Lobby 7/28/2012 5:00:00 PM 7/28/2012 7:00:00 PM 10602 10602 Eric Freeman SQL Dev Track Azalea Room Raffle- Main Lobby 7/28/2012 5:00:00 PM 7/28/2012 7:00:00 PM 10602 10602 Eric Freeman Misc Track Gardenia Room Raffle- Main Lobby 7/28/2012 5:00:00 PM 7/28/2012 7:00:00 PM 10603 10603 Eric Freeman DBA Track Camellia Room After Party- Chevy's on the River 1369 Garden Hwy Sacramento, CA 95833 7/28/2012 7:00:00 PM 7/28/2012 10:00:00 PM 10603 10603 Eric Freeman BI Track Magnolia Room After Party- Chevy's on the River 1369 Garden Hwy Sacramento, CA 95833 7/28/2012 7:00:00 PM 7/28/2012 10:00:00 PM 10603 10603 Eric Freeman SQL Dev Track Azalea Room After Party- Chevy's on the River 1369 Garden Hwy Sacramento, CA 95833 7/28/2012 7:00:00 PM 7/28/2012 10:00:00 PM 10603 10603 Eric Freeman Misc Track Gardenia Room After Party- Chevy's on the River 1369 Garden Hwy Sacramento, CA 95833 7/28/2012 7:00:00 PM 7/28/2012 10:00:00 PM 10604 10604 Eric Freeman DBA Track Camellia Room Lunch- Main Lobby 7/28/2012 12:00:00 PM 7/28/2012 1:30:00 PM 10604 10604 Eric Freeman BI Track Magnolia Room Lunch- Main Lobby 7/28/2012 12:00:00 PM 7/28/2012 1:30:00 PM 10604 10604 Eric Freeman SQL Dev Track Azalea Room Lunch- Main Lobby 7/28/2012 12:00:00 PM 7/28/2012 1:30:00 PM 10604 10604 Eric Freeman Misc Track Gardenia Room Lunch- Main Lobby 7/28/2012 12:00:00 PM 7/28/2012 1:30:00 PM 10605 10605 Eric Freeman DBA Track Camellia Room Registration- Hotel Entrance 7/28/2012 7:30:00 AM 7/28/2012 8:00:00 AM 10605 10605 Eric Freeman BI Track Magnolia Room Registration- Hotel Entrance 7/28/2012 7:30:00 AM 7/28/2012 8:00:00 AM 10605 10605 Eric Freeman SQL Dev Track Azalea Room Registration- Hotel Entrance 7/28/2012 7:30:00 AM 7/28/2012 8:00:00 AM 10605 10605 Eric Freeman Misc Track Gardenia Room Registration- Hotel Entrance 7/28/2012 7:30:00 AM 7/28/2012 8:00:00 AM 10606 10606 Eric Freeman DBA Track Camellia Room Morning Coffee Break 7/28/2012 8:00:00 AM 7/28/2012 8:30:00 AM 10606 10606 Eric Freeman BI Track Magnolia Room Morning Coffee Break 7/28/2012 8:00:00 AM 7/28/2012 8:30:00 AM 10606 10606 Eric Freeman SQL Dev Track Azalea Room Morning Coffee Break 7/28/2012 8:00:00 AM 7/28/2012 8:30:00 AM 10606 10606 Eric Freeman Misc Track Gardenia Room Morning Coffee Break 7/28/2012 8:00:00 AM 7/28/2012 8:30:00 AM 10805 10805 WIT Panel DBA Track Camellia Room Everyone has heard that the number of women in science, technology, engineering and math (STEM) is declining. Some academic institutions and industry leaders are working to change that trend. How each of us, women and men, encourage more young women to consider a career in technology? What are the most effective ways to counteract the declining numbers of women in technical fields?Hear from a panel of speakers as they share their perspective and bring your own questions and ideas. 7/28/2012 12:15:00 PM 7/28/2012 1:15:00 PM 10818 10818 Varun Singh BI Track Magnolia Room Achieving scale-out quickly and easily for MS SQL Server environments can be extremely difficult, if not impossible. Other areas that are difficult or costly to achieve for SQL Server environments include transparent caching of Read queries, as well as instrumentation and Analytics of all SQL queries in *real-time*. In this session, you will learn how ScaleArc has developed SQL Server infrastructure software that achieves instant scale-out, caching, load balancing, firewall/filtering and higher availability…without any changes or modifications to existing applications or SQL Server databases. For those interested in migrating to SQL Server 2012, we will also discuss how ScaleArc can assist and add-value in a 2012 migration. 7/28/2012 12:15:00 PM 7/28/2012 1:15:00 PM