sqlsathistory

Nr: 891

SQLSaturday #891 - Los Angeles 2019

Start Time (24h)	Speaker	Track	Title
08:30:00	Jay Falck	Private and Public Cloud Architecture and Infrastructure	Setting up a test lab with Hyper-V
08:30:00	Ami Levin	Private and Public Cloud Architecture and Infrastructure	Big Data - The Biggest Fad of the Decade
08:30:00	John Wells	Database Administration and Development	Fundamentals That Will Improve Your Query Performance!
08:30:00	David Lundell	Private and Public Cloud Architecture and Infrastructure	Open Source vs SQL Database Maintenance Plans
08:30:00	Kevin Feasel	Data Presentation, Visualization, and Analytics	Applying Forensic Accounting Techniques Using SQL and R
08:30:00	Vlad Vlasceanu	Private and Public Cloud Architecture and Infrastructure	Running SQL Server on AWS
08:30:00	Jeff Prom	Data Presentation, Visualization, and Analytics	Mastering Master Data Services
08:30:00	Amod Singhal	Database Administration and Development	SQL Query Foundations
08:30:00	Brodie Brickey	Database Administration and Development	SSIS Basics
10:00:00	Paul Stanton	Database Administration and Development	SQL DevOps Simplified with Production Databases
10:00:00	Brett Powell	Database Administration and Development	Power BI Administration Solutions
10:00:00	Igal Sapir	Database Administration and Development	Migrate Your Database to PostgreSQL
10:00:00	Mike Burek	Database Administration and Development	Why is Python in SQL Server?
10:00:00	Liz Amador	Data Presentation, Visualization, and Analytics	Designing Accessible Power BI Reports
10:00:00	Jeff Iannucci	Database Administration and Development	SELECT Start FROM Here: Querying for T-SQL Beginners
10:00:00	Jeff Bertman	Private and Public Cloud Architecture and Infrastructure	Maximizing Big Data ROI via Best of Breed Technology Patterns Practices
10:00:00	Andrew Karcher	Private and Public Cloud Architecture and Infrastructure	Getting Started with Azure Databricks Delta
10:00:00	Ted Stathakis	Data Presentation, Visualization, and Analytics	Reporting Services Introduction
10:00:00	Elaena Bakman	Data Presentation, Visualization, and Analytics	SSRS - Thinking Outside the Report
11:30:00	Armando Lacerda	Database Administration and Development	DBA vNext
11:30:00	Armando Lacerda	Data Presentation, Visualization, and Analytics	Power BI Dataset Tuning
11:30:00	DeNisha Malone	Data Presentation, Visualization, and Analytics	Power BI Free vs. Pro vs. Premium - Understanding What Works for You!
11:30:00	Phillip Seamark	Data Presentation, Visualization, and Analytics	Wacky DAX
11:30:00	Suresh Datla	Data Presentation, Visualization, and Analytics	Top features of Power BI you should know
11:30:00	Charles Embry Jr	Database Administration and Development	The Mobile DBA, using Docker and Azure Data Studio to work on the go!
11:30:00	Eric Blinn	Database Administration and Development	Encryption: Not just for the NSA anymore
11:30:00	Andrew Karcher	Database Administration and Development	Add some Spark to your Data Processing Pipeline
11:30:00	Simon Cho	Private and Public Cloud Architecture and Infrastructure	[StepByStep] SQL Server on Container? What is Kubernetes?
11:30:00	Benjamin Nevarez	Database Administration and Development	Dive into the Query Optimizer - Undocumented Insight
11:30:00	Brodie Brickey	Database Administration and Development	Getting Data out of Active Directory with SQL Server
11:30:00	Mohamed Mawla	Private and Public Cloud Architecture and Infrastructure	From Zero to Hero: Start Machine Learning using Azure ML studio
11:30:00	Nuri Halperin	Private and Public Cloud Architecture and Infrastructure	Introduction to MongoDB
11:30:00	SQL Saturday in LA	Data Presentation, Visualization, and Analytics	Metadata Management and Data Governance in the World of CCPA
13:00:00	Armando Lacerda	Database Administration and Development	CosmosDB - Understanding the main factors for successfull deployment
13:00:00	SQL Saturday in LA	Professional Development and Personal Branding	Women in Technology (multiple speakers)
13:00:00	Kevin Mackey	Other	Don't just code it—Generate It
13:00:00	Vlad Vlasceanu	Private and Public Cloud Architecture and Infrastructure	Why Cloud Databases like Amazon Aurora are more Scalable and Reliable
13:00:00	SQL Saturday in LA	Data Presentation, Visualization, and Analytics	Address the Elephant in Your Business
13:00:00	Steve Rezhener	Data Presentation, Visualization, and Analytics	Dynamic data flows in SSIS without programming
13:00:00	JP Chen	Database Administration and Development	SQL on Linux
13:00:00	Soumya Banerjee	Database Administration and Development	A dive into Dimensional Modeling
13:00:00	SQL Saturday in LA	Private and Public Cloud Architecture and Infrastructure	Virtualizing SQL Server on vSphere. Doing it Right!
13:00:00	Satish Jayanthi	Other	Doing Much More With Much Less: The Case for Data Warehouse Automation
13:00:00	SQL Saturday in LA	Data Presentation, Visualization, and Analytics	Dynamic data flows in SSIS without programming
14:30:00	DeNisha Malone	Data Presentation, Visualization, and Analytics	Tell a Story with Data in Power BI
14:30:00	Phillip Seamark	Database Administration and Development	The Art of Data Modelling with Analysis Services
14:30:00	Patrick Partin	Data Presentation, Visualization, and Analytics	What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf
14:30:00	David Lundell	Professional Development and Personal Branding	How to Be an MVP (in Life and a Microsoft MVP)
14:30:00	Kevin Feasel	Private and Public Cloud Architecture and Infrastructure	SQL Server Machine Learning Services in Production
14:30:00	Christopher Dobler	Private and Public Cloud Architecture and Infrastructure	ElasticSearch - A look at the ELK stack and visualizing data with Canvas
14:30:00	Kevin Mackey	Database Administration and Development	Service Broker for near-real time message processing
14:30:00	Jeff Iannucci	Database Administration and Development	It's Not Your Fault, It's the SQL Server Default
14:30:00	Ted Stathakis	Data Presentation, Visualization, and Analytics	Reporting Services: A Smart Migration Strategy
14:30:00	Stacey Broadwell	Professional Development and Personal Branding	Job Seeker BootCamp: Resumes, Interviews Salary Negotiation
16:00:00	Ami Levin	Database Administration and Development	Where did I put my (primary) keys?
16:00:00	John Wells	Database Administration and Development	Simplify your Daily Tasks with DBATools!
16:00:00	Charles Embry Jr	Professional Development and Personal Branding	Imposter Syndrome How to work through it
16:00:00	Eric Blinn	Database Administration and Development	I have indexes, but do I have the right indexes?
16:00:00	Michelle Gutzait	Database Administration and Development	Azure Database, Azure Virtual Machine or Azure Managed Instance? Why, when, what?
16:00:00	Mike Burek	Database Administration and Development	Columnstore Indexes for Everyone
16:00:00	Liz Amador	Data Presentation, Visualization, and Analytics	What you need to know to be Power BI Certified
16:00:00	Arthur Gimpel	Data Presentation, Visualization, and Analytics	Make sense of real-time data using Elasticsearch
16:00:00	Ben Oastler	Data Presentation, Visualization, and Analytics	How to screw up a Power BI implementation
16:00:00	Phil Robinson	Data Presentation, Visualization, and Analytics	Data Preparation with Power BI Desktop M – Strategy, Tactics and Tips
16:00:00	Sepand Gojgini	Database Administration and Development	Columnstore Index Primer
16:00:00	Mark Mucchetti	Private and Public Cloud Architecture and Infrastructure	Google Cloud Platform: Introduction

