Event Location:
45 Liberty Blvd.
Malvern, Pennsylvania
Abstract:
As I enter into the World of Database Administration I found that I was not only concerned about the data within the Database but with other technologies that support the database. Where is the data stored and who is responsible for that device? How will that be accessed and what level of access should they be granted. What host will the Instance be installed and who is responsible for that? These question lead to other question that we don’t have control so therefore we must find a way too intelligently and effectively communicate. Let’s look at some of the ways to enhance the communication between administrative groups outside of the Database realm. Is the Operating System and Network that supports the database functioning as expected? Is the storage device providing us with optimal throughput? Do we have enough space to continue to grow our data and Log files? How can this be evaluated and effectively communicated to administrators that are not DBA’s?
Speaker(s): Todd Phillippe,
Abstract:
Remember the days when Analysis Services solely represented an OLAP engine? Are you unclear about when to still build cubes vs. invoke the new Tabular engine in SSAS? Do you feel confused about where the self-service capabilities of PowerPivot end and where enterprise BI begins? If you answered YES to any of those questions, please join A.J. Mee (Principal BI Specialist at Microsoft) for some practical, real-world guidance around the three modes of SQL Server Analysis Services. As with most of A.J.'s presentations, the vast majority of the time will be spent providing demonstrations of the technology. Both traditional (i.e. relational) and non-traditional (i.e. unstructured/semi-structured) data sources may be incorporated into the demonstrations.
Speaker(s): A.J. Mee,
Abstract:
Coaching might be the most important and least understood component of building a high performance team and a high performance career. Coaching leverages the art and science of active listening, powerful questions, giving and receiving high quality feedback, goal setting, and managing accountability. It’s a very different from training or mentoring. You spend time tuning your database. How much time do you spend tuning questions? This session is an introduction to the art and science of asking great coaching questions. We’ll explore a wide range of questions that are great to have in your quiver of question especially no matter what job you have in #sqlfamily. Coaching takes years to master. Learning basic coaching skills can happen quickly impacting your life, career, and the people around you in a modest period of time. You’ll leave this session with practical skills that can be quickly embraced and which have the potential to change your life and career for the better.
Speaker(s): Brian Moran,
Abstract:
Get in-depth knowledge and architectural guidance on modeling, governing and managing large data sets through the use of Partitioned Tables and how to load and manage them. Learn an effective ETL architecture, strategy and tactics to support: 24x7 business intelligence availability with no data warehouse "down-time" for data loading Supporting complex, multi-column partition schemes with given the current single-column limitation on partitioning functions Partition loading and switching with minimal impact on user activity (queries) High-performance business intelligence solutions by leveraging ColumnStore indexes on partitioned tables Updating partitioned table with ColumnStore Indexes given the current read-only limitation on tables with ColumnStore indexes Use SQL Server Integration Services as purely a orchestration tool for these processes Leverage SQL Server Management Objects to deliver a set of robust methods for a more flexible ETL architecture ***** 2 Hours Pleas
Speaker(s): Darryll Petrancuri,
Abstract:
Get in-depth knowledge and architectural guidance on modeling, governing and managing large data sets through the use of Partitioned Tables and how to load and manage them. • Learn an effective ETL architecture, strategy and tactics to support: 24x7 business intelligence availability with no data warehouse "down-time" for data loading • Supporting complex, multi-column partition schemes given the current single-column limitation on partitioning functions • Partition loading and switching with minimal impact on user activity (queries) High-performance business intelligence solutions by • leveraging ColumnStore indexes on partitioned tables • Updating partitioned table with ColumnStore Indexes given the current read-only limitation on tables with ColumnStore indexes • Use SQL Server Integration Services as purely a orchestration tool for these processes • Leverage SQL Server Management Objects to deliver a set of robust methods for a more flexible ETL architecture
Speaker(s): Darryll Petrancuri,
Abstract:
As every DBA knows, the one question you want to be able to answer affirmatively is “Can you recover that data?” Monitoring is critical, but monitoring methods can be imperfect. Traditional methods are difficult to set up and maintain across your entire environment, resulting in incomplete monitoring and missed alerts, so that it’s difficult to be sure of your answer to that all important question. This presentation will: • Describe a better way to monitor your database environment that is more efficient, easier to maintain, and guarantees that you never miss an alert. • Share key syntax, so that you are certain the databases you are responsible for are always up, always backed up, and never run out of disk/file space. So that your answer to that all important question is always YES!
Speaker(s): John Abrams,
Abstract:
Database development can be a daunting task when modifying many objects for a project or coordinating schema changes across a team of developers. Implementing those changes can be equally problematic, particularly when deploying them to different versions of the same database. SSDT makes database refactoring a breeze – tracking renamed objects, preventing data loss during deployment and maintaining references between objects in a database. See the latest features in SSDT and learn how to create and work within a database project. Learn the tips and tricks in Visual Studio that will cut your development effort and allow you to deploy 100s of changes without missing an object, with better quality code.
Speaker(s): Mark Wojciechowicz,
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,
Abstract:
Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline and provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-)
Speaker(s): Robert Pearl,
Abstract:
SSIS is the tool of choice for loading a data warehouse. But let's face it, dragging round cornered boxes and connecting them with arrows ain't fun. It's time consuming and you'll soon realize you're doing the same thing over and over again. Sam Vanga demonstrates how to dynamically create SSIS packages to process dimension and fact tables using Business Intelligence Markup Language (BIML), a free add-in.
Speaker(s): Samuel Vanga,
Abstract:
In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
Speaker(s): Timothy McAliley,
Abstract:
Learn about the leader in Enterprise Flash Technology: Fusion-io and discover the power its io-Memory platform can provide to your enterprise. Reduce query times, decrease batch processing, and increase the efficiency of your infrastructure all without increasing your datacenter footprint!
Speaker(s): Eric Schwartz,
Abstract:
Access, mash, clean, explore, visualize, and publish information using Excel and SQL Server!
Speaker(s): Kevin Bucher,
Abstract:
Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs. Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance? In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many.
Speaker(s): Mike Hillwig,
Abstract:
As the newest version of SQL Server, 2012 is introducing many new BI features. This session will look at what has changed in SSIS 2012 and how to best leverage these new features to get the most for your ETL effort!
Speaker(s): Paul Rizza,
Abstract:
Regular Expressions, aka RegEx, is a powerful syntax for finding patterns in text, which has been around since the 60’s. Until recently the power of RegEx has been an elusive tool to T-SQL Developers. This presentation will provide an introduction to Regular Expressions in general and concentrate on the tools and techniques for using them in T-SQL. Find out how easy and powerful Regular Expressions can be for everyday tasks such as basic where condition criteria to validating and scrubbing data. Come on you know you’ve always wanted to learn RegEx ever since you first saw them. Now is your chance to get a jump start on using them. You will leave with the tools, knowledge and resources to get you started.
Speaker(s): Joshua Lynn,
Abstract:
Cluster MVP David Bermingham will walk you through the process of creating high availability and disaster recovery configurations using the new features of SQL Server 2012 AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters and Multisite Clusters. And then finally David will demonstrate how Availability Groups and Failover Clusters can be used together for a combination of High Availability and Disaster Recovery. This session will make use of VMs to demonstrate the technology in a "hands-on" fashion.
Speaker(s): David Bermingham,
Abstract:
We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FORTY times now and it is always very highly rated!
Speaker(s): Kevin Boles,
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 how to use each one.
Speaker(s): Jessica Moss,
Abstract:
Eliminate the I/O barriers to data center with storage at the speed of memory. Violin Memory solutions deliver breakthrough performance and scalability through an enterprise-class storage system that unlocks the full potential of your SQL infrastructure. KEY BENEFITS • Mixed workload on shared hosts with no risk to SLAs • Protect data without impacting performance Setting the Benchmark Standard for SQL performance • 5x to 10x faster performance for all workloads • 5x to 10x less latency • Elastic scalability for cloud deployments • Increase density and improve IT efficiency • Reduce TCO through increased consolidation
Speaker(s): Peter Wellauer,
Abstract:
In this sessions, We will look at SSIS and what you will need to take in consideration that will performance of your package. We'll take a look at the SSIS execution tree, buffer usage by SSIS transforms, and design considerations that will impact the performance of your package.
Speaker(s): Vince Napoli,
Abstract:
You got the "It's Slow" call, yeah you know the one. There are many places to dig in and determine how true that is but we'll focus on what the server thinks utilizing Performance Monitor. We'll go a bit deep into those facts in the poster on the wall and tell you the what/where/whys of it all. We'll make sure you understand those items selected and what they mean. We will also go through ways to quickly analyze that mountain of data collected.
Speaker(s): Hope Foley,
Abstract:
You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this demo rich session you will be able to - Explain the differences between SQL Servers 9 "index" types - Identify the layout of SQL Server data on disk - Decide which index types are the right ones to use for a given query - Assess the impact of the Key on access speed
Speaker(s): Sebastian Meine,
Abstract:
Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.
Speaker(s): Kevin Boles,
Abstract:
Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.
Speaker(s): Andy Warren,
Abstract:
Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card.
Speaker(s): Dave Bermingham and Eric Schwartz,
Abstract:
We all know that backups are important. Don't we? And we know that our backups are only as good as our ability to restore them. Dont' we? In this session, veteran DBA Mike Hillwig will walk through the basics of database backup and recovery, including the different types of backups. He'll also set the record straight around some very common myths around database backup and recovery.
Speaker(s): Mike Hillwig,
Abstract:
Are you struggling with performance issues and your current tools are not providing answers? Confio’s flagship product, Ignite, may be your answer. This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. The speaker will use real-life case studies to demonstrate the techniques.
Speaker(s): Janis Griffin,
Abstract:
Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common DBA problems by utilizing Cloud services in combination with PowerShell automation. In this session, we'll review the basic Cloud architecture, as well as some specifics as to the components of the solution.
Speaker(s): Matt Velic,
Abstract:
More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important data, but the formatting must be stripped out in order for users to effectively search this data. Filestream, Filetable, Full-Text Search, and Semantic Search are covered.
Speaker(s): Steve Jones,
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,
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
Speaker(s): Jim Murphy,
Abstract:
SQL Server 2012 provides a variety of advanced tools for presenting Business Intelligence data to businesses. This session will explore building a flexible business intelligence architecture that can meet the variety of changing needs most businesses face, including scale up and scale out of BI services. It emphasizes an infrastructure that can focus the available computing resources where they are most needed quickly and easily.
Speaker(s): Mark Scott,
Abstract:
This session will move your on premise SQL Server database to a Windows Azure SQL Database using SQL Server 2012 Management Studio. In addition, after the database has been moved into the cloud, we will setup a Data Sync process using the SQL Azure portal across different server locations.
Speaker(s): Charles Rivel,
Abstract:
SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.
Speaker(s): Wayne Sheffield,
Abstract:
Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance, and is an important part of the SQL Server 2012 release: This session revolves around a demo which brings together our EIM functionality in SQL Server 2012 and which tells our Credible, Consistent Data story. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.
Speaker(s): Donald Scott,
Abstract:
Let's go beyond the hype of Big Data and the Microsoft story around Big Data and talk about real-world actual implementations of Big Data Big Data Analytics solutions. I'll talk about implementing SQL Server, Big Data Analytics engines, Hadoop and Big Data visualizations tools.
Speaker(s): Mark Kromer,
Abstract:
Virtualisation is a hot topic at the moment and the chances are your business is probably looking at or already implemented virtualisation to some degree. As a DBA there will be pressure for you to virtualise your SQL Servers too. Many DBAs are reluctant to virtualise their SQL servers usually because of the fear that that performance will suffer. If virtualisation is done properly though SQL Server will run perfectly well on a virtual platform and you may even get some added HA benefits thrown in for free.
Speaker(s): Gethyn Ellis,
Abstract:
Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.
Speaker(s): Brian Davis,
Abstract:
SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.
Speaker(s): Janis Griffin,
Abstract:
In this session we'll discuss the important features of an Enterprise-grade ETL framework and how easy it is to build one leveraging the new improved features of SSIS 2012.
Speaker(s): Ravi Gudlavalleti,
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Speaker(s): Chris Bell,
Abstract:
We'll discuss concepts of Spatial Data, and how it is implemented in SQL Server. We'll look at Geometry vs. Geography, different spatial data instances, and functions operation on them.
Speaker(s): Dominic Falso,
Abstract:
This session covers the Self Service BI solutions available using Office 2013 and SQL 2012 for business users to do their ad-hoc analysis. In addition, the Analysis Models can be used for by Power View for visual representation of the analysis.
Speaker(s): Akesh Gupta,
Abstract:
SQL Server Integration Services (SSIS) 2012 added full support for Change Data Capture (CDC) on databases. In this session we will cover the basics of CDC in SQL Server 2012 and then how to build SSIS 2012 packages that make using CDC to load your Data Warehouses easier than they were before. No previous knowledge of CDC is required for this session, but some knowledge of any version of SSIS will make it easier to understand.
Speaker(s): Steve Wake,
Abstract:
Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
Speaker(s): Joseph D'Antoni,
Abstract:
In recent years Data Careers have expanded beyond the conventional role of a DBA. This is due to the ever expanding amount of data, a larger variety of tools and the need for business to use data to drive their own performance goals. This session will provide an overview of Data Careers, a discussion of personal traits and life stages that may align with different Data Careers. The new Career areas such as Data Science, Analytics and Data Journalism will be reviewed. In addition, the attendees will be provided with a template that will enable them to make more strategic career-related decisions.
Speaker(s): Melissa Demsak,
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
Speaker(s): Eddie Wuerch,
Abstract:
Whether predicting customers or All Stars, 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,
Abstract:
Lets talk about some of the open source databases today CouchDB, MongoDB, HBase, PstgreSQL, Redis, Neo4J. You will learn and see how these databases are different and where they fit when desiging a data solution. We will cover Relational DB's, Document DB's, Graph DB's, Key-Value and columnar databases. We will then get into Big Data solutions and see some examples of MapReduce Hive queries on HDInsight.
Speaker(s): Muthu Ramanathan,
Abstract:
MVC is the hot trend in .NET web development projects. The model in MVC is usually fed from a database to store and retrieve data. This session covers the tooling and techniques to reliably process data queries to a local, enterprise, or Azure SQL Server database. Some developers prefer the code first database generation with scripted schema updates. Other projects require entity data models bound to legacy databases. Front end tools for displaying and editing data with model driven validation and also presented.
Speaker(s): Bill Wolff,
Abstract:
Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!
Speaker(s): Eddie Wuerch,
Abstract:
A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If it is not done correctly you will not be successful. This presentation will teach the you how to do it right. We will discuss why you virtualize a database, using the right hypervisor, installation, Architecting for performance, the storage layer, the processor, Memory considerations, the network layer. This presentation focuses on VMware but much of the information is relevant in any virtualized environment.
Speaker(s): Michael Corey,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Narayan Venkat – Vice President, Product Management Narayan brings 20 years of expertise in storage, data management, and virtualization platforms.
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
LinkedIn: http://www.linkedin.com/in/b5lurker
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
LinkedIn: http://www.linkedin.com/in/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Contact: http://mssqldude.wordpress.com/
Mark Kromer has been with Microsoft for over 5 years in a number of roles over those years including technology specialist and product manager, always centered on the Microsoft data platform. Current, Mark travels the U.S. talking with customers about best practices in implementing Microsoft BI, DWs and Big Data solutions. Mark was also previously the BI Big Data technology director for Razorfish and Anexinet as well as a product manager for Oracle.
LinkedIn: http://www.linkedin.com/pub/samuel-vanga/60/385/551
Contact: http://SamuelVanga.com
Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at http://SamuelVanga.com.
Sr. BI consultant and Architect with over 10 years of experience delivering BI solutions for Fortune 150 clients. Helped clients transition from legacy third party ETL solutions to SSIS.
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.
LinkedIn: https://www.linkedin.com/in/briandavis78
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Contact: http://www.confio.com
Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database applications. Before coming to Confio, Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As a Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning.
LinkedIn: http://www.linkedin.com/pub/christopher-bell/19/a08/93/
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.
Akesh Gupta is founder of Light Speed Solutions. He has more than 20 years of experience in architecting, designing, developing and delivering successful applications of all sizes for various industries. Akesh Gupta is a certified Microsoft Trainer with a passion to bring real world experience into his training sessions. At Light Speed Solutions, he is actively involved in bringing the power of analysis using PowerPivot and PowerView to business user community.
Contact: http://us.sios.com/blog/
Dave Bermingham is the Senior Technical Evangelist at SIOS Technology Corp. He is a Microsoft Cluster MVP award recipient (2010-2013) with over 25 years IT experience. He specializes in HA clustering and related technologies. Eric Schwartz is the Sales Engineering Manager for the Northeast USA at Fusion-io. He has over fifteen years experience managing and deploying IT infrastructure and specializes in high performance storage solutions leveraging solid state technologies.
LinkedIn: https://uk.linkedin.com/in/gethynellis
Contact: http://www.gethtynellis.com
Gethyn is a SQL Server consultant and trainer and has worked with SQL Server for nearly 20 years. He specialises in version mIgration, performance, security, architecture and design including Azure and virtualisation solutions. He is working with private and public sector organisations in the UK, Europe and USA. Gethyn delivers a range of SQL Server training, including the Microsoft Official Curriculum. He is the author of three training courses and two published books on SQL Server and Azure. You can find his blog at www.gethynellis.com
LinkedIn: http://www.linkedin.com/in/sqlwatchmen
Contact: http://sqlwatchmen.com/blogs/jim/
Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.
Contact: http://anexinet.com/solutions/bi_data_solutions.asp
Managing Director overseeing the Business Intelligence practice at Anexinet.
LinkedIn: http://www.linkedin.com/in/mattvelic
Contact: http://mattvelic.com
Matt Velic is a database developer for Sanametrix in Washington, DC. When not jet setting between projects at work, you can find him at a board game, a video game, or playing a guitar.
LinkedIn: http://www.linkedin.com/in/sqldiva/
Melissa Demsak is passionate about Data, Business and People. She’s currently a Manager of SQL Architecture at large real estate holding company. Melissa was the leader of the NJSQL User Group ‘06-‘12, PASS Summit Program Committee ’07-’10 and a PASS Regional Mentor. She’s currently on the Program Committee for the PASS BA Conference in April and leads the PASS Business Analytics Virtual Chapter.
LinkedIn: http://www.linkedin.com/in/briancmoran
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.
LinkedIn: http://www.linkedin.com/in/dpetrancuri
Darryll Petrancuri is a visionary and innovative software developer and architect who today specializes in developing solutions, including data models, database / ETL framework architecture and implementation for business intelligence challenges in environments with VLDBs and highly volatile / unstable dimensions and attributes using SQL Server and .NET technologies. (Pending Revision)
LinkedIn: http://www.linkedin.com/in/eddiewuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
LinkedIn: https://www.linkedin.com/in/michael-corey/
Contact: http://michaelcorey.com/
Michael is a Director Cloud Computing Evangelist for Spectrum Enterprise Navisite. In 2017, was recognized as #42 of the top 100 most influential people in the “cloud industry”. Michael's a recognized Microsoft Data Platform MVP formerly (Microsoft SQL Server MVP), recognized Oracle ACE, a recognized VMware vExpert and has worked with relational databases for over 30 years starting with Oracle Version 3. Michael is a Past President of the Independent Oracle Users Group (IOUG), A Founder of the Professional Association of SQL Server and current President of the IOUG VMware Special Interest Group. Michael is the original Oracle Press author, frequent blogger http://michaelcorey.com/, a regular columnist for the Big Data Quarterly
LinkedIn: http://www.linkedin.com/in/mikehillwig
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.
Contact: http://www.pocketjoshua.com/sql
Joshua Lynn started programming databases when he was 14. Professionally, he has been in the IT industry since 1991 specializing in database design, ETL, and change detection. His experience with SQL server goes back to version 6.5 where he thought triggers were neat. Currently, he is still working on doing useful things with SQL server and believes CTEs have enhanced his professional life. In his spare time, he mentors high school students in building robots. He is also an advocate for Deadlock victims’ rights.
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.
Contact: http://www.aspect-consulting.com/
John Abrams, COO and Co-Founder of Aspect Consulting, Inc. John is senior Data Architect/DBA with 20+ years’ experience working with clients and their data. John’s primary focus is on database administration, performance tuning, data warehouse and data load processing design and architecture, as well as application design and architecture.
LinkedIn: http://www.linkedin.com/in/dpetrancuri
Darryll Petrancuri is a visionary and innovative software developer and architect who today specializes in developing solutions, including data models, database / ETL framework architecture and implementation for business intelligence challenges in environments with VLDBs and highly volatile / unstable dimensions and attributes using SQL Server and .NET technologies. (Pending Revision)
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
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.
Contact: http://www.fusionio.com
Fusion IO
LinkedIn: http://www.linkedin.com
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.
LinkedIn: https://www.linkedin.com/in/vince-napoli-777691
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.
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.
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.
LinkedIn: http://www.linkedin.com/in/WayneSheffield
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
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.
LinkedIn: https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile
Contact: http://clusteringformeremortals.com/
David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.
LinkedIn: http://www.linkedin.com/in/eddiewuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: http://www.linkedin.com/in/billjwolff
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.
LinkedIn: http://www.linkedin.com/in/prizza/
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.
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
Is the Job of a DBA, just a DBA? As I enter into the World of Database Administration I found that I was not only concerned about the data within the Database but with other technologies that support the database. Where is the data stored and who is responsible for that device? How will that be accessed and what level of access should they be granted. What host will the Instance be installed and who is responsible for that?
Contact: http://www.itkegger.com
Team of Speakers: Donald Scott (donscott@microsoft.com), Kenneth Hausman (kennha@microsoft.com), Jon Tupitza (jtupitza@microsoft.com). We are all Microsoft employees. We support SQL and other Microsoft products for customers around the DC area. Together we bring over a decade of MS experience. Ken Hausman and Jon Tupitza are Microsoft Consultants and Donald Scott is a Microsoft Premier Field Engineer.
LinkedIn: http://www.linkedin.com/in/WayneSheffield
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
Mark Scott is a senior Business Intelligence consultant with Microsoft Consulting Services. He has over a decade of deep technical experience with the Microsoft SQL Server platform and has built business intelligence systems for manufacturing, financial, healthcare and pharmaceutical firms throughout the nation. He has authored a number of books and spoken internationally on Business Intelligence and database topics.
LinkedIn: http://www.linkedin.com/pub/timothy-mcaliley/10/530/787/
I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.
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.
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 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 served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).
LinkedIn: http://www.linkedin.com/in/mikehillwig
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.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
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.
LinkedIn: http://www.linkedin.com/profile/view?id=3997984amp;trk=hb_tab_pro_top
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”.
The following is a list of sponsors that helped fund the event.