SQLSaturday #203 - Boston 20134/6/2013 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. #sqlsat203Microsoft1 Cambridge CenterCambridgeMA021422938SIOS Technologyhttp://us.sios.com/company/about-us/http://us.sios.com/wp-content/uploads/2011/12/PartnerPortal/Logos_Guidelines/logo-1.png601702945Data Educationhttp://dataeducation.comhttp://dataeducation.com/dataeducation170x60.png601702857Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702881Pragmatic Workshttp://pragmaticworks.com/PragmaticWorksHome.aspxhttp://pragmaticworks.com/images/Logo/PragmaticWorksLogo.jpg601703024Dell Software Grouphttp://www.quest.com/http://i.imgur.com/BAdC3.png601703052Melissa Datahttp://www.melissadata.comhttp://www.melissadata.com/images/mdlogo-color-tag-170x60.gif601703175Precise Software Solutionshttp://www.precise.comhttp://www.precise.com/images/common/logo.png601703176Sanbolic, Inc.http://www.sanbolic.comhttp://info.sanbolic.com/rs/sanbolic/images/Sanbolic logo.png601702869PASS Headquartershttps://www.sqlpass.orghttp://www.sqlsaturday.com/images/PASS_logo.jpg601702890Pluralsighthttp://www.pluralsight.com/http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-500x109-v1.png601702968COZYROChttp://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601702993Redgatehttp://redg.at/VPjrYFhttp://crankydba.com/sqlsat203/redgate.jpg601703209SQLHAhttp://www.sqlha.comhttp://www.sqlha.com/wp-content/themes/sqlha/images/logo.png601703071Sql Power Tools, Inc.http://www.sqlpower.comhttp://www.sqlpower.com/img/spt_logo_sql_saturday.png6017012767Allan HirtCluster MVP Allan Hirt is a consultant, published author, speaker, and trainer who has been using Microsoft SQL Server in various guises since 1992. He is currently based in the Boston, MA, area and travels all over the world to work with and train clients. His most recent book is 'Pro SQL Server 2008 Failover Clustering' (Apress) and is currently working on its sequel, Mission Critical SQL Server 2012 due in 2013.@SQLHAhttp://www.linkedin.com/pub/allan-hirt/1/b72/673http://www.sqlha.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLHA484813227Andy RobertsAndy Roberts is a Data Platform Technology Specialist for Microsoft in the Northeast district. and has spent 12 years as a consultant for Microsoft Consulting Services. As a consultant Andy assisted customers in implementing mission critical OLTP and DW/BI solutions on SQL Server. Andy wore many hats as a consultant including application developer, solution architect, mentor to development teams, mentor to DBAs, BI lead, SCRUM Master, and the guy-that-knows-a-bunch-of-stuff-about Microsoft. @_andy_roberts_http://www.linkedin.com/pub/andy-roberts/0/126/793/http://blogs.msdn.com/andyrobertshttps://api.twitter.com/1/users/profile_image?screen_name=@_andy_roberts_484812667Ayad ShammoutAyad Shammout has been involved in IT for 23 years as a Developer, System Analyst and Database Consultant. He has a long experience in Microsoft Platforms and products primarily specialized in SQL Server, SharePoint and Windows OS. He is working in OLTP design and development, Data Warehousing, and Business Intelligence. Ayad has been involved in many SQL Server Enterprise implementations for Business Intelligence, High-Availability, Disaster Recovery, Infrastructure Design and Virtualization@aashammouthttp://www.linkedin.com/in/ayadshammouthttps://api.twitter.com/1/users/profile_image?screen_name=@aashammout484812468Benjamin NevarezBenjamin Nevarez is a database professional based in Los Angeles and author of “Inside the SQL Server Query Optimizer”, published by Red Gate books. He has more than 15 years of experience with relational databases, and has been working with SQL Server since version 6.5. Benjamin has also been the technical editor of the two latest books by Kalen Delaney including “SQL Server 2008 Internals”. He has been a speaker at several technology conferences, including the PASS Summit and SQL Connections.@BenjaminNevarezhttp://www.benjaminnevarez.com/https://api.twitter.com/1/users/profile_image?screen_name=@BenjaminNevarez484812744Bradley BallBradley Ball is a SQL MCITP with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. He is a Sr. Consultant with Pragmatic Works specializing in DBA and BI solutions. He has presented at SQL Saturdays, MAGICPASS OPASS, SQL Rally, DevConnections, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com@SQLBallshttp://www.linkedin.com/in/sqlballshttp://www.sqlballs.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLBalls484812631Brandon LeachBrandon is a veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he fell in love with SQL Server and database development and administration. Currently he is manages 89+ SQL Servers for Network Health in Medford, Ma. He works closely with the developement, infrastructure, and management in and out of IT to make sure the needs of the business and its future goals are met.
He is also the Chief organizer for SQLSaturday Providence, RI@SQLServerNerdhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLServerNerd484812390Chad 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=@chadchurchwell484813834Christina LeoChristina Leo is a Boston based independent consultant specializing in T-SQL development and performance tuning. She's currently working with Adam Machanic on an investment fund management data warehouse project. Previously, she worked as a database developer for Jack Henry Associates. She actively participates in the SQL Server community speaking at local user group meetings and SQL Saturdays. She’s also one of six Idera ACEs (Advisor and Community Educator) for 2012-2013.@christinaleohttp://www.linkedin.com/pub/christina-leo/a/839/9aahttp://christinaleo.nethttps://api.twitter.com/1/users/profile_image?screen_name=@christinaleo484812506Dan ClarkDan Clark is a senior BI consultant for Pragmatic Works. As a member of the Pragmatic Works SEAL Team (Special Engagements and Learning) he is focused on learning new BI technologies and training others how to best implement the technology. Dan has published several books and numerous articles on .NET programming and BI development. He is a regular speaker at various developer/database conferences and user group meetings.http://www.linkedin.com/in/dxclarkhttp://drclarkblog.wordpress.com/484812751Grant FritcheyGrant Fritchey is a SQL Server MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. He joined Red Gate Software as a Product Evangelist in January 2011.@gfritcheyhttp://www.linkedin.com/in/scarydbahttp://www.scarydba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@gfritchey484812370John MinerJohn has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA). John is currently a Senior SQL Server Developer / Administrator in charge of best practices by the IT team at Sensata Technologies. He is the PASS chapter leader for Southern New England.@JohnMiner3http://www.linkedin.com/pub/john-miner/a/85a/889http://www.craftydba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@JohnMiner3484812368Joseph D'AntoniJoey D'Antoni is a frequent speaker at SQL Saturday events. He is a SQL Server Architect at Comcast in West Chester, Pennsylvania with 10+ years of experience working on a wide variety of database platforms. His specialties include DR, HA and Virtualization.
@jdantonhttp://joedantoni.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484812373Michael CoreyMichael Corey, Founder of Ntirety. Michael is a frequent speaker at technology conferences throughout the world. Michael is an VMware vExpert , Oracle ACE, and is on Talkin’ Cloud 200 Computing Executives and Experts List. Michael is a past president of the IOUG; he helped found the Professional Association of SQL Server. He is a frequent blogger for Database Trends Applications. He written numerous articles and books published on topics as Microsoft SQL Server to Tuning Oracle.@Michael_Coreyhttp://www.linkedin.com/pub/michael-corey/1/795/66bhttp://michaelcorey.ntirety.com/https://api.twitter.com/1/users/profile_image?screen_name=@Michael_Corey484812332Paresh MotiwalaParesh Motiwala is a Microsoft SQL Database Administrator with Bingham McCutchen in Boston. He has presented SQL topics at various forums. Paresh engages in public speaking on a variety of topics and trains children in the same art. He also does occasional standup comedy. True to Paresh's networking passion, he can be contacted at , http://gplus.to/pareshmotiwala, pareshmotiwala@gmail.com amongst other ways as given below.http://www.linkedin.com/in/pareshmotiwalahttps://api.twitter.com/1/users/profile_image?screen_name=484813051Peter MyersPeter has 16 years of solid experience working in OLTP database design and Business Intelligence with SQL Server and SharePoint. In April 2012, Peter was re-awarded Microsoft MVP (Most Valuable Professional) for the sixth time. Peter enjoys sharing his enthusiasm for Microsoft technologies by presenting at SQL Server user group meetings and technical events, including TechEd in North America, Europe and Australia.http://www.linkedin.com/in/peterjsmyershttps://api.twitter.com/1/users/profile_image?screen_name=484812720SB Chatterjee Architect/Tech-lead in Hartford CT with over 20 years IT experience. Worked at companies like Aetna, IBM, Microsoft, UNICEF, United Technologies and State of Connecticut. Graduate degrees in Computer Science, Business Administration and Economics. Awarded the Microsoft MVP Award for SharePoint products 6 times since 2008. He is fairly active in the SharePoint StackExchange and other forums. Twitter: @sbc111 Acting Director - CT.NET Dev Group (CTDOTNET) CT SharePoint Dev Group (CTSPDG).@sbc111http://weblogs.asp.net/sbchatterjee/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@sbc111484812786Scott KleinScott Klein is a Windows Azure Technical Evangelist for Microsoft, focusing on Windows Azure data services, including Windows Azure SQL Database and Windows Azure Storage. Scott has been working with SQL Server for over 20 years. Prior to Microsoft Scott was one of the first 4 SQL Azure MVPs. Scott is the author of over ½ dozen books, including Pro SQL Azure by APress. He can also be found speaking at conferences around the world, such as TechEd, DevConnections, and SQL PASS.@SQLScotthttp://www.linkedin.com/in/sqlscotthttp://www.scottlklein.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLScott484812341SQL Saturday 203Event staff@mikehillwighttp://www.linkedin.com/in/mikehillwighttps://api.twitter.com/1/users/profile_image?screen_name=@mikehillwig484812314SQLSaturday 203484812375Stacia MisnerStacia Misner has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft’s business intelligence technologies since 2000. She is a SQL Server MVP, SSAS Maestro, MCITP, MCTS, and has authored or co-authored multiple books and articles about Microsoft business intelligence technologies.@StaciaMisnerhttp://www.linkedin.com/in/staciamisner http://blog.datainspirations.comhttps://api.twitter.com/1/users/profile_image?screen_name=@StaciaMisner484812330Steve SimonSenior Business Intelligence Development Engineer at Atrion Networking Corporation. He has been involved with database design and analysis for over 20 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2010. He has just recently presented a Business Intelligence paper at Oracle World in San Francisco . Steve has also presented 5 papers at the Information Builders' (IBI) International Summits. He is a PASS regional mentor chair of the Oracle/SQL VC.@#SQLServerBoffinhttp://www.linkedin.com/in/stephenrsimonhttp://www.infogoldusa.comhttps://api.twitter.com/1/users/profile_image?screen_name=@#SQLServerBoffin484812386Sunil KadimdiwanSunil Kadimdiwan Sunil Kadimdiwan has 25+ years’ experience in architecting and implementing database solutions. He has deep knowledge of the Microsoft SQL Server and Business Intelligence technology stack. He is a frequent speaker at SQL Saturdays, Code Camps, User Group meetingshttp://www.linkedin.com/in/sunilkadimdiwanhttp://www.infotrove.com/events.html484812318Thomas LaRockThomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas holds a MS degree in Mathematics from WSU. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MCM and MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).@https://twitter.com/#!/SQLRockstarhttp://www.linkedin.com/in/sqlrockstarhttps://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/#!/SQLRockstar484813421Tim SidorTim is a Data Quality Analyst at Melissa Data, with over 12 years experience in consulting clients to integrate data quality solutions and advise implementation strategies and custom solutions to improve database quality and performance.484812452Varsham PapikianVarsham Papikian works as a Principal Database Developer/DBA/Architect at Wolters Kluwer Financial Services. He has 15 years of experience working with database technologies. He is a mentor and a frequent speaker at different events and user group meetings. Varsham helps to run two SQL Server-related user groups in Boston area: 'New England SQL Server User Group' and 'Boston BI User Group'. He also helps others at different online forums like MSDN.http://www.linkedin.com/in/varshampapikian48481231412314SQLSaturday 203Hawthorne (4018)Registrations4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1231412314SQLSaturday 203Longfellow (4028)Registrations4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1231412314SQLSaturday 203Thoreau (4038)Registrations4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1231812318Thomas LaRockHawthorne (4018)Database Design: Size DOES MatterGreat database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 4/6/2013 9:45:00 AM4/6/2013 10:45:00 AM1233012330Steve SimonConstitution (2033)Database design for mere developersSQL Server 2012: Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development 'patterns and anti-patterns', final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1233112331Steve SimonBunker Hill (2006): Get your Mining Model Predictions out to allSQL Server 2012: Over the past 18 months many financial and portfolio management firms have been severely ‘hit’ by the depressed markets and poor economic conditions.This lead to risk exposure and considerable client liability.We like many firms have gone through the 'teething process'with regards to data mining model predictions and have now taken our systems from the prototype stage to our “shop floor” and are getting the 'good word' out to management via SQL Server Reporting Services.4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1233212332Paresh MotiwalaConstitution (2033)Network or PerishAs IT personnel, we tend to get boxed-in, stranded on our own little island. We fail to make people aware of our activities, both within our own organization and in our wider professional circles. Just like a shipwrecked captain waiting for the rescue boat on a desert island, if you fail to communicate, your career will be stuck with no possibility of progression. This presentation will show you how to leverage networking and self-marketing techniques that will allow you to set sail off the island and into new opportunities.
4/6/2013 4:00:00 PM4/6/2013 5:00:00 PM1234112341SQL Saturday 203Hawthorne (4018)Keynote/KickoffAdam Machanic will kick off the day's event4/6/2013 8:30:00 AM4/6/2013 9:00:00 AM1234112341SQL Saturday 203Longfellow (4028)Keynote/KickoffAdam Machanic will kick off the day's event4/6/2013 8:30:00 AM4/6/2013 9:00:00 AM1234112341SQL Saturday 203Thoreau (4038)Keynote/KickoffAdam Machanic will kick off the day's event4/6/2013 8:30:00 AM4/6/2013 9:00:00 AM1234712347SQL Saturday 203Hawthorne (4018)Ask the Experts: Database AdministrationHave a question that wasn't answered today? Throw it to our panel of experts to see what they think.We'll take as many questions as possible. You'll have an opportunity throughout the day to provide your questions to our volunteers.4/6/2013 12:15:00 PM4/6/2013 1:15:00 PM1236812368Joseph D'AntoniConcord (2018)SQL 2012 -- All About HA and DRHave you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start? In this session we will walk through the process of creating a disaster recovery plan for your organization, the HA and DR options within SQL Server, and finally a demonstration of the new Availability Groups feature in SQL Server 2012 and see them in practice.4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1237012370John MinerBunker Hill (2006): How to audit and prevent unwanted user actions.Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes. 1 – Granting correct user access is vital 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications 5 – Preventing table TRUNCATIONS 6 – Preventing unwanted SCHEMA changes 7 – New Feature (2008) – change data capture4/6/2013 4:00:00 PM4/6/2013 5:00:00 PM1237312373Michael CoreyLongfellow (4028)Virtualizing SQL Server 2012: Doing IT RightSession Description: A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If it is not done correctly you will not be successful. This presentation will teach the you how to do it right. We will discuss why you virtualize a database, using the right hypervisor, installation, Architecting for performance, the storage layer, the processor, Memory considerations, the network layer. This presentation focuses on VMware but much of the information is relevant in any virtualized environment. 4/6/2013 9:45:00 AM4/6/2013 10:45:00 AM1237512375Stacia MisnerThoreau (4038)A Big Data PrimerThe term 'big data' dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.4/6/2013 9:45:00 AM4/6/2013 10:45:00 AM1237612376Stacia MisnerConstitution (2033)Taking BI to the Next Level: CollaborationSelf-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration.4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1238612386Sunil KadimdiwanConstitution (2033)Self Service BI: Office 2013 and SQL 2012In this session I will focus on how you can use the new features of Office 2013 such as Power View in Excel. How do you connect to multiple data models? How can you layout your data on a Map? How can you drill down to the details? And much more.4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1239012390Chad ChurchwellBunker Hill (2006): Designing 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.4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1245212452Varsham PapikianBunker Hill (2006): Secrets of SQL Server Management Studio (SSMS)SQL Server Management Studio is a complex tool which database professionals use every day. Yet many people are not aware of some 'hidden' features in SSMS. During the session I will describe some of them using SSMS 2012. A few of them should also work in earlier versions of SSMS too.4/6/2013 9:45:00 AM4/6/2013 10:45:00 AM1246812468Benjamin NevarezThoreau (4038)Top Query Optimizer Topics for Better PerformanceThis session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1246912469Benjamin NevarezThoreau (4038)Dive into the Query Optimizer-Undocumented InsightThis 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1247612476Joseph D'AntoniLongfellow (4028)Using PowerView and Hadoop to Unlock Hidden MarketA practical way to derive business value from big data is to microtarget customers, but where do you begin? In this session, we examine real data from one of the nation's largest cable TV providers and combine it with data from the 2010 census and other data sources. In addition, we demonstrate how to use Hadoop and the Microsoft BI stack with this integrated data to develop powerful analytics quickly and easily. We demystify the process of working with big data by showing you first how to gather and load the data into Hadoop, and then how to extract a subset of that data and apply data visualization to reveal insightful patterns that can be used to connect more effectively with customers.
4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1250612506Dan ClarkLongfellow (4028)Building Your First Tabular ModelWith the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine. To use the new Vertipaq engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to query the data, create calculations, measures, and KPI’s.This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded). We will import data from a SQL Server relational database into a tabular model project and create relationships between the tables. We will use DAX to create and manage calculations, measures, and Key Performance Indicators4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1263112631Brandon LeachConstitution (2033)A DBAs Guide to HIPAAIn this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve.
We'll also dive into several features in SQL Server that can help in this endeavor. 4/6/2013 9:45:00 AM4/6/2013 10:45:00 AM1266712667Ayad ShammoutBunker Hill (2006): Building BI Semantic Model Tabular in 60 minutesSQL Server 2012 introduces the new Analysis Services Tabular Mode. BI Semantic Model (BISM) Tabular is in-memory database in Analysis Services using state-of-the-art compression algorithms. BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add-in. In this session, I will show you how to build a complete solution in Tabular and creating one from the ground up, deploy a rich semantic model and discover a simpler method for analyzing business data. You also learn the basics of DAX language and how to manage role based security and partitioning in a Tabular model. You will be able to create your BISM Tabular models, and gain a solid background to enable you starting your next project.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1272012720SB ChatterjeeConcord (2018)Get-PowerShell | Get-SQLServerPowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).
4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1274412744Bradley BallHawthorne (4018)SQL Internals , Recovery Models, Backups! OH MYThe more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1275112751Grant FritcheyConcord (2018)Tune Queries By Fixing Bad Parameter Sniffing Parameter sniffing is a misunderstood issue on SQL Server. Most of the time, parameter sniffing is helping performance on your servers. But sometimes, circumstances change, and what was helping you is now hurting you – bad. In this session, we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then we’ll explore how parameter sniffing can go wrong and look at seven different ways you can deal with it when it does. You’ll take away a wealth of knowledge that will help you identify and resolve bad parameter sniffing in your own environment.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1275212752Grant FritcheyLongfellow (4028)What to Look for in Execution PlansYou've heard often enough that you need to look at execution plans to understand what's going on with a query. But what are you supposed to look at? This session answers that question, providing a step-by-step set of considerations for evaluating your execution plans. We'll look at the aspects of an execution plan that should be immediately checked, why they should be checked, and provide some guidance for what to do about what you find. You'll be able to apply this information to your SQL Server 2012 systems as well as older versions of SQL Server.4/6/2013 4:00:00 PM4/6/2013 5:00:00 PM1276712767Allan HirtHawthorne (4018)Demystifying Clustering for the DBAThe word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering ... but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you're looking to deploy the latest and greatest.4/6/2013 4:00:00 PM4/6/2013 5:00:00 PM1278612786Scott KleinConcord (2018)Kung Fu Migration to Windows Azure SQL DatabaseAs cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master.4/6/2013 9:45:00 AM4/6/2013 10:45:00 AM1304313043Allan HirtHawthorne (4018)Business Continuity: The Real Reason for HA and DRThese days, I've stopped counting how many times I've been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1305113051Peter MyersHawthorne (4018)What's New for Self-Service BI in Excel 2013The self-service BI capabilities in Excel 2013 are growing in leaps and bounds! This presentation describes and demonstrates the PowerPivot and Power View functionality embedded inside the Excel client. Demonstrations will focus on the new features supported by both tools in Excel 2013. This presentation is relevant to those already experienced with PowerPivot and Power View, as well as those new to each.4/6/2013 11:00:00 AM4/6/2013 12:00:00 PM1305213052Peter MyersThoreau (4038)Introduction to SQL Server 2012 MDS and DQSThis presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).
MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.
DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.4/6/2013 4:00:00 PM4/6/2013 5:00:00 PM1322713227Andy RobertsLongfellow (4028)Database Dev ALM with SQL Server Data ToolsTransform traditional database development by using SQL Server Data Tools - a declarative, model-based experience that supports both online and offline (project-based) database development. 4/6/2013 2:45:00 PM4/6/2013 3:45:00 PM1323813238SQLSaturday 203Hawthorne (4018)Sponsor SpotlightPlatinum Sponsor Spotlight4/6/2013 9:15:00 AM4/6/2013 9:30:00 AM1323813238SQLSaturday 203Longfellow (4028)Sponsor SpotlightPlatinum Sponsor Spotlight4/6/2013 9:15:00 AM4/6/2013 9:30:00 AM1323813238SQLSaturday 203Thoreau (4038)Sponsor SpotlightPlatinum Sponsor Spotlight4/6/2013 9:15:00 AM4/6/2013 9:30:00 AM1342113421Tim SidorThoreau (4038)Matching and SurvivorshipThe spectrum of Contact Data Quality covers numerous interrelated aspects such as parsing, standardization, correction, verification, enrichment and matching. But one crucial concept that is quite commonly overlooked in the field of data quality is the implementation of an intelligent and automatable process for the creation of the “golden record” through the consolidation of data within the matching process; a technique also known as Survivorship.4/6/2013 1:30:00 PM4/6/2013 2:30:00 PM1343813438SQL Saturday 203Hawthorne (4018)Prizes, Raffles, and RemarksEnd of the day remarks with prizes from our vendors and a few items raffled off by the event. 4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1343813438SQL Saturday 203Longfellow (4028)Prizes, Raffles, and RemarksEnd of the day remarks with prizes from our vendors and a few items raffled off by the event. 4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1343813438SQL Saturday 203Thoreau (4038)Prizes, Raffles, and RemarksEnd of the day remarks with prizes from our vendors and a few items raffled off by the event. 4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1383413834Christina LeoConcord (2018)Why APPLY?Most T-SQL developers know that the APPLY operator can be used to invoke a table valued function. But did you know that it can also be used to join to derived data sets, return multiple columns from a sub-query, shred XML, create working columns for use with the WHERE and GROUP BY clauses, and replace the UNPIVOT operator? If not, then why not take your skills to the next level, and come see each use case in action, using real-world examples. You'll leave the session with thorough understanding of the full potential of this versatile operator, as well as a few new tricks up your T-SQL sleeves.4/6/2013 4:00:00 PM4/6/2013 5:00:00 PM1413814138SQL Saturday 203Thoreau (4038)Ask the Experts: Application DevelopmentHave a question that wasn't answered today? Throw it to our panel of experts to see what they think.We'll take as many questions as possible. You'll have an opportunity throughout the day to provide your questions to our volunteers.4/6/2013 12:15:00 PM4/6/2013 1:15:00 PM1413914139SQL Saturday 203Longfellow (4028)Ask the Experts: Business IntelligenceHave a question that wasn't answered today? Throw it to our panel of experts to see what they think.We'll take as many questions as possible. You'll have an opportunity throughout the day to provide your questions to our volunteers.4/6/2013 12:15:00 PM4/6/2013 1:15:00 PM1446514465SQL Saturday 203Concord (2018)Sponsor Spotlight - Quest SoftwareSponsor Spotlight - Quest Software4/6/2013 12:15:00 PM4/6/2013 1:15:00 PM1446614466SQL Saturday 203Bunker Hill (2006): Sponsor Spotlight - SIOSSponsor Spotlight - SIOS4/6/2013 12:15:00 PM4/6/2013 1:15:00 PM