SQLSaturday #383 - Rochester 2015

Event Date: 05/16/2015 00:00:00

Event Location:

Rochester Institute of Technology
1 Lomb Memorial Drive
Rochester, New York

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: XML Without Xanax: How to Handle XML in SQL Server

Abstract: Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!

We’ll start with reasons why having XML in SQL Server might be a good thing, then we’ll face our fears and turn tabular data into XML, and finally we’ll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.

If you survive this session, you’ll have faced your fears about XML in SQL Server, you’ll have a solid understanding of creating XML from tabular data, and you’ll know how to use xQuery to parse XML.

Speaker(s):

Adam Belebczuk

Track and Room: Track 7 - Room 2400

Title: Right-Sizing Your SQL Server Virtual Machine

Abstract: Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

Speaker(s):

David Klee

Track and Room: Track 6 - Room 1610

Title: Rethink Your ETL with BIML

Abstract: It’s estimated that 70% of data warehousing development is in ETL (extract, transformation, and load) between the different source systems, your data warehouse, and/or your data mart. Recently a new tool has entered the marked that promised to revolutionize the way we think about ETL processes. Gone are the days where we need to manually code every component, every event handler, and painstakingly ensure that every package adheres to corporate standards. In this session, Chris will introduce you to the world of BIML and how it can change your world. We’ll show you how to quickly create a template in BIML that will make sure all of your packages adhere to corporate standards, and then use metadata to quickly generate dozens of packages to populate your dimensions and facts. Stop spending weeks developing SSIS packages that can be built in hours! You won’t want to miss this session!

Speaker(s):

Chris Schmidt

Track and Room: Track 4 - Room 1455

Title: Hacking Exposé - Using SSL to Protect SQL Connections

Abstract: Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data? You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries? Using a simple hacking technique we will dig into some packets on our network and see what’s in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would. *Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.

Speaker(s):

Chris Bell

Track and Room: Track 3 - Room 1445

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract: Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.

Speaker(s):

Janis Griffin

Track and Room: Track 6 - Room 1610

Title: Basic Database Design

Abstract: Abstract: You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week 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, will be ready to meet that clients need.

Coverage: 1 - Files File Groups 2 - Logins Users 3 - Security using schemas 4 - Database roles for access. 5 - Table design via SSMS or TSQL. 6 - Default, Check, and NULL constraints 7 - Handling table relationships (PK vs FK). 8 - To index or not to index? 9 - Testing database integrity using DML.

Speaker(s):

John Miner

Track and Room: Track 1 - Auditorium

Title: Software as a service

Abstract: Abstract:

Are you tired of installing, configuring and patching Microsoft SQL Server? Microsoft Azure SQL database maybe a way to move some of your infrastructure to the cloud. Depending upon your companies philosophy, it might be great for development, testing, and possibly production environments.

The exciting thing about this service is that new features will be released on this platform first before trickling down to the on-premise editions.

Coverage:

1 - The Azure Portal 2 - Identifying your database server 3 - Adding IP Rules for clients 4 - Capturing a connection string 5 - Using SSMS and/or SQLCMD for development 6 - Creating a database from TSQL 7 - Executing CRUD statements 8 - Migrating old database using wizard 9 - What SQL Azure database still lacks.

Speaker(s):

John Miner

Track and Room: Track 4 - Room 1455

Title: Transactional Replication: Architecture, Setup, and Monitoring

Abstract: At some point in every DBA’s career they’ll be probably be asked to work with transactional replication. While it may seem scary at first, it’s not that complicated once you understand how all the parts and pieces work together. In this session we’ll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly. Session Goals: • Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles. • Learn how to configure a working replication topology • Learn how to how to monitor transactional replication performance

Speaker(s):

Kendal Van Dyke

Track and Room: Track 5 - Room 1520

Title: Transactional Replication: Tuning and Troubleshooting

Abstract: At some point in every DBA’s career they’ll be probably be asked to work with transactional replication but most DBAs don’t look under the covers once they’re done walking through the setup wizards. In this session we’ll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies. Session Goals: • Learn how to baseline performance metrics by gleaning information from the distribution database • Show how to tune replication agent performance with agent profiles • Demonstrate advanced troubleshooting techniques to apply when problems occur

