sqlsathistory

Nr: 951

Back to Main list

SQLSaturday #951 - Tampa 2020

Start Time (24h) Speaker Track Title
09:00:00 John Sterrett Cloud Application Development Deployment Getting Started: Introduction to Azure SQL Database
09:00:00 Jean Joseph Enterprise Database Administration Deployment HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES
09:00:00 Rick Heiges Professional Development An Examination of Today's Certifications
09:00:00 Dustin Ryan Analytics and Visualization Welcome to Azure Synapse
09:00:00 Sergiy Lunyakin Application Database Development Let’s democratize Spark for .NET developers
09:00:00 Buck Woody Advanced Analysis Techniques Artificial Intelligence, Machine Learning and Deep Learning Explained
09:00:00 Thomas Grohser Application Database Development Scaling Clustered Column Store Indexes
09:00:00 Monica Rathbun Enterprise Database Administration Deployment Mastering TempDB
09:00:00 Daniel Cai BI Platform Architecture, Development Administration Load a Data Warehouse using SSIS
09:00:00 Dan King Analytics and Visualization PowerBI and PowerApps Married at First Sight
09:00:00 Deji Akomolafe Cloud Application Development Deployment Successfully Virtualizing SQL Server on vSphere - Straight from the Source
09:00:00 Jeffrey Garbus Application Database Development Indexing for performance
10:15:00 Srikrishna Krishnarao Srinivasan Advanced Analysis Techniques Machine Learning with AzureML and Microsoft Excel API
10:15:00 Mohammad Darab Enterprise Database Administration Deployment Big Data Clusters for the Absolute Beginner
10:15:00 Jeff Taylor Application Database Development What's New In SQL Server For The Developer
10:15:00 Dale Sullenberger Professional Development Starting a Career in IT - Ask the Panel!
10:15:00 Donna Ellis Wilson Professional Development Failure needs to be an option.
10:15:00 Harvey Hyman Application Database Development SQL Server SSMS Fundamentals for Beginners
10:15:00 Dustin Dorsey Cloud Application Development Deployment Azure Cost Management
10:15:00 Jonathan Kehayias Application Database Development Eliminating Anti-Patterns and RBAR for Faster Performance
10:15:00 George Walkey Enterprise Database Administration Deployment Using Powershell to Document SQL Server
10:15:00 Frank Quintana Information Delivery “The different faces of Information: Data Modeling and the Data Profession in the 21st Century”
10:15:00 ALAN FERRANDIZ LANGLEY Analytics and Visualization Data Science, Analytics, and Storytelling Tools
10:15:00 Jeremy Frye BI Platform Architecture, Development Administration PowerApps and AI: A Flow of Location Events
10:15:00 Paul Turley BI Information Delivery The District Dashboard: Modeling Reporting Solutions for Public Education
11:30:00 Rick Heiges Professional Development Getting Noticed
12:00:00 Marsha Pierce Enterprise Database Administration Deployment How To Talk To Your Storage Admin
12:00:00 Daniel Cai BI Platform Architecture, Development Administration KingswaySoft - Supercharge your ETL Development with Advanced SSIS Components
13:15:00 Aaron Cutshall Application Database Development Tally Ho! -- Explore the Varied Uses of Tally Tables
13:15:00 Rob Volk Enterprise Database Administration Deployment That's So Metadata: Discover Your Database From The Inside
13:15:00 Michael Antonovich BI Platform Architecture, Development Administration The Power of Power BI Themes or I Haven't Written Themes Since High School
13:15:00 Kevin Feasel Application Database Development Data Virtualization with PolyBase
13:15:00 Dale Sullenberger Professional Development Data and the Data Professionals Future - Ask the Panel
13:15:00 Eric Cobb Application Database Development Exploring The JSON Features In SQL Server
13:15:00 Andy Warren Enterprise Database Administration Deployment Deploying Database Changes Without Taking an Outage
13:15:00 Jose Chinchilla Cloud Application Development Deployment Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.
13:15:00 Suzanne Ricci Professional Development How to Beat the ATS
13:15:00 Chad Buher BI Platform Architecture, Development Administration Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks
13:15:00 Shawn Meyers Enterprise Database Administration Deployment Intelligent Infrastructure for the DBA
13:15:00 Diane Schuster BI Platform Architecture, Development Administration CozyRoc: Dynamic Data Flows in SSIS Without Programming
14:30:00 Jack Corbett Enterprise Database Administration Deployment dbatools - A PowerShell Toolkit for the DBA
14:30:00 Dave Mason Compliance and Security Auditing and Taming SQL Server Permissions
14:30:00 Carolyn Risk Application Database Development MA + THE - E = Aggravated with Aggregation
14:30:00 Mindy Curnutt Application Database Development An Introduction to Spatial Data in SQL Server
14:30:00 Dale Sullenberger Professional Development Switching to an IT Career - Ask the Panel
14:30:00 Ganesh Lohani Analytics and Visualization Data Science 101: An Introduction to Data Science Using Python
14:30:00 Nem Schlecht Application Database Development Maximizing SQL Server Management Studio for Developers and DBAs
14:30:00 David Patrick Cloud Application Development Deployment Intro to Azure for SQL Geeks
14:30:00 Jignesh Patel Other Powershell for DBA to day to day stuff
14:30:00 Eddy Djaja Application Database Development Instant SQL Sandbox Using Docker
14:30:00 Jonathan Kehayias Application Database Development Deadlocking for Mere Mortals
14:30:00 TBTLA Tampa Bay Technology Leadership Association Professional Development From Tech to Lead - Transitioning from a Technician to a Leader
14:30:00 Dmitri Korotkevitch Enterprise Database Administration Deployment 5 Availability Groups Issues That May Ruin Your Day
14:30:00 Konstantin Melamud Enterprise Database Administration Deployment Performance Tuning - Analyzing Execution Plans
14:30:00 Paul LaGrone BI Information Delivery 2017 SSIS Scale Out for High Availability
15:45:00 Alexander Fleming Application Database Development Working with JSON in SQL Server
15:45:00 Aaron Cutshall Professional Development How To Give a Technical Presentation
15:45:00 Rob Volk Enterprise Database Administration Deployment Revenge: The SQL!
15:45:00 Jeff Taylor Enterprise Database Administration Deployment Top 10 Things DBA's Should Know About Their Infrastructure
15:45:00 Peter Doyle Application Database Development Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less
15:45:00 Oscar Zamora BI Platform Architecture, Development Administration Azure Synapse Analytics against Google BigQuery and Snowflake. What are the main differentiators?
15:45:00 John Wang Strategy and Architecture Introduction to IoT using Azure
15:45:00 Matt Gordon Enterprise Database Administration Deployment Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio
15:45:00 Marsha Pierce Strategy and Architecture The Future Is Here for Containers!
15:45:00 Frank Gill Enterprise Database Administration Deployment Performance Improvements in SQL Server 2019
15:45:00 Harvey Hyman Strategy and Architecture Normal Forms Made Easy
15:45:00 Adriano da Silva Analytics and Visualization DAX 360 and Power BI
15:45:00 Rahat Yasir Advanced Analysis Techniques Designing end to end platform for advance data analysis and machine learning on Azure
15:45:00 Sarah Patrick Application Database Development Sarah the Explorer: Navigating and Customizing the SharePoint Interface

SessionID: 100074

Getting Started: Introduction to Azure SQL Database

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: John Sterrett

Title: Getting Started: Introduction to Azure SQL Database

Abstract:

First impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is have a bad first impression. In this session, you will learn the difference between Azure SQL Database, Elastic Pools, Managed Instances, and Hyperscale. You will learn how to test migrations for compatibility issues before you start your migration process. You will learn how to secure your data and also make your data highly available. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload(s) and how to monitor your workload over time to make sure your users have a great experience while you save as much money as possible.

SessionID: 100081

HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jean Joseph

Title: HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES

Abstract:

In this session, I will be talking about performance turning, index design, statistics, query optimizer, parameter sniffing, data types, analyzing and understanding execution plans, wait stats, activity monitor, DMV(s). After this session you should be able to quickly identify the top performance issues of your databases.

SessionID: 100094

An Examination of Today's Certifications

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Professional Development

Speaker: Rick Heiges

Title: An Examination of Today's Certifications

Abstract:

Certifications can set you apart from other candidates. They can also force you to learn new technologies and approaches to business problems. In this session, we will cover Microsoft Certification options centered around data and Azure and which one may be right for you. We will also offer a couple of quick tips on test taking plus how certifications have changed. We will also touch on AWS and GCP certifications.

SessionID: 100127

Welcome to Azure Synapse

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Dustin Ryan

Title: Welcome to Azure Synapse

Abstract:

Microsoft's powerful new service, Azure Synapse, brings together the worlds of data warehousing and big data analytics by providing a unified experience for ingesting, cleansing, modeling, and sharing data. In this session, we'll discuss the basics of Azure Synapse, ideal uses cases for Azure Synapse, and demonstrate how attendees can use Azure Synapse. By the conclusion of this session, attendees will have a deeper understanding of Azure Synapse and how to begin using Azure Synapse.

SessionID: 100759

Let’s democratize Spark for .NET developers

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Sergiy Lunyakin

Title: Let’s democratize Spark for .NET developers

Abstract:

SessionID: 100824

Artificial Intelligence, Machine Learning and Deep Learning Explained

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Advanced Analysis Techniques

Speaker: Buck Woody

Title: Artificial Intelligence, Machine Learning and Deep Learning Explained

Abstract:

What is the difference between Artificial Intelligence, Machine Learning and Deep Learning? And how can each be used? Join Buck Woody, a Data Scientist from the Azure Data team at Microsoft, as he covers simple, clear explanations for these technologies, how they can be applied, and how you can get started learning them yourself. You'll get valuable (free) resources for creating Artificial Intelligence programs, and you'll see examples of code for each area. ​

SessionID: 101435

Scaling Clustered Column Store Indexes

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Thomas Grohser

Title: Scaling Clustered Column Store Indexes

Abstract:

Clustered Column Store Indexes are a great tool when used correctly. This session will explain on how to plan, configure, and operate Clustered Columstore indexes to handle trillions of rows. This is done with a real world example that is in production. Avoiding mistakes in the beginning will save you lots of data wrangling over time.

Come and learn how to partition, select the right datatypes, and insert the data into a Clustered Column Store Index to achieve optimal performance results.

SessionID: 101469

Mastering TempDB

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: Mastering TempDB

Abstract:

Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you'll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.

SessionID: 101655

Load a Data Warehouse using SSIS

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Daniel Cai

Title: Load a Data Warehouse using SSIS

Abstract:

In this session, we will discuss various components available in SSIS to help load a data warehouse, including the data load of dimension and fact tables. We will discuss what to watch for when using the Slowly Changing Dimension (SCD) component, and how you may load into fact tables incrementally on large-scale implementations. As we progress, we will demonstrate some best practices that can be used to achieve the desired performance with great flexibility when loading a data warehouse.

SessionID: 101747

PowerBI and PowerApps Married at First Sight

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Dan King

Title: PowerBI and PowerApps Married at First Sight

Abstract:

PowerBI is Microsoft's self service reporting tool that give businesses a robust visualization of their data. As Microsoft's Power Platform has evolved, PowerApps is taking a similar approach by providing businesses with a self service application tier. In this session we will see the power of bringing the two together. Let's explore how the visualization tier of PowerBI can enhance the development and capabilities of PowerApps. We will go from a blank canvas app and import visualizations while pointing out some of the pros and cons of marrying the two together. We will use the capabilities of PowerApps to write and update our SQL Server tables. Bringing the two together can provide businesses with a robust solution under one umbrella. Join me in learning how these two services came together and said "I DO".

SessionID: 101757

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

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

Indexing for performance

Back to calendar

Event Date: 29-02-2020 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Jeffrey Garbus

Title: Indexing for performance

Abstract:

You simply can't access large volumes of data without correct indexes. This session teaches indexing from the optimizer's perspective, including what the indexes can and can't do, and how the optimizer can and can't use them.

SessionID: 100016

Machine Learning with AzureML and Microsoft Excel API

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Advanced Analysis Techniques

Speaker: Srikrishna Krishnarao Srinivasan

Title: Machine Learning with AzureML and Microsoft Excel API

Abstract:

How cool would it be, if it is possible to run a Machine Learning model in AzureML to classify or predict your business requirement and give access of it to your employees to run it every time using their most favorite tool... yes Microsoft Excel

Also, would it excite you, if you were told, the entire time to build and deploy this ML App with AzureML and Microsoft Excel is a matter of hours, with no mobile app, no website, no servers... just set, ready to go.

Join me in this exploratory session on building and deploying Machine Learning model for your business with AzureML with Microsoft Excel API.

SessionID: 100026

Big Data Clusters for the Absolute Beginner

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mohammad Darab

Title: Big Data Clusters for the Absolute Beginner

Abstract:

Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts

SessionID: 100041

What's New In SQL Server For The Developer

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Jeff Taylor

Title: What's New In SQL Server For The Developer

Abstract:

SessionID: 100679

Starting a Career in IT - Ask the Panel!

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Professional Development

Speaker: Dale Sullenberger

Title: Starting a Career in IT - Ask the Panel!

Abstract:

This moderated session features a panel of IT professionals with a wide range of experience ready to answer your questions about getting started and progressing in IT. Have a question about what you can do as a student to get ready? What employers look for from those brand new to the profession? How to grow your skills and know when to look for the next opportunity? Bring your questions and we'll answer as many as time permits. This session is focused on college students, but is open to all.

SessionID: 100751

Failure needs to be an option.

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Professional Development

Speaker: Donna Ellis Wilson

Title: Failure needs to be an option.

Abstract:

Turbo charge your career, your projects, and your team by changing the way you approach failure, learning, practice, and praise. This session will cover research in cognitive psychology and neuroscience in an actionable path forward to eliminate perfectionism and other career-stifling behaviors and thoughts, which those of us in the tech industry are particularly susceptible to.

SessionID: 101194

SQL Server SSMS Fundamentals for Beginners

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Harvey Hyman

Title: SQL Server SSMS Fundamentals for Beginners

Abstract:

This session is for people who are brand new to SQL Server or are looking for a review of the fundamentals of SSMS. We will review features presented in version 17.9, specifically creating tables and views; choosing data types; creating indexes, constraints, rules and triggers; creating basic queries using select, from, where, order by; simple joins; more complex queries and operators; primary key, foreign key, composite key; generating a system data diagram.

SessionID: 101261