SessionID: 91847

Setting up a test lab with Hyper-V

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Jay Falck

Title: Setting up a test lab with Hyper-V

Abstract:

So, you want to play with SQL server and/or Windows Server but you don't have extra hardware lying around. In this session I'll go over creating the necessary virtual networking and virtual machines to allow you to do this and protect your local network from possible harm.

SessionID: 91882

Big Data - The Biggest Fad of the Decade

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Ami Levin

Title: Big Data - The Biggest Fad of the Decade

Abstract:

In this session we will investigate what Big Data really means, and more importantly - what it doesn't mean.

What makes Big Data different than any other data? What makes Big Data challenges different than the same old challenges we had 30 years ago?

Together, we will perform an honest, inquisitive, and enlightening investigation of what Big Data really is, it's origins, and how it evolved over the last decade. We will use history, analytics and logic to dissect the beast, and expose it for what it really is.

Why should you care? The Big Data hype is holding you back from doing what is really important with data - getting value out of it. Making sense of it. Vendors, organizations, and architects have become so obsessed with the 'Big Data' fad, and too many either lost sight, or no longer have the resources to pursue their real goals.

In this session I will plea to your reasoning, critical thinking, and plain common sense, to wake up and shout with me "The Emperor has no clo

SessionID: 91944

Fundamentals That Will Improve Your Query Performance!

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Database Administration and Development

Speaker: John Wells

Title: Fundamentals That Will Improve Your Query Performance!

Abstract:

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!

SessionID: 92028

Open Source vs SQL Database Maintenance Plans

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: David Lundell

Title: Open Source vs SQL Database Maintenance Plans

Abstract:

