sqlpasshistory

ID: 984

Back to Main list

Data Expert Series

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
07-02-2019 16:00	Meagan Longoria	Breakout Session (75 minutes)	Advanced Analytics	Do Your Data Visualizations Need a Makeover?
07-02-2019 16:00	Bob Pusateri	Breakout Session (75 minutes)	Database Administration and Development	SSMS & T-SQL Tricks: Working Smarter, Not Harder
07-02-2019 16:00	Hamish Watson	Breakout Session (75 minutes)	Cloud Solutions	Building a Database DevOps Pipeline in the Cloud in less than 59 Minutes
07-02-2019 17:20	Kendra Little	Breakout Session (75 minutes)	Database Administration and Development	Fix My Functions: Speeding Up Scalar and Table Valued UDFs
07-02-2019 17:20	Jeff Renz, Leslie Weed	Breakout Session (75 minutes)	Business Intelligence and Data Warehousing	Innovative Data Modeling: Make Data Warehousing Cool Again
07-02-2019 17:20	Carlos Bossy	Breakout Session (75 minutes)	Advanced Analytics	Data Science Tips and Tricks using Python and SQL
07-02-2019 18:40	Jen Underwood	Breakout Session (75 minutes)	Advanced Analytics	Storytelling for Machine Learning and Advanced Analytics
07-02-2019 18:40	Ed Leighton-Dick	Breakout Session (75 minutes)	Database Administration and Development	Principle of Least Privilege: The Key to Strong Security
07-02-2019 18:40	Brent Ozar	Breakout Session (75 minutes)	Database Administration and Development	Getting Better Query Plans by Improving SQL’s Estimates
07-02-2019 20:00	Pinal Dave	Breakout Session (75 minutes)	Database Administration and Development	Kick Start! SQL Server 2017 Performance Tips and Tricks
07-02-2019 20:00	Kimberly Tripp	Breakout Session (75 minutes)	Database Administration and Development	Architecting for Scalability and Performance in Hybrid Workloads
07-02-2019 20:00	Matt How	Breakout Session (75 minutes)	Advanced Analytics	A Heart to Heart with your Data: Emotional Intelligence in Azure
07-02-2019 21:20	Bob Ward	Breakout Session (75 minutes)	Database Administration and Development	Inside SQL Server with Containers
07-02-2019 21:20	Sourabh Agarwal	Breakout Session (75 minutes)	Database Administration and Development	Architecting a Highly Available Database Platform with SQL Server
07-02-2019 21:20	Alberto Ferrari	Breakout Session (75 minutes)	Advanced Analytics	Understanding Relationships in Power BI
07-02-2019 22:40	Richard Campbell	Breakout Session (75 minutes)	Advanced Analytics	Building Trust in Teams

SessionID: 88772

Do Your Data Visualizations Need a Makeover?

Back to calendar

Event Date: 07-02-2019 16:00 - Category: Breakout Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Meagan Longoria

Title: Do Your Data Visualizations Need a Makeover?

Description:

Do you ever look at your data visualizations and feel that they are lackluster? Have you made a report using the latest chart types, but you still can’t gain adoption from your target audience? Lots of people feel this way, but they can’t quite identify what should be changed or how to change it. This session will help you identify signs that it’s time to give your data visualizations a makeover and provide practical tips for improving your reports and dashboards. We’ll discuss how simple changes in design choices related to color, chart types, chart formatting, and report layout can make a big difference in creating clear and engaging visualizations with common analysis tools like Power BI and Excel.

SessionID: 88771

SSMS & T-SQL Tricks: Working Smarter, Not Harder

Back to calendar

Event Date: 07-02-2019 16:00 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Bob Pusateri

Title: SSMS & T-SQL Tricks: Working Smarter, Not Harder

Description:

Do you spend a considerable amount of time in SQL Server Management Studio? Are you always in search of ways to write better code with less effort? Attend this session to see demonstrations of all the helpful gems SSMS has hiding in plain sight that will save you keystrokes, mouse clicks, and time while getting your work done. We will also cover useful T-SQL Scripts to make common tasks easier and faster, and solutions to frequently-encountered coding problems.

Whether you're a developer or a DBA, whether you do your work on-premises or in the cloud, attend this session to learn how easy it is to write better T-SQL code and save the day, all while working smarter, not harder!

SessionID: 88770

Building a Database DevOps Pipeline in the Cloud in less than 59 Minutes

Back to calendar

Event Date: 07-02-2019 16:00 - Category: Breakout Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Hamish Watson

Title: Building a Database DevOps Pipeline in the Cloud in less than 59 Minutes

Description:

DevOps processes encompass both Continuous Integration and Continuous Delivery. Continuous integration is based around automated builds and tests. Continuous Delivery allows both application developers, database developers and DBAs alike to deploy better quality code/software. In this DEMO heavy session, we will start off with source code only.

Over the course of 59 minutes we will build a deployment pipeline that starts off with pushing our database and application code to source control. We will utilize Visual Studio Team Services to automate our build and tests and perform Continuous Integration operations. The output of these operations will be a standardized package of our built solution.

Utilizing PowerShell in the form of Infrastructure as Code, we will spin up multiple Azure based environments that will be deployed to using automated Continuous Delivery processes. The finished result will be an automated and reliable deployment pipeline that was built under 59 minutes.

SessionID: 88775

Fix My Functions: Speeding Up Scalar and Table Valued UDFs

Back to calendar

Event Date: 07-02-2019 17:20 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Kendra Little

Title: Fix My Functions: Speeding Up Scalar and Table Valued UDFs

Description:

User Defined Functions are awesome for code reuse and expressing business rules simply — but they're famous performance killers in SQL Server. Learn which patterns cause scalar and table valued functions to drag down your query performance, and how to write your functions so they don't slack off. You'll see demos of how functions can be almost invisible in some query execution plans, and see what's really going on in your queries. You'll also learn which functions get major performance boosts from interleaved execution and the 'Froid' framework in the latest versions of SQL Server.

SessionID: 88774

Innovative Data Modeling: Make Data Warehousing Cool Again

Back to calendar

Event Date: 07-02-2019 17:20 - Category: Breakout Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Jeff Renz, Leslie Weed

Title: Innovative Data Modeling: Make Data Warehousing Cool Again

Description:

There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature. Discover this highly auditable modeling technique used in international banking, manufacturing, insurance and many more industries. Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy. Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time. We will explore how you can use continuous integration and delivery to further maximize value.

SessionID: 88776

Data Science Tips and Tricks using Python and SQL

Back to calendar

Event Date: 07-02-2019 17:20 - Category: Breakout Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Carlos Bossy

Title: Data Science Tips and Tricks using Python and SQL

Description:

The practice of Data Science has arrived and as data professionals we're on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before.

To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session, we will start by providing an introduction to Python, quickly becoming the defacto programming language for data scientists who want to create enterprise-ready solutions.

Carlos will then cover predictive analytics using T-SQL and Python, providing a practical understanding of what it takes to develop your own predictive models making the most of the expertise you already have. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into an analytics environment.

SessionID: 88783

Storytelling for Machine Learning and Advanced Analytics

Back to calendar

Event Date: 07-02-2019 18:40 - Category: Breakout Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Jen Underwood

Title: Storytelling for Machine Learning and Advanced Analytics

Description:

Storytelling and depiction of information has existed for hundreds of years in various forms and formats. In today’s era of artificial intelligence and machine-assisted analytics, accurately interpreting and effectively communicating findings is becoming a crucial skill to bridge the growing data literacy gap. To help decision makers get the most value from analytics projects to drive better outcomes, you need to help them make sense of the results.

Machine learning and advanced analytics can be difficult to understand and explain. Describing the problem, the model, the relationships among variables and the findings are often subtle, surprising and technically complex. Effectively translating quantitative insights and telling a compelling story requires planning, compelling design, and visualization choices. Successful analytical communicators don’t wait until the end of the analysis but rather use the entire process as a vehicle to communicate with stakeholders. Please join me in this session to learn the essence of storytelling for advanced analytics.

SessionID: 88787

Principle of Least Privilege: The Key to Strong Security

Back to calendar

Event Date: 07-02-2019 18:40 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Ed Leighton-Dick

Title: Principle of Least Privilege: The Key to Strong Security

Description:

A truly strong security model starts with no permissions and adds what is necessary to allow the user or application to do their assigned task - no more, no less. This is called the Principle of Least Privilege. It's a simple concept, but it can be quite difficult to implement in practice, especially if the prevailing practice has been much more permissive.

In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.

SessionID: 88782

Getting Better Query Plans by Improving SQL’s Estimates

Back to calendar

Event Date: 07-02-2019 18:40 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Brent Ozar

Title: Getting Better Query Plans by Improving SQL’s Estimates

Description:

You’ve been writing T-SQL queries for a few years now, and when you have performance issues, you’ve been updating stats and using OPTION (RECOMPILE). It’s served you well, but every now and then, you hit a problem you can’t solve. Your data’s been growing larger, your queries are taking longer to run, and you’re starting to wonder: how can I start getting better query plans?

The secret is often comparing the query plan’s estimated number of rows to actual number of rows. If they’re different, it’s up to you – not the SQL Server engine – to figure out why the guesses are wrong. To improve ’em, you can change your T-SQL, the way the data’s structured and stored, or how SQL Server thinks about the data.

This session won’t fix every query – but it’ll give you a starting point to understand what you’re looking at, and where to go next as you learn about the Cardinality Estimator.

SessionID: 88786

Kick Start! SQL Server 2017 Performance Tips and Tricks

Back to calendar

Event Date: 07-02-2019 20:00 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Pinal Dave

Title: Kick Start! SQL Server 2017 Performance Tips and Tricks

Description:

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 has introduced many new features. This session is carefully crafted to help overcome the beginner’s inertia for DBAs who have been using SQL Server for a while but aren't sure how to get started with the new features introduced in SQL Server 2017.

Here is a glimpse of the features we will cover in this session: • Adaptive query plans • Batch mode adaptive join • New cardinality estimates for optimal performance • Indexing Improvements • Automatic Tuning • Memory optimizations

At the end of the session, DBAs will learn 3 essential processes which can be game changers for their career. After implementing the suggestions discussed in this session, DBAs will have extra time to handle more pressing issues which they were not able to focus on earlier.

This 75 minutes will be the most productive time for any DBA or Developer.

SessionID: 88788

Architecting for Scalability and Performance in Hybrid Workloads

Back to calendar

Event Date: 07-02-2019 20:00 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Kimberly Tripp

Title: Architecting for Scalability and Performance in Hybrid Workloads

Description:

You’re keeping more data around longer and longer and you want to be able to better analyze that data; you might have a dedicated server for analysis but management often require reports run with real-time information. How can you architect the correct design to handle the ever-increasing volume of data as well as manage that data effectively for analysis both in production and to a secondary analysis server? This session will discuss the architectural changes you can design for both better manageability as well as long-term scalability!

SessionID: 88784

A Heart to Heart with your Data: Emotional Intelligence in Azure

Back to calendar

Event Date: 07-02-2019 20:00 - Category: Breakout Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Matt How

Title: A Heart to Heart with your Data: Emotional Intelligence in Azure

Description:

Customers have feelings. If you meet with all your customers regularly you probably think you know how they feel. But what if you have millions of customers? How can you even begin to get to understand how each of those customers feel about your business?

This is where cognitive API’s come in. By harnessing the power of deep neural networks, we can accurately derive emotional insight from our data and use this to improve our offering to our customers. In this session we will look at the tools needed to connect your data to the right API’s and how we can leverage their capability. Starting out with sentiment analysis we move to facial expression recognition and image tagging.

Attendees will gain the knowledge of how to connect different types of data to appropriate cognitive services. This talk would be of interest to anyone that deals regularly with customer data or has a curiosity toward data science and its application within a business.

SessionID: 88789

Inside SQL Server with Containers

Back to calendar

Event Date: 07-02-2019 21:20 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Bob Ward

Title: Inside SQL Server with Containers

Description:

Containers are the new virtual machines. Containers present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work and how SQL Server runs in them. Will cover the architecture of containers, how we have built SQL Server to run in containers, and how they work in environments such as Kubernetes. While this is an internal focused session you will walk away with knowledge of practical scenarios where SQL Server in Containers may be the right deployment model for you.

SessionID: 88790

Architecting a Highly Available Database Platform with SQL Server

Back to calendar

Event Date: 07-02-2019 21:20 - Category: Breakout Session (75 minutes) - Track: Database Administration and Development

Speaker(s): Sourabh Agarwal

Title: Architecting a Highly Available Database Platform with SQL Server

Description:

Mission critical database systems, built on SQL Server or other platforms, often have 4 or higher 9s of availability requirements, and as such significant planning and testing is needed to ensure the systems will meet these requirements. Designing such environments requires a good understanding and awareness of the product capabilities and all the granular requirements of the environment. This is sessions we will talk about the HA capabilities SQL Server offers for deployments to Public/Private clouds and across deployment types like Bare-Metal, VMs and containers. Additionally we will also present customer reference architectures being used to run mission critical workloads.

SessionID: 88785

Understanding Relationships in Power BI

Back to calendar

Event Date: 07-02-2019 21:20 - Category: Breakout Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Alberto Ferrari

Title: Understanding Relationships in Power BI

Description:

Relationships are the foundation of any Power BI or Analysis Services Tabular data model with multiple entities. At first sight, this is a trivial concept, especially if one has a knowledge of relational data modeling. However, the ability to create multiple relationships between the same tables and the existence of bidirectional filters increase the complexity of this topic. In this session, we will discover the complexity behind relationships and how they work in complex and potentially ambiguous data models.

SessionID: 88773

Building Trust in Teams

Back to calendar

Event Date: 07-02-2019 22:40 - Category: Breakout Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Richard Campbell

Title: Building Trust in Teams

Description:

Today businesses run on software, and the quality of that software is directly affected by the level of trust the team members responsible for that software have with each other - from management to developers to operations folks to data administrators - everyone has a hand in the success of software, but without trust, that success is hampered. What can you do to improve the levels of trust in your team? Join Richard Campbell as he discusses his experiences building trust within teams with time, effort, honesty and pizza.