SQLSaturday #69 - Philadelphia 2011
Event Date: 03/05/2011 00:00:00
Event Location:
- DeVry University
- 1140 Virginia Drive
- Philadelphia, Pennsylvania
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Knowing Tempdb
Abstract: System database call tempdb, which is used for storing temporary objects and has been a key component of SQL Server since its inception. The role of tempdb has been brought to the forefront with a plethora of new features and optimizations that depends upon temporary objects. Session will discuss on -> How SQL Server uses tempdb for internal and user created temporary objects -> How to troubleshoot and avoid common tempdb issues -> How to monitor and tune tempdb performance -> How configuration best practices can increase the performance and availability of tempdb
Speaker(s):
- Bharat Kenjale
Track and Room: DBA Track #2 (109) - N/A
Title: Modeling Hierarchies in SQL
Abstract: The dictionary defines a hierarchy as “any system of persons or things ranked one above another.” Classic examples that you may want to model in a database are an org chart or a bill of materials. A less well-behaved example is the dependency of database objects (sysdepends). These examples will be used to explain HIERARCHYID, recursive CTE (Common Table Expressions) and the Adjacency List Model.
Speaker(s):
- Patty Pickup
Track and Room: Prof Devel / Dev (113) - N/A
Title: I/O, I/O It’s Why my Server’s Slow - Waits Queue
Abstract: Based on the popular cover-story article appearing in SQL Server Magazine, Robert Pearl expands on ways to measure SQL Server’s performance and present the information in a readable and useful format. He will bring us useful tips for getting and analyzing I/O information, and troubleshoot performance bottlenecks. In addition, Robert will scratch the surface and introduce performance tuning using a methodology called Waits and Queues, with respect to I/O. By using this methodology one can identify the best opportunities to improve performance, the so called “biggest bang for the buck”. These performance improvements are likely to have a significant return on the performance tuning time investment.
Speaker(s):
- Robert Pearl
Track and Room: DBA Track #2 (109) - N/A
Title: Accessing SQL Server Data with .NET
Abstract: Bill will demonstrate the latest Microsoft patterns and practices for SQL Server data access. This includes LINQ query syntax, Entity Framework data modelling, REST web services using WCF Data Services (oData), and client side data models with WCF RIA Data Services.
Speaker(s):
- Bill Wolff
Track and Room: Dev Track #1 (110) - N/A
Title: TDD – Thwarting Database Defects
Abstract: It’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.
Speaker(s):
- Dennis Lloyd and Sebastian Meine .
Track and Room: Prof Devel / Dev (113) - N/A
Title: Table Vars and Temp Tables-What you NEED to know!
Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, ‘When do I use one or the other and what are the various impacts of doing so?”
Speaker(s):
- Wayne Sheffield
Track and Room: Dev Track #2 (111) - N/A
Title: Spatial Data and Windows Azure
Abstract: Spatial Data is very important for the new applications, related with Data Visualization and BI. Windows Azure offers possibility to use advantages of spatial data suing cloud computing. In this lecture will talk about the use of spatial data in the Windows Azure - loading data from SQL Azure Spatial, data files from Windows Azure Storage, optimizing Windows Azure applications and their use of different types of customers: WEB based, WPF, WP7. We will learn how to import spatial data in different formats in Windows Azure Storage and SQL Azure Spatial and will create a several sample Windows Azure applications, that use this data.
Speaker(s):
- Mihail Mateev
Track and Room: Dev Track #1 (110) - N/A
Title: Table Partitioning: Implementing a sliding window
Abstract: In this session Joe will first discuss the benefits and requirements of table partitioning in SQL 2008 and then go through the planning and implementation steps of partitioning an 11 million row sample table. Once complete, we will then review in detail our sliding window requirements and see exactly how the partitioning toolbox commands (Split, Merge Switch) can be used to implement our scenario. You will get to see the actual partitioning code and the sliding window code. No prior table partitioning experience is assumed.
Speaker(s):
- Joe Toscano
Track and Room: Dev Track #1 (110) - N/A
Title: Advance T-SQL technique to optimize a code.
Abstract:
In this session I’ll demonstrate how T-SQL code can be improved using latest features for
SQL Server 2005 and up, such as CTE (Common Table Expression), OUTPUT clause, Ranking functions, EXCEPT, INTERSECT, XPath query, MERGE statement and others.
Speaker(s):
- Alex Grinberg
Track and Room: Dev Track #2 (111) - N/A
Title: Data Encryption and Key Management in SQL
Abstract: Overview of data encryptions and key management that is built into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.
Speaker(s):
- Said Salomon
Track and Room: DBA Track #1 (108) - N/A
Title: Slinging data with SQL Server Replication
Abstract: Performance problems getting you down? Replication may be the solution.
SQL Server replication is a native SQL Server component used to move data from one server to another, and sometimes back again. It’s most popular use case is to offload reporting from bogged down OLTP servers - it can also be used for scale out solutions, transforming data, consolidating data, moving data closer to its consumers, proving high availability solutions and disaster recovery.
Speaker(s):
- Hilary Cotter
Track and Room: DBA Track #1 (108) - N/A
Title: Entity Strategies: Structuring Your Consultancy
Abstract: Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.
Speaker(s):
- William E Pearson III
Track and Room: Prof Devel / Dev (113) - N/A
Title: Query Tuning - Getting it Right the First Time!
Abstract: Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s):
- Janis Griffin
Track and Room: Dev Track #2 (111) - N/A
Title: Rolling upgrade 2008 R2 Cluster /SQL 2008 R2
Abstract: Reduce downtime of SQL 2008 failover over clusters by applying service packs and cumulative updates using Rolling Upgrades.
Speaker(s):
- Greg Seidel
Track and Room: DBA Track #1 (108) - N/A
Title: Building your first SQL Cluster
Abstract: Interested in high availability, but don’t know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs. Of course, SQL Server will be included in this process.
Speaker(s):
- Joseph D’Antoni
Track and Room: Misc / Vendor (121) - N/A
Title: High-Speed Dimensional Data Loads With SSIS
Abstract: Performance-driven SSIS ETL solutions require a mix of both SQL and SSIS developer optimizations. In this session attendees will learn SQL code and SSIS data flow optimizations, tips and best practices that are specifically geared to obtain the best performance from your enterprise ETL solution. This session is specific to Datamart ETL, but much of the information presented can be applied to any SSIS solution.
Speaker(s):
- Michael Coles
Track and Room: BI Track #2 (106) - N/A
Title: Deploying Data Tier Applications with SQL 2008 R2
Abstract: Data Tier Applications (DAC Packs) are a new feature in SQL 2008 R2, that alllow developers to better simplify environmental management. In this demo, I will define the requirement surrounding DAC packs, then build and deploy a sample.
Speaker(s):
- Joseph D’Antoni
Track and Room: Dev Track #1 (110) - N/A
Title: Sell Yourself!
Abstract: In today’s economy job seekers need to take advantage of every opportunity. In this session attendees will learn how to take advantage of unprecedented opportunities to market themselves to potential employers (and the world at large!) We’ll cover topics including fine-tuning your resume, managing your online presence and responding to the toughest interview questions. We’ll also discuss how you can turn simple steps, like asking your interviewer questions and sending a follow-up note, into unparalleled opportunities to close the deal.
Speaker(s):
- Michael Coles
Track and Room: Prof Devel / Dev (113) - N/A
Title: Beyond Plateaux: Optimize SSAS via Best Practices
Abstract: Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.
Speaker(s):
- William E Pearson III
Track and Room: BI Track #2 (106) - N/A
Title: Database design tips and tricks
Abstract: I will talk about designing structures that hold data for the business
- Designing Lookup tables and Data Tables.
- Surrogate keys and exceptions thereto.
- The differences between Logical models and Physical implementation.
We will wrap up with an Interactive design session.
Speaker(s):
- Raj More
Track and Room: DBA Track #2 (109) - N/A
Title: Building your first cube in SQL Server
Abstract: Learn about the value of building multi-dimensional cubes for reporting on your data in SQL Server. Learn how and where to go to get started with building cubes in SSAS, PowerPivot and the new ways to build semantic models in SQL Server Denali, starting at level 101 for beginners.
Speaker(s):
- Mark Kromer
Track and Room: BI Track #2 (106) - N/A
Title: SQL Server Service Broker – An Overview
Abstract: Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures.
Speaker(s):
- Janis Griffin
Track and Room: Dev Track #2 (111) - N/A
Title: Using Confio Ignite 8 for Production Failures
Abstract: A real life application of the Confio product Ignite8 to solve one companies serious production issues. This session will touch on many SQL Server tools, disciplines and resources and bring them all together into a synergy of useful index generation, interpreting execution plans, and using Benchmark Factory to get real performance measurements.
Speaker(s):
- Dale Cunningham
Track and Room: DBA Track #2 (109) - N/A
Title: Women In Technology Panel Discussion
Abstract: Increasing the role of women in technology has a direct impact on the women working in hi-tech, but the effects can go far beyond that. How do female tech workers influence innovation and product development? How do men benefit from having more women working in technology? Can the presence of women in tech affect a company’s bottom line? What does it mean for women and their families when they have access to hi-tech jobs? This session is open to both men and women. The panelists will present brief remarks and then the floor will be open for the audience to ask questions of the panelists.
Speaker(s):
- Sharon Dooley
Track and Room: Prof Devel / Dev (113) - N/A
Title: SSRS Interactive Reports
Abstract: I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports.
Speaker(s):
- Matt Van Horn
Track and Room: BI Track #1 (105) - N/A
Title: SSRS 2008R2 Reporting Gallery
Abstract: In this presentation, I’ll show 10 rather cool looking reports created in SSRS 2008R2 - everything from sparklines to heat maps, from Tablix-drilldown reports to advanced charts, from performance gauges to new page/group control features in R2. Since no presentation can cover the creation of all ten, I’ll let the majority of the audience decide which to cover.
Speaker(s):
- Kevin Goff
Track and Room: BI Track #1 (105) - N/A
Title: Troubleshooting SQL performance
Abstract: CausesTools used in troubleshootingIdentifying risks and mitigating.
Speaker(s):
- Muthu Ramanathan
Track and Room: DBA Track #1 (108) - N/A
Title: Business Intelligence with SharePoint 2010
Abstract: SharePoint 2010 provides many opportunities to render data from business intelligence applications. In this presentation, I’ll show examples of building BI content in SharePoint 2010 using PerformancePoint Services, Excel Services, SSRS, and PowerPivot. Because I’m covering many applications, I won’t be able to cover any one topic too heavily. But at the end of the presentation, the attendee will see several examples of how BI applications can use SharePoint 2010
Speaker(s):
- Kevin Goff
Track and Room: BI Track #1 (105) - N/A
Title: Parallel Data Warehousing
Abstract: Overview Architecture Query plans Demos
Speaker(s):
- Muthu Ramanathan
Track and Room: BI Track #1 (105) - N/A
Title: Become Bilingual! Oracle for the SQL Server DBA
Abstract: In today’s enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA’s for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.
Speaker(s):
- Randy Knight
Track and Room: DBA Track #1 (108) - N/A
Title: Migrate SQL Server Apps to SQL Azure Cloud DB
Abstract: This session will introduce you to the world of database cloud utility computing with SQL Azure. We will walk through a step-by-step process of migrating an on-premises SQL Server database to SQL Azure. We’ll demonstrate a reporting application that works as-is regardless of the SQL Server database location on prem or cloud. You will also experience developing T-SQL code in Visual Studio and utilize SSMS to deploy code from development to production in SQL Azure using the Data-Tier Application DAC capability. Lastly, we will demonstrate using the Silverlight Database Manager tool for managing and modifying your cloud databases directly.
Speaker(s):
- Mark Kromer
Track and Room: Dev Track #1 (110) - N/A
Title: Concurrency Control
Abstract: This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affect query concurrency and performance.
Speaker(s):
- Sebastian Meine
Track and Room: DBA Track #2 (109) - N/A
Title: Intro to SQL Reporting Services
Abstract: I will offer a 100 level into to Reporting Services and show you how to build reports using the Business Intelligence Development Studio 2008. We will cover all the basics that you will need to know to build a real report currently knowing nothing about reporting services.
Speaker(s):
- Matt Van Horn
Track and Room: BI Track #1 (105) - N/A
Title: Intro to SSIS
Abstract: This session is for the beginner to SQL Server Integration Services (SSIS). In this session, we will step you through creating an Extraction, Transformation, and Load (ETL) package in SSIS from scratch to move and process your data. We will start with an overview of SSIS in general, and then highlight the different connections, tasks, and transformations available in the workflow and data flow engines as we build our new SSIS package. When you leave you will be to create a basic SSIS package on your own.
Speaker(s):
- Vince Napoli
Track and Room: Misc / Vendor (121) - N/A
Title: Many-to-Many: Multiple Calendars in a Single Cube
Abstract: Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes’ date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, we look at a way we can accomplish this by implementing a SQL Server Analysis Services “many-to-many” dimension scenario.
Speaker(s):
- William E Pearson III
Track and Room: BI Track #2 (106) - N/A
Title: Visual Studio 2010 Database Projects
Abstract: Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren’t databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.
Speaker(s):
- Randy Knight
Track and Room: Dev Track #2 (111) - N/A
Title: Light-up BI Dashboards with Cool Visualizations
Abstract: We will dive into discussions lots of demos on techniques you can leverage for your own Microsoft SQL Server SharePoint BI solutions. I’ll show examples and how to create cool dashboards with compelling visualizations for office-based users and mobile users. This session will be geared toward SQL Server professionals with .NET code samples that can be easily re-used.
Speaker(s):
- Mark Kromer
Track and Room: BI Track #2 (106) - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Muthu Ramanathan
I am Muthu Ramanathan, currently working as a Dedicated SQL Engineer @ Microsoft. I have been with Microsoft for 5years, dealing with Microsoft’s Premier customers. I have been working with SQL Server since version 4.2 for over 15 years, when SQL shared very similar characteristics as Sybase. My recent passion has been around Big Data and the Hadoop Eco-system, currently engaged actively working on a couple of POC’s involving MPP database systems and Hadoop Systems.
Greg Seidel
I am a Technology Sales Specialist for SQL Server, servicing the Mid Atlantic States District. Prior to joining Microsoft I was a SQL Server DBA for a national pharmacy chain. I also worked as a Data Warehouse Administrator for a national cable company.
Bill Wolff
Twitter: - https://twitter.com/billjwolff
LinkedIn: Bill Wolff
Contact: https://mvp.microsoft.com/en-us/PublicProfile/10864?fullName=Bill%20Wolff
Bill Wolff is an independent consultant, trainer, and architect specializing in Microsoft development technologies under the name Agility Systems. He ran the consulting firm Wolff Data Systems for 15 years and directed armies of consultants in the dot com world. Bill is founder and President of the philly.NET user group and involved in several other user communities. Bill is a 15 year Microsoft MVP in .NET and SQL.
Dennis Lloyd and Sebastian Meine .
Contact: http://tSQLt.org
Sebastian Meine, PhD is a principal trainer and consultant with sqlity.net llc (http://sqlity.net). He specializes in T-SQL performance and SQL-TDD and shares his passion and knowledge regularly with audiences world-wide.
If you want to get Dennis talking, ask him about database quality and testing. He enjoys sharing his experiences about software development, databases, agile practices and bioinformatics. You can find out more about what he’s up to at: http://curiouslycorrect.com
Michael Coles
Michael Coles is a prolific writer on SQL Server topics. He has authored or coauthored several SQL Server developer titles including Expert SQL Server 2008 Encryption, Pro T-SQL 2008 Programmer’s Guide and Pro Full-Text Search in SQL Server 2008. He has also written dozens of technical articles that have been published online and in print magazines. Michael is a Microsoft MVP (SQL) and holds MCST:SQL Server 2008 (database development), MCDBA and MCP+I certifications, with a Bachelors degree in Information Technology. Michael has over 15 years SQL Server experience and he is currently Chief ETL Architect for a BI consulting firm in New York.
Mark Kromer
Twitter: - @kromerbigdata
LinkedIn: Mark Kromer
Contact: http://www.kromerbigdata.com
Mark Kromer is a Microsoft Cloud Data Solution Architect with 20 years of experience in database applications, data warehouses, big data and business intelligence.
Joe Toscano
Joe Toscano is an Architect at Siemens who has been working with SQL Server since version 6.5 as a consultant, DBA, ETL Specialist, DW Architect, instructor and mentor. Over the last few years he has focused on Business Intelligence projects leveraging the SQL Server BI stack, but has continued to work on SQL Development and SQL Administration projects. Joe has presented at numerous events including PASS, PSSUG and SQLSaturdays and has SQL Server classes for several Microsoft Partners.
Alex Grinberg
LinkedIn: Alex Grinberg
I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book “XML and JSON Recipes for SQL Server”, also wrote number of articles for Simple-Talk and SQLServerCentral.com
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Muthu Ramanathan
I am Muthu Ramanathan, currently working as a Dedicated SQL Engineer @ Microsoft. I have been with Microsoft for 5years, dealing with Microsoft’s Premier customers. I have been working with SQL Server since version 4.2 for over 15 years, when SQL shared very similar characteristics as Sybase. My recent passion has been around Big Data and the Hadoop Eco-system, currently engaged actively working on a couple of POC’s involving MPP database systems and Hadoop Systems.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Mark Kromer
Twitter: - @kromerbigdata
LinkedIn: Mark Kromer
Contact: http://www.kromerbigdata.com
Mark Kromer is a Microsoft Cloud Data Solution Architect with 20 years of experience in database applications, data warehouses, big data and business intelligence.
Michael Coles
Michael Coles is a prolific writer on SQL Server topics. He has authored or coauthored several SQL Server developer titles including Expert SQL Server 2008 Encryption, Pro T-SQL 2008 Programmer’s Guide and Pro Full-Text Search in SQL Server 2008. He has also written dozens of technical articles that have been published online and in print magazines. Michael is a Microsoft MVP (SQL) and holds MCST:SQL Server 2008 (database development), MCDBA and MCP+I certifications, with a Bachelors degree in Information Technology. Michael has over 15 years SQL Server experience and he is currently Chief ETL Architect for a BI consulting firm in New York.
Raj More
I am a Business Intelligence developer, having transitioned over from transactional systems a few years ago. I find business use of data extremely fascinating. I have recently moved to Baltimore, and I love life here.
Said Salomon
Said Salomon has over 25 year experience as an IT Professional. He has a vast array of abilities in the field in the areas of Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America. Current Said is a DBA at Unitrin Direct Insurance. Secretary of Philadelphia SQL Server User Group (PSSUG). I am also the SQL Track lead for the Philly Dot Net Code Camps.
Mark Kromer
Twitter: - @kromerbigdata
LinkedIn: Mark Kromer
Contact: http://www.kromerbigdata.com
Mark Kromer is a Microsoft Cloud Data Solution Architect with 20 years of experience in database applications, data warehouses, big data and business intelligence.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Dale Cunningham
Twitter: - https://twitter.com/fly_scuba
LinkedIn: Dale Cunningham
Contact: http://www.dalecunningham.com
Dale Cunningham is a Sr. Database Administrator and has worked for enterprises both large and small. Performance tuning, Clustering, High Availability and Disaster Recovery are his preferred fields of focus in the MS SQL arena. In his spare time, Dale enjoys flying as a private pilot and playing racquetball. As a father of 5 children and grandfather to 4, family is an important part of his life. Dale enjoys visiting foreign countries and exploring the world. He has recently been married to a wonderful woman from Ukraine and they enjoy traveling the world together. Dale desires to build a home that is energy self-sufficient by using solar, wind and hydro electric power. He enjoys Call of Duty on XBox under the handle XO UEG Barricuda.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Bharat Kenjale
Bharat Kenjale have more than 10 years’ experience working as Database administrator. Experience Profile Database Administrator : Credit Suisse, New York, NY : 2002 -2006 Sr. Database Administrator: Goldman Sachs, New York, NY : 2006 - 2009 Data Architect/Sr. Database Administrator : Susquehanna International Group, Bala Cynwyd,PA: 2009 - present
Bharat is Microsoft Certified IT Professional (MCITP) and have experience in presenting at local PASS chapters.
Patty Pickup
I have been working with and certified in SQL Server since version 6.5 (around 1996). I spent over a decade working as an independent contractor for companies as large as Fortune 500 Companies (Rohm and Haas, Glaxo Smith-Kline) and as small as just a few people. I have worked on Data Warehousing projects as well as traditional OLTP applications. I have passed all six Microsoft SQL 2008 Certification Exams and am currently studying to become a Microsoft Certified Master in SQL.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Matt Van Horn
Contact: http://www.anythingtheycando.com/blog/index.php
Matt Van Horn is a Sr. Consultant with Services group at Infragistics, a world leader in user interface (UI) development tools and experts in the User Experience (UX) market. In his current role, Matt is responsible for working with our customers to develop innovative applications.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Wayne Sheffield
Twitter: - @DBAWayne
LinkedIn: Wayne Sheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
Robert Pearl
Twitter: - @PearlKnows
LinkedIn: Robert Pearl
Contact: http://www.sqlservercentral.com/blogs/pearlknows/
Robert Pearl is a 5-year SQL Server MVP and creator of the award-winning database and monitoring alert system, SQLCentric. Author of the HealthySQL - Comprehensive Guide to Healthy SQL Server Performance. He’s the founder of Pearl Knowledge Solutions. As a SQL Server community evangelist, he covers local SQL Server events in the New York City area and maintains the Pearl Knows blog. Voted TOP BLOGGER in 2011.
Hilary Cotter
Hilary Cotteris a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in HA technologies, especially replication, performance tuning, full-text search, and SQL Server Service Broker.
Hilary is also an author, or contributor on a number of books on SQL Server.
Kevin Goff
Twitter: - @KevinSGoff
Contact: http://www.KevinSGoff.net
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Database architect/developer/speaker/author
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
Vince Napoli
Twitter: - @Napoli_V
LinkedIn: Vince Napoli
Vince is a Business Intelligence Architect with Anexinet in Blue Bell. He has worked with Data Warehousing and Business Intelligence since 1996, with a focus and specialty on SQL Sever since 1999, and an BI Architect since 2001. Vince is a frequent presenter at PSSUG, former president and current board member of PSSUG, and has presented at several SQLSaturdays and also a Code camp presenter in the Philadelphia area.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Kevin Goff
Twitter: - @KevinSGoff
Contact: http://www.KevinSGoff.net
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Database architect/developer/speaker/author
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
Sebastian Meine
Twitter: - @sqlity
LinkedIn: Sebastian Meine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
Matt Van Horn
Contact: http://www.anythingtheycando.com/blog/index.php
Matt Van Horn is a Sr. Consultant with Services group at Infragistics, a world leader in user interface (UI) development tools and experts in the User Experience (UX) market. In his current role, Matt is responsible for working with our customers to develop innovative applications.
Sharon Dooley
Sharon Dooley has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Architect. Sharon is an active member of PASS and leads the DBA Virtual Chapter.
Sponsors
The following is a list of sponsors that helped fund the event: