sqlsathistory

Nr: 859

Back to Main list

SQLSaturday #859 - Tampa 2019

Start Time (24h)	Speaker	Track	Title
09:00:00	Eddy Djaja	Enterprise Database Administration Deployment	What Is Clogging Your Database Performance?
09:00:00	Stephen Muliokela	Enterprise Database Administration Deployment	Database Corruption
09:00:00	Dustin Ryan	Analytics and Visualization	Making Sense of the Power BI Ecosystem
09:00:00	Paul LaGrone	Enterprise Database Administration Deployment	2017 SSIS Scale Out for HA/DR ETL
09:00:00	Michael Keleher	Compliance and Security	Building Defense in Depth Using the Full Spectrum of SQL Server Encryption
09:00:00	Doug McClurg	BI Platform Architecture, Development Administration	Continuous Analytics Deployment with Azure DevOps
09:00:00	Erica Woods	Professional Development	14 Tips for an Effective Job Search Leveraging Recruiters
09:00:00	Tim Radney	Enterprise Database Administration Deployment	Understanding SQL Server Backup and Restore
09:00:00	David Pless	BI Platform Architecture, Development Administration	REAL WORLD REPORT SERVER PERFORMANCE SCALABILITY STRATEGIES
10:15:00	John Wells	Application Database Development	Fundamentals That Will Improve Your Query Performance!
10:15:00	Andy Warren	Professional Development	A System for Managing Career Learning
10:15:00	Michael Antonovich	Information Delivery	What's New in Creating Data Models and Reporting with Power BI
10:15:00	Frank Quintana	Strategy and Architecture	Hadoop 123. NoSQL, Not Only SQL SQL Everywhere
10:15:00	Vishal Pawar	BI Platform Architecture, Development Administration	Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice
10:15:00	Dustin Ryan	BI Platform Architecture, Development Administration	Building a Data Warehouse from the Ground Up
10:15:00	Katie Schmidt	Enterprise Database Administration Deployment	DevOps Database Obfuscation
10:15:00	Jignesh Patel	Other	Powershell for DBA to day to day stuff
10:15:00	Harvey Hyman	Application Database Development	SQL Server Fundamentals for Beginners
11:45:00	Shawn Meyers	Enterprise Database Administration Deployment	Successfully Virtualizing SQL Server on vSphere
11:45:00	Craig Allen	Strategy and Architecture	Modernize SQL with Dell Technologies
13:00:00	Buck Woody	Advanced Analysis Techniques	Introduction to SQL Server Big Data Clusters
13:00:00	George Walkey	BI Platform Architecture, Development Administration	The SSRS 2017 Restful API
13:00:00	Jose Chinchilla	BI Platform Architecture, Development Administration	Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.
13:00:00	John Wang	Strategy and Architecture	Introduction to IoT using Azure
13:00:00	Doug McClurg	BI Platform Architecture, Development Administration	Tracking Change is the Backbone of Your Data Platform
13:00:00	Martina Tesar	Compliance and Security	Partnership Between Audit and Technology Teams
13:00:00	Erica Woods	Professional Development	Your Interview Prep Action List - 11 To-Dos to Rock Their Socks Off!
13:00:00	Jeff Taylor	Enterprise Database Administration Deployment	SQL Server 2019 CTP 2.x - New Features
13:00:00	Carolyn Risk	Application Database Development	How to Speak SQL
14:15:00	Andy Warren	Application Database Development	Constraints are the Key (to Data Integrity)
14:15:00	Frank Quintana	Strategy and Architecture	“Past, Present and Future of the Data Profession"
14:15:00	Shawn Meyers	Professional Development	How to make a SQL Saturday Presentation
14:15:00	Jen Underwood	Analytics and Visualization	Storytelling for Machine Learning and Advanced Analytics
14:15:00	James McAuliffe	Enterprise Database Administration Deployment	Changing Data Is Easy, Managing Data Change is Hard!
14:15:00	Alexander Fleming	BI Platform Architecture, Development Administration	Why You Should Consider Implementing Indexed Views
14:15:00	Adriano da Silva	Analytics and Visualization	An Introduction to Power BI for Data Science With Python
14:15:00	Travis Page	Compliance and Security	Look, over there, your permissions are showing!
14:15:00	Suzanne Ricci	Professional Development	Creating a Resume for Online Submission
15:45:00	George Walkey	Enterprise Database Administration Deployment	Using Powershell to Document SQL Server
15:45:00	Ronald Dameron	Cloud Application Development Deployment	Azure Resource Management with PowerShell
15:45:00	Jeff Taylor	Enterprise Database Administration Deployment	How To Tune A Multi-Terabyte Database For Optimum Performance.
15:45:00	Michael Antonovich	BI Information Delivery	Accessibility Concerns of Reporting Style with Power BI
15:45:00	Jose Chinchilla	Analytics and Visualization	Become a Power BI superstar under 1 hour !
15:45:00	Robert Hatton	Application Database Development	Thinking in SQL
15:45:00	Dale Sullenberger	Application Database Development	Temporal Tables: Creation, Use, and Optimizing
15:45:00	Jo Willetts	Professional Development	Stop Leaving Money On the Table – A Data Professional’s Guide to Unlocking Tax S
15:45:00	Gilda Alvarez	Professional Development	Women in IT . A survival kit.