The Database Maintenance plans used to be a one size fits all tool that did a lot of unnecessary work, especially, when it came to indexing. So I have been recommending that clients use other tools such as Ola Hallengren’s award winning free SQL Server Maintenance Solution. So let’s have a showdown at high noon in the Arizona desert and see if Database Maintenance Plans in SQL 2016 and 2017 are now good enough or if we still need to turn to other solutions like Ola’s.

SessionID: 92954

Applying Forensic Accounting Techniques Using SQL and R

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Kevin Feasel

Title: Applying Forensic Accounting Techniques Using SQL and R

Abstract:

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.

SessionID: 93080

Running SQL Server on AWS

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Vlad Vlasceanu

Title: Running SQL Server on AWS

Abstract:

Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most. We will cover Amazon RDS for SQL Server features and the key differences between running deployments on Amazon Elastic Cloud Compute (EC2) and Amazon RDS.

SessionID: 93255

Mastering Master Data Services

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Jeff Prom

Title: Mastering Master Data Services

Abstract:

In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.

SessionID: 93691

SQL Query Foundations

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Database Administration and Development

Speaker: Amod Singhal

Title: SQL Query Foundations

Abstract:

Prerequisite: None. Some prior experience with SQL will be helpful.

This tutorial will focus on crucial foundational knowledge needed to retrieve data from SQL tables, i.e., the “R” (Read) in CRUD. Throughout, the emphasis is on concepts, rules, and avoiding "gotchas" - not on syntax. Topics covered will include: A review of SELECT statement, Logical Execution Order of SQL SELECT’s clauses, How SQL JOINs work, NULL values, etc.

SessionID: 94010

SSIS Basics

Back to calendar

Event Date: 15-06-2019 - Session time: 08:30:00 - Track: Database Administration and Development

Speaker: Brodie Brickey

Title: SSIS Basics

Abstract:

Integration Services (SSIS) can be a very powerful tool for data loading as well as many other functions. In this demo we'll cover some methods for getting started with this program and look at some of the things we can do with SSIS.

SessionID: 91916

SQL DevOps Simplified with Production Databases

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Database Administration and Development

Speaker: Paul Stanton

Title: SQL DevOps Simplified with Production Databases

Abstract:

DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

SessionID: 91972

Power BI Administration Solutions

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Database Administration and Development

Speaker: Brett Powell

Title: Power BI Administration Solutions

Abstract:

Power BI administrators responsible for managing and monitoring a Power BI deployment may develop custom solutions to more efficiently perform their duties and to manage BI resources. This session will walk through the purpose and components of several of these solutions including tenant-wide usage monitoring, user and group profile reports, refresh failure notification emails, and scale up/down Power BI embedded and Azure Analysis Services resources. Technologies to be featured include PowerShell, the Power BI REST API, Azure Active Directory, Power BI Embedded, SQL Server Agent, and Azure Automation.

SessionID: 92044

Migrate Your Database to PostgreSQL

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Database Administration and Development

Speaker: Igal Sapir

Title: Migrate Your Database to PostgreSQL

Abstract:

PostgreSQL, or in its shorter name, Postgres, is a FOSS (Free and Open Source) Database Engine that has gained a lot of traction over the past decade. It is fast, reliable, and scalable, and is used in production by many large organizations around the world.

In this session I will cover a brief overview of Postgres, cover the benefits of migrating to it, and show a demo of you can migrate a SQL Server database to Postgres.

SessionID: 93074

Why is Python in SQL Server?

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Database Administration and Development

Speaker: Mike Burek

Title: Why is Python in SQL Server?

Abstract:

SQL Server 2017 supports Python. Does that seem weird? What can this be used for?

Maybe you heard data scientists like it. Does anyone else? Turns out, Python can be used for DBA and t-sql developer tasks!

Come see how to use Python to import, profile, and manipulate data. We can also create better email with formatted tables and graphs. Maybe you can start using Python in your t-sql code.

SessionID: 93205

Designing Accessible Power BI Reports

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Liz Amador

Title: Designing Accessible Power BI Reports

Abstract:

We'll look at the new features that have rolled out in response to a major push at Microsoft to make Power BI reports more accessible. What some of the different areas of accessibility to think about, and some handy tools to help you make your reports more usable for everyone.

SessionID: 93305

SELECT Start FROM Here: Querying for T-SQL Beginners

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Database Administration and Development

Speaker: Jeff Iannucci

Title: SELECT Start FROM Here: Querying for T-SQL Beginners

Abstract:

Have you been asked to begin querying data in SQL Server databases? Or are you just curious to try T-SQL? Great – let’s get started! In this session we’ll cover the basics of the SELECT statement, your T-SQL tool for getting that data. We’ll also show the individual parts of a query, discuss basic aggregation, and demonstrate common filtering options using operators and functions. You’ll walk away with a solid foundation, ready to start your journey to become a T-SQL expert.

SessionID: 93331

Maximizing Big Data ROI via Best of Breed Technology Patterns Practices

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Jeff Bertman

