SQLSaturday #141 - South Florida 20126/16/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. #sqlsat141NOVA Southeastern University3301 College AveDavieFL333142247Homnick Systems, Inc.http://homnick.comhttp://dl.homnick.com/HomnickLogo.PNG601702263SherlockTech Staffinghttp://www.SherlockTeck.comhttp://www.sfssug.com/sqlsaturday/141/SherlochTechColorLogo2011.jpg601702188TekPartnershttp://www.tekpartners.comhttp://www.tekpartners.com/wp-content/uploads/2012/04/TP_P2P_IT-021.jpg601702216Iderahttp://www.idera.comhttp://www.idera.com/images/Logo-Idera.png601702080Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702181Blue Syntax Consultinghttp://www.bluesyntax.nethttp://www.bluesyntax.net/images/Logo.jpg601702280HPhttp://www.hp.comhttp://welcome.hp-ww.com/country/us/en/cs/images/i/print_logo.jpg601702286Insight Global, Inc.http://www.insightglobal.net/http://www.insightglobal.net/images/logo.png601702287TEKsystemshttp://www.teksystems.com/http://www.saic.com/contractcenter/ites-2s/images/logos/tek.gif601702298Nova Southeastern Universityhttp://www.nova.edu/http://www.sfssug.com/sqlsaturday/141/NSU-GSCIS.JPG601702299Precise Software Solutionshttp://www.precise.comhttp://www.precise.com/images/home/sap-home-banner.gif601702309dotNet Miamihttp://dotnetmiami.comhttp://dotnetmiami.com/images/dotnetmiami_170_60.png601702310DirecLogixhttp://www.direclogix.comhttp://www.sfssug.com/sqlsaturday/141/direclogix.gif601702315Red Gate Softwarehttp://www.red-gate.comhttp://www.red-gate.com/assets/images/common/logo.png601702326Xtiviahttp://www.Xtivia.comhttp://www.xtivia.com/images/XtiviaLogo-170x60.jpg601702331Convergence Consulting Grouphttp://www.ccgBI.comhttp://www.convergenceconsultinggroup.com/wp-content/uploads/logo.jpg601702349Pragmatic Workshttp://pragmaticworks.com/http://pragmaticworks.com/images/logo/PragmaticWorksLogo.jpg601702370Cesar Henao For Congress Committeehttp://cesarforcongress.comhttp://c369569.r69.cf1.rackcdn.com/th_c1f86a6c16114c76a69d3ef8fe7cd6aa.jpg601702386Ultimate Softwarehttp://www.ultimatesoftware.com/http://conferences.oreillynet.com/images/logos/ultimatesoftware.gif601709820Aaron NelsonAaron Nelson is a Senior SQL Server Architect with over 10 years of experience in SQL Server. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V).@http://twitter.com/sqlvarianthttp://www.linkedin.com/in/sqlvarianthttp://sqlvariant.com/wordpress/https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant48488764Alex FunkhouserAlex Funkhouser srote his first lines of code in 1980 on a TRS80. Alex is an avid supporter of the technology community. He earned an MBA from The Netherlands, and a Bachelor of Science from Washington University. Alex's recruiting philosophy: “Know who is best at what, and know who needs the best!@alexfunkhouserhttp://www.linkedin.com/in/alexfunkhouserhttp://www.SherlockTech.comhttps://api.twitter.com/1/users/profile_image?screen_name=@alexfunkhouser48488047Anthony SammartinoAnthony Sammartino is responsible for guiding the BI Solutions Practice’s strategy, methodology, and operational execution, including overseeing or engaging as a Solution Architect, Project Manager, or Technical Lead in all BI Projects for TekPartners. Before joining TekPartners, Mr. Sammartino was President and Principal Consultant of APS Partners Inc., where he provided BI Consulting to many fortune 500 companies where he almost exclusively delivered solutions using the MS BI Stack.@apsammartinohttp://www.linkedin.com/in/apsammartinohttp://www.anthonysammartino.comhttps://api.twitter.com/1/users/profile_image?screen_name=@apsammartino48488230Bradley SchachtBradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer. Bradley has experience on many part of the Microsoft BI platform. He has spoken at events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).@bradleyschachthttp://www.linkedin.com/pub/bradley-schacht/17/66b/b08http://www.bradleyschacht.comhttps://api.twitter.com/1/users/profile_image?screen_name=@bradleyschacht48489010Chad ChurchwellI am a Senior DBA Consultant for Pragmatic Works focusing on Replication we well as HA/DR and performance tuning. I have been a SQL DBA for 10 years@chadchurchwellhttp://www.linkedin.com/in/chadchurchwellhttp://www.sqlchad.comhttps://api.twitter.com/1/users/profile_image?screen_name=@chadchurchwell48487968Christopher PriceChris Price is a Business Intelligence Consultant with Pragmatic Works. He has his M.B.A from the University of South Florida and has worked as a professional software developer since 1999. For the past couple of years his attention has been focused on the Microsoft Business Intelligence stack. His interested span the BI stack from SSIS and SSAS to Performance Point. @bluewater79http://bidn.com/blogs/cprice1979/https://api.twitter.com/1/users/profile_image?screen_name=@bluewater7948488801David LiebmanI’m a developer specializing in .Net, SQL, and SSRS development for over five years of the eighteen years I have spent in the IT Industry. I have experience working for some big companies in Financial, Healthcare, and Insurance. I have written some custom reporting solutions and web applications for Large Companies in the Tampa Bay area using .Net, SSRS, and SQL. I’m currently a Sr. Developer at AgileThought that is leader in software development and system integration services in Tampa FL.@bisqldavehttp://www.linkedin.com/in/liebmandavidhttp://www.bisqldave.comhttps://api.twitter.com/1/users/profile_image?screen_name=@bisqldave48487975Devin KnightDevin is a BI consultant and Trainer at Pragmatic Works Consulting. He has authored three SQL Server books and speaks at conferences like PASS, Code Camps and several SQL Saturday events. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).@https://twitter.com/knight_devinhttp://www.linkedin.com/profile?viewProfile=key=22920224locale=en_UStrk=tab_prohttp://www.bidn.com/blogs/devinknighthttps://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/knight_devin48487985Dmitri KorotkevitchDmitri Korotkevitch is Director of Development at Actsoft - Tampa based company developing GPS Tracking and Mobile Workforce Management solutions. Back-end database handles more than 3000TPS during the peak time. Dmitri has 10 years experience working with SQL Server and holds MCPD and MCITP - Sql Server 2005 2008 Database Developer and 2008 Database Administrator certificates. http://aboutsqlserver.comhttps://api.twitter.com/1/users/profile_image?screen_name=48489149Eduardo BlumenfeldMore than 30 years working with databases,
starting with the old dbase 2/3 foxpro@eblumenfeldhttps://api.twitter.com/1/users/profile_image?screen_name=@eblumenfeld48488029James McAuliffeJames McAuliffe, MCITP, is a Business Intelligence Solution Architect for Convergence Consulting Group. He has been working as a professional software developer since 1993, and has worked with clients from local businesses to Fortune 500 companies. James has been using SQL Server since 1999, and in the last few years with a concentration on the Business Intelligence methodologies. He is excited to share about the new capabilities that SQL Server 2012 brings to information professionals.http://www.linkedin.com/profile/view?id=11710667trk=tab_prohttp://www.convergenceconsultinggroup.com48489778Janis 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=@DoBoutAnything48488821Jen 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=@jenstirrup48489822John SchneyerJohn Schneyer is a certified problem solving and decision making consultant and trainer. Having spent over 20 years with the world’s largest chemical company, John has applied his skills consulting in Germany, England, and the United States. John has never worked with SQL Server. His database experience includes IMS, Image3000, DB2, Alpha 3, Paradox, and Access. John views his role as a catalyst that comes in, identifies problem root cause, develops solutions, and then implements preventive John.Schneyer@BocaConsultants.com48489571Josh KodiHas over 20 years of experience in IT over half of which on DW/BI. Has worked on various DW/BI tools and technologies including Microsoft BI stack, Business Objects, MicroStrategy as well as database such as SQL Server, Oracle and Teradata. Having worked on quite a few initiatives from ground up, posses an in depth knowledge on various areas of DW and BI.http://www.linkedin.com/in/joshkodi48488659Luis FigueroaLuis Figueroa is an IT professional focused on delivering business solutions that leverage the Microsoft SQL Server platform. His area of expertise is Data Warehousing and Business Intelligence but he is passionate about all things SQL Server. With 7+ years of experience in the field, Luis has delivered data management solutions for companies in the Security, Online Marketing and Healthcare Industries. He is also the Director of Sponsorship for the South Florida SQL Server User Group.@luisefigueroahttp://www.linkedin.com/in/luisefigueroahttp://blog.extremebi.net/https://api.twitter.com/1/users/profile_image?screen_name=@luisefigueroa48489401Max TrinidadI’m from Puerto Rico, have been working with computers since 1979. Throughout many years, I have worked with various types of databases such as: Dbase, OS/400-DB2, MySQL and MSSQL. Also, provided support to Windows Servers 2003/2008, Windows 7, SQL Servers Applications, Microsoft Virtualization Technologies, and build some Visual Studio solutions. I’m a Microsoft PowerShell MVP since 2008 and MVP SAPIEN Technologies since 2010.@MaxTrinidadhttp://www.linkedin.com/pub/max-trinidad/12/47/775http://www.maxtblog.com/https://api.twitter.com/1/users/profile_image?screen_name=@MaxTrinidad48488816Pam ShawPam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa.@http://www.linkedin.com/in/pshaw1129http://www.linkedin.com/in/pshaw1129http://sqlpam.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw112948489378RIchie RumpRichie is a SW developer, data architect and project manager. He recently lead the project team that rewrote Integrated Supply Chain Management System that serves as the backbone for the Burger King supply chain. He currently holds the (PMP) certification and various Microsoft certifications. His previous experience includes working for Florida Power and Light, Ryder and Walt Disney World. Richie also founded the dotNetMiami user group. Richie is a CIS graduate of the University of Miami.@Jorrisshttp://www.linkedin.com/in/richierumphttp://www.jorriss.nethttps://api.twitter.com/1/users/profile_image?screen_name=@Jorriss48489609Sebastian MeineSebastian is a principal trainer and consultant with sqlity.net llc (http://sqlity.net) and CTO for TSTS Inc, a company that provides an online personalized training and workout solution (http://www.tanyastroh.com). He specializes in T-SQL Test Driven Development (TDD) and performance and shares his passion and knowledge regularly with audiences world-wide through his writings and speaking engagements.Read more at http://sqlity.net/en/about/@sqlityhttp://sqlity.nethttps://api.twitter.com/1/users/profile_image?screen_name=@sqlity48489938Shervin ShakibiShervin Shakibi is a Microsoft Regional Director and the lead Developer Technoloies Instructor. In addition to being an author and Technical editor on many .NET books he has been a popular speaker at events such as Microsoft Tech Ed, PDC and Developer Days. Shervin has been developing Enterprise applications since 1987 and a Microsoft Certified Trainer since 1994. Experienced in the delivery of scalable, stable and open enterprise-level.@shervshervhttp://www.linkedin.com/pub/shervin-shakibi/1/563/174http://geekswithblogs.com/shervinhttps://api.twitter.com/1/users/profile_image?screen_name=@shervsherv48489902Telmo SampaioTelmo Sampaio is the Chief Geek at MCTrainer.NET, his own consulting and training company. He specializes in SQL, SharePoint, .NET and System Center. His passion for technology and teaching made him a self-taught developer from early age. After working for IBM and Microsoft, Telmo now travels the world training, consulting, speaking and helping Microsoft develop their certification program.@telmo_sampaiohttp://www.linkedin.com/pub/telmo-sampaio/0/200/172 https://api.twitter.com/1/users/profile_image?screen_name=@telmo_sampaio48489073Tim CostelloTim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.@http://www.twitter.com/tradneyhttp://linkedin.com/in/tradneyhttp://www.timradney.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://www.twitter.com/tradney484879577957SQLSatruday 141Room 1047Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79577957SQLSatruday 141Room 1048Coffee Break6/16/2012 10:15:00 AM6/16/2012 10:45:00 AM79577957SQLSatruday 141Room 1048Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79577957SQLSatruday 141Room 1049Coffee Break6/16/2012 10:15:00 AM6/16/2012 10:45:00 AM79577957SQLSatruday 141Room 1049Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79577957SQLSatruday 141Room 3031Coffee Break6/16/2012 10:15:00 AM6/16/2012 10:45:00 AM79577957SQLSatruday 141Room 3031Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79577957SQLSatruday 141Room 1052Coffee Break6/16/2012 10:15:00 AM6/16/2012 10:45:00 AM79577957SQLSatruday 141Room 1052Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79577957SQLSatruday 141Room 1053Coffee Break6/16/2012 10:15:00 AM6/16/2012 10:45:00 AM79577957SQLSatruday 141Room 1053Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79577957SQLSatruday 141Room 1124Coffee Break6/16/2012 10:15:00 AM6/16/2012 10:45:00 AM79577957SQLSatruday 141Room 1124Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79577957SQLSatruday 141Room 1054Coffee Break6/16/2012 10:15:00 AM6/16/2012 10:45:00 AM79577957SQLSatruday 141Room 1054Coffee Break6/16/2012 2:30:00 PM6/16/2012 3:00:00 PM79587958SQLSaturday 141Room 1047Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79587958SQLSaturday 141Room 1048Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79587958SQLSaturday 141Room 1049Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79587958SQLSaturday 141Room 3031Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79587958SQLSaturday 141Room 1052Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79587958SQLSaturday 141Room 1053Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79587958SQLSaturday 141Room 1124Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79587958SQLSaturday 141Room 1054Lunch Break6/16/2012 12:00:00 PM6/16/2012 1:15:00 PM79687968Christopher PriceRoom 1054Introduction to Master Data Services 2012 Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM79717971Christopher PriceRoom 1048SSIS Moving Beyond the Script Task Script ComponMove beyond the script task and script component and you’ll find one of the often overlooked aspects of Integration Services is the extensibility options that are available. We will dive into a world of .Net code and discover your options for extending your SSIS Packages with custom objects. We will explore both custom task and data flow components as we develop from the ground up a set of reusable SSIS components using managed code.6/16/2012 9:00:00 AM6/16/2012 10:15:00 AM79757975Devin KnightRoom 1124Creating Dashboards with PerformancePoint ServicesWho wouldn’t want to create unbelievable dashboards that executives can get excited about? PerformancePoint Services is perfect tool for creating interactive dashboards viewable from inside SharePoint. In this session Devin will talk you through getting up and running with PerformancePoint and how to create a basic Dashboard including a KPI, Scorecard and Report.6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM79767976Devin KnightRoom 1124Extending Reporting Services with Custom CodeThe Reporting Services expression language can be a powerful tool for customizing report data and layout, but often times you will find it is lacking functionality that is easily available in .Net. While this session is not designed to teach you .Net it will show you some commonly used .Net functions for Reporting Services. We will also talk about the difference between custom code that is embedded in a report and external assemblies imported into Reporting Services.6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM79857985Dmitri KorotkevitchRoom 1047Deep Dive into Indexes (Part 1)No system ever performs well even on the most powerful hardware unless the database is efficiently indexed. But what does 'efficient indexing' mean? Database Professionals impress customers by use of magic buzzwords such as “Indexing strategies” and “Performance tuning” and happily contribute to the myth about complexity of the subject. But with all complexity involved it’s not Rocket Science – the key point is to understand how SQL Server works with indexes and look at them from SQL Server standpoint.
This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system.6/16/2012 9:00:00 AM6/16/2012 10:15:00 AM79867986Dmitri KorotkevitchRoom 1047Deep Dive into Indexes (Part 2)No system ever performs well even on the most powerful hardware unless the database is efficiently indexed. But what does 'efficient indexing' mean? Database Professionals impress customers by use of magic buzzwords such as “Indexing strategies” and “Performance tuning” and happily contribute to the myth about complexity of the subject. But with all complexity involved it’s not Rocket Science – the key point is to understand how SQL Server works with indexes and look at them from SQL Server standpoint.
This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system.6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM80298029James McAuliffeRoom 1048Clean Up On Column 3Using Data Quality Services to Clean Up Your Mess
It’s happened to all of us. Reach for the jar at the grocery store and…. “Clean up on Aisle 3!”. Well, what happens if the jar you are reaching for is full of data? And it’s bad data? And you got it alllll over the place? This session will deal with techniques for finding bad data, organizing and fixing it, and incorporating the new features of Data Quality Services to help you in your efforts.
This document will talk about Data Quality issues, and how using Microsoft’s new Data Quality Services (SSDQS) feature in SQL 2012
6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM80478047Anthony SammartinoRoom 1053Divide Conquer Reporting - With ReplicationIn this session I will go over how to separate your systems for transactional databases, and for reporting. I will cover the basics of replication, the types, which one is right for your situation, agents it creates and their purpose, provide tips, best practices, and dispel any fears you may have heard or validate them about replication. 6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM82308230Bradley SchachtRoom 1048Introduction to ETL Using SSISAs we all know data is not static. It is constantly changing, constantly moving and just moving data from one place to another is a simple enough task. In this session Brad will explore how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files. He will then discuss some of the DOs and DON’Ts of the SSIS ETL world. We will discuss ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that you may not be able to handle all in memory, and bring multiple sources into one destination. Other topics: partially blocking vs fully blocking, which transforms are right for what jobs, what to avoid.6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM86598659Luis FigueroaRoom 1048Extremely Fast Dimension Updates with CDC and CTIn this session Luis will demonstrate how to use Change Tracking and Change Data Capture to very quickly update data warehouse dimensions. He will also cover the new Change Data Capture functionality included in SSIS 2012.6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM87648764Alex FunkhouserRoom 1052For Love or Money, Your IT Career• Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?
• Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are learning and using the latest, most marketable technologies?
In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career.
6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM88018801David LiebmanRoom 1049BI in the CloudIn this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM88168816Pam ShawRoom 1053Tips Tricks for dynamic SSRS ReportsIn this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM88178817Pam ShawRoom 1053Taking the Scary out of Monster ReportsSo the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM88218821Jen StirrupRoom 1049SQL 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.6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM90109010Chad ChurchwellRoom 1047Designing An Efficient Replication TopologyThis session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve specific business needs will also be covered.6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM90739073Tim CostelloRoom 1049Dimensional Design primer: What you need to knowEverybody wants a data warehouse. What IS a data warehouse? How is it different from a data mart? Star Schema? Snowflakes? The dimensional bus? 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.6/16/2012 9:00:00 AM6/16/2012 10:15:00 AM91309130Jen StirrupRoom 1124Mobile Business Intelligence for Everyone, Now!Microsoft has made serious commitments to mobile Business Intelligence, announced at SQLPass Summit 2011. What is the roadmap? What's available right now, and how can it be implemented at your organisation?
Come to this session to learn about mobilising Business Intelligence using Sharepoint, Reporting Services, SQL Azure, Excel Services and Power Pivot. Yes, it is possible to have mobile Business Intelligence in your organisation, and come to this session in order to learn how!
6/16/2012 9:00:00 AM6/16/2012 10:15:00 AM91499149Eduardo BlumenfeldRoom 3031Using With in SQLThe With statement is a really powerful for SQL queries that allows to improve readability, simplify maintenance and create very complex queries by dividing the task in small chunks.
This session will go from simple examples to more involved recursive ones.
6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM93789378RIchie RumpRoom 1054New T-SQL features in SQL Server 2012 With the introduction of SQL Server 2012 data developers have new ways to interact with their databases. This session will review the powerful new analytic windows functions, new ways to generate numeric sequences and new ways to page the results of our queries. Other features that will be discussed are improvements in error handling and new parsing and concatenating features. 6/16/2012 9:00:00 AM6/16/2012 10:15:00 AM94019401Max TrinidadRoom 3031Basic Intro to PowerShell for the DBADescription:This is an Intro level for the SQL DBA wanting to start and learn how to use PowerShell in their environment. It will be divided in two half hour part be covering PowerShell setup essentials, and testing PowerShell working with both SMO and SQLPS module to build SQL PowerShell scripts. This is not a language intro but it will get you started to learn PowerShell. Covering PowerShell V2/V3 and SQL Server tools.6/16/2012 9:00:00 AM6/16/2012 10:15:00 AM94029402Max TrinidadRoom 3031PowerShell Query for the T-SQL DeveloperThis session will show the side-by-side similarity in building a PowerShell query vs T-SQL. I will demo some scripting techiniques in buidling a PowerShell query, building Hash table objects, ways to read and display the information. If the person knows how-to write T-SQL script, then it makes it easy to understand How-To write a PowerShell query.6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM95719571Josh KodiRoom 1049DW/BI: 0 to 60 and beyond!Everything from basics of Data Warehouse and Busines Intelligence to what does it take to build a successful solution. Will look at Microsoft BI stack and related tools to implement a DW/BI solution. Will also look at an Advanced Data Visualization and Analysis Tool, Tableau. Attendees will get an opportunity to ask practical questions on DW and BI.6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM96099609Sebastian MeineRoom 3031Mining XML Query PlansExecution plans contain a lot of information that can guide you in your performance tuning process. Since SQL 2005 it is possible to retrieve the execution plans stored in the cache using DMVs and DMFs. However, as they are stored in XML format it can be cumbersome and difficult to extract the information you need. In this session, you will learn how the XML query plan is structured and how to use SQL Server’s built-in XQuery language to extract information. Examples include indexes that the optimizer indicates would increase performance if implemented and queries that use table scans or nested loop joins.6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM97789778Janis GriffinRoom 1052Looney 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.6/16/2012 10:45:00 AM6/16/2012 12:00:00 PM98209820Aaron NelsonRoom 1054Time 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!6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM98219821Aaron NelsonRoom 1052PowerShell for Data ProfessionalsYou’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM98229822John SchneyerRoom 1124KEYNOTE SESSION: What Happens NextKEYNOTE SESSION6/16/2012 8:30:00 AM6/16/2012 8:45:00 AM98899889Tim RadneyRoom 1047It's TEMPDB Why Should You Care?TEMPDB is just for temporary data right? It is installed by default and gets recreated each time SQL is restarted so what does it matter right? WRONG TEMPDB is a critical part of your SQL Server instance and needs special attention. In this session Tim Radney will give you insight into what uses TEMPDB, why TEMPDB is important, what are the best practices for configuring TEMPDB, what makes TEMPDB so unique, and how to determine if your TEMPDB has a contention issue. Tim will demo creating contention in TEMPDB and explain how to solve this dreadful issue. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.6/16/2012 3:00:00 PM6/16/2012 4:15:00 PM98979897Tim RadneyRoom 1124Know Backups and Know RecoveryYou say you have a backup strategy, but what is your recovery strategy?
In this session Tim will demonstrate several methods for performing much-needed backups and how to recover those backups to include FULL, DIFFERENTIAL, FILE GROUP, and TRANSACTION LOG. He will also demo performing a peace meal restore as well as backing up and restoring the tail end of the log after the data file becomes corrupt.
Tim will discuss industry best practices for backing up and recovering your data. The goal of this session is to educate you on the various backup strategies so you can decide which is best for your organization, demonstrate how to recover your databases, and to create the desire for you to go back and validate your current strategies6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM99029902Telmo SampaioRoom 1053Are you spatially aware?Don't get caught between mth and geography, let SQL show you where you are! Learn to use spatial data to store location information and integrate with Bing Maps and SSRS.6/16/2012 9:00:00 AM6/16/2012 10:15:00 AM99389938Shervin ShakibiRoom 1054SQL 2012 BI Capabilities in SharePoint 2010 SQL 2012 adds new extensive self-service BI capabilities in SharePoint 2010. The BI Semantic Model is one model for all end user experiences – reporting, analytics, scorecards, dashboards, and custom applications. All client tools in the Microsoft BI stack – Excel, PowerPivot, SharePoint Insights and Reporting Services now operate on this model. PowerPivot in SharePoint 2010 now integrates a Power View SharePoint Integrated Reporting Services instance.
6/16/2012 1:15:00 PM6/16/2012 2:30:00 PM