SessionID: 89067

What Is Clogging Your Database Performance?

Back to calendar

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

Speaker: Eddy Djaja

Title: What Is Clogging Your Database Performance?

Abstract:

A concise and systematic approaches rather than guessing to analyze SQL Server performance will be presented. Through measuring the response time and wait time at the query level, the performance bottleneck is pinpointed and tuned. The presentation will look at the basic of gathering the stats from SQL Server DMVs.

SessionID: 89638

Database Corruption

Back to calendar

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

Speaker: Stephen Muliokela

Title: Database Corruption

Abstract:

Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption?

The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues. Highlight of topics

1. Why corruption occurs?
2. Detecting corruption – how SQL Servers detects corruption at the page level.
3. Different types of corruption- e.g. False alarms, memory corruption etc.
4. Limitation of DBCC how to speed the DBCC process.
5. Undocumented DBCC commands.
6. Monitoring I/O errors.
7. Verifying backup for corruption.

SessionID: 89722

Making Sense of the Power BI Ecosystem

Back to calendar

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

Speaker: Dustin Ryan

Title: Making Sense of the Power BI Ecosystem

Abstract:

Power BI has taken the world by storm since it's release in mid-2015. Since then, Microsoft's cloud analytics service has matured and grown in scope and complexity. In this session, we'll seek to understand the moving parts of the Power BI ecosystem including Power BI Pro, Premium, Report Server, Embedded, Data Flows, and more. By the end of this session the audience should have a firm grasp on the components ecosystem and how those components work together.

SessionID: 89849

2017 SSIS Scale Out for HA/DR ETL

Back to calendar

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

Speaker: Paul LaGrone

Title: 2017 SSIS Scale Out for HA/DR ETL

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. This session 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: 89887

Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Back to calendar

Event Date: 23-03-2019 - Session time: 09:00:00 - Track: Compliance and Security

Speaker: Michael Keleher

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract:

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

SessionID: 90135

Continuous Analytics Deployment with Azure DevOps

Back to calendar

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

Speaker: Doug McClurg

Title: Continuous Analytics Deployment with Azure DevOps

Abstract:

DevOps lives at the fast paced intersection of developers and IT professionals. Our business partners are learning and expanding their analytics toolkit, putting more pressure on technical teams to deliver analytics at an accelerated operational cadence. I'm here to show you how to automate your production database code delivery even in large data warehouse environments.

SessionID: 90173

14 Tips for an Effective Job Search Leveraging Recruiters

Back to calendar

Event Date: 23-03-2019 - Session time: 09:00:00 - Track: Professional Development

Speaker: Erica Woods

Title: 14 Tips for an Effective Job Search Leveraging Recruiters

Abstract:

It’s no surprise that embarking upon a job search can be a high-anxiety time. However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels (including 5 key resume truths), working with Recruiters, always attempting the "referral route," leveraging alerts and other strategies, etc. can help reduce frustrations and make it better. In this session, we’ll highlight our top 14 strategies to help you go from "I'm not finding jobs I'm interested in" and/or "I'm not hearing back on my resume or from Recruiters" to "it's time to prepare for my interview!"

SessionID: 90817

Understanding SQL Server Backup and Restore

Back to calendar

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

Speaker: Tim Radney