Speaker(s):

Kendal Van Dyke

Track and Room: Track 5 - Room 1520

Title: Possible Musics: SSAS Multidimensional vs Tabular

Abstract: The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with SSAS 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SQL Server MVP and SSAS Maestro Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing examples to illustrate approaches for given scenarios.

Speaker(s):

William E Pearson III

Track and Room: Track 2 - N/A

Title: Getting Started with MDX

Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.

Speaker(s):

William E Pearson III

Track and Room: Track 7 - Room 2400

Title: SQL Server 2014 New Features

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

Track and Room: Track 1 - Auditorium

Title: The Quest for the Golden Record: MDM Best Practices

Abstract: In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.

Speaker(s):

Brian Benzel

Track and Room: Track 4 - Room 1455

Title: Introduction to Window Functions

Abstract: SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

Speaker(s):

Kathi Kellenberger

Track and Room: Track 2 - Room 1435

Title: The usual SUSPECTs: When good databases go bad.

Abstract: You just restarted SQL Server, but some of your databases aren’t coming online. Maybe you see a database marked SUSPECT, or RECOVERY PENDING. What do you do? In this session we’ll cover the various states that a database can be in, how they get into those states, and learn the proper techniques to bring your data safely back online.

Speaker(s):

David Maxwell

Track and Room: Track 3 - Room 1445

Title: The Many Paths of Consulting

Abstract: People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.

This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.

Speaker(s):

David Klee

Track and Room: Track 6 - Room 1610

Title: What exactly is big data and why should I care?

Abstract: You may understand what a data warehouse is, but what is big data? And why should I care about it? How will it help me? I’ll talk about the things to look at to understand if you have big data, and cover those buzz words you may have heard but don’t know what they mean (data scientist, Hadoop, Internet of Things, data lake, modern data warehouse). I’ll also give examples of how big data is making companies make better business decisions.

Speaker(s):

James Serra

Track and Room: Track 7 - Room 2400

Title: Query Tuning - Get it Right the First Time

Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

Speaker(s):

Janis Griffin

Track and Room: Track 6 - Room 1610

Title: DBA 911 - Database Corruption

Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.

Speaker(s):

David Maxwell

Track and Room: Track 3 - Room 1445

Title: How does Microsoft solve Big Data?

Abstract: So you got a handle on what Big Data is and how you can use it to find business value in your data. Now you need an understanding of the Microsoft products that can be used to create a Big Data solution. Microsoft has many pieces of the puzzle and in this presentation I will show how they fit together. How does Microsoft enhance and add value to Big Data? From collecting data, transforming it, storing it, to visualizing it, I will show you Microsoft’s solutions for every step of the way.

Speaker(s):

James Serra

Track and Room: Track 7 - Room 2400

Title: Enterprise-level auditing on a Standard Edition budget

Abstract: In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what’s going on in your databases. Unfortunately, that’s an Enterprise Edition feature. What about those of us running Standard Edition? In this demo-heavy session, we’ll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, extended events, and even SQL Audit.

Speaker(s):

Colleen Morrow

Track and Room: Track 5 - Room 1520

Title: T-SQL Window Function Performance

Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

Speaker(s):

Kathi Kellenberger

Track and Room: Track 2 - Room 1435

Title: Availability Groups 101: An Introduction

Abstract: One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we’ll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.

Speaker(s):

Adam Belebczuk

Track and Room: Track 7 - Room 2400

Title: So you want to be a Database Administrator…

Abstract: In 2014, CareerBliss.com and Forbes Magazine ranked Database Administrator as the #1 happiest job. But what exactly does a DBA do? How does someone become a DBA? And why are they so darned happy? In this session we’ll explore the different types of DBA, their roles and responsibilities, and the career path for database professionals. Whether you’re just starting your career and trying to find your footing, or you’re a seasoned veteran wondering where to go from here, this session will show you the possibilities.

Speaker(s):

Colleen Morrow

Track and Room: Track 5 - Room 1520

Title: Query Optimization Crash Course

Abstract: Do you have users complaining that applications are running “too slow”? Do your DB traces look like a short story written by monkeys at typewriters? This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We’ll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!

Speaker(s):

