sqlsathistory

Nr: 827

SQLSaturday #827 - Cincinnati 2019

Start Time (24h)	Speaker	Track	Title
08:30:00	Drew Furgiuele	Professional Development	Building the HASSP: Putting SQL Server In Space
08:30:00	Matt Gordon	Enterprise Database Administration Deployment	Azure-d Availability: Scaling SQL Server to the Cloud
08:30:00	Eric Blinn	Enterprise Database Administration Deployment	Encryption: Not just for the NSA anymore
08:30:00	Peter Shore	Cloud Application Development Deployment	Hello My Friends, Welcome to CosmosDB
08:30:00	Vanessa Kesten	BI Platform Architecture, Development Administration	Help Me SSIS Logging, You're My Only Hope!
08:30:00	Sean Forgatch	BI Platform Architecture, Development Administration	Azure Data Factory Ingestion Framework
09:45:00	Andrew Loree	Analytics and Visualization	Microsoft Machine Learning Services
09:45:00	Jim Miller	BI Platform Architecture, Development Administration	Populating a Data Warehouse with SSIS and Biml Patterns
09:45:00	Jess Pomfret	Enterprise Database Administration Deployment	Install Configure SQL Server with PowerShell DSC
09:45:00	Andy Mallon	Application Database Development	Demystifying Data Compression
09:45:00	Elizabeth Noble	Enterprise Database Administration Deployment	Migrate Your Database with Distributed AGs
09:45:00	Slava Trofimov	BI Platform Architecture, Development Administration	Better Together: Power BI Dataflows and Azure Data Lake Storage
11:00:00	Andrew Loree	Cloud Application Development Deployment	Azure Data Studio - The Open-Source, Cross-Platform, Cloud Database Tool for SQL
11:00:00	Peter Shore	Enterprise Database Administration Deployment	Infrastructure for the DBA: An Introduction
11:00:00	David Mellinger	BI Platform Architecture, Development Administration	Azure Migration Options for the SQL Server BI Stack
11:00:00	Jeff Moden	Enterprise Database Administration Deployment	“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance
11:00:00	Julie McLain-Harper	Enterprise Database Administration Deployment	SQL Server Database Security: Do Your Part, Be Security Smart!
11:00:00	Chris Hyde	Advanced Analysis Techniques	Python in SQL Server 2017
12:15:00	Kevin Hill	Enterprise Database Administration Deployment	Your SQL Servers are misconfigured
12:15:00	Ryan Morris	Advanced Analysis Techniques	Snowflake - The Data Warehouse Built For The Cloud
13:30:00	John Deardurff	Application Database Development	A Beginners Guide to Transactions
13:30:00	Mindy Curnutt	Enterprise Database Administration Deployment	AzureVM + Log Shipping + Automation = Bargain Basement DR Solution (How To)
13:30:00	Jeff Moden	Enterprise Database Administration Deployment	“Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.
13:30:00	Joshua Higginbotham	BI Platform Architecture, Development Administration	Optimizing the ETL Development Process with BIML
13:30:00	Allen White	Application Database Development	Get Near Realtime ETL with Service Broker
13:30:00	Josh Burgin	BI Platform Architecture, Development Administration	PBI Dataflows for the BI Pro
13:30:00	Todd Walker	Advanced Analysis Techniques	Getting Started with Azure Databricks
13:30:00	Amy Herold	Enterprise Database Administration Deployment	PowerShell for the DBA
14:45:00	Carl Roepe	Enterprise Database Administration Deployment	How to perform a health check
14:45:00	Kevin Feasel	Analytics and Visualization	Getting Started with Apache Spark
14:45:00	Lucas Feiock	Cloud Application Development Deployment	Lambda architecture design using Azure Databricks for advanced analytics
14:45:00	Jonathan Stewart	Analytics and Visualization	Data Visualization: How to truly tell a great story!
14:45:00	Ed Wagner	Enterprise Database Administration Deployment	DBA - What's Most Important
14:45:00	Lisa Bohm	Application Database Development	The Curious Case of the Foreign Key
14:45:00	Karen Lopez	Application Database Development	Who's Pissing in Your Data Lake?
14:45:00	Alicia Moniz	Advanced Analysis Techniques	AI Cognitive Services: Vision 101
16:00:00	Dave Bland	Enterprise Database Administration Deployment	Statistics - Why are they there and what do I do with them
16:00:00	Sourav Mukherjee	Enterprise Database Administration Deployment	Are you following SQL Server Development Best Practices?
16:00:00	Sam Nasr	Application Database Development	Data Time Travel with SQL Server Temporal Tables
16:00:00	Anthony Mattas	Cloud Application Development Deployment	Deep Into the Cosmos(DB)
16:00:00	Deji Akomolafe	Strategy and Architecture	Successfully Virtualizing SQL Server on vSphere - Straight from the Source
16:00:00	Michael Hewitt	Analytics and Visualization	Applying Visual Design Best Practices in Power BI
16:00:00	Clark Hahn	Strategy and Architecture	Stretch DB – Moving your SQL Server Database to the Cloud One Record at a Time
16:00:00	Dustin Dorsey	Enterprise Database Administration Deployment	Understanding and making good decisions on SQL licensing

