SQLSaturday #226 - South Florida 2013 6/29/2013 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat226 3301 College Ave Davie FL 33314 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 3272 SherlockTech Staffing Gold Sponsor http://www.SherlockTech.com http://www.sherlocktech.com/wp-content/uploads/2013/04/SherlockTechHorizontal.jpg 60 170 3281 Blue Syntax Consulting Gold Sponsor http://www.bluesyntax.net http://www.bluesyntax.net/images/Logo.jpg 60 170 3315 TekPartners Gold Sponsor http://www.tekpartners.com http://4.bp.blogspot.com/-N3hKqgOu1ds/UV7x1c8-9qI/AAAAAAAAAOM/2rWegXe_kWA/s1600/TekPartners+BI++Staffing+Logo.PNG 60 170 3421 SIOS Technology Corp. Gold Sponsor http://us.sios.com http://ftp.us.sios.com/dgallagher/images/SIOS_logo_170x60.jpg 60 170 3427 Dell Software Gold Sponsor http://www.quest.com/ http://i.imgur.com/BAdC3.png 60 170 3344 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 3361 Fusion-io Silver Sponsor https://www.fusionio.com http://www.fusionio.com/images/logo.png 60 170 3306 PASS Headquarters Bronze Sponsor http://sqlpass.org http://www.sfssug.com/images/sqlpass2.jpg 60 170 14105 David Dye BI Track Room 3 This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 14106 David Dye What's up SQL2012! Room 1047 This session covers the new features and functions introduced to T-SQL in SQL Server 2012. Our time will be spent reviewing enhancements to T-SQL specifically for SQL Server 2012 with attention to demonstrations and code samples. This is a basic session, but ttendees should have a general knowledge of T-SQL. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14108 David Dye DBA Auditing Room 1053 This session will introduce column level encryption using t-sql. We will discuss the introduction of cryptographic services in SQL Server and how this enables native encryption as well as real life scenarios and uses of column level encryption. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 14109 Mark Tabladillo Business Dev Room 3032 Are you looking to create more stability in your professional future in uncertain economic times? Developing a social media platform is a challenge for highend professionals and consultants. The presenter has established a blog (http://marktab.net), cofounded an online journal (http://solidq.com/sqj), become a paid video presenter, secured a spot at Microsoft TechEd, and earned credit toward his first Microsoft MVP. This presentation introduces the basic elements for 2013 of a successful web strategy. The presenter shares his own statistics and first-hand experiences with website development, WordPress blog hosting, leveraging social media services (including Twitter, Linked in, YouTube and Facebook), and working with Microsoft. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 14110 Mark Tabladillo BI Reporting Room 3031 Text mining is projected to dominate data mining, and the reasons are evident: we have more text available than numeric data. Microsoft introduced a new technology to SQL Server 2012 called Semantic Search. This session's detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index. The demos include a web-based Silverlight application, and content documents from Wikipedia. We'll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14112 David Eichner BI Reporting Room 3031 Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy! 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 14116 Anthony Sammartino Database Developers Room 1049 In this session I will cover how SSAS tabular and PowerPivot compliment each other and make the slicing and dicing of large amounts of data a breeze for Power Users. I will give a brief explanation and history of each, then will let the audience choose their own adventure in creating a SSAS tabular model or PowerPivot model from scratch. I will walk everyone through how to import data into it, create data relationships from a regular database model, then expose the elements from the model for users to slice and dice data with ease with a Pivot table then a Power View visualization. I will demonstrate a few DAX commands that are very powerful yet very easy. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 14117 Anthony Sammartino Self Service BI Room 3034 In this session I will give a brief history of Self-Service Visualization and some tools out there today that facilitate it. I will then introduce Power View and the two ways it can be used; SharePoint 2010 (or 2013) and now Excel 2013. I will then cover what sources can be used to create a Power View report then jump into a demo and create a few visualizations from a blank canvas to demonstrate how easy, yet powerful this visualization tool really is. I will also show the SSAS Tabular model that houses the data for the Power View reports and will enhance it as part of the session to make Power View shine. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14136 Kevin Boles What's up SQL2012! Room 1047 Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 14137 Kevin Boles DEV Programming Room 1052 This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can get when suboptimal joins are used. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14143 Jeffrey Garbus DBA track Room 1048 This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication. Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14145 Jeffrey Garbus DBA Performance Room 1054 Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 14150 Luis Figueroa BI Reporting Room 3031 Are you currently using Master Data Services? if the answer is no, you can't afford to miss this presentation. In this session Luis will provide an overview of MDS 2012. What is it? What can you use it for? Whether you are looking for a better solution for your business users than the common spread-marts or you are implementing a Master Data Management strategy to go along with your EDW, this session is for you. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 14164 Jorge Novo BI Track Room 3 On this session you will learn how to find patterns and generic processes to create an ETL framework to automate the most common task within your organization using SSIS, from metadata driven package execution to ETL tracking of file loading processes. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14169 Max Trinidad DBA track Room 1048 Come and learn some basic technique on how to use PowerShell to work with your XML file. XML files are everywhere and you need to be prepare to use your tools that already are available at your fingertip. In this case, using PowerShell with SMO and Sapien XML editor which is a great tools. Also, I will be demostrating one particular scenario on how to convert UTC XML generated Dates to PowerShell w/SMO and T-SQL DateTime. You will get some PowerShell, T-SQL, and creating/viewing XML schemas in this session. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 14170 Max Trinidad BI Track Room 3 This session will demostrate how you can reuse a PowerShell script in SSIS 'Script Task' component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 14221 Hanneh Bandi Business Dev Room 3032 How are diamonds shaped? Self-Improvement session and will provide skills and knowledge on how to redirect your career growth in any company or environment. Session consists of business scenarios on how to improve business relationships; acquire some people skills; respect the dress code; learn to use your stepping stones; smile more and replace your attitude with a POSSITIVE ONE. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 14445 James McAuliffe Business Analytics Room 3033 Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14526 Jim Murphy DBA track Room 1048 In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 14536 David Ortiz BI Reporting Room 3031 The Microsoft BI Stack provides many different options when it comes to choosing a presentation layer. From PerformancePoint to PowerView the options are plentiful; however each option presents different benefits and is intended for different use cases. In this session I will cover the different presentation options provided by Microsoft and more importantly dive into when and where it is proper to use the different options. I will also demonstrate ways to integrate the different options like including a Reporting Services report in a PerformancePoint dashboard. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 14563 Anthony Sammartino Self Service BI Room 3034 In this session I will cover how PowerPivot and BISM Tabular complement each other in the domains of self-service and corporate BI. Let's face it, The Finance department does not have the expertise to model a database for reporting, and IT doesn't have the expertise in advanced financial calculations that the executive team is interested in. To bridge the gap from a large requirements process with the risk of functionality lost in translation, I will show you how you can roll out a PowerPivot model for business units in your organization and when it makes sense to centralize it in a BISM Tabular model. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 14564 Michael Antonovich Business Dev Room 3032 This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 14565 Michael Antonovich Business Dev Room 3032 This session introduces Data Quality Services, a feature introduced in SQL Server 2012. One of the challenges in developing Business Intelligence solutions is ensuring that the data does not have inconsistencies, incomplete records, invalid or inaccurate values, and data duplication. Sometimes when consolidating data from more than one source you have to transform data to create one standard set of domain values in a standard format. SQL 2012 answers this need with Data Quality Services (DQS). In this session, you will learn the basics of what DQS is and how it can be used to clean your data. You will see how to build a domain both manually and from an existing data table. You will then see how to use these domains to validate tables in SQL Server and Excel preparing them for use in SSAS and PowerPivot. After this session, you will understand how by putting quality back into your data, you can be your organization's BI hero. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 14675 Luis Figueroa Business Analytics Room 3033 Ready for the big data explosion? In this session Luis will provide an overview of Microsoft’s 100% Apache compatible Hadoop distribution and its role in the Microsoft's data platform. Expect to learn details about both flavors of HDInsight (service and Azure) and see examples of how to combine 3rd party and public data with your own. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 14683 Jorge Novo Database Developers Room 1049 Learn how to create metadata driven SSIS Packages using .NET code. Create a complex or simple framework to generate SSIS templates for custom configurations and automate most ETL processes. Traverse, modify and audit your current SSIS packages. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 14818 Chad Churchwell What's up SQL2012! Room 1047 This presentation will focus on the concepts behind AlwaysOn Availability Groups and new improvements to Failover Clusters, benefits it provides, and a demo of setting up AlwaysOn Availability groups 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 14819 Chad Churchwell DBA Auditing Room 1053 With replication being a source for many data warehouse systems, this session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve business needs will also be covered. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 14887 Richie Rump Database Developers Room 1049 Forget AlwaysOn and Columnstore Indexes the really fun features of SQL Server 2012 are in T-SQL. In this session you'll get the grand tour of these new features. You'll be introduced to the powerful new analytic window functions, discover new ways to generate numeric sequences and explore the awesome new query paging feature. You'll also be enamored with the new error handling features and new string functions such as the awesome Format function. Upon completion you'll have a great understanding of these great new features and how you can utilize them in your environment. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 14889 Richie Rump Database Developers Room 1049 Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework. Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 14899 Christopher Price DBA Performance Room 1054 There is runaway growth in the data volumes many organizations are facing today. The bad news is that much of this data is unstructured which means your traditional RDBMS just isn't capability of helping you deal with it. As a result significant emphasis has been put on technologies like Hadoop, No SQL and other distributed databases which are better suited to handling unstructured data. With the latest release SQL Server 2012 however, Microsoft has provided new features which will help tame some of this unstructured data. This session will dive into the new FileTable and Statistical Semantic Search features. We will show you how they work and highlight real world examples for integrating these exciting new features into your organization. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 14900 Christopher Price DBA Performance Room 1054 Your data is dirty…very dirty….now what? Let's clean it up! This session will introduce proven real-world techniques for cleaning and managing the quality of your data not just once but in an iterative, reliable manner to help you avoid the costly and sometimes daily firefighting that bad data can cause. Proven techniques for data profiling exploration, cleansing, data enrichment and matching/de-duplication will all be covered in this demo and data-centric session. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 14901 Christopher Price Business Analytics Room 3033 Businesses depend on reliable, consistent and correct data that can be managed effectively and shared through-out the enterprise. Master Data Services provides a powerful, feature-rich platform for arriving at this destination but the successful journey to this end requires a proven integrated approach. This session will discuss how MDS fits in the overall EIM architecture within your organization including real-world strategies for integrating (cleansing, matching and loading) Master Data into MDS and for making it available organization-wide. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 15008 Gareth Swanepoel DBA Performance Room 1054 Do SQL Server Administrators or Developers really know how to configure the hard- and software components of a SQL Server in order to have it running at peak performance ? This is not their fault and is purely due to the fact that they have not been exposed to these options before. If you are a DBA or developer and find yourself wondering how hardware changes affect a system or have questions relating to the performance implications of partitioning or compression, then this session is for you. In this session, I will be exploring topics such as Memory configuration, CPU and cache options, IO considerations, partitioning, compression and database file placement and many other performance optimisation tricks. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 15048 Mohamed Kabiruddin What's up SQL2012! Room 1047 In a world where executives/CXOs are keen to perform analytics and data consolidation with lightning speed, there is a strong push towards incorporating the principles of Agile manifesto in the BI world to deliver solutions faster than ever before. In this session, I will share techniques that will help a consultant deliver BI solutions with a rapid prototyping approach and how Agile features of TFS can be leveraged to run projects. The session will involve case studies and practical demos using Team Foundation Server and SQL Server 2012's BI tools - SSIS, SSRS, SSAS (tabular) and Excel PowerPivot. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 15090 Russell Fustino Business Dev Room 3032 See how to build your first Windows 8 app. We will use what I learned when creating the app: .NET Gurus Can Cook, which contains recipes from famous folks in the software industry such as Scott Hanselman and Mary Jo Foley. Join ComponentOne Developer Evangelist and former Microsoft Developer Evangelist, Russ Fustino in this session and learn the new programming paradigm for creating Windows 8 style apps. You will see how to build an application that incorporates many of the key characteristics of a great Windows 8 style app, including: * A modern UI user experience that leverages the signature Windows 8 controls such as GridView, ListView, FlipView, AppBar, Semantic Zoom and other Windows 8 controls. * A user experience that scale 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 15091 Sam Mesel DBA track Room 1048 There are many operations performed internally by SQL Server engine that use TempDB besides the objects created by developers (temporary tables or table variables). This session will present situations where SQL Server uses TempDB under the hood, and what can be done to prevent your TempDB to be your bottleneck. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 15092 Dmitri Korotkevitch DBA track Room 1048 Support 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. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15093 Dmitri Korotkevitch Database Developers Room 1049 Database professionals usually do not have the luxury of time when dealing with the customers problems. Customers expect ROI within the days and sometimes even within the hours after bringing them on board. In this we will talk how to quickly troubleshoot the system using wait statistics, DMVs, perf counters and other tools available in SQL Server. We will see how various design and code issues represent themselves in the system and mask each other. 6/29/2013 9:00:00 AM 6/29/2013 10:15:00 AM 15098 Brandon Leach Business Analytics Room 3033 In this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 15099 Brandon Leach DBA Auditing Room 1053 HIPAA puts a lot of responsibility on our companies and compliance can be hard to maintain. Today medical data is more valuable on the black market than a social security number or a credit card. As DBAs we're charged with the security of our data and thus act as front line defense. In this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve. We'll also dive into features in SQL Server that can help in this endeavor. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 15100 Frank Quintana DEV Programming Room 1052 Using BIDS we are able to answer questions in two contradictory worlds the OLTP and the OLAP in order to do that BIDS is presented with the three services SSIS, SSRS and SSAS and a variety of languages such as SQL, T-SQL, MDX, DMX, etc. It is impossible to explain even one aspect of one of the tools that comprise BIDS (Database Tools) even less to explain the main components of the MS BI stack SSIS, SSAS, SSRS in a single presentation. So in this presentation we are trying to explain the mind set of these three services and paradigms from the perspective of the problems they are trying to solve. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 15123 David Bermingham What's up SQL2012! Room 1047 Cluster MVP David Bermingham will walk you through the process of creating high availability and disaster recovery configurations using the new features of SQL Server 2012 AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters and Multisite Clusters. And then finally David will demonstrate how Availability Groups and Failover Clusters can be used together for a combination of High Availability and Disaster Recovery. This session will make use of VMs to demonstrate the technology in a 'hands-on' fashion. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15125 Rafael Salas Self Service BI Room 3034 Are you keeping up with buzz around big data? Are you wondering what opportunities and changes big data may bring to your data warehouse architecture? In this session you will learn about HDinsight, Microsfot’s big data platform, capabilities and tool set. We will address common myths and develop recommendations to successfully bring big data capabilities to your data warehouse and business intelligence implementation. After this presentation you will better prepared to make architectural and functional design decisions when considering Microsoft HDInsight as part of your solution. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 15126 Rafael Salas Self Service BI Room 3034 Have you figured out the role that a self-service ETL tool may play in your organization? Self-service BI technologies has gotten a lot of attention in the last few years and capabilities have gone from mere data visualization to data discovery and enrichment. Data Explorer for Excel is Microsoft’s latest move in the self-service data integration area. A free add-in for Excel 2010 and 2013, Data Explorer is receiving glowing reviews by BI pros and power users because of its friendly interface and rich capabilities.  In this session you will learn how Data Explorer for Excel can be used to discover, combine, and refine data. We will also look at some advanced functionality and the language used under the covers – M. After attending this presentation, you will be better prepared to support business users and understand how Data Explorer may affect your organization’s BI landscape and be ready to address potential risks of misguided implementations. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 15146 Yelena Pavlyuk BI Reporting Room 3031 Report Builder is a free and a powerful tool providing familiar Microsoft Office environment and targeted by Microsoft to business users. See for yourself if you as a developer would like to use this product or convince your power users to give it a try. In this session we'll look at differences between BIDS Report Designer and Report Builder. Then we'll walk through creating some reports to highlight Report Builder features and make a general overview of Report Builder benefits. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15147 Mark Tabladillo BI Track Room 3 This presentation includes a complex business analytics solution using elements across the Microsoft Business Intelligence technology. This talk will not have all the steps spelled out. Therefore you should prepare -- for example, by looking at the SQL Server 2012 Developer Kit -- since attendees will be expected to have working knowledge of SQL Server relational database, SSIS, SSAS, SSRS, SSMS and SSDT. Key elements of this solution will highlight features new to SQL Server 2012. At the end of the demonstration, you will be expected to participate in groups to promote one idea which builds on the demo, and everyone will be voting for their favorite groups. Come ready to create and celebrate your peers. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15148 John Welch DEV Programming Room 1052 Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15149 John Welch DEV Programming Room 1052 Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. You will also see how to automate the testing of SSIS packages, using the open source ssisUnit framework. The session will cover several of the common questions about automated unit testing, including how to handle test data , how to set up the environment for multiple developers, and how to make tests flexible. 6/29/2013 2:45:00 PM 6/29/2013 3:45:00 PM 15150 John Welch DBA Performance Room 1054 You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM 15151 Jose L. Rivera Business Analytics Room 3033 This is the era of data. The Business is demanding up to day information and insight in a timelier manner. We need a solution that could enable us to satisfy those needs and be as close as real time. This session will provide insight on how to use the Change Data Capture (CDC) inside SQL Server to load your Fact and Dimension tables that will accommodate those business needs. After this session you will be able to implement the concepts in your on environments to achieve the reporting and data requirements. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15152 Jose L. Rivera DEV Programming Room 1052 TSQL window functions, originally introduced in SQL Server 2005, have proven to be quite useful to solve complex ranking and aggregation scenarios. The new additions in SQL Server 2012 make them irresistible. In this session, we will discuss how to use them and highlight the new order, offset and distributions functionalities in real-world examples. 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 15154 Kendal Van Dyke DBA Auditing Room 1053 Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that? You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check. Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office 6/29/2013 10:45:00 AM 6/29/2013 12:00:00 PM 15155 Kendal Van Dyke DBA Auditing Room 1053 As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15725 Herve Roggero Self Service BI Room 3034 Let's talk database! SQL Server 2012 IaaS is a new offering, while SQL Database (previously SQL Azure) is a PaaS relational database engine. How do they compare? Which one should you use? Let's discuss pros and cons, and see how easy it is to build a database in the cloud. 6/29/2013 4:00:00 PM 6/29/2013 5:00:00 PM 15729 Jen Underwood BI Track Room 3 This fun and informative session covers best practices for data visualization and even infographics using Microsoft BI: Excel, Power View, the Office 2013 Web Apps Framework, Reporting Services, Visio and other open source and third-party data visualizations. 6/29/2013 1:30:00 PM 6/29/2013 2:30:00 PM