Title: Maximizing Big Data ROI via Best of Breed Technology Patterns Practices

Abstract:

Not long ago the question was whether your organization had big data. Did you have the volume, the velocity, the technology. Now those basics are largely given for most people attending this event. The path to success is still fuzzy, however, with so many technologies to choose from – and so many ways to use them.

This presentation triangulates in a holistic manner on the modern business dilemma: how can we leverage technology to improve revenue, profit, market share, quality, and numerous other success criteria. That said, this is not about the analytics or KPIs -- although it is about measurable improvement. It’s about lining up the right technologies and using them in effective, proven ways to maximize Return on Investment (ROI). Since the slant here is holistic, we’ll show how to blend infrastructure, tools, methods, and talent to avoid and constantly trim technical debt… and to produce success stories that are consistently repeatable, not a byproduct of individual heroics.

SessionID: 93645

Getting Started with Azure Databricks Delta

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Andrew Karcher

Title: Getting Started with Azure Databricks Delta

Abstract:

Databricks Delta is a single data management tool that combines the scale of a data lake, the reliability and performance of a data warehouse, and the low latency of streaming in a single system for the first time. This session will go over the basics of what Databricks Delta is and how it can be used as part of your Data Platform.

SessionID: 93878

Reporting Services Introduction

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Ted Stathakis

Title: Reporting Services Introduction

Abstract:

This introduction to Reporting Services is for the novice user with no previous exposure to Reporting Services. This session will walk through getting data for the report though publishing and using the report.

Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL: You’ve already paid for it, so put it to use! In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services. From building a data set through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort. Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.

SessionID: 93893

SSRS - Thinking Outside the Report

Back to calendar

Event Date: 15-06-2019 - Session time: 10:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Elaena Bakman

Title: SSRS - Thinking Outside the Report

Abstract:

Most of us use SSRS to create reports, maybe send out notifications or provide data outputs for users to consume, but what if you needed to give your user the ability to run a job on demand, or modify data or execute a SSIS package? Can SSRS do that? Yes it and I will show you how.

SessionID: 91879

DBA vNext

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Database Administration and Development

Speaker: Armando Lacerda

Title: DBA vNext

Abstract:

Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.

Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.

In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.

SessionID: 91880

Power BI Dataset Tuning

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Armando Lacerda

Title: Power BI Dataset Tuning

Abstract:

Most Power BI reports rely on a small dataset. And due to a lighting fast data engine most data model mistakes are shadowed by the speed of the service. When the dataset gets bigger then best data modeling practices are required. The trick here is Power BI data engine is not relational and therefore most data modeling techniques either don’t apply or don’t deliver. In this session we will go over how to model and measure performance for larger Power BI datasets.

SessionID: 91968

Power BI Free vs. Pro vs. Premium - Understanding What Works for You!

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: DeNisha Malone

Title: Power BI Free vs. Pro vs. Premium - Understanding What Works for You!

Abstract:

This session will compare and contrast the 3 levels of a Power BI user. I will review details that make each level unique and also answer any questions you've been needing to resolve about the adoption/administration of the application in your enterprise.

SessionID: 91981

Wacky DAX

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Phillip Seamark

Title: Wacky DAX

Abstract:

Did you know the DAX language is far more capable than merely running a SUM over a column, or counting rows in a table? DAX sits on top of one of the fastest databases around, and this session will explore some unusual and creative scenarios that you previously would have thought as not possible using just DAX.

The session will aim to reset your understanding of what is possible in DAX by walking through some interesting code highlights from a recent series of games built using DAX. Each game pushes and explores different boundaries in DAX and will attempt to show just where those lines are.

The session will hopefully inspire you to add some creative and exciting techniques to your own DAX based data models.

SessionID: 91982

Top features of Power BI you should know

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Suresh Datla

Title: Top features of Power BI you should know

Abstract:

Since the first release 4 years ago. Power BI as a platform has matured very quickly and has become a robust platform for Reporting and Selfserve BI. Several features are added every month to Power BI platform. We have picked up a few of the coolest features and hacks that you can take advantage of.

SessionID: 91986

The Mobile DBA, using Docker and Azure Data Studio to work on the go!

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Database Administration and Development

Speaker: Charles Embry Jr

Title: The Mobile DBA, using Docker and Azure Data Studio to work on the go!

Abstract:

In this session we will go over the steps involved with getting a local Database Development environment set up on your laptop using SQL Server on Linux, Docker and Azure Data Studio. We will go over installation of Docker and SQL Server, tips and tricks on data persistence in Docker, and how to connect and work with SQL Server running Docker using Azure Data Studio, including customizing Azure Data Studio to your needs.

SessionID: 91995

Encryption: Not just for the NSA anymore

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Database Administration and Development

Speaker: Eric Blinn

Title: Encryption: Not just for the NSA anymore

Abstract:

SessionID: 93647