Edward Pollack

Track and Room: Track 1 - Auditorium

Title: Boosting DWH-Performance with SQL Server 2014

Abstract: SQL Server 2014 is all about in-memory. Not that previous versions did not hold as much as data as possible inside of memory through caching, but now we enter a new era: columnar storage, in-memory tables and compiled stored procedures are different from what we have seen so far. In this session, you will see how you can leverage those new features and how you can come by existing limitations. Come back to office with the knowledge how to boost the performance of your ETL, queries and reports into the new era.

Speaker(s):

Markus Ehrenmueller-Jensen

Track and Room: Track 2 - Room 1435

Title: Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools

Abstract: Join Thomas in an almost Powerpoint free session where he shows how to write a reusable code library using TSQL, stored procedures, tables and functions and shows how to integrate it into multiple database projects with a few mouse clicks. He will also share Tips and Tricks for using Visual Studio more effective.

Speaker(s):

Thomas Grohser

Track and Room: Track 2 - Room 1435

Title: The BI Power Hour

Abstract: Imagine a world in that end-user can collect data from your data warehouse, from operational databases, flat files, excel files and even external data sources like a web page or a data market. Imagine that those users can cleanse the data by themselves, manage calculations, and refresh the data through a tool they are already familiar with. Imagine that they also can build nice and crisp interactive reports (tables, charts maps) by just a few mouse clicks or by natural language.

Speaker(s):

Markus Ehrenmueller-Jensen

Track and Room: Track 2 - Room 1435

Title: SQL Server Storage Engine under the hood

Abstract: How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What’s done asynchronous and what’s synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what’s different when SQL Server is starting up. Which I/O Subsystems (including SSD) are best for which type of data and what’s the impact if you choose a different one. Which files can be placed on the same volume and which should not.

Speaker(s):

Thomas Grohser

Track and Room: Track 2 - Room 1435

Title: (a Few of) My Favorite DMVs

Abstract: Dynamic Management Views are a beautiful gift from Microsoft. With them you can gather immense amounts of information about your SQL environment, optimize performance issues, and solve problems you didn’t even know you had! We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.

Speaker(s):

Edward Pollack

Track and Room: Track 7 - Room 2400

Title: Getting started with SSIS

Abstract: Integration services is a powerful tool for visualizing and handling most of your SQL Server ETL needs. But Business Intelligence Development Studio (BIDS) can be a confusing tool the first time that you start the application. There’s a LOT going on, and for the first time developer, it’s not very clear how to get started. This session will help get you on your feet developing SSIS packages. We will look at some common scenarios and live demo creating your first SSIS packages to copy data from one server to another, extract data to a flat file, and learn how to solve some common errors. Feel free to bring your questions on getting started with BIDS.

Speaker(s):

Matt Nelson

Track and Room: Track 1 - Auditorium

Title: The Use Cases for In-Memory OLTP

Abstract: In this session, we will do a short introduction to the In-Memory OLTP feature before diving straight into the use cases where the new lockless/latchless concurrency control and native compilation really shines. Demos will cover PAGELATCH contention, use of In-Memory for ETL and In-Memory tables as ‘shock absorbers’ for high throughput environments. For each case we will do a comparison of “Classic” vrs In-Memory, what gains can the audience expect and what patterns will yield the biggest benefits.

Speaker(s):

Warner Chaves

Track and Room: Track 3 - Room 1445

Title: SQL Server AlwaysOn Availability Groups

Abstract: Need HA and DR? Tired of Mirroring or Log Shipping restrictions? Reporting queries slowing down your production system? The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution, which is an enterprise-level alternative to database mirroring. How, and why to use this will be covered.

Speaker(s):

George Walters

Track and Room: Track 2 - Room 1435

Title: Easing Into Scripting with Windows PowerShell

Abstract: You’ve been hearing about Windows PowerShell, but you’re wondering if it’s something you should be working with. Or maybe you’re just looking for a way to make those boring, repetetive chores take care of themselves. In this introductory session, we’ll talk about what PowerShell is, how to use it, and where it’s going. Whether you’re a junior DBA or seasoned veteran, you’ll find ways that PowerShell can make your life easier.

Speaker(s):

Andy Levy

Track and Room: Track 2 - Room 1435

Title: Troubleshoot SQL Server Performance Issues using Wait Statistics

Abstract: Have you ever scratched your head trying to figure out what is causing performance issues in your SQL Server databases? In this session, we will look at uncovering your SQL Server’s performance issues by learning about wait statistics. We will look at SQL Server wait statistics and how we can troubleshoot performance problems using this methodology – from finding the root cause to resolving the issues.

Speaker(s):

Edwin M Sarmiento

Track and Room: Track 6 - Room 1610

Title: Level Up: Understanding Azure’s SQL Database Service Tiers

Abstract: As part of Microsoft’s aggressive cloud strategy, the SQL Database as a service has been getting new releases and new features at a rapid pace.

The biggest change so far has been the introduction of three service tiers: Basic, Standard and Premium.

Gone is the pay for database size system and it has been replaced by a system where we also pay for the performance characteristics and recovery features of our database.

Come learn the differences between the tiers, measuring performance and how to optimize the use of your cloud SQL power.

Speaker(s):

Warner Chaves

Track and Room: Track 3 - Room 1445

Title: APPLY Yourself

Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

Speaker(s):

Kevin Feasel

Track and Room: Track 5 - Room 1520

Title: The Spy Who Loathed Me - An Intro to SQL Security

Abstract: You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.

Speaker(s):

Chris Bell

Track and Room: Track 1 - Auditorium

Title: Much Ado About Hadoop

Abstract: Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

Speaker(s):

Kevin Feasel

Track and Room: Track 5 - Room 1520

Title: SQL Server and Networking High Availability/Disaster Recovery Best Practices

Abstract: Do you think you can handle Failover Clustering and Availability Groups? Think again. Your job description as a SQL Server DBA has just changed. In this demo-centric session, you’ll see how networking aspects such as Active Directory and DNS play very important roles when implementing a SQL Server high availability and disaster recovery (HA/DR) solution. You will want to be confident enough to have a conversation with your Domain Administrator to make sure your SQL Server databases meet their recovery objectives and service level agreements.

Speaker(s):

Edwin M Sarmiento

Track and Room: Track 6 - Room 1610

Title: Fixing Page Life Expectancy

Abstract: Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.

Speaker(s):

Steve Hood

Track and Room: Track 4 - Room 1455

Title: Building dynamic SSIS packages for more flexibility

Abstract: After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with today’s date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.

Speaker(s):

Matt Nelson

Track and Room: Track 4 - Room 1455

Title: Advanced Troubleshooting Your SQL Connections

Abstract: Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect. It becomes more challenging when we find nothing is wrong with the way SQL Server is running. In this session we review common mistakes to the configuration of network settings. We’ll also show how to troubleshoot the SQL Server Browser. We’ll cover how to test for firewall issues. Finally we’ll discuss why SQL Server is blamed for dropping its connections.

Speaker(s):

Mike Hays

Track and Room: Track 4 - Room 1455

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Matt Slocum

Twitter: - SQLMatt

LinkedIn: Matt Slocum

Contact: http://www.sqlmatt.com

Husband, Father, and certifiable…I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting.
I also love space, technology Japanese culture.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

SIOS Technology

Twitter: - @SIOSTech

LinkedIn: SIOS Technology

Contact: http://us.sios.com/blog/

SIOS Technology Corp. makes software products that protect data and applications from downtime, while eliminating complexity, and reducing labor costs. SIOS products make clusters in both SAN and #SANLess environments easy to use and easy to own. By removing the configuration limitations of traditional clusters, SIOS products give enterprise data managers the freedom to run applications in the environment that best meets their needs – physical, virtual, cloud or any combination thereof.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

George Walters

Twitter: - https://twitter.com/geo_walters

LinkedIn: George Walters

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

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

Steve Hood

Twitter: - @SteveHoodSQL

LinkedIn: Steve Hood

Contact: http://simplesqlserver.com

I#39;m a DBA who has gone through most of my career with few people to learn and unsure of where to find great help until I found a real mentor. When I started at a company with a great, knowledgeable manager and learned to find others speaking about SQL Server online my skills boomed. This is especially true in my most passionate area, SQL Server performance.

