SQLSaturday #201 - Orange County, CA 20134/20/2013 12:00:00 AM(GMT-08:00) Pacific Time (US and Canada); TijuanaSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat201Goldenwest College15744 Golden West StreetHuntington BeachCA926472916Red Gate Softwarehttp://redg.at/VBD5XWhttp://www.red-gate.com/assets/images/common/logo.png601702942Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601703026Dell Software Grouphttp://www.quest.com/http://i.imgur.com/BAdC3.png601703075QuickStart Intelligencehttps://www.quickstart.comhttp://www.quickstart.com/images/logo.png601703211Violin Memoryhttp://www.vmem.comhttp://www.sqlsaturday.com/files/c7cff1d7-3156-4eac-8939-2ba76a756afc.jpg601703263Melissa Datahttp://www.melissadata.comhttp://www.melissadata.com/images/mdlogo-color-tag-170x60.gif601703295Precise Softwarehttp://www.precise.comhttp://media.marketwire.com/attachments/200809/467269_precise_logo_doc.jpg601702868PASS Headquartershttps://www.sqlpass.orghttp://www.sqlsaturday.com/images/pass_logo_partner_bw.jpg601703322Goldenwest Collegehttp://www.goldenwestcollege.edu/http://farm9.staticflickr.com/8255/8628080091_b6537a44fe_m.jpg601703323Microsoft Corporationhttp://www.microsoft.comhttp://farm9.staticflickr.com/8242/8628047879_1451821d5c_m.jpg601703285Firm Solutions Inchttp://firmsolutionsinc.com/index.htmlhttp://firmsolutionsinc.com/images/firmsolutions.gif401003379Violin Memoryhttp://www.vmem.comhttp://www.sqlsaturday.com/files/c7cff1d7-3156-4eac-8939-2ba76a756afc.jpg6017014781Andrew KarcherAndrew is a former 4-Time SQL Server MVP covering the entire Business Intelligence stack, Application Development, and Architecture of database systems. He serves the community in multiple ways: SQL Saturday Lead Organizer, President – San Diego .Net User Group, Board Member – San Diego SQL Server Users Group. He has presented at multiple Users Groups, SQL Saturdays, Code Camps and conferences such as SQL Pass.@akarcherhttp://www.linkedin.com/in/andrewkarcherhttp://www.andrewkarcher.comhttps://api.twitter.com/1/users/profile_image?screen_name=@akarcher484814174Ben AminniaBen Aminnia is a database architect / .NET developer / consultant at Pointer Corporation with over 20 years of experience in developing database systems and managing a team of SQL Server developers and DBAs. He's also the president of Los Angeles SQL Server Professionals Group and the architect of Virtual Information Portal (VIP) System. http://www.linkedin.com http://www.pointercorp.com484812515Benjamin NevarezBenjamin 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@BenjaminNevarezhttp://www.benjaminnevarez.com/https://api.twitter.com/1/users/profile_image?screen_name=@BenjaminNevarez484814012Brent GreenwoodBrent Greenwood, MS, MCITP, CBIP is a PowerPivot junkie and long-time Microsoft BI Pro with 13+ years of experience in the data analysis, data warehousing and business intelligence crafts. He's delivered solutions and worn lots of different hats in a variety of verticals including Investment Management, Brokerage, Insurance Services, Healthcare, and Higher Education. And most importantly, he's a cycling fan who loves riding and building prototypes with AdventureWorks cycling data.
http://www.linkedin.com/in/brentgreenwoodhttp://brentgreenwood.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=484813811Carlos BossyCarlos Bossy (MCTS, MCP SQL Server 2008 BI, CBIP) is a Consultant with 25 years experience in software and database development. As the Principal of his company Carlos focuses on developing Business Intelligence solutions including modeling data warehouses, predictive analytics, integration and reporting. He has worked with SQL Server for 12 years and is very enthusiastic about its powerful features. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies.@carlosbossyhttp://www.linkedin/in/carlosbossyhttp://www.carlosbossy.comhttps://api.twitter.com/1/users/profile_image?screen_name=@carlosbossy484812795Christian WadeChristian Wade, creator of the BISM Normalizer, has been doing BI and solution architecture since SQL Server 7. He spoke at the PASS Community Summit in 2012 and 2005, the 2005 European PASS Conference, and other events including SQLSaturday. Christian is from the UK, but lives in California.http://christianwade.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=484812295David McCarterDavid McCarter is a Microsoft MVP and a principal software engineer/architect in San Diego. He is the editor-in-chief of dotNetTips.com... a web site dedicated to helping programmers in all aspects of programming. David has written for programming magazines and has published three books (the latest is 'David McCarter's .NET Coding Standards'). He is one of the founders and directors of the 19 year old San Diego .NET Developers Group (www.sddotnetdg.org)@davidmccarterhttp://www.linkedin.com/in/davidmccarterhttp://dotnettips.comhttps://api.twitter.com/1/users/profile_image?screen_name=@davidmccarter484813085Diana DeeDiana is a Microsoft Certified Trainer who has taught Microsoft courses to IT professionals and college students since 1996.
Diana has been a course developer throughout her computer teaching career. She has revised and developed database design, administration, and querying courses for an on-line University and for a major training company.
She had presented at SQL Saturdays #44, #73, #120, and #157.
@SQLDeehttps://api.twitter.com/1/users/profile_image?screen_name=@SQLDee484814187Dmitri KorotkevitchDmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master who is working with Microsoft SQL Server for more than 11 years. He specializes in architecture, design, development and performance tuning of OLTP systems and responsible for implementation of several database backends handling thousands of transactions per second around the clock. Dmitri has Master’s degree in Computer Science and also held MCPD certificate.http://aboutsqlserver.comhttps://api.twitter.com/1/users/profile_image?screen_name=484812617Glenn BerryGlenn Berry is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO. Glenn has been a SQL Server MVP since 2007, 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.@GlennAlanBerryhttp://www.linkedin.com/pub/glenn-berry/10/a61/6b8http://sqlserverperformance.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GlennAlanBerry484813878Ike EllisIke Ellis has over 17 years of experience in databases and is a current Microsoft MVP. Ike has been Microsoft certified since the beginning, currently holding an MCDBA, MCSE, MCSD, and MCT. He's spoken at TechEd, written articles and given podcasts alongside his many community contributions.@ellisteam1http://www.linkedin.com/in/ikeellishttp://www.the-monastery.comhttps://api.twitter.com/1/users/profile_image?screen_name=@ellisteam1484813958Janis GriffinJanis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Prior to Confio, Janis held DBA positions in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis was Principal Architect and Sr. Manager, mentoring other DBAs on best practices in database performance tuning.@DoBoutAnythinghttp://www.linkedin.com/pub/janis-griffin/0/914/abahttps://api.twitter.com/1/users/profile_image?screen_name=@DoBoutAnything484814019Jason HornerJason Horner has been working with SQL Server for over 10 years. He is
currently focused on a large scale Spatial Data Warehouse project. He
holds MCITP Certifications in both Database Administration and
Database Development.@Jason Hornerhttp://www.linkedin.com/pub/dir/Jason/Hornerhttps://api.twitter.com/1/users/profile_image?screen_name=@Jason Horner484813824Jeff RenzJeff Renz has been working in the IT industry for 14 years, the last 10 of which has been focused on designing and implementing data collection and reporting solutions. He is currently working as a senior consultant for Statera on the Business Intelligence Solutions team.
Certified by the Genesee Academy as a Certified Data Vault Data Modeler.
@jeff_renzhttp://www.linkedin.com/pub/jeff-renz/29/82a/aa4 http://www.statera.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jeff_renz484813312Joseph VertidoA Data Quality Analyst at Melissa Data, Joseph has worked with numerous clients in understanding their business needs for data quality, analyzing their architecture and environment, and recommending strategic solutions to successfully integrate data quality within their infrastructure. He gives frequent webinars for implementing different techniques for data quality and also manages the MVP Program – a network that provides resources to community leaders, speakers, consultants and other experts.@/melissadatahttp://www.linkedin.com/company/melissa-datahttp://blog.melissadata.com/data-quality-authority/https://api.twitter.com/1/users/profile_image?screen_name=@/melissadata484813951Julie KoesmarnoJulie Koesmarno is a BI Consultant at LobsterPot Solutions, with MCITP Database Administrator 2008, MCITP Database Developer 2008, and MCITP Business Intelligence 2008 qualifications. She has over 8 years of commercial experience in SQL Server for large-scale and multi-million-dollar OLTP and ETL projects. Her recent project includes SQL Server 2012 BI solution using Tabular Model. She has presented at PASS Summit, PASS BI/DW Virtual Chapter, SQLRally, 24 Hours of PASS, and SQLSaturday.@mssqlgirlhttp://au.linkedin.com/in/juliekoesmarnohttp://www.mssqlgirl.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mssqlgirl484812467Lynn LangitLynn is an expert on many types of data solutions - including SQL Server (both OLTP and OLAP), Hadoop, MongoDB and other NoSQL solutions. In 2012 Google awarded her as a 'Google Developer Expert' for her community education work around the Google Cloud. 10Gen added her to their list of 'MongoDB Masters' as well. Lynn does production work with SQL Server and many other NoSQL systems. She most often deploys using the AWS cloud.@lynnlangithttp://www.LynnLangit.comhttps://api.twitter.com/1/users/profile_image?screen_name=@lynnlangit484812643Mickey StueweMickey Stuewehttp://www.linkedin.com/in/brentgreenwoodhttp://wit.sqlpass.orghttps://api.twitter.com/1/users/profile_image?screen_name=484814026Phil RobinsonPhil Robinson is an independent consultant focused on developing Business Intelligence solutions using SQL Server tools. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQL Saturday – San Diego. He currently serves as a PASS `Regional Mentor for the Southwest Region.http://www.linkedin.com/in/sqldbdev https://api.twitter.com/1/users/profile_image?screen_name=484812613Robert HattonRob Hatton is past President of the Tampa Bay SQL Server Business Intelligence User Group. He's a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments. He's currently working with Convergence Consulting group, a Florida based organization focused on providing B.I. solutions.http://www.linkedin.com/pub/rob-hatton/45/4b8/3ab484814543Stacia MisnerStacia Misner has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft’s business intelligence technologies since 2000. She is a SQL Server MVP, SSAS Maestro, MCITP, MCTS, and has authored or co-authored multiple books and articles about Microsoft business intelligence technologies.@StaciaMisnerhttp://www.linkedin.com/in/staciamisner http://blog.datainspirations.comhttps://api.twitter.com/1/users/profile_image?screen_name=@StaciaMisner484815055Trent MeraTrent has worked for Quest Software (now part of Dell) for 7 years as a Systems Consultant with a focus on SQL Server. His prior experience is 7 years of SQL Server development in the Real Estate, Finance and Defense industries.484815056Violin MemorySpeaker Bio484814780Virginia MushkatblatVirginia Mushkatblat has 20 years of development and architectural experience with critical data-intensive applications. She has worked in companies ranging from start-ups to international conglomerates with the range of requirements, including those of 24/7 and batch processing, and lead teams of DB developers, architects and administrators. She has worked in entertainment, technology and financial industries. http://www.linkedin.com/in/virginiamushkatblathttp://www.firmsolutionsinc.com/48481228212282SQLSaturday 201Registration AreaLunch Break4/20/2013 12:30:00 PM4/20/2013 1:15:00 PM1228312283SQLSaturday 201Registration AreaRegistrations4/20/2013 8:00:00 AM4/20/2013 8:15:00 AM1228412284SQLSaturday 201Registration AreaRaffle4/20/2013 5:15:00 PM4/20/2013 5:30:00 PM1229512295David McCarterTech 100Rock Your Technical InterviewHave you ever not gotten a job due to not being prepared for the technical interview? I’ve have interviewed 100′s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. This session will include advice from engineers just like you that have recently landed a new job!
A DVD for this session (sponsored by TechTalent) will be available for only $10. Credit cards accepted.4/20/2013 2:45:00 PM4/20/2013 3:45:00 PM1246712467Lynn LangitForum 1AWS for the SQL Server ProIn this talk Lynn will share her real-world experience deploying solutions to the AWS cloud. She will focus on data solutions such as EC2 w/SQL Server, RDS w/SQL Server and more. Her talk will include coverage of NoSQL offerings such as Glacier, S3 and DynamoDB. She will also cover the new RedShift service. Attend this talk to learn which services to use and tips for usage in the real world.4/20/2013 2:45:00 PM4/20/2013 3:45:00 PM1251512515Benjamin NevarezForum 1Dive into the Query Optimizer-Undocumented InsightThis 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.4/20/2013 1:30:00 PM4/20/2013 2:30:00 PM1251612516Benjamin NevarezTech 100Understanding Parameter SniffingParameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.4/20/2013 4:00:00 PM4/20/2013 5:00:00 PM1261312613Robert HattonTech 101Designing for Analysis: Facts and DimensionsThis session will focus on patterns and practices that are successful in designing Data Warehouse and Business Intelligence solutions. Designing an analytic database is different from designing a transactional database. This presentation will provide thorough coverage into the foundation of analytic database design: Facts and Dimensions. We'll also discuss the Star and Snowflake schema, dimension hierarchies, multiple calendar dimensions and how all of this fits with the query and reporting tools used to actually present information. 4/20/2013 8:30:00 AM4/20/2013 9:30:00 AM1261412614Robert HattonTech 116The server side of Reporting ServicesThis session will cover important information about how to set up Reporting Services. We'll go beyond the simple installation and configuration issues. Covered topics will include shared data sources, managing the folder structure, using linked reports, and the management user interfaces. We'll also cover the database that Reporting Services uses to house report definitions.4/20/2013 11:00:00 AM4/20/2013 12:00:00 PM1261712617Glenn BerryForum 1Hardware 201: Selecting Database HardwareThe foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.4/20/2013 9:45:00 AM4/20/2013 10:45:00 AM1261912619Glenn BerryForum 1Dr. DMV: How to Use Dynamic Management ViewsSQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to SQL Server 2005 through 2012), presents and explains over fifty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.
4/20/2013 8:30:00 AM4/20/2013 9:30:00 AM1264312643Mickey StueweTech 116Tablix - The Rubik Cube of Reporting ServicesDid you know that the Table, Matrix, and List controls are all based on the highly flexible Tablix Data Region Grid? So really, they are all one control that can be morphed into each other.
Learn how to get the most out of the Tablix controls in this demo-heavy session. We'll go through how to best layout data using multiple Tablix controls. We’ll use parameters to change the layout of the data in these controls to minimize the number of reports that need to be maintained. We’ll create a columnar report that grows vertically as well as horizontally, and we’ll find out about other exciting uses of this highly flexible control.4/20/2013 2:45:00 PM4/20/2013 3:45:00 PM1279512795Christian WadeMath 118MDX vs. DAX: Currency ConversionCompare and contrast how multidimensional and tabular achieve the same end result in quite different ways. Learn where multidimensional decorates the metadata of the model, while tabular offloads responsibility to DAX. Understand how the design goals of the DAX language – which are akin to Excel formulas and relational-database concepts – differ from MDX and traditional OLAP. Features covered can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal.4/20/2013 11:00:00 AM4/20/2013 12:00:00 PM1308513085Diana DeeTech 101Thanks for the MemoryMemory is a vital resource for SQL Server. Use of memory by SQL Server is a huge topic.
This talk is designed to give you enough knowledge to get you started on your journey to mastering this topic.
The talk will describe:
• How SQL Server uses memory
• How you can tell whether memory is being well-managed on your system
• What you can control
4/20/2013 9:45:00 AM4/20/2013 10:45:00 AM1331213312Joseph VertidoTech 101Data Quality Services Approach to Cleansing Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project. What really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit.4/20/2013 2:45:00 PM4/20/2013 3:45:00 PM1381113811Carlos BossyMath 118Enterprise Tabular ModelsTabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you'll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you'll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel, SSRS and other reporting tools.4/20/2013 8:30:00 AM4/20/2013 9:30:00 AM1381513815Carlos BossyMath 118Predictive Modeling with SQL Server Data MiningThis session will show you how to solve a real-world data mining problem by demonstrating the entire development life cycle of a predictive model. Attendees will learn the essentials required to harness the power of a decision tree algorithm to develop and optimize a production ready predictive model. Carlos will also show how to iterate through the process to improve the model’s effectiveness. Finally, you will see show how to make the most of a predictive model by deploying it and utilizing in your applications and reports.4/20/2013 4:00:00 PM4/20/2013 5:00:00 PM1382413824Jeff RenzTech 101Data Vault Data Warehouse ArchitectureData vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.4/20/2013 11:00:00 AM4/20/2013 12:00:00 PM1387813878Ike EllisTech 11610 Reporting Tips and TricksThis session will show you 10 tricks from the easy to the difficult. We'll have a new tip every six minutes and every tip will have a demo. Some of the tips you might know, some you might not. Come with your own tips and share with the rest of us. Let's make a memorable session filled with things we can immediately use in our reporting lives!4/20/2013 1:30:00 PM4/20/2013 2:30:00 PM1387913879Ike EllisForum 1Continuous Integration, Continuous Deployment, andWhen a developer goes it alone and works on their own feature of a product, there is always a chance that the feature will never be folded back into the main product, thus never released, effectively wasting that developer’s time. Continuous Integration means every time a developer writes code, that code is folded back into the main project and tested with all the other code. Continuous Integration means no developer is left behind. Come to this session to learn how you can make sure all the code your developers have written is used, is effective, and works with all the other code being written. Come learn how to deploy software faster, with higher quality, and with fewer database problems!4/20/2013 4:00:00 PM4/20/2013 5:00:00 PM1395113951Julie KoesmarnoTech 116From Impaired To Insightful Geospatial ReportingIt is expected that business reports be insightful and engaging. Region based reporting can be transformed from boring grids to visually interactive maps. This session will describe how to embark upon self-service and mobile BI solutions that are available within the Microsoft BI stack for analytical geospatial reporting. You will learn the basics of geographical data, including GIS, Longitude-Latitude coordinates and free form text. Using these different data types, we will discuss SSRS 2012, Power View and Excel 2013 tools that can leverage insightful analysis. Finally and most importantly, attending this talk will get you started in learning the essential techniques to deliver geospatial reports that tell meaningful stories for users.4/20/2013 8:30:00 AM4/20/2013 9:30:00 AM1395813958Janis GriffinForum 1Extend Your Knowledge with Extended Events!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.
4/20/2013 11:00:00 AM4/20/2013 12:00:00 PM1395913959Janis GriffinTech 100Looney Tuner? No, there IS a method to my madnessSQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.4/20/2013 1:30:00 PM4/20/2013 2:30:00 PM1401214012Brent GreenwoodTech 101Lean BI Solutions w PowerPivot, Tabular a MulletBusiness in the front. Party in the Back. The Mullet strikes a nice balance between 'Classy' 'Outlaw'. By applying this model to BI, we'll uncover ways to deliver solutions faster more efficiently through Lean practices. This session is for anyone who needs to satisfy demanding customers that aren't quite sure what they want, but they need it NOW or they'll lose that critical deal the world will end! We'll focus on sequencing deliverables and using PowerPivot prototypes that can be promoted to an AS Tabular model if/when needed. This process aims to minimize rework while striking a balance between delivering value fast with initial 'Cowboy' efforts, and incrementally building a responsible, scalable, maintainable architecture. 4/20/2013 4:00:00 PM4/20/2013 5:00:00 PM1401914019Jason HornerMath 118Dimension Modeling Design Patterns: Beyond BasicsThis session will provide a deeper dive into the art of dimensional
modeling. We will look at the different types of fact tables and
dimension tables, how and when to use them. We will also some
approaches to creating rich hierarchies that make reporting a snap.
This session promises to be very interactive and engaging, bring your
toughest Dimensional Modeling quandaries.4/20/2013 1:30:00 PM4/20/2013 2:30:00 PM1402614026Phil RobinsonTech 116Report Delivery - From Report Manager to the CloudSQL Server Reporting Services Report Manager provides a great web platform for managing and delivering many types of reports. We will review delivering reports with Report Manager and explore integrating SSRS as the engine for report presentation within web and windows applications. We will also look at options to feed reports to your document management system and push reports to the cloud for remote access and mobile devices.4/20/2013 4:00:00 PM4/20/2013 5:00:00 PM1417414174Ben AminniaTech 100SQL Azure vs. Amazon RDS - An In-Depth ComparisonThis is my diary of two adventurous roads I traveled for exploring the new world of database options in the cloud, from different viewpoints for IT Managers, DBAs, and Database Developers. It includes my notes from successful DB implementations in SQL Azure and Amazon RDS. 4/20/2013 11:00:00 AM4/20/2013 12:00:00 PM1418714187Dmitri KorotkevitchTech 100'It's MINE' - Intro into locking in SQL ServerIn this session Dmitri talks about locking in Microsoft SQL Server. He covers various lock types that exist in the product and explains how transaction isolation levels affect locking behavior. Dmitri also discusses why we have blocking in the systems and how to troubleshoot blocking problems and deadlocks.
This is PowerPoint-free session. Only Management Studio, T-SQL Code and bag of candies are in use.
4/20/2013 8:30:00 AM4/20/2013 9:30:00 AM1418814188Dmitri KorotkevitchTech 100Data Partitioning in VLDBSupport of the large databases is not a trivial task. Large amount of data negatively impacts system performance and make administration and SLA compliance much more complicated. Data partitioning can help to solve those problems and reduce support and hardware cost. This session demonstrates various approaches of data partitioning available in SQL Server. It compares pros and cons of different partitioning techniques from performance, scalability and administration standpoints. The session also discusses how to reduce hardware cost by implementing tiered storage and demonstrates how to move data between filegroups and/or disk arrays keeping the system online in the different versions and editions of SQL Server. 4/20/2013 9:45:00 AM4/20/2013 10:45:00 AM1454314543Stacia MisnerMath 118Taking BI to the Next Level: CollaborationSelf-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration.4/20/2013 2:45:00 PM4/20/2013 3:45:00 PM1454414544Stacia MisnerMath 118A Big Data PrimerThe term 'big data' dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.4/20/2013 9:45:00 AM4/20/2013 10:45:00 AM1477914779Mickey StueweForum 1WIT Panel - Women In TechnologyWith the importance of STEM centric jobs increasing, how can we inspire our youth to take a more active interest in their STEM related education? Join Mickey Stuewe as she speaks with a panel of professionals and STEM advocates to discuss ways to motivate our youth to be excited about Science, Technology, Engineering, and Mathematics (STEM).4/20/2013 12:30:00 PM4/20/2013 1:15:00 PM1478014780Virginia MushkatblatTech 101Data Flow Architectures in Software Development Life-CycleThe presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.4/20/2013 1:30:00 PM4/20/2013 2:30:00 PM1478114781Andrew KarcherTech 116SQL 2012 Programmability EnhancementsWith SQL 2012 comes a slew of enhancements on the Programmability side. This session will explore some of those new features such as Analytic Functions, Over Clause (Window Functions), Date Functions, Conversion Functions, Sequence Objects, Paging and FileTables to name just a few. If you want to get a jump on those features you will be seeing in SQL 2012 this is the session for you.4/20/2013 9:45:00 AM4/20/2013 10:45:00 AM1505015050Janis GriffinTech 100Advanced Performance Tuning Tips with Confio’s IgniteAre you struggling with performance issues and your current tools are not providing answers? Confio’s flagship product, Ignite, may be your answer. This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. Janis will use real-life case studies to demonstrate the techniques.4/20/2013 12:30:00 PM4/20/2013 1:15:00 PM1505515055Trent MeraTech 116Visibility into server workload to the statement level with Dell's Foglight Performance Analysis forThis presentation will be a quick walkthrough of Dell's Foglight Performance Analysis for SQL Server. This tool allows the DBA to see fine-grained as well as long-term SQL Server workload analytics, with details to the level of statements, users, applications, and more.4/20/2013 12:30:00 PM4/20/2013 1:15:00 PM1505615056Violin MemoryTech 101Violin Memory Lunch SessionViolin Memory Lunch Session4/20/2013 12:30:00 PM4/20/2013 1:15:00 PM