Add some Spark to your Data Processing Pipeline

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Database Administration and Development

Speaker: Andrew Karcher

Title: Add some Spark to your Data Processing Pipeline

Abstract:

Azure Databricks is an Apache Spark-based analytics platform optimized for the Microsoft Azure cloud services platform. Designed with the founders of Apache Spark, Databricks is integrated with Azure to provide one-click setup, streamlined workflows, and an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts. This session will cover the basics of Azure Databricks, how to start developing applications within Azure Databricks.

SessionID: 93849

[StepByStep] SQL Server on Container? What is Kubernetes?

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Simon Cho

Title: [StepByStep] SQL Server on Container? What is Kubernetes?

Abstract:

Docker and Kubernetes are becomes very hot industry since last couple of years.

SQL Server used to run only on Physical machine. Now, it's not any more strange or wrong that SQL server run on VM.

This session is designed for understanding about container and how SQL server could run on container.

There are 2 types of applications, Stateless and Stateful. We will go over the difference between them and will deliver the detail cases how SQL server could adjust in Container environment.

Therefore, developer or DBA could choose better architecture in various conditions.

Within this session will cover what the market demand is and what SQL server can do on the demand.

SessionID: 93888

Dive into the Query Optimizer - Undocumented Insight

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Database Administration and Development

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 94011

Getting Data out of Active Directory with SQL Server

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Database Administration and Development

Speaker: Brodie Brickey

Title: Getting Data out of Active Directory with SQL Server

Abstract:

For many organizations Active Directory is the heart of the Network. In this session we'll cover how to query users from AD groups, query groups within a specific OU, and dynamically get users for all groups in a specific OU. We'll also discuss some of the limitations of ADSI and how to work around it. Finally, we'll use a little SQL and a dash of Powershell and push updates back into Active Directory.

SessionID: 94945

From Zero to Hero: Start Machine Learning using Azure ML studio

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Mohamed Mawla

Title: From Zero to Hero: Start Machine Learning using Azure ML studio

Abstract:

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts.

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on

SessionID: 95275

Introduction to MongoDB

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Nuri Halperin

Title: Introduction to MongoDB

Abstract:

Getting started with MongoDB is not always easy. This gentle introduction goes heavy on the demo to show you what it feels like to use MongoDB as a developer. Rather than relying on extra frameworks and such, we'll access MongoDB directly from the shell and Node, and see how you achieve both simple and complex data manipulation tasks.

Along the way, we'll cuts through some myths and misunderstandings surrounding MongoDB. You will learn what's unique about this database, how best to leverage its capabilities, and be well positioned to decide if this is a good fit for application.

SessionID: 95276

Metadata Management and Data Governance in the World of CCPA

Back to calendar

Event Date: 15-06-2019 - Session time: 11:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: SQL Saturday in LA

Title: Metadata Management and Data Governance in the World of CCPA

Abstract:

SessionID: 91877

CosmosDB - Understanding the main factors for successfull deployment

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Database Administration and Development

Speaker: Armando Lacerda

Title: CosmosDB - Understanding the main factors for successfull deployment

Abstract:

In this session packed with demos you will see how to cross the bridge between SQL Server and Cosmos DB back and forth; how to related items from both sides and what is required to design a CosmosDB deployment.

SessionID: 93207

Women in Technology (multiple speakers)

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Professional Development and Personal Branding

Speaker: SQL Saturday in LA

Title: Women in Technology (multiple speakers)

Abstract:

Session format:

Improve style, no slide deck, no PowerPoint
Multiple speakers, 10 to 15 minutes each
Talk about your career, how you got started, what worked for you, what didn’t, advice on getting ahead, and what you love most about your job Panelists: Elizabeth Amador DeNisha Malone Carmen Honacker Michelle Kamrat Gutzait Elaena Bakman Hue Hoang Stacey Broadwell

SessionID: 93286

Don't just code it—Generate It

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Other

Speaker: Kevin Mackey

Title: Don't just code it—Generate It

Abstract:

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.

Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.

Source to Target mapping documents can be used to generate the code to effect the mapping.
Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
Business rules can be encoded in data and the code to implement them manufactured. Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?

SessionID: 93754

Why Cloud Databases like Amazon Aurora are more Scalable and Reliable

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Vlad Vlasceanu

Title: Why Cloud Databases like Amazon Aurora are more Scalable and Reliable

Abstract:

Amazon Aurora is a fully managed MySQL and PostgreSQL-compatible relational database with the speed, reliability, and availability of commercial databases at one-tenth the cost. It is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. This session provides an overview of Aurora, explores Aurora features, such as serverless, global databases, multi-master, replication and multi-AZ failover, and helps you get started.

SessionID: 94044

Address the Elephant in Your Business

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: SQL Saturday in LA

Title: Address the Elephant in Your Business

Abstract:

The best way to deal with the elephant that takes up residence in every business is to name it and tame it! Bad data is bad for business – costing you 10-25% of revenue, along with poor analytics and unhappy customers.

Join our lunch presentation to learn how to effectively address your elephant. We’ll discuss: • 6 dimensions of Data Quality • Easy tools that can be applied in-line using SSIS SQL Server • How to overcome international data challenges – language, formatting field requirements

SessionID: 94047

Dynamic data flows in SSIS without programming

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Steve Rezhener

Title: Dynamic data flows in SSIS without programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. In contrast, COZYROC's Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated into the SSIS package at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 94469

SQL on Linux

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Database Administration and Development

Speaker: JP Chen

Title: SQL on Linux

Abstract:

SessionID: 94493

A dive into Dimensional Modeling

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Database Administration and Development

Speaker: Soumya Banerjee

Title: A dive into Dimensional Modeling

Abstract:

A dive into the basics and some advanced dimensional modeling concepts and design patterns. Topics covered will be introduction to dimensional modeling and difference from transaction vs analytics consumptions, primary and foreign keys, different types of facts and dimensions, slowly changing dimensions and various types, common design patterns for handling date, time, product, inventory etc.

SessionID: 94539

Virtualizing SQL Server on vSphere. Doing it Right!

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: SQL Saturday in LA

Title: Virtualizing SQL Server on vSphere. Doing it Right!

Abstract:

For most DBAs virtualization is no longer a matter of "If" but "When". This means it is critical for DBAs to understand how this technology works and how we can ensure we get the most performance and scalability out of it. In this session we will look at some of the best practices and gotchas when Designing Standalone and Highly Available SQL deployments in a vSphere environment. We'll also cover how to troubleshoot performance issues when they arise.

SessionID: 94889

Doing Much More With Much Less: The Case for Data Warehouse Automation

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Other

Speaker: Satish Jayanthi

Title: Doing Much More With Much Less: The Case for Data Warehouse Automation

Abstract:

One of the most pervasive problems in BI today is that data warehouses take too long to build and they are too hard to change. According to TDWI, building a data warehouse is among the most labor-intensive and time-consuming activities of BI development. There are so many moving parts—requirements, source data analysis, data quality, source-target mapping, data acquisition, data transformation logic, ETL design, scheduling, error handling—and getting it right the first time isn’t easy. And when you finally do get it right, something changes...

Join data warehouse automation pioneer WhereScape for this presentation to learn how companies like Nike, Costco, Cornell University, WSU, Daimler, Blue Cross, F5 accelerate warehouse development and change cycles while simultaneously assuring quality and consistency. A key aspect of doing automation right is that it should not get in the way of your developers – it should leverage existing skills, add best practices and generate documentation.

SessionID: 94947

Dynamic data flows in SSIS without programming

Back to calendar

Event Date: 15-06-2019 - Session time: 13:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: SQL Saturday in LA

Title: Dynamic data flows in SSIS without programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. In contrast, COZYROC's Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated into the SSIS package at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 91967

Tell a Story with Data in Power BI

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: DeNisha Malone

Title: Tell a Story with Data in Power BI

Abstract:

Got lot's of data, but not sure what to do with it?

This session will give you the steps to get the most insightful story from you dataset! We will also review Power BI Best Practices for everyday developers

SessionID: 91980

The Art of Data Modelling with Analysis Services

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Database Administration and Development

Speaker: Phillip Seamark

Title: The Art of Data Modelling with Analysis Services

Abstract:

Modern data modelling is indeed an art form, and Azure Analysis Services provides a canvas which the data artist can create beautiful and stunning masterpieces.

This session will not only focus on the critical elements required to ensure your creation is a work of art but also cover aspects of data modelling specific to Analysis Services. The session will cover tips, tools and helpful info on building efficient data models that can scale in any of the tools that make use of the AS engine (Power BI, Excel and Analysis Services)

SessionID: 92005

What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Patrick Partin

Title: What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf

Abstract:

You wear many hats, know your KPI, fight those fires, and are used to -- but still scared of -- "hey, what just happened?"

As a DBA, you very likely have SQL Server well covered, but what about if/when you support Cassandra? Mongo? MySQL? What if you're DevOps and need something from ASP .Net? IIS? Nginx?

In this interactive session, we'll go over show you how to locally install and configure InfluxDB to store your data, get Telegraf to pull, and with Grafana, create some quick dashboards. Time permitting, we can set some thresholds, and send them to Slack.

All of these tools are completely free, and if you don't have the right monitoring, or any, this is perfect for you.

SessionID: 92026

How to Be an MVP (in Life and a Microsoft MVP)

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Professional Development and Personal Branding

Speaker: David Lundell

Title: How to Be an MVP (in Life and a Microsoft MVP)

Abstract:

SessionID: 92955

SQL Server Machine Learning Services in Production

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Kevin Feasel

Title: SQL Server Machine Learning Services in Production

