SQLSaturday #193 - Phoenix 2013 4/27/2013 12:00:00 AM (GMT-07:00) Arizona SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat193 Chandler-Gilbert Community College Pecos Campus 2626 East Pecos Road Chandler AZ 85225 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 3181 Delphix Gold Sponsor http://www.delphix.com http://www.sqlsaturday.com/files/eb089f19-583e-48e8-a15f-4a97da02fdd0.jpg 60 170 3214 Neudesic Gold Sponsor http://www.neudesic.com http://www.sqlsaturday.com/files/d07d6dfe-c1b8-4be8-9615-ada0c3428110.jpg 60 170 3215 Business Decision Gold Sponsor http://www.businessdecision.us http://www.businessdecision.us/uploads/Image/65/4375_449_BD-Logo-SQL-Saturday.jpg 60 170 3355 Statera Gold Sponsor http://www.statera.com http://www.sqlsaturday.com/files/f214cda2-d4c1-4563-b1ac-7f5317eb31f0.jpg 60 170 3368 Chandler Gilbert Community College Gold Sponsor http://www.cgc.maricopa.edu/Pages/Default.aspx http://www.sqlsaturday.com/files/0e701366-ed54-4f08-9470-ec2fcfb6f806.png 60 170 2900 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2917 Red Gate Software Silver Sponsor http://redg.at/11bDJ4y http://www.red-gate.com/assets/images/common/logo.png 60 170 3027 Dell Software Group Silver Sponsor http://www.quest.com/ http://i.imgur.com/BAdC3.png 60 170 3160 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 3168 Xtivia, Inc Silver Sponsor http://www.xtivia.com/ http://www.xtivia.com/images/XtiviaLogo-170x60.jpg 60 170 3292 GoDaddy.com Silver Sponsor http://www.godaddy.com/ http://www.sqlsaturday.com/files/0737ddd5-aef8-4306-ad32-b5a3b05707ae.jpg 60 170 3325 Idera Silver Sponsor http://www.idera.com http://www.sqlsaturday.com/files/e093d75e-8cbb-47b4-aab5-f11c45bdd6a9.jpg.png 60 170 3331 Fusion-io Silver Sponsor https://www.fusionio.com http://www.sqlsaturday.com/files/1b7abb60-7950-446d-a904-27d4aed8b23a.png 60 170 2970 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3239 Sql Power Tools, Inc. Bronze Sponsor http://www.sqlpower.com http://www.sqlpower.com/img/spt_logo_sql_saturday.png 60 170 3283 Fuller Solutions Bronze Sponsor http://www.fuller-solutions.com http://www.sqlsaturday.com/files/a23ba43a-8337-4ad0-ad24-3fdf2b021c66.jpg 60 170 3382 Interface Technical Training Bronze Sponsor http://www.interfacett.com/ https://dl.dropboxusercontent.com/u/27987416/InterfaceTT_170x60.png 60 170 12088 Joseph Vertido APP DEV IRN 123 The spectrum of Contact Data Quality covers numerous interrelated aspects such as parsing, standardization, correction, verification, enrichment and matching. But one crucial concept that is quite commonly overlooked in the field of data quality is the implementation of an intelligent and automatable process for the creation of the “golden record” through the consolidation of data within the matching process; a technique also known as Survivorship 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 12092 Scott Klein Azure Big Data Prof Dev IRN 131 You have migrated your SQL Server database to Windows Azure SQL Database (AKA SQL Azure), and you have migrated your application to Windows Azure. Now what? As the load on your database begins to increase, the need to scale your new SQL Database instance becomes a realization. In this demo-filled session we'll explore SQL Federation, Microsoft's solution for cloud database scalability. This session will look at the scalability model for the cloud and how SQL Federation solves the scale-out issue. We'll look at the architecture of SQL Federation and you can apply SQL Federation to your cloud database solution. 4/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 12226 Dave Pettengill Azure Big Data Prof Dev IRN 131 This session discusses how we can deliver a better BI product if we learn to better communicate with the business user and get then to think differently about data and about their needs. Attendees will gain an understanding of how to initiate conversations and begin a process of increasing the quality of user requirements. They will also learn how to start and develop this process to get user buy in. The end goal is to fully utilize BI capabilities to reduce costs, improve performance or identify new business opportunities. 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 12377 Stacia Misner Azure Big Data Prof Dev IRN 131 The 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/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 12378 Stacia Misner BIA / BID IRN 219 Self-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/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 12429 Brian Flynn APP DEV / DBA IRN 125 Have you ever been wrought with end user complaints of database performance issues only to open your tools that show only live performance or limited historical performance and find no answers? After being bit by this many times, I developed my own eye in the sky to monitor CPU Physical IO at the database, user and application levels. This solution logs data continuously and parses it into an Analysis Services cube which can be queried by Excel. No need to requisition funds for 3rd party tools. You can do this with the tools you have and I’ll give you the scripts to get started. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels. 4/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 12533 Shannon Lowder Azure Big Data Prof Dev IRN 131 During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 12534 Kathy Gibbs DBA IRN 120 SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data. 4/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 12535 Kathy Gibbs BIA / DBA IRN 129 With 2012 Extended Events became much easier to use and is a great way to find out more of what is going on in the database. This presentation will show how you can use Extended Events to find out about items like Deadlocks and Query Performance. We will create a new Event and I will show you how you can use the data collected to report commonly monitored statistics. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 12588 Ryan McCauley DBA/BIA SC140-144 Have you ever seen an execution plan and been totally lost as to what it means or what you can learn from it? We'll cover the basics of execution plans - how the SQL Server assembles the query, different types of joins, and why the query engine makes those decisions. We'll also look at common reasons why the query optimizer can make less-than-optimal decisions, and how you can improve the query layout or the the object metadata to help improve the execution plan and speed up the results. 4/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 12686 Dave Pettengill DBA IRN 120 Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, with all of the performance that you enjoy today, and Dave Pettengill will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments. Practical tips, tricks, and gotchas for designing for performance will be discussed in this session. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 12699 Jeff Renz DBA/BIA SC140-144 Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server. 4/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 12700 Jeff Renz BIA IRN 126 Data 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/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 12789 Scott Klein Azure Big Data Prof Dev IRN 131 As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master. 4/27/2013 4:00:00 PM 4/27/2013 5:00:00 PM 13040 Vern Rabe APP DEV / DBA IRN 125 It's an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goals in this presentation are to show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for proper usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of imappropriate data types or improper usage of them. In addition, I will cover serveral data type related functions and point out caveates in their usage. 4/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 13041 Vern Rabe BIA / DBA IRN 129 One of the new features of SQL Server 2012 is columnstore indexes, where the storage of index data is “turned on its head”. We will look into how this feature is implemented internally, how it can greatly improve query performance in the right environment, what the current limitations are, and how to implement workarounds for those limitations. 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 13373 Joseph Vertido APP DEV IRN 123 This session will focus on the differences in address format and structure around the world and how that can place in the effective storage of 'useful' address data within the Enterprise. In addition, we’ll discuss how address data is 'mangled' to be stored and how it can impact the overall quality level of any tool used for address validation and correction internationally. With 240+ countries and territories around the world, this is not a small consideration. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 13425 Paul Turley BID IRN 128 When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models. 4/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 13427 Paul Turley BID IRN 128 Amp up Reporting Services and tale your business reports to the next level with custom code written in Visual Studio. Build one dynamic super report to replace several other reports and address business requirements more effectively. Dynamically add or remove query columns, modify groups and sorting options. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 13698 Nate Locklin BID IRN 128 Will you know where to go when the zombie apocalypse begins? This presentation will offer a fun tutorial for using maps in SQL Server 2012 Reporting Services reports. Sample applications and use of ESRI shapefiles will be included in the demonstration. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 13714 Josh Sivey BID IRN 128 In SSRS, a rendering extension is a component or module of a report server that transforms report data and layout information into a device-specific format. Out of the box, SSRS includes seven rendering extensions: HTML, Excel, Word, CSV, XML, Image, and PDF. During this presentation, Josh will show how to implement and deploy a JavaScript Object Notation (JSON) rendering extension for SSRS. JSON is a lightweight data-interchange format commonly used in rich client web applications. 4/27/2013 4:00:00 PM 4/27/2013 5:00:00 PM 13715 Josh Sivey APP DEV IRN 123 tSQLt is a database unit testing framework for Microsoft SQL Server. In this session we'll review the main aspects of tSQLt including: installing the tSQLt framework, creating and executing unit tests, isolating code using fake tables/views and stored procedure spies. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 13732 Reeves Smith BIA / BID IRN 219 Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data (nouns) within the enterprise. Get a good business and technical understanding of how MDS can help your organization obtain better data governance. The demo will walk through the basics of getting started with Master Data Services 2012, including the Excel Add-in for Master Data Services. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 13736 Mark Halstead DBA IRN 120 PowerShell is a powerful tool for automating many daily activities of a SQL Server DBA. This session will introduce you to PowerShell and provide examples of how PowerShell interacts with SQL Server. 4/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 13738 Colin Smith APP DEV IRN 123 Delphix is a new tool that is coming to market for SQL Server. This product virtualizes at the database level and makes refreshing and or creating new copies of databases for developers very quick and easy. This tool will save you time and storage. It is an amazing tool. I do not work for Delphix I just believe that this tool is one of the most useful tools that I have seen in a long while. This product also has great ROI as you will see in the session 4/27/2013 4:00:00 PM 4/27/2013 5:00:00 PM 13739 Colin Smith APP DEV / DBA IRN 125 Now that you know the basics, we will dive into functions and profiles. I will show you how to create your own function library so you can call these functions whenever you need to. This session will be very demo driven, and I will show you how to write scripts in order to offload the simple repeatable tasks that you have to do. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 13868 Russ Burns BIA / BID IRN 219 Excel 2013 brings PowerPivot and Power View to the desktop (without downloading add-ins) so you should get ready for it. Your users will google Power View and try to make magic with their own data. Unfortunately it isn't as simple as uploading a grid of excel data into PowerPivot and exploring it with Power View. We will work with an imaginary Business Analyst who needs help bringing their data to life. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 13873 Chris Shaw DBA IRN 120 It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements.  However, the best solution can only be provided if the database professional is getting all the answers.  This session is a case study into many of Disaster Recovery options that we as database professionals have.  Understand the answers to the important questions that  we should be asking to provide the best solution not only for the database but for the business as well.  As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is. 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 13888 Martin Schoombee DBA/BIA SC140-144 ETL (Extract, Transform Load) processes are fundamentally important in any data warehouse environment, and there are many different ways in which to develop the components. In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I'm sure it will work for you too!! 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 13923 Randy Knight BIA / DBA IRN 129 SQL Server offers several isolation levels beyond the default 'READ COMMITTED'. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each. 4/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 13924 Randy Knight APP DEV / DBA IRN 125 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. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 13932 Brad Baker BIA / BID IRN 219 DQS and the DQS Cleansing Transformation 4/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 13940 Kat Meadows DBA IRN 120 From the expect disasters of failed hardware, malicious and unintentional data corruption, to the more unusual disasters of HVac failures, water main breaks, and fire, we will walk through case studies of each type, discuss what went right and what went wrong with the disaster recovery plan and how to plan better in the future. This session is intended to be interactive, to have you thinking about your own environment and what you need to put into place to help you successfully recover from disasters. 4/27/2013 4:00:00 PM 4/27/2013 5:00:00 PM 13941 Kat Meadows Azure Big Data Prof Dev IRN 131 Finding the right people to form a team can be a difficult task, but once you have them, retaining them can be just as challenging. With budget strings tight, pay raises are few and far between, so how can you keep your team satisfied? This session will cover what it takes to keep your team motivated and focused. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 13957 Orion Gebremedhin BIA IRN 126 An in depth analysis and demonstration of how dynamic security works in SQL Server 2012 Analysis Services tabular models. With a practical demo and comparison to the Multi-Dimensional instance of SQL Server Analysis Services. 4/27/2013 4:00:00 PM 4/27/2013 5:00:00 PM 14015 Matt Smith DBA/BIA SC140-144 This session will cover a selection of topics and decision criteria for designing SSAS solutions for performance and scalability. This session is geared primarily towards Multidimensional SSAS, however in many cases Matt will cover how options may impact Tabular as well. Topics include: -Parent-Child vs. Natural Hierarchies -Star vs. Snowflake schemas -Many to Many relationships -Partitioning -Aggregation Designs -Processing schemes 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 14017 Andrew Duclos DBA/BIA SC140-144 How to successfully deploy permissions, agent job, and better manage the database development life cycle using SSDT. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 14020 Russ Burns BIA / BID IRN 219 Reporting Services standardizes your report creation and SharePoint enables collaboration and content management. SSRS/SharePoint Integrated Mode gives you a platform to empower your developers, power users, and end users. We will discuss the initial setup of integrated mode, work through some real life strategies using simple out of the box features, and consider some places where more development and planning may be helpful. 4/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 14025 Phil Robinson BID IRN 128 SQL 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/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 14035 Carlos Bossy BIA IRN 126 This 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/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 14036 Robert Miller APP DEV IRN 123 Have you ever wondered what functionality exists in T-SQL for aggregation beyond just using a GROUP BY? Curious as to what Windowing functions are? Curious about the numerous enhancements (developer love) to windowing functions in SQL Server 2012? Then come watch the 'Secret life of windowing function' presentation. 4/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 14037 Robert Miller APP DEV IRN 123 The OVER clause tends to be under appreciated and, sometimes, ignored. SQL Server 2012 includes new features in the OVER clause. The new features will be discussed along with what that pesky 'Window' thing is and how it fits with the OVER clause. 4/27/2013 2:45:00 PM 4/27/2013 3:45:00 PM 14038 Carlos Bossy BIA IRN 126 Tabular 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/27/2013 8:30:00 AM 4/27/2013 9:30:00 AM 14044 Orion Gebremedhin BID IRN 128 The multi-dimensional analytic cube is the final output of most data warehousing projects as such a practical understanding of the MDX language as applied to reporting from SSAS multidimensional cubes is extremely important. In this session we will go over some basic to advanced query techniques that any developer can use to create useful data sets from SSAS cubes. 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 14045 William E Pearson III BIA IRN 126 The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with SSAS 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SQL Server MVP and SSAS Maestro Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing examples to illustrate approaches for given scenarios. 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 14047 William E Pearson III BIA / DBA IRN 129 In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 14057 Kevin Boles DBA/BIA SC140-144 We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FORTY times now and it is always very highly rated! 4/27/2013 4:00:00 PM 4/27/2013 5:00:00 PM 14060 Kevin Boles APP DEV / DBA IRN 125 Analyzing File IO Stalls and Wait Stats can really help you understand why performance on your server is poor and point you in the right direction towards improving the situation! Very helpful scripts will be provided along with discussions and references to help you understand what are two of the most important tools in my performance analysis toolbag! 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 15219 Reeves Smith BIA / DBA IRN 129 Data Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula. Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demo row and filter context 4/27/2013 4:00:00 PM 4/27/2013 5:00:00 PM 15220 Chris Shaw DBA IRN 120 Have you been asked for an interview for that perfect job? The job that you would love to have on a team that you really want to be a part of? It is time to sharpen those interview skills. Every interview is different. During this session we will talk about my observations from many interviews that I have been a part of. There are many examples in this session on how not to present yourself, during an interview. We may laugh at some of the observations, but there are many lessons to learn. Get an inside look at how hiring managers make decisions, and make sure you know what to look for as the candidate. Have you been tasked with conducting an interview? We will complete the session with some tips on how to make sure that you get the information you need to make a good decision. 4/27/2013 9:45:00 AM 4/27/2013 10:45:00 AM 15221 Kevin Boles BIA IRN 126 Another 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. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM