sqlsathistory

Nr: 778

Back to Main list

SQLSaturday #778 - Memphis 2018

Start Time (24h)	Speaker	Track	Title
08:45:00	Kevin Boles	Application Database Development	Know What Your Code is Doing to SQL Server!
08:45:00	Jandee Richards	Cloud Application Development Deployment	Azure Databricks 101
08:45:00	Louis Davidson	Application Database Development	Database Design Fundamentals
10:00:00	Ed Watson	BI Platform Architecture, Development Administration	A Beginner's Guide to Power BI
10:00:00	Amie Mason	Advanced Analysis Techniques	Azure Intelligent Services
10:00:00	Brian Hansen	Enterprise Database Administration Deployment	Let's Explore SQL Internals
11:15:00	Chris Hyde	Analytics and Visualization	Python in SQL Server 2017
11:15:00	DeNisha Malone	BI Platform Architecture, Development Administration	Best Practices for Power BI Desktop
11:15:00	Amy Herold	Enterprise Database Administration Deployment	The Case for Change: Identifying and Remedying Bad Code
13:30:00	Dan Evans	BI Platform Architecture, Development Administration	Power BI administration made easy(ier)
13:30:00	Peter Shore	Cloud Application Development Deployment	Hello My Friends, Welcome to CosmosDB
13:30:00	Pete Brown	Application Database Development	Intro to PowerShell for DBAs
14:45:00	Daniel Glenn	Cloud Application Development Deployment	Using Your On-prem Data in a Cloud World
14:45:00	Paul Popovich Jr	Enterprise Database Administration Deployment	SQL on Linux and Docker 101
14:45:00	Warren Sifre	BI Platform Architecture, Development Administration	Introduction to BI Architecture
14:45:00	Enrique Bañuls	Application Database Development	Columnstore in Real Life

SessionID: 80240

Know What Your Code is Doing to SQL Server!

Back to calendar

Event Date: 06-10-2018 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Know What Your Code is Doing to SQL Server!

Abstract:

ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance, concurrency and scalability you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from the same flaws.

SessionID: 84499

Azure Databricks 101

Back to calendar

Event Date: 06-10-2018 - Session time: 08:45:00 - Track: Cloud Application Development Deployment

Speaker: Jandee Richards

Title: Azure Databricks 101

Abstract:

In the fast-changing landscape of Big Data Analytics one tool has emerged as the standard; Apache Spark. Azure Databricks combines the best of Apache Spark and Azure. Azure Databricks is a cloud-based Analytics Platform built on Apache Spark with built-in integration to Azure: SQL Data Warehouse, Cosmos DB, Data Lake Store, Event Hubs, and Data Factory. In this session; we will cover the history of Databricks, review capabilities, and discuss Use Cases Best Practices. The session will also show you how to get started with Azure Databricks with a demo on setting up your first Azure Databricks Cluster using a data streaming example.

SessionID: 85121

Database Design Fundamentals

Back to calendar

Event Date: 06-10-2018 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

SessionID: 80136

A Beginner's Guide to Power BI

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: A Beginner's Guide to Power BI

Abstract:

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.

SessionID: 84482

Azure Intelligent Services

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

Speaker: Amie Mason

Title: Azure Intelligent Services

Abstract:

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.

SessionID: 84849

Let's Explore SQL Internals

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Let's Explore SQL Internals

Abstract:

Have you ever wondered how SQL Server stores your data? With so many ways that it can be done, we couldn't possibly cover everything in this session, but we'll discuss the fundamental building blocks that SQL uses to organize data into usable units. We'll also see how we can peek under the covers to actually view some of the strutures involved. Why? Because understanding how the pieces fit together will help you to design better, more efficient databases and tables, as well as providing knowledge of a critical component of how the SQL optimizer comes up with query plans.

SessionID: 84049

Python in SQL Server 2017

Back to calendar

Event Date: 06-10-2018 - Session time: 11:15:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 84220

Best Practices for Power BI Desktop

Back to calendar

Event Date: 06-10-2018 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: DeNisha Malone

Title: Best Practices for Power BI Desktop

Abstract:

What are some do's and dont's when developing reports/dashboard in Power BI? This quick session will change the way you use Power BI forever!

I will include tips and tricks to get the best out of report development.

SessionID: 84660

The Case for Change: Identifying and Remedying Bad Code

Back to calendar

Event Date: 06-10-2018 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: The Case for Change: Identifying and Remedying Bad Code

Abstract:

There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one "perfect storm" that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it's a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance.

How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.

SessionID: 80369

Power BI administration made easy(ier)

Back to calendar

Event Date: 06-10-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dan Evans

Title: Power BI administration made easy(ier)

Abstract:

Now that you have Power BI in your organization the fun has just started! Making sure users get the best experience requires some thought and planning though. Come learn the fundamentals of the Power BI architecture and hear about best practices with assigning licenses, delegating roles, audit log analysis, gateway management and overall Power BI administration based on real-world experiences.

SessionID: 80793

Hello My Friends, Welcome to CosmosDB

Back to calendar

Event Date: 06-10-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Peter Shore

Title: Hello My Friends, Welcome to CosmosDB

Abstract:

Microsoft says Azure Cosmos DB is a globally distributed, multi-model database. Your reaction might be something like, “what the heck is it”, “why would I use it”, or “how do I use it”. The fundamental purpose of this session is to answer those very questions. After briefly discussing what CosmosDB is, we’ll take some time to discuss why you might use CosmosDB instead of SQL Server or another platform, and finally touch on some basics to get you started with CosmosDB. Upon completion of this session you will be better equipped to discuss the value of CosmosDB to your organization.

SessionID: 85267

Intro to PowerShell for DBAs

Back to calendar

Event Date: 06-10-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Pete Brown

Title: Intro to PowerShell for DBAs

Abstract:

PowerShell can be an invaluable tool for DBAs, greatly reducing time spent on repetitive tasks. In this session we will provide an introduction to PowerShell and perform some common administrative functions using the SqlServer PowerShell module built into SSMS 2016.

SessionID: 80137

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 06-10-2018 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Daniel Glenn

Title: Using Your On-prem Data in a Cloud World

Abstract:

Microsoft Power BI, Flow, and PowerApps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.

In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Office 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Office 365 and SharePoint Server 2016.

SessionID: 80366

SQL on Linux and Docker 101

Back to calendar

Event Date: 06-10-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Paul Popovich Jr

Title: SQL on Linux and Docker 101

Abstract:

By now you've heard that SQL Server is available on various flavors of Linux and Docker. Join me in this session to go through the basics of these technologies. I want to show you how to setup, install, configure, and have a database to insert some data into and query. Then I want to go through your tool management options. All in all I hope to leave you with the ability to take this to your shop to see where it might make sense to use in the future.

SessionID: 82481

Introduction to BI Architecture

Back to calendar

Event Date: 06-10-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Warren Sifre

Title: Introduction to BI Architecture

Abstract:

There is a ton of buzz in the market about BI, but do we really know what is BI Architecture? We will go over an ideal architecture design and explain the various elements and tools that make up this architecture. We will use the Microsoft BI Stack as a perspective, but architecture can be replicated with various vendor tools.

SessionID: 86359

Columnstore in Real Life

Back to calendar

Event Date: 06-10-2018 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Enrique Bañuls

Title: Columnstore in Real Life

Abstract:

In real life, columnstore can be easily configured in the wrong way. In this session we are going to talk about the key points to truly create a real-time operational analytics in our OLTP environments.

This site is open source. Improve this page.