Abstract:

Writing code which uses SQL Server Machine Learning Services is easy enough, but that is just the beginning of the story. In this talk, we will cover the rest of the R development story for database administrators. We will look at the methods available to install and maintain R packages, learn good practices for deploying and maintaining custom SQL Server Machine Learning Services code, and learn where to find critical information when things break. These battle-tested tips will make it easier for you to integrate R and SQL Server Machine Learning Services in your existing deployment processes and get the most out of this feature.

SessionID: 93013

ElasticSearch - A look at the ELK stack and visualizing data with Canvas

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Christopher Dobler

Title: ElasticSearch - A look at the ELK stack and visualizing data with Canvas

Abstract:

My company uses a NoSQL style database engine. As such we have no access to standard database functions like relational queries. To get around this we built an ElasticSearch caching layer on top of our database to make complex queries, but we got so much more than just a caching layer by choosing ElasticSearch.

In this talk we will cover a variety of out of the box features you get with ElasticSearch, why ElasticSearch is so popular, and what it can do for your company, even if you don't have the type of database handicaps a noSQL install might create.

SessionID: 93285

Service Broker for near-real time message processing

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Database Administration and Development

Speaker: Kevin Mackey

Title: Service Broker for near-real time message processing

Abstract:

If you've learned the basics of Service Broker, this discussion will help you understand how to design a Service Broker architecture that allows for near real time message processing from external sources.

In this case, see a system designed to handle 5 million varied messages an hour in less than 750 milliseconds per message across multiple, distributed commodity SQL Servers. Discussion of service broker design and optimization, conversation management, error handling and logging, and operational metrics.

SessionID: 93304

It's Not Your Fault, It's the SQL Server Default

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Database Administration and Development

Speaker: Jeff Iannucci

Title: It's Not Your Fault, It's the SQL Server Default

Abstract:

When you see those little green checkmarks, then you know your new SQL Server instance is ready to go, right? Not exactly. Your fresh installation has several questionable default settings that could cause headaches and heartburn in the future. In this session we will identify the instance and database defaults that could lead to disaster. We’ll also discuss how you can modify them to improve performance and avoid unnecessary problems.

SessionID: 93879

Reporting Services: A Smart Migration Strategy

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Ted Stathakis

Title: Reporting Services: A Smart Migration Strategy

Abstract:

With Power BI Report Server, you can host traditional paginated reports alongside Power BI analytical reports, KPIs and mobile reports. This session will show how to use the data in the ReportServer database to determine a smart migration strategy for upgrading to a new SSRS or Power BI Report Server. Starting with the new features of Report Manager, Mobile reports, KPIs and the Mobile Report Publisher app. The session will then focus on how to utilize the report meta data in the ReportServer database, combined with the transaction log table, to show how to determine which reports, data sets and data sources are being used and determine what objects to migrate. Learn how to use PowerShell to extract the reports and data sets from the database, instead of downloading them, to facilitate an easy migration to a new implementation. Also discover a way of determining all TSQL used by the reports. This session is particularly useful for migrating from 2008 but applicable to any migration.

SessionID: 95082

Job Seeker BootCamp: Resumes, Interviews Salary Negotiation

Back to calendar

Event Date: 15-06-2019 - Session time: 14:30:00 - Track: Professional Development and Personal Branding

Speaker: Stacey Broadwell

Title: Job Seeker BootCamp: Resumes, Interviews Salary Negotiation

Abstract:

Job Seeker skills are something you can take with you throughout your career. In this session, Stacey Broadwell will lead attendees through the full lifecycle of job seeking. Resume building, profile advertising, interviewing salary negotiation. Bring your resume and your laptops and lets roll up our sleeves and bust some myths on interviewing.

SessionID: 91881

Where did I put my (primary) keys?

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Database Administration and Development

Speaker: Ami Levin

Title: Where did I put my (primary) keys?

Abstract:

In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.

We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.

SessionID: 91946

Simplify your Daily Tasks with DBATools!

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Database Administration and Development

Speaker: John Wells

Title: Simplify your Daily Tasks with DBATools!

Abstract:

Did you ever wonder if there was one tool you could use to simplify your daily tasks without much effort? There is and it is DBATools! This is an incredible PowerShell Module that will make your life easier. Whether you want to do a quick backup and restore, copy a login to another server, check server settings, check logs, manage a server or do a full migration.

Don’t have any experience with PowerShell? Don’t worry because you don’t have to. Some incredible people in this community have already done the work for you! Come join me in this demo heavy session and we will get you prepared to take advantage of this incredible tool!

SessionID: 91985

Imposter Syndrome How to work through it

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Professional Development and Personal Branding

Speaker: Charles Embry Jr

Title: Imposter Syndrome How to work through it

Abstract:

