SQLSaturday #168 - Tampa BI Edition 201211/17/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. #sqlsat1681001 East Palm AvenueTampaFL336052730TekPartners BI Solutionshttp://www.tekpartnersbi.comhttp://4.bp.blogspot.com/-CS092Q7ijE0/UDZ1FN1AiAI/AAAAAAAAAH0/fqLyrAEcr0o/s320/TP+LOGO+Business+Intelligence+Solutions+June+2011.jpg601702739Pragmatic Workshttp://pragmaticworks.com/http://pragmaticworks.com/images/logo/PragmaticWorksLogo.jpg601702779Convergence Consulting Grouphttp://www.ccgBI.comhttp://tampabaybi.sqlpass.org/Portals/239/convergencelogo170x60.png601702813Fusion-iohttps://www.fusionio.comhttp://www.fusionio.com/images/fusionio-logo.gif601702709Quest Softwarehttp://www.quest.com/http://www.quest.com/images/common/quest_logo.gif601702719CozyRochttp://www.cozyroc.comhttp://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601702654Agile Bay, Inc.http://www.agilebay.comhttp://tampabaybi.sqlpass.org/Portals/239/agilebay170x60.png601702636Jason Thomashttp://road-blogs.blogspot.comhttps://xmp7ua.bay.livefilestore.com/y1pgMJIQLI5I7eTQiU9RbpQ8Eyu3GXt5jhk211KxpOxpxCClvTgKG2qGOJClvk8lUpaZiH57ym5jXXPqtgNwu_ZSKUSoQ1A9RK6/TitlImg.jpg4010011456Adam JorgensenAdam Jorgensen is the President of Pragmatic Works Consulting and a Director for the Professional Association of SQL Server. As a Microsoft SQL Server MVP and SSAS Maestro he has over 13 years of extensive experience with SQL Server, SharePoint and analytics. He is especially focused in the areas of Pararllel Data Warehousing, Tier 1 OLAP, Private and Public Cloud, and Big Data designing solutions making those technologies real for the today's enterprises.@adam_Jorgensenhttp://www.linkedin.com/in/wajorgensenhttp://adamjorgensen.comhttps://api.twitter.com/1/users/profile_image?screen_name=@adam_Jorgensen484810835Andy WarrenAndy Warren is an independent consultant specializing in SQL Server based in Orlando. Over the course of his career he has written more than 100 technical articles, was a founder of SQLServerCentral.com, relaunched the Orlando SQL Server User Group (oPASS), served for three years on the PASS Board of Directors, and has been a SQL MVP since 2008. He blogs most days at SQLAndy on a wide range of topics and spends a lot of time teaching and thinking about professional development and mentoring.
@sqlandyhttp://www.linkedin.com/in/sqlandyhttp://www.sqlandy.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlandy484810353Anthony SammartinoAnthony Sammartino is responsible for guiding the BI Solutions Division’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=@apsammartino484811495Brian Mitchell
Brian Mitchell is a MCM - SQL 2008 and Analysis Services Maestro. In his current position at Microsoft, he is a Senior Consultant delivering Business Intelligence and SQL Server PDW Solutions .
Brian has extensive experience delivering training for the full range of the Microsoft BI stack. Specifically, he has great passion for Analysis Services and Reporting Services. . Brian has presented on SQL Server Topics at TechED, SQLPASS, and several SQLSaturday's.@brianwmitchellhttp://www.linkedin.com/in/brianwmitchellhttp://sqlpdw.comhttps://api.twitter.com/1/users/profile_image?screen_name=@brianwmitchell484811527Brian K McDonaldBrian K. McDonald, MCDBA, MCSD is an Independent Business Intelligence consultant. Brian has served in many roles over his 13+ years in the IT industry. Brian is the lead author on Pro SQL Server 2012 Reporting Services (Apress), has written featured articles for industry websites and has a very active blog on SQLServerCentral and BIDN. Brian is an active member of the community and has presented at User groups, Code Camps, SQL Rally and SQL Saturday events across Florida.@briankmcdonaldhttp://tinyurl.com/briankmcdonaldhttps://api.twitter.com/1/users/profile_image?screen_name=@briankmcdonald484811342Chad 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=@chadchurchwell484810597Christopher 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://www.bidn.com/blogs/cprice1979/https://api.twitter.com/1/users/profile_image?screen_name=@bluewater79484810319David EichnerDavid Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics partner software development and technology consulting firm. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP)@ICANsoftwarehttp://www.linkedin.com/in/icansoftwarehttp://www.icansoftware.comhttps://api.twitter.com/1/users/profile_image?screen_name=@ICANsoftware484811167Dustin Ryan Mitchell PearsonDustin is a Sr. BI Consultant (MCTS,MCITP) and hitman/ninja assassin for Pragmatic Works. Lately, Dustin has spent most of his time developing BI solutions that involve SSRS, SSIS, SSAS. Dustin has also worked as a technical editor on various books. You can find Dustin speaking at events like SQL Saturday, SQL Rally, Code Camp, and other online webinars. Mitchell Pearson is a customer support rep with Pragmatic Works, experienced in developing supporting BI solutions utilizing SSRS SSIS. M@dryanPWhttp://www.linkedin.com/pub/dustin-ryan/14/59b/a9bhttp://sqldusty.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@dryanPW484811565Ira 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.@irawhitesidehttp://www.linkedin.com/in/irawarrenwhitesidehttp://irawarrenwhiteside.comhttps://api.twitter.com/1/users/profile_image?screen_name=@irawhiteside484811908James McAuliffe James McAuliffe is a Business Intelligence Solution Architect for Convergence Consulting Group. He has been working as a software developer since 1993, and has worked with clients of all sizes, 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 Business Intelligence methodologies. He is excited to share about the new capabilities that SQL Server 2012 brings to the database and information professional.http://www.convergenceconsultinggroup.com484811299Jen UnderwoodJen is a Microsoft Business Intelligence Sr. Technical Product Manager. She has 16 years of experience in business intelligence, data warehousing, reporting and analytics. Jen is active in the SQL Server community, blogs, presents at global SQL Server events and local user group meetings. She graduated from the University of Wisconsin, Milwaukee and has a post graduate certificate in Computer Science - Data Mining from the University of California, San Diego.@idigdatahttp://www.linkedin.com/in/jenunderwood http://www.jenunderwood.com/https://api.twitter.com/1/users/profile_image?screen_name=@idigdata484811535Jorge NovoJorge Novo is a senior ETL developer at lender processing services (LPS)
Specially in metadata driving applications and SSIS programming using. NET
Graduate from UNF in 2005 http://www.linkedin.com/pub/jorge-novo/1/546/b70http://etldevelopernotes.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=484810393Jose L. RiveraJose L, Business Analytics Manager at Abarca Health and College professor at University of Phoenix, has over 9 years of experience developing Business Intelligence solutions using SQL Server technologies, among others. In addition, he shares his knowledge and perspectives as PRPASS Community Leader, college professor and Co-Leader for the Azure and Global Spanish virtual chapters. He holds the MCTIP in Database Administration, Database Development and Business Intelligence for SQL Server 2008.@jlrivmirhttp://www.linkedin.com/profile/view?id=189422534http://www.jlrivmir.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jlrivmir484810167Kevin GoodeKevin first started programming on a Timex Sinclair 1000 when he was 11 years old. As a professional, Kevin has been designing and developing custom applications using Microsoft development tools since 1995. He has designed and developed large enterprise class applications and intranet applications for companies such as International Paper, LexisNexis, and Duke Energy. He moved from Cincinnati in 2006 to join Bit-Wizards, Custom Software Solutions headquartered in Fort Walton Beach, FL. @codepagodahttp://www.linkedin.com/in/kevingrohoskehttps://api.twitter.com/1/users/profile_image?screen_name=@codepagoda484810348Luis 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.nethttps://api.twitter.com/1/users/profile_image?screen_name=@luisefigueroa484811472Mark TabladilloMark Tabladillo (MVP, SAS Expert) has been an information technology professional since 1998, and has a primary career consulting with companies across the United States and around the world. Mark's business mission is to empower and inspire executives, architects and developers with insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark shares his thoughts on his professional blog at http://marktab.net@marktabnethttp://www.linkedin.com/company/marktab-consultinghttp://www.marktab.nethttps://api.twitter.com/1/users/profile_image?screen_name=@marktabnet484811426Maximo TrinidadOriginally from Puerto Rico, since 1979 I’ve work with legacy systems, network infrastructure, databases, and currently working as a BizTalk Application Engineer. I’m a Microsoft PowerShell MVP since 2008, SAPIEN MVP since 2010, and very involve with Florida’s IT Pro/SQLServer Communities.@MaxTrinidadhttp://www.linkedin.com/pub/max-trinidad/12/47/775http://www.maxtblog.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MaxTrinidad484810942Michael AntonovichMike Antonovich is the Assistant Director of Web Services for Orange County Public Schools in Orlando, FL where he manages the SharePoint portal team implementing the Internet, intranet, collaboration, project, team, and school sites. They are also responsible for multiple .Net custom applications throughout the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User's Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007@SharePointMikeAhttp://www.linkedin.com/in/michaelpantonovichhttp://sharepointmike.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SharePointMikeA484810150Mike DavisMike Davis, MCITP, is the Managing Project Lead at Pragmatic Works. He is an author of several Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.@MikeDavisSQLhttp://www.linkedin.com/in/mikedavissqlhttp://mikedavissql.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MikeDavisSQL484811936Pam 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/pshaw1129https://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw1129484811374Richie RumpRichie Rump is a software developer, data architect and project manager. He currently helps companies solve their data challenges using SQL Server and .Net. He holds the Project Management Professional (PMP), Certified Scrum Master (CSM) and various Microsoft development certifications. Richie is also the founder of the dotNet Miami, a community focused on enterprise development with .NET and SQL Server. His previous experience includes working with Burger King, FPL, Ryder and Walt Disney World.@Jorrisshttp://www.linkedin.com/in/richierumphttp://jorriss.nethttps://api.twitter.com/1/users/profile_image?screen_name=@Jorriss484811512Rob KerrRob is CTO with BlueGranite, a Microsoft Gold Partner. Rob is a Microsoft SQL Server MVP and holds top Microsoft certifications in both SQL Server Database Administration and BI Development. Rob has implemented data warehouse and business analytics systems for many Fortune 500 companies. Rob is the lead contributor to msbiacademy.com, a site providing free on-demand training covering a variety of Microsoft technology areas.@robkerrbihttp://www.linkedin.com/in/kerrrobhttp://www.robkerr.comhttps://api.twitter.com/1/users/profile_image?screen_name=@robkerrbi484810982Robert HattonRob Hatton is past President of the Tampa Bay SQL Server Business Intelligence User Group. He's a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments. He's currently working with Convergence Consulting group, a Florida based organization focused on providing B.I. solutions.@RobertSkBIhttp://www.linkedin.com/in/robertskoglundhttps://api.twitter.com/1/users/profile_image?screen_name=@RobertSkBI484811619SQL Saturday.484810147SQLSaturday 168484811949Thomas SpetnagelBefore joining Valpak, Tom was a ‘platinum’ consultant for ERP-industry giant SAP for over 5 years for customers like BMW, Hershey, Georgia-Pacific, Kimberly-Clark, and GE-Fanuc. Tom has held several positions at Valpak before his latest new role, Director of Business Intelligence. Tom holds a B.S. in Aerospace Engineering from University of Michigan, a Master of Science in Aerospace Engineering from Georgia Tech, and an MBA from Georgia Tech.http://www.linkedin.com/pub/thomas-spetnagel/24/367/35bhttp://www.valpak.com48481014710147SQLSaturday 168ALunch Break11/17/2012 12:15:00 PM11/17/2012 1:15:00 PM1014710147SQLSaturday 168BLunch Break11/17/2012 12:15:00 PM11/17/2012 1:15:00 PM1014710147SQLSaturday 168CLunch Break11/17/2012 12:15:00 PM11/17/2012 1:15:00 PM1014710147SQLSaturday 168DLunch Break11/17/2012 12:15:00 PM11/17/2012 1:15:00 PM1015010150Mike DavisANew SSIS Features in SQL 2012The newest version of SQL Server is out and packed with new features. Come see all of the newest features and best practices in SSIS 2012. Learn about the new SSIS parameters, environments, deployment, and the new tasks. Understand the new project deployment mode and how to execute SSIS 2012 packages with T-SQL.11/17/2012 9:30:00 AM11/17/2012 10:15:00 AM1016710167Kevin GrohoskeCA Developers Walk through MS BI Reporting StackMicrosoft’s SQL Server team has provided a unique set of capabilities for Business Intelligence. With PowerPivot, Power View, and SQL Server Reporting Services (SSRS) provides a full breadth of capabilities that can be utilized to mash up data across the enterprise. In this session we will walk through the product stack and determine how the tools fit in the ecosystem and how they can be utilized within your organization to provide greater insight into your business data.11/17/2012 8:30:00 AM11/17/2012 9:15:00 AM1031910319David EichnerCSRS Report Builder for Business IntelligenceLearn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!11/17/2012 11:30:00 AM11/17/2012 12:15:00 PM1034810348Luis FigueroaAChange Tracking and Change Data Capture Deep DiveIn this session Luis will cover beginning to end these two technologies key to delivering a real time data warehouse. Come join him to discuss different scenarios and some gotcha's he has learned and dealt with in real world implementations.
11/17/2012 1:30:00 PM11/17/2012 2:15:00 PM1035310353Anthony SammartinoBSSAS Tabular and Self Service BI - TheDynamDAX DuoIn this session I will cover how SSAS tabular and Self Service BI compliment each other and make the slicing and dicing of large amounts of data a breeze for Power Users. I will give a brief explanation and history of each then will walk through how to create a SSAS tabular model, get into how to create data relationships from a regular database model with large tables, then hook it up to Excel and expose the elements for users to slice and dice data with ease and create charts. Then will demonstrate a few DAX commands that are very powerful yet very easy. 11/17/2012 9:30:00 AM11/17/2012 10:15:00 AM1039310393Jose L. RiveraCPimp my BISM: Enhance VisualizationsWith the introduction of the BISM, originally used by PowerPivot, the power of analytics behind PowerPivot, PowerView and SSAS Tabular have grown to endless proportions. Nevertheless, having a good model is only half the work. In this session, we will show how to pimp your BISM and provide rich and powerful visualizations.11/17/2012 1:30:00 PM11/17/2012 2:15:00 PM1059710597Christopher PriceAIntegrating DQS, MDS and Your Data Warehouse With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.11/17/2012 11:30:00 AM11/17/2012 12:15:00 PM1083510835Andy WarrenDBuilding Your Professional Development PlanPlan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.11/17/2012 2:30:00 PM11/17/2012 3:15:00 PM1094210942Michael AntonovichBCube World for Flat Table LandersThis session will explore the tabular approach to building cubes in SQL Server Analysis Services 2012 for DBA’s more comfortable with relational databases. Starting with a ‘normal’ relational database, you will learn how to define your measure and dimensions, define hierarchies, and build functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as well for their more demanding models.11/17/2012 10:30:00 AM11/17/2012 11:15:00 PM1094410944Michael AntonovichDHello, My Name Is DAXFor anyone doing serious work with PowerPivot, you know that you must sometimes create additional columns calculated from the data in your existing data sources. If your data source is SQL Server, you could do this in SQL directly by just connecting to a custom view. However, for most other data sources (and for those users without development access to SQL Server) the best alternative is building expressions in PowerPivot to define new columns. DAX is also used to join tables on multiple columns and to create calculated measures. This session will explore DAX functions and expressions and how they differ from Excel expressions. We will even show how to use DAX expressions to create new measures.11/17/2012 1:30:00 PM11/17/2012 2:15:00 PM1098210982Robert HattonCThe server side of Reporting ServicesThis session will cover important information about how to set up Reporting Services. We'll go beyond the simple installation and configuration issues. Covered topics will include shared data sources, managing the folder structure, using linked reports, and the management user interfaces. We'll also cover the database that Reporting Services uses to house report definitions.11/17/2012 9:30:00 AM11/17/2012 10:15:00 AM1116711167Dustin Ryan Mitchell PearsonASSIS 2012 In Yo' Face: Introduction to SSISDustin is a Sr. BI Consultant (MCTS,MCITP) and hitman/ninja assassin for Pragmatic Works. Dustin develops BI solutions with SSRS, SSIS, SSAS. Dustin has also worked as a technical editor on various books. You can find Dustin speaking at events like SQL Saturday, SQL Rally, Code Camp, online webinars. Mitchell Pearson is a customer support rep with Pragmatic Works, experienced in developing supporting BI solutions utilizing SSRS SSIS. Mitchell can be found supporting the customers, speaking at SQL Saturday events, and working as a carny at a Mexican carnival.11/17/2012 8:30:00 AM11/17/2012 9:15:00 AM1124611246Kevin GoodeBDown on the FarmElastic computing, horizontal scaling, always on, shared services: these are great buzz words and sound so easy when described in CIO magazine. Implementing and managing these concepts is no easy task. This session will take an in-depth look at the implementation of a SSIS server farm and a SSAS server farm. The discussion points will include: how to load balance across the farm, how to achieve always on, how to scale out, how to automate the whole thing and what developers need to do to use the farm.11/17/2012 11:30:00 AM11/17/2012 12:15:00 PM1124711247Kevin GoodeALet’s get parallelHave you ever wondered how Microsoft and Unisys loaded 1TB of data in 30 minutes? They used as many parallel processes as possible. This session will walk through a solution that makes heavy use of parallel processing. We will look at the use of scope to isolate threads and script tasks to determine and spread the workload across multiple threads. Additionally, we will look at how to determine how many parallel processes should be run on a single server and techniques to spread loads over multiple servers. 11/17/2012 3:30:00 PM11/17/2012 4:15:00 PM1129911299Jen UnderwoodDWhat's New for Microsoft Business IntelligenceIn this demo packed session we will cover what is new for BI pros in Excel 2013, Office 365, SharePoint 2013, and SQL Server 2012 SP1. We we dig into the newer paradigm of BI technologies including Excel 2013, Power View, Office Apps, PerformancePoint, Visio Services, Reporting Services, PowerPivot, Business Connectivity Services and other improvements across a variety of on-premise, cloud, mobile and hybrid BI delivery scenarios. 11/17/2012 9:30:00 AM11/17/2012 10:15:00 AM1134211342Chad ChurchwellDDesigning An Efficient Replication TopologyWith replication being a source for many data warehouse systems, this 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 business needs will also be covered.11/17/2012 11:30:00 AM11/17/2012 12:15:00 PM1137411374Richie RumpDIntro to Project Management for BI ProfessionalsThe IT industry isnow being dominated by projects. This session is designed to present a high-level foundational knowledge of the project management process. It will also focus on the tools that BI professionals can use to deliver projects on time and on budget.11/17/2012 3:30:00 PM11/17/2012 4:15:00 PM1139611396Jose L. RiveraCPredictive Analytics at your fingertipsThe Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.11/17/2012 4:30:00 PM11/17/2012 5:15:00 PM1142611426Maximo TrinidadDPowerShell Working with XML and SMOCome and learn some basic technique on how to use PowerShell to work with your XML file. XML files are everywhere and you need to be prepare to use your tools that already are available at your fingertip. In this case, using PowerShell with SMO and Sapien XML editor which is a great tools. Also, I will be demostrating one particular scenario on how to convert UTC XML generated Dates to PowerShell w/SMO and T-SQL DateTime. You will get some PowerShell, T-SQL, and creating/viewing XML schemas in this session.11/17/2012 8:30:00 AM11/17/2012 9:15:00 AM1145611456Adam JorgensenBRoping the Elephant - Hadoop and BI Live!
Have you been wondering how you can sit down at work and use Hadoop to make your BI better? Have you thought about what Big Data could mean to your firm? Come watch Adam setup, populate, consume and integrate data from a Big Data Platform into a SQL BI solution Live!11/17/2012 1:30:00 PM11/17/2012 2:15:00 PM1147211472Mark TabladilloBApplied Enterprise Semantic MiningSQL Server 2012 debuts a new Semantic Platform (commonly known as the applied task, Semantic Search). This text mining technology leverages the already established Full Text Index, and builds semantic indexes in a two-phase process. This presentation provides a science description and demo for the Enterprise implementation of Tag Index and Document Similarity Index. At present (RC0), the indexes work for 15 languages. Included are strategy tips for how to best leverage the technology along with already-existing Microsoft text mining and data mining.11/17/2012 4:30:00 PM11/17/2012 5:15:00 PM1149511495Brian MitchellDMonitoring your BI SolutionYou've built your BI solution, now how do you monitor it. Is it performing well? What is your baseline?
This session will delve into the monitoring of SSRS and SSAS environments and what you can do with the tools out of the box.11/17/2012 10:30:00 AM11/17/2012 11:15:00 PM1151211512Rob KerrBIncorporating Hadoop into your DW/BI StrategyThis session provides a technical overview of Hadoop targeted for Microsoft DW/BI professionals. Emphasis will be on how Map/Reduce paradigms complement and extend BI architectures. Specifically highlighted will be the Hadoop ecosystem, HDFS, Cloud vs. On-Premise, and various strategies to integrate SQL and NoSQL technologies into cohesive solutions.11/17/2012 2:30:00 PM11/17/2012 3:15:00 PM1151311513Rob KerrBDesigning a SQL 2012 BI ArchitectureLearn how to combine SQL Server and SharePoint technologies to deliver compelling insights and rich data exploration. This session covers architecture and deployment planning for BI solutions using SQL Server, Analysis Services, PowerPivot, Power View, Excel Services and related technologies.
11/17/2012 8:30:00 AM11/17/2012 9:15:00 AM1152711527Brian K McDonaldCReporting Services Deep DiveSQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - Features added in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it **11/17/2012 3:30:00 PM11/17/2012 4:15:00 PM1153511535Jorge NovoASSIS Complex file structures ETL In this session I am going to demonstrated the design and structure of how to process complex file structures.
Learn some of the techniques to Load your data warehouse.11/17/2012 2:30:00 PM11/17/2012 3:15:00 PM1156511565Ira WhitesideACreating 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.11/17/2012 10:30:00 AM11/17/2012 11:15:00 PM1156611566Ira WhitesideASSIS Package Realtime Visualzation AnalyticsImplement an SSIS Framework to track the progress of SSIS production packages similar to how you can in the BIDS Designer, and explore your package withs windows explorer like capability.Utilizing the “out of the box” SSIS Logging with no changes required to the existing logic or packages. The new framework will also use SSIS to scan existing packages and automatically discover Master / Child package relationships and providing a capability for package restartability. This design pattern can be use to replace earlier “Stored Proc” version of SSIS Framework greatly reducing the code required. This functionality is complementary to the 2012 Package Tracking capability.11/17/2012 4:30:00 PM11/17/2012 5:15:00 PM1161911619SQL SaturdayARaffles PrizesJoin us to say thanks to our sponsors, speakers, organizers and attendees and for a chance to win books and other great prizes.11/17/2012 5:30:00 PM11/17/2012 6:00:00 PM1161911619SQL SaturdayBRaffles PrizesJoin us to say thanks to our sponsors, speakers, organizers and attendees and for a chance to win books and other great prizes.11/17/2012 5:30:00 PM11/17/2012 6:00:00 PM1161911619SQL SaturdayCRaffles PrizesJoin us to say thanks to our sponsors, speakers, organizers and attendees and for a chance to win books and other great prizes.11/17/2012 5:30:00 PM11/17/2012 6:00:00 PM1161911619SQL SaturdayDRaffles PrizesJoin us to say thanks to our sponsors, speakers, organizers and attendees and for a chance to win books and other great prizes.11/17/2012 5:30:00 PM11/17/2012 6:00:00 PM1189911899Robert SkoglundBBI with Big DataIn this session we will overview what Big Data has to offer to Business Intelligence.11/17/2012 3:30:00 PM11/17/2012 4:15:00 PM1190811908James McAuliffe CReport With Power:Bring All Your Data to the TableBy now, we have been hearing a lot about the new Power* tools. PowerPivot, PowerView, and the tabular data model. But what does it all mean? How can you put these tools to work for you? This session provides examples of powerfully combining data from lots of different sources in creative ways, to achieve new insights. This session will walk you through real life scenarios, using these tools to fill in missing and move from “if only” to “what if”.11/17/2012 10:30:00 AM11/17/2012 11:15:00 PM1193611936Pam ShawCTaking 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. 11/17/2012 2:30:00 PM11/17/2012 3:15:00 PM1194911949Thomas SpetnagelDPractical BI: Maximizing Productivity ValueIn my presentation “Practical BI: Strategies IT Can Use To Maximize Its Productivity and Value To The Business”, I will review strategies that the BI technical team is using at Valpak to provide the best service to our business stakeholders. In particular, I will discuss the ‘agile development’ methodology we are employing, and will detail the special refinements we’ve made to accommodate the unique challenges of BI development. I will also describe specific practices to facilitate productivity that can be employed in any BI shop regardless of project management.11/17/2012 4:30:00 PM11/17/2012 5:15:00 PM