Title: Understanding SQL Server Backup and Restore

Abstract:

Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn't know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, file group, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There's something here for everyone to learn!

SessionID: 90820

REAL WORLD REPORT SERVER PERFORMANCE SCALABILITY STRATEGIES

Back to calendar

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

Speaker: David Pless

Title: REAL WORLD REPORT SERVER PERFORMANCE SCALABILITY STRATEGIES

Abstract:

In this session we will cover the best strategies to track and improve SSRS / Power BI Report Server performance and scalability. We will cover methods of tracking report performance through DMVs, leveraging the Report Server ExecutionLog3 catalog view, and monitoring Power BI Report Server / Reporting Services using performance monitor (perfmon), and more. We will analyze this information through T-SQL queries in SSMS and Power BI analysis.

We will discuss when to scale out the Report Server and when to focus on the reporting dataset queries that driven through report execution.

We will cover methods of isolating Report Server performance from OLTP activity and solutions to isolate expensive reports when you cannot isolate the OLTP and reporting overhead.

Finally, we will cover Reporting Services and Power BI Report Design techniques to improve report performance and scalability.

We will cover Azure Data Studio extensions, Power BI Dashboards, and examining the exec

SessionID: 89084

Fundamentals That Will Improve Your Query Performance!

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: Application Database Development

Speaker: John Wells

Title: Fundamentals That Will Improve Your Query Performance!

Abstract:

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

SessionID: 89193

A System for Managing Career Learning

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: Professional Development

Speaker: Andy Warren

Title: A System for Managing Career Learning

Abstract:

Are you investing enough time and in right place when it comes to learning new stuff? Or do you feel like you're spending too much time? Or, more commonly, that you're setting goals and then falling off track? All of us struggle to manage learning while sustaining a career and family. But it IS possible! This session is designed to give you a prescriptive solution to the challenges of managing learning; identifying what you need to learn, how much time to invest in learning each topic, scheduling and tracking your learning, and recovering from the interruptions that life throws at us. My system won't make you rich, but it will make you feel in control of your career learning goals.

SessionID: 89250

What's New in Creating Data Models and Reporting with Power BI

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: Information Delivery

Speaker: Michael Antonovich

Title: What's New in Creating Data Models and Reporting with Power BI

Abstract:

Power BI has grown into a very useful and powerful tool to analyze your corporate data, but not everyone knows that it is a product that is literally changing monthly. Each month Microsoft introduces new features to the downloaded and online versions of PowerBI. Keeping up can be time consuming. However, Microsoft provides documentation, videos, and other resources to not only help you up to date with these changes, but to also allow you to vote on potential new features and even to submit new feature ideas of your own. If you have not been keeping up with the changes to Power BI since you first downloaded your desktop version a year or more ago, you need to attend this session to learn how to keep up with this ever changing, ever improving product.

SessionID: 89377

Hadoop 123. NoSQL, Not Only SQL SQL Everywhere

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: Strategy and Architecture

Speaker: Frank Quintana

Title: Hadoop 123. NoSQL, Not Only SQL SQL Everywhere

Abstract:

Since the end of the previous decade, our profession has been kicked by a set of new models, technologies, and architectures that are revolutionizing our practice. I pretend to clarify the position of SQL as the LINGUA FRANCA for Data and the relational model versus the allegations of deprecation of the relational model, and the NoSQL movement presentation of SQL as a language with no future. These among others are the topics of my presentation.

In this presentation, I will depict the Hadoop evolution from version1 to version 3, and its relation to legacy architectures models and in particular to SQL.

SessionID: 89547

Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Vishal Pawar

Title: Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Abstract:

To improve the performance, sustainability, security and scalability of enterprise-grade Power BI implementations with constant velocity, we need to adhere best practices

In this session Vishal will go over Power BI Ecosystem with Example, PBI RS evolution from its inception Architecture of Enterprise Power BI Report Server and usage through various tool available to publish -SSDT SSRS, Power BI Desktop(Optimized Version), Report Builder and mobile report builder and various Best Practices for PBI Report Server.

SessionID: 89726

Building a Data Warehouse from the Ground Up

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dustin Ryan

Title: Building a Data Warehouse from the Ground Up

Abstract:

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a semantic modeling technologies like SQL Server Analysis Services or Power BI and how the choices we make during the data warehouse design phase can make or break our reports.