SessionID: 86743

Building the HASSP: Putting SQL Server In Space

Back to calendar

Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Professional Development

Speaker: Drew Furgiuele

Title: Building the HASSP: Putting SQL Server In Space

Abstract:

In today's world, technology is a pervasive part of our lives. We have "smart" appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.

The High-Altitude SQL Server Project, or HASSP, is one such project.

The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!

In this session, you'll hear about how this is possible: we'll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you'll see how to recreate (and hopefully improve!) the project on your own.

SessionID: 86842

Azure-d Availability: Scaling SQL Server to the Cloud

Back to calendar

Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Azure-d Availability: Scaling SQL Server to the Cloud

Abstract:

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.

SessionID: 87178

Encryption: Not just for the NSA anymore

Back to calendar

Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Blinn

Title: Encryption: Not just for the NSA anymore

Abstract:

SessionID: 87226

Hello My Friends, Welcome to CosmosDB

Back to calendar

Event Date: 30-03-2019 - Session time: 08: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: 87300

Help Me SSIS Logging, You're My Only Hope!

Back to calendar

Event Date: 30-03-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Vanessa Kesten

Title: Help Me SSIS Logging, You're My Only Hope!

Abstract:

When something goes wrong with your SSIS package and you need to tell your boss more than "I have a bad feeling about this…", let the Force of SSIS logging save you from the dark side!

SSIS logging may be the last thing on your mind when starting a new project, but getting it right in the beginning is well worth your while. Logging can help troubleshoot errors, tackle inefficiencies, and even raise a red flag when there are issues in your data flow. Newer versions of SQL Server have brought new options for logging. Learn what information is available for each option along with how to implement custom logging when the built-in options aren't robust enough for your project's needs.

SessionID: 87798

Azure Data Factory Ingestion Framework

Back to calendar

Event Date: 30-03-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sean Forgatch

Title: Azure Data Factory Ingestion Framework

Abstract:

In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline.

SessionID: 87155

Microsoft Machine Learning Services

Back to calendar

Event Date: 30-03-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Andrew Loree

Title: Microsoft Machine Learning Services

Abstract:

SQL Server 2017 Machine Learning Services is more than just R and Python language support for SQL Server. SQL Machine Learning Services provides analytics for any size of data, runs in SQL Server, or alongside Windows, Linux, HDInsight Spark or Hadoop clusters, is simple to administer and allows you to integrate and deploy simply. In this session, learn architecture and deployment options, stand-alone and in-database, along with some real-world use-cases. Learn how to leverage Machine Learning Services with new TSQL language support, training and deploying models, scaling beyond memory with RevoScaleR to generating millisecond predictions in-database. With any size data environment, SQL Machine Learning Services can provide analytics in both an operationally sound and easy to administer paradigm.

A beginner level understanding of Machine Learning and process is highly recommended but not required. Beyond SQL Machine Learning Services, an overview of all Microsoft Machine Learning

SessionID: 87309

Populating a Data Warehouse with SSIS and Biml Patterns

Back to calendar

Event Date: 30-03-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jim Miller

Title: Populating a Data Warehouse with SSIS and Biml Patterns

Abstract:

This session will demonstrate how to leverage "Biml powered SSIS Patterns", to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to any ETL/ETL scenarios. The components used during this session: BimlSnap_v2 (an Open-Source, Biml integrated SQL Server database), and BimlExpress (a Visual Studio Add-in used to generate SSIS package) are both available at no charge. In addition, attendees will receive a 'SQL Server Metadata Manager' solution, along with a fully integrated SSIS Framework.

