SQLSaturday #197 - Omaha 2013 4/6/2013 12:00:00 AM (GMT-06:00) Central Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat197 Mammel Hall, University of Nebraska-Omaha 6708 Pine Street Omaha NE 68106 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 2906 House of Brick Technologies Gold Sponsor http://www.houseofbrick.com http://davidklee.net/hob_sqlsat_logo.png 60 170 2931 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2943 Tegile Systems Gold Sponsor http://www.tegile.com http://www.sqlsaturday.com/files/4bea2224-5b2e-4510-83a8-7f11e6685b15.jpg 60 170 2960 Deliveron Consulting Services Gold Sponsor http://www.deliveron.com http://www.davidklee.net/wp-content/uploads/2013/01/deliveron.png 60 170 3007 Farm Credit Services of America Gold Sponsor https://www.fcsamerica.com/ http://www.fcsamerica.com/images/logo.png 60 170 3025 Dell Software Group Gold Sponsor http://www.quest.com/ http://i.imgur.com/BAdC3.png 60 170 3067 Blue Cross Blue Shield of Nebraska Gold Sponsor https://www.nebraskablue.com/ http://www.sqlsaturday.com/files/6939f80b-8f7f-49ba-ac9c-556f8b95b2ef.png 60 170 3178 GNet Group Gold Sponsor https://www.gnetgroup.com http://www.gnetgroup.com/_styles/images/bg-logo.png 60 170 3201 Modis Gold Sponsor http://www.modis.com/ http://www.sqlsaturday.com/files/352cccb7-1d87-4f8c-84e8-7ab68c5b71e3.png 60 170 3205 Violin Memory Gold Sponsor http://www.violin-memory.com/ http://www.sqlsaturday.com/files/c7cff1d7-3156-4eac-8939-2ba76a756afc.jpg 60 170 2866 PASS Headquarters Silver Sponsor http://www.sqlpass.org http://www.sqlsaturday.com/images/PASS_logo.jpg 60 170 3013 SQLskills.com Silver Sponsor http://www.sqlskills.com/ http://www.sqlskills.com/images/sqlskillslogo_color.jpg 60 170 3030 Pluralsight Silver Sponsor http://pluralsight.com http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-250x55-v1.png 60 170 3093 Home Instead, Inc. Silver Sponsor http://www.homeinstead.com http://www.homeinstead.com//Style%20Library/Images/Corporate/Corporate-bw.gif 60 170 3179 Aspect Software Silver Sponsor http://www.aspect.com/Pages/default.aspx http://www.aspect.com/images/logo.jpg 60 170 3221 Sogeti USA Silver Sponsor http://www.us.sogeti.com/ http://www.us.sogeti.com/web-images/SogetiLogo.jpg 60 170 2896 Datavail Bronze Sponsor http://www.datavail.com/ http://www.sqlsaturday.com/files/8b0cd3a8-d1f9-44a3-bbbc-84af0649037f.JPG 60 170 2969 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3086 Sql Power Tools, Inc. Bronze Sponsor http://www.sqlpower.com http://www.sqlpower.com/img/spt_logo_sql_saturday.png 60 170 3199 CRi Bronze Sponsor http://www.clientresourcesinc.com/ http://www.clientresourcesinc.com/wp-content/uploads/2013/03/CRI_logo_WEB137x60.gif 60 170 3282 idea5, Inc. Bronze Sponsor http://idea5inc.com/index.html http://idea5inc.com/images/idea5_logo.png 60 170 3193 QCI Personal Sponsor https://www.qci.com http://www.sqlsaturday.com/files/acaeeb2b-e83d-4dd1-9630-9fee77792607.png 40 100 3054 Data On Wheels - Steve Hughes Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2013/02/data-on-wheels-1.png 40 100 3078 Wrox SWAG http://www.wrox.com http://www.sqlsaturday.com/files/01de18c8-27fe-4cbb-a060-cad5836816b9.gif 40 100 12148 SQLSaturday 197 Business Intelligence 122 4/6/2013 11:30:00 AM 4/6/2013 12:45:00 PM 12148 SQLSaturday 197 DBA 121 4/6/2013 11:30:00 AM 4/6/2013 12:45:00 PM 12148 SQLSaturday 197 Developer 120 4/6/2013 11:30:00 AM 4/6/2013 12:45:00 PM 12148 SQLSaturday 197 General 119 4/6/2013 11:30:00 AM 4/6/2013 12:45:00 PM 12148 SQLSaturday 197 Business Intelligence 117 4/6/2013 11:30:00 AM 4/6/2013 12:45:00 PM 12148 SQLSaturday 197 DBA 118 4/6/2013 11:30:00 AM 4/6/2013 12:45:00 PM 12149 SQLSaturday 197 DBA 118 4/6/2013 8:00:00 AM 4/6/2013 8:30:00 AM 12149 SQLSaturday 197 Business Intelligence 117 4/6/2013 8:00:00 AM 4/6/2013 8:30:00 AM 12149 SQLSaturday 197 General 119 4/6/2013 8:00:00 AM 4/6/2013 8:30:00 AM 12149 SQLSaturday 197 Developer 120 4/6/2013 8:00:00 AM 4/6/2013 8:30:00 AM 12149 SQLSaturday 197 DBA 121 4/6/2013 8:00:00 AM 4/6/2013 8:30:00 AM 12149 SQLSaturday 197 Business Intelligence 122 4/6/2013 8:00:00 AM 4/6/2013 8:30:00 AM 12150 SQLSaturday 197 Business Intelligence 122 4/6/2013 5:00:00 PM 4/6/2013 5:30:00 PM 12150 SQLSaturday 197 DBA 121 4/6/2013 5:00:00 PM 4/6/2013 5:30:00 PM 12150 SQLSaturday 197 Developer 120 4/6/2013 5:00:00 PM 4/6/2013 5:30:00 PM 12150 SQLSaturday 197 General 119 4/6/2013 5:00:00 PM 4/6/2013 5:30:00 PM 12150 SQLSaturday 197 Business Intelligence 117 4/6/2013 5:00:00 PM 4/6/2013 5:30:00 PM 12150 SQLSaturday 197 DBA 118 4/6/2013 5:00:00 PM 4/6/2013 5:30:00 PM 12151 Matthew Brimer DBA 118 Database Security is a very broad and scary topic, one which many days could be dedicated to speaking on it. In this session Matt will give a high level overview of what Database Security is, what tools Microsoft gives you to accomplish it and some simple things that you can do to shrink your attack surface. 4/6/2013 8:30:00 AM 4/6/2013 9:45:00 AM 12153 Michael Fal DBA 121 Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it. 4/6/2013 3:45:00 PM 4/6/2013 5:00:00 PM 12342 Joseph Sack Developer 120 When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed. 4/6/2013 12:45:00 PM 4/6/2013 2:00:00 PM 12537 Kathy Gibbs DBA 121 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/6/2013 2:15:00 PM 4/6/2013 3:30:00 PM 12692 Brandie Tarvin General 119 Having scheduled database backups is one thing, but knowing what backup types are needed is a different horse of a different color. Building on the 'Backups 101' session, this discussion focuses on why we should build Recovery solutions instead of Backup solutions, and the most important things to remember when designing the solution. 4/6/2013 10:00:00 AM 4/6/2013 11:15:00 AM 12696 Jeff Renz Business Intelligence 117 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/6/2013 12:45:00 PM 4/6/2013 2:00:00 PM 12721 Glenn Berry DBA 121 The 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/6/2013 8:30:00 AM 4/6/2013 9:45:00 AM 12723 Glenn Berry DBA 121 SQL 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/6/2013 10:00:00 AM 4/6/2013 11:15:00 AM 12728 David Klee DBA 118 Come see David Klee (@kleegeek) and Joe Grant (@dba_jedi) in a 'discussion' with a competitive comparison between SQL Server and Oracle in a highly interactive dynamic session. Each database engine has its place in the IT world, and we will discuss which is the right tool for the job. The goal is to be objective and compare features, strengths and weaknesses, and editions. Check your opinions at the door and come join us for an educational session! 4/6/2013 10:00:00 AM 4/6/2013 11:15:00 AM 12780 Steve Jones Developer 120 More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important data, but the formatting must be stripped out in order for users to effectively search this data. Filestream, Filetable, Full-Text Search, and Semantic Search are covered. 4/6/2013 3:45:00 PM 4/6/2013 5:00:00 PM 12782 Steve Jones DBA 121 Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications. 4/6/2013 12:45:00 PM 4/6/2013 2:00:00 PM 13078 Meagan Longoria Business Intelligence 117 PerformancePoint can be a useful tool for delivering a dashboard to users through SharePoint. The data visualizations for your dashboard can come from PerformancePoint, Excel Services, Reporting Services, or a web page. Understanding the features and limitations of these sources of data visualizations can help you create a dashboard that best meets your users’ needs. 4/6/2013 8:30:00 AM 4/6/2013 9:45:00 AM 13156 Bill Fellows Developer 120 The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences. 4/6/2013 10:00:00 AM 4/6/2013 11:15:00 AM 13175 Sudhir Gajre DBA 118 This is a deep dive session in the new HA/DR options for SQL Server 2012. Through interactive discussions and lively demos, get an in depth understanding of the AlwaysOn Failover Clustering and AlwaysOn Availability Groups. Experience how to set up active secondary’s and off load backups to the secondary servers. You will walk away with a thorough understanding of the pros and cons of each HA/DR option in SQL Server 2012 and can immediately apply it to practical use. 4/6/2013 3:45:00 PM 4/6/2013 5:00:00 PM 13177 Sudhir Gajre General 119 Yes, how to be a DBA and retire rich. This is a session in the ‘off the beaten path’ or the ‘miscellaneous track’. You will learn nothing SQL Server technical in this session, but will learn about the Modern Portfolio Management theory in Finance. I will conduct a practical discussion on how to structure your 401(K) portfolio or your general investment portfolio for the most optimal asset allocation and maximum return while minimizing taxes and expenses. You can use the practical tips in this session to consider options to streamline your portfolio to maximize returns. This session may serve as a wakeup call to do something about your portfolio. When it comes to retirement, clearly, luck is not a strategy. 4/6/2013 12:45:00 PM 4/6/2013 2:00:00 PM 13212 Kevin Boles Developer 120 For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure! 4/6/2013 8:30:00 AM 4/6/2013 9:45:00 AM 13442 Ronald Yenko General 119 SQL Server 2005 and later continued to introduce tools to help you audit what was occurring in your database, with 2012 introducing even more auditing tools. In this session, we'll go over the questions you need to ask your business to determine what level of auditing is appropriate. We'll go through how to set up many of the common audits to meet your business' requirements. Each technique has its features and each has associated costs - your goal is to find a balance. 4/6/2013 8:30:00 AM 4/6/2013 9:45:00 AM 13476 Scott Shaw Business Intelligence 117 Have you ever wondered what's going on with that SQL Server Analysis server you support? Do you want to know what this BI fuss is all about? I'll walk you through the basics of dimensional modelling to help you understand from a operational DBA perspective what's going on and why a BI system needs to be treated differently. I'll take the mysticism out of the differences between OLTP and OLAP and provide a method to the maddness. 4/6/2013 2:15:00 PM 4/6/2013 3:30:00 PM 13550 Leslie Weed Business Intelligence 122 What you need to know about Reporting Services in the Cloud. We will cover benefits, limitations and scenarios that you may or may not have thought about for implementing this into your enviornment or for simply taking advantage of the free trial period. 4/6/2013 12:45:00 PM 4/6/2013 2:00:00 PM 13553 Phil Brammer Business Intelligence 122 New in SQL Server 2012, the SSIS catalog provides a rich set of built-in tools for capturing/reporting package logging, statistics, and other interesting things all within a few keystrokes or mouse clicks. This session will focus on the internals of this new catalog and how to use it. You will learn how to extend and query the metadata captured by the package execution process and how to navigate your way around the built-in reports. 4/6/2013 8:30:00 AM 4/6/2013 9:45:00 AM 13556 Dean Nicholson Developer 120 Discuss the basic indexing principles you should have learned in school if you had been paying attention. We will examine a couple of data and indexing patterns that will enable you to make an educated decision on your indexing strategy. We will also take a deep dive in how indexes begin and grow and how they are used 4/6/2013 2:15:00 PM 4/6/2013 3:30:00 PM 13559 Steve Hughes Business Intelligence 122 If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013. In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution. Microsoft has went 'all-in' with Excel as their primary BI client. If you want to get a first hand look at using it more fully, you will be amazed. I know I was. 4/6/2013 3:45:00 PM 4/6/2013 5:00:00 PM 13562 Shawn Meyers DBA 118 Using freely available tools to baseline your new SQL server instance. Using Crystal disk mark, SQLIO, Memtest86, and Dell DVDstore tools to measure, baseline and compare results of your new hardware. Crystal disk mark and SQLIO will test IO subsystems ; memtest86 will test your memory before you put it into production. Dell DVDstore will be used to create a database enabling you to put a synthetic load simulating numerous users to your SQL server instance, enabling the creation of solid baselines when putting the server under a heavy load. Using the benchmarks to determine capacity of the hardware and will it met the expected load. 4/6/2013 12:45:00 PM 4/6/2013 2:00:00 PM 13567 Tim Plas DBA 118 Amazon’s AWS and Microsoft’s Azure both offer SQL Server instances as services (not necessarily as servers). What do they offer, why would one use them, how do they differ, what special considerations are there? What exactly does “Platform as a Service” (PaaS) mean with SQL? 4/6/2013 2:15:00 PM 4/6/2013 3:30:00 PM 13723 Reeves Smith Business Intelligence 117 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/6/2013 3:45:00 PM 4/6/2013 5:00:00 PM 13725 Reeves Smith Business Intelligence 122 Data Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Understand the basics of the DAX language and get introduced to evaluation context. 4/6/2013 10:00:00 AM 4/6/2013 11:15:00 AM 14052 Jason Horner Business Intelligence 122 This 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/6/2013 2:15:00 PM 4/6/2013 3:30:00 PM 14075 Bill Pearson Business Intelligence 117 Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. 4/6/2013 10:00:00 AM 4/6/2013 11:15:00 AM 14098 Jeff Hicks General 119 A key feature of Windows PowerShell is the ability to execute long running tasks in the background while you continue to use the shell for other tasks. In this session you will learn about the PowerShell's job infrastructure including using scheduled background jobs, a new PowerShell 3.0 feature. We'll also explore some alternatives such as using runspaces. 4/6/2013 2:15:00 PM 4/6/2013 3:30:00 PM 14539 Jeff Hicks General 119 One of the killer features in PowerShell 3.0 is the ability to create workflows with Powershell script. You do not need a developer background or Visual Studio to create workflows. Now you can workflow scripts for long running and unattended tasks that can survive network interruptions or even reboots. In this session we'll look at workflow syntax, how to run and some best practices. 4/6/2013 3:45:00 PM 4/6/2013 5:00:00 PM