SessionID: 90396

DevOps Database Obfuscation

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Katie Schmidt

Title: DevOps Database Obfuscation

Abstract:

Database masking, obfuscation, CI, CD... What is this stuff? This is a story about how we did a complete overhaul on our development life cycle to create more outcomes for our users, resolve communication issues with the team, and provide pre-production databases for our developers through database obfuscation. We will discuss our why, our team structure, the preparation work completed, the database obfuscation process tools available.

SessionID: 90564

Powershell for DBA to day to day stuff

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15: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: 90796

SQL Server Fundamentals for Beginners

Back to calendar

Event Date: 23-03-2019 - Session time: 10:15:00 - Track: Application Database Development

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

Successfully Virtualizing SQL Server on vSphere

Back to calendar

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

Speaker: Shawn Meyers

Title: Successfully Virtualizing SQL Server on vSphere

Abstract:

Today, many organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications.

Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by a member of the VMware's SQL Server Experts Group.

SessionID: 91650

Modernize SQL with Dell Technologies

Back to calendar

Event Date: 23-03-2019 - Session time: 11:45:00 - Track: Strategy and Architecture

Speaker: Craig Allen

Title: Modernize SQL with Dell Technologies

Abstract:

Abstract: Dell Technologies has infrastructure platforms to Accelerate, Protect, and Modernize your SQL Server environments. SQL Server 2017/2019 coupled with advanced hardware platforms from Dell allows you to move to the next level of performance. Learn how next-gen hardware integrates directly into SQL Server.

SessionID: 88998

Introduction to SQL Server Big Data Clusters

Back to calendar

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

Speaker: Buck Woody

Title: Introduction to SQL Server Big Data Clusters

Abstract:

In this session you will learn how SQL Server 2019 implements an elastically scalable storage layer that integrates SQL Server on Linux, PolyBase, Containers, Kubernetes, Spark and HDFS to scale to petabytes of data storage. You’ll get a complete explanation about the architecture for this platform, and you’ll also learn about common use case scenarios for using big data clusters.

SessionID: 89001

The SSRS 2017 Restful API

Back to calendar

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

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

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

Back to calendar

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

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

Introduction to IoT using Azure

Back to calendar

Event Date: 23-03-2019 - Session time: 13:00: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: 90136

Tracking Change is the Backbone of Your Data Platform

Back to calendar

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

Speaker: Doug McClurg

Title: Tracking Change is the Backbone of Your Data Platform

Abstract:

Features and concepts like Change Tracking, Change Data Capture, Temporal Tables, and other similar delta systems are complex and may carry a stigma or misapprehension in your organization around performance or security or cost. Even if you do not directly implement these features or methods absolutely, most information systems rely on tracking changes especially from legacy line of business applications. I'm here to show you robust techniques for implementing delta systems in SQL Server to increase the trustworthiness of your data warehouse. I will also steer you away from common pitfalls.

SessionID: 90146

Partnership Between Audit and Technology Teams

Back to calendar

Event Date: 23-03-2019 - Session time: 13:00:00 - Track: Compliance and Security

Speaker: Martina Tesar

Title: Partnership Between Audit and Technology Teams

Abstract:

Quick Introduction and Agenda Overview

Roles and Responsibilities Audit and Compliance Teams Data Owners and Technology Owners Tips for Successful Collaboration Framing the Audit or Assessment Agreed Upon Findings Responding to Inquiry Partnering with Compliance and Audit Teams Questions and Contact Info

SessionID: 90180

Your Interview Prep Action List - 11 To-Dos to Rock Their Socks Off!

Back to calendar

Event Date: 23-03-2019 - Session time: 13:00:00 - Track: Professional Development

Speaker: Erica Woods

Title: Your Interview Prep Action List - 11 To-Dos to Rock Their Socks Off!

Abstract:

"I feel like I'm always the runner up or 2nd place candidate..."

The job market is fierce, and Managers are interviewing several qualified candidates. When you combine that with the fact that 92% of interviewees are highly anxious, and nerves impact their performance, and that most candidates simply don't know how to effectively market themselves, it's easy to see why interviewing is one of the most frustrating parts of the job search. However, we'll teach you some tricks for preparing the right way, how to market yourself effectively, how to conduct a SWOT Analysis to guide your interview prep, provide example best practice questions to ask, share confidence building strategies and provide some favorite recommended resources and tools!