Attend to see how Biml can revolutionize your SSIS development!

SessionID: 89429

Install Configure SQL Server with PowerShell DSC

Back to calendar

Event Date: 30-03-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jess Pomfret

Title: Install Configure SQL Server with PowerShell DSC

Abstract:

Get on the cutting edge by implementing infrastructure as code for your SQL Server environment. Using PowerShell Desired State Configuration (DSC) we'll look at how to take a newly built Windows Server and get it ready for prime time while discussing the benefits associated with infrastructure as code.

Setup Pre-Requisites
Install SQL Server
Configure SQL Server
Make SQL Server Application Ready

SessionID: 89537

Demystifying Data Compression

Back to calendar

Event Date: 30-03-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Andy Mallon

Title: Demystifying Data Compression

Abstract:

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

SessionID: 89577

Migrate Your Database with Distributed AGs

Back to calendar

Event Date: 30-03-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Elizabeth Noble

Title: Migrate Your Database with Distributed AGs

Abstract:

You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session expects that attendees are already familiar with Availability Groups.

SessionID: 89712

Better Together: Power BI Dataflows and Azure Data Lake Storage

Back to calendar

Event Date: 30-03-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Slava Trofimov

Title: Better Together: Power BI Dataflows and Azure Data Lake Storage

Abstract:

Power BI Dataflows bring advanced self-service data preparation capabilities to power users and business analysts. Azure Data Lake Storage offers massively scalable and performant storage solution for enterprise big data analytics. The ability to integrate Power BI Dataflows with Azure Data Lake Storage promises to open a new set of opportunities for collaboration between business analysts, data engineers, and data scientists. In this demo-rich session, we’ll take a look at an example of such collaborations and discuss the questions and limitations that you should consider as you begin working with these services.

SessionID: 87153

Azure Data Studio - The Open-Source, Cross-Platform, Cloud Database Tool for SQL

Back to calendar

Event Date: 30-03-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Andrew Loree

Title: Azure Data Studio - The Open-Source, Cross-Platform, Cloud Database Tool for SQL

Abstract:

Azure Data Studio (formerly SQL Operations Studio) is the modern, cross-platform database management tool for SQL Server, both on-premise and in the cloud. A simple, clean approach to a UI creates an experience different from other SQL management tools today. Fully integrated intellisense with customizable code-snippets, connection management, and dashboards, Azure Data Studio, provides the T-SQL editor experience most of us expect today. Unlike other tools, Azure Data Studio is 100% open-source, easily extensible, and has full integration to modern source control solutions like GIT.

In this session, we introduce Azure Data Studio and interacting with SQL Server environments. We will focus on productivity comparable to SSMS, shortcuts and time savers, as well as how to leverage source control. Lastly, we will cover extending Azure Data Studio by setting up a development environment, and walking through the process of build and debugging a custom dashboard component, using Electron

SessionID: 87227

Infrastructure for the DBA: An Introduction

Back to calendar

Event Date: 30-03-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: Infrastructure for the DBA: An Introduction

Abstract:

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.

SessionID: 88495

Azure Migration Options for the SQL Server BI Stack

Back to calendar

Event Date: 30-03-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Mellinger

Title: Azure Migration Options for the SQL Server BI Stack

Abstract:

The SQL Server Analytics\BI stack is widely used and mature. Azure PaaS offerings have matured greatly well beyond just Azure SQL DB the last couple of years. This session is designed for SQL Server professionals who want to expand their knowledge set to Azure or those interested in learning more about Azure data solution options. The focus will be on SQL Server on-premise (or on Azure VM\IaaS) to Azure equivalences, complementary tools, and hybrid approaches and possible challenges. Azure SQL DB, Azure SQL DW, Azure Data Factory, Azure Analysis Services, Power BI and more will be covered.

SessionID: 88840

“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance

Back to calendar

Event Date: 30-03-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Moden

Title: “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance

Abstract:

Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance.

This isn’t your typical presentation on Index Maintenance.

In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice” methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code. We'll also introduce a new way to graphically see actual index structure using a new "Black Arts" stored procedure called "sp_IndexDNA" that you have to see to believe.

SessionID: 89581

SQL Server Database Security: Do Your Part, Be Security Smart!

