SQLSaturday #121 - Philadelphia 20126/9/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. #sqlsat12145 Liberty Blvd., Suite 210MalvernPA193551788ConfioGold Sponsorhttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601701886AnexinetGold Sponsorhttp://www.anexinet.comhttp://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/Anexinet_Logo_Lg_jpeg_300.jpg601702118IderaGold Sponsorhttp://www.idera.comhttp://www.idera.com/images/Logo-Idera.png601702234Microsoft CorporationGold Sponsorhttp://www.microsoft.com/en-us/mtc/locations/philadelphia.aspxhttp://www.microsoft.com/global/oneMscomSettings/PublishingImages/Microsoft_logo.png601702293GridIron SystemsGold Sponsorhttp://www.gridironsystems.comhttp://www.gridironsystems.com/wp-content/uploads/2011/02/GridIron_Logo42.png601702259Quest SoftwareGold Sponsorhttp://www.quest.com/http://www.quest.com/images/common/quest_logo.gif601702284RDA CorporationSilver Sponsorhttp://www.rdacorp.comhttp://www.rdacorp.com/wp-content/uploads/RDA-logo-170-x-60.jpg601702302SapienSilver Sponsorhttp://www.sapien.comhttp://www.sapien.com/assets/img/logo3.png601702317ConfioSilver Sponsorhttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702325XtiviaSilver Sponsorhttp://www.Xtivia.comhttp://www.xtivia.com/images/XtiviaLogo-170x60.jpg601702239Branegy Systems IncSilver Sponsorhttp://branegy.comhttp://branegy.com/global/img/branegy_logo.png601702242CSS Technical ServicesSilver Sponsorhttp://www.contemporarystaffing.com/http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/CSS_TechServlogo.jpg601702063Aspect ConsultingSilver Sponsorhttp://www.aspect-consulting.com/http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/AspectConsulting.jpg601702100Red Gate SoftwareSilver Sponsorhttp://www.red-gate.com/?utm_source=ugutm_medium=uglogoutm_content=sqlsat121phillyutm_campaign=redgatehttp://www.red-gate.com/assets/images/common/logo.png601701813Perpetual Technologies, Inc.Silver Sponsorhttp://pti.nethttp://www.pti.net/Logo/logo170x60.jpg601701867O'Reilly BooksSilver Sponsorhttp://oreilly.comhttp://oreilly.com/images/orn_logos/oralogo_bk200.gif601701881Robert Half TechnologySilver Sponsorhttp://www.rht.comhttp://www.roberthalftechnology.com/External_Sites/content/RHT-2009/Shared/Images/rht_logo.gif601701808Cozy RocBronze Sponsorhttp://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601701906Bronze Sponsorhttp://www.linchpinpeople.comhttp://linchpinpeople.com/wp-content/uploads/2012/02/linchpin_logo_trans.png601702288CapTech ConsultingBronze Sponsorhttp://www.captechconsulting.comhttp://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/CapTech_logo_color_170x84.jpg601702107Morgan Kaufman PublishersBronze Sponsorhttp://mkp.com/http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg601702186OpenTV/NagraPersonal Sponsorhttp://www.linkedin.com/profile/view?id=14982979trk=tab_prohttp://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/Pat_Reiter.jpg401001944Vince NapoliPersonal Sponsorhttp://www.linkedin.com/profile/view?id=1682443trk=tab_prohttp://m4.licdn.com/mpr/mpr/shrink_80_80/p/2/000/05f/1ef/1c3c4a3.jpg401001967Said SalomonPersonal Sponsorhttp://www.sqlbouncer.comhttp://i1237.photobucket.com/albums/ff476/DrOlemit/43630045.jpg401002101Mark KromerPersonal Sponsorhttp://mssqldude.wordpress.comhttp://m4.licdn.com/mpr/mpr/shrink_80_80/p/1/000/125/098/0b1e03d.jpg401002069BorisPersonal Sponsorhttp://www.linkedin.com/profile/view?id=67258654locale=en_UStrk=tyahhttp://m4.licdn.com/mpr/mpr/shrink_100_100/p/4/000/148/0b1/186e885.jpg401001745Shannon LowderBlog Sponsorhttp://shannonlowder.comhttp://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png401001753StrateSQLBlog Sponsorhttp://jasonstrate.comhttp://www.jasonstrate.com/images/StrateSQLBanner.jpg401001843MarkTab ConsultingBlog Sponsorhttp://www.marktab.nethttp://www.marktab.net/images/MarkTabNet_100x40.gif401008728A.J. MeeA.J. Mee is a Principal Technology Solutions Professional for Microsoft Corporation. He leads Microsoft's pre-sales practice around Business Intelligence (BI), serving 300+ Enterprise customers in the Mid-Atlantic region of the US (PA/DE/NJ/DC/MD/VA). In his role, he is primarily responsible for aligning specific customer requirements around BI empowerment and democratization to Microsoft's industry-leading BI platform. He joined Microsoft in 2006 as part of its acquisition of ProClarity.www.linkedin.com/pub/aj-mee/0/413/111/48488625Adam BelebczukAdam Belebczuk is a Developer turned Accidental DBA for Banyan Technology of Elyria, OH. Adam has over 8 years of experience in IT ranging from customer service to server/network administration to software and database development. Adam is an MCITP DBA 2005/2008, and specializes in SQL Server development and performance tuning.@SQLDiablohttp://www.linkedin.com/in/itacbhttp://www.SQLDiablo.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLDiablo48488627Adam BelebczukAdam Belebczuk is a Developer turned Accidental DBA that works for a small SaaS provider in Cleveland, Ohio. Adam is an MCITP DBA 2005/2008 and belongs to the Ohio North SQL Server User Group Professional Association for SQL Server (PASS). In addition to all things technological, he also loves to make electronic music, cook, go skiing, read, help educate his fellow geeks whenever the opportunity presents itself.@SQLDiablohttp://www.linkedin.com/in/itacbhttp://www.SQLDiablo.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLDiablo48488705Alex GrinbergAlex has more than 20 years IT experience. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, LSAC to name a few and is currently working with Aspect Consulting Inc. Alex is guest author for SQLServerSentral.comhttp://www.linkedin.com/profile/view?id=19737727authType=nameauthToken=lPvFtrk=tyah48489211Allen WhiteAllen is a Practice Manager for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last five years. He's President of the Ohio North SQL Server User's Group and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.@SQLRunrhttp://www.linkedin.com/profile/view?id=16846136locale=en_UStrk=tab_prohttps://api.twitter.com/1/users/profile_image?screen_name=@SQLRunr48489782Allen WhiteAllen is a Practice Manager for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last five years. He's President of the Ohio North SQL Server User's Group and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.@SQLRunrhttp://www.linkedin.com/profile/view?id=16846136locale=en_UStrk=tab_prohttp://sqlblog.com/blogs/allen_white/default.aspx.https://api.twitter.com/1/users/profile_image?screen_name=@SQLRunr48488629Bill WolffBill Wolff is the SharePoint Practice Director at Capax Global where he works with Fortune 100 companies on strategy, architecture, governance, and security. Bill is founder and President of the philly.NET user group, a previous INETA board member where he served as Vice President, Speaker Bureau, and involved in several other user communities. Bill was a contributing author on several books. His certifications include trainer, systems engineer, developer, and Microsoft MVP.@billjwolffhttp://www.linkedin.com/in/billjwollfhttps://mvp.support.microsoft.com/profile=EFACCE1E-781F-45E9-A15D-22A07639500Chttps://api.twitter.com/1/users/profile_image?screen_name=@billjwolff48489212Brian MoranBrian Moran is chief servant officer and co-owner of both Linchpin People and SQL People. He is a contributing editor for SQL Server Magazine and has been involved in the SQL Server community for more than 20 years. Brian co-founded what might be the first SQL Server user group in the world, was one of the first SQL Server MVPs in the world, and was on the SQL Server Magazine launch team. @briancmoranhttp://www.linkedin.com/pub/brian-moran/0/484/94bhttp://linchpinpeople.comhttps://api.twitter.com/1/users/profile_image?screen_name=@briancmoran48488048Christina LeoChristina Leo works as a database developer for ProfitStars, a Jack Henry Company. She supports three development teams that create software for the banking industry. She actively participates in the SQL Server community, is part of the leadership team for the Nashville SQL Server User Group, volunteers with the PASS - Women in Technology Virtual Chapter, and holds an MCITP for SQL Server 2005 in Development and Administration. @christinaleohttp://www.linkedin.com/pub/christina-leo/a/839/9aahttp://christinaleo.nethttps://api.twitter.com/1/users/profile_image?screen_name=@christinaleo48488049Christina LeoChristina Leo works as a database developer for ProfitStars, a Jack Henry Company. She supports three development teams that create software for the banking industry. She actively participates in the SQL Server community, is part of the leadership team for the Nashville SQL Server User Group, volunteers with the PASS - Women in Technology Virtual Chapter, and holds an MCITP for SQL Server 2005 in Development and Administration. @christinaleohttp://www.linkedin.com/pub/christina-leo/a/839/9aahttp://christinaleo.nethttps://api.twitter.com/1/users/profile_image?screen_name=@christinaleo48487995Chuck RivelChuck Rivel is a Principal Architect with RDA Corporation and has been developing custom Microsoft applications for the past 14 years. He has architected numerous data warehousing projects in the financial, manufacturing, health and food industries involving all areas of the MS BI development life cycle using the Microsoft BI stack. In addition to the hands on experience of working with MS technologies, Chuck has coauthored the Microsoft SharePoint 2010 Business Intelligence Unleashed book.www.linkedin.com/pub/chuck-rivel/1/2b7/4a5http://bisqlserver.rdacorp.com/https://api.twitter.com/1/users/profile_image?screen_name=48486844Dan 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.www.linkedin.com/in/dxclark/http://pragmaticworks.com/48488708Dennis Lloyd JrSebastian Meine is the SQL Stylist at sqlity.net llc. He founded sqlity.net in 2010 to fully engage in his passion for SQL Server. Sebastian provides training and consulting services. He specializes in T-SQL Test Driven Development (TDD) and performance tuning.
Dennis is a software development coach at Curiously Correct. He has broad experience in the software development with specialized focus on Agile practices and database technologies.@dennislloydjrhttp://www.testdrivendatabases.comhttps://api.twitter.com/1/users/profile_image?screen_name=@dennislloydjr48488666Dominic FalsoDominic is the Database Developer with The Reinvestment Fund in Center City Philadelphia. He has studied OO programming since 1995 and database software since 1999 (SQL Server since 2001). He currently works with SQL Server 2008 R2 and .NET C#, doing data analysis and manipulation, as well as writing code management software. In his spare time, he takes studies Chinese Acrobatics and Tightwire at the Philadelphia School of Circus Arts in Germantown. @https://api.twitter.com/1/users/profile_image?screen_name=@48488721Erin StellatoErin Stellato is a Senior Database Engineer at Hyland Software, Inc. in Westlake, OH. She has over 11 years of technology experience, and has worked with SQL Server for the last eight years. Erin works with customers to provide support for problems that involve the database and system performance. She is an active member of the SQL Server community and blogs about her experiences. Her areas of interest include Internals, Maintenance strategies, Performance Tuning and High Availability.@erinstellatohttp://www.LinkedIn.com/in/erinstellatohttp://www.erinstellato.comhttps://api.twitter.com/1/users/profile_image?screen_name=@erinstellato48488722Erin StellatoErin Stellato is a Senior Database Engineer at Hyland Software, Inc. in Westlake, OH. She has over 11 years of technology experience, and has worked with SQL Server for the last eight years. Erin works with customers to provide support for problems that involve the database and system performance. She is an active member of the SQL Server community and blogs about her experiences. Her areas of interest include Internals, Maintenance strategies, Performance Tuning and High Availability.@erinstellatohttp://www.LinkedIn.com/in/erinstellatohttp://www.erinstellato.comhttps://api.twitter.com/1/users/profile_image?screen_name=@erinstellato48488714Hope FoleyHope has over 12 years experience in the IT world, she has worked across many industries including small business enterprises, start ups, and Fortune 500 companies, and has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst, and took over as Principal Microsoft Consultant, where she now leads a team of expert DBAs and developers.@hope_foleyhttp://www.linkedin.com/pub/hope-foley/6/79b/5a9http://www.hopefoley.comhttps://api.twitter.com/1/users/profile_image?screen_name=@hope_foley48488272Jason ThomasJason Thomas is a SQL Server Professional with around 6 years of BI experience, mainly in SSAS and SSRS. He currently works as a Business Intelligence Consultant for Mariner in Charlotte, NC and is a constant presence in the Microsoft forums, for which he was recognized with the Microsoft Community Contributor award. @sqlJasonhttp://www.linkedin.com/profile/view?id=45468672trk=tab_prohttp://road-blogs.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlJason48488408Jeff Leidydelivering best-fit, end-to-end solutions complete with client assessments, project planning, tool selection, implementation, data management tuning, and optimization—for companies of any size. Focus on the Microsoft BI stack: SQL Server, SSIS, SSAS, SSRS; integration of these tools with SharePoint, Excel, and PowerPivot. I have delivered BI solutions to clients in a variety of industries, providing management solutions which turn operational data into priceless intelligence.@kevinbucherhttp://www.linkedin.com/in/kbucher/http://anexinet.com/solutions/bi_data_solutions.asphttps://api.twitter.com/1/users/profile_image?screen_name=@kevinbucher48488738Jessica MossJessica M. Moss is a well-known architect at CapTech Consulting, speaker, author, and Microsoft MVP of SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in many industries and has authored technical content for multiple magazines, websites, and the book 'Microsoft SQL Server 2008 Integration Services Problem-Design-Solution'. Jessica enjoys working with the Virginia community and speaks regularly at user groups, code camps, and conferences.@jessicammosshttp://www.linkedin.com/pub/jessica-moss/7/2b4/200http://www.jessicammoss.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jessicammoss48488323John SterrettJohn Sterrett has been active within the SQL Server community. He is a PASS Regional Mentor for the Mid-Atlantic Region, co-founded the West Virginia SQL Server User Group and hosted two PASS SQL Saturday events in West Virginia. John has presented at several SQL Server events including PASS SQLRally Orlando, PASS Summit 2011, SQL Server 2010 Member Summit, many PASS SQL Saturday events, code camps, and, user groups. John is a syndicated blogger at SQLServerPedia, contributes tips at MSSQLTIPS.@JohnSterretthttp://www.linkedin.com/in/johnsterretthttp://johnsterrett.comhttps://api.twitter.com/1/users/profile_image?screen_name=@JohnSterrett48488268Josef RichbergA SQL practitioner for over 19 years specializing in performance tuning. I currently work for Penguin Group (US), designing, enhancing, and improving, the sql experience for many of the data warehouse applications. I have been heavily involved in designing and implementing SSIS packages. I am the RedGate '2009 Exceptional DBA' award winner.@sqlrunnerhttp://www.linkedin.com/in/josefrichberghttp://josef-richberg.squarespace.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlrunner48488725Joseph D'AntoniJoseph D'Antoni is a Principal Infrastructure Architect for a major telecommunications provider. He has nearly 15 years of IT experience working for multiple Fortune 500 companies in a wide variety of database and major project roles. He holds a bachelor degree from Louisiana Tech University and a MBA from North Carolina State University. Joey is an avid cook and cyclist. @jdantonhttp://joedantoni.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton48487654Joshua FeiermanJosh Feierman is a SQL Server DBA who has been working with SQL since 2005, and has worked in both production and development support roles. He currently works as a DBA supporting development teams for a medium sized financial services company in the Philadelphia area. In addition to SQL Server Josh enjoys playing with VMWare and Powershell.@awanderingmindhttp://www.linkedin.com/pub/joshua-feierman/5/213/bb1http://awanderingmind.comhttps://api.twitter.com/1/users/profile_image?screen_name=@awanderingmind48486822Justin DearingJustin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He has been recongnized by 10gen as a Mongo Master for his involvement in the MongoDB community.
Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.@zippy1981http://www.linkedin.com/in/justindearingnychttp://www.justaprogrammer.nethttps://api.twitter.com/1/users/profile_image?screen_name=@zippy198148486868Karen LopezKaren López is Sr. Project Manager and Architect at InfoAdvisors, Inc. Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. Karen specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com. @datachickWww.LinkedIn.com/in/karenlopezhttp://blog.infoadvisors.comhttps://api.twitter.com/1/users/profile_image?screen_name=@datachick48486869Karen LopezKaren López is Sr. Project Manager and Architect at InfoAdvisors, Inc. Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. Karen specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com. @datachickWww.LinkedIn.com/in/karenlopezhttp://blog.infoadvisors.comhttps://api.twitter.com/1/users/profile_image?screen_name=@datachick48487562Kathy GibbsKathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions.@KGdbahttp://www.linkedin.com/pub/kathy-gibbs/a/6a8/680http://www.confio.comhttps://api.twitter.com/1/users/profile_image?screen_name=@KGdba48489913Kathy Gibbs
Kathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions.@KGdbahttp://www.linkedin.com/pub/kathy-gibbs/a/6a8/680http://www.confio.comhttps://api.twitter.com/1/users/profile_image?screen_name=@KGdba48488103Kevin GoffMicrosoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, Author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics@KG_SQLBITrainerhttp://www.kevinsgoff.nethttps://api.twitter.com/1/users/profile_image?screen_name=@KG_SQLBITrainer48488104Kevin GoffMicrosoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, Author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics@KG_SQLBITrainerhttp://www.kevinsgoff.nethttps://api.twitter.com/1/users/profile_image?screen_name=@KG_SQLBITrainer48488518Kevin BucherAs Director of the BI practice at Anexinet, I deliver best-fit, end-to-end solutions complete with client assessments, project planning, tool selection, implementation, data management tuning, and optimization—for companies of any size. Focus on the Microsoft BI stack: SQL Server, SSIS, SSAS, SSRS; integration of these tools with SharePoint, Excel, and PowerPivot. @kevinbucherhttp://www.linkedin.com/in/kbucher/http://anexinet.com/solutions/bi_data_solutions.asphttps://api.twitter.com/1/users/profile_image?screen_name=@kevinbucher48489210Lunch LunchLunch@jdantonhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton48489218Mark KromerMark Kromer is Microsoft technology specialist for SQL Server for the Mid-Atlantic District. Mark was also lead technical product manager for BI solutions for Microsoft in Redmond and a principal product manager at Oracle. You can find Mark speaking at local events like SQL Saturday, Code Camp and PASS groups. He co-writes the SQL Server Magazine BI Blog and SearchSQLServer monthly Microsoft QA article.@mssqldudehttp://www.linkedin.com/in/markkromerhttps://api.twitter.com/1/users/profile_image?screen_name=@mssqldude48487784Mark HudsonMark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data warehouses and data presentations using numerous platform tools including both SQL Server 2005 and SQL Server 2008. He currently serves as a data architect and developer with CapTech. He also is a leading member of the Richmond SQL Server User Group (www.richmondsql.org).@HMarkHudsonhttp://www.captechconsulting.comhttps://api.twitter.com/1/users/profile_image?screen_name=@HMarkHudson48487786Mark HudsonMark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data warehouses and data presentations using numerous platform tools including both SQL Server 2005 and SQL Server 2008. He currently serves as a data architect and developer with CapTech. He also is a leading member of the Richmond SQL Server User Group (www.richmondsql.org).@HMarkHudsonhttp://www.captechconsulting.comhttps://api.twitter.com/1/users/profile_image?screen_name=@HMarkHudson48486802Mark KromerMark Kromer is Microsoft technology specialist for SQL Server for the Mid-Atlantic District. Mark was also lead technical product manager for BI solutions for Microsoft in Redmond and a principal product manager at Oracle. You can find Mark speaking at local events like SQL Saturday, Code Camp and PASS groups. He co-writes the SQL Server Magazine BI Blog and SearchSQLServer monthly Microsoft QA article.@mssqldudehttp://www.linkedin.com/in/markkromerhttp://mssqldude.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mssqldude48487498Mark WojciechowiczIn the past year, Mark has worked as a Business Intelligence Architect with Anexinet. He began a career in IT with the implementation of Supply Chain Management applications. Realizing these applications stored a wide breadth of data that could be harvested for analysis, Mark became an impassioned advocate of data warehousing. Today, he advocates visualization of data and has spoken on the subject at PSSUG.@MarkWojciehowichttp://www.linkedin.com/pub/mark-wojciechowicz/2/54/803http://www.anexinet.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MarkWojciehowic48487499Mark WojciechowiczIn the past year, Mark has worked as a Business Intelligence Architect with Anexinet. He began a career in IT with the implementation of Supply Chain Management applications. Realizing these applications stored a wide breadth of data that could be harvested for analysis, Mark became an impassioned advocate of data warehousing. Today, he advocates visualization of data and has spoken on the subject at PSSUG.@MarkWojciehowichttp://www.linkedin.com/pub/mark-wojciechowicz/2/54/803http://www.anexinet.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MarkWojciehowic48487696Mike HillwigMike Hillwig is a SQL DBA for a Boston-based provider of cloud-based solutions for the financial industry He's been working with SQL Server since version 7 and has worked as a DBA for the past seven years. He's got a background in infrastructure and networking.@mikehillwighttp://www.linkedin.com/in/mikehillwighttp://crankydba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mikehillwig48488727Muthu RamanathanI am currently working as a Dedicated SQL Engineer @ Microsoft. I have been with Microsoft for over 4 years, dealing with Microsoft’s Premier customers.I have been working with SQL Server since version 4.2, when SQL shared very similar characteristics as Sybase.Spent more than two decade's time in corporate America and Contributing something back to the database world, will take me one step closer to fulfilling my dreams.Current projects include PDW, in-memory databases,tuning ERP apps on SQL.48489209Panel DiscssionKaren López, Joey D'Antoni, Brian Moran@jdantonhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484810039Pat LatorraPat is currently Systems Engineer at GridIron Systems with responsibility as the key technical advisor managing customer requirements for Proof of Concept evaluations, technical consultant for application and storage acceleration and solution implementation manager for the New York region. http://www.gridironsystems.com48489355Paul RizzaSenior Consultant @ Microsoft Consulting Services@PaulRizzaSQLhttp://www.linkedin.com/in/prizza/https://api.twitter.com/1/users/profile_image?screen_name=@PaulRizzaSQL48487129Robert PearlRobert Pearl, President of Pearl Knowledge Solutions, Inc., and SQL MVP/SME and solutions-oriented Senior DBA with 12+ years of experience. Robert is a SQLCommunity/SQLSaturday evangelist and promoter. He is maintains his regular blog at SQLServerCentral.com, called Pearl Knows. Robert was voted TOP BLOGGER, in the 2011 SQL Magazine Community Choice Awards.
He is also creator and developer of the award-winning SQLCentric – a web-based DB monitoring alert system with the DBA in mind.@Pearlknowshttp://www.linkedin.com/in/robertpearlhttp://www.sqlservercentral.com/blogs/pearlknows/https://api.twitter.com/1/users/profile_image?screen_name=@Pearlknows48487733Ron JohnsonA 25 year veteran of the IT industry Ron has significant experience as a software engineer (C++). For the past 10 years Ron has focused on the Microsoft Technology stack developing Windows data-driven applications using C# and the .Net framework. Ron is currently a Senior DBA with Xtivia specializing in performance optimization, security, database design, SSIS, and replication. Ron earned a M.Sc. in Computer Science and a B.Sc. in Physics.http://rjssqlservernotes.wordpress.com/48488662Sebastian MeineSebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). He founded sqlity.net in 2010 to fully engage in his passion for SQL Server. Sebastian provides training and consulting services. He specializes in T-SQL Test Driven Development (TDD) and performance tuning and shares his knowledge regularly with audiences world-wide through his writings and speaking engagements.
Read more at http://sqlity.net/en/about/@sqlityhttp://lnkd.in/Y2WwBRhttp://sqlity.nethttps://api.twitter.com/1/users/profile_image?screen_name=@sqlity48489638Vince NapoliVince Napoli is a Business Intelligence Architect with Anexinet in Blue Bell. His specialty is Data Warehousing and Business Intelligence since 1996, and has been working with SQL Server since 1999 with the 7.0 release as a DBA and Business Intelligence Architect. Vince is a frequent presenter at PSSUG, and has been a SQL Saturday and Code camp presenter in the philadelphia area, and is also the President of the Phila SQL Server users group.
@Napoli_Vhttps://www.linkedin.com/pub/vince-napoli/0/691/777https://api.twitter.com/1/users/profile_image?screen_name=@Napoli_V48486812Wayne SheffieldWayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at www.sqlservercentral.com, where he also is active on the forums assisting the community.@DBAWaynehttp://www.linkedin.com/pub/wayne-sheffield/20/259/546http://blog.waynesheffield.com/waynehttps://api.twitter.com/1/users/profile_image?screen_name=@DBAWayne48488693William EmmertBill is the Tech Director and a SQL Architect in the Philadelphia Microsoft Technology Center (MTC). He has been working at Microsoft for the last 14 years helping customers of all sizes to develop and implement relational OLAP solutions with SQL Server.He started his career at Microsoft in MCS, In 2007, worked in the SQL product team SQLCAT group and in 2010 worked in the NY MTC before taking on his current role in the Philadelphia MTC.48489217WIT WITWomen In Tech Session@jdantonhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484868026802Mark KromerBIFranklin LabMicrosoft Cloud BIWith the growing number of mobile users, requirements for browser-based BI and the lower TCO of cloud-based solutions, Cloud BI is becoming a dominate topic in the business intelligence world. In this session, I will demonstrate how to create a complete working Microsoft BI application that is cloud-based using SQL Server, SQL Azure, PowerPivot and Silverlight.6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM68126812Wayne SheffieldDBA\Dev30th StreetMinimally Invasive - Tools to Doctor Up Your CodeThis code filled session examines several additions to recent versions of SQL Server. These tools allow you to perform minimally invasive surgery on your code and gain performance! Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops! 6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM68226822Justin DearingDBA IIMRP 1MongoDB for the Relational DBANoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there's not RELATIONAL in DBA.
On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database.
On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to. 6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM68446844Dan ClarkBI 2012EBCBuilding 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 Indicators6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM68686868Karen LopezDBA\Dev30th StreetModel-Driven Database DesignModel-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as 'Who does what?', 'Why are we doing this?', 'Do I have to Use a GUI?' and 'Just who do you think you are?'. Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment.6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM68696869Karen LopezProf DevBerwynCareer Management for Data ProfessionalsCareer Success in Data Management during Turbulent Timesa; A workshop on issues and ideas that today's data professionals can do to build their careers and networking skills with other data management professionals. Workshop topics will include:• Demonstrating your expertise• Building a portfolio of your success stories• Getting others to sell your skills and business value• Building extending your data management skill set• 10 Steps to highlighting you and your workBring your thoughts, ideas, and experiences.6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM71297129Robert PearlDBA IIMRP 1Much Ado About Indexes - Tuning, Tips TricksIn my session, I will offer some practical tips and tricks on a wide-array of Index Analysis methods that will allow you to find out everything about a client's indexes and were afraid to ask! What better way to optimize the performance of the database than talk about their indexes. What do you need to know in order to make these suggestions, and implement them. This session will cover the basics on indexes, and then demonstrate ways to improve DB performance. Missing Indexes, Duplicate Indexes, Fragmented Indexes, Covering Indexes, Clustered Nonclustered indexes, and the queries that love them. I will also demo ways in which you can correlate the worst performing queries with missing indexes.6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM74987498Mark WojciechowiczBI/DevPaoli Using Database Projects to Manage Schema ChangesThis session will demonstrate how to use database projects (aka DBPro and DataDude) for managing and synchronizing database schemas between environments. If you develop databases, today, or administer changes and have not used database projects before, this is the session for you. Database projects offer a great set of tools for detecting schema changes and automating the scripting process. This session will help database developers learn the basics of the database toolset and help DBAs understand the output. In addition, we will cover test driven development and look at how to avoid common pitfalls when making schema changes.6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM74997499Mark WojciechowiczBI 2012EBCData Quality Services in SQL Server 2012Based on the teaching of the Kimball Group and Jack Olsen, learn about what data quality is and how to manage it in a data warehouse project. See how Data Quality Services (DQS) fits into the cleansing and conforming steps of an ETL and how these new tools create a huge leap forward in how the organization can take active responsibility over their data. This session will give hands on examples of common data quality problems and how to address them. 6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM75627562Kathy GibbsDBA IIMRP 1Best Practices for Monitoring Databases on VMwareSQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM76547654Joshua FeiermanDBA IMRP IIAvoiding 'Monkey At The Monitor' By DelegatingAs a DBA there is a lot of simple, step-by-step work that has to be completed on a daily basis. And while it's obviously a necessary part of our job, it's not fun and it takes away from time we could spend doing more important, less urgent work. One attractive option is delegating work to others, thus allowing the DBA to focus on more attractive / important tasks. But how do we do so without compromising security or best practices? Using the tips and tricks presented in this session, you'll be able to spread your workload to junior personnel while still maintaining a sound security / audit model.6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM76967696Mike HillwigDBA IIMRP 1Top Ten Rules for Managing a Production EnvironmenMike Hillwig has ten rules for managing a SQL Server environment regardless of the size. His rules cover things from server configurations to planning for a disaster and a few things that should never be done. 6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM77337733Ron JohnsonDBA IIMRP 1Creating a Performance Baseline for SQL ServerCreating a Performance Baseline for a SQL Server should be the first task any DBA accomplishes when inheriting the instance. The Performance Baseline provides a starting point for any performance optimization efforts, a point of reference for future performance comparisons, and documents the server and instance configuration. 6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM77847784Mark HudsonBIFranklin LabMaking Predictions with Microsoft Data Mining ToolWhether predicting customers, All Stars or concert set lists, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM77867786Mark HudsonBIFranklin LabPut Your Data on the MapColumbus demonstrated the world was not flat. Our Address table suggests events occurred at a particular location. SQL Server 2008 supports geospatial data. SQL Server 2008 R2 provides the United States map gallery. Come see how Reporting Services leverages those knowns to present our data in a geographical way.6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM79957995Chuck RivelBI 2012EBCCreating a PPS Dashboard Using a BI Semantic ModelThis session will cover how one can create a PerformancePoint Services Dashboard using a SQL Server 2012 BI Semantic Model.6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM80488048Christina LeoDevelopmentWynnewoodWhat's Buried in the Plan Cache?Creating a query plan can be a time consuming and expensive process. To avoid repeating these potentially costly steps unnecessarily, SQL Server stores its query plans, in the plan cache where they can be reused as needed.
In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.
6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM80498049Christina LeoDBA\Dev30th StreetWorking with Server Side TracesYou may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you.
First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace.6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM81038103Kevin GoffBI/DevPaoli Integrating MDX code with OLAP applicationsIt's one thing to know how to write basic MDX code (and that's certainly important). It's another to know how to incorporate MDX into SSRS applications, PerformancePoint Services applications, and other BI applications. In this presentation, I'll show some of the intricacies, issues, and workarounds for using MDX code in OLAP applications. 6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM81048104Kevin GoffDevelopmentWynnewoodT-SQL for Application Developers - Attendees choseThat's right, attendees choose! I'll show 20 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 20 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM82688268Josef RichbergBI/DevPaoli SSIS Tips TricksLearn some of the quirks and capabilities of SSIS. Learn about the pitfall of 'parallel path choicing'. Use the Script Component as a data source (to solve complex sourcing issues) and as a data destination (to get around the identity column conundrum). See how use Script Tasks to build directory scanners for efficient file import techniques. Learn how to build and use Named Pipes to improve workload performance. We'll also go over some the tunable properties of the Data Flow object.6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM82728272Jason ThomasBI/DevPaoli Advanced Charting Techniques in SSRSSSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts.
This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level. 6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM83238323John SterrettDBA IMRP IIPerformance Tuning for PiratesIf you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.
6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM84088408Jeff LeidyBIFranklin LabMobilize your PowerPivot SolutionsOverview and demonstration of steps required to expose PowerPivot/SharePoint to mobile devices.6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM85188518Kevin BucherBIFranklin LabPower View 101Built on top of the BI Semantic Model, Power View gives the users of all levels a powerful yet simple to use experience. Power View provides interactive, browser-based data exploration and visualization - this presentation will walk through the basics of Power View, use cases, and a demonstration.
6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM86258625Adam BelebczukDBA IMRP IISQL Server 2012 AlwaysOn Readable SecondariesOne of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you're just curious about AlwaysOn, then you won't want to miss this session.6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM86278627Adam BelebczukDBA\Dev30th StreetIntroduction to SQL Server Service BrokerIn this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM86298629Bill WolffBI/DevPaoli SharePoint Integration with SQL Server SharePoint is a collaboration, document management, and solution delivery platform built on .NET, SQL Server, and Active Directory. This talk explains how SharePoint uses SQL Server to store content, configuration, and logging data. For databases that are not native to SharePoint, Business Connectivity Services provides a seamless forms over data experience. SharePoint is used extensively for Business Intelligence where it becomes the user interface for Reporting Services, PowerPivot, and Performance Point. We will also look at how SQL Server 2012 affects the SharePoint ecosystem.6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM86628662Sebastian MeineDBA\Dev30th StreetIndex InternalsThis presentation looks behind the scenes of how SQL Server physically organizes the data on disk. We will talk about Heaps, B+Trees, RIDs, Keys, Seeks and Scans. The materials covered will allow you to make a more informed decision about what type of index to use when.6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM86668666Dominic FalsoDevelopmentWynnewoodIntroduction to the .NET SSIS API (C#)Using the .NET API, we'll design and run existing packages, and create a new one. We'll discuss the different objects a package contains, see how to query a package's contents, and how to edit field-level component transformations. 6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM86938693William EmmertDBA IIMRP 1Increasing High Availability and Decreasing CompleIn this session you will be introduced to the new and enchanced SQL Server High Availability and Disaster Recovery features in SQL Server 2012. I will demo the setup of an AlwaysOn Availability Group and show how an application can automatically reconnect following a failover. Additionally, I will show how to configure read-only secondaries and demonstrate the use of prioritizing the secondaries for access.6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM87058705Alex GrinbergDevelopmentWynnewoodDBA-User Interface, build a bridge.This is 100% code session, where presenter will demonstrate system development live cycle. Starting from a database stored procedure and go to the user interface to display a result. Down the road I’ll demonstrate different techniques, how to create a stored procedure calling class from SQL Server using system tables. How to pass to the stored procedure different parameter types, such as XML or ADO.NET DataTable. 6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM87088708Dennis Lloyd JrDevelopmentWynnewoodThwarting Database DefectsIt’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. 6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM87148714Hope FoleyBI 2012EBCPowerPivot BISM in SQL Server 2012The BI world is all coming together as one to have hold and cherish in the BI Semantic Model. We will discuss that and what it means and dive into PowerPivot 2012. Will go over some oldie but goodies from v1 as well as heavily highlight some of the most anticipated new features. We will create together a real world scenario to help solve my own BI problems. Learn to crank out some uber snazzy reports that will knock your boss's KPIs off! 6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM87218721Erin StellatoDBA IMRP IIDBCC Commands: The Quick and the DangerousThere are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM87228722Erin StellatoDBA\Dev30th StreetYou’re My Density: Making Sense of StatisticsThe Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM87258725Joseph D'AntoniProf DevBerwynIt Costs How Much? SQL Server LicensingDid you know that as of June 30th the model for licensing SQL Server is changing? Learn about what these changes mean to you and your IT organization. We will discuss the impact to hardware architecture, virtualization environments, and DR. Understand the strategies you are your organization can take to minimize the financial impact of these licenses changes.6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM87278727Muthu RamanathanDevelopmentWynnewoodSQL Server performance tuning made easy !SQL Server is a developer platform. The experience you get from this platform depends on how you leverage the platform.
In this session, we will talk about some live performance scenarios including CPU starvation, High Memory consuming Queires, SQL Server Caches, I/O Intensive Queries by walking through some live examples. This will be all examples, few slide interactive session that talks about SQL Server performance tuning, using some of the native tools thats comes out of the box. We will finish by getting into SQL Server 2012 Extended Events introduction and how better troubleshooting gets in SQL 2012 and .NET 4.5. 6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM87288728A.J. MeeBI 2012EBCSQL Server 2012's Net-New BI CapabilitiesMuch like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including:
· Power View
· BI Semantic Model (BISM)
· Data Quality Services
· Master Data Management
· Columnstore Index6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM87388738Jessica MossBI 2012EBCExploring your Data with Power ViewExploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one.6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM92099209Panel DiscssionProf DevBerwynYou Wouldn't Let HR Manage Your DBs...So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel.6/9/2012 4:00:00 PM6/9/2012 5:00:00 PM92109210Lunch LunchProf DevBerwynLunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92109210Lunch LunchBI 2012EBCLunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92109210Lunch LunchDBA IMRP IILunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92109210Lunch LunchDBA IIMRP 1LunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92109210Lunch LunchDBA\Dev30th StreetLunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92109210Lunch LunchBI/DevPaoli LunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92109210Lunch LunchBIFranklin LabLunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92109210Lunch LunchDevelopmentWynnewoodLunchLunch6/9/2012 12:00:00 PM6/9/2012 1:30:00 PM92119211Allen WhiteDBA IMRP IIManage SQL Server 2012 with PowerShell and CoreWindows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM92129212Brian MoranProf DevBerwynConversational leadershipLeadership coaching is the practice of using relational influence, the people kind, not the database kind J, to develop and empower leaders. You might be in a position of leadership today. You might be in a position of leadership tomorrow. Either way; we all have opportunities to lead in different ways as we go about our lives and careers. Learn some simple techniques that can help you lead through conversation.6/9/2012 8:30:00 AM6/9/2012 9:30:00 AM92179217WIT WITProf DevBerwynPASS Women In Technology SessionAn interactive discussion on diversity and gender in the IT and data profession. Panelists Erin Stellato, Karen Lopez, and Hope Foley will discuss issues such as:
- is diversity an issue we should be concerned with?
- what do our daughters think about IT careers?
- Why are fewer women considering IT careers?
- Why are women leaving the profession a a higher rate?
- What can we as individuals do about this?
- What, if anything, should PASS be doing about it?
Questions and comments from attendees will be the primary focus of this session, so have your opinions ready. This session is not just for women; all attendees are welcome to participate.6/9/2012 11:00:00 AM6/9/2012 12:00:00 PM92189218Mark KromerBI/DevPaoli Managing SQL Server in Large Warehouse EnvironmentFor SQL Server DBAs experienced in managing OLTP environments, managing a large DW SQL Server environment can present a whole new set of challenges. In this session, we will discuss ways to overcome and prepare for those challenges and the different ways that a DBA must interact with
SQL Server and the associated BI tools to ensure a successful data warehouse environment.6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM93559355Paul RizzaBIFranklin LabShortcuts to Building SSIS in .NetShortcuts to Building SSIS in .Net6/9/2012 2:45:00 PM6/9/2012 3:45:00 PM96389638Vince NapoliProf DevBerwynAnalysis Services Half and Half-Half Cube/Half MDXIn this intro level session, we'll look at the basics of building a working SSAS Cube, and the basics of MDX calculations. In constructing a working cube, we will cover key concepts for Analysis Services and MDX, and show you how to construct a basic cube and regular dimension, and a calculated member for Analysis. We will pack as much information into this session so as to allow you to take away enough to be able to start building cubes and metrics on your own. 6/9/2012 1:30:00 PM6/9/2012 2:30:00 PM97829782Allen WhiteDBA IMRP IIGather SQL Server Performance Data with PowerShellWe all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.6/9/2012 9:45:00 AM6/9/2012 10:45:00 AM99139913Kathy GibbsDBA IIMRP 1Advanced Performance Tuning Tips with IgniteAre you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. Kathy will use real-life case studies to demonstrate the techniques.6/9/2012 12:45:00 PM6/9/2012 1:15:00 PM1003910039Pat LatorraDBA IMRP IIAccelerate SQL Server 10xThis interactive session presents reference architectures and actual IT case studies for integrating Solid State Disk (SSD) into existing storage infrastructures to boost performance and enable virtualization especially in big data environments where data volumes are growing rapidly, and applications and users are demanding high-speed concurrent access. Attendees will see how large database environments can be more strategic in their deployment of SSD and reap 10-fold performance acceleration without the need to reconfigure or move applications or data, without forklift hardware upgrades, and without changing data protection policies. This session will allow one-on-one Q A with a technical architect. 6/9/2012 12:45:00 PM6/9/2012 1:15:00 PM