SQLSaturday #150 - Baton Rouge 2012 8/4/2012 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. #sqlsat150 Business Education Complex, Campus of Louisiana State University e.g. street address here if entered venue name above Baton Rouge LA 70808 2354 Sparkhound Inc. Platinum Level http://www.sparkhound.com https://lh4.googleusercontent.com/-Nv3XO9AtZDk/T9isIa2y5GI/AAAAAAAAAB0/R2zR7krsZ80/w455-h162-k/sparkhound%2Blogo.jpg 60 170 2415 User Group Support Services Platinum Level http://www.technicalcommunity.com https://sites.google.com/a/brssug.org/brssug/_/rsrc/1317342447601/config/microsoft_ugss.png 60 170 2451 Amedisys Gold Sponsor http://www.amedisys.com http://www.amedisys.com/app_themes/Main/images/logo.gif 60 170 2335 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2542 Telerik Gold Sponsor http://www.telerik.com/ http://www.brdnug.org/wp-content/uploads/Telerik-Logo.png 60 170 2472 Red Gate Software Silver Sponsor http://www.red-gate.com http://www.red-gate.com/assets/images/common/logo.png 60 170 2420 Antares Technology Solutions Silver Sponsor http://www.antaresnet.com http://host.antaresnet.com/attachment/antares_logo.jpg 60 170 2269 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2283 Turner Industries Group, LLC Bronze Sponsor http://www.turner-industries.com http://www.turner-industries.com/Images/Interior/about%20turner/ti_signaturelogo.jpg 60 170 2456 Postlethwaite Netterville Bronze Sponsor http://www.pncpa.com http://www.pncpa.com//admin/files/images/pages/PN-Logo-horiz.gif 60 170 2462 Pluralsight Special Pluralsight-only Level http://www.pluralsight-training.net/microsoft/ http://www.brssug.org/_/rsrc/1340685229876/pluralsight-fullcolor-250x55-v1%5B1%5D.png 40 100 2366 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 2372 SQL Tact Blog Sponsor http://www.sqltact.com https://si0.twimg.com/profile_images/663236575/sqltact_reasonably_small.jpg 40 100 2381 SQLJuJu Blog Sponsor http://www.sqljuju.com http://www.sqljuju.com/wp-content/uploads/2012/04/SQLJuJu100x40b.gif 40 100 10288 Bill Watters I am a Nerd who loves soccer, hanging with my family and sharing what I learn. I have been in IT for over 15 years and focused on Portal Solutions for the last 10. I am currently highly focused on BI Integration with SharePoint and making data more accessable to users. @bwatters http://www.linkedin.com/in/bwatters http://wattersbill72.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@bwatters 48 48 10267 Billy Chism Senior Software Architect at Sparkhound with over 17 years of experience in software design, development and project management. 48 48 10270 Brandon Cornett Brandon is a graduate of Southeastern Louisiana University, where he obtained his Bachelor's Degree in Computer Science, and a Minor in Mathematics. He is currently employed with Envoc, and has been a Software Developer there for over a year. He has worked extensively with the ASP.NET MVC framework, and has built numerous iOS and Android mobile applications that communicate with this framework. @brandonmc2005 http://www.linkedin.com/pub/brandon-cornett/49/541/208 http://bcornett.com/ https://api.twitter.com/1/users/profile_image?screen_name=@brandonmc2005 48 48 9387 Brian Sullivan Brian Sullivan is a developer analyst for Falcon Applications, LLC in Shreveport, LA. He has been working with Microsoft technologies for about 7 years, and is interested in increasing the exposure of agile techniques and methodologies in the Microsoft developer community. He currently runs the Shreveport .NET User Group and speaks frequently at local user groups and conferences. He received the Microsoft MVP award for Data Platform Development in 2011. Brian is a graduate of Harding University. @bmsullivan http://www.sullivansoftdev.com https://api.twitter.com/1/users/profile_image?screen_name=@bmsullivan 48 48 9090 Bryan Smith Bryan Smith is a Database Technology Specialist with Microsoft. http://www.linkedin.com/pub/bryan-smith/17/98B/161 48 48 10171 Cassius Dsouza Cassius holds BS and MS degrees, and is currently pursuing a second MS degree in Information Systems Decision Sciences at LSU. Further, he is currently working as student worker for the LSU Highway Safety Research Group. 48 48 10229 Chris Eargle Chris Eargle is a Telerik Developer Evangelist, INETA Director, and Microsoft Most Valuable Professional – C# from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, features content to guide you in becoming a .NET Ninja! @kodefuguru http://www.linkedin.com/in/chriseargle http://www.kodefuguru.com https://api.twitter.com/1/users/profile_image?screen_name=@kodefuguru 48 48 10143 Christine Assaf Christine Assaf is the founder and writer for HRTact.com. HR Tact is a professional blog that posts content found from research in the HR field as well as HR 'from the trenches.' She has a BS in Business Management and received her HR certification at LSU. She is currently employed as the HR Business Support Manager for a local retail/wholesale business. @HRTact http://www.linkedin.com/in/christineassaf http://www.hrtact.com https://api.twitter.com/1/users/profile_image?screen_name=@HRTact 48 48 10175 Cody Gros Cody Gros has been in the IT field for over 7 years working with SharePoint and Windows Server Technology. He is well versed in SharePoint 2010/2007 and is experienced in applying PowerShell scripting to SharePoint and Active Directory automation solutions. @codygros http://blog.codygros.com https://api.twitter.com/1/users/profile_image?screen_name=@codygros 48 48 10170 Cory Hutchinson Cory Hutchinson currently serves as the Associate Director for the Highway Safety Research Group (HSRG) at Louisiana State University and the Coordinator of the Louisiana Traffic Records Coordinator Committee (LA TRCC). Cory oversees all IT related projects within HSRG including business analytics, web site design, data quality analysis, electronic crash data collection, data reporting, disaster recovery, graphical information systems, business intelligence, and crash data integration. @markverret http://www.linkedin.com/pub/mark-verret/2/104/81 http://hsrg.lsu.edu https://api.twitter.com/1/users/profile_image?screen_name=@markverret 48 48 10247 Dave Reid HR Professional 1997- Present- Provides HRM expertise in employee relations – including progressive discipline, full cycle talent management, supervisory training and development initiatives and reviews safety accident investigations for 350 non union manufacturing and warehouse employees. http://www.linkedin.com/pub/dave-reid-phr-ssgb-dtm/1/416/34/ 48 48 10089 Eric Trivette Eric Trivette, MCPD, has been working with Microsoft ASP.NET since December 2006. Eric began SharePoint development with SharePoint 2010 and works with Antares Technology Solutions as a consultant where he designs and implements custom solutions in SharePoint 2010 and all versions of ASP.NET. 48 48 10265 Forest Marie Forest Marie is a lead software developer working for Turner Industries in Baton Rouge, Louisiana and Microsoft Certified Professional. He's been developing a variety of software since graduating from Southeastern in 2003. As an advocate of the S.O.L.I.D. principles, Forest is passionate about writing applications that was easy to work on, easy to maintain and easy to extend. @forestmarie http://www.linkedin.com/profile/view?id=18963700trk=tab_pro https://api.twitter.com/1/users/profile_image?screen_name=@forestmarie 48 48 10268 George Mauer George Mauer is a software developer, speaker, entrepreneur, writer, and comedian with an interest in the various techniques that can make software simple, extensible, and communicative. He is the owner of Humble Pi Software and currently a senior developer with Surge Consulting. He co-hosts the weekly Virtual Brownbag and is a regular participant in the New Orleans .Net, Ruby, Php, and general developers groups. He speaks regularly on C#, Javascript, MVC, and Agile. @togakangaroo http://www.linkedin.com/pub/george-mauer/4/327/a91 http://speakerrate.com/speakers/10090-togakangaroo https://api.twitter.com/1/users/profile_image?screen_name=@togakangaroo 48 48 8948 J Sawyer J Sawyer is a developer based in Houston, TX who absolutely loves to write code. After spending 9 years at Microsoft, he moved on to other things and is currently the Lead Developer for the RealTime Data Management team at Logica US. He spends his days building Really Cool Things around StreamInsight and having a blast doing it. J was recently named a Microsoft MVP for Sql Server due to his activities around StreamInsight. http://www.linkedin.com/in/devbiker http://www.devbiker.net https://api.twitter.com/1/users/profile_image?screen_name= 48 48 10159 James Sampson James Sampson works for Sparkhound as a developer on their Application Support team. He spends his free time developing non-sensical applications for Windows Phone and Windows Azure. http://business.lsu.edu/Information-Systems-Decision-Sciences/Pages/MS-Analytics.aspx 48 48 10274 Jennifer McCown Jen McCown is a Microsoft SQL Server MVP, developer, and DBA. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She is co-creator of DBARoadmap.com, and also writes for Petri IT Knowledgebase. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. @MidnightDBA http://www.linkedin.com/in/jennifermccown http://www.midnightdba.com/Jen https://api.twitter.com/1/users/profile_image?screen_name=@MidnightDBA 48 48 10164 Jeremy Beckham Jeremy holds a degree in Electronic Business from Southern University AM and is in the Executive MBA program at SELU. He has been a Senior Developer for Envoc for the past five years, specializing in ASP.Net and SharePoint Development as well as systems integrations and has given several talks on SharePoint, Microsoft.Net, and Node.js at SQL Saturday Houston, SharePoint Saturday, and .Net User Groups across south Louisiana. @jbeckh2 http://www.linkedin.com/in/jeremybeckham http://www.envoc.com https://api.twitter.com/1/users/profile_image?screen_name=@jbeckh2 48 48 10142 Jim Murphy Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90's. He is the President/CEO of SQLWatchmen, LLC., a managed DBA service provider for smaller companies who do not need a full-time DBA. He runs the Austin SQL Server User Group: CACTUSS Central and sits on the board of SQLPOSSE.com. He has been a professional DBA and developer for over 20 years and has run a consulting company full-time for over a decade. @SQLMurph http://www.linkedin.com/in/sqlwatchmen http://www.sqlwatchmen.com/blogs/jim https://api.twitter.com/1/users/profile_image?screen_name=@SQLMurph 48 48 9155 Jonathan Gardner Jonathan is a Technical Manager, PMP, and MCITP working with Insource Technology in Houston, TX. He has over 10 years of experience with a wide range of IT solutions including Database Administration, Virtualization, SAN Administration, and Windows Server environments. @jgardner04 http://www.linkedin.com/in/jonathangardner http://jonathanagardner.com https://api.twitter.com/1/users/profile_image?screen_name=@jgardner04 48 48 10305 Kate Treadwell I am a professional problem solver. My main work focuses around IT operations and logistics where I develop solutions to problems which my coworkers bring to me for help, and which I seek from user feedback. I have worked as our company's DBA, developer, and BI director for the last three years. I was recently promoted to Chief Technology Officer because I have a knack for finding patterns, forecasting, and listening to what people really want from data. CIO, Red Ball Oxygen @kpatrick81 http://www.linkedin.com/profile/view?id=23999744trk=tab_pro https://api.twitter.com/1/users/profile_image?screen_name=CIO, Red Ball Oxygen @kpatrick81 48 48 9069 Kimberly Boyd, DTM **Will send to Stacy Vicknair.** 48 48 10044 Kristen Reeves After graduating from Southeastern Louisiana University with a B.S in Computer Science and an MBA (Information Systems), I started my career in the Data Warehousing field. For 5 yrs I worked for Revenue Solutions, Inc. providing data warehousing solutions to revenue agencies. In this time I provided consulting to the MA Dept. of Revenue located in Boston as well as the GA Dept. of Revenue located in Atlanta. I recently became employed by Geocent, where I'm providing DB development skills @KristenNReeves http://www.linkedin.com/pub/kristen-reeves/0/766/ba https://api.twitter.com/1/users/profile_image?screen_name=@KristenNReeves 48 48 10241 Latish Sehgal Latish is a .NET consultant with Improving Enterprises and very passionate about software development and solving customer problems. He also leads the Dallas C# SIG. He can be reached via his blog at http://www.dotnetsurfers.com/ or twitter (http://twitter.com/latish). @latish http://www.dotnetsurfers.com https://api.twitter.com/1/users/profile_image?screen_name=@latish 48 48 10837 Laurie Firmin Antares Lunch Session 48 48 10144 Mark Holmes After working as a software developer for over 20 years, Mark Holmes is now a Senior DBA for TeleVox Software in Mobile, AL. He is also the chapter leader of the Pensacola SQL Server Users Group, soon expanding to become the Gulf Coast SQL Server Users Group. Mark led the organization of SQL Saturday #132 in Pensacola 2012. @markverret http://www.linkedin.com/in/markjholmes http://hsrg.lsu.edu https://api.twitter.com/1/users/profile_image?screen_name=@markverret 48 48 9042 Mike Byrd Former rocket scientist, retired USAF fighter test pilot; now a database geek. Former CTO for Texas Windstorm Insurance Association (9 years) and now SQL Server guru for Newgistics, Inc. (a direct competitor with FedEx and UPS for ground transportation for small packages) and part-time consultant. Expertise is performance tuning. @ByrdNest_TX http://www.linkedin.com/pub/mike-byrd/1/aa0/bbb https://api.twitter.com/1/users/profile_image?screen_name=@ByrdNest_TX 48 48 9842 Nancy Hidy Wilson Nancy Hidy Wilson has been working with Microsoft SQL Server since 1994. She originally volunteered for PASS at the first Community Summit in 1999 and has served on various PASS Committees. Nancy has been a PASS Community Summit speaker. She has led the Houston Area SQL Server User Group (HASSUG) since 2001. Nancy’s focus for the past 15+ years has been on providing standardized installation, configuration, and management of SQL Server for the global enterprise environment. @NancyHidyWilson http://www.linkedin.com/in/nancyhidywilson http://nancyhidywilson.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@NancyHidyWilson 48 48 9030 Paul Johnson Paul Johnson is a Senior Development Consultant for Sparkhound, Inc. He has worked in the Baton Rouge Software Industry for 12 years @pjguitarist https://api.twitter.com/1/users/profile_image?screen_name=@pjguitarist 48 48 9698 Ryan Adams Ryan Duclos is a Senior Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a Community Influencer for Microsoft. Ryan is the President of the Lower Alabama .NET User Group and is also involved with the Pensacola SQL Server User Group. @rduclos http://www.linkedin.com/in/ryanduclos https://api.twitter.com/1/users/profile_image?screen_name=@rduclos 48 48 10045 Santos Martinez @ConfigNinja http://www.linkedin.com/in/configninja http://aka.ms/ConfigNinja https://api.twitter.com/1/users/profile_image?screen_name=@ConfigNinja 48 48 10273 Sean McCown Sean McCown is a Certified Master in SQL Server 2008 for both Administration and Development. He is also a SQL Server MVP with over 15yrs experience in databases. Sean is a Contributing Editor with InfoWorld Magazine and a frequent contributor to many community sites and forums. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight. @MidnightDBA http://www.MidnightDBA.com https://api.twitter.com/1/users/profile_image?screen_name=@MidnightDBA 48 48 10330 SQL Saturday Team SQL Saturday Team 48 48 10283 Steve Schaneville Maintenance Engineer at the Paper Mill a didn't make my (or any other) list of most satisifying jobs, so I left that life and moved to Germany, where I discovered programming. After 2 1/2 years writing code to control robots (well kinda), I moved back to Baton Rouge and, surrounded by some incredibly smart people, learned something or other about writing enterprise software. I now serve as the Senior Applications Architect at Amedisys, Inc., and learn new things daily from my genius coworkers. @schaneville http://www.linkedin.com/pub/steve-schaneville/0/a15/5ab https://api.twitter.com/1/users/profile_image?screen_name=@schaneville 48 48 9629 Thomas LeBlanc Thomas is a Senior DBA at Turner Industries in Baton Rouge, LA. Worked in the IT field for 21 years experience w/ COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 9 years ago. He has been blessed with speaking at SQLRally at SQLPass in 2011. Thomas’ free time is spent helping other improving his relationship with family God. TheSmilingDBA.Blogspot.com @TheSmilingDBA http://www.linkedin.com/profile/view?id=29648544trk=tab_pro http://thesmilingdba.blogspot.com/ https://api.twitter.com/1/users/profile_image?screen_name=@TheSmilingDBA 48 48 9848 Tim Costello Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area. @TimCost http://www.linkedin.com/pub/tim-costello/8/b38/a02 https://www.interworks.com/company/our-team/staff/tim-costello https://api.twitter.com/1/users/profile_image?screen_name=@TimCost 48 48 10307 Tom Resing Tom is a Microsoft Certified Master in SharePoint. He is passionate about online collaboration technologies and loves being active in the SharePoint Community. Tom has been blogging about SharePoint for the last 5 years after certifying on the 2007 platform. Tom has enjoyed 15 years in the internet industry developing products and web site functionality in Perl, C++, Java, VB.Net and C#. With SharePoint, Tom prefers an Out of the Box approach to deployment. @resing http://tomresing.com https://api.twitter.com/1/users/profile_image?screen_name=@resing 48 48 10280 Trey Cook I am currently a Technology Strategist for Microsoft for the Enterprise Partner Group customers in South Louisiana. Prior to joining Microsoft, I spent eight years with The Shaw Group as an IT Manager / Senior Systems Engineer for messaging and collaboration as well as an IT Security Manager. Prior to joining The Shaw Group Inc., I spent nearly five years as a PC/Network Technician, Help Desk Manager, Systems Administrator and DBA for Turner Industries, Ltd. @fbciii http://www.linkedin.com/in/treycook1 https://api.twitter.com/1/users/profile_image?screen_name=@fbciii 48 48 10271 Wayne Odom Wayne is a Software Development Project Lead for Turner Industries Group, a large heavy industrial construction company based out of Baton Rouge. He's been developing software for a variety of businesses since graduating from LSU in 2002. He's interviewed more developers and dbas than he can remember. @batonrougefun http://www.linkedin.com/in/jerryodom http://www.jerryodom.com/ https://api.twitter.com/1/users/profile_image?screen_name=@batonrougefun 48 48 10233 Wesley Brown Wes Brown is a PASS chapter leader and SQL Server MVP. He writes for SQL Server Central and maintains his blog at http://www.sqlserverio.com. Wes is Currently serving as a Database Administrator Consultant for Dell. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays. @SQLServerIO http://www.linkedin.com/in/sqlserverio http://www.sqlserverio.com https://api.twitter.com/1/users/profile_image?screen_name=@SQLServerIO 48 48 8893 8893 SQLSaturday 150 SQL DBA 1 Auditorium (1510) 8/4/2012 11:50:00 AM 8/4/2012 1:00:00 PM 8948 8948 J Sawyer SQL Dev 1620 StreamInsight provides real-time analytics on large volumes of data with a response time measured in milliseconds, bringing a new level of capabilities to the Sql Server platform. This session will provide an overview of StreamInsight, its capabilities and use cases. It will also provide details on StreamInsight 2.1, what's been added and how it makes your real-time applications easier and more robust. 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 9030 9030 Paul Kennedy SQL BI 1 1800 Design walkthrough of an ETL solution developed using the Microsoft SSIS system for an enterprise level Data Warehouse. Managing the ETL process migration from a single data warehousing SQL Server to a multi-server environment can often be a complex task. This session will walk you through the design of a ETL system that has been created for such a scenario. The design takes into consideration several of the shortcomings inherent in the SSIS system and provides a structure for coordinated loading and processing of data from extraction to presentation. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 9042 9042 Mike Byrd SQL DBA 1 Auditorium (1510) Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results -- they were surprising to me! 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 9069 9069 Kimberly Boyd, DTM Career 1325 A demonstration of the tools, techniques, and benefits of Toastmasters International program. We will present a Toastmaster meeting that will allow the participants to see, hear, and experience the effects of communication and leadership development. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 9090 9090 Bryan Smith SQL Dev 1620 In this session, we will explore the new T-SQL analytic functions introduced with Microsoft SQL Server 2012, looking not only at what challenges they help us solve but also how they simplify T-SQL development and improve query performance. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 9091 9091 Bryan Smith SQL BI 2 1735 Write-back is a powerful feature of Analysis Services that provides the ability to input data directly into complex models. In this session, you will learn the basic techniques for Analysis Services write-back and how these techniques may be applied to address various business needs. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 9155 9155 Jonathan Gardner Career 1325 Projects that run long, run over budget, or flat out fail always get management's attention, and not good attention. This session will cover the project management process and demonstrate how it can help deliver higher quality results on time and on budget. Case studies and real world examples will arm managers and team leads with tools including communication management plans, requirements documentation, stakeholder management plans, and change management. These tools will help mitigate and manage common project pitfalls like status update meetings, gold plating, and scope creep. At the end of the session attendees will be armed with the knowledge necessary to streamline projects and how to deliver a top quality work product. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 9387 9387 Brian Sullivan .net 2 1220 Modern ORMs like NHibernate and Entity Framework are powerful, flexible tools that are the right choice for many projects. But they feel like overkill for that little internal app with three tables and one screen. And even after a ton of tuning, the SQL they produce for that massive screen in your mission-critical enterprise app can be abysmal. It turns out that both of these problems might have the same answer: a Micro ORM. These lightweight tools leverage the power of dynamic typing and other advanced .NET framework features to give you a simple way to get your data that's also easy to optimize. Brian will give an overview of the various tools available, and dive deep into PetaPoco to show you how powerful these little frameworks can be. 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 9629 9629 Thomas LeBlanc SQL BI 1 1800 This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demostration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints. 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 9698 9698 Ryan Richard .net 2 1220 Most developers are probably more familiar with the database first and model first design methods in Entity Framework, simply because these areas reached maturity earlier in the product life cycle. However, beginning with Entity Framework 4.1, the code first method has also become fully developed. This session will introduce you to the main concepts and core objects, methods, properties, etc. used to build your data access layer with code first methodology in Entity Framework. 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 9797 9797 Ryan Duclos SQL DBA 2 1700 SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer, as well as some of the differences and limitations. ***It is assumed that you have familiarity with SQL Server. 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 9798 9798 Ryan Duclos SQL BI 1 1800 SQL Azure Reporting is a CTP offering and part of the SQL Azure and Windows Azure Platform. The SQL Azure Reporting component is based on SQL Server Reporting Services (SSRS). It is a cloud-based service offerring a subset of SSRS technology. In this session we will go over the basic of getting SQL Azure Reporting setup and wired up. ***It is assumed that you have familiarity with designing/managing SSRS reports. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 9842 9842 Nancy Hidy Wilson SQL DBA 2 1700 Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server 2008 and 2008 R2 features designed to make a DBA’s life easier. If you aren’t using CMS, PBM, EPM, MDW, UCP or DAC – come learn what they are and the potential benefits for managing your environment. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 9844 9844 Nancy Hidy Wilson SQL DBA 2 1700 There seems to be lots of buzz about AlwaysOn (new high availability \ disaster recovery feature) and new BI features in SQL Server 2012. But, what else do you need to be aware of specifically for the database engine to make your case for upgrading? This session will provide an overview of changes to the installation process, enhancements for manageability (PowerShell updates, new DMVs and T-SQL functions), updates to security features and more! You’ll leave this session with a list of SQL Server 2012 features to help you develop your upgrade justification. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 9848 9848 Tim Costello SQL BI 2 1735 Tuning the data flow is all about choices. In this session we'll explore some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we'll walk through creating a performance baseline, tuning the data source, the destination and all the ‘stuff’ in the middle. This is a demo-driven session. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 9849 9849 Tim Costello SQL BI 1 1800 Everybody wants a data warehouse. What IS a data warehouse? How is it different from a data mart? What is a star Schema? What are snowflakes? Why is the dimensional bus important? In this session we'll cover all the key concepts you need to know to better understand what a data warehouse is and how to start building one. 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10044 10044 Kristen Reeves SQL BI 2 1735 This presentation will serve as an introduction into the world of Data Warehousing. We will start by covering the key characteristics and concepts of a Data Warehouse as well as go over the differences between a Warehouse and transactional Database Management System. We will then go into the internal design and processes involved in building an efficient Data Warehouse. We will end by discussing why Data Warehouses are useful to a business and how a business can leverage the key information stored to drive future business decisions. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 10045 10045 Santos Martinez IT Pro 1420 Attendees will be able to gain general knowledge of ConfigMgr 2012 and its functionality 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10061 10061 Ryan Adams SQL DBA 1 Auditorium (1510) There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers. Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent. We'll discuss how the location of your server in AD is important, how security can be compromised, and even AD DNS configuration. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work. This includes the biggest perpetrator, Group Policies Objects. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 10089 10089 Eric Trivette SharePoint 1615 Getting started in the world of SharePoint development? Have ASP.NET development experience? In this session, you will learn how SharePoint 2010 is built off the ASP.NET platform. We will also bridge the gap between both platforms by covering the basics of the SharePoint platform and set you on the path to developing your own SharePoint solutions. 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10090 10090 Santos Martinez IT Pro 1420 Building on the Deployment and Infrastructure Design session, this technical session walks you through planning and deploying a Microsoft System Center 2012 Configuration Manager hierarchy, including migration from an existing Configuration Manager 2007 hierarchy. Learn about the various migration scenarios, tools such as Package Conversion Manager (PCM) and Physical-to-Virtual (P2V), and share best practice guidance as your customers go to Configuration Manager 2012 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 10142 10142 Jim Murphy SQL DBA 1 Auditorium (1510) 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. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10143 10143 Christine Assaf Career 1325 If you are a Manager needing some interviewing education - this is your course! This session focuses on basic interviewing guidelines, including: preliminary interviews, types of testing, secondary or follow-up interviews, while keeping in mind EEO guidelines and best practices. Learn tips and tricks of the trade from an HR guru who is 'in the trenches.' 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10144 10144 Mark Holmes SQL DBA 2 1700 The developer vs DBA rivalry is as classic as pirate vs ninja. Find out why the rivalry exists, why they must learn to work together, and get some tips on coexisting with your nemesis, whether you're a developer or a DBA. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 10159 10159 James Sampson Windows Phone Dev Track 1321 In this session, you will learn to develop a new Windows Phone 7.5 application using Visual Studio from the ground up. Feel free to bring your laptop to join in. After going through getting started and developing a small application, I will try to help anyone with their own development projects for Windows Phone as well. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10164 10164 Jeremy Beckham .net 2 1220 Workflow Foundation is a very powerful part of the .Net Framework that has been mostly ignored by the .Net development community. The main reason developers don't learn it is because they just have no idea how to apply it to their current architectures. This presentation focuses on using Workflow Foundation inside of an ASP.Net MVC application with a n-tiered architecture. We will step through creating a workflow with Workflow Services and then we will see how to use the workflow from an ASP.Net MVC application. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 10166 10166 Mark Verret SQL BI 2 1735 Having clean data is a critical component in data warehousing and business intelligence systems. With the release of SQL Server 2012 Microsoft has provided a powerful tool to help organizations in tackling their data quality issues. We will look at this new Data Quality Services tool and how it can help clean the data that will eventually end up in your warehouse. 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 10170 10170 Cory Hutchinson SQL BI 1 1800 This presentation will walk through the key concepts and decisions necessary for moving from a transactional system to an analytical system based on a data warehouse. Concepts and demonstrations will be based on the process implemented at the LSU Highway Safety Research Group as the case study. The discussion will be based on a more business approach while also presenting technical details. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10171 10171 Cassius Dsouza SQL Dev 1620 In this session we will introduce accessing data and writing queries in SAS. If time permits, we will cover statistical modeling techniques on datasets to depict its implementation in business intelligence projects. No prior knowledge of SAS is assumed. However, knowledge of basic SQL techniques is assumed. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 10175 10175 Cody Gros SharePoint 1615 Are you a SharePoint administrator and now have to maintain all your SharePoint databases? This session will provide you with the information you need to maintain your SharePoint databases including: - Backup/Recovery of databases - Determining your recovery model -Building maintenance plans - SQL Aliases 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 10190 10190 Cody Gros IT Pro 1420 SharePoint 2010 brings to the table an enterprise level search solution that allows you to search content inside and outside of your organization. This session will dive into the various features that are included in SharePoint search. This session will cover the following topics: - Searching content inside your organization - Searching people/expertise inside the enterprise - Searching external LOB data using BCS - Using search to build a Corporate Directory Search 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10229 10229 Chris Eargle .net 1 1125 Lambda expressions are a powerful feature of C#, one that can be wielded for good or evil. Attend this session for an adventure through the evolution of the C# language, from the depths of the delegate keyword to the expressiveness of the lambda expression. I will show you how anyone can easily learn to wield and empower code with lambda expressions. It's dangerous to go alone! Take this: =gt; 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10233 10233 Wesley Brown SQL DBA 1 Auditorium (1510) Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come! 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10241 10241 Latish Sehgal .net 1 1125 As developers, we all have our favorite utilities, some used occasionally and then there are others that we refuse to work without. We might not use all of them everyday, but a good developer should know his options when the need arises. In this session, we'll go through the tools, utilities and hacks that can make you much more productive as a .Net developer. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10247 10247 Dave Reid Career 1325 You will learn hoiw to initially prepare for the interview. Provide the company with the best information highlighting your talents. Provide you with insights and information to get you in front of the right people looking for talent.. 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 10265 10265 Forest Marie .net 1 1125 A high level discussion of the tools used in a large enterprise by a professional .NET team. On a budget? No worries, most of these tools are free courtesy of the open source .NET developer community that you need to know about. Discussion to include awesome debugging skills, catching performance issues before they go live (we learned the hard way), how to have a professional error logging system set up in minutes, working with other developers and productivity tools. We'll also spend some on some critical design tips to keep your applications running faster and avoiding the 'clean slate syndrome.' 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 10266 10266 Mike Carter .net 2 1220 Automating deployment of web solutions using Team Foundation Server 2010, Team Build and MSDeploy. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 10267 10267 Billy Chism Windows Phone Dev Track 1321 Demo: Build a simple texting application for Windows Phone 7 using Microsoft Push Notification Services and Windows Azure Toolkit for Windows Phone. 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10268 10268 George Mauer .net 2 1220 Nearly everyone working with javascript knows jQuery but there are lot's of useful javascript libraries! Come learn about the incredibly popular underscore.js - a utility jackknife that is the 'bow tie to jQuery's tux'. This session will cover the basics of what you can do with underscore and why you should include it in your javascript projects. Always. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10270 10270 Brandon Cornett Windows Phone Dev Track 1321 In recent years, the WCF team at Microsoft has released multiple REST services, while the ASP.NET team has helped developers build basic APIs by allowing JSON to be returned from MVC controllers. ASP.NET Web API is a joint effort by both teams to provide a single RESTful API framework. This session will cover the basics of how to use ASP.NET Web API to build simple HTTP services. We will start with a new MVC 4 project and build a functional API that can be consumed by numerous clients in order to query and manipulate data from the host. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 10271 10271 Wayne Odom Career 1325 I've interviewed a lot of potential software developers and DBAs in the last 3 years. My managers look to myself and my peers to decide who can do the job. As a lead I'm pretty in tune to what you need to know to get the job done. Here are some things that'll help young and old IT pros get a job especially if I'm the interviewer you've got to convince. 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10273 10273 Sean McCown SQL DBA 2 1700 The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started. 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10274 10274 Jennifer McCown SQL Dev 1620 You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool. This session is chock full of code examples, including before-and-after demos and how-tos. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 10275 10275 Jennifer McCown SQL Dev 1620 If you'd like to become a database professional - or if you already work with SQL Server at all - you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance! 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 10276 10276 Sean McCown SQL DBA 1 Auditorium (1510) Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 10280 10280 Trey Cook .net 1 1125 Learn how to leverage Windows Azure and the Content Delivery Network to host HD quality video, and Visual Studio to build and deploy a Smooth Streaming Media player to play the video. 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 10281 10281 Paul Johnson Windows Phone Dev Track 1321 In this session we will take a design approach to building a Windows Phone app with Expression Blend. 8/4/2012 9:35:00 AM 8/4/2012 10:35:00 AM 10283 10283 Steve Schaneville .net 1 1125 Unit Tests are common place in our tools for creating quality code. However, we still run into several road blocks that often prevent us from writing a thorough suite of tests. This session will suggest ways of solving 2 specific problems that I have personally experienced when trying to write suites of unit tests. Specifically, I'll attempt to address: * how to write test for older code libraries that do not currently have unit tests so that the code can be changed with confidence (a look at the new Fakes framework in VS 2012). * how to write tests for logic/data access code that uses Entity Framework without hiding the flexiblilty of Entity Framework (note, I actually don't prefer the repository pattern). 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 10288 10288 Bill Watters SharePoint 1615 This is a walk through of how to create a Metro Sytle Navigation to a SharePoint Site, potentially including exposing high level Core Metrics in tiles to bubble that key information to users. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 10305 10305 Kate Treadwell SQL BI 2 1735 I will discuss one of the easiest ways to make our bosses happy: using data to answer their most difficult questions. Our challenge is to take massive amounts of data and transform it into meaningful visualizations for the business teams that that IT department services. The most difficult problem often lies at the intersection of millions of lines of data and the team’s ability to sort through pages upon pages of Excel or printed reports. I will discuss simple methods of transforming that data from Excel, SQL Server, Oracle, and even flat text files into visualizations which answer some of the biggest questions in a matter of seconds; SSRS or BI development experience is not required. 8/4/2012 10:50:00 AM 8/4/2012 11:50:00 AM 10306 10306 James Van Scotter, Ph.D. and Joni Shreve, Ph.D. .net 1 1125 LSU’s College of Business and the College of Agriculture recently joined forces to create the Master of Science in Analytics (MSA) program. MSA students learn to use advanced technologies for data management, applied statistics, and optimization with large real-world data sets to increase return on investment, improve customer retention, detect fraud and improve decision making. Student teams work with leading companies and government organizations to solve real problems in insurance, banking, health care, communications, law enforcement, and marketing. The presenters will outline the program and discuss opportunities to collaborate with local businesses. 8/4/2012 12:15:00 PM 8/4/2012 1:00:00 PM 10307 10307 Tom Resing SharePoint 1615 Mapping Mashups with SharePoint Designer including an Overview of Current Map Service Providers, an Introduction to Customizing the Data View Web Part, and a Demonstration of Dynamic Mapping from List Data 8/4/2012 8:20:00 AM 8/4/2012 9:20:00 AM 10308 10308 Tom Resing SharePoint 1615 Business Connectivity Services with Microsoft SQL Server including an Overview of the Business Connectivity Services, an Introduction to Configuring BCS, and Demonstrations of using External Lists and External Data Columns. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 10330 10330 SQL Saturday Team SQL DBA 1 Auditorium (1510) Welcome to SQL Saturday Baton Rouge! In this session we will be introducing you to the facility and answer any questions you have before the FREE training begins! 8/4/2012 8:00:00 AM 8/4/2012 8:15:00 AM 10334 10334 SQL Saturday Team SQL DBA 1 Auditorium (1510) Closing - Raffle and Prizes 8/4/2012 3:40:00 PM 8/4/2012 4:30:00 PM 10837 10837 Laurie Firmin SQL BI 2 1735 Antares Lunch Session 8/4/2012 12:15:00 PM 8/4/2012 1:00:00 PM 10838 10838 Jennifer McCown .net 2 1220 Whether you are searching for a new job or already well established, you need the right tools and strategy to make your career great! Men and women both should come and join the discussion to share their experiences with job hunting, interviewing, professional development, and on-the-job issues. 8/4/2012 12:15:00 PM 8/4/2012 1:00:00 PM 10969 10969 James Sampson Windows Phone Dev Track 1321 Ready to get started on your Windows Phone application? Bring your laptop with the pre-installed SDK to this session to get started with your app ideas. There will be a developer or two familiar with the platform to help you get started. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM 11081 11081 Santos Martinez IT Pro 1420 A review of the new Windows 8 operating system and QA with Microsoft PFE Santos Martinez. 8/4/2012 1:10:00 PM 8/4/2012 2:10:00 PM 11082 11082 Santos Martinez IT Pro 1420 A review of the new Windows Server 2012 operating system and QA with Microsoft PFE Santos Martinez. 8/4/2012 2:25:00 PM 8/4/2012 3:25:00 PM