Back to calendar

Event Date: 30-03-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Julie McLain-Harper

Title: SQL Server Database Security: Do Your Part, Be Security Smart!

Abstract:

With data being stolen nearly daily from even the most prestigious companies, data security should be at the forefront of all keepers of database servers and server instances. How can your SQL Server data get in the wrong hands? What are some common SQL Server specific security considerations? What are the best practices? When and where should they be implemented? What techniques for security can be used in SQL Server? What can I do as a DBA or Developer to ensure data is secured in all environments? Tips and troubleshooting with real world DevOps experience will be presented to attendees to identify the most common but hardest to resolve issues. Some topics to be discussed will be Data Masking, Security Groups, Named Instance security, and Linked Servers.

SessionID: 89824

Python in SQL Server 2017

Back to calendar

Event Date: 30-03-2019 - Session time: 11:00:00 - Track: Advanced Analysis Techniques

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: 89986

Your SQL Servers are misconfigured

Back to calendar

Event Date: 30-03-2019 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Hill

Title: Your SQL Servers are misconfigured

Abstract:

Your SQL Servers are misconfigured!

And it is probably not your fault.

90% of the SQL Servers I have seen in my 18 year career are just wrong. Not “crash” or “won’t start” wrong. More like “why is the website so slow” wrong.

We are going to roll through a clean install and look at some things that can be made right during the install. And then we will look at some configurations that can only be done after the install.

Things like:

Instant File Initialization Backup Compression MAXDOP TempDB configuration Cost Threshold for Parallelism And more if we have time!

Fair warning…I’m going to overuse the phrase “It Depends”

Dallas DBAs is dedicated to helping you find these issues, test them, remediate them and get the most stability, reliability and performance out of your SQL Server.

SessionID: 91525

Snowflake - The Data Warehouse Built For The Cloud

Back to calendar

Event Date: 30-03-2019 - Session time: 12:15:00 - Track: Advanced Analysis Techniques

Speaker: Ryan Morris

Title: Snowflake - The Data Warehouse Built For The Cloud

Abstract:

Come by the Snowflake booth to learn more.

SessionID: 86718

A Beginners Guide to Transactions

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: John Deardurff

Title: A Beginners Guide to Transactions

Abstract:

This session is for the absolute beginner to learn the basics of Transactions and will answer questions such as, What is a Transaction? What are the ACID properties of a Transaction? How does the Transaction Log work to provide consistency to a database? What is a checkpoint? Are dirty pages bad or good? What is a lock? The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.

SessionID: 88279

AzureVM + Log Shipping + Automation = Bargain Basement DR Solution (How To)

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Mindy Curnutt

Title: AzureVM + Log Shipping + Automation = Bargain Basement DR Solution (How To)

Abstract:

Operating on a budget can result in some creative solutions. Recently I've come up with a creative solution for traditional on-premise client-server solutions that allows for full redundancy in the cloud, but at a budget price. This is accomplished through VMs, copying of logs to Blob Storage, automation of hydration, updates de-allocation. It may be a bit of a Rube Goldberg machine, but it works! The result is an extremely pro-rated and affordable DR solution that is within 1 hour or less of production in restorability. Come to this session to learn more about the hurdles faced when putting this solution together and to brainstorm together how it can even be improved.

SessionID: 88841

“Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Moden

Title: “Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.

Abstract:

Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance.

This isn’t your typical presentation on Index Maintenance.

In this second of two back-to-back sessions, we’ll learn of several incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it, virtually eliminate “Bad” page splits, reduce wasted memory, make your log file log file backups a whole lot more happy and increase the overall performance of even perfect code.

We’ll also learn that no simple method is a panacea, what to do about the horror of "expAnsive" updates, and how to make even GUID-keyed indexes work well.

SessionID: 88855

Optimizing the ETL Development Process with BIML

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Joshua Higginbotham

Title: Optimizing the ETL Development Process with BIML

Abstract:

In this discussion, we will overview the benefits Biml can bring to the ETL Development process. How used in conjunction with other languages like SQL and PowerShell, can build out large scale ETL packages in a fraction of the time it would take under traditional SSIS development.

SessionID: 89079

Get Near Realtime ETL with Service Broker

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Allen White

Title: Get Near Realtime ETL with Service Broker

