SQLSaturday #121 - Philadelphia 2012 6/9/2012 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat121 45 Liberty Blvd., Suite 210 Malvern PA 19355 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 1788 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1886 Anexinet Gold Sponsor http://www.anexinet.com http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/Anexinet_Logo_Lg_jpeg_300.jpg 60 170 2118 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2234 Microsoft Gold Sponsor http://www.microsoft.com/en-us/mtc/locations/philadelphia.aspx http://www.microsoft.com/global/oneMscomSettings/PublishingImages/Microsoft_logo.png 60 170 2259 Quest Software Gold Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2293 GridIron Systems Gold Sponsor http://www.gridironsystems.com http://www.gridironsystems.com/wp-content/uploads/2011/02/GridIron_Logo42.png 60 170 1813 Perpetual Technologies, Inc. Silver Sponsor http://pti.net http://www.pti.net/Logo/logo170x60.jpg 60 170 1867 O'Reilly Media Silver Sponsor http://oreilly.com http://oreilly.com/images/orn_logos/oralogo_bk200.gif 60 170 1881 Robert Half Technology Silver Sponsor http://www.rht.com http://www.roberthalftechnology.com/External_Sites/content/RHT-2009/Shared/Images/rht_logo.gif 60 170 2063 Aspect Consulting Silver Sponsor http://www.aspect-consulting.com/ http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/AspectConsulting.jpg 60 170 2100 RedGate Silver Sponsor http://www.red-gate.com/?utm_source=ugutm_medium=uglogoutm_content=sqlsat121phillyutm_campaign=redgate http://www.red-gate.com/assets/images/common/logo.png 60 170 2239 Branegy Systems Silver Sponsor http://branegy.com http://branegy.com/global/img/branegy_logo.png 60 170 2242 CSS Technical Services Silver Sponsor http://www.contemporarystaffing.com/ http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/CSS_TechServlogo.jpg 60 170 2284 RDA Corporation Silver Sponsor http://www.rdacorp.com http://www.rdacorp.com/wp-content/uploads/RDA-logo-170-x-60.jpg 60 170 2302 Sapien Silver Sponsor http://www.sapien.com http://www.sapien.com/assets/img/logo3.png 60 170 2317 Confio Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2325 Xtivia Silver Sponsor http://www.Xtivia.com http://www.xtivia.com/images/XtiviaLogo-170x60.jpg 60 170 1808 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1906 Linchpin People LLC Bronze Sponsor http://www.linchpinpeople.com http://linchpinpeople.com/wp-content/uploads/2012/02/linchpin_logo_trans.png 60 170 2107 Morgan Kaufman Publishers Bronze Sponsor http://mkp.com/ http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 60 170 2288 CapTech Consulting Bronze Sponsor http://www.captechconsulting.com http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/CapTech_logo_color_170x84.jpg 60 170 1944 Vince Napoli Personal Sponsor http://www.linkedin.com/profile/view?id=1682443trk=tab_pro http://m4.licdn.com/mpr/mpr/shrink_80_80/p/2/000/05f/1ef/1c3c4a3.jpg 40 100 1967 Said Salomon Personal Sponsor http://www.sqlbouncer.com http://i1237.photobucket.com/albums/ff476/DrOlemit/43630045.jpg 40 100 2069 Boris Personal Sponsor http://www.linkedin.com/profile/view?id=67258654locale=en_UStrk=tyah http://m4.licdn.com/mpr/mpr/shrink_100_100/p/4/000/148/0b1/186e885.jpg 40 100 2101 Mark Kromer Personal Sponsor http://mssqldude.wordpress.com http://m4.licdn.com/mpr/mpr/shrink_80_80/p/1/000/125/098/0b1e03d.jpg 40 100 2186 OpenTV/Nagra Personal Sponsor http://www.linkedin.com/profile/view?id=14982979trk=tab_pro http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/Pat_Reiter.jpg 40 100 1745 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1753 StrateSQL Blog Sponsor http://jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 1843 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 6802 Mark Kromer BI Franklin Lab With the growing number of mobile users, requirements for browser-based BI and the lower TCO of cloud-based solutions, Cloud BI is becoming a dominate topic in the business intelligence world. In this session, I will demonstrate how to create a complete working Microsoft BI application that is cloud-based using SQL Server, SQL Azure, PowerPivot and Silverlight. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 6812 Wayne Sheffield DBA\Dev 30th Street This code filled session examines several additions to recent versions of SQL Server. These tools allow you to perform minimally invasive surgery on your code and gain performance! Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops! 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 6822 Justin Dearing DBA II MRP 1 NoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there's not RELATIONAL in DBA. On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database. On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to. 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 6844 Dan Clark BI 2012 EBC With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine. To use the new Vertipaq engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to query the data, create calculations, measures, and KPI’s.This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded). We will import data from a SQL Server relational database into a tabular model project and create relationships between the tables. We will use DAX to create and manage calculations, measures, and Key Performance Indicators 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 6868 Karen Lopez DBA\Dev 30th Street Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as 'Who does what?', 'Why are we doing this?', 'Do I have to Use a GUI?' and 'Just who do you think you are?'. Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment. 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 6869 Karen Lopez Prof Dev Berwyn Career Success in Data Management during Turbulent Timesa; A workshop on issues and ideas that today's data professionals can do to build their careers and networking skills with other data management professionals. Workshop topics will include:• Demonstrating your expertise• Building a portfolio of your success stories• Getting others to sell your skills and business value• Building extending your data management skill set• 10 Steps to highlighting you and your workBring your thoughts, ideas, and experiences. 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 7129 Robert Pearl DBA II MRP 1 In my session, I will offer some practical tips and tricks on a wide-array of Index Analysis methods that will allow you to find out everything about a client's indexes and were afraid to ask! What better way to optimize the performance of the database than talk about their indexes. What do you need to know in order to make these suggestions, and implement them. This session will cover the basics on indexes, and then demonstrate ways to improve DB performance. Missing Indexes, Duplicate Indexes, Fragmented Indexes, Covering Indexes, Clustered Nonclustered indexes, and the queries that love them. I will also demo ways in which you can correlate the worst performing queries with missing indexes. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 7498 Mark Wojciechowicz BI/Dev Paoli This session will demonstrate how to use database projects (aka DBPro and DataDude) for managing and synchronizing database schemas between environments. If you develop databases, today, or administer changes and have not used database projects before, this is the session for you. Database projects offer a great set of tools for detecting schema changes and automating the scripting process. This session will help database developers learn the basics of the database toolset and help DBAs understand the output. In addition, we will cover test driven development and look at how to avoid common pitfalls when making schema changes. 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 7499 Mark Wojciechowicz BI 2012 EBC Based on the teaching of the Kimball Group and Jack Olsen, learn about what data quality is and how to manage it in a data warehouse project. See how Data Quality Services (DQS) fits into the cleansing and conforming steps of an ETL and how these new tools create a huge leap forward in how the organization can take active responsibility over their data. This session will give hands on examples of common data quality problems and how to address them. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 7562 Kathy Gibbs DBA II MRP 1 SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data. 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 7654 Joshua Feierman DBA I MRP II As a DBA there is a lot of simple, step-by-step work that has to be completed on a daily basis. And while it's obviously a necessary part of our job, it's not fun and it takes away from time we could spend doing more important, less urgent work. One attractive option is delegating work to others, thus allowing the DBA to focus on more attractive / important tasks. But how do we do so without compromising security or best practices? Using the tips and tricks presented in this session, you'll be able to spread your workload to junior personnel while still maintaining a sound security / audit model. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 7696 Mike Hillwig DBA II MRP 1 Mike Hillwig has ten rules for managing a SQL Server environment regardless of the size. His rules cover things from server configurations to planning for a disaster and a few things that should never be done. 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 7733 Ron Johnson DBA II MRP 1 Creating a Performance Baseline for a SQL Server should be the first task any DBA accomplishes when inheriting the instance. The Performance Baseline provides a starting point for any performance optimization efforts, a point of reference for future performance comparisons, and documents the server and instance configuration. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 7784 Mark Hudson BI Franklin Lab Whether predicting customers, All Stars or concert set lists, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought. 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 7786 Mark Hudson BI Franklin Lab Columbus demonstrated the world was not flat. Our Address table suggests events occurred at a particular location. SQL Server 2008 supports geospatial data. SQL Server 2008 R2 provides the United States map gallery. Come see how Reporting Services leverages those knowns to present our data in a geographical way. 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 7995 Chuck Rivel BI 2012 EBC This session will cover how one can create a PerformancePoint Services Dashboard using a SQL Server 2012 BI Semantic Model. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 8048 Christina Leo Development Wynnewood Creating a query plan can be a time consuming and expensive process. To avoid repeating these potentially costly steps unnecessarily, SQL Server stores its query plans, in the plan cache where they can be reused as needed. In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation. 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 8049 Christina Leo DBA\Dev 30th Street You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you. First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 8103 Kevin Goff BI/Dev Paoli It's one thing to know how to write basic MDX code (and that's certainly important). It's another to know how to incorporate MDX into SSRS applications, PerformancePoint Services applications, and other BI applications. In this presentation, I'll show some of the intricacies, issues, and workarounds for using MDX code in OLAP applications. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 8104 Kevin Goff Development Wynnewood That's right, attendees choose! I'll show 20 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 20 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 8268 Josef Richberg BI/Dev Paoli Learn some of the quirks and capabilities of SSIS. Learn about the pitfall of 'parallel path choicing'. Use the Script Component as a data source (to solve complex sourcing issues) and as a data destination (to get around the identity column conundrum). See how use Script Tasks to build directory scanners for efficient file import techniques. Learn how to build and use Named Pipes to improve workload performance. We'll also go over some the tunable properties of the Data Flow object. 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 8272 Jason Thomas BI/Dev Paoli SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level. 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 8323 John Sterrett DBA I MRP II If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag. 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 8408 Jeff Leidy BI Franklin Lab Overview and demonstration of steps required to expose PowerPivot/SharePoint to mobile devices. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 8518 Kevin Bucher BI Franklin Lab Built on top of the BI Semantic Model, Power View gives the users of all levels a powerful yet simple to use experience. Power View provides interactive, browser-based data exploration and visualization - this presentation will walk through the basics of Power View, use cases, and a demonstration. 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 8625 Adam Belebczuk DBA I MRP II One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you're just curious about AlwaysOn, then you won't want to miss this session. 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 8627 Adam Belebczuk DBA\Dev 30th Street In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 8629 Bill Wolff BI/Dev Paoli SharePoint is a collaboration, document management, and solution delivery platform built on .NET, SQL Server, and Active Directory. This talk explains how SharePoint uses SQL Server to store content, configuration, and logging data. For databases that are not native to SharePoint, Business Connectivity Services provides a seamless forms over data experience. SharePoint is used extensively for Business Intelligence where it becomes the user interface for Reporting Services, PowerPivot, and Performance Point. We will also look at how SQL Server 2012 affects the SharePoint ecosystem. 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 8662 Sebastian Meine DBA\Dev 30th Street This presentation looks behind the scenes of how SQL Server physically organizes the data on disk. We will talk about Heaps, B+Trees, RIDs, Keys, Seeks and Scans. The materials covered will allow you to make a more informed decision about what type of index to use when. 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 8666 Dominic Falso Development Wynnewood Using the .NET API, we'll design and run existing packages, and create a new one. We'll discuss the different objects a package contains, see how to query a package's contents, and how to edit field-level component transformations. 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 8693 William Emmert DBA II MRP 1 In this session you will be introduced to the new and enchanced SQL Server High Availability and Disaster Recovery features in SQL Server 2012. I will demo the setup of an AlwaysOn Availability Group and show how an application can automatically reconnect following a failover. Additionally, I will show how to configure read-only secondaries and demonstrate the use of prioritizing the secondaries for access. 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 8705 Alex Grinberg Development Wynnewood This is 100% code session, where presenter will demonstrate system development live cycle. Starting from a database stored procedure and go to the user interface to display a result. Down the road I’ll demonstrate different techniques, how to create a stored procedure calling class from SQL Server using system tables. How to pass to the stored procedure different parameter types, such as XML or ADO.NET DataTable. 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 8708 Dennis Lloyd Jr Development Wynnewood It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 8714 Hope Foley BI 2012 EBC The BI world is all coming together as one to have hold and cherish in the BI Semantic Model. We will discuss that and what it means and dive into PowerPivot 2012. Will go over some oldie but goodies from v1 as well as heavily highlight some of the most anticipated new features. We will create together a real world scenario to help solve my own BI problems. Learn to crank out some uber snazzy reports that will knock your boss's KPIs off! 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 8721 Erin Stellato DBA I MRP II There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 8722 Erin Stellato DBA\Dev 30th Street The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge. 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 8725 Joseph D'Antoni Prof Dev Berwyn Did you know that as of June 30th the model for licensing SQL Server is changing? Learn about what these changes mean to you and your IT organization. We will discuss the impact to hardware architecture, virtualization environments, and DR. Understand the strategies you are your organization can take to minimize the financial impact of these licenses changes. 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 8727 Muthu Ramanathan Development Wynnewood SQL Server is a developer platform. The experience you get from this platform depends on how you leverage the platform. In this session, we will talk about some live performance scenarios including CPU starvation, High Memory consuming Queires, SQL Server Caches, I/O Intensive Queries by walking through some live examples. This will be all examples, few slide interactive session that talks about SQL Server performance tuning, using some of the native tools thats comes out of the box. We will finish by getting into SQL Server 2012 Extended Events introduction and how better troubleshooting gets in SQL 2012 and .NET 4.5. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 8728 A.J. Mee BI 2012 EBC Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including: · Power View · BI Semantic Model (BISM) · Data Quality Services · Master Data Management · Columnstore Index 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 8738 Jessica Moss BI 2012 EBC Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one. 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 9209 Panel Discssion Prof Dev Berwyn So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel. 6/9/2012 4:00:00 PM 6/9/2012 5:00:00 PM 9210 Lunch Lunch Prof Dev Berwyn Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9210 Lunch Lunch BI 2012 EBC Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9210 Lunch Lunch BI/Dev Paoli Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9210 Lunch Lunch BI Franklin Lab Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9210 Lunch Lunch DBA I MRP II Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9210 Lunch Lunch DBA II MRP 1 Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9210 Lunch Lunch Development Wynnewood Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9210 Lunch Lunch DBA\Dev 30th Street Lunch 6/9/2012 12:00:00 PM 6/9/2012 1:30:00 PM 9211 Allen White DBA I MRP II Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform. 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 9212 Brian Moran Prof Dev Berwyn Leadership coaching is the practice of using relational influence, the people kind, not the database kind J, to develop and empower leaders. You might be in a position of leadership today. You might be in a position of leadership tomorrow. Either way; we all have opportunities to lead in different ways as we go about our lives and careers. Learn some simple techniques that can help you lead through conversation. 6/9/2012 8:30:00 AM 6/9/2012 9:30:00 AM 9217 WIT WIT Prof Dev Berwyn An interactive discussion on diversity and gender in the IT and data profession. Panelists Erin Stellato, Karen Lopez, and Hope Foley will discuss issues such as: - is diversity an issue we should be concerned with? - what do our daughters think about IT careers? - Why are fewer women considering IT careers? - Why are women leaving the profession a a higher rate? - What can we as individuals do about this? - What, if anything, should PASS be doing about it? Questions and comments from attendees will be the primary focus of this session, so have your opinions ready. This session is not just for women; all attendees are welcome to participate. 6/9/2012 11:00:00 AM 6/9/2012 12:00:00 PM 9218 Mark Kromer BI/Dev Paoli For SQL Server DBAs experienced in managing OLTP environments, managing a large DW SQL Server environment can present a whole new set of challenges. In this session, we will discuss ways to overcome and prepare for those challenges and the different ways that a DBA must interact with SQL Server and the associated BI tools to ensure a successful data warehouse environment. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 9355 Paul Rizza BI Franklin Lab Shortcuts to Building SSIS in .Net 6/9/2012 2:45:00 PM 6/9/2012 3:45:00 PM 9638 Vince Napoli Prof Dev Berwyn In this intro level session, we'll look at the basics of building a working SSAS Cube, and the basics of MDX calculations. In constructing a working cube, we will cover key concepts for Analysis Services and MDX, and show you how to construct a basic cube and regular dimension, and a calculated member for Analysis. We will pack as much information into this session so as to allow you to take away enough to be able to start building cubes and metrics on your own. 6/9/2012 1:30:00 PM 6/9/2012 2:30:00 PM 9782 Allen White DBA I MRP II We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 6/9/2012 9:45:00 AM 6/9/2012 10:45:00 AM 9913 Kathy Gibbs DBA II MRP 1 Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. Kathy will use real-life case studies to demonstrate the techniques. 6/9/2012 12:45:00 PM 6/9/2012 1:15:00 PM 10039 Pat Latorra DBA I MRP II This interactive session presents reference architectures and actual IT case studies for integrating Solid State Disk (SSD) into existing storage infrastructures to boost performance and enable virtualization especially in big data environments where data volumes are growing rapidly, and applications and users are demanding high-speed concurrent access. Attendees will see how large database environments can be more strategic in their deployment of SSD and reap 10-fold performance acceleration without the need to reconfigure or move applications or data, without forklift hardware upgrades, and without changing data protection policies. This session will allow one-on-one Q A with a technical architect. 6/9/2012 12:45:00 PM 6/9/2012 1:15:00 PM