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 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 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 2335 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2451 Amedisys Gold Sponsor http://www.amedisys.com http://www.amedisys.com/app_themes/Main/images/logo.gif 60 170 2542 Telerik Gold Sponsor http://www.telerik.com/ http://www.brdnug.org/wp-content/uploads/Telerik-Logo.png 60 170 2420 Antares Technology Solutions Silver Sponsor http://www.antaresnet.com http://host.antaresnet.com/attachment/antares_logo.jpg 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 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 8893 SQLSaturday 150 SQL DBA 1 Auditorium (1510) 8/4/2012 11:50:00 AM 8/4/2012 1:00:00 PM 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Laurie Firmin SQL BI 2 1735 Antares Lunch Session 8/4/2012 12:15:00 PM 8/4/2012 1:00:00 PM 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 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 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 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