Abstract:

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. This session will demonstrate how to keep your data warehouse updated in near real-time using Service Broker messages from your OLTP database.

SessionID: 89502

PBI Dataflows for the BI Pro

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Josh Burgin

Title: PBI Dataflows for the BI Pro

Abstract:

New Power BI features such as Dataflows are blurring the lines between a citizen BI developer's role and a professional BI developer's role. In this session we'll look at how PBI Dataflows should be used by a professional BI developer (hint... AI is one reason) and when more robust analytic tools should be used.

SessionID: 89671

Getting Started with Azure Databricks

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Todd Walker

Title: Getting Started with Azure Databricks

Abstract:

Azure Databricks is gaining a large amount of momentum as it helps many organizations tackle large big data, advanced analytics, and streaming workloads. In this session, you will be introduced to the Azure Databricks platform, how it can fit into your architecture, and how you can get started using the platform today.

SessionID: 90594

PowerShell for the DBA

Back to calendar

Event Date: 30-03-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: PowerShell for the DBA

Abstract:

PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions.

In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.

SessionID: 86907

How to perform a health check

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Carl Roepe

Title: How to perform a health check

Abstract:

Are you uncertain about the health and capacity of your SQL Server? Are you taking over a new server and need to get a better understanding of the health of the server? Are you uncertain if your servers are following industry best practices?

In this session we will start by discussing the importance of performing a Health Check. We will then show how to run the popular Blitz script by Brent Ozar. After that we will review the other key areas to check like the VM configuration, Windows Configuration, SQL Configuration, Security configuration, and Database configuration. Finally, we’ll show how to save the results for capacity and trending analysis

At the end of the session you will be able to: (1) Perform a Health Check on a server; (2) List the key areas for improvement; (3) Save the results for capacity and trending analysis.

SessionID: 87120

Getting Started with Apache Spark

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Getting Started with Apache Spark

Abstract:

As companies work to gain insight from ever-increasing amounts of data, data platform practitioners need tools which can scale along with the data. Early big data solutions in the Hadoop ecosystem assumed that data sizes overwhelmed available memory, emphasizing heavy disk usage to coordinate work between nodes. As the cost of memory decreases and the amount of memory available per server increases, we see a shift in the makeup of big data systems, emphasizing heavy memory usage instead of disk. Apache Spark, which focuses on memory-intensive operations, has taken advantage of this hardware shift to become the dominant solution for problems requiring distributed data. In this talk, we will take an introductory look at Apache Spark. We will review where it fits in the Hadoop ecosystem, cover how to get started and some of the basic functional programming concepts needed to understand Spark, and see examples of how we can use Spark to solve issues like calculating PageRank.

SessionID: 87136

Lambda architecture design using Azure Databricks for advanced analytics

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Lucas Feiock

Title: Lambda architecture design using Azure Databricks for advanced analytics

Abstract:

In this session, we will review the history of Azure Databricks, world records it broke, and how to accelerate your data platform solutions. We will cover lambda architecture, Azure Databricks components, and how to integrate other Microsoft Azure services. Then we will see a demonstration on creating clusters, notebooks, team collaboration, and advanced analytics. Finally, we will take a look at additional information on how to further utilize Azure Databricks.

SessionID: 89368

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 89379

DBA - What's Most Important

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Wagner

Title: DBA - What's Most Important

Abstract:

There are so many topics for a DBA to focus on that it can be overwhelming, especially for a new or accidental DBA. Without knowing what's most important, you can find yourself spending lots of time trying to figure out what's important. This session focuses on the five topics that matter most to a DBA, whether you're an aspiring DBA, a new DBA or a seasoned professional.

SessionID: 89448

The Curious Case of the Foreign Key

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Lisa Bohm

Title: The Curious Case of the Foreign Key

Abstract:

Foreign keys are basic constraints used widely in database design. This session will show how they can improve performance when used correctly. There are, however, some options that developers need to use with care because they can degrade performance significantly... and sneakily!

SessionID: 89642

Who's Pissing in Your Data Lake?

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Karen Lopez

Title: Who's Pissing in Your Data Lake?

Abstract:

The new data terms of Data Lake, Data Reservoir, and Data Swamp have left me with more questions than answers. In this presentation, Karen discusses the types of data anomalies that organizations can run into when they use external data, the wrong datasets for the right reasons and the right datasets for the wrong reasons.