Azure Cost Management

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Dustin Dorsey

Title: Azure Cost Management

Abstract:

One of the benefits of the cloud is the ability to be able to create resources quickly and on-demand as you need them. However, without proper control and monitoring, this can quickly generate some not-so-pleasant surprises when your bill arrives. In this session, I want to show you how you can create governance around your Azure environment to avoid these surprises and start getting the most from your spend while still being able to maintain the flexibility that makes the cloud so valuable. We will discuss how you can allocate costs to specific areas and create more accountability in your organization using things such as tagging. We will also dive heavily into the Azure Cost Management + Billing portion of the portal and talk about analyzing spends and how you can create more visibility to your organization. We will also look at creating and using budgets, alerting around billing\spends, and how to review and interpret the cost saving recommendations that Azure provides.

SessionID: 101687

Eliminating Anti-Patterns and RBAR for Faster Performance

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Jonathan Kehayias

Title: Eliminating Anti-Patterns and RBAR for Faster Performance

Abstract:

Are you looking for faster performance on your existing hardware? Do you have queries that run slowly and don’t seem to scale as the data set grows? Are you running SQL Server in the cloud where you don’t have control over the configuration of the environment?

This session will show you how to find the low hanging fruit in your environment, explain why the problem exists, and step through how you can make the necessary changes to boost your SQL Server’s performance with a minimal amount of effort. This session focuses on schema and code design problems, to help you get the most bang for your buck when performance tuning SQL Server. By focusing on real-world examples with reproducible workloads, you will easily be able to see the impact of common mistakes and learn how to fix them quickly for improved performance.

This session is the third session in the SQL Performance for Developers Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 101715

Using Powershell to Document SQL Server

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walkey

Title: Using Powershell to Document SQL Server

Abstract:

Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more

SessionID: 101816

“The different faces of Information: Data Modeling and the Data Profession in the 21st Century”

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Information Delivery

Speaker: Frank Quintana

Title: “The different faces of Information: Data Modeling and the Data Profession in the 21st Century”

Abstract:

One Data Model fit all cases is not possible- When the only tool you have is a hammer all the problems look like a nail.

From Flat File to Big Data different models have been used each with their own advantage and limitations. Depending on the purpose our models change and change the skills and tools we use. From manual processing to the digital collection, storage, manipulation, and analysis of data our models have been changed and enriched in order to make sense of the information inside the data, convert it to knowledge and finally gain wisdom in our decisions. The presentation is an overview of the way we work today with data and how the new perspectives on Data are changing the data profession. In addition to the traditional and new models to work with data, the author introduces two models of his own to explain the “Digital Transformation Hierarchy” and “The Intelligence Life Cycle”.

SessionID: 101866

Data Science, Analytics, and Storytelling Tools

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: ALAN FERRANDIZ LANGLEY

Title: Data Science, Analytics, and Storytelling Tools

Abstract:

In this talk we will discover the secrets to create an impact on a presentation using the resources provided by analytics and storytelling. Additionally, we will see the most common mistakes made when presenting data and how to solve them using the best analytical and storytelling practices.

SessionID: 102098

PowerApps and AI: A Flow of Location Events

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: PowerApps and AI: A Flow of Location Events

Abstract:

The Microsoft Power Platform has become an innovative bridge between data interaction, visualization, and analytics. The possibilities have become almost endless for businesses to engage with their data in amazing ways.

In this session, we will dissect an application using Power Apps and location services to track latitude and longitude coordinates on Bing maps. Attendees will learn how to configure and demonstrate it on a mobile device. I will also show two approaches using AI within the application by using Azure SQL Database, Cognitive Services and Power Automate. An end-user will be able to leverage Bing Search for location-aware web searches, while an administrator will be able to leverage the Azure SQL Database and Power Automate to send alerts based on predefined metrics.

SessionID: 102210

The District Dashboard: Modeling Reporting Solutions for Public Education

Back to calendar

Event Date: 29-02-2020 - Session time: 10:15:00 - Track: BI Information Delivery

Speaker: Paul Turley

Title: The District Dashboard: Modeling Reporting Solutions for Public Education

Abstract:

Learn about data modeling and reporting from a real solution in production and with new features in progress. The District Dashboard is a Business Intelligence solution created for Forsyth County Schools to track and analyze K-12 student performance, college and career readiness. Built on Power BI, Azure Analysis Services, Azure Data Factory and Azure SQL. Working with Microsoft Education Services, this reference solution is built on extensive Azure services as a foundation for education systems.

SessionID: 100095

Getting Noticed

Back to calendar

Event Date: 29-02-2020 - Session time: 11:30:00 - Track: Professional Development

Speaker: Rick Heiges

Title: Getting Noticed

Abstract:

You are awesome! You know that you are a great fit for that role and would be a great hire. But, how do you stand out from the crowd and Get Noticed? This session will go over some tactics on how to get noticed on LinkedIn and also show some examples of how your resume can get you to that next step. Audience participation is encouraged in this lightning talk to get ideas flowing.

