Event Location:
Microsoft New York Metro District Office
11 Times Square
New York City, New York
Abstract:
As an ETL developer using SQL Server Integration Services have you ever wondered how to: 1. Import all .csv files from a folder 2. Replace dynamic SQL using variables in SSIS 3. How to configure the data flow buffer 4. Create custom logging solutions 5. Use a script component as a data flow transformation This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties. Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components. Upon completion of this workshop attendees will be able to: 1. Import/export multiple sources/destinations 2. Use an execute SQL task with variables to replace dynamic SQL within a package 3. Dynamically handle errors within any part of a package 4.
Speaker(s): David Dye,
Abstract:
DevOps is a term that has come to mean many things to many people. At its core, this important concept represents a way to remove old barriers between the infrastructure, application, and development tiers within an IT organization. An understanding of scripting and automation platforms is becoming a critical skill for SQL Server Database Administrators. Additionally, as hardware is increasingly virtualized, new opportunities for scripted deployment and configuration are available. This session will utilize demos to illustrate the many ways SQL Database Administrators can automate routine tasks from deployment through configuration.
Speaker(s): Denis McDowell,
Abstract:
I have implemented at several client. In implementing MDS I have extensive experience in creating data quality, data governance and MDM/MDS accelerators I published many articles. Accelerators can take many forms generally there either software products that accelerate development and/or techniques that embody data aware and code generation capabilities. In developing the MDS application extracting data, applying data quality, loading MDS entities, and extracting data from MDS, we have applied these techniques, that I have published articles on. Specifically we've created an SSIS/MDS application architecture is highly reusable and can easily be used to Quickstart other MDS projects requiring minimal change and leaving the best practices for MDS architecture, as I understand them. The basic principle we applied this to be a data aware (data profiling)and create SSIS code that will self generate loan pr
Speaker(s): Ira Warren,
Abstract:
In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, and a SQL Server MVP. Along the way I saw my yearly income triple. Is it because I know some secret? Is it because I am a genius? No! It is just about laying out your career path, setting goals, and doing the work. It's about building your personal brand and stepping out of your comfort zone. It's about overcoming your fear of taking risks. If you can do those things, you will be rewarded. I will discuss how you too can go from unknown to well-known. I will talk about building your community presence by blogging, presenting, writing articles and books, twitter, LinkedIn, certifications, interviewing, networking, and consulting and contracting. Your first step to enhancing your career will be to attend this session!
Speaker(s): James Serra,
Abstract:
There’s just so much to do to get your systems to run in an optimal fashion, but where do you start. This session will walk you through an extensive checklist of things you can do to better manage your servers, databases and code. We’ll start with server configurations and what you can do with them. We’ll then move through standard administrative tasks that will help with performance. Then it’s off to the intricacies of database design and how that can affect performance. We’ll finish up with T-SQL and where it can hurt or help your systems. All examples in the session will use readily available tools that are a standard part of SQL Server. Get your own systems to run faster with the information you’ll receive.
Speaker(s): Grant Fritchey,
Abstract:
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through various pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust. In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
Speaker(s): Grant Fritchey,
Abstract:
One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.
Speaker(s): Joseph D'Antoni,
Abstract:
In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like "What are the typical waiting times in our order process?" are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems. In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.
Speaker(s): Kennie Pontoppidan,
Abstract:
Secure, Enable, Maintain, Sustain. In depth discussion on SSAS dynamic security and security frameworks and SSIS maintenance toolkits for the cube. Create security roles in the cube that enable the business based on underlying data patterns. Presentation covers theory and demo of roles creation in the cube, dynamic MDX security, creating SSIS roles with a toolkit based on the adventureworks db model and cube and integrated security model. Using integrated security, service accounts and data sources in the presentation layers this we walk through a security model for end-to-end security as can be implemented in sharepoint integrated solutions and/or standalone reports. This presentation provides real world application and an SSIS toolkit to take away and implement in your solutions.
Speaker(s): Daniel Lewandowski,
Abstract:
SQL Server is a high performance relational engine and provides a highly scalable database platform but due to its complexity, bad programming practices, poor indexing and configuration can be prone to serious concurrency problems, unexpected behaviors, lost updates and much more! In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. Now in SQL Server 2012 and SQL 2014 even more have followed including latch free data-structures, but many challenges and problems still remain. Let’s take a long look into the world of SQL Server concurrency and investigate Pessimistic and Optimistic isolation understanding how they work, when you should use them, and more importantly when they can go very wrong. Don't be staring down the wrong end of SQL Server's two Smoking Barrels and join me for this revealing and thought provoking presentation.
Speaker(s): Mark Broadbent,
Abstract:
SQL Server 2005 made much of information necessary for performance available through easily accessible DMVs. Ad-hoc performance tuning is possible simply with direct queries to the DMVs. Many database today actually show signs of having too many indexes. A degree of index consolidation is possible by visual examination. A more ambitious objective is to build a set of good indexes with no more indexes than necessary. To do this, it is necessary to catalog the index usage of hundreds if not thousands of SQL statements. Impossible or impractical? This can be done by automating execution plan analysis using ExecStats (free on QDPMA.com)
Speaker(s): Joe Chang,
Abstract:
Microsoft has clearly positioned the Entity Framework 6 (EF) as the primary data access platform for .NET applications. But many developers have yet to embrace the powerful Object Relational Mapping (ORM) capabilities that EF offers. Whether you’re new to ORM, or you’ve dabbled in other ORM technologies, Lenni will show how quickly you can start working with EF6 and boost your productivity when building data-centric .NET applications. We’ll begin with a quick introduction to ORM and EF, and then explain many of the special ORM features in EF6, such as the Entity Data Model, and table splitting, inheritance, entity splitting, and many-to-many relationships. With the basics covered, Lenni will then dive right into live demos that show what EF can do for you as a data access layer, using database-first, model-first, and code-first approaches with both direct SQL and stored procedures. We’ll also discuss new features introduced in EF6, and show how to use EF in N-Tier scenarios.
Speaker(s): Leonard Lobel,
Abstract:
n this session, I propose to share some of the tricks I've used on the operational side of being a DBA. There's saying, never perform small miracles, people to rely on them, but isn't it useful to have a few in your back-pocket. Everyone knows log-shipping is great for DR recovery, but what about using it for minor issues, like a delete or update gone bad? Want to move a large table someplace else (like that "oh it'll just be a small audit table, it won't grow large because we'll write the functionality later to keep it small" and they never do? UNC backups... an often overlooked but useful option for making a backup AND getting it off your server. Run a small operation where too many fingers have access to the operational DB and you want to catch them? These are some of the tricks I've picked up over the years and used more than once to perform small miracles and have saved my bacon or the bacon of others
Speaker(s): Greg Moore,
Abstract:
By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask. Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts This session will show you how : • Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account. • Create a storage account and container for the HDInsight Cluster. • Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly. • The HDInsight cluster is provisioned and configured for access to the sample data. • A partitioned Hive table is created over top of the sample data • Exploration of the result • And how to automate these task either in Powershell or SSIS.
Speaker(s): Kenneth Nielsen,
Abstract:
You're either an Accidental DBA, or someone who has inherited the awesome responsibility of the companies SQL Server databases. Until now, you knew enough to be dangerous, but now you are THE DBA. You stepped forward, volunteered, or were just drafted, and you're a bit nervous on what to do first how to manage X number of servers. Peformance tuning, security, upgrades, migrations, oh my! This session will share experiences from the frontlines, and better organize your DBA day. Things you should do NOW, and other things you need to think about down the road. This is more a professional development on being the best DBA you can be, and how to excel in your role. Remember you are the guardian of the company's data, now find out what to do with it! War stories, tasks, tools, and checklists will arm you with what you may face from your peers. You will come out of this ready for action and on you're way to being a DBA superstar!
Speaker(s): Robert Pearl,
Abstract:
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!
Speaker(s): Leonard Lobel,
Abstract:
A data flow task moves data from point A to point B, but how does it work behind the scenes? Understanding the internals of data flow engine can help you make correct package design choices in the first place and identify issues when your data loads run forever. Using simple analogies, you'll see how data flow engine moves data through each component, uses buffers, builds execution trees, and transforms data in the pipeline. Along the way, you'll learn corresponding options and tips that make your packages run as fast as possible. This demo-filled session is for SSIS developers who're comfortable with creating packages but not so comfortable figuring out why data flow is slow and when or how to parallelize the data flows. Open the hood, you need to know how data flow engine works to make it work for you in an efficient and optimal way.
Speaker(s): Samuel Vanga,
Abstract:
You have seen glimpses of the new Power BI platform during the Public Preview reveal. Although it may not be readily apparent, Microsoft has totally reimagined the Power BI platform and user experience for BI professionals, developers and business users. In this new release, Microsoft has added Power BI Designer, developer APIs, custom templates/apps, hybrid direct connectivity to on-premise data sources without data copying, a native mobile BI app and other top secret enhancements that we can dive into by the time of this session. Please join me to further explore all these great changes and enjoy a fun demo-intensive session.
Speaker(s): Jen Underwood,
Abstract:
SQL Server 2014 will have a number of new features to help with specific situations in OLTP and OLAP queries. In-Memory tables and queries, SSD Buffer Pool, Columnstore Indexing, and AlwaysOn Improvements will be covered
Speaker(s): George Walters,
Abstract:
In this demo-heavy session we will take a look at the SQL Server auditing capabilities of Azure-based resources and on-premises resources. We will discuss and demonstrate the basics of SQL Azure Database Audit, how configure it, and how to review and analyze the audit findings generated from SQL Azure Database Audit. We will also discuss and demonstrate the basics of using the SQL Server 2014 Audit feature on-premises and for SQL Server IaaS resources in Azure. We will also discuss best-practices and real-world considerations for both the SQL Azure Database Audit and the SQL Server Audit Feature.
Speaker(s): Timothy McAliley,
Abstract:
In 2005, Linus Torvalds developed a version control system (VCS) called git. Since then, it has become as platform agnostic and ubiquitous as the internet. In that same note, github, the most popular service for hosting git repositories has become so ubiquitous that Microsoft chose to host the source code for its OSS fork of the .NET framework there instead of its own codeplex. What does this mean to a DBA? Well. whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS. In my session. We will cover: What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github? We will be covering using git from both the command line and Vis
Speaker(s): Justin Dearing,
Abstract:
Dynamic SQL can be a powerful tool that allows you to write fast efficient queries when the specifics may not be known until run-time. It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you'll ever see. Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
Speaker(s): Edward Pollack,
Abstract:
Columnstore indexes were introduced in SQL Server 2012 and completely change the way in which we can store and process data using the new columnar format. With SQL Server 2014 and Azure SQL expanding the use of these indexes, it's important to keep in mind the best practices to get the most benefit out of this technology. In this session we will do a quick intro to columnstores and immediately dive into demos on how to load data, modify the index and write queries. All using the best practices to leverage the maximum benefits from these indexes.
Speaker(s): Warner Chaves,
Abstract:
Most data warehouses are scheduled to update periodically, such as once nightly. Others need to be refreshed in real-time, providing business users with up to the minute reports and analytics. This session will review the architecture required to construct a dimensional data warehouse, source it with real-time ETL using Change Data Capture (CDC), and query it efficiently from various reporting tools. It will cover advanced topics such as managing concurrent reads/writes using RCSI, storing real-time aggregates using indexed views, avoiding deadlocks using application locking, and other real-world construction/tuning/maintenance issues inherent in a real-time system.
Speaker(s): Mark Murphy,
Abstract:
When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.
Speaker(s): Bradley Ball,
Abstract:
Many database developers sooner or later need to consume from or feed data to an accounting application such as the General Ledger. Not being trained as bookkeepers, we may find bookkeeping conventions confusing at best and mystical at worst. When is a credit negative, and a debit positive ? The subject also has a reputation for being dull. But not really understanding the concepts and semantics seriously impedes unit testing, effective communication with the business, and excessive dependence on business analysts as intermediaries. We can do better ! This session will focus on demystifying the concepts and terms, facilitating further study if you are so inclined, and enabling you to understand the requirements and be proactive in testing. The session will conclude with a brief demo showing how SQL Server's Analysis Services directly supports some bookkeeping concepts.
Speaker(s): Mark Frawley,
Abstract:
With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.
Speaker(s): Konstantin Melamud,
Abstract:
The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.
Speaker(s): Alex Grinberg,
Abstract:
In this session. We will discuss and review the top ten most common SQL system outages I've experienced in the last 5 years as a production troubleshooter working with the nations largest law firms and consulting firms. We will discuss the causes, prevention, rapid diagnosis, monitoring techniques, and the fastest fixes for each. You are troubleshooting a production system and you need tactics and tools.
Speaker(s): Scott Ellis,
Abstract:
This session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for certification.
Speaker(s): John Deardurff,
Abstract:
After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160; We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.
Speaker(s): Chris Shaw,
Abstract:
Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in VR. We will follow a query from beginning to end and "runthrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
Speaker(s): Todd Kleinhans,
Abstract:
Congratulations. You've setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.
Speaker(s): Josh Luedeman,
Abstract:
This presentation is a journey through some of the common challenges facing DBAs and SSIS developers: scaling up and/or out to increase throughput, load balancing, recoverability and restartability, basic process auditing, multiple job dependency checking. Next we will review the essential elements to building a framework based on the work pile design pattern that will help resolve many of the issues these challenges may bring. The end goal is a framework that will manage a set of jobs that can recover from common errors, be spread across multiple servers, check load consistency and make sure that nothing runs unless the appropriate upstream data is available.
Speaker(s): Daniel Bowlin,
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker(s): Jason Horner,
Abstract:
Scott Ellis discusses big data, e-discovery, entrepreneurship, SQL, and the importance of culture to growth, sustainability, and healthy competition on a field of big players.
Speaker(s): Scott Ellis,
Abstract:
Tired of watching progress bars and waiting for servers to reboot while you follow run books on how to install SQL Server. This session teaches you how to automate the whole process of installing a Windows Server (Core Installation), Install SQL Server, setup Clustering and configure an AlwaysOn availability groups. The whole process is presented as a live demo
Speaker(s): Thomas Grohser,
Abstract:
Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head. Contemporary IT environments should standardize their architecture including a tier of flash. Virtualized or non-virtualized, standardizing on in-server flash is vital for optimizing performance, scalability, efficiency (technical and cost), reliability, availability. Learn how flash flips the /faster bit the significant impact flash makes not just in terms of performance, but also best practices, the massive savings in licensing driven by consolidation on flash.
Speaker(s): J May,
Abstract:
A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given.
Speaker(s): Michael Corey,
Abstract:
Perfmon is a standard windows monitoring tool available on every windows deployment. It can provide a wealth of information about the activities within your system. We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis. This session will have a strong component of demos.
Speaker(s): Rick Heiges,
Abstract:
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
Speaker(s): Aaron Bertrand,
Abstract:
Clustering SQL Server still vexes many in one way or another. For some, it is even worse now that both AlwaysOn features - clustered instances (FCIs) and availability groups (AGs) - require an underlying Windows Server failover cluster. Storage, networking, Active Directory quorum, and more are topics that come up quite often. Learn from one of the world's experts on clustering SQL Server some the most important items - both good and bad - that you need to do to be successful whether you are creating an FCI, AG, or combining both together in one solution.
Speaker(s): Allan Hirt,
Abstract:
In this session, we will focus on how to formulate a Master Data Management strategy and build a solution to find the single version of the truth, aka the Golden Record. We will demonstrate building a sample customer domain in this session, showing how to use various tools including MDS for data quality, matching, and deduplication across multiple data sources.
Speaker(s): Dennis Messina,
Abstract:
SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, hierarchies, versioning, and Excel Integration. Profisee Maestro slashes your time to deployment on MDS by providing an alternate interface for data stewards and application owners. Maestro adds data modeling, and data stewardship capabilities to simplify getting master data in the hands of your users. Maestro also adds data quality, address correction, matching, workflow, CRM integration and an SDK. Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.
Speaker(s): Dennis Messina,
Abstract:
Being able to accomodate the most demanding requirements on security is more important now than ever. This session will take you through a variety of approaches on how to implement basic to complex security on dimensions in SSAS. A quick intro through the GUI will bring us to AMO through PowerShell as the weapon of choice. Different concepts on hierarchy security models will also be demonstrated.
Speaker(s): Jens Vestergaard,
Abstract:
We will start with basic reporting services report and work up to intermediate level. If time allows, we will cover some advance feature. We will also cover some "Gotchas" as we move along. The session will be heavily demo based.
Speaker(s): Ravi Kumar,
Abstract:
In this deep dive Cluster MVP Dave Bermingham will take a look at cluster quorum options and how they have evolved over the years. Starting with Disk only quorums and ending with Cloud Witness, by the end of this session you should understand this most commonly misunderstood cluster concept and be ready to tackle your next AlwaysOn Availability Groups deployment or AlwaysOn Failover Cluster Instance implementation. Multisite and SANLess clusters will be discussed as well as the implications of Dynamic Quorum and Dynamic Witness.
Speaker(s): David Bermingham,
Abstract:
As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.
Speaker(s): Wes Springob,
Abstract:
It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable. In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.
Speaker(s): Sebastian Meine,
Abstract:
In this session we are going to focus on the interaction between SSDT and Team Foundation Server. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution.
Speaker(s): Regis Baccaro,
Abstract:
There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker(s): William Wolf,
Abstract:
In this session, I will be talking about performance turning, index design, statistics, query optimizer, parameter sniffing, data types, analyzing and understanding execution plans, wait stats, activity monitor, DMV(s). After this session you should be able to quickly identify the top performance issues of your databases.
Speaker(s): Jean Joseph,
Abstract:
Do you know what Extended Properties are? Do you use Extended Properties for your database objects? Do you know how to simplify the process of setting Extended Properties for automated Documenting of your Database? If any of your answers is "NO" then you have to attend this session.
Speaker(s): Slava Murygin,
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
Speaker(s): Randy Knight,
Abstract:
You just found out that a client needs a SQL database to be designed from scratch. However, your existing DBA has given two weeks notice. This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up. Topics are focused on data storage structures, security, and integrity. After this presentation, you will be ready to meet that clients need.
Speaker(s): John Miner,
Abstract:
How can we use data to predict the future? In this session we'll explore dichotomous outcome prediction models using Azure Machine Learning. We'll use Azure Machine Learning to format and cleanse data with native modules and R, train learning algorithms, optimize parameters, and compare different models. Along the way we'll cover some of the key differences in feature selection and how to interpret the results.
Speaker(s): Kevin Feit,
Abstract:
Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha's, and performance tuning and troubleshooting techniques.
Speaker(s): Hilary Cotter,
Abstract:
You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
Speaker(s): Amy Herold,
Abstract:
As DBAs there are many tasks we’re asked to do every day that we just accept as taking a long time because of some manual component we can’t get around. Many of these tasks can be brought into line with regex. You can use it to format your own T-SQL and create code that writes code with relative ease. I’m going to teach you the basics of regex and show you how to perform many tasks that’ll make your life much easier like deploying code, formatting T-SQL, and much more.
Speaker(s): Sean McCown,
Abstract:
The Azure Data Factory was introduced at the end of 2014. Data Factory is a cloud scalable data movement and transformation tool. Data Factory is not SQL Server Integration Services and will require some different skills to master. In this session, we will learn how to create a data factory to copy data from an Azure Blob to a SQL database. After working through that solution, we will look at how to use the Data Factory with HDInsight on Azure and Machine Learning activities. Throughout the session, we will look at managing the Data Factory in the Azure portal.
Speaker(s): Steve Hughes,
Abstract:
SQL 2016 CTP2 is out now. What do you get? Mission Critical Performance, Advanced Analytics, Extend from on-premises to Hyper scale Cloud. SQL 2016 On-Premises GIVES YOU THIS! Come learn about the new features, that you can use today!
Speaker(s): George Walters,
Abstract:
With the rapid advance in analytic features and the increased capabilities to produce more informative reports, SQL Server 2014 opens a plethora of new and exciting opportunities. In the hands-on presentation we shall be constructing a few simple analytic reports (from background financial data). More importantly we shall see how our conclusions help us target new prospective business opportunities.
Speaker(s): Steve Simon,
Abstract:
You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
Speaker(s): Jennifer McCown,
Abstract:
On this session we are going to cover, how to create ETL frameworks by using existing metadata to generate SSIS packages at run-time using C# code. Expand the potential of Integration Services, create your own custom components, and enforce standards across your organization.
Speaker(s): Jorge Novo,
Abstract:
Automation is a key part to becoming a great DBA. Without automation a DBA can start to drown in a sea of repeating tasks. The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water. In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks. In addition we will look into how to monitor the jobs and alerts created. Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.
Speaker(s): Lance Tidwell,
Abstract:
Do you have questions about your SQL Server installation? Want to know what a PAGEIOLATCH_EX means? Come along and ask your questions. This is a QA session, we're not going to solve your SQL dumps, but the limit to the questions is the time we have and the areas we cover.
Speaker(s): Simon Facer,
Abstract:
Explore some of the mistakes and misconceptions DBAs tend to have about SSIS. Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.
Speaker(s): Paul Rizza,
Abstract:
You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet. We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.
Speaker(s): Kennie Pontoppidan,
Abstract:
That's right, attendees choose! I'll show 30 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 30 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:
This session will go well beyond creating SSAS cubes with the cube wizard. I'll cover topics such as the pros and cons of ROLAP, XMLA Processing options, Many to Many Bridge Tables and the use of the DefaultMember and IsAggregatable properties, SSAS Report Actions, Dynamic SSAS Roles with custom MDX code, Advanced MDX in SSRS, Partitioning and Aggregations, Data Driven KPIs, and Dimension Attribute Discretization.
Speaker(s): Kevin Goff,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/kennie
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
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: https://www.linkedin.com/in/gregdmoore
Contact: https://blog.greenms.com
Greg Moore is a graduate of RPI. There, he majored in CompSci, but probably spent as much time hiking, canoeing, caving and rock-climbing as he did studying. He started working with SQL Server 4.21a in 1995 and has survived numerous upgrades. He's been a Director and later VP of IT at several startups including PowerOne Media, TownNews and Traffiq and now consults. These days, when he's not busy with playing with SQL Server or spending time with his family, he can often be found underground caving or teaching cave rescue with the NCRC. While his focus is on the operations side of DBA, his interests include DR, performance and general IT problem solving. He is the author of: IT Disaster Response: Lessons Learned in the Field.
LinkedIn: https://www.linkedin.com/in/thomasgrohser/
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
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.
LinkedIn: https://www.linkedin.com/in/alex-grinberg-36773a6/
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
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.
LinkedIn: http://www.linkedin.com/in/JohnDeardurff
Contact: https://www.sqlmct.com
John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.
LinkedIn: https://www.linkedin.com/profile/view?id=33119347amp;trk=hp-identity-name
Contact: http://www.danielbowlin.com/
I am a data integration developer at Time Warner Cable. I have been working with SQL Server technologies since the late 90s. About 6 years ago I specialized in the SQL Server BI stack. Lately I have been almost exclusively working in SSIS.
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.
I have over 12 years of experience working with SQL Server and Business Intelligence Technology. My current focus is cloud technologies: Power BI, Azure Analysis Services, Azure SQL Data Warehouse, Azure Data Factory. As a PFE at Microsoft, I regularly deliver 2 - 4 day training workshops.
LinkedIn: http://www.linkedin.com/in/scarydba
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
LinkedIn: http://www.linkedin.com/in/aherold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
LinkedIn: http://www.linkedin.com/in/aspiringgeek
Contact: http://blogs.msdn.com/jimmymay
Jimmy May is a Microsoft Certified Master (MCM). He's formerly a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, most interesting SQL Server apps from all over the world. More recently he was a SQL Server Technologist for what was Fusion-io's Data Propulsion Lab (DPL). He is a founder of the IndyPASS IWUG user groups.
LinkedIn: https://www.linkedin.com/in/jenunderwood
Contact: http://www.jenunderwood.com/
Jen Underwood is a Microsoft Sr. Program Manager of Business Intelligence amp; Analytics. She works with external groups, customers, channel partners, MVPs, BI professionals and application developers to better connect the outside world to engineering. Throughout most of her ~20 year career she has been researching, designing and implementing data warehousing, business intelligence and predictive analytics solutions across a variety of open source, niche and enterprise vendor landscapes.
LinkedIn: https://www.linkedin.com/in/williamjwolf
Contact: http://www.sqlwarewolf.com
Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.
LinkedIn: http://www.linkedin.com/in/kennie
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
LinkedIn: http://www.linkedin.com/in/joshluedeman
Contact: http://www.joshluedeman.com
Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft's Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.
LinkedIn: http://www.linkedin.com/pub/rick-heiges/1/b93/777/
Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx
Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.
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.
LinkedIn: https://www.linkedin.com/in/georgewalters
Contact: https://georgewalters.wordpress.com/
Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions. A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases. Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events
LinkedIn: https://www.linkedin.com/pub/allan-hirt/1/b72/673
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
LinkedIn: http://www.linkedin.com/in/stephenrsimon/
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
LinkedIn: http://www.linkedin.com/in/jasonhorner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I'm a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I'm fluent in several languages including: SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years. In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
LinkedIn: https://www.linkedin.com/in/justindearingnyc
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.
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/pub/kevin-feit/8/992/837
Kevin Feit is a Solution Principal with Slalom Consulting specializing in data warehousing and ETL development. He has been working with SQL Server since 1990 and is a Microsoft Certified Professional.
LinkedIn: https://www.linkedin.com/in/georgewalters
Contact: https://georgewalters.wordpress.com/
Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions. A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases. Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events
Contact: http://www.craftydba.com
John has twenty-five years of data processing and project management experience. His expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance of systems. He is currently a Senior Consultant at Atrion Networking Corporation providing customers with Database and Business Intelligence solutions. When he is not busy at PASS events, he spends time with his wife and daughter enjoying outdoor activities.
Contact: http://sqlblog.com/blogs/joe_chang/default.aspx
Contact: https://blogs.sentryone.com/author/AaronBertrand
Aaron, Product Manager at SentryOne, produces performance and optimization tools for the entire Microsoft data platform, as well as Plan Explorer, a free tool for SQL Server execution plan analysis. In his spare time, he is either playing volleyball, curling, blogging at sqlperformance.com and blogs.sentryone.com, or contributing to SQL Server conversations on Twitter and dba.stackexchange.com. He has worked with SQL Server since 6.5 and has been an MVP since 1997.
Contact: http://www.tallan.com
Mark Frawley has worked for 20 years developing data warehouses on a variety of RDBMS platforms, 12 of those implementing BI solutions using all the server-based components of the Microsoft BI stack - SQL Server, Analysis Services, Reporting Services and Integration Services. He specializes in covering both the technical and non-technical aspects of solutions, and enjoys sharing knowledge, especially that which transcends but relates to technology.
Hilary Cotteris a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in HA technologies, especially replication, performance tuning, full-text search, and SQL Server Service Broker. Hilary is also an author, or contributor on a number of books on SQL Server.
I've been at Microsoft over 7 years, and worked with SQL Server since it was Sybase. For the last 4 years I've been increasingly focused on MPP data Warehouses - APS (Analytics Platform System) and Azure SQL Data Warehouse. I handle the day-today maintenance tasks, bit the fun stuff is the Performance Tuning. MPP Data Warehousing isnt your fathers SQL Server - we are less focused on IO and Waits, and much more focused on Data Distribution and Data Movement.
LinkedIn: http://www.linkedin.com/in/JamesSerra
Contact: http://www.JamesSerra.com
James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.
LinkedIn: http://www.linkedin.com/in/scarydba
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
LinkedIn: http://www.linkedin.com/in/christophershaw/
Contact: http://chrisshaw.wordpress.com/
Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.
LinkedIn: https://uk.linkedin.com/in/retracement
Contact: http://tenbulls.co.uk
Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.
LinkedIn: http://www.linkedin.com/in/dataonwheels
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
LinkedIn: https://www.linkedin.com/in/jeandjoseph/
Contact: http://tsqlhelp.wordpress.com/
Highly experienced in Big Data and traditional data technologies with a history of successes in designing, implementing complex technical projects for diverse businesses in various stages of their development. Acknowledged as a leader capable of mentoring teams of different backgrounds and talents and inspiring individual efforts to deliver. Organized and detail-oriented, with a positive pro-active and hardworking attitude. Performance history reflects a highly analytical strategic thinker with strengths in defining solutions and executing programs that have been invaluable to an all-encompassing range of projects and positions.
LinkedIn: http://dk.linkedin.com/in/regisbaccaro
Contact: http://theblobfarm.wordpress.com
Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.
LinkedIn: http://dk.linkedin.com/in/jvestergaard
Contact: http://www.t-sql.dk
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).
LinkedIn: https://www.linkedin.com/pub/jorge-novo/1/546/b70
Contact: http://etldevelopernotes.blogspot.com/
Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes, SQL tunning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
LinkedIn: http://ca.linkedin.com/in/warnerchaves/
Contact: http://sqlturbo.com
Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.
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”.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
LinkedIn: https://www.linkedin.com/pub/slava-murygin/9/b95/858
Contact: http://slavasql.blogspot.com/
Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.
LinkedIn: https://www.linkedin.com/profile/view?id=81593638
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
LinkedIn: https://www.linkedin.com/pub/scott-r-ellis-information-technology-architect-author/4/55/144
Contact: http://Www.scorellis.com
Scott has worked with the software Relativity since early 2007 and since 2009, he has been a final point of escalation for SQL related issues. His official job title is quot;to serve as a point of escalation and solve the most heinous scalability and performance issues facing kCura clients.quot; He is an Architect on the Infrastructure Engineering team, and is the principle architect behind kCura#39;s performance dashboard QoS, he is a published author, former forensic expert, and former physicist.
LinkedIn: https://www.linkedin.com/in/sqlballs
Contact: http://www.sqlballs.com
Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG's, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
LinkedIn: https://www.linkedin.com/in/dennismessina
Contact: http://www.profisee.com
Dennis Messina is the Northeast Regional Director with Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which was sold to Microsoft in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold Partner providing solutions built on MDS and the Microsoft stack. Prior to joining Profisee, Dennis spent 10 years working as a Solution Specialist and Account Manager at Microsoft based in NYC.
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
LinkedIn: http://www.linkedin.com/in/lennilobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences. Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
LinkedIn: https://www.linkedin.com/pub/scott-r-ellis-information-technology-architect-author/4/55/144
Contact: http://Www.scorellis.com
Scott has worked with the software Relativity since early 2007 and since 2009, he has been a final point of escalation for SQL related issues. His official job title is quot;to serve as a point of escalation and solve the most heinous scalability and performance issues facing kCura clients.quot; He is an Architect on the Infrastructure Engineering team, and is the principle architect behind kCura#39;s performance dashboard QoS, he is a published author, former forensic expert, and former physicist.
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
LinkedIn: http://www.linkedin.com/pub/todd-kleinhans/0/920/981
Contact: https://toddkleinhans.wordpress.com/
Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he's mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/
Contact: http://lancetidwell.com
Lance Tidwell, from the Austin, TX, area, has worked as a SQL Server DBA for the last 11 years. During his time as a DBA he has found his passion for all things SQL, but specifically for performance tuning. He has a life-long quest to always be learning new things; currently this quest has lead him to explore more about the Data Analytics/ Data Science areas.
LinkedIn: https://www.linkedin.com/in/markmurphynyc
Contact: http://www.infinityanalytics.com
Mark Murphy is a data warehouse architect with 17 years experience designing business intelligence analytic solutions in New York City. His primary focus has been on designing and managing large scale data warehouses / OLAP solutions, primarily in SQL Server, Analysis Services and Oracle. His specialties include real time data warehousing, Kimball dimensional data modeling, ETL, performance tuning, data visualization, analytics, and machine learning.
LinkedIn: https://www.linkedin.com/in/dennismessina
Contact: http://www.profisee.com
Dennis Messina is the Northeast Regional Director with Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which was sold to Microsoft in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold Partner providing solutions built on MDS and the Microsoft stack. Prior to joining Profisee, Dennis spent 10 years working as a Solution Specialist and Account Manager at Microsoft based in NYC.
LinkedIn: http://www.linkedin.com/in/SQLWes/
Contact: http://SQLWes.com
Wes Springob is a Premier Field Engineer (PFE) at Microsoft and speaks regularly on Business Intelligence, Power BI, database and report development.
Daniel has been a college instructor and high school teacher, network engineer, and tour guide along the way to starting LewiCool Consulting. MicroSoft Business Intelligence Consultancy with BI experience in enterprise organizations spanning multi-million dollar corportations to government, telecom, banking, industrial and education. Striving to enable business with technology, with secure maintainable sustainable solutions that help the business attain success in whatever the endeavor.
LinkedIn: https://www.linkedin.com/profile/preview?vpa=pubamp;locale=en_US
Denis McDowell is a Microsoft Data Professional with over 20 years of experience with SQL Server, scripting, virtualization, IT operations, and Cloud implementations across multiple industries. He currently works as the Solutions Engineering Manager for SentryOne and owns a consulting practice in the Charlotte, NC area. Denis has been a regular presenter at local, regional, and national conferences and events, including PASS Summit, Microsoft Hosting Summit, and numerous SQLSaturday and SQL User Groups around the U.S. In his free time, Denis enjoys traveling with his family, playing and recording in his home music studio, and catering to the needs of his three dogs.
LinkedIn: http://dk.linkedin.com/in/kennethmnielsen/
Contact: http://funkylab.com
Kenneth M. Nielsen currently work at Microsoft as Data Platform Solution Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
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
LinkedIn: http://www.linkedin.com/in/lennilobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences. Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
The following is a list of sponsors that helped fund the event.