SQLSaturday #154 - St. Louis 20129/15/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. #sqlsat1545 Jackson AvenueCenter for Application of Information technology (CAIT) at Washington University in St.LouisClaytonMO631052392Covenant Technology Partnershttp://www.covenanttechnologypartners.comhttp://www.sqlsaturday.com/files/db024a5f-3814-4fa3-b772-eb7990709904.jpg601702400Pragmatic Workshttp://pragmaticworks.com/http://pragmaticworks.com/images/logo/PragmaticWorksLogo.jpg601702403Technology Partners, Inc.http://www.technologypartners.net/http://1.bp.blogspot.com/-CVYNG4RNaiQ/T-TVmWslsPI/AAAAAAAAACc/M0oOpkNxE6I/s320/tpi170x60.jpg601702443Oakwood Systems http://www.oakwoodsys.comhttp://www.sqlsaturday.com/files/02c340ac-8120-4d3e-8d92-2a01392b8c76.png601702379CAIT - Washington University in St Louishttp://www.cait.wustl.edu/http://www.sqlsaturday.com/files/12b6f876-3101-420b-abd7-320d06db4bcd.jpg401002385SyllogisTekshttp://www.syllogisteks.comhttp://www.syllogisteks.com/images/syllogisteksLOGOstacked%20copy.jpg601702601Fusion-iohttps://www.fusionio.comhttp://www.sqlsaturday.com/files/6b15396e-6586-4c1a-9ceb-5041e299ca5a.png601702546Melissa Datahttp://www.melissadata.comhttp://www.melissadata.com/images/mdlogo-color-tag-170x60.gif601702338Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702376Quest Softwarehttp://www.quest.com/http://www.quest.com/images/common/quest_logo.gif601702272CozyRochttp://www.cozyroc.comhttp://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601702568Microsoftwww.microsoft.comhttp://www.sqlsaturday.com/files/3aac5a61-0835-4669-b428-412136653452.jpg601702329Steve Hughes - Data on Wheelshttp://www.dataonwheels.comhttp://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png401002642SAPIEN Technologieshttp://www.SAPIEN.comhttp://www.sqlsaturday.com/files/f91073b7-227b-45ff-8ec7-3a7c78125b08.png401002647Wrox Presshttp://www.wrox.com/http://www.sqlsaturday.com/files/47884842-f76c-4a3a-b2df-8c404a93ca86.jpg401002668Redgatehttp://www.red-gate.com/http://www.red-gate.com/assets/images/common/logo.png4010011174Aaron NelsonAaron Nelson is a Senior SQL Server Architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server.He has experience managing enterprise-wide data needs in both transactional and data warehouse environments. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer.@http://twitter.com/sqlvarianthttp://www.linkedin.com/in/sqlvarianthttp://sqlvariant.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant484810155Andy GalbraithAndy aka Abhi has several years of BI experience including planning, design, development and implementation in business database applications.Andy has worked primarily as a consultant holding positions primarily in the Energy,Banking,Media,Consulting. Currently Working on Cloud development Project.@Andythiruhttp://www.linkedin.com/in/dbaandyhttps://api.twitter.com/1/users/profile_image?screen_name=@Andythiru484810921Arie JonesArie Jones 'AJ' is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis Indiana. Arie has over 10 years experience in SQL Server, Oracle, and .NET development. His main role consists of providing clients with high level BI, database, and application development solutions while mentoring PTI’s extensive staff of consultants on new technologies. Additionally, AJ is a community speaker, has written several books, and blogs extensively at http://www.programmersedge.com .@programmersedgehttp://www.linkedin.com/in/ariejoneshttp://www.programmersedge.comhttps://api.twitter.com/1/users/profile_image?screen_name=@programmersedge48489100Bill FellowsBill has been a professional developer for the past 13 years and has had the pleasure and pain of working with a variety of RDBMS. He's been involved with SQL Server since 2000 and has lost far too many hairs to DTS and SSIS, He was the organizer of SQL Saturday 53 and 101. When not milking yaks or fighting crime, Bill finds himself employed as the lead database developer for an undisclosed entity in the Kansas City, Missouri area.@billinkcbillinkchttp://blog.billfellows.nethttps://api.twitter.com/1/users/profile_image?screen_name=@billinkc484810158Brian FlynnBrian Flynn has been working in IT since his college days in 1995, beginning as a desktop support technician. Since graduating with a Computer Science Mathematics degree from SLU in 1999, he has served in many roles such as web and database development, administration and system engineering of multiple disciplines including web, database, mail and networking. He has been functioning in management capacities since 2008 and enjoys promoting social interaction and team building among I.T. pros.@brianpaulflynnhttp://www.linkedin.com/in/brianpaulflynnhttps://api.twitter.com/1/users/profile_image?screen_name=@brianpaulflynn484810034Dan GuzmanDan is a Database Solution Architect at a major online brokerage firm. He's been using Microsoft SQL Server since version 4.21 was introduced on the Windows platform and has over 25 years of experience in Database Administrator/Developer roles. http://weblogs.sqlteam.com/dang484810925Dave FacklerDave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouse environments, exploiting SQL Server enterprise database features, standard design principles, and industry best practices. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each yearhttp://www.linkedin.com/in/davefacklerhttps://api.twitter.com/1/users/profile_image?screen_name=484810138David KleeDavid Klee (@kleegeek) is a SQL Server performance and virtualization expert. With over fifteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis.@kleegeekhttp://www.linkedin.com/in/davidakleehttp://davidklee.nethttps://api.twitter.com/1/users/profile_image?screen_name=@kleegeek484811172Eddie Hendrix I am currently a SQL Server Technical Sales Professional for Microsoft. I have been a Database Professional in the St. Louis market for 8+ years working with many different database technologies for many different organizations. @STLSQLGUYhttps://api.twitter.com/1/users/profile_image?screen_name=@STLSQLGUY484810808Hima NagisettyHima is a SQL Server professional with extensive experience in designing, developing, testing and supporting database solutions. She is working as a Development DBA for a financial firm in Saint Louis. She started of working with SQL Server 2000 about 7 years ago. She has played the roles both database developer and administrator and specifically enjoys being the database safeguard.48489349Ira WhitesideInformation Technology professional with over 30 years of industry experience , Hands on experience in using Microsoft SQL Server 2005/2008 tools, including SSIS, SSAS, SSRS (Microsoft Reporting Services) MDM (Master Data Services) and Data mining. In addition, have written and blogged several Articles for SQL Server Central and other publicationsas BI as well as videos for PASS Virtual BI.@irawhitesidehttp://www.linkedin.com/in/irawarrenwhitesidehttp://irawarrenwhiteside.comhttps://api.twitter.com/1/users/profile_image?screen_name=@irawhiteside484810015Janis GriffinJanis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Prior to Confio, Janis held DBA positions in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis was Principal Architect and Sr. Manager, mentoring other DBAs on best practices in database performance tuning.@DoBoutAnythinghttp://www.linkedin.com/pub/janis-griffin/0/914/abahttps://api.twitter.com/1/users/profile_image?screen_name=@DoBoutAnything484810324Jeff FatticJeff Fattic has been employed in IT in some fashion for over 10 years. Most of his career, he’s been a software developer on the Microsoft stack, but about five years ago, he began studying Application Lifecycle Management tools and processes. Jeff recently joined Microsoft as a Developer Technology Specialist helping customers be more successful with developer tools. He is a co-founder and board member of the St. Louis Days of .NET conference.@JeffFattichttp://www.jfattic.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@JeffFattic484810065Kathi KellenbergerKathi Kellenberger is a Sr. consultant with Pragmatic Works. She is author of 'Beginning T-SQL 2008' and co-author of 'Beginning T-SQL 2012', 'Professional SQL Server 2005 Integration Services' and 'SQL Server MVP Deep Dives'. She has spoken at several conferences including SQL PASS, Day of .Net, SQL Rally and many SQL Saturdays. @auntkathihttp://www.linkedin.com/in/kathikellenbergerhttp://www.bidn.com/blogs/kathikhttps://api.twitter.com/1/users/profile_image?screen_name=@auntkathi484810755Kevin BolesKevin is a SQL Server expert, working exclusively with the product since version 6.5. With almost 20 years of database experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 years. His passion is the relational engine, especially scalability, performance analysis and tuning.@TheSQLGuruhttp://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru484810391Melissa MeyerMelissa is a Senior Developer at Covenant Technology Partners and a Microsoft Certified IT Professional. Melissa works with the Microsoft BI stack to deliver data and BI solutions of all shapes and sizes to our clients. Melissa is passionate about all things data and about making the data work for you. In her spare time, Melissa is an avid outdoors woman who enjoys hunting, gardening and spending time with family and friends.http://www.covenanttechnologypartners.com484810639Rick NuunnI have 20 years of experience in all areas of the application development life cycle; the last 15 years in database development as a Database Architect.I have designed, developed, implemented, created and delivered training on systems I have designed.I have been involved in the evolution of small shops into large enterprises.I have been involved in successes and witnessed failures as IT shops search for better ways to design and build databases.I hope to share some of my experiences.48489213Scott ShawScott Shaw has been an IT professional since the late 90’s. He is currently employed by Oakwood Systems in Saint Louis, MO as a Solutions Architect. Scott has presented at various SQLSaturdays and other PASS events. In 2011 he was a finalist for the RedGate DBA of the Year award.@shawsqlhttp://www.linkedin.com/in/scottpshawhttp://www.dbaexperience.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@shawsql484811209SQL Saturday #154 SQL Saturday #154SQL Saturday #154 Raffle Closing48489098SQLSatruday #154lunch@SQLSuperguruhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLSuperguru48489678Travis WhitleyTravis is a MS SQL Server consultant and has worked with databases since 2002. He has had the honor of presenting at past SQLSaturday events in Kansas City and at the Greater Midwest SQL Relay in St. Louis.@DBAconsortiumhttp://whitleysql.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@DBAconsortium48489103Wendy PastrickSQL Server DBA for 10+ years working SQL Server. Works closely with development teams to see application development through the entire lifecyle. Also has experience with Transactional and Merge Replication along with High Availability and Disaster Recovery planning and implementaiton. @wendy_dancehttp://www.linkedin.com/in/wendypastrickhttp://wendyverse.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@wendy_dance484890989098SQLSatruday 154Room 021Coffee Break9/15/2012 3:00:00 PM9/15/2012 3:15:00 PM90989098SQLSatruday 154Room 021Coffee Break9/15/2012 9:45:00 AM9/15/2012 10:00:00 AM90989098SQLSatruday 154Room 021Coffee Break9/15/2012 11:15:00 AM9/15/2012 11:30:00 AM90989098SQLSatruday 154Room 143Coffee Break9/15/2012 3:00:00 PM9/15/2012 3:15:00 PM90989098SQLSatruday 154Room 143Coffee Break9/15/2012 9:45:00 AM9/15/2012 10:00:00 AM90989098SQLSatruday 154Room 143Coffee Break9/15/2012 11:15:00 AM9/15/2012 11:30:00 AM90989098SQLSatruday 154Room 024Coffee Break9/15/2012 3:00:00 PM9/15/2012 3:15:00 PM90989098SQLSatruday 154Room 024Coffee Break9/15/2012 9:45:00 AM9/15/2012 10:00:00 AM90989098SQLSatruday 154Room 024Coffee Break9/15/2012 11:15:00 AM9/15/2012 11:30:00 AM90989098SQLSatruday 154Room 025Coffee Break9/15/2012 3:00:00 PM9/15/2012 3:15:00 PM90989098SQLSatruday 154Room 025Coffee Break9/15/2012 9:45:00 AM9/15/2012 10:00:00 AM90989098SQLSatruday 154Room 025Coffee Break9/15/2012 11:15:00 AM9/15/2012 11:30:00 AM90989098SQLSatruday 154Room 028Coffee Break9/15/2012 3:00:00 PM9/15/2012 3:15:00 PM90989098SQLSatruday 154Room 028Coffee Break9/15/2012 9:45:00 AM9/15/2012 10:00:00 AM90989098SQLSatruday 154Room 028Coffee Break9/15/2012 11:15:00 AM9/15/2012 11:30:00 AM91009100Bill FellowsRoom 021Kama Sutra of SSIS: A guide to loving ETLSlow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.9/15/2012 3:15:00 PM9/15/2012 4:30:00 PM91019101Bill FellowsRoom 0282012 TSQL SweetsThe 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.9/15/2012 10:00:00 AM9/15/2012 11:15:00 AM91039103Wendy PastrickRoom 024Read Dirty to Me - Isolation Levels/User ImpactIssue a 'SELECT {data} FROM {myTable}' statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.9/15/2012 11:30:00 AM9/15/2012 12:45:00 PM91049104Wendy PastrickRoom 025Transactional Replication 101Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.
We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.9/15/2012 1:45:00 PM9/15/2012 3:00:00 PM92139213Scott ShawRoom 021Cubicle to ConsultingWhat you do for a living may say a lot about who you are. No where is this as true as in IT. How you learn, how you grow, your passions, and your goals can all be reflected in your job. There are many ways your skills can be delivered and you need to choose the best fit for who you are. This session aims to take an unbiased look at the difference between working in a solid, stable IT environment or trekking out and offering your skills as an IT consultant. The differences are staggering and each has their risks and rewards. Each role has its own myths and, like most myths, some are true and some are not. This session will draw on real-world experience and won't hesitate to point out the successes as well as the failures.
9/15/2012 11:30:00 AM9/15/2012 12:45:00 PM92169216Scott ShawRoom 028SQL Server in HealthcareDid you know Microsoft started a new company dedicated to healthcare? Did you even know Microsoft has an electronic health records product and a large suite of security products specifically focused on healthcare solutions? You may not know it but healthcare is driving today's technology. Everything from business analysis, security, and tele-communications is focusing on healthcare solutions. Even Microsoft Kinect is getting in the act. Where there is growth, there is opportunity. This session will define the lingo and point out the trends in order to demystify the industry. I'll start with the big picture and drill down to the specifics. Together we'll navigate the trends and get excited about where all of this is going.
9/15/2012 8:30:00 AM9/15/2012 9:45:00 AM93499349Ira WhitesideRoom 028Creating a Metadata Mart w/ SSIS - Data GovernanceThis is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.9/15/2012 11:30:00 AM9/15/2012 12:45:00 PM96789678Travis WhitleyRoom 021Behind the Scenes: SQL Server StatisticsAn informative, entry level session regarding SQL Server statistics and the importance of their accuracy. The presentation will cover, in detail, the statistics object - how they are generated and how the optimizer utilizes them, along with some foundation SQL Server internals principles. Examples will be provided that construct situations where the optimizer chooses poor execution plans due to issues with statistics. Finally, a free stored proc will be provided that allows for comprehensive statistics management by the DBA.
9/15/2012 10:00:00 AM9/15/2012 11:15:00 AM1001510015Janis GriffinRoom 143Looney Tuner? No, there IS a method to my madnessSQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.9/15/2012 11:30:00 AM9/15/2012 12:45:00 PM1001910019Janis GriffinRoom 025Don't Panic, DBAs! Databases on VMware made easy.More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 9/15/2012 3:15:00 PM9/15/2012 4:30:00 PM1003410034Dan GuzmanRoom 024Maximizing SQL Server Insert PerformanceThis session describes how to maximize throughput for high-volume insert applications using both programming and database server techniques. Performance of bulk insert and table-valued-parameter methods will be contrasted with traditional insert methods.
9/15/2012 8:30:00 AM9/15/2012 9:45:00 AM1006510065Kathi KellenbergerRoom 024SQL Server 2012 T-SQLHave you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!9/15/2012 3:15:00 PM9/15/2012 4:30:00 PM1013810138David KleeRoom 025Database Health and PerformanceSure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.9/15/2012 8:30:00 AM9/15/2012 9:45:00 AM1015510155Andy GalbraithRoom 143Maintain Your DBs with Help from Ola HallengrenOne of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.9/15/2012 1:45:00 PM9/15/2012 3:00:00 PM1015810158Brian FlynnRoom 028Pivoting Performance Data Pinpointing ProblemsHave you ever been wrought with end user complaints of database performance issues only to open your tools that show only live performance or limited historical performance and find no answers? After being bit by this many times, I developed my own eye in the sky to monitor CPU Physical IO at the database, user and application levels. This solution logs data continuously and parses it into an Analysis Services cube which can be queried by Excel. No need to requisition funds for 3rd party tools. You can do this with the tools you have and I’ll give you the scripts to get started. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels.9/15/2012 3:15:00 PM9/15/2012 4:30:00 PM1032410324Jeff FatticRoom 025Your Database Code is in My TFS!Tooling for application developers has always surpassed those available for database developers. Microsoft now provides tools that give database developers some love: get database code into source control, branch for concurrent development, automate builds and deployments, refactor, and so much more.9/15/2012 10:00:00 AM9/15/2012 11:15:00 AM1039110391Melissa MeyerRoom 021SQL 2012 Integration with SharePointThis session will showcase what is new in the BI arena in SQL 2012, focusing on BI in SharePoint. Discussion will be centered around Power View, SSRS, PowerPivot 2.0 and the new Tabular Model. Learn what each tool can do and when to use them. 9/15/2012 8:30:00 AM9/15/2012 9:45:00 AM1063910639Rick NuunnRoom 021Database Design Done RightFrom beginning to end application development is upside down. So much emphasis is placed on the front end and so little on the analysis of database structure that many application development projects fail to achieve the goals set by the business. This presentation uses an interwoven analogy to illustrate the process currently used by most enterprises, the results, and the short comings. Yet with a change of focus, the same projects can not only be successful; they can be done under budget, with greater flexibility and extensibility. Future projects can benefit from this change of focus with additional savings in timelines and fewer bug fixes downstream. Any business person or data professional who works directly with business people c9/15/2012 1:45:00 PM9/15/2012 3:00:00 PM1075510755Kevin BolesRoom 024Common TSQL MistakesWe are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over a dozen times now and it is always very highly rated!9/15/2012 1:45:00 PM9/15/2012 3:00:00 PM1080810808Hima NagisettyRoom 143SQL Server Detective Duo – Change Tracking and CDC'Change 'is the only constant. It is the undoubted truth for data in our world of OLTP databases. Most of us are required to implement an array of solutions to track data changes, for reasons ranging from simple logging to complex regulatory compliance. So the important question is, how best can tracking be done? To help you make the right choice, this session will list and demonstrate some Change Tracking mechanisms. Some of the highlights will be SQL Server Change Tracking and Change Data Capture (CDC) features.9/15/2012 3:15:00 PM9/15/2012 4:30:00 PM1090110901Andy ThiruRoom 028Windows Azure SQL database Intro and what’s NewWindows Azure provides many options for storing data. Windows Azure SQL Database is one of the Windows Azure’s solution for working with relational data. If you are familiar with SQL Server, SQL Azure will be a natural extension of your knowledge and skills. In this session, you will get introduced to: Windows Azure SQL Database and learn how to get started.We will explore how to migrate an existing on-premise SQL Server database to Windows Azure SQL Database. We will then walkthrough how to manage and administer your Windows Azure SQL servers and databases. We will take a look at how to connect and build applications using Windows Azure SQL. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azu9/15/2012 1:45:00 PM9/15/2012 3:00:00 PM1092110921Arie JonesRoom 024PWNED! Security, SQL Server, and You!With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it's better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We'll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help in figuring out what is going on. It'll be AWESOME!9/15/2012 10:00:00 AM9/15/2012 11:15:00 AM1092510925Dave FacklerRoom 143Get Ready for SSIS in SQL Server 2012!With the next release of SQL Server, BI developers and database professionals need to know what's available and how to take advantage of new features and capabilities. During this session, we'll drilldown on the next release of SSIS and discuss development improvements, the new deployment model, and better managability options. Along the way, we'll look at new SSIS features including project parameters, shared connection managers, team-based development improvements, and a brand new deployment model with significantly improved management features. Come see some of the exciting changes now available in your favorite data integration tool!9/15/2012 10:00:00 AM9/15/2012 11:15:00 AM1117211172Eddie Hendrix Room 025Microsoft's Monitoring Options for SQL ServerA look at different options for monitoring and debugging your SQL Server environment. We'll start from low level and work our way to enterprise level options. We'll look at traces flags, logs, data collectors, utility control points, and up to system center. 9/15/2012 11:30:00 AM9/15/2012 12:45:00 PM1117411174Aaron NelsonRoom 143Time Saving Tips Tricks for SSMS 2012SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!9/15/2012 8:30:00 AM9/15/2012 9:45:00 AM1120911209SQL Saturday #154 SQL Saturday #154Room 021SQL Saturday #154 RegistrationSQL Saturday #154 Registration9/15/2012 8:00:00 AM9/15/2012 8:30:00 AM1121011210SQL Saturday #154 SQL Saturday #154Room 021SQL Saturday #154 Raffle ClosingSQL Saturday #154 Raffle Closing9/15/2012 4:30:00 PM9/15/2012 5:00:00 PM1150811508SQLSatruday #154Room 021LunchLunch9/15/2012 12:45:00 PM9/15/2012 1:45:00 PM1150811508SQLSatruday #154Room 143LunchLunch9/15/2012 12:45:00 PM9/15/2012 1:45:00 PM1150811508SQLSatruday #154Room 024LunchLunch9/15/2012 12:45:00 PM9/15/2012 1:45:00 PM1150811508SQLSatruday #154Room 025LunchLunch9/15/2012 12:45:00 PM9/15/2012 1:45:00 PM1150811508SQLSatruday #154Room 028LunchLunch9/15/2012 12:45:00 PM9/15/2012 1:45:00 PM