At one point or another most of us have had that feeling. You feel like you are about to be fired at any moment, like it is only a matter of time until they find out you don't know what you are doing and you are out of your depth. Or maybe you are sitting in a meeting with a group of your peers discussing the project you are working on. You see what you believe to be a large flaw in the current project, yet you do not speak up as you feel like you and not qualified enough to voice your concern. When your coworkers or boss pay you a compliment and try to express how impressed they are with you work or value as an employee do you try to diminish the complement or your value? If you have ever been in one of the situations above you have probably had a case of Imposter Syndrome. In this session we will discuss what Imposter Syndrome is, how it affects people and most importantly how to identify it in yourself and others and some techniques to help you break out of these feelings.

SessionID: 91993

I have indexes, but do I have the right indexes?

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Database Administration and Development

Speaker: Eric Blinn

Title: I have indexes, but do I have the right indexes?

Abstract:

Do you have all the right indexes on your SQL Server databases? Have you implemented any indexes other than traditional clustered and non-clustered indexes? If the answer to either question is a “no” or an “I don’t know”, then this session is for you.

This session will help introduce less commonly used index types and settings along with indexing methodologies. Follow along while we learn which indexes your SQL Server is begging you to make and others it wishes you would drop. Learn use cases for filtered, full-text, and columnstore indexes. There will be plenty of demos and shareable scripts to showcase the benefits too!

Are you using a version and edition of SQL Server is able to use these features? We’ll cover that too and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.

SessionID: 91996

Azure Database, Azure Virtual Machine or Azure Managed Instance? Why, when, what?

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Database Administration and Development

Speaker: Michelle Gutzait

Title: Azure Database, Azure Virtual Machine or Azure Managed Instance? Why, when, what?

Abstract:

So you have already decided to move to Azure but which platform is the best for your databases, from functionality perspective as well as price? In this presentation Michelle will present the advantages and disadvantages of each platform as well as how to choose the best one for your database(s).

SessionID: 93071

Columnstore Indexes for Everyone

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Database Administration and Development

Speaker: Mike Burek

Title: Columnstore Indexes for Everyone

Abstract:

Columnstore indexes are available to all SQL Server editions, Express to Enterprise, starting with SQL Server 2016 Service Pack 1. They can save disk space, increase query performance, and combine OLTP and OLAP workloads. Should you change all your tables to columnstores? Let's find out!

SessionID: 93143

What you need to know to be Power BI Certified

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Liz Amador

Title: What you need to know to be Power BI Certified

Abstract:

Maybe you've played around with Power BI and want to up your game so you can get a job or a raise. Come and learn how Power BI Certification can help you, what's on the exam, and some tips and tricks for studying and taking the test.

SessionID: 93679

Make sense of real-time data using Elasticsearch

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Arthur Gimpel

Title: Make sense of real-time data using Elasticsearch

Abstract:

Elasticsearch is a data store built for addressing various data challenges using the foundations of speed, scale and relevance. It provides advanced querying, search and real-time analytics capabilities. Throughout this talk, Arthur Gimpel, Solutions Architect at Elastic, will introduce Elasticsearch and the Elastic Stack, demonstrate different use cases of using it as a main data store, or alongside with your current databases, using the polyglot persistence architectural approach.

SessionID: 93707

How to screw up a Power BI implementation

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Ben Oastler

Title: How to screw up a Power BI implementation

Abstract:

We’ve all screwed something up, haven’t we? Assembling Ikea furniture, reverse parking…. presenting at a SQL Saturday. Ben was an early adopted of Power BI and thus had to learn a lot of things the hard way. In this presentation, Ben will run you through lessons learnt around the Data Gateway, BI prototyping, report development and deployment, customer engagement and more. Come along to this session to learn about some of the best and worst Power BI Practices.

SessionID: 94077

Data Preparation with Power BI Desktop M – Strategy, Tactics and Tips

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Phil Robinson

Title: Data Preparation with Power BI Desktop M – Strategy, Tactics and Tips

Abstract:

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. Mashups of data from corporate, partner, commercial and public sources are the new normal.

In this presentation we will review traditional strategies for data cleanup, explore Power BI Desktop features for data exploration and look at Power BI Desktop configuration tips. Building readable, reusable and shareable cleanup scripts in M using the Power Query Advanced Editor will also be covered.

SessionID: 94187

Columnstore Index Primer

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Database Administration and Development

Speaker: Sepand Gojgini

Title: Columnstore Index Primer

Abstract:

Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.

SessionID: 94890

Google Cloud Platform: Introduction

Back to calendar

Event Date: 15-06-2019 - Session time: 16:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Mark Mucchetti

Title: Google Cloud Platform: Introduction

Abstract:

Google Cloud Platform provides a vast array of global infrastructure, compute, and storage resources. How do all of these parts work together? How do you manage and monitor serverless applications? This session will provide a survey of GCP offerings, how they can be practically structured and assembled, and how you can get up and running.

This site is open source. Improve this page.