SQLSaturday #204 - Detroit 2013 3/16/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. #sqlsat204 Lawrence Technological University 21000 West Ten Mile Road Southfield MI 48075 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 3037 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 3148 Tegile Systems Gold Sponsor http://www.tegile.com http://www.sqlsaturday.com/files/c794d898-7ab5-42bf-a085-a19080ce381f.jpg 60 170 3158 Precise Software Solutions Gold Sponsor http://www.precise.com/?_kk=precise%20software_kt=2e770b9f-12b0-4329-b99d-53e2361c8245gclid=CO6Awrqf3LUCFZOe4Aod4kcA8Q http://www.precise.com/images/common/logo.png 60 170 3167 Project Leadership Associates, Inc. Silver Sponsor http://www.projectleadership.net http://www.projectleadership.net/images/project-leadership-logo.jpg 60 170 3190 BlueGranite Silver Sponsor www.blue-granite.com http://www.blue-granite.com/wp-content/uploads/2013/03/sqlsaturday.jpg 60 170 3206 Microsoft Corporation Silver Sponsor http://www.microsoft.com http://www.estetica-design-forum.com/attachments/logo-design-brand-identity-forum/8769d1345730184-new-microsoft-logo-microsoft-logo.jpg 60 170 3118 New Horizons Computer Learning Centers Silver Sponsor http://nhgreatlakes.com/ http://www.sqlsaturday.com/files/e581c92a-8884-4eb7-bdc8-78f56af1e18e.jpg 60 170 2870 PASS Headquarters Silver Sponsor https://www.sqlpass.org https://www.sqlsaturday.com/images/PASS_logo.jpg 60 170 3023 Dell Software Group Silver Sponsor http://www.quest.com/ http://i.imgur.com/BAdC3.png 60 170 2967 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3208 Sogeti Bronze Sponsor http://www.us.sogeti.com http://www.sqlsaturday.com/files/58051c5f-2599-437a-b54a-64b143c9b944.jpg 60 170 3226 FusionStorm Bronze Sponsor http://fusionstorm.com/ http://media.marketwire.com/attachments/201102/35977_FusionStorm_logo_tag_med.jpg 60 170 12418 SQLSatruday 204 DBA Room 1 3/16/2013 10:15:00 AM 3/16/2013 10:30:00 AM 12418 SQLSatruday 204 DBA Room 1 3/16/2013 2:15:00 PM 3/16/2013 2:30:00 PM 12418 SQLSatruday 204 DBA Room 1 3/16/2013 3:45:00 PM 3/16/2013 4:00:00 PM 12418 SQLSatruday 204 Prof Dev Room 2 3/16/2013 10:15:00 AM 3/16/2013 10:30:00 AM 12418 SQLSatruday 204 Prof Dev Room 2 3/16/2013 2:15:00 PM 3/16/2013 2:30:00 PM 12418 SQLSatruday 204 Prof Dev Room 2 3/16/2013 3:45:00 PM 3/16/2013 4:00:00 PM 12418 SQLSatruday 204 BI Room 3 3/16/2013 10:15:00 AM 3/16/2013 10:30:00 AM 12418 SQLSatruday 204 BI Room 3 3/16/2013 2:15:00 PM 3/16/2013 2:30:00 PM 12418 SQLSatruday 204 BI Room 3 3/16/2013 3:45:00 PM 3/16/2013 4:00:00 PM 12418 SQLSatruday 204 Developer Room 4 3/16/2013 10:15:00 AM 3/16/2013 10:30:00 AM 12418 SQLSatruday 204 Developer Room 4 3/16/2013 2:15:00 PM 3/16/2013 2:30:00 PM 12418 SQLSatruday 204 Developer Room 4 3/16/2013 3:45:00 PM 3/16/2013 4:00:00 PM 12418 SQLSatruday 204 Wild Card Room 5 3/16/2013 10:15:00 AM 3/16/2013 10:30:00 AM 12418 SQLSatruday 204 Wild Card Room 5 3/16/2013 2:15:00 PM 3/16/2013 2:30:00 PM 12418 SQLSatruday 204 Wild Card Room 5 3/16/2013 3:45:00 PM 3/16/2013 4:00:00 PM 12419 SQLSaturday 204 Wild Card Room 5 3/16/2013 11:45:00 AM 3/16/2013 1:00:00 PM 12419 SQLSaturday 204 Developer Room 4 3/16/2013 11:45:00 AM 3/16/2013 1:00:00 PM 12419 SQLSaturday 204 BI Room 3 3/16/2013 11:45:00 AM 3/16/2013 1:00:00 PM 12419 SQLSaturday 204 Prof Dev Room 2 3/16/2013 11:45:00 AM 3/16/2013 1:00:00 PM 12419 SQLSaturday 204 DBA Room 1 3/16/2013 11:45:00 AM 3/16/2013 1:00:00 PM 12420 SQLSaturday 204 DBA Room 1 3/16/2013 8:00:00 AM 3/16/2013 9:00:00 AM 12420 SQLSaturday 204 Prof Dev Room 2 3/16/2013 8:00:00 AM 3/16/2013 9:00:00 AM 12420 SQLSaturday 204 BI Room 3 3/16/2013 8:00:00 AM 3/16/2013 9:00:00 AM 12420 SQLSaturday 204 Developer Room 4 3/16/2013 8:00:00 AM 3/16/2013 9:00:00 AM 12420 SQLSaturday 204 Wild Card Room 5 3/16/2013 8:00:00 AM 3/16/2013 9:00:00 AM 12421 SQLSaturday 204 Wild Card Room 5 3/16/2013 5:30:00 PM 3/16/2013 6:00:00 PM 12421 SQLSaturday 204 Developer Room 4 3/16/2013 5:30:00 PM 3/16/2013 6:00:00 PM 12421 SQLSaturday 204 BI Room 3 3/16/2013 5:30:00 PM 3/16/2013 6:00:00 PM 12421 SQLSaturday 204 Prof Dev Room 2 3/16/2013 5:30:00 PM 3/16/2013 6:00:00 PM 12421 SQLSaturday 204 DBA Room 1 3/16/2013 5:30:00 PM 3/16/2013 6:00:00 PM 12433 David Maxwell DBA Room 1 There are four basic tasks every DBA should know how to do. They are, in this order: Restore, Backup, Index and Stats maintenance, and Consistency Checking. After this session, beginning and 'involuntary' DBAs will know the basic ins and outs of each of these four critical tasks, as well as how to set up recurring maintenance on their servers, and handle some of the common issues these tasks present 3/16/2013 1:00:00 PM 3/16/2013 2:15:00 PM 12455 Sam Nasr Developer Room 4 The FileStream feature was introduced with SQL Server 2008 allowing BLOBs to be managed by the DB. In 2012, FileTable expands on this feature by using specific tables for storing these BLOBs. This allows Windows apps to access these items as if there were stored on the file system. 3/16/2013 1:00:00 PM 3/16/2013 2:15:00 PM 12538 Carlton Ramsey Wild Card Room 5 In this session we will review some example code of ways I use PowerShell to help me as a DBA. Bring your questions and we will work together see how PowerShell can be the 'Super Glue' that can be used to solve some of your problems. 3/16/2013 1:00:00 PM 3/16/2013 2:15:00 PM 12557 David Klee DBA Room 1 Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO. 3/16/2013 9:00:00 AM 3/16/2013 10:15:00 AM 12603 Kevin Boles Developer Room 4 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! 3/16/2013 4:00:00 PM 3/16/2013 5:15:00 PM 12604 Kevin Boles Developer Room 4 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! 3/16/2013 9:00:00 AM 3/16/2013 10:15:00 AM 12716 Kevin Bullen Prof Dev Room 2 Every SQL developer or DBA should have a fully stocked toolbox that they can turn to in times of need. SQL Server enjoys a wide variety of support from 3rd party vendors that provide tools to help us peek under the hood and pinpoint issues. Sometimes we either don't have the budget for everything we would like, or we need something for a one-off project. In this session we will examine some of the free tools published by members of the SQL community and 3rd party vendors. 3/16/2013 9:00:00 AM 3/16/2013 10:15:00 AM 12834 Josh Fennessy BI Room 3 With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes. An entire new method of modelling analytic data has emerged and it's called Tabular Mode Analysis Services. In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes -- Multidimensional and Tabular -- into one level playing arena. In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation. 3/16/2013 10:30:00 AM 3/16/2013 11:45:00 AM 12871 Colleen Morrow Wild Card Room 5 Let's face it, auditing isn't sexy. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be sexy. 3/16/2013 2:30:00 PM 3/16/2013 3:45:00 PM 12953 Craig Purnell DBA Room 1 We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them 3/16/2013 10:30:00 AM 3/16/2013 11:45:00 AM 12954 Craig Purnell Prof Dev Room 2 LinkedIn is more than an online resume! The platform is chock full of useful features for networking, relationship building, and job searching. Think of it as your professional online image. LinkedIn is rapidly becoming the de facto platform for business networking. There are many powerful, advanced features that most people don’t know how to use or even exist. It is also an online communication platform, professional networking portal, and contacts database. Takeaways include: how to optimize and polish your profile, how to get your profile to 100%, quality vs. quantity networking strategies, selecting of and the correct use of LinkedIn groups 3/16/2013 2:30:00 PM 3/16/2013 3:45:00 PM 12991 Jordan Martz BI Room 3 Implimenting agility and leveraging tool to deliver cubes faster is the next generation for Data Warehousing initiatives. I'll show you how to generate C# applications for SSIS And Cubes, impliment a tool for generating the SSIS, Dimensional structures, and building the cubes. This is just the start because I'll be interjecting how to Model Data Warehouses for major companies and how your company needs to do it. You don't get hired for knowing Kimball and Inmon anymore. 3/16/2013 2:30:00 PM 3/16/2013 3:45:00 PM 13115 Rob Kerr BI Room 3 This session provides a technical overview of Hadoop and HD Insight targeted for Microsoft DW/BI professionals. Emphasis will be on how Map/Reduce paradigms complement and extend BI architectures. Specifically highlighted will be the Hadoop ecosystem, HDFS, Cloud vs. On-Premise, and various strategies to integrate SQL and NoSQL technologies into cohesive solutions. 3/16/2013 1:00:00 PM 3/16/2013 2:15:00 PM 13116 Dustin Prescott Wild Card Room 5 The best defense is a good offence. Learn how to practice hacking without going to jail or getting fired. In this presentation we'll be going over how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks. We will also attempt to snag some credentials from the SAM cache so we can go galavanting across the rest of the network. 3/16/2013 10:30:00 AM 3/16/2013 11:45:00 AM 13117 Tom Groszko Developer Room 4 I will present INSERT, UPDATE, DELETE and INSTEAD OF triggers using T-SQL. I will not be talking about CLR triggers. I will compare triggers to constraints, discuss security, demonstrate what each kind of trigger does, explain T-SQL trigger specific statements, enabling and disabling, ordering the sequence of trigger execution, demonstrate how to use the INSERTED and DELETED tables available in a trigger. 3/16/2013 10:30:00 AM 3/16/2013 11:45:00 AM 13192 George Squillace BI Room 3 The expression language in SQL Server Integration Services is rich, and there are many locations within a package where the expression language can be used to make packages more dynamic. Within Derived Column transformations, Precedence Constraint evaluation, Script Tasks, Connection Managers, Containers and more, expressions and variables can be used to increase the flexibility of an SSIS package. Remember, “Write once, run many!” 3/16/2013 9:00:00 AM 3/16/2013 10:15:00 AM 13208 Allen White Wild Card Room 5 You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly. 3/16/2013 9:00:00 AM 3/16/2013 10:15:00 AM 13288 Jeff Moden Developer Room 4 Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive 'black arts' session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand. You just have to know that a Tally Table is involved somewhere in this. ;-) 3/16/2013 2:30:00 PM 3/16/2013 3:45:00 PM 13355 Eddie Wuerch Prof Dev Room 2 Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session 3/16/2013 1:00:00 PM 3/16/2013 2:15:00 PM 13356 Eddie Wuerch DBA Room 1 Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you. 3/16/2013 4:00:00 PM 3/16/2013 5:15:00 PM 13610 Brian Davis DBA Room 1 Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started. 3/16/2013 2:30:00 PM 3/16/2013 3:45:00 PM 13674 Frank Murphy BI Room 3 Introduction to spatial features in SQL Server: how to create, procure, integrate and leverage spatial data. Demo using SQL Server 2008 R2. 3/16/2013 4:00:00 PM 3/16/2013 5:15:00 PM 13768 Chris Hyde Prof Dev Room 2 Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with maxIT-VCS, a subsidiary of SAIC that specializes in healthcare IT consulting for the healthcare market, which he particularly enjoys as he gets to tackle different types of SQL problems at each client. He has been previously employed at ABQ Health Partners, Thornburg Mortgage, and Presbyterian Health Services. 3/16/2013 10:30:00 AM 3/16/2013 11:45:00 AM 14161 Karen Lopez Wild Card Room 5 Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions. Using real-life evidence of her own data in your systems. 3/16/2013 4:00:00 PM 3/16/2013 5:15:00 PM 14175 Colleen Morrow Prof Dev Room 2 Ever thought about trying your hand at blogging? Or maybe you've started a blog but struggle with what to write about. We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom. 3/16/2013 4:00:00 PM 3/16/2013 5:15:00 PM