SessionID: 100765

How To Talk To Your Storage Admin

Back to calendar

Event Date: 29-02-2020 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 101654

KingswaySoft - Supercharge your ETL Development with Advanced SSIS Components

Back to calendar

Event Date: 29-02-2020 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Daniel Cai

Title: KingswaySoft - Supercharge your ETL Development with Advanced SSIS Components

Abstract:

Want to get more out of your SSIS development efforts? The SSIS Productivity Pack is a collection of premium SSIS components which enable an improved SSIS ETL development experience with greater potentials. These SSIS components for connectivity and productivity offer more features and bring new enhancements to SSIS to enable integration scenarios not once possible without custom scripting.

In this session, we will introduce you to our collection of 150 advanced SSIS components. We will demonstrate some of our most popular offerings including our JSON XML components for integrating with REST APIs, Premium Derived Column with over 225 functions, and unique components such as Duplicate Detector and Diff Detector.

In additional to performing advanced transformations you will also find codeless and feature-rich solutions for integrating with virtually any application or database system including leading enterprise applications such as Microsoft SharePoint, Dynamics 365 and more.

SessionID: 100028

Tally Ho! -- Explore the Varied Uses of Tally Tables

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: Tally Ho! -- Explore the Varied Uses of Tally Tables

Abstract:

Because SQL Server is designed to efficiently operate with set-based queries it does not perform as well with loops and cursors. However there are situations where you really need some type of a loop. Tally tables give you the best of both worlds by allowing you to effectively "loop" through records in a set-based manner. We'll explore what tally tables are, how they work, and more importantly review some of the many ways you can use them to turn your loops and cursors into efficient set-based operations.

SessionID: 100038

That's So Metadata: Discover Your Database From The Inside

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: That's So Metadata: Discover Your Database From The Inside

Abstract:

Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?

SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

We will also cover the official Microsoft documentation on these features and other resources on how to use them.

SessionID: 100310

The Power of Power BI Themes or I Haven't Written Themes Since High School

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Michael Antonovich

Title: The Power of Power BI Themes or I Haven't Written Themes Since High School

Abstract:

Power BI uses themes to customize the look of Power BI reports. I hope most of you already know how to change colors and fonts in your BI reports. But if you are doing that for every data visualization on every page/tab, you are: 1) wasting a lot of time configuring these same properties multiple times, and 2) risking inconsistent styles (colors and fonts) because it is so easy to miss one or more of the format settings as you go from one data visualization on one page to another. But what if you could define your format settings one time and use them across all your pages, even in multiple BI files created by yourself and others in your organization creating a consistency or branding that would be difficult to achieve manually. This session explores how you can build and use themes to accomplish such a task. It consists mostly of demonstrations with an introduction into basic JSON which sounds scarily like coding but don't worry, I'll guide you through the rough waters.

SessionID: 100653

Data Virtualization with PolyBase

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Data Virtualization with PolyBase

Abstract:

PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.

SessionID: 100681

Data and the Data Professionals Future - Ask the Panel

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Professional Development

Speaker: Dale Sullenberger

Title: Data and the Data Professionals Future - Ask the Panel

Abstract:

This moderated session features a panel of IT leaders from Tampa Bay area companies. Have a question about what they see as the direction of data and the data profession(s) in the coming years? Want to know what the current trends are across various companies? Want to generate thought about how you can best position yourself for near future in the ever changing landscape? Bring your questions and we will answer as time permits. This session is open to all.

SessionID: 101008

Exploring The JSON Features In SQL Server

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Eric Cobb

Title: Exploring The JSON Features In SQL Server

Abstract:

SQL Server 2016 introduced built-in JSON support, with new features that allow you do things like store JSON text in database tables, read and modify JSON, format the results of regular SQL queries into JSON, and transform JSON objects into table format. In this demo heavy session we’ll explore the new JSON functions and T-SQL enhancements that are now available, and find out just what SQL Server can (and can’t) do with JSON.

SessionID: 101256

Deploying Database Changes Without Taking an Outage

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Warren

Title: Deploying Database Changes Without Taking an Outage

Abstract:

For most DBA's and most companies changes to the database are done during either a maintenance window that allows some downtime or during a full planned outage. Doing it that way makes a lot of sense, you don't have to work about blocking or deadlocks or the code being out of sync with the database. But what if your business needs to move faster, say deploying changes every week? It's possible, with some caveats and a small risk or two! This presentation will start an overview of "blue/green" deployments and why "database first" is a good plan. From there we'll look at how to deploy various types of changes and how to assess and mitigate the risk of each. It is possible, and the upside if that you'll work fewer nights and weekends making changes!

SessionID: 101838

Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Jose Chinchilla

Title: Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Abstract:

Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.

SessionID: 101851

How to Beat the ATS

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Professional Development

Speaker: Suzanne Ricci

Title: How to Beat the ATS

Abstract:

Today's hiring environment is very different from even 1 year ago. If you have applied online to jobs and have not had success this interactive session is for you. Come learn how to craft a resume to start getting results with online submissions. MOre interviews = more offers. Let's learn how to beat the applicant tracking systems.

SessionID: 101854

Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chad Buher

Title: Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks

Abstract:

Has your organization accumulated a ton of reports that are crucial, yet fragmented and difficult to maintain? This session deals with the challenge of documenting those disconnected reports and replacing them with integrated dashboards. We will also discuss the trade offs of different data integration architecture options such as data lakes, dimensional models, real time solutions like data virtualization, and cloud based solutions.

In this session, we will explore:

SessionID: 102158

Intelligent Infrastructure for the DBA

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Intelligent Infrastructure for the DBA

Abstract:

Every day we are expected to do more and more work with less resources. The future shows this trend will continue. Writing scripts to do automation will only get us so far. Gartner Group has created a new category called Intelligent Infrastructure in 2017 and many infrastructure vendors and software companies are doing more and more in this space. This session will explain what Intelligent Infrastructure is, what AIOps is, what is available now and what is coming and how the DBA can utilize these new tools to improve their daily workflow. Free up your time to focus on bigger strategic problems for your organization.

SessionID: 102683

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 29-02-2020 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Diane Schuster

Title: CozyRoc: 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. 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 at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. 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: 100032

dbatools - A PowerShell Toolkit for the DBA

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jack Corbett

Title: dbatools - A PowerShell Toolkit for the DBA

Abstract:

In this demo driven session you will learn how to: prepare your computer for installation of the dbatools module, install dbatools and pre-requisites, use dbatools commands to automate routine tasks such as migrating logins and jobs, setup log shipping, and add databases to availability groups.

At the end of the session, you will be able to return to your office with dbatools as a new tool in your toolkit to help you manage your SQL Server estate in a more efficient manner.

SessionID: 100212

Auditing and Taming SQL Server Permissions

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Compliance and Security

Speaker: Dave Mason

Title: Auditing and Taming SQL Server Permissions

Abstract:

Excessive authorizations violate the principal of least privilege and put you and your organization at risk. In this session, we'll review how to identify the server and database principals that pose the greatest threats to the security, availability, and recoverability of SQL Server. Then we'll look at a real world example and show how to "downsize" permissions to a more appropriate level that both administrators and users can live with.

SessionID: 100532

MA + THE - E = Aggravated with Aggregation

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Carolyn Risk

Title: MA + THE - E = Aggravated with Aggregation

Abstract:

A beginner session to relieve the frustration of using simple aggregation functions in SQL statements. The session will cover simple equations such as adding, counting, MIN and MAX functionality. The syntax for filtering on an aggregated value will also be covered.

SessionID: 100547

An Introduction to Spatial Data in SQL Server

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: An Introduction to Spatial Data in SQL Server

Abstract:

Over a decade ago Microsoft added the capability to store and work with geometry and geography data types. (Wait...what's this you say?!?) Well, yes...it's been there for quite some time now. You can actually store spatial data in SQL tables (in the form of points, lines and polygons). There are also many powerful, built-in functions that allow the manipulation and calculation of results around this data. This is a powerful, but sadly underused feature of the product given that IoT tends to be so focused around the location of things.

Come to this session to learn about:

● The two elusive data types (geography and geometry) ● T-SQL Spatial routines and functions ● How to load spatial data ● Where you can get lots and lots of free spatial data to supplement your existing systems ● See an example of real-world Spatial data in use (aggregating truck positions for tax calcs) ● Write a SQL query from a bitmap picture (pure amusement)

SessionID: 100680

Switching to an IT Career - Ask the Panel

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Professional Development

Speaker: Dale Sullenberger

Title: Switching to an IT Career - Ask the Panel

Abstract:

This moderated session features a panel of IT professionals with a wide range of experience ready to answer your questions about transitioning into and progressing in IT. Have a question about what you can do to take the step from your current position into IT to get ready? What do employers look for from those changing career paths? How to show your present skills in a manner that will help you move into an IT opportunity? Bring your questions and we'll answer as many as time permits. This session is focused on professionals that have recently changed into an IT career, or are hoping to do so soon, but is open to all.

SessionID: 100859

Data Science 101: An Introduction to Data Science Using Python

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Ganesh Lohani

Title: Data Science 101: An Introduction to Data Science Using Python

Abstract:

SessionID: 100892

Maximizing SQL Server Management Studio for Developers and DBAs

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Nem Schlecht

Title: Maximizing SQL Server Management Studio for Developers and DBAs

Abstract:

Whether you're a developer or a DBA, you likely use SSMS (SQL Server Management Studio) a lot. However, are you using all the features and extensions available to maximize your efficiency? This talk will show some of the most useful, yet overlooked, features of SSMS and some of the best (and free) extensions to make life easier for you and your teams. I'll also include some of my most useful code snippets that I've found or written over the years and a quick look at the new Azure Data Studio (previously SQL Operations Studio). Save yourself some time and headaches and optimize the way develop or administer your SQL!

SessionID: 100911

Intro to Azure for SQL Geeks

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: David Patrick

Title: Intro to Azure for SQL Geeks

Abstract:

Interested in using the Cloud for SQL Server? Wondering what is the cloud? Come find out what Cloud Computing is all about and why you might want to use it. We’ll introduce Microsoft’s Cloud, Azure, and talk about how it can be used for FREE! We’ll demonstrate creating Virtual Machines in the cloud that can run SQL Server (just like on premises) and we’ll also demonstrate creating SQL Servers in the Cloud using SQL Azure (no virtual machines required).

SessionID: 101449

Powershell for DBA to day to day stuff

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Other

Speaker: Jignesh Patel

Title: Powershell for DBA to day to day stuff

Abstract:

Learn how easy to write powershell As being DBA

Use powershell for reporting and check database status Run one powershell script for all instance and many more

SessionID: 101508

Instant SQL Sandbox Using Docker

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Eddy Djaja

Title: Instant SQL Sandbox Using Docker

Abstract:

SQL Server running on Linux was unthinkable ten years ago. Now it is not only possible to run SQL Server on Linux, but also Windows 10 as the sandbox and development machines that can host SQL Server on Linux. It is possible because of a Container technology. Using Azure Data Studio's notebook as the runbook, we will show step by step to deploy SQL Server on Docker in Windows 10 desktop . The demo will also show the experimental feature of LCOW (Linux Container on Windows).

SessionID: 101688

Deadlocking for Mere Mortals

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Jonathan Kehayias

Title: Deadlocking for Mere Mortals

Abstract:

While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server 2005 and 2008, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server 2005 and 2008; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.

SessionID: 101727

From Tech to Lead - Transitioning from a Technician to a Leader

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Professional Development

Speaker: TBTLA Tampa Bay Technology Leadership Association

Title: From Tech to Lead - Transitioning from a Technician to a Leader

Abstract:

Many people want to be a manager; however, most folks believe that their company will guide them or provide the opportunity for that next big step. That is not the case! You have to take your career into your own hands, take additional responsibilities, be more vocal, add more skills, and discuss your career desires with your supervisor and HR.

You got the manager role, now what? The transition from a team member to a manager can be a rough road. Just because you’re the manager now, doesn’t mean people will listen to you. Understanding what it takes to become a Leader, not a manager, will be the difference between success and failure!

This presentation will share some successful practices on how to successfully transition from Technician to a Leader.

SessionID: 101756

5 Availability Groups Issues That May Ruin Your Day

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dmitri Korotkevitch

Title: 5 Availability Groups Issues That May Ruin Your Day

Abstract:

AlwaysOn Availability Groups have become the most common High Availability technology used with SQL Server. It provides protection at the database group level, and it stores a separate copy of each database on each node, eliminating storage from being a single point of failure.

While Availability Groups help to achieve required High Availability, they may also introduce issues in the system. In this session, Dmitri will discuss several less-known problems associated with them. You will learn how Availability Groups may impact transaction log truncation and contribute to the blocking in the system, how readable secondaries may increase CPU and I/O load on primaries among a few other things. Dmitri will also discuss how to properly setup monitoring for Availability Group infrastructure in your environment.

SessionID: 101998

Performance Tuning - Analyzing Execution Plans

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Konstantin Melamud

Title: Performance Tuning - Analyzing Execution Plans

Abstract:

Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations.

In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation

SessionID: 102105

2017 SSIS Scale Out for High Availability

Back to calendar

Event Date: 29-02-2020 - Session time: 14:30:00 - Track: BI Information Delivery

Speaker: Paul LaGrone

Title: 2017 SSIS Scale Out for High Availability

Abstract:

2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.

SessionID: 100024

Working with JSON in SQL Server

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Alexander Fleming

Title: Working with JSON in SQL Server

Abstract:

JSON support was one of the most requested features on the Microsoft Connect site. I will walk through a brief history of JSON in SQL Server with comparisons to XML, then break out some T-SQL demos. The demos will illustrate the fundamentals of working with JSON and some "gotchyas." The demos will also become more complex as the session progresses and attempt to illustrate realistic scenarios and creative uses for working with JSON.

SessionID: 100030

How To Give a Technical Presentation

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Professional Development

Speaker: Aaron Cutshall

Title: How To Give a Technical Presentation

Abstract:

Most people don't like to speak in public and technical folks are certainly no exception. Yet, you've got some ideas for a great presentation but just don't know how to go about putting it all together. On top of that, how do you go about giving the presentation itself? This session will cover how to pull your material together in an organized fashion and present it such that your audience can follow along and get the message you want to relay. We'll also discuss how to deal with issues that cause presenters stress to help you to make the process enjoyable and rewarding for all.

SessionID: 100037

Revenge: The SQL!

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 100042

Top 10 Things DBA's Should Know About Their Infrastructure

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Taylor

Title: Top 10 Things DBA's Should Know About Their Infrastructure

Abstract:

This session covers the top 10 things DBA's should know and configure for their database servers infrastructure.

SessionID: 100061

Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Peter Doyle

Title: Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less

Abstract:

Would you like to create Pivot Tables in SQL with ease?

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible

SessionID: 100086

Azure Synapse Analytics against Google BigQuery and Snowflake. What are the main differentiators?

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Oscar Zamora

Title: Azure Synapse Analytics against Google BigQuery and Snowflake. What are the main differentiators?

Abstract:

Data Warehousing has been traditionally deployed via on-prem MPP solutions, and due to cloud modernization, and datacenter reduction footprint initiatives, organizations are looking out to establish a relationship with a cloud solution that can help them get off the traditional storage and compute licensing scheme, to easily scale their workloads without spending millions in newly acquired hardware, and to reduce their database administration operational tasks.

Azure Synapse Analytics, Google BigQuery and Snowflake Provide a path to migrate workloads into the cloud and allows an efficient resource utilization for both compute and storage. That is at least, what the marketing says as it has a tacit disclaimer around it. Azure Synapse Analytics offers scalability, pay-as-you-go compute solutions, with data contained within the database boundaries. The presentation shows a side by side comparison, with pros and cons of each platform and debunks some of the myths that have surfaced.

SessionID: 100236

Introduction to IoT using Azure

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: John Wang

Title: Introduction to IoT using Azure

Abstract:

Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own?

We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.

SessionID: 100390

Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio

Abstract:

On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks.

SessionID: 100763

The Future Is Here for Containers!

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Marsha Pierce

Title: The Future Is Here for Containers!

Abstract:

Demonstrate how to use docker swarm to quickly spin up many containers and persist the same data set to all of the containers. This is what every developer wants. Should your container be on premise or the cloud? Does it matter? Demonstrate how to move a container between on premise and the cloud with data.

SessionID: 101061

Performance Improvements in SQL Server 2019

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Frank Gill

Title: Performance Improvements in SQL Server 2019

Abstract:

Microsoft released SQL Server 2019 in November. The latest version contains several improvements and new features that improve reliability and performance. First, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process. This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced. ADR also prevents the transaction log from growing during a long-running transaction. Second, metadata for temporary tables can be stored in in-memory tables. For tempdb-heavy workloads, this removes a bottleneck and provides an improvement to performance. Finally, SQL Server 2019 supports the use of persistent-memory (PMEM) devices. PMEM can be used to persist the transaction log buffer, effectively removing LOGWRITE waits. Join me for this session to learn about these new features in SQL Server 2019 and how they can make your workload run faster.

SessionID: 101195

Normal Forms Made Easy

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Harvey Hyman

Title: Normal Forms Made Easy

Abstract:

The focus of this session is to demystify the normal forms and the normalization process. This presentation will provide the audience with simple explantions for each normal form with easy to understand examples starting with 1NF all the way to 6NF.

SessionID: 101705

DAX 360 and Power BI

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Adriano da Silva

Title: DAX 360 and Power BI

Abstract:

This presentation provides beginners with an applied way to learn DAX and apply this knowledge in reports right away by optimizing and/or enhancing them. DAX stands for Data Analysis Expressions and it is used in Analysis Services, Excel (Power Pivot) and Power BI Desktop to create powerful calculations and queries.

This presentation is a quick DAX 360 by covering not only syntax, formulas and expressions, but it showing how to use tools, best practices, troubleshooting and query optimization techniques.

Topics Covered:

The information in this presentation provides attendees with a fresh look at the language and an opportunity to learn some valuable techniques.

SessionID: 101834

Designing end to end platform for advance data analysis and machine learning on Azure

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Advanced Analysis Techniques

Speaker: Rahat Yasir

Title: Designing end to end platform for advance data analysis and machine learning on Azure

Abstract:

In this session we will use azure cloud platform to develop and design an end to end data analysis and machine learning platform for an enterprise graded solution. An advanced data analysis and ML platform consists of data storage, training pipeline, training code base, inferencing pipeline, inferencing code base and API designing. We will show all the steps to design an enterprise graded scalable AI solution using Azure platform.

SessionID: 101865

Sarah the Explorer: Navigating and Customizing the SharePoint Interface

Back to calendar

Event Date: 29-02-2020 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Sarah Patrick

Title: Sarah the Explorer: Navigating and Customizing the SharePoint Interface

Abstract:

As the SharePoint Intern for Smithsonian Institution’s Office of the Chief Information Officer, I created an interactive organization chart in SharePoint so users can find information on all the Smithsonian units in one place. I will go in depth on how I used SharePoint web parts, HTML/CSS, and JavaScript to create an image map with modals to display each unit’s information and the obstacles I faced with the customizations.

This site is open source. Improve this page.