SQLSaturday #121 - Philadelphia 2012
Event Date: 06/09/2012 00:00:00
Event Location:
- 45 Liberty Blvd.
- Malvern, 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: Working with Server Side Traces
Abstract: You 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.
Speaker(s):
- Christina Leo
Track and Room: DBA\Dev - N/A
Title: You’re My Density: Making Sense of Statistics
Abstract: The 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.
Speaker(s):
- Erin Stellato
Track and Room: DBA\Dev - N/A
Title: Building Your First Tabular Model
Abstract: With 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 Indicators
Speaker(s):
- Dan Clark
Track and Room: BI 2012 - N/A
Title: Conversational leadership
Abstract: Leadership 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.
Speaker(s):
- Brian Moran
Track and Room: Prof Dev - N/A
Title: MongoDB for the Relational DBA
Abstract: NoSQL 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.
Speaker(s):
- Justin Dearing
Track and Room: DBA II - N/A
Title: Much Ado About Indexes - Tuning, Tips Tricks
Abstract: In 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.
Speaker(s):
- Robert Pearl
Track and Room: DBA II - N/A
Title: It Costs How Much? SQL Server Licensing
Abstract: Did 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.
Speaker(s):
- Joseph D’Antoni
Track and Room: Prof Dev - N/A
Title: Model-Driven Database Design
Abstract: Model-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.
Speaker(s):
- Karen Lopez
Track and Room: DBA\Dev - N/A
Title: T-SQL for Application Developers - Attendees chose
Abstract: That’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.
Speaker(s):
- Kevin Goff
Track and Room: Development - N/A
Title: You Wouldn’t Let HR Manage Your DBs…
Abstract: 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.
Speaker(s):
- Joseph D’Antoni
Track and Room: Prof Dev - N/A
Title: Managing SQL Server in Large Warehouse Environment
Abstract: For 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.
Speaker(s):
- Mark Kromer
Track and Room: BI/Dev - N/A
Title: Minimally Invasive - Tools to Doctor Up Your Code
Abstract: This 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!
Speaker(s):
- Wayne Sheffield
Track and Room: DBA\Dev - N/A
Title: Power View 101
Abstract: Built 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.
Speaker(s):
- Kevin Bucher
Track and Room: BI - N/A
Title: Accelerate SQL Server 10x
Abstract: This 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.
Speaker(s):
- Pat Latorra
Track and Room: DBA I - N/A
Title: 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 Jr
Track and Room: Development - N/A
Title: Using Database Projects to Manage Schema Changes
Abstract: This 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.
Speaker(s):
- Mark Wojciechowicz
Track and Room: BI/Dev - N/A
Title: Best Practices for Monitoring Databases on VMware
Abstract: SQL 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.
Speaker(s):
- Kathy Gibbs
Track and Room: DBA II - N/A
Title: SQL Server performance tuning made easy !
Abstract: 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.
Speaker(s):
- Muthu Ramanathan
Track and Room: Development - N/A
Title: Career Management for Data Professionals
Abstract: Career 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.
Speaker(s):
- Karen Lopez
Track and Room: Prof Dev - N/A
Title: Integrating MDX code with OLAP applications
Abstract: It’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.
Speaker(s):
- Kevin Goff
Track and Room: BI/Dev - N/A
Title: SSIS Tips Tricks
Abstract: Learn 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.
Speaker(s):
- Josef Richberg
Track and Room: BI/Dev - N/A
Title: Advanced Performance Tuning Tips with Ignite
Abstract: Are 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.
Speaker(s):
- Kathy Gibbs
Track and Room: DBA II - N/A
Title: SQL Server 2012’s Net-New BI Capabilities
Abstract: Much 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 Index
Speaker(s):
- A.J. Mee
Track and Room: BI 2012 - N/A
Title: Avoiding “Monkey At The Monitor” By Delegating
Abstract: As 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.
Speaker(s):
- Joshua Feierman
Track and Room: DBA I - N/A
Title: Performance Tuning for Pirates
Abstract: If 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.
Speaker(s):
- John Sterrett
Track and Room: DBA I - N/A
Title: Manage SQL Server 2012 with PowerShell and Core
Abstract: Windows 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.
Speaker(s):
- Allen White
Track and Room: DBA I - N/A
Title: Top Ten Rules for Managing a Production Environmen
Abstract: Mike 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.
Speaker(s):
- Mike Hillwig
Track and Room: DBA II - N/A
Title: DBA-User Interface, build a bridge.
Abstract: 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.
Speaker(s):
- Alex Grinberg
Track and Room: Development - N/A
Title: Creating a Performance Baseline for SQL Server
Abstract: Creating 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.
Speaker(s):
- Ron Johnson
Track and Room: DBA II - N/A
Title: Exploring your Data with Power View
Abstract: Exploring 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.
Speaker(s):
- Jessica Moss
Track and Room: BI 2012 - N/A
Title: SQL Server 2012 AlwaysOn Readable Secondaries
Abstract: One 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.
Speaker(s):
- Adam Belebczuk
Track and Room: DBA I - N/A
Title: Gather SQL Server Performance Data with PowerShell
Abstract: We 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.
Speaker(s):
- Allen White
Track and Room: DBA I - N/A
Title: Making Predictions with Microsoft Data Mining Tool
Abstract: Whether 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.
Speaker(s):
- Mark Hudson
Track and Room: BI - N/A
Title: Introduction to the .NET SSIS API (C#)
Abstract: 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.
Speaker(s):
- Dominic Falso
Track and Room: Development - N/A
Title: Data Quality Services in SQL Server 2012
Abstract: Based 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.
Speaker(s):
- Mark Wojciechowicz
Track and Room: BI 2012 - N/A
Title: Mobilize your PowerPivot Solutions
Abstract: Overview and demonstration of steps required to expose PowerPivot/SharePoint to mobile devices.
Speaker(s):
- Kevin Bucher
Track and Room: BI - N/A
Title: DBCC Commands: The Quick and the Dangerous
Abstract: There 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.
Speaker(s):
- Erin Stellato
Track and Room: DBA I - N/A
Title: What’s Buried in the Plan Cache?
Abstract: 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.
Speaker(s):
- Christina Leo
Track and Room: Development - N/A
Title: Analysis Services Half and Half-Half Cube/Half MDX
Abstract: In 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.
Speaker(s):
- Vince Napoli
Track and Room: Prof Dev - N/A
Title: Microsoft Cloud BI
Abstract: With 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.
Speaker(s):
- Mark Kromer
Track and Room: BI - N/A
Title: Advanced Charting Techniques in SSRS
Abstract: SSRS 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.
Speaker(s):
- Jason Thomas
Track and Room: BI/Dev - N/A
Title: Index Internals
Abstract: This 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.
Speaker(s):
- Sebastian Meine
Track and Room: DBA\Dev - N/A
Title: SharePoint Integration with SQL Server
Abstract: 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.
Speaker(s):
- Bill Wolff
Track and Room: BI/Dev - N/A
Title: PowerPivot BISM in SQL Server 2012
Abstract: The 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!
Speaker(s):
- Hope Foley
Track and Room: BI 2012 - N/A
Title: Increasing High Availability and Decreasing Comple
Abstract: In 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.
Speaker(s):
- Bill Emmert
Track and Room: DBA II - N/A
Title: Introduction to SQL Server Service Broker
Abstract: In 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.
Speaker(s):
- Adam Belebczuk
Track and Room: DBA\Dev - N/A
Title: Shortcuts to Building SSIS in .Net
Abstract: Shortcuts to Building SSIS in .Net
Speaker(s):
- Paul Rizza
Track and Room: BI - N/A
Title: Put Your Data on the Map
Abstract: Columbus 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.
Speaker(s):
- Mark Hudson
Track and Room: BI - N/A
Title: Creating a PPS Dashboard Using a BI Semantic Model
Abstract: This session will cover how one can create a PerformancePoint Services Dashboard using a SQL Server 2012 BI Semantic Model.
Speaker(s):
- Charles Rivel
Track and Room: BI 2012 - 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.
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
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
Kevin Bucher
Contact: http://anexinet.com/solutions/bi_data_solutions.asp
Managing Director overseeing the Business Intelligence practice at Anexinet.
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
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.
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.
Dan Clark
LinkedIn: Dan Clark
Contact: http://drclarkblog.wordpress.com/
Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.
Brian Moran
Twitter: - @briancmoran
LinkedIn: Brian Moran
Contact: http://www.linchpinpeople.com/author/brian-moran/
Brian Moran is Chief Servant Officer at Linchpin People and has been active in the SQL Server community for more than 20 years. Brian co-founded one of the first SQL Server user groups in the world, was one of the first SQL Server MVPs, was on the SQL Server Magazine launch team, and has served on the PASS Board of Directors in two separate terms. Brian#39;s roles in the SQL Server community include technologist, author, community leader, and entrepreneur.
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
Hope Foley
Contact: http://hopefoley.com/
Hope has over 12 years experience in the IT world, she has worked across many industries from small business enterprises to Fortune 500 companies. She 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. She is also a SQL Server MVP.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Bill Emmert
William Emmert, Technical Director/Technology Architect, Microsoft Technology Center, Microsoft Corporation Bill is a Data Platform Architect in the Philadelphia Microsoft Technology Center (MTC). He started his career at Microsoft in 1998 in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, he worked on the SQL Server product group for 1 year as a member of the SQL Server Customer Advisory Team (SQLCAT) returning back to consulting in 2008. In 2010 he worked in the New York MTC as a SQL Architect before taking on his current roles in the Philadelphia MTC in 2011. Bill has worked in the computer industry for 30 years.
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Dennis Lloyd Jr
Twitter: - @dennislloydjr
Contact: http://www.testdrivendatabases.com
Dennis Lloyd is a software development coach at Curiously Correct. He has broad experience in the software development life-cycle with specialized focus on Agile practices and database technologies. He is co-founder of the tSQLt unit testing framework for SQL Server and is active in the SQL Server open source community.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
John Sterrett
Twitter: - JohnSterrett
LinkedIn: John Sterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
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
Joshua Feierman
Contact: http://awanderingmind.com
Josh 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.
Mark Wojciechowicz
Contact: http://anexinet.com
Mark Wojciechowicz has worked as a business intelligence architect for Anexinet for the past 3 years and has MCITP certifications for SQL 2008 in Business Intelligence. He is a proponent of Agile project management for data warehouses and test-driven database development.
A.J. Mee
Contact: http://blogs.msdn.com/b/ajmee/
A.J. Mee is a Principal for Microsoft. He has dedicated his entire 20-year career to the field of BI and Database. He has served in varied roles from development to project management to people leadership to sales. He is a popular speaker who frequently presents on a wide variety of BI-related topics at numerous conferences and events. He came to Microsoft as part of its acquisition of ProClarity in 2006. A.J. holds a B.A. in Computer Science from LaSalle University.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Mark Wojciechowicz
Contact: http://anexinet.com
Mark Wojciechowicz has worked as a business intelligence architect for Anexinet for the past 3 years and has MCITP certifications for SQL 2008 in Business Intelligence. He is a proponent of Agile project management for data warehouses and test-driven database development.
Mark Hudson
Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and serves as a leader of the Richmond SQL Server User Group (www.richmondsql.org).
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.
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.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
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”.
Mark Hudson
Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and serves as a leader of the Richmond SQL Server User Group (www.richmondsql.org).
Charles Rivel
Contact: http://www.rdacorp.com
A developer of custom Microsoft applications since 1997 with a focus on Business Intelligence development since 2002. I have architected numerous data warehousing projects in multiple industries involving all areas of the Microsoft BI stack.
I also co-authored an Unleashed series book “ Microsoft SharePoint 2010 Business Intelligence Unleashed” detailing the different BI components in SharePoint 2010 and I have spoken at many SQL Server and SharePoint Group events throughout the country.
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.
Kathy Gibbs
Twitter: - KGdba
LinkedIn: Kathy 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
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
Pat Latorra
Contact: http://www.gridironsystems.com
Pat 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.
Justin Dearing
Twitter: - zippy1981
LinkedIn: Justin Dearing
Contact: http://www.justaprogrammer.net
Justin 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 currently works as a developer in the capital markets industry.
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.
Kevin Bucher
Contact: http://anexinet.com/solutions/bi_data_solutions.asp
Managing Director overseeing the Business Intelligence practice at Anexinet.
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
Bill Wolff
Contact: https://mvp.support.microsoft.com/profile=EFACCE1E-781F-45E9-A15D-22A07639500C
Bill 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.
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”.
Kathy Gibbs
Twitter: - KGdba
LinkedIn: Kathy 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
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Josef Richberg
Twitter: - sqlrunner
LinkedIn: Josef Richberg
Contact: http://josefrichberg.com
I have over 29 years in the world of RDBMS. I have in-depth knowledge of Microsoft SQL Server and the Azure platform (Data Factories, Logic Apps, Functions,Event Grids…) . I am fiercely passionate about my work.
I am currently developing a new Azure ecosystem for Penguin Random House. This includes moving load processes to Azure Logic Apps and Data Factory pipelines, leveraging Azure Functions, and pushing the new SQL Services to the limit.
I am the creator of the Enhanced Threading Framework (ETF) for SSIS. I presented at PASS 2013 on advanced SSIS techniques: http://www.sqlpass.org/summit/2013/Sessions/SessionDetails.aspx?sid=4845 and was awarded ‘2009 Exceptional DBA of the Year’, by RedGate and my peers.
Dominic Falso
Dominic is the Data Architect 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 2017 and .NET C#, doing data analysis and manipulation, as well as writing code management software.
Ron Johnson
Contact: http://rjssqlservernotes.wordpress.com/
A 20 year veteran of the IT industry with over 10 years experience as a software engineer Ron is a seasoned SQL Server performance optimization professional.Ron is currently supporting various clients as a consulting DBA specializing in PTO,Replication,HA/DR,and Security with Xtivia, Inc. a full-service IT company with offices in Dallas,TX, Colorado Springs,CO,and Edison,NJ.Ron earned a M.Sc. in Computer Science and a B.Sc. in Physics.Ron has 10 years of experience as an adjunct faculty member.
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.
Paul Rizza
Twitter: - @PaulRizzaSQL
LinkedIn: Paul Rizza
Contact: http://blogs.msdn.com/b/paulrizza/
Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning. Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.
Jason Thomas
Twitter: - @SqlJason
LinkedIn: Jason Thomas
Contact: http://www.SqlJason.com
Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).
Sponsors
The following is a list of sponsors that helped fund the event: