SQLSaturday #183 - Albuquerque 2013 2/9/2013 12:00:00 AM (GMT-07:00) Mountain Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat183 6700 Jefferson Street Building A Albuquerque NM 87109 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 2948 Dell/Quest Software Gold Sponsor http://www.quest.com/company/contact-us.aspx http://i.imgur.com/BAdC3.png 60 170 3053 New Horizons Host http://www.newhorizons.com http://i1164.photobucket.com/albums/q568/kgbkto/NewHorizonsLogo-Orig.jpg 40 100 2821 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/media/164281/confio_logo.jpg 60 170 2882 Xtivia, Inc Silver Sponsor http://www.xtivia.com/ http://www.xtivia.com/images/XtiviaLogo-170x60.jpg 60 170 3031 Precise Software Silver Sponsor http://www.precise.com http://www.precise.com/images/common/logo.png 60 170 3044 Robert Half Technology Silver Sponsor http://www.rht.com/ http://i1164.photobucket.com/albums/q568/kgbkto/RHT_logo_CMYK-1.jpg 60 170 2859 PASS Headquarters Bronze Sponsor http://www.sqlpass.org/ http://i1164.photobucket.com/albums/q568/kgbkto/PASS_logo.jpg 60 170 2988 Red Gate Software Swag Sponsor http://redg.at/VSuG1E http://www.red-gate.com/assets/images/common/logo.png 40 100 3008 O'Reilly Swag Sponsor http://oreilly.com http://oreilly.com/images/orn_logos/oralogo_bk200.gif 40 100 3029 xSQL Software Swag Sponsor http://www.xsql.com http://www.xsql.com/images/xSQLSoftware.png 40 100 3042 McGraw-Hill Publishing Swag Sponsor http://mhprofessional.com/ http://i1164.photobucket.com/albums/q568/kgbkto/McGrawHillLogo_zpsb064ca89.png 40 100 3045 Morgan Kaufmann Swag Sponsor http://store.elsevier.com/Morgan-Kaufmann/IMP_16/ http://i1164.photobucket.com/albums/q568/kgbkto/MK_logo.jpg 40 100 3051 Wrox Press Swag Sponsor http://www.wrox.com http://i1164.photobucket.com/albums/q568/kgbkto/Wrox_logo.jpg 40 100 11775 SQLSatruday 183 114 2/9/2013 3:40:00 PM 2/9/2013 4:05:00 PM 11775 SQLSatruday 183 115 2/9/2013 3:40:00 PM 2/9/2013 4:05:00 PM 11775 SQLSatruday 183 112 2/9/2013 3:40:00 PM 2/9/2013 4:05:00 PM 11775 SQLSatruday 183 113 2/9/2013 3:40:00 PM 2/9/2013 4:05:00 PM 11776 SQLSaturday 183 113 2/9/2013 11:55:00 AM 2/9/2013 1:10:00 PM 11776 SQLSaturday 183 112 2/9/2013 11:55:00 AM 2/9/2013 1:10:00 PM 11776 SQLSaturday 183 115 2/9/2013 11:55:00 AM 2/9/2013 1:10:00 PM 11776 SQLSaturday 183 114 2/9/2013 11:55:00 AM 2/9/2013 1:10:00 PM 11777 SQLSaturday 183 114 2/9/2013 7:30:00 AM 2/9/2013 8:00:00 AM 11777 SQLSaturday 183 115 2/9/2013 7:30:00 AM 2/9/2013 8:00:00 AM 11777 SQLSaturday 183 112 2/9/2013 7:30:00 AM 2/9/2013 8:00:00 AM 11777 SQLSaturday 183 113 2/9/2013 7:30:00 AM 2/9/2013 8:00:00 AM 11778 SQLSaturday 183 113 2/9/2013 5:15:00 PM 2/9/2013 5:45:00 PM 11778 SQLSaturday 183 112 2/9/2013 5:15:00 PM 2/9/2013 5:45:00 PM 11778 SQLSaturday 183 115 2/9/2013 5:15:00 PM 2/9/2013 5:45:00 PM 11778 SQLSaturday 183 114 2/9/2013 5:15:00 PM 2/9/2013 5:45:00 PM 11942 Mark Halstead 115 There are times when T-SQL, DMV's and system tables can't tell you what you need to know or do what you need to do. Knowing the basics of PowerShell can provide functionality when you need to work 'outside of the box'. 2/9/2013 4:05:00 PM 2/9/2013 5:15:00 PM 11978 Michael Fal 114 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. 2/9/2013 9:25:00 AM 2/9/2013 10:35:00 AM 11983 Jason Brimhall 115 Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. 2/9/2013 10:45:00 AM 2/9/2013 11:55:00 AM 11985 Aaron Bertrand 114 The session will cover a collection of minor bad habits that can occasionally lead to major problems. 2/9/2013 8:00:00 AM 2/9/2013 9:15:00 AM 11987 Jeff Renz 113 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 population of a data mart. SQL Server 2012 introduces column store indexes and the Vertipaq engine. Because the Vertipaq engine allows you to use a dimensional model or a relational model, I will argue that a data vault design is the best architecture for your data warehouse. In this session we will introduce you to the data vault architecture, the new modeling capabilities of Vertipaq, compare the performance of the OLAP engine vs the Tabular engine and discuss data warehouse design options to best leverage column store indexes. 2/9/2013 4:05:00 PM 2/9/2013 5:15:00 PM 11990 Kyle Neier 113 Just like your grandma tested spaghetti to tell if it was done, we'll be throwing several of the new T-SQL enhancements against the wall to see what's good and what falls off. We'll silence the lion's RaiseRror by throwing some meaty exceptions. We'll bring together the old lovers 'Coalesce' and '+' for one last jaunt before they are banished by the Concat function. We'll even open the window on some of the new aggregate and analytical functions as well as some other t-sql enhancements introduced in SQL 2012. 2/9/2013 1:10:00 PM 2/9/2013 2:20:00 PM 11992 Ron Beatty 115 How to handle and track changes in a data warehouse dimension table is an important dimensional modeling consideration. The dimension tables of a data warehouse need to be designed to appropriately store a history of attribute changes over time. The ETL processes need to detect these changes and correctly update the dimensional table to preserve historical accuracy. Finally, fact records need to be associated with the correct historical version of the dimension. In this presentation, a SQL Server Integration Services (SSIS) will be demonstrated that creates an ETL data flow which will load a dimensional table with both Type 1 and Type 2 dimensional attributes. 2/9/2013 8:00:00 AM 2/9/2013 9:15:00 AM 12003 Gabriel Villa 113 Do you spend a lot of time writing code? If you have repeated tasks that are slowing you down, why not takeaway tips and tricks to save time and become more productive. I have been told, “If you do something once, do it right, you do it twice, automate it!” I will share some tips how scripting anything from batch files, PowerShell, Perl or AutoHotkey scripts and using productivity tools will save you time, and convert you into a codefu ninja 2/9/2013 2:30:00 PM 2/9/2013 3:40:00 PM 12004 Steven Wake 112 SSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven't seen what has been updated in SSIS 2012, this will be the session to cover the most! 2/9/2013 4:05:00 PM 2/9/2013 5:15:00 PM 12009 Russ Burns 115 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. 2/9/2013 1:10:00 PM 2/9/2013 2:20:00 PM 12066 Denny Cherry 114 In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best. 2/9/2013 1:10:00 PM 2/9/2013 2:20:00 PM 12108 Rob Mandeville 112 This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I'll discuss the differences between virtual and physical host metrics and issues surrounding them. We'll discuss some virtualization shortcomings and then show a little about Confio's Ignite and how it can help DBAs achieve virtualization and not lose visibility of their physical layer. 2/9/2013 1:10:00 PM 2/9/2013 2:20:00 PM 12239 Ben Miller 112 Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You'll be glad you did. 2/9/2013 10:45:00 AM 2/9/2013 11:55:00 AM 12245 Chris Shaw 114 Recently I watched the news as a crisis situation was played out. There were police officers were running around, moving behind large solid objects like cars, putting on their protective gear.  At first it looked like mass chaos but after watching it closely the officers moved like a well-oiled machine.   The more I watched the more I realized that as database professionals we have crisis situations as well. As the situations are compared there are a number of things that we can learn by watching how other professionals handle crisis.  This session is dedicated to looking at how others handle crisis so that we can learn from what they do. 2/9/2013 4:05:00 PM 2/9/2013 5:15:00 PM 12248 TJay Belt 115 The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases. The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities. We will discuss various terms, processes, ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion. 2/9/2013 9:25:00 AM 2/9/2013 10:35:00 AM 12276 Steve Jones 114 Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more. 2/9/2013 10:45:00 AM 2/9/2013 11:55:00 AM 12279 Jason Horner 112 In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and discuss how and when to use each type. We will also review approaches to creating rich hierarchies that simplify complex reporting. This session will be very interactive--bring your toughest dimensional modeling quandaries! 2/9/2013 9:25:00 AM 2/9/2013 10:35:00 AM 12298 Carlos Bossy 114 Columnstore Indexes in SQL Server 2012 will allow you to significantly improve the speed of data warehousing queries without creating cubes, aggregated tables, or other techniques normally used to improve performance. This session will show how to implement this new type of index in SQL Server and demonstrate their advantages compared to traditional solutions. Carlos also discuss the scenarios for which columnstore indexes should be implemented instead of cubes, on top of star schemas, and with reporting tables to provide powerful but flexible BI solutions. 2/9/2013 2:30:00 PM 2/9/2013 3:40:00 PM 12345 Todd Kleinhans 113 Do you have an affordable lab set-up running SQL Server 2012 on Windows 2012 to learn and play with? In the 70-462 Administering Microsoft SQL Server 2012 Databases Training Kit, you will need six (!) machines on their own domain to complete the exercises. Using VMWare Workstation 9 ($250), Todd will show how to set up your lab environment on a ~$500 laptop running Windows 7 64-bit, 8GB of RAM, and an SSD drive using less than 40GB of space for the six virtual machines! Using free iso(s), we will run through several of the set-up exercises from the 70-462 Training Kit in order to build out the training lab. Participants will leave with enough knowledge and links to resources to build their own affordable SQL Server 2012 lab. 2/9/2013 8:00:00 AM 2/9/2013 9:15:00 AM 12363 Sri Sridharan 112 Every CIO and CTO is now talking and thinking about Big Data can make their life easier at their business. You will walk out of this session with a fair understanding of Big Data, the various terminologies in this space. So next time when your CIO asks about it - you know where to start. 2/9/2013 2:30:00 PM 2/9/2013 3:40:00 PM 12380 Reeves Smith 113 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 understanding of how MDS can help your organization obtain better consistency across your organization. 2/9/2013 10:45:00 AM 2/9/2013 11:55:00 AM 13134 Dave Justice 113 When you just can't seem to make your report look the way you want it to, consider using Custom Code snippets. Learn about doing custom formatting, report documentation, and even using SSRS to generate file extracts. We will also look at a tweak to the rsReportServer.config file to configure custom export formats. We'll wrap up with a report on the ExecutionLog table that will give us an idea of which reports are our problem children. 2/9/2013 9:25:00 AM 2/9/2013 10:35:00 AM 13225 Kathleen Meadows 115 Most DBA’s know you need to be doing some form of maintenance on your databases: Backups, index rebuilding\reorganization, update statistics, integrity checks, and system cleanup. SQL Server offers some basic tasks to complete this needed maintenance. The session will cover setting up a maintenance plan including the tasks, schedules, and logging. From there, we will dive deeper into the basic task, find out what is going on behind the scene, and discuss when it is ok to use them and when you should create your own. At the end of the session you will know how to create a maintenance plan, how to log results and keep a history of success or failures, when you should use what SQL Server has provided and when you should create your own plan. 2/9/2013 2:30:00 PM 2/9/2013 3:40:00 PM 13602 Tom Norman 112 Have you ever taken over a server or better yet an entire environment? Just recently I changed jobs knowing nothing about their databases except what I could learn from the interview process. I walk in knowing there are going to be issues but where do I start? What is most important, what can wait? How can I get a picture of the systems? Are there any tools to help me? Let’s put our heads together, let’s see what you would do, then I will let you know what I have begun to do. 2/9/2013 8:00:00 AM 2/9/2013 9:15:00 AM