SessionID: 90263

SQL Server 2019 CTP 2.x - New Features

Back to calendar

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

Speaker: Jeff Taylor

Title: SQL Server 2019 CTP 2.x - New Features

Abstract:

In this session, we will cover the new features that are being introduced in SQL Server 2019 CTP 2.x.

SessionID: 90528

How to Speak SQL

Back to calendar

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

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

Constraints are the Key (to Data Integrity)

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Andy Warren

Title: Constraints are the Key (to Data Integrity)

Abstract:

This session is designed to introduce you or to re-engage your interest in all the options we have for setting constraints in a database. From datatypes to nulls to checks, defaults, foreign keys, and triggers we have a LOT of options, so it's important to know the options and also have a bit of a professional philosophy on when to use each of them - we will do a brief look at each of them. We'll talk about why getting them right on day 1 is so important, how to add them to existing tables (the syntax is the least interesting part!), and some patterns and anti-patterns you can look for when you get to the office on Monday. Constraints aren't glamorous, but they matter, and they require an advocate - you! A good session for DBA's, developers, and yes, even managers.

SessionID: 89378

“Past, Present and Future of the Data Profession"

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Strategy and Architecture

Speaker: Frank Quintana

Title: “Past, Present and Future of the Data Profession"

Abstract:

In the excitement of the possibilities that Big Data technology and Data Science techniques are opening, we forgot that correlation is not equal than causation and that any design model has intrinsic limitations. Dr. Deming said "In God we trust, all others must bring data." but what he really wanted to reach was Wisdom! Data is just the raw material the real goal is Wisdom I have been thinking about the chain toward Wisdom (Data-Information-Knowledge-Wisdom) and wonder how many organizations have reached, at least, the level of Knowledge and if any at all have reached the pinnacle of Wisdom. We are drowning in a sea of data and we are starving for wisdom.

How is Data Science and Big Data changing our profession? What is a Data Scientist? What is a Data Engineer? What is a Data Analyst? Which skills do we need?

SessionID: 89897

How to make a SQL Saturday Presentation

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Professional Development

Speaker: Shawn Meyers

Title: How to make a SQL Saturday Presentation

Abstract:

Nearly everyone one who attends a SQL Saturday has something to share, which others can learn from. This session covers how to take your knowledge and ideas and turn them into a presentation. Most of the focus will be on content generation and organization of your idea into a presentation and demonstrations, to allow you to present.

SessionID: 90059

Storytelling for Machine Learning and Advanced Analytics

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Jen Underwood

Title: Storytelling for Machine Learning and Advanced Analytics

Abstract:

Storytelling and depiction of information has existed for hundreds of years in various forms and formats. In today’s era of artificial intelligence and machine-assisted analytics, accurately interpreting and effectively communicating findings is becoming a crucial skill to bridge the growing data literacy gap. To help decision makers get the most value from analytics projects to drive better outcomes, you need to help them make sense of the results.

Machine learning and advanced analytics can be difficult to understand and explain. Describing the problem, the model, the relationships among variables and the findings are often subtle, surprising and technically complex. Effectively translating quantitative insights and telling a compelling story requires planning, compelling design, and visualization choices. Successful analytical communicators use the entire process to communicate with stakeholders. Don't miss this fun demo-packed educational session.

SessionID: 90116

Changing Data Is Easy, Managing Data Change is Hard!

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: James McAuliffe

Title: Changing Data Is Easy, Managing Data Change is Hard!

Abstract:

Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.

SessionID: 90147

Why You Should Consider Implementing Indexed Views

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

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 demonstrations in order to clarify my points further and provide more opportunities for the audience to ask questions.

SessionID: 90216

An Introduction to Power BI for Data Science With Python

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Adriano da Silva

Title: An Introduction to Power BI for Data Science With Python

Abstract:

This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services.

This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy, etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.

SessionID: 90313

Look, over there, your permissions are showing!

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Compliance and 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: 90789

Creating a Resume for Online Submission

Back to calendar

Event Date: 23-03-2019 - Session time: 14:15:00 - Track: Professional Development

Speaker: Suzanne Ricci

