SQLSaturday #105 - Dublin 20123/24/2012 12:00:00 AM(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, LondonSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat105Hilton HotelCharlemount PlaceDublin, Ireland21640Prodata SQL Centre of Excellencehttp://www.prodata.iehttp://www.prodata.ie/images/Prodata_Logo.jpg601701674Microsofthttp://www.microsoft.com/ireland/about/http://i.microsoft.com/global/about/legal/en/us/PublishingImages/mslogo_black_2.gif601701712Redgate Softwarehttp://www.redgate.comhttp://www.sqlsaturday.com/images/resized - redgate_logo.png601701723SQL Sentryhttp://www.sqlsentry.net/sqlsaturday105http://www.sqlsentry.net/UI/customMenu/headLogo.png601701759DNM Technologyhttp://www.dnm.iehttp://www.dnm.ie/images/dnmlogofull.gif601701780Spanish Point Technologies Ltdhttp://www.spanishpoint.iehttp://www.spanishpoint.ie/Image/SPLogo.png601701801CXC - The Specialist Accountants for Contractorshttp://www.cxc.iehttp://www.cxc.ie/images/cxc_logo_large_trans.gif601702095Questhttp://www.quest.comhttp://www.quest.com/images/common/quest-logo.gif601702134Iderahttp://www.idera.comhttp://www.idera.com/images/Logo-Idera.png401001968O'Reillyhttp://oreilly.com/http://cdn.oreilly.com/images/sitewide-headers/ml-header-home-blinking.gif401001969McGraw Hillhttp://www.mcgraw-hill.co.uk/http://www.mcgraw-hill.co.uk/images/hdr_home_logo.gif401006648Aaron BertrandAaron is Senior Consultant at SQL Sentry, Inc. He has been a Microsoft MVP since 1997, has spoken at several user group meetings and SQL Saturday events, and blogs at SQLBlog.com (http://sqlblog.com/blogs/aaron_bertrand/).@AaronBertrandhttp://sqlsentry.net/https://api.twitter.com/1/users/profile_image?screen_name=@AaronBertrand48486599Allan MitchellAllan is the joint owner of Copper Blue Consulting Ltd. Copper Blue Consulting focus on getting the right data to the right people at the right time and in the right format. We are passionate about data integrity and suitability. We have worked all over the world in a variety of industries and on projects both large and small. We specialise in Extract, Transform and Load Complex Event Processing Master Data Management Data Visualisation Operational and Predictive Analytics.@allanSQLIShttp://uk.linkedin.com/pub/allan-mitchell/1/b4/5a9http://www.copperblueconsulting.comhttps://api.twitter.com/1/users/profile_image?screen_name=@allanSQLIS48486545Andre KammanI'm a Dutch SQL Server consultant. Having worked as a DBA on 400+ instances for the past couple of years. I'm on a datawarehouse project right now where I find myself using SSIS mostly these days. I run the Dutch PASS chapter, and I'm a SQL Server MVP@andrekammanhttp://andrekamman.comhttps://api.twitter.com/1/users/profile_image?screen_name=@andrekamman48486639Bob BeaucheminBob Beauchemin is a database-centric application practitioner and architect, instructor, course author, writer, and Developer Skills Partner for SQLskills. Over the past few years he's been writing and teaching developer-centric classes on SQL Server 2005-2012 courses to students worldwide. He has authored books on SQL Server as well as numerous whitepapers, articles, and blog entries.@bob_duffyhttp://blogs.prodata.ie/https://api.twitter.com/1/users/profile_image?screen_name=@bob_duffy48486402Chris Testa-O'NeillChris Testa-O'Neill is a SQL Server Microsoft Most Valuable Professional(MVP) and a Senior Consultant at Coeo specialising in SQL Server Business Intelligence. He is also a technical author, working on courses for SQL Server 2008 R2 with Microsoft Learning and advising on the SQL Server 2012 curriculum. Chris runs the Manchester SQL Server User Group and is an organiser for SQLBits. Chris has spoken at a range of events around the world.@ctesta_oneillhttp://www.coeo.comhttps://api.twitter.com/1/users/profile_image?screen_name=@ctesta_oneill48485984Christina LeoChristina Leo works as a database developer for ProfitStars, a Jack Henry Company. She supports three development teams that create software for the banking industry. She actively participates in the SQL Server community, is part of the leadership team for the Nashville SQL Server User Group, volunteers with the PASS - Women in Technology Virtual Chapter, and holds an MCITP for SQL Server 2005 in Development and Administration. @christinaleohttp://www.linkedin.com/pub/christina-leo/a/839/9aahttp://christinaleo.nethttps://api.twitter.com/1/users/profile_image?screen_name=@christinaleo48486679Christopher WebbChris is a UK-based SQL Consultant and Microsoft MVP. He is a highly respected figure in the Microsoft Business Intelligence Community worldwide and has been working with Microsoft BI tools since 1998. Chris has extensive experience of implementing BI solutions on the Microsoft Platform across a broad spectrum of industries including pharmaceuticals, financial services, engineering, manufacturing, retail and market research.@Christopher Webb @technitrainhttp://uk.linkedin.com/pub/chris-webb/1/85/966http://cwebbbi.spaces.live.com/https://api.twitter.com/1/users/profile_image?screen_name=@Christopher Webb @technitrain48487917Committee MembersRegistration by various volunteers@gunngirl1https://api.twitter.com/1/users/profile_image?screen_name=@gunngirl148486617James BaldwinJames Baldwin
Cork, Ireland
Technical Manager, EMC Proven Solutions for Microsoft Applications
Evangilist and customer champion into EMC design teams. Architects solutions to assist customers and EMC field in deploying Microsoft Solutions through Technical papers, demonstration collateral and technical discussions.http://www.emc.com/sql48486155Jen StirrupJen Stirrup is a newly-awarded SQL Server MVP. She is an independent consultant who specialises in Business Intelligence, with a focus on Data Visualisation. Jen has conducted projects in the UK and mainland Europe. Jen has previously spoken at SQLBits, SQLPASS and other community events on the topic of Business Intelligence and Data Visualisation. She blogs regularly on these topics at www.jenstirrup.com and can be found tweeting at twitter.com/jenstirrup @jenstirruphttp://www.linkedin.com/in/jenstirruphttp://www.jenstirrup.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jenstirrup48486145Karen LopezKaren López is Sr. Project Manager and Architect at InfoAdvisors. As a Microsoft MVP, Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. She specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com. Karen wants you to Love Your Data.@datachickhttp://linkedin.com/in/karenlopezhttp://blog.infoadvisors.comhttps://api.twitter.com/1/users/profile_image?screen_name=@datachick48486908Kevin KlineKevin Kline is the technical strategy manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and past president of the international Professional Association for SQL Server (PASS). He has authored many books and is a top-rated speaker at such worldwide conferences as Microsoft TechEd, the Best Practice Conference, the PASS Community Summit, and DevConnections. Kevin writes regular columns in SQL Server Magazine and Database Tr@http://twitter.com/#!/keklinehttp://www.linkedin.com/in/keklinehttp://kevinekline.com/https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/#!/kekline48486609Klaus AschenbrennerKlaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008.@Aschenbrennerhttp://www.sqlpassion.athttps://api.twitter.com/1/users/profile_image?screen_name=@Aschenbrenner48485977Mark BroadbentMark Broadbent is a SQL Server specialist with over 14 years experience working with numerous HA solutions and is possibly the hardest drinking DBA on the planet. Mark is the SQLCambs Chapter Leader and has presented at SQLBits 7/ 8/ 9, SQLRally 1, SQLRelay and SQLPASS 2011 and has been awarded the Microsoft Community Contributor award in recognition of his contribution towards the SQL Server Community.@MarkGStaceyhttp://uk.linkedin.com/in/retracement/http://tenbulls.co.ukhttps://api.twitter.com/1/users/profile_image?screen_name=@MarkGStacey48487022Matt MassonMatt Masson is a Software Development Engineer working with the SQL Server Integration Services (SSIS) team. Matt has worked on many aspects of the SSIS product including upgrade, performance, and overall user experience. He is a frequent presenter at Microsoft conferences, and maintains the SSIS Team blog. Prior to joining Microsoft in 2006, Matt was a developer on a number of BI Reporting and Analytical products@mattmassonhttp://www.linkedin.com/in/mmassonhttp://www.mattmasson.com/https://api.twitter.com/1/users/profile_image?screen_name=@mattmasson48486086Neil HamblyNeil Hambly (currently F/T DB Architect) A SQL Professional over the last 14 years, having started with version 6.5 and worked with all versions and features since thenA UG leader (London, UK) and {very} frequent presenter @ UK SQL Server User Groups along with sessions @ SQLBits 7 (York), 8 (Brighton), SQL-in-the-City (London) conferencesCan be frequently found doing his studies towards the SQL 2008 MCM certification and manages the LinkedIN “UK SQL Server User Group”@Neil_Hamblyhttp://www.linkedin.com/in/neilhamblyhttp://sqlblogcasts.com/blogs/NeilHamblyhttps://api.twitter.com/1/users/profile_image?screen_name=@Neil_Hambly48488307Noemi Moreno Tom AustinNoemi Moreno, Business Intelligence Specialist and Tom Austin, SQL Team Lead at Red Gate Software@abjbradfordhttp://www.redgate.comhttps://api.twitter.com/1/users/profile_image?screen_name=@abjbradford48487884Pete HarrisPete is a Learning Product Planner in MSL focusing on SQL Server courseware. He joined Microsoft in 1995, and was part of the first team of developer trainers in the post-Microsoft University era. He helped build the Mastering Series products for retail and the classroom. Since then he’s done a variety of work around Microsoft but almost always focussed on content in some way.http://www.linkedin.com/pub/pete-harris/0/68/ab948488529Ronan GeraghtyThis session will be delivered by Ronan Geraghty, Tibbs Pereira and Ronan Gavin of Microsoft Ireland@ronangeraghtyhttp://blogs.msdn.com/b/ronang/https://api.twitter.com/1/users/profile_image?screen_name=@ronangeraghty48487980Rushabh MehtaRushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. Rushabh served as PASS President for the 2010/2011 term. He has worked with Microsoft SQL Server since 1998 and has designed and developed BI systems on the Microsoft platform since 2001. Rushabh is a SQL Server MVP and frequent speaker at large conferences and PASS Chapters around the world. As Immediate Past President, Rushabh continues to support the PASS organization.@rushabhmehtahttp://www.linkedin.com/in/rushabhbmehtahttp://blogs.solidq.com/RushabhMehta https://api.twitter.com/1/users/profile_image?screen_name=@rushabhmehta48487023Various SpeakersVarious Speakers both new and old48485997William E Pearson IIIBill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution.@Bill_Pearsonhttp://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85ehttps://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85Ehttps://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson484859775977Mark StaceyCharlemount Suite 3Analysis Services for the DBAMany DBAs have heard the term Analysis Services, but don't really know what it's for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution.
This session will be practical for SQL 2005 through 2008 R2, but he will also take the time to explain what changes in SQL 2012 and the new Tabular mode.3/24/2012 4:00:00 PM3/24/2012 5:00:00 PM59845984Christina LeoCharlemount Suite 4SQL Server Internals: It's What's for Dinner!Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server.3/24/2012 2:45:00 PM3/24/2012 3:45:00 PM59975997William E Pearson IIITBAGetting Started with MDX: The (Very) BasicsIn this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
3/24/2012 4:00:00 PM3/24/2012 5:00:00 PM60866086Neil HamblyCharlemount Suite 4Effective Data Management using Data CompressionI present this session @ Red Gate SQL-in-the-City Conference (London - July 2011)This session will explain the basic principles of SQL Server's data compression feature, how it functions, what options you can choose, and how it performs under differing workloads. We will look at how to integrate data compression into your current schema designs and the challenges you will likely encounter, examining the all-important performance aspects and the configuration changes to consider along with SKU editions requirements. We will also look @ Red Gate's 'SQL Storage Compress' product to show how their data compression tool can tackle these data growth challenges in a different manner.3/24/2012 10:40:00 AM3/24/2012 11:40:00 AM61456145Karen LopezCharlemount Suite 2Database Design Contentious IssuesA highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.3/24/2012 9:30:00 AM3/24/2012 10:30:00 AM61556155Jen StirrupCharlemount Suite 3SQL Server 2012: Business Intelligence Data VizThe new Business Intelligence and Data Visualisation functionality are key to the changes in SQL Server 2012. We will take a look at:
- Power View and its impact for Data Visualisation
- PowerPivot improvements and new features
- Reporting Services and its future in Sharepoint
Come to this session in order to 'hit the ground running' with Business Intelligence and Data Visualisation in SQL Server 2012.3/24/2012 10:40:00 AM3/24/2012 11:40:00 AM64026402Chris Testa-O'NeillCharlemount Suite 3Notes on SQL 2012 Highly Available BI EnvironmentsThis session will provide insight on what to expect when deploying a highly available end to end SQL Server 2012 Business Intelligence environment as experienced from the field. As well as leveraging the SQL Server Business Intelligence skills that you possess. You will also gain an insight into the additional skills and knowledge that you will need to ensure the successful delivery of technologies such as such as PowerPivot, PowerView, SQL Server Reporting Services and SQL Server Analysis Services on a robust architecture. 3/24/2012 2:45:00 PM3/24/2012 3:45:00 PM65426542Mark BroadbentCharlemount Suite 4Moves like Jagger-Upgrading to SQL Server 2012In this diverse session we will take an in-depth look at moving to the SQL 2012 platform and the upgrade strategies at your disposal. Specifically we will take a deep dive into preparing and reporting for upgrade, upgrade strategies, performing the upgrade, knowing the upgrade was successful.
This session will therefore look at some advanced scenarios such as SQL Server 2012 on Server Core, preparing for Always On Availability Groups, upgrading your SQL Failover Cluster, storage migration.
Attend this must see session and you too can have the “Moves like Jagger”.3/24/2012 4:00:00 PM3/24/2012 5:00:00 PM65456545Andre KammanCharlemount Suite 4Build a monitoring system with Powershell Remoting
My last session on managing large environments turned out to be more talk than proof, it contained a bunch of war stories and almost no demos.
This session will be the other way around, we're going to spend most of our time in powershell and we'll build a whole monitoring system from scratch.
I'll use powershell remoting and real world demo's based on my own day to day practice.
To keep the promise of a level 300 session I'll spend some time in the beginning to explain the concepts of powershell remoting,
after which I'll build a monitoring system step by step in the second part of the session.3/24/2012 12:00:00 PM3/24/2012 1:00:00 PM65996599Allan MitchellCharlemount Suite 3Making Data Fit for Business using DQSThere are lots of DQ issues we are going to talk about some of the common issues and later see how we can handle them. Issues such as
1. Misspelled names
2. Misspelled addresses – addresses which do not exist, e-mail addresses
3. Duplication
Pretty much everyone suffers from these problems so come to this session to learn a new way to deal with them in SQL Server 2012 Data Quality Services3/24/2012 9:30:00 AM3/24/2012 10:30:00 AM66096609Klaus AschenbrennerTBAAdvanced SQL Server 2008 TroubleshootingIt's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast? Which tools provides you SQL Server for this task? In this session you will see a lot of different tools with which you can do effective SQL Server troubleshooting. You will learn how to identify performance bottlenecks with those tools, and how to resolve the identified bottlenecks.3/24/2012 12:00:00 PM3/24/2012 1:00:00 PM66176617James BaldwinCharlemount Suite 4Storage Best Practices Performance optimizationThe release of SQL Server 2012 brings long-awaited technologies and improved scalability to the database platform.
While historical best practices will continue to apply, added product features such as AlwaysOn, PowerView, Column Store, now brings an extra dimension to consider when deploying and optimizing storage for SQL Server 2012.
This session will cover Storage Best Practices for both existing SQL Server editions and 2012 in common and feature-intense areas. Designing for OLTP, OLAP/DW/BI environments also is addressed.
3/24/2012 9:30:00 AM3/24/2012 10:30:00 AM66396639Bob BeaucheminCharlemount Suite 2Searching over data and files with SQL Server 2012With the addition of non-transactional filestream, filetable, semantic search and full-text search support for property search, SQL Server 2012 provides an excellent platform for searching over traditional relational as well as unstructured document data. This talk covers the motivation, implementation, and components that expands and inegrates search capabilities.3/24/2012 10:40:00 AM3/24/2012 11:40:00 AM66486648Aaron BertrandCharlemount Suite 2T-SQL : Bad Habits to KickThe session will cover a collection of minor bad habits that can occasionally lead to major problems.3/24/2012 2:45:00 PM3/24/2012 3:45:00 PM66796679Christopher WebbCharlemount Suite 2Intro to Tabular Model in Analysis Services 2012Introduction to the Tabular Model in Analysis Services 2012
The Tabular model in Analysis Services 2012 is the new alternative to building cubes: it’s easier to develop with (especially if you come from a relational database background) and its in-memory, column-store database provides blindingly fast performance. This session will provide a basic introduction to building Tabular models and discuss their strengths and weaknesses compared to cubes.
3/24/2012 12:00:00 PM3/24/2012 1:00:00 PM69086908Kevin KlineCharlemount Suite 2Top Ten Things Every Developer Should KnowStereotypes abound in all walks of life, IT is no different - Developers think DBAs are control freaks; DBAs think developers are unruly cowboys - How do we overcome these differences? For developers, the best strategy is to manage DBA anxieties and demonstrate your competence and credibility. Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration. There are a short list of mistakes that, if known in advance, will make your life much easier. These mistakes are the “low hanging fruit” of application design, development, and administration. Application of the lessons in this session, should help you to perform more efficiently effectively3/24/2012 4:00:00 PM3/24/2012 5:00:00 PM70227022Matt MassonTBASSIS in SQL Server 2012: Development EnhancementsThe SQL Server 2012 release of SQL Server Integration Services (SSIS) includes a broad range of new features and enhancements designed to ease adoption for new users and to increase productivity for experienced SSIS developers. In this demo intensive session, Matt Masson – Senior Software Development Engineer on the SSIS team – guides you through the new developer focused functionality in SQL Server 2012. We’ll look at the productivity enhancements in SQL Server Data Tools (formerly the Business Intelligence Development Studio), team development enhancements, and the new Change Data Capture (CDC) features that ship with the product. If you haven’t seen the new SSIS features in SQL Server 2012 yet, you won’t want to miss this session!3/24/2012 10:40:00 AM3/24/2012 11:40:00 AM70237023Various SpeakersTBALightning TalksA chance for both new and seasoned speakers to present for 5 minutes on their favourite topic. Prizes awarded for the best and most entertaining lightening talk.3/24/2012 2:45:00 PM3/24/2012 3:45:00 PM78847884Pete HarrisCharlemount Suite 3Get the right SQL Certifications for your businessPete Harris, SQL Server Product Planner for Microsoft will lead you through the training offered by Microsoft in the area of SQL Server 2012 and SQL Server 2008. He will be supported by Chris Testa-O’Neill, e-learning author, Microsoft Certified Trainer and Senior Consultant at Coeo and a guest MCM / MCA. The session will cover certifications such as:
• Microsoft Certified Technical Specialist
• Microsoft Certified IT Professional
• Microsoft Certified Master
• Microsoft Certified Architect
The Session will also identify and explore available learning channels (Microsoft official courses – instructor led training / e-learning / press books) to support you in achieving your certification 3/24/2012 12:00:00 PM3/24/2012 1:00:00 PM79177917Committee MembersCharlemount Suite 4REGISTRATIONDelegates register on Arrival3/24/2012 8:00:00 AM3/24/2012 9:15:00 AM79177917Committee MembersCharlemount Suite 3REGISTRATIONDelegates register on Arrival3/24/2012 8:00:00 AM3/24/2012 9:15:00 AM79177917Committee MembersCharlemount Suite 2REGISTRATIONDelegates register on Arrival3/24/2012 8:00:00 AM3/24/2012 9:15:00 AM79177917Committee MembersTBAREGISTRATIONDelegates register on Arrival3/24/2012 8:00:00 AM3/24/2012 9:15:00 AM79187918Committee MembersCharlemount Suite 4COFFEE BREAK AMDelegates drink coffee3/24/2012 11:40:00 AM3/24/2012 12:00:00 PM79187918Committee MembersCharlemount Suite 3COFFEE BREAK AMDelegates drink coffee3/24/2012 11:40:00 AM3/24/2012 12:00:00 PM79187918Committee MembersCharlemount Suite 2COFFEE BREAK AMDelegates drink coffee3/24/2012 11:40:00 AM3/24/2012 12:00:00 PM79187918Committee MembersTBACOFFEE BREAK AMDelegates drink coffee3/24/2012 11:40:00 AM3/24/2012 12:00:00 PM79197919Committee MembersCharlemount Suite 4COFFEE PMAnd more coffee3/24/2012 3:45:00 PM3/24/2012 4:00:00 PM79197919Committee MembersCharlemount Suite 3COFFEE PMAnd more coffee3/24/2012 3:45:00 PM3/24/2012 4:00:00 PM79197919Committee MembersCharlemount Suite 2COFFEE PMAnd more coffee3/24/2012 3:45:00 PM3/24/2012 4:00:00 PM79197919Committee MembersTBACOFFEE PMAnd more coffee3/24/2012 3:45:00 PM3/24/2012 4:00:00 PM79207920Committee MembersCharlemount Suite 4LUNCH BREAKDelegates break for lunch3/24/2012 1:00:00 PM3/24/2012 2:45:00 PM79207920Committee MembersCharlemount Suite 4LUNCH BREAKDelegates break for lunch3/24/2012 1:45:00 PM3/24/2012 2:30:00 PM79207920Committee MembersCharlemount Suite 3LUNCH BREAKDelegates break for lunch3/24/2012 1:00:00 PM3/24/2012 2:45:00 PM79207920Committee MembersCharlemount Suite 2LUNCH BREAKDelegates break for lunch3/24/2012 1:00:00 PM3/24/2012 2:45:00 PM79207920Committee MembersTBALUNCH BREAKDelegates break for lunch3/24/2012 1:00:00 PM3/24/2012 2:45:00 PM79217921Committee MembersCharlemount Suite 4AFTER PARTYFun....3/24/2012 5:30:00 PM3/24/2012 11:30:00 PM79217921Committee MembersCharlemount Suite 3AFTER PARTYFun....3/24/2012 5:30:00 PM3/24/2012 11:30:00 PM79217921Committee MembersCharlemount Suite 2AFTER PARTYFun....3/24/2012 5:30:00 PM3/24/2012 11:30:00 PM79217921Committee MembersTBAAFTER PARTYFun....3/24/2012 5:30:00 PM3/24/2012 11:30:00 PM79247924Committee MembersCharlemount Suite 4Guest Speaker Welcome OverviewWelcome3/24/2012 9:15:00 AM3/24/2012 9:30:00 AM79247924Committee MembersCharlemount Suite 3Guest Speaker Welcome OverviewWelcome3/24/2012 9:15:00 AM3/24/2012 9:30:00 AM79247924Committee MembersCharlemount Suite 2Guest Speaker Welcome OverviewWelcome3/24/2012 9:15:00 AM3/24/2012 9:30:00 AM79247924Committee MembersTBAGuest Speaker Welcome OverviewWelcome3/24/2012 9:15:00 AM3/24/2012 9:30:00 AM79807980Rushabh MehtaTBASSIS 2012 Management Considerations and Best PractSQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages3/24/2012 9:30:00 AM3/24/2012 10:30:00 AM83078307Noemi Moreno Tom AustinCharlemount Suite 2Social Media, BI, Bridging the SSMS-VS Divide Delivered by Noemi Moreno, Business Intelligence Specialist and Tom Austin, SQL Team Lead at Red Gate Software.In this session, Noemi and Tom explain how they developed a system to import information from Twitter into a SQL Server data warehouse, and to export their analysis into Google Docs. They also discuss how Red Gate’s database development tools helped them collaborate on the project without having to pick between their favourite IDEs. Session attendees have the chance to enter the competition to win a SQL Developer Bundle.3/24/2012 1:45:00 PM3/24/2012 2:30:00 PM85288528Bob DuffyCharlemount Suite 3SQL 2012 Always On-Deep DiveAlways On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.
During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery.
This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.
3/24/2012 1:45:00 PM3/24/2012 2:30:00 PM85298529Ronan GeraghtyTBADrive Greater Application ROIDrive Greater Application ROI, Deeper Business Insights, and Faster Time to Market...
Learn how SQL Server 2012 can help you Reduce Your Costs and Increase ROI on Mission Critical Applications while Innovating with New Technology.
• Reduce total cost of ownership of Mission critical and line of business applications
• Increase ROI on current IT investments
• Improve time to market on new IT investments
• SQL Server 2012: an overview of changes to SKU line-up and licensing model
3/24/2012 1:45:00 PM3/24/2012 2:30:00 PM