These errors in design, oversights and old school, traditional practices can impact the success of your projects, even if you don't use any data lakes.

We'll look at end-to-end processes, data capture issues, impractical designs, balancing performance against data quality. I'll be using examples from my own personal data to show you just how my data has been mistreated in IT systems. Plus we'll talk about your data and your data stories.

We will build a list of good practices and tools to use to spare you from a flood of data issues in your organization.

SessionID: 91562

AI Cognitive Services: Vision 101

Back to calendar

Event Date: 30-03-2019 - Session time: 14:45:00 - Track: Advanced Analysis Techniques

Speaker: Alicia Moniz

Title: AI Cognitive Services: Vision 101

Abstract:

Are you curious about Visual Recognition and Object Detection in Azure? Are you wondering what the difference is between the Computer Vision API and the Custom Vision API? Do you want a quick introduction to get you up to speed on both, so that you can quickly build and deploy a Cognitive Services model?

Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.

In this session, we will look at the basics of Cognitive Services Vision. First learn how to create your Cognitive Services model. Then you can see how to train and improve accuracy. Finally, we will step through python code in Azure Notebooks to call the APIs.

SessionID: 86820

Statistics - Why are they there and what do I do with them

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Statistics - Why are they there and what do I do with them

Abstract:

In this session you will learn the basics of statistics and what they are used for. You will learn how to gather information about the statistics and how to use the information to improve performance. It is important the statistics are maintained to work properly so we will also discuss what on going maintenance should be done on statistics.

SessionID: 88003

Are you following SQL Server Development Best Practices?

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sourav Mukherjee

Title: Are you following SQL Server Development Best Practices?

Abstract:

Coding is always a fun but challenging job. Developers do not only have to execute the right output based on the business requirement but also need to maintain right coding standards by using the optimum use of variable sizes and keeping in view the other best practices. The session will cover the key best practices which developers can follow and get benefited.

Many of us already may have been using these steps already but for those who are new to the development process or want to brush up, the session is for you.

SessionID: 88566

Data Time Travel with SQL Server Temporal Tables

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Sam Nasr

Title: Data Time Travel with SQL Server Temporal Tables

Abstract:

Many times developers have to support users by answering the “What happened to the data?” The task of retrieving data from a specific point in time is not an easy one. Often this involves retrieving a backup and restoring the data in question (hopefully!). SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups. With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.

SessionID: 88926

Deep Into the Cosmos(DB)

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Anthony Mattas

Title: Deep Into the Cosmos(DB)

Abstract:

Have you ever wanted to see what an end-to-end solution looks like with Cosmos DB? Well look no further, in this session we will be pulling back the covers and walking through a scenario (with code) which is using Cosmos DB, Databricks, and Machine Learning to create great experiences for retail customers.

SessionID: 89246

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Strategy and Architecture

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i

SessionID: 89461

Applying Visual Design Best Practices in Power BI

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Analytics and Visualization

Speaker: Michael Hewitt

Title: Applying Visual Design Best Practices in Power BI

Abstract:

This session will focus on the how to of visual design in Power BI and equip you to take your report designs to the next level! We will create and implement custom report themes, demo how to design reports for different audiences in your organization and explore how to use Power BI's out of the box formatting options to help you deliver consistent and effective reports.

SessionID: 89634

Stretch DB – Moving your SQL Server Database to the Cloud One Record at a Time

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Strategy and Architecture

Speaker: Clark Hahn

Title: Stretch DB – Moving your SQL Server Database to the Cloud One Record at a Time

Abstract:

Ok… so maybe it is 9,999 records at a time. New with SQL Server 2016, this technology allows a hybrid way to separate their cold and hot data with minimal code changes.

Clark will share his real world experience with trying to implement Stretch DB as well as a demonstration of the setup using both the wizard and T-SQL scripts.

SessionID: 89709

Understanding and making good decisions on SQL licensing

Back to calendar

Event Date: 30-03-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dustin Dorsey

Title: Understanding and making good decisions on SQL licensing

Abstract:

SQL licensing is not the most exciting part of the job for a lot of people, but it is one of the most expensive. The decisions that are made regarding this can have a significant cost benefit or consequence to your organization. In this session, we will dive through each of the ways you can license, review common misconceptions and discuss optimization opportunities you can start using immediately.

This site is open source. Improve this page.