Title: Creating a Resume for Online Submission

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

Using Powershell to Document SQL Server

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45: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: 89025

Azure Resource Management with PowerShell

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Ronald Dameron

Title: Azure Resource Management with PowerShell

Abstract:

You’re company is transitioning to the Cloud. Initially, your Azure deployment was small and could be managed primarily via the Azure portal but now it spans the globe with implementations in several countries. You have too many resources to manage with the Azure portal alone. You can automate these tasks with PowerShell without being a PowerShell expert. I’m Ronald Dameron. I’m responsible for managing the resources of twelve Azure subscriptions containing hundreds of resources. I can show you how. I’ve done it.

SessionID: 89092

How To Tune A Multi-Terabyte Database For Optimum Performance.

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Taylor

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Abstract:

This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.

SessionID: 89248

Accessibility Concerns of Reporting Style with Power BI

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Michael Antonovich

Title: Accessibility Concerns of Reporting Style with Power BI

Abstract:

Reports are no longer just black and white columns and rows of numbers. Reports combine tables with charts, KPIs and more. There is a lot to be concerned about when designing reports to provide information to your audience. Today, your company can face lawsuits if your reports are not accessible to all users. You must consider the way you display your data, the amount of data displayed, the use of color and maybe even the use of animation. Creating attractive reports is not just about making them pretty. It is about grabbing your audience's attention. It is making sure you don't inadvertently introduce accessibility problems that limit who can receive your message, your data. This session while looking at some reporting best practices will also give you information to steer you clear of accessibility concerns to insure access to your results by all consumers of your report. (Note: Accessibility is governed through the guidelines of the American Disabilities Act)

SessionID: 89289

Become a Power BI superstar under 1 hour !

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Jose Chinchilla

Title: Become a Power BI superstar under 1 hour !

Abstract:

Power BI is Microsoft's industry leading data analytics discovery and visualization tool that has disrupted the way data professionals interact and derive insights from their data. It is one of the most in-demand and sought-after tools to know in today's IT career market. Join us for a fun and interactive learning opportunity to learn how to ingest, transform and visualize data from a wide variety of sources using Power BI. Learn how to create rich and interactive reports incorporating slicers, drill-down and drill-through actions. Attendees will also learn how to create, publish and share reports and dashboards for desktop and mobile consumption. Attendees will walk-away feeling like real Power BI *superstars, capable of tackling any data project in their paths! *Awesomeness may vary.

SessionID: 89903

Thinking in SQL

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Robert Hatton

Title: Thinking in SQL

Abstract:

SQL is conceptually different than most programming languages. Join us for a conversation about SQL, why it's different from traditional procedural languages, and how to effectively use this truly elegant programming language. Rather than focus on the kinds of information easily located on the Web, we'll concentrate on how to use SQL for the tasks that it's really good at. Beginners will get a great introduction to the style of thought that gets the most out of SQL. Experienced developers will find a good refresher and an opportunity to share their experiences with others.

SessionID: 90295

Temporal Tables: Creation, Use, and Optimizing

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Dale Sullenberger

Title: Temporal Tables: Creation, Use, and Optimizing

Abstract:

With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables, query the data from the tables for different scenarios, and optimize them for query performance allowing simplicity for the consumers of the data.

SessionID: 90493

Stop Leaving Money On the Table – A Data Professional’s Guide to Unlocking Tax S

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: Professional Development

Speaker: Jo Willetts

Title: Stop Leaving Money On the Table – A Data Professional’s Guide to Unlocking Tax S

Abstract:

Tired of paying too much in taxes? Learn how to save on your taxes by taking advantage of every credit and deduction you are eligible for. Jo Willetts will explain tax reform changes and delve into the deductions and credits you could be eligible for so you can keep more of your money come tax time.

SessionID: 90758

Women in IT . A survival kit.

Back to calendar

Event Date: 23-03-2019 - Session time: 15:45:00 - Track: Professional Development

Speaker: Gilda Alvarez

Title: Women in IT . A survival kit.

Abstract:

My journey of survival and overcoming discrimination, harassment, divorce, layoffs , single mothering and death . Independent of any industry women share many struggles, but it is more difficult when you try to do in an industry dominated by men. I will be sharing my experiences and tools to grow in your personal and professional life.

This site is open source. Improve this page.