Knowing that my knowledge came from others, I now have a second passion of sharing my knowledge with others.

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

Kimberly StJacques

Twitter: - @kimstjacques

LinkedIn: Kimberly StJacques

Contact: http://dbobserver.com

Kim StJacques is passionate about SQL Server and Community. She has worked in IT for 20+ years and 15 of those years working with SQL Server. Kim’s experience as a DBA spans multiple database platforms, however, SQL Server is her passion. Kim is also an avid volunteer in the SQL Server community! She has served as a SQLSaturday organizer/volunteer/speaker, PASS Summit Program Committee, PASS Summit Ambassador, and PASS Summit buddy for first timers. As a recent empty nester, Kim has developed a thirst for learning new things such as Ansible and Docker, however, she still finds time for a few Overwatch matches and a splash of Netflix.

Matt Slocum

Twitter: - SQLMatt

LinkedIn: Matt Slocum

Contact: http://www.sqlmatt.com

John Miner

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.

Thomas Grohser

LinkedIn: Thomas Grohser

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.

Matt Slocum

Twitter: - SQLMatt

LinkedIn: Matt Slocum

Contact: http://www.sqlmatt.com

Matt Nelson

Twitter: - http://twitter.com/mattpgh

LinkedIn: Matt Nelson

Contact: http://wwww.nelsonsweb.net

Matt Nelson is a Database Administrator and Business Intelligence developer for RDX (Remote DBA Experts) in Pittsburgh, PA. With over 10 years of experience, He works with more than 200 clients on general database administration needs and BI projects. Matt is also the Chapter Leader of the Pittsburgh SQL Server Users Group, and an organizer of Pittsburgh SQLSaturday. He occasionally blogs at www.nelsonsweb.net and http://www.rdx.com/Blog/

Warner Chaves

Twitter: - @warchav

LinkedIn: Warner Chaves

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.

Matt Slocum

Twitter: - SQLMatt

LinkedIn: Matt Slocum

Contact: http://www.sqlmatt.com

John Miner

Twitter: - https://twitter.com/JohnMiner3

LinkedIn: John Miner

Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/

John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.

He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.

He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.

Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.

Thomas Grohser

LinkedIn: Thomas Grohser

Matt Slocum

Twitter: - SQLMatt

LinkedIn: Matt Slocum

Contact: http://www.sqlmatt.com

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

George Walters

Twitter: - https://twitter.com/geo_walters

LinkedIn: George Walters

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.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

Matt Nelson

Twitter: - http://twitter.com/mattpgh

LinkedIn: Matt Nelson

Contact: http://wwww.nelsonsweb.net

Warner Chaves

Twitter: - @warchav

LinkedIn: Warner Chaves

Contact: http://sqlturbo.com

Edward Pollack

Twitter: - EdwardPollack

LinkedIn: Edward Pollack

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.

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

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.

James Serra

Twitter: - www.twitter.com/JamesSerra

LinkedIn: James Serra

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”.

Markus Ehrenmueller-Jensen

Twitter: - MEhrenmueller

LinkedIn: Markus Ehrenmueller-Jensen

Contact: http://www.savorydata.com

Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Edwin M Sarmiento

Twitter: - EdwinMSarmiento

LinkedIn: Edwin M Sarmiento

Contact: http://www.EdwinMSarmiento.com

Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

James Serra

Twitter: - www.twitter.com/JamesSerra

LinkedIn: James Serra

Contact: http://www.JamesSerra.com

Markus Ehrenmueller-Jensen

Twitter: - MEhrenmueller

LinkedIn: Markus Ehrenmueller-Jensen

Contact: http://www.savorydata.com

Edwin M Sarmiento

Twitter: - EdwinMSarmiento

LinkedIn: Edwin M Sarmiento

Contact: http://www.EdwinMSarmiento.com

Andy Levy

Twitter: - ALevyInROC

LinkedIn: Andy Levy

Contact: https://flxsql.com

Andy is a database administrator, PowerShell fan, former developer, Open Source contributor, SQLSaturday organizer and user group leader. He’s worn a number of IT hats since 1999 before landing in database administration, including web server administration and development, systems integration, and database development. When he isn’t picking queries apart and wrangling an unruly herd of databases, he can be found helping out with his son’s Boy Scout troop, making BBQ ribs for his daughter, or planning the next family vacation with his wife.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Mike Hays

LinkedIn: Mike Hays

Contact: http://www.thesqlreport.com/

Mike has been working with Microsoft SQL Server for the last twenty years. Currently working as a Database Administrator for a diversified energy company, he has also worked in the retail, manufacturing, banking sectors. He holds a Master’s degree in Computer Information Science from Cleveland State University. He currently resides in Ohio with his girlfriend Alexia, her two children and their dog Lanna.

Adam Belebczuk

Twitter: - @SQLDiablo

LinkedIn: Adam Belebczuk

Contact: http://www.sqldiablo.com/

Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.

Brian Benzel

Brian is Regional Sales Director responsible for driving sales and onboarding new customers in PA, NJ, NY, DE, MD, and DC for Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which Microsoft acquired in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold ISV Partner providing solutions built on MDS. Brian was formerly with Microsoft Corporation as a Senior Account Manager for 7 years.

Chris Schmidt

Twitter: - @sqlbischmidt

LinkedIn: Chris Schmidt

Contact: http://intelligentsql.wordpress.com/

Chris Schmidt is a data architect with Centric Consulting and has experience designing business intelligence solutions for a wide variety of companies in multiple industries. He is very passionate about the entire Microsoft BI stack, with a special emphasis on SSIS and SSAS.

Colleen Morrow

Twitter: - @ClevelandDBA

LinkedIn: Colleen Morrow

Contact: http://colleenmorrow.com

Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Colleen Morrow

Twitter: - @ClevelandDBA

LinkedIn: Colleen Morrow

Contact: http://colleenmorrow.com

Edward Pollack

Twitter: - EdwardPollack

LinkedIn: Edward Pollack

Contact: https://www.sqlshack.com/author/edward-pollack/

Adam Belebczuk

Twitter: - @SQLDiablo

LinkedIn: Adam Belebczuk

Contact: http://www.sqldiablo.com/

SQLSaturday #383 - Rochester 2015

Sessions

Title: XML Without Xanax: How to Handle XML in SQL Server

Title: Right-Sizing Your SQL Server Virtual Machine

Title: Rethink Your ETL with BIML

Title: Hacking Exposé - Using SSL to Protect SQL Connections

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Title: Basic Database Design

Title: Software as a service

Title: Transactional Replication: Architecture, Setup, and Monitoring

Title: Transactional Replication: Tuning and Troubleshooting

Title: Possible Musics: SSAS Multidimensional vs Tabular

Title: Getting Started with MDX

Title: SQL Server 2014 New Features

Title: The Quest for the Golden Record: MDM Best Practices

Title: Introduction to Window Functions

Title: The usual SUSPECTs: When good databases go bad.

Title: The Many Paths of Consulting

Title: What exactly is big data and why should I care?

Title: Query Tuning - Get it Right the First Time

Title: DBA 911 - Database Corruption

Title: How does Microsoft solve Big Data?

Title: Enterprise-level auditing on a Standard Edition budget

Title: T-SQL Window Function Performance

Title: Availability Groups 101: An Introduction

Title: So you want to be a Database Administrator…

Title: Query Optimization Crash Course

Title: Boosting DWH-Performance with SQL Server 2014

Title: Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools

Title: The BI Power Hour

Title: SQL Server Storage Engine under the hood

Title: (a Few of) My Favorite DMVs

Title: Getting started with SSIS

Title: The Use Cases for In-Memory OLTP

Title: SQL Server AlwaysOn Availability Groups

Title: Easing Into Scripting with Windows PowerShell

Title: Troubleshoot SQL Server Performance Issues using Wait Statistics

Title: Level Up: Understanding Azure’s SQL Database Service Tiers

Title: APPLY Yourself

Title: The Spy Who Loathed Me - An Intro to SQL Security

Title: Much Ado About Hadoop

Title: SQL Server and Networking High Availability/Disaster Recovery Best Practices

Title: Fixing Page Life Expectancy

Title: Building dynamic SSIS packages for more flexibility

Title: Advanced Troubleshooting Your SQL Connections

Speakers

Sponsors