SQLSaturday #452 - Charlotte 2015
Event Date: 10/17/2015 00:00:00
Event Location:
- Central Piedmont Community College (CPCC)
- 2800 Campus Ridge Road
- Charlotte, North Carolina
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Getting the Skinny on Minimally Logged Operations
Abstract: Any changes to Non-Memory Optimized tables require a certain amount of logging to the transaction log in order to ensure the integrity of the operation and of course the database. Most of these are fully logged operations and can write a tremendous amount of data to the transaction log. As you probably already know these can lead to various performance and availability issues. However you may be able to minimize the effect of these with what is called a minimally logged operation. This session will outline how these can be used under the right conditions to save time, resources and potentially a lot of headaches. Various demos will hit home on just how much of an impact this can have on some every day operations.
Speaker(s):
- Andrew Kelly
Track and Room: Enterprise Database Administration Deployment - Room 2316
Title: Scripting out SQL Server for Documentation and Disaster Recovery
Abstract: Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
Speaker(s):
- George Walkey
Track and Room: Enterprise Database Administration Deployment - Room 3315
Title: Introducing Forensic Analytics with PowerPivot for Excel
Abstract: Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities. In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.
Speaker(s):
- William E Pearson III
Track and Room: Analytics and Visualization - Room 3315
Title: Tame Your Unruly Data…With Constraints!
Abstract: Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
Speaker(s):
- Rob Volk
Track and Room: Application Database Development - Room 2316
Title: Analysis Services: Show Me Where It Hurts
Abstract: “Its.Slow!” are probably the two most dreaded words for any database professional (right behind “You’re fired!”)
What’s slow? Since when? Compared to what?
Join this “something-everyone-should-be-doing-but-isn’t” session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We’ll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.
Speaker(s):
- Bill Anton
Track and Room: BI Platform Architecture, Development Administration - Room 3316
Title: SSIS 2014 Data Flow Tuning Tips and Tricks
Abstract: Do you want SSIS to go fast? This session is for you! Attend and learn techniques for developing, instrumenting, monitoring, and managing SSIS 2014 Data Flow performance in your data integration enterprise.
Speaker(s):
- Andy Leonard
Track and Room: BI Platform Architecture, Development Administration - Room 3316
Title: Beginners SQL Server Security the Low Hanging Fruit
Abstract: Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA’s can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA’s are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.
Speaker(s):
- Lindsay Clark
Track and Room: Enterprise Database Administration Deployment - Room 2315
Title: Table Partitioning Intro and make that a sliding window too!
Abstract: A walk-through of creating a sliding window table partition on an AdventureWorks table.
Speaker(s):
- Jeff Reinhard
Track and Room: Enterprise Database Administration Deployment - Room 3316
Title: Managing Complex Workloads Using the SQL Server 2014 Resource Governor
Abstract: The Resource Governor is a key SQL Server technology for managing competing workloads. New capabilities designed to provide greater flexibility in resource management have been added in SQL Server2012 and SQL Server 2014. As organizations consolidate their SQL architectures, effective management of compute and disk resources becomes more difficult. This session will detail Resource Governor functions as well as demos to illustrate advanced workload management using the SQL 2014 Resource Governor.
Speaker(s):
- Denis McDowell
Track and Room: Enterprise Database Administration Deployment - Room 2302
Title: Crash course on becoming better SQL Developer.
Abstract: Crash course on becoming better SQL developer by focusing on common mistakes and how to overcome it. What does one need to know to become better SQL Developer? What tools can make your job easier and how to use them? How can I write modular code to make it reusable? These and many other questions will be answered by reviewing mistakes, showcasing free tools and going over bad code.
Speaker(s):
- Vladimir Oselsky
Track and Room: Application Database Development - Room 2316
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: Other - Room 2300
Title: Getting Started With Execution Plans
Abstract: Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.
Speaker(s):
- Scott Fallen
Track and Room: Enterprise Database Administration Deployment - Room 3316
Title: From T4 to BimlScript
Abstract: This session is for database and application developers who know Microsoft’s T4 (Text Template Transformation Toolkit) from Visual Studio but would like to make the transition to the powerful BimlScript language for generating SSIS and SSAS projects dynamically. Business Intelligence Markup Language (Biml) and BimlScript let you tap into the rich metadata of your SQL Server databases, multiplying your efficiency and accuracy many times over. During this highly-interactive session, we’ll leverage your familiarity with template-based code generators like T4, comparing its features to BimlScript to tackle some difficult Business Intelligence tasks in a fraction of the time it would normally take. If you don’t know T4, any prior experience with template-based code generators will prepare you well for this session. Moreover, if you’ve never done dynamic code generation before, you may still find this session fascinating and a quite useful addition to your toolbox.
Speaker(s):
- Kevin Hazzard
Track and Room: BI Information Delivery - Room 3314
Title: What’s in a Date? Avoiding confusion with Dates, Times, and Durations
Abstract: Dates and Times can be very confusing. Julian Days, Fiscal Years Months, UTC, Atomic Time, Leap Seconds, ISO 8601, and more clutter up what, on the surface, appears to be a simple set of data types. This session will work to demystify dates and times, with a focus on SQL Server. It will cover the pros and cons of each of SQL Server’s date/time data types, why you need a Calendar table in almost every database (and maybe a Time table too), various good methods of handling intervals and durations, how to use the IANA tzdata database to help with time zones daylight savings. As a bonus, if we have time, we’ll also talk about SQL Server 2016’s Temporal tables and what they mean for the current/history table pattern.
Speaker(s):
- Nate West
Track and Room: Application Database Development - Room 2301
Title: Getting Started with SSIS Script Tasks and Components
Abstract: SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session for an introduction to the scripting capabilities of SSIS. Many data movement activities can be handled with SSIS using the built-in tasks and components. Eventually, though, you will run into a scenario that will be better handled by extending SSIS functionality with custom code. In this session, we will cover the basics of using scripts in SSIS control flows and data flows. We’ll talk about the pros and cons of scripts, review the development environment for scripts, cover some interesting and useful .NET classes, and walk through multiple examples of scripts that add useful functionality to SSIS.
Speaker(s):
- John Welch
Track and Room: BI Platform Architecture, Development Administration - Room 2315
Title: Profisee: Learn How To Build A Golden Record for Any Subject
Abstract: Attend the lunch demo and see how you can use Master Data Services and Maestro to: o Create a golden record for any subject area in a matter of minutes o Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? o Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? o Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting o Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
Speaker(s):
- Gene Webb
Track and Room: Sponsored Session - Room 2302
Title: There May Be No Free Lunch But You Can Have Free Training
Abstract: Did you know that you don’t have to wait until the next PASS Summit or BA Conference to get more training? If your company can’t send everyone to the big conferences every year, it definitely doesn’t mean you have to go without keeping up your skills or increasing your knowledge. You’ve found your way to SQLSaturday, and that’s a great first step. But there is so much more out there. I’ll share with you free resources including blogs, user groups, PASS virtual chapters, Twitter, Linked In, online forums, and other websites. These resources will help you stay connected to the SQL/BI community year-round so you can continue to increase your skills without draining your company’s training budget or your wallet.
Speaker(s):
- Meagan Longoria
Track and Room: Professional Development - Room 2302
Title: Policy Based Management: Introduction and Implementation
Abstract: In this session users will be introduced to the concepts and capabilities of Policy Based Management. We will review the basics of what policies are, the process for setting up new policies, evaluating policies against an environment, and scaling policies across an environment.
Speaker(s):
- Ryan Brickey
Track and Room: Enterprise Database Administration Deployment - Room 2314
Title: Enhancing Data and Predictive Analytics with NoSQL
Abstract: The pervasiveness of Big Data has created significant challenges for companies that have historically utilized relational database management systems to perform data analysis and predictive analytics. This presentation outlines the challenges that stem from Big Data as it relates to deriving value from data, the types of NoSQL data stores available and how NoSQL can serve as a data platform that enhances the data analysis and predictive analytics capabilities of companies.
Speaker(s):
- Cornell Emile
Track and Room: Analytics and Visualization - Room 3314
Title: Azure SQL Database - Is it right for my organization?
Abstract: Azure SQL Database is now based on the same bits as SQL Server 2014, bringing great enterprise capabilities. We will discuss business continuity features such as geo restore, point-in-time recoveries, and how to recover a deleted database with only a few clicks. No more retrieving tapes from you off-site backup vault! Learn how easy it is to configure a geo-replicated solution which allows for both disaster recovery and readable secondaries. Use the built-in SQL Server Management Studio wizard to migrate your on-premises databases into Azure SQL Database.
Speaker(s):
- Lori Clark
Track and Room: Cloud Application Development Deployment - Room 3316
Title: Secure/Encrypt SQL Server Database With TDE
Abstract: TDE, Transparent Database Encryption, is a Microsoft built-in solution to protect sensitive information by encrypting entire SQL Server database. TDE encrypts and decrypts the data on the fly with minimum overhead and no code change at all on the development or application side.
Speaker(s):
- Thomas Chan
Track and Room: Enterprise Database Administration Deployment - Room 2316
Title: Tone Analysis with HDInsight and Azure Machine Learning
Abstract: People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
Speaker(s):
- Paco Gonzalez
Track and Room: BI Information Delivery - Room 3314
Title: Creating a Performance Monitoring Solution for SQL Server BI Suite
Abstract: These talks discuss using the native Windows performance tools System Monitor and WMI technology to create logs that track the overall performance of SSIS, SSAS, and SQL Server. This will be a deep dive into Windows Performance Monitoring and WMI tools that are native to all Windows Operating Systems and how they can be used to track and monitor your SQL applications. I will discuss memory utilization, counters, WMI classes, and threading that is collected during SQL operations within the Windows OS. I will also show you how to collect this data manually or via automated schedule and export it for later evaluation or logging
Speaker(s):
- Melvin Black
Track and Room: BI Platform Architecture, Development Administration - Room 2315
Title: Trust Your Data with Data Quality Services
Abstract: This session will step through the fundamentals that go into assessing existing data quality issues as well as an introduction on how to use Microsoft’s Data Quality Services to address those issues. The presentation will begin by discussing techniques to uncover pain points that may currently exists within your data. We will step through techniques for stakeholder discussions and things to look for when profiling your data. In the second half of the session, we will transition into a demo that introduces the capabilities of Data Quality Services. I will discuss the major functions of Data Quality Services such as, Knowledge Bases, domains, and matching. My goal at the end of the session is for each participant to have a good baseline understanding of what to look for when assessing quality within their data, as well as, how to begin solving the issues they find.
Speaker(s):
- Justin Ward
Track and Room: BI Information Delivery - Room 3314
Title: Advanced SQL Server Agent
Abstract: When was the last time you read up on SQL Agent features? Is there more you could be doing with it?
We’ll answer this question and more as we take a deep dive into the SQL Server Agent. In this session we will cover some of the basic best practices of SQL Agent configuration as well as more advanced topics like managing large numbers of jobs, properly managing job history, and keeping jobs in sync across multiple instances.
Speaker(s):
- Mark Wilkinson
Track and Room: Enterprise Database Administration Deployment - Room 2300
Title: Small Scale Data Collection Using PowerShell - Going NSA Style!
Abstract: While we are not the NSA, certain vital data needs to be collected – for example audit data, trace data, session information, performance data etc. – all to a central SQL Server repository, for analysis. In this session let us see how freely available PowerShell code can be used to collect data from multiple SQL Servers instances/databases. At the end of this session, you will have the knowledge and ability to collect pretty much any data to a central repository with just a couple of lines of code all in a manner that works specifically for you!
Speaker(s):
- Jana Sattainathan
Track and Room: Other - Room 2316
Title: Database Corruption
Abstract: Database corruption could happen to you. This could potentially be one of the worst nightmares you could experience in the database world. In this session I will be talking about what database corruption is. I will also give a lesson on how dbcc works and the limitation of it. I will give examples of database corruption and how to resolve them. I will also give examples of how to verify integrity of backups. Backups are essentially the last resort for resolving database corruption.
Speaker(s):
- Stephen Muliokela
Track and Room: Other - Room 2300
Title: First Look at SQL Server 2016
Abstract: Microsoft has been busy working on the next version of SQL Server - SQL Server 2016. We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB. Row Level Security allows you to add another layer of security to your environment. StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.
Speaker(s):
- Rick Heiges
Track and Room: Enterprise Database Administration Deployment - Room 3315
Title: Pyramid Analytics: Looking for the Power BI on-prem alternative
Abstract: Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML!
Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics’ BI Office suite.
Speaker(s):
- Mark Scott
Track and Room: Sponsored Session - Room 2301
Title: Power BI: Architecture, Integration Points, Implementation Options
Abstract: In this session we will review Power BI V2 architecture and integration points with corporate data sources, SaaS services, Azure, and third party apps. We will examine and demonstrate key capabilities in the Power BI web-based service, Power BI Desktop, Excel, and mobile apps. Implementation options for Power BI involving cloud, on-premises, and hybrid approaches will be explored. Finally, the concept of “Bimodal BI” will be introduced with use cases for how Power BI might be utilized for both self-service BI and certain corporate BI initiatives.
Speaker(s):
- Melissa Coates
Track and Room: BI Platform Architecture, Development Administration - Room 2302
Title: Better Managed Services Through Monitoring with UpSearch and SQL Sentry
Abstract: In this presentation Brian Davis and Scott Fallen will demonstrate how SQL Sentry tools help UpSearch and their managed services customers monitor and tune their SQL Servers. Brian is a SQL Server Consultant for UpSearch, and Scott is a Sales Engineer for SQL Sentry. During the presentation, we will look at baselining, performance bottleneck identification, query tuning, alerting, and automated response with SQL Sentry in the context of how the team at UpSearch leverages these features. We will conclude with a demo of some of the powerful features of SQL Sentry Plan Explorer FREE.
Speaker(s):
- Scott Fallen
Track and Room: Sponsored Session - Room 2315
Title: No Money for Performance Monitoring Tools? No Problem!
Abstract: So you like the idea of using one of the commercially available performance monitoring tools but can’t convince your boss to spend the money? Then join me as we explore some absolutely free tools born right out of Microsoft’s customer support teams: DiagManager and SQLNexus. We will see just how easy it is to use them to collect and analyze performance data from your SQL Servers. These tools can get you started quickly without having to deal with the red tape.
Speaker(s):
- Patrick Keisler
Track and Room: Enterprise Database Administration Deployment - Room 2315
Title: Looking for the Power BI on-prem alternative?
Abstract: Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML!
Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics’ BI Office suite.
Speaker(s):
- Mark Scott
Track and Room: Analytics and Visualization - Room 2301
Title: Status of the Charlotte IT Marketplace
Abstract: In this session you will learn what is the status of the local IT market. Included will be: Salary Information, Market Trends, City Facts, Who is HIring, and a lot more.
Speaker(s):
- Leveat Ruse
Track and Room: Professional Development - Room 2301
Title: Introduction to R Programming
Abstract: R is a free software environment for statistical computing and graphics. By far the most popular programming language for data science projects, R is used to solve problems in fields such as biology, physics, finance and marketing. With the recent acquisition of Revolution R and the increasing capabilities of AzureML, Microsoft’s attention to deliver an enterprise-ready version of the R platform has increased exponentially. Please join me to learn the foundations of R, how to begin plotting data using ggplot2 and how R is integrated in AzureML.
Speaker(s):
- Jake Switzer
Track and Room: Analytics and Visualization - Room 2315
Title: DELL SQL Server Solutions
Abstract: Your organization relies on SQL Server to support its applications, customers and employees. But to maintain productivity, control costs and protect data, your SQL Server environment must be up and running, effectively supported and secured. Come see how DELL SQL Server Solutions increase productivity, reduce costs and protect data in your SQL Server environment.
Speaker(s):
- Vera Takakura
Track and Room: Sponsored Session - Room 2316
Title: SQL Server and Azure
Abstract: SQL Server 2014\2016 is on the edge of one of the larger revolutions in Database technologies in the recent past. The reason is that we have a new technology out there, and your may have heard of it, it’s called the cloud. Microsoft’s version of cloud technologies is called Azure.
In this session, we will learn some details of using SQL Server 2014 with Azure, as well as Azure Database as a Service. In addition, we’ll explore some of the new, improved features available in SQL Server 2016. We’ll explore how SQL Server integrates with Azure, and how you can put one toe in the water and get started integrating the cloud into your organization.
Speaker(s):
- Rich Cargile
Track and Room: Cloud Application Development Deployment - Room 3314
Title: Introduction To R For Sql Developers
Abstract: In this session we will explore
- Installation of R and R Studio
- R basics
- Power of R
- Getting data from databases and other sources.
- Managing Data frame using Package dplyr
- Visualization of Data using Graphic Package ggplots2
- In-Database R in Sql Server 2016
Speaker(s):
- Kiran Math
Track and Room: Analytics and Visualization - Room 2314
Title: Managing a Production Azure SQL Database - True Story!
Abstract: I develop for and manage a small, but active, web application that lives completely inside of Azure from code to data. I’ve been involved with it since inception, and I’ve learned a few things about developing for, and managing data in this environment the hard way.
I’d like to share some of the lessons I’ve learned in hopes that it can save others some time.
Speaker(s):
- Jason Hall
Track and Room: Cloud Application Development Deployment - Room 2314
Title: Making Predictions with Microsoft Data Mining Tools
Abstract: Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft’s data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It’s easier than you might have thought.
Speaker(s):
- Mark Hudson
Track and Room: Other - Room 2300
Title: Disaster Recovery Where to Begin
Abstract: So you have a good backup strategy in place, but now you have to think about a disaster recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn. Then we will talk about how to choose the best one to meet your business needs.
Speaker(s):
- Tracy Boggiano
Track and Room: Other - Room 2314
Title: Scalable Application Design with Service Broker
Abstract: How your business applications interact directly with the corporate database can dramatically affect how successful you are. One of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can focus performance concerns where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently and minimizes conflicts with your critical updates. This session walks you through the steps to get Service Broker running and providing a consistent delivery of your business data.
Speaker(s):
- Allen White
Track and Room: Application Database Development - Room 2314
Title: Building Your Yellow Brick Road: Directing Your Path to a Successful Career
Abstract: For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.
Speaker(s):
- Justin Randall
Track and Room: Professional Development - Room 3315
Title: Statistics are hidden treasure.
Abstract: What are statistics? Why do we need statistics? How we can use statistics for our advantage?
I’ll show you the case, along with walking through statistics, execution plans, plan cache and query hints.
Also, will show how to use statistics in your day-to-day life and benefit from it.
Speaker(s):
- Slava Murygin
Track and Room: Enterprise Database Administration Deployment - Room 3315
Title: PowerShell Basics for SQLServer
Abstract: Overview of PowerShell and how to perform SQL scripts using PowerShell. In this session you will learn the basics on building scripts using PowerShell and then learn the basics of using PowerShell for SQL server administration.
Speaker(s):
- Michael Wharton
Track and Room: Enterprise Database Administration Deployment - Room 2302
Title: Planning for Virtualization
Abstract: This session will serve as a guide for database administrators who are considering virtualizing their SQL server instances (or are about to have that decision thrust upon them) and are unsure of the best approach. It will cover the basics of how to configure a virtualized environment for SQL server, make you aware of some of the common performance pitfalls and help to dispel some of the myths around managing database availability in a virtualized environment. At the end of the session you should have a good idea as to whether virtualization is the right choice for your database environment and a broad strategy for how to go about implementing it.
Speaker(s):
- Brian Carrig
Track and Room: Other - Room 2300
Title: Beginning Azure
Abstract: The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let’s put SQL Server into the cloud!
Speaker(s):
- Thomas Norman
Track and Room: Cloud Application Development Deployment - Room 2302
Title: SQL Clinic
Abstract: SQL Clinic is an open session/discussion lead by couple of Microsoft engineers. If you have any SQL related problem or question, you can go there and ask and get a consult for free. If you do not have problems or questions you can just sit in and learn what kind of problems other people have in their environments.
Speaker(s):
- Harsh Deep Singh
Track and Room: Enterprise Database Administration Deployment - Room 2301
Title: Configuring and using PolyBase to interact with Hadoop
Abstract: In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits.
Speaker(s):
- Montrial Harrell
Track and Room: BI Information Delivery - 3314
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Scott Fallen
Twitter: - @ScottFallen
LinkedIn: Scott Fallen
Contact: http://blogs.sqlsentry.com/author/ScottFallen/
Scott Fallen (@ScottFallen) is a Solutions Engineering Manager on SentryOne’s Sales team and is responsible for technical sales support. He interacts with customers and prospective customers at conferences and trade shows. He also provides demos and online webinars existing and future users of SentryOne software.
Justin Randall
Twitter: - jh_randall
LinkedIn: Justin Randall
Contact: http://blogs.sqlsentry.com/justinrandall
Justin Randall is a Senior Consultant at SQL Sentry, LLC. He has over 30 years of data management experience in a variety of roles from Enterprise Data Modeler to DBA, supporting development in DB2, Sybase, and SQL Server. Justin frequently speaks at SQL Server User Group meetings and SQLSaturdays, and has presented at several SQLintersection conferences. His current professional interests are SQL Server performance monitoring and tuning, and career development.
Kiran Math
Kiran Math is a Software Engineer on the Construction Predictive Analytical team at Fluor, where he specializes in T-SQL, R, Python, C# etc.
A resident of Greenville, South Carolina, he can be found cycling and hiking the trails around Greenville.
He is active in his local SQL PASS chapter in Greenville, speaking and volunteering at SQLSaturdays.
Harsh Deep Singh
Twitter: - @harshdeepsingh
LinkedIn: Harsh Deep Singh
Contact: http://blogs.msdn.com/b/sqljourney/
HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Nate West
I have been working with databases for over 10 years, as an application developer, data modeler, and data warehouse architect. How best to represent the real world in a computer always been a deep interest of mine. I have lived most of my life in the Pittsburgh area, moving to Charlotte in 2013.
Rich Cargile
Rich Cargile is a Senior Software Engineer at RDA Corporation. For over 10 years, he has designed, developed, and maintained a data-centric solutions within multiple industries such as Finance, Digital Marketing, State and Federal Government using Microsoft#39;s BI stack. His main interests include relational database performance tuning, ETL, Business Intelligence, and Azure.
George Walkey
Twitter: - sqlbytehd
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
Michael Wharton
Twitter: - MyProjectExpert
LinkedIn: Michael Wharton
Contact: http://MyProjectExpert.com
Michael Wharton is a Project MVP. He has been an independent consultant for the past 20 years, with over 30 Project/SharePoint Server deployments. He has an MBA from Wake Forest and has over 44 Microsoft Certifications. Michael’s primary job is helping companies setup a PMO, Project Management Office using Project Server using SQL server on a SharePoint Farm. He has worked extensively with the back end support setting up SQL server, SharePoint Server and Project Server using PowerShell.
Melvin Black
LinkedIn: Melvin Black
My background includes a wide and depth understanding in the End to End development of Reporting Solutions and Data Modeling using the Microsoft Business Intelligence stack.
Certified as Microsoft MCSE, MCSD (VB and SQL), MCTS (Performance Point 2007, SQL Business Intelligence 2005 and 2008, SCOM 2007). I have been a Microsoft Certified Profession since 1997,a former Microsoft Engineer, and currently an active Sr. BI Consultant.
B.S. in Information Systems Mgmt and M.S. Project Management
Jake Switzer
LinkedIn: Jake Switzer
Jake Switzer is a SQL/BI consultant for Microsoft. He works to deliver data analytics solutions to customers using a variety of Microsoft and Open Source software. He is interested in topics such as data science, business intelligence, and sports analytics.
Ryan Brickey
Twitter: - SQLBrickey
LinkedIn: Ryan Brickey
Contact: http://mindofadba.blogspot.com/
Ryan is currently a Database Administrator with Wells Fargo where he is responsible for a production SQL Server environment. Before coming to Wells Fargo, he started his career working as a data analyst doing data mining and developing ETL procedures. From there he turned to performance monitoring and tuning as a Software Support Engineer with SQL Sentry. He also holds the certification of MCITP - SQL Server 2008 Database Administration.
Patrick Keisler
Twitter: - @PatrickKeisler
LinkedIn: Patrick Keisler
Contact: http://www.patrickkeisler.com
I#39;m a husband, a father, an Atlanta Braves fan, and oh yeah…I know a thing or two about Microsoft SQL Server, because I work for Microsoft supporting it as a Premier Field Engineer. I have over 15 years of DBA experience and have gained considerable knowledge in SQL Server by supporting lots of different type of applications ranging from high-volume trading applications to large data warehouses. I hold several certifications: MCSE: Data Platform, MCITP SQL 2008 Admin and Dev, and Security+.
Andy Leonard
Twitter: - AndyLeonard
LinkedIn: Andy Leonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
Melissa Coates
Twitter: - https://twitter.com/SQLChick
LinkedIn: Melissa Coates
Contact: https://www.CoatesDataStrategies/blog
Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.
Andrew Kelly
Twitter: - gunneyk
Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx
Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.
Mark Wilkinson
Twitter: - http://twitter.com/m82labs
Contact: http://www.m82labs.com
I am a father of 4, and live in Raleigh North Carolina. I love fixing problems, and learning new technologies that can help me fix those problems faster and better than I did the time before.
In my spare time I like to read, speak, and learn new things. I currently work as a Database Administrator at ChannelAdvisor where I solve fairly interesting problems on fairly large databases.
You can often find me on Twitter where I talk about SQL, beer, and anything else I find interesting.
Jana Sattainathan
Twitter: - www.twitter.com/SQLJana
LinkedIn: Jana Sattainathan
Contact: http://www.sqljana.wordpress.com
Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.
Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (> 20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing. He has also fully automated the database deployment which supports all components of SQL Server and Oracle using PowerShell (with about 150 functions) that is tracked extensively.
Jason Hall
Twitter: - @SQLSaurus
LinkedIn: Jason Hall
Contact: http://blogs.sqlsentry.com/jasonhall
Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.
Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.
Meagan Longoria
Twitter: - mmarie
LinkedIn: Meagan Longoria
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Jeff Reinhard
Twitter: - @SQLMajor
LinkedIn: Jeff Reinhard
I have 25 years of database development experience, mostly with SQL Server, with companies such as Ernst amp; Young, Internet Security Systems/IBM, AirWatch, WebMD, CheckFree and others. My recent focus has been on AlwaysOn availability groups and database DevOps.
Denis McDowell
Twitter: - mcdowell_is
LinkedIn: Denis McDowell
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.
Lindsay Clark
Twitter: - @LindsayOClark
LinkedIn: Lindsay Clark
Lindsay started out in network administration with a BA in Computer Science from South University prior to finding her true love in database administration. Whether it#39;s mentoring in the office or presenting sessions at SQLSaturday, Lindsay loves to find new ways to collaborate and share information. In addition to her role as DBA at American Credit Acceptance, she actively recruits speakers for her user group and chairs her local SQLSaturday event.
Justin Ward
LinkedIn: Justin Ward
My name is Justin Ward and I am a Data Solutions consultant with Cardinal Solutions Group. Since joining Cardinal, I#39;ve had the opportunity to gain experience in multiple industries working with Reporting, Integration, and Data Quality tools across both Microsoft and IBM platforms. I#39;m very passionate about constantly learning and sharing knowledge with peers of my profession. This has driven me two present and partake in multiple SQL events in the Charlotte area over the past couple of years.
Stephen Muliokela
LinkedIn: Stephen Muliokela
I have been a DBA for many years now and currently hold multiple SQL Server certificates. In addition, I am also a Six Sigma Blackbelt.
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
Tracy Boggiano
Twitter: - TracyBoggiano
LinkedIn: Tracy Boggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.
Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.
Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
Vera Takakura
Twitter: - vtakonsql
LinkedIn: Vera Takakura
Account Executive for Enterprise Database Solutions for Dell Software formally Quest Software
Mark Hudson
Twitter: - HMarkHudson
Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).
Kevin Hazzard
Twitter: - https://twitter.com/KevinHazzard
LinkedIn: Kevin Hazzard
Contact: http://www.linchpinpeople.com/blog/
Kevin Hazzard is a Partner at Linchpin People LLC, leaders in the data integration and database wellness space. He was a long-time Microsoft MVP and the author of a book entitled Metaprogramming in .NET. Kevin also serves as an elected member of his local School Board and dedicates most of his non-professional time promoting public education.
Leveat Ruse
Twitter: - www.twitter.com/ncsctechrecruit
LinkedIn: Leveat Ruse
As an Executive Technical Recruiter with Ctrl+f, I currently develop effective recruitment strategies to attract top talent at all levels of an organization. I am an IBM certified trainer and began my career performing general human resources duties. I quickly worked my way up through the ranks of technical recruiting from Lead Recruiter to Senior Recruiter to Business Development.
Thomas Chan
LinkedIn: Thomas Chan
I work with SQL Server since 2001 with version 7.
Mark Scott
Twitter: - @usamjscott
LinkedIn: Mark Scott
Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mark-scott.aspx
Mark has over 20 years of consulting, managing, delivering, and selling in both private and public companies all over the US. Prior to joining Pyramid, he held consulting and sales leadership positions at Microsoft delivering and selling BI and Data Warehousing solutions to large enterprise accounts. In his spare time - Mark enjoys traveling and spending time with his wife, and two sons age 4 and 6!
Cornell Emile
Twitter: - https://twitter.com/CornellEmile
For nearly two decades, Cornell A. Emile has designed, developed, and maintained data-centric solutions within multiple industries such as Finance, Digital Marketing, Non-Profit, Retail, Manufacturing State and Federal Government using Microsoft#39;s business and data products. His main interests include architecting data solutions, Business Intelligence and NoSQL databases.
Paco Gonzalez
Twitter: - @pacosql
LinkedIn: Paco Gonzalez
Paco Gonzalez is the CEO of SolidQ North America, and a Microsoft Data Platform MVP. Focused on Business Analytics and Artificial Intelligence, he specializes in helping organizations become data driven from a strategic and technical perspective. Paco is a speaker at small and large conferences such as PASS Summit, Ignite, and Business Applications Summit, and he has published several books and whitepapers. He is based in Atlanta, GA.
Gene Webb
Twitter: - None
LinkedIn: Gene Webb
Contact: http://None
Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist.
Bill Anton
Twitter: - https://twitter.com/SQLbyoBI
LinkedIn: Bill Anton
Contact: http://byobi.com/blog/
Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.
Slava Murygin
Twitter: - SlavaSQL
LinkedIn: Slava Murygin
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.
Brian Carrig
Twitter: - @briancarrig
Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.
Scott Fallen
Twitter: - @ScottFallen
LinkedIn: Scott Fallen
Contact: http://blogs.sqlsentry.com/author/ScottFallen/
Scott Fallen (@ScottFallen) is a Solutions Engineering Manager on SentryOne’s Sales team and is responsible for technical sales support. He interacts with customers and prospective customers at conferences and trade shows. He also provides demos and online webinars existing and future users of SentryOne software.
Lori Clark
As a Data Platform Specialist for State and Local Government, I work with customers to effectively license their SQL Server environments. I showcase various technical features through demos and on-site discussions, as well as assist customers with POCs. Recently, I recorded a Channel 9 quot;What#39;s New for Azure SQL Databasequot; video.
Mark Scott
Twitter: - @usamjscott
LinkedIn: Mark Scott
Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mark-scott.aspx
Mark has over 20 years of consulting, managing, delivering, and selling in both private and public companies all over the US. Prior to joining Pyramid, he held consulting and sales leadership positions at Microsoft delivering and selling BI and Data Warehousing solutions to large enterprise accounts. In his spare time - Mark enjoys traveling and spending time with his wife, and two sons age 4 and 6!
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
Rick Heiges
Twitter: - heigesr2
LinkedIn: Rick Heiges
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.
Vladimir Oselsky
Twitter: - @VladyOselsky
LinkedIn: Vladimir Oselsky
Vladimir Oselsky (Vlady) is an IT Professional with over 15 years of experience in various IT Jobs. Born and raised in Siberia, moved to United States in late 90s. Passion for computer and programming started with DOS games and learning Borland Paschal in 8th grade as a hobby. IT career consisted of everything from hardware and software support to server administration. Current focus on SQL Server Database Development and .NET programming
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.
Montrial Harrell
Twitter: - @blackdragon_sql
LinkedIn: Montrial Harrell
Contact: http://www.broadstrokeconsulting.com
Montrial has been involved with Technology since his first programming class in Junior High over 23 years ago. Since then he has been discovering how to use technology to solve problems in support of infrastructure teams, software development, Health Care and Government agencies. He has worked as a Systems Admin, LAN Admin, QA Engineer, instructor and finally decided to focus on Data Management and Governance because it offered so many ways to help businesses.
John Welch
Twitter: - @john_welch
LinkedIn: John Welch
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
Sponsors
The following is a list of sponsors that helped fund the event: