Nr: 911
SQLSaturday #911 - Orlando 2019
SessionID: 94831
Data Science 101: An Introduction to Data Science Using Python
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: Big Data/Data Science
Speaker: Ganesh Lohani
Title: Data Science 101: An Introduction to Data Science Using Python
Abstract:
Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
SessionID: 94923
In-Place vs Side-by-Side SQL Upgrades; Clearing the Confusion
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: DBA
Speaker: Troy Gallant
Title: In-Place vs Side-by-Side SQL Upgrades; Clearing the Confusion
Abstract:
SessionID: 95144
Containerize your learning - a docker introduction
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: Docker Powershell
Speaker: Daniel Shrader
Title: Containerize your learning - a docker introduction
Abstract:
You've heard about docker, but haven't found that use case for it yet or simply just don't have the time to learn it. This session will start off showing you what docker is at a high level, and its many simple use cases. You'll leave with enough knowledge to either use someone else's docker image or build your own. All of this without needing to install docker on your machine. We'll go into how to spin up an environment using a cloud resource in minutes. After that, we'll install a graphical interface for docker in a docker image to help speed up your learning. From there, we will even spin up an SQL Server in a container that can start and stop in little to no time.
SessionID: 95190
Why You Should Consider Implementing Indexed Views
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: DBA
Speaker: Alexander Fleming
Title: Why You Should Consider Implementing Indexed Views
Abstract:
This session will include an explanation of what indexed views are, the types of problems that they solve, and their limitations. Additionally, I will provide a methodology for determining whether or not you should consider using indexed views to solve problems in your environment - including how to test and compare them to some alternatives. I will then go through some demos and provide more opportunities for the audience to ask questions.
SessionID: 95620
SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: Cloud
Speaker: Darius Liktorius
Title: SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)
Abstract:
SessionID: 95662
Test Driven Development (TDD) for T-SQL Database Development
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: TSQL
Speaker: Anthony Mendoza
Title: Test Driven Development (TDD) for T-SQL Database Development
Abstract:
SessionID: 95736
Encrypting Data within SQL Server
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: Security
Speaker: Thomas Norman
Title: Encrypting Data within SQL Server
Abstract:
In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.
You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.
SessionID: 96075
How UCF IT uses Power BI to monitor our IT Services
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: PowerBI
Speaker: Priscilla Camp
Title: How UCF IT uses Power BI to monitor our IT Services
Abstract:
SessionID: 96084
Data visualization tips for Power BI
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: PowerBI
Speaker: Orlando Mezquita
Title: Data visualization tips for Power BI
Abstract:
In this session we will cover multiple data visualization tips to create more interactive Power BI reports and dashboards. Some of the Power BI features we will cover are report pages tooltips, drillthrough filters, better use of bookmarks, SVG Measures, and many more.
SessionID: 96278
DAX for Beginners - Learn the basics for Power BI
Event Date: 09-10-2021 - Session time: 09:00:00 - Track: PowerBI
Speaker: Katie Schmidt
Title: DAX for Beginners - Learn the basics for Power BI
Abstract:
If you want to use PowerBI, you'll want to learn the DAX language. We will go over what, when and how to use it along with where to get help! If you are an excel person, this might be an easy shift. If you are not, then you will definitely want to understand this language if you or your teams are using PowerBI.
SessionID: 94827
Machine Learning with AzureML and Microsoft Excel API
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: Machine Learning
Speaker: Srikrishna Krishnarao Srinivasan
Title: Machine Learning with AzureML and Microsoft Excel API
Abstract:
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: 94862
SQL Server 2019 - New Features
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: DBA
Speaker: Jeff Taylor
Title: SQL Server 2019 - New Features
Abstract:
In this session, we will cover the new features that are being introduced in SQL Server 2019. There will be Demos!
SessionID: 94943
LEAD, LAG CTE
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: TSQL
Speaker: Victor Ivantsov
Title: LEAD, LAG CTE
Abstract:
Query too complex and slow? Using dynamic SQL a lot? Come and see how use of new SQL Server language concepts and build-in functions can help.
SessionID: 95297
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: DBA
Speaker: Eddy Djaja
Abstract:
SessionID: 95385
Introduction to IoT using Azure
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: Developer
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: 95431
Building Scalable Cloud Databases
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: Cloud
Speaker: Tim Lentine
Title: Building Scalable Cloud Databases
Abstract:
Usually when developers and DBAs talk about scaling databases we mean 'scaling up' our database server to handle the increased demands of our users.
But what if 'scaling up' isn't the only or best answer?
What if we're building a multi-tenant SaaS application, and want to have a single front-end for each of our clients, but have multiple back-end databases to segregate customer data?
In this talk, we'll look at ways we can scale our SQL Server Databases 'out' instead of 'up'.
We will touch on a few database design considerations before diving into the Elastic Database Client libraries to see how we can add intelligent data-dependent-routing to our applications, ensuring that each request is routed to the correct database.
Finally, we will explore how Azure Elastic Database Pools can be used to optimize our database workloads in Azure.
SessionID: 95458
Big Data Clusters for the Absolute Beginner
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: Big Data/Data Science
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: 95541
Power BI for the Data Systems Administrator
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: PowerBI
Speaker: Gina Meronek
Title: Power BI for the Data Systems Administrator
Abstract:
Data systems administrators pride themselves on their ability to dig deep into the weeds of their systems and get to the root of problems. However, when it comes time to explain a complex or intermittent issue, we find that others don’t enjoy those weeds. Ever wish you could draw a better picture of what’s going on? Enter Power BI! This tool is beloved by many analysts and developers but it can transform more than just OLTP data. Attend this session to learn how you can use quick models in Power BI against administrative data such as the SSRS execution log, SQL Server Extended Events, XML JSON files, query performance data, and even those random Excel files you get from vendors. You’ll leave this session with the skills you need to survey your domain from a new angle and communicate what you learn to your organization.
SessionID: 95969
How to automate row level security in Power BI using DAX and SSAS
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: PowerBI
Speaker: Ashwini Jain
Title: How to automate row level security in Power BI using DAX and SSAS
Abstract:
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization or embed them in your app or website. This session is for users are who want to automate Power BI row-level security by replicating the security of another data source such as corporate ERP. Many organizations maintain tight data security within their organization. Row-level security needs to be defined within Power BI. This can be difficult if you have many users and security changes happen quite often. If you are using a corporate ERP system that has security built into it, you would end up doing redundant work of managing security at two places, in ERP as well as in Power BI. DAX query can be used to filter out rows based on user ID/user name. We will go over the demo of the entire process starting from bringing data into SSAS, creating data model, applying row level security publish the report. Never again you will have to manually manage roles within Power BI.
SessionID: 98554
Aggregations in Power BI: How to unlock the power of big datasets
Event Date: 09-10-2021 - Session time: 10:00:00 - Track: PowerBI
Speaker: Shabnam Watson
Title: Aggregations in Power BI: How to unlock the power of big datasets
Abstract:
Aggregations are one of the most important optimization methods for managing big datasets in Power BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database.
In this session, you will learn about the concept of aggregations, different table storage modes in Power BI, different kinds of aggregation tables, how to configure aggregation tables so that they can answer high level user queries, and finally how to use tools such as DAX Studio or Extended Events to determine if the aggregations are actually being used.
SessionID: 94837
Linked Servers - Creating, and Using
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: TSQL
Speaker: Dale Sullenberger
Title: Linked Servers - Creating, and Using
Abstract:
Linked servers in SQL have been around for a very long time, but still can cause lots of headache when configuring one for use. In this session, we will dive in the the multiple creation, security, and configuration options that can be so important to making them work successfully. In the last part, we will cover the different syntax available over linked servers and when best to use one over the other, with some real life examples.
SessionID: 94838
Data Virtualization with PolyBase
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: Big Data/Data Science
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: 94863
DevOps - How To Setup CICD Step By Step For Your Website Database
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: Developer
Speaker: Jeff Taylor
Title: DevOps - How To Setup CICD Step By Step For Your Website Database
Abstract:
SessionID: 94951
The SSRS 2017 Restful API
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: SSRS
Speaker: George Walkey
Title: The SSRS 2017 Restful API
Abstract:
SSRS 2017 has recently added a RESTful API to the Reporting Server, in addition to its classic SOAP interface. Using Powershell's Invoke-RestMethod , we will explore the new API with examples for creating folders, permissions, altering Timed Subscriptions and firing them off.
SessionID: 95593
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: DBA
Speaker: Vladimir Oselsky
Abstract:
SessionID: 95629
Introduction to Agile
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: Developer
Speaker: Ryan Conrad
Title: Introduction to Agile
Abstract:
Agile software development is more than frameworks such as Scrum, Extreme Programming or Feature-Driven Development (FDD).
Agile software development is an umbrella term for a set of frameworks and practices based on the values and principles expressed in the Manifesto for Agile Software Development and the 12 Principles behind it. When you approach software development in a particular manner, it's generally good to live by these values and principles and use them to help figure out the right things to do given your particular context.
Join us to learn how to apply this principles in real day to day activities.
SessionID: 96086
A Rocket Scientist Perspective on Index Column Selection
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: DBA
Speaker: Mike Byrd
Title: A Rocket Scientist Perspective on Index Column Selection
Abstract:
SessionID: 96107
Level-up your Power BI Reports
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: PowerBI
Speaker: Cecilia Brusatori
Title: Level-up your Power BI Reports
Abstract:
You've been working with Power BI, building fantastic reports and dashboards. Let's take a look at some of the cool features that will help you make your reports more appealing and add more functionalities.
This session is 100% demos: Shortcuts, visuals interactions, drilling down/up/through data , custom tooltips, bookmarks.
SessionID: 96399
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: Docker Powershell
Speaker: Jack Corbett
Abstract:
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: 98069
Cloud Essentials for the Database Professional - Hands-On Session
Event Date: 09-10-2021 - Session time: 11:00:00 - Track: Cloud
Speaker: Jay Rajendran
Title: Cloud Essentials for the Database Professional - Hands-On Session
Abstract:
SessionID: 95537
Starting a Career in IT - Ask the Panel!
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: SQL101
Speaker: Andy Warren
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: 95985
CozyRoc: Dynamic Data Flows in SSIS Without Programming
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: ETL
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: 96082
Introduction to SQL Server on AWS
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: Cloud
Speaker: Tom Staab
Title: Introduction to SQL Server on AWS
Abstract:
Are you curious about the benefits of running SQL Server on the AWS Cloud? Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most and why thousands of customers have chosen Amazon Web Services for their Microsoft Windows and SQL Server workloads. We will cover the benefits of running SQL Server on Amazon EC2 and Amazon RDS along with best practices for implementation. This is an audience-driven session where you can choose from a variety of topics including infrastructure, security, migration, high availability, storage, monitoring, management, backup, and recovery.
SessionID: 96423
Data, Data Everywhere, a lot of it is Free
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: Big Data/Data Science
Speaker: Rodney Landrum
Title: Data, Data Everywhere, a lot of it is Free
Abstract:
SessionID: 98065
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: Cloud
Speaker: Jay Rajendran
Abstract:
SessionID: 98154
PaaSport to Paradise: Lifting Shifting with Azure SQL Database + SSIS in Azure Data Factory
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: ETL
Speaker: Sandy Winarko
Title: PaaSport to Paradise: Lifting Shifting with Azure SQL Database + SSIS in Azure Data Factory
Abstract:
SessionID: 98561
Master Data Services (MDS): Friend or Foe?
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: Big Data/Data Science
Speaker: Tyler Graham
Title: Master Data Services (MDS): Friend or Foe?
Abstract:
SessionID: 98571
Event Date: 09-10-2021 - Session time: 12:15:00 - Track: DBA
Speaker: franklin yamamoto
Abstract:
SessionID: 94936
The Psychology of Better Power BI Reporting
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: PowerBI
Speaker: Ed Watson
Title: The Psychology of Better Power BI Reporting
Abstract:
In this course we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.
SessionID: 95007
Hack / Protect SQL Server - Come learn both.
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: Security
Speaker: Hiram Fleitas
Title: Hack / Protect SQL Server - Come learn both.
Abstract:
If you're using Dynamic Data Masking, Row-Level-Security or just SQL Server and you don't know how to hack it, then come to this session. I have some demos may leave you in aah. I'll show you how to also protect yourself against these hacks, plus how to add your database to source control with Azure DevOps, TFS or GitHub to better manage your database changes/deployments.
- TDS
- DDM
- RLS
- Database Source Control
We'll have plenty of time for QA. I hope to see you there!
SessionID: 95092
Migrate Your Database(s) with Distributed AGs
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: DBA
Speaker: Elizabeth Noble
Title: Migrate Your Database(s) 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: 95211
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: ETL
Speaker: Soumya Banerjee
Abstract:
SessionID: 95919
Hadoop, Hive, and Big Data For MSSQL Professionals
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: Big Data/Data Science
Speaker: Ernest Libertucci
Title: Hadoop, Hive, and Big Data For MSSQL Professionals
Abstract:
SessionID: 95959
PowerBI and PowerApps Married at First Sight
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: PowerBI
Speaker: Dan King
Title: PowerBI and PowerApps Married at First Sight
Abstract:
SessionID: 96053
PowerShell Core - Intro to SQL Server Linux Container
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: Docker Powershell
Speaker: Maximo Trinidad
Title: PowerShell Core - Intro to SQL Server Linux Container
Abstract:
This session will be covering the basic of working with Containers and PowerShell Core. We'll be taking the steps of creating a SQL Server 2019 container in Windows Subsystem for Linux. Then, taking the updated image to be loaded on another Linux system. You'll learn how to update, save, and reload a Docker container with SQL Server for Linux. Test the connectivity to SQL Server Container using Azure Data Studio and PowerShell Core. Get started with Containers!
SessionID: 96079
Deep Dive into Blocking and Deadlocks Troubleshooting
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: TSQL
Speaker: Dmitri Korotkevitch
Title: Deep Dive into Blocking and Deadlocks Troubleshooting
Abstract:
This, two-part session will explain why blocking and deadlocks occur, and how to troubleshoot them in your environments. First, it will provide the overview of SQL Server Concurrency Model and describe SQL Server locking behavior and root-causes of typical blocking issues. Next, the session will discuss how to capture and troubleshoot them using standard SQL Server tools, and how to simplify the analysis using Blocking Monitoring Framework developed by Dmitri.
SessionID: 98060
How to Speak SQL
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: TSQL
Speaker: Carolyn Risk
Title: How to Speak SQL
Abstract:
This will be a beginner level session on SQL clauses and the key parts of a SQL statement. We will cover the main building blocks of the language with the SELECT, INSERT, UPDATE and DELETE commands. We will do a syntax breakdown of the statement structure with special focus on the JOIN clauses in the FROM statements and conditional statements in the WHERE clause.
SessionID: 98128
Women in IT. A survival guide.
Event Date: 09-10-2021 - Session time: 13:30:00 - Track: Professional Development
Speaker: Gilda Alvarez
Title: Women in IT. A survival guide.
Abstract:
SessionID: 94836
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: DBA
Speaker: Dale Sullenberger
Abstract:
So, you installed SQL 2016 (or newer) and implemented Temporal Tables for some of your data. Everything is running well, but now what? In this session we will look at the effects of adding various indexes to both the main and the history table and discuss what that might mean to the front end performance. We will go into data management scenarios, for when you do not want to keep all the data in that table forever.
SessionID: 94894
SQL Server Fundamentals for Beginners
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: SQL101
Speaker: Harvey Hyman
Title: SQL Server 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: 94948
What's New in Creating Data Models and Reporting with Power BI
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: PowerBI
Speaker: Michael Antonovich
Title: What's New in Creating Data Models and Reporting with Power BI
Abstract:
SessionID: 94988
Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: Cloud
Speaker: Oscar Zamora
Title: Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift
Abstract:
Snowflake, RedShift and Teradata provide a path to migrate workloads into the cloud and allows a very reduced utilization expense for both compute and storage. That is at least, what the marketing says as it has a tacit disclaimer around it.
Azure SQL Data Warehouse 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: 95157
Look, over there, your permissions are showing!
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: Security
Speaker: Travis Page
Title: Look, over there, your permissions are showing!
Abstract:
You just walked into that fancy new gig, and you're getting your first cup of coffee. Your boss walks up and asks, "Who has access to that prod server?", do you know how to get the answers in the next hour? More importantly, do you know what these permissions mean, what an attacker could do with these permissions? In this session we'll start from scratch assuming that you have no experience with an audit with this question in mind. We'll work back from here to develop a strategy of how to harden your server.
SessionID: 95174
Build a Modern Data Warehouse from disparate sources with Apache Spark and Power BI
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: Big Data/Data Science
Speaker: oscar garcia
Title: Build a Modern Data Warehouse from disparate sources with Apache Spark and Power BI
Abstract:
Learning Objectives:
Challenges when using disparate data sources (different models)
Define a common model to support the different model shapes (Star Schema)
Apache Spark Overview
Strategy for loading the different data-sets into the common model
Data analysis and visualization with Power BI
SessionID: 95286
SQL Server is not an excuse to avoid DevOps
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: Developer
Speaker: Santosh Hari
Title: SQL Server is not an excuse to avoid DevOps
Abstract:
Working as a DevOps consultant in the field I hear this excuse all the time: "We can't do DevOps, we use a SQL database"
Handcrafted database deployments take days and are extremely fragile. This often leads DBAs to the misconception that introducing DevOps - which naturally leads to an increased cadence in deployments - will result in DBAs doing deployments all the time and with more breakages. We will dispel this misconception by showing how DevOps automation and a little discipline allow better testing, shorter release cycles, and reduced business risk. We will also discuss some techniques and best practices for introducing DevOps for SQL Server deployments.
SessionID: 95630
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: DBA
Speaker: Valentin Iamandi
Abstract:
When the server becomes unresponsive,
the performance goes down the drain and the CPUs are at 100%.
You asks yourself: I wish I knew what and how to do it.
-- How to configure your Sql Server for maximum performance
-- Execution plans: what plan is chosen by Sql Server and why?
-- Big databases issues and solutions
-- Indexes or Statistics updates, what and where: Rebuild or Reorg
-- Sql code tricks to increase code performance
-- What to do when in maximum performance pain
SessionID: 95719
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: TSQL
Speaker: Rob Volk
Abstract:
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:
- Document your database schema objects such as procedures, functions, tables, columns and indexes
- Investigate performance and look for bottlenecks and tuning opportunities
- Discover metadata to administer your databases backups, index maintenance, and security
- Apply your own metadata using extended properties
We will also cover the official Microsoft documentation on these features and other resources on how to use them.
SessionID: 96024
Getting started with Azure Data Factory Data Flows
Event Date: 09-10-2021 - Session time: 14:45:00 - Track: ETL
Speaker: Jose Chinchilla
Title: Getting started with Azure Data Factory Data Flows
Abstract: