sqlsathistory

Nr: 920

Back to Main list

SQLSaturday #920 - Oregon 2019

Start Time (24h)	Speaker	Track	Title
08:30:00	Thomas Grohser	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	Using Clustered Column Store Indexes at Scale
08:30:00	Steve Wake	BI Arch/Admin: Design, ETL, SSIS, EDW	Power BI Premium: Just the Facts
08:30:00	James McGillivray	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	Windowing Functions: Shedding some light
08:30:00	Aaron Cutshall	Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips	Defining What's Normal -- The Basics of Database Normalization
08:30:00	Ganesh Lohani	Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.	Data Science 101: An Introduction to Data Science Using Python
08:30:00	Erland Sommarskog	DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR	Certificates and EXECUTE AS - Putting Permissions Inside Stored Procedures
08:30:00	Martin Catherall	Professional Development: Career, Skills, Interviewing, Managing, WIT	Data Privacy and Data Security in a Data-Driven world
08:30:00	Oliver Engels	BI Arch/Admin: Design, ETL, SSIS, EDW	Common Data Model - Our new buddy for Data Governance
08:30:00	Michael Wall	Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips	Lightning Talks Session 1
10:15:00	Kellyn Pot'Vin-Gorman	Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc.	Be Part of the Solution with Automation
10:15:00	Neil Hambly	BI Design: Delivery: Power BI, SSRS, Visualization	PowerBI Model Designs Techniques
10:15:00	Ben Miller	DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR	Tips and Tricks for the PowerShell DBA [VIDEO]
10:15:00	Brian Ziff-Levine	Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips	SQL for Product Mangers and Business Line Managers
10:15:00	Padmashree Koneti	Professional Development: Career, Skills, Interviewing, Managing, WIT	Grabbing the brass ring: tools for better self-advocacy in the tech workplace
10:15:00	Erik Darling	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	The SQL Server Performance Tasting Menu
10:15:00	Robby Boney	Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.	The Jupyterian Snake Invasion: Intro to Jupyter Notebooks, Python, Azure and Beyond [VIDEO]
10:15:00	Ken Puls	BI Arch/Admin: Design, ETL, SSIS, EDW	BI in Modern Excel: The value is in the Refresh
10:15:00	Michael Wall	Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips	Lightning Talks Session 2
11:45:00	Daniel Cai	BI Arch/Admin: Design, ETL, SSIS, EDW	KingswaySoft - Supercharge your ETL Dev with Advanced SSIS Components
11:45:00	Diane Schuster	BI Arch/Admin: Design, ETL, SSIS, EDW	CozyRoc: Dynamic Data Flows in SSIS Without Programming
11:45:00	Tillmann Eitelberg	BI Arch/Admin: Design, ETL, SSIS, EDW	OH22 - Data Quality in Action
11:45:00	Brandon Leach	DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR	VMWare - Virtualizing SQL Server on vSphere
11:45:00	Jackie Wilushewski	BI Design: Delivery: Power BI, SSRS, Visualization	Marquam - How to Make Beautiful Dashboards in Power BI
11:45:00	Brian Whittington	BI Arch/Admin: Design, ETL, SSIS, EDW	Becoming Data-Driven with Snowflake
11:45:00	Chris Finlan	BI Design: Delivery: Power BI, SSRS, Visualization	Power BI - Ask Microsoft Anything
11:45:00	Elliott Whitling	Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.	Interject - Are you prepping for the Data Apocalypse?
11:45:00	Karan Kumar	BI Arch/Admin: Design, ETL, SSIS, EDW	Talend - Delivering Trusted Data at Speed
13:00:00	Randolph West	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	Back to the Future with Temporal Tables
13:00:00	Melody Zacharias	Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.	Introduction to AI
13:00:00	Joshua Higginbotham	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	Introduction to GitHub
13:00:00	Angela Henry	BI Design: Delivery: Power BI, SSRS, Visualization	What is Power BI?
13:00:00	Adrian Mee	Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips	SQL Server Management Studio - Beyond the basics
13:00:00	Vern Rabe	DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR	Get Faster Queries with Better Statistics Management
13:00:00	Gabi Münster	DevOps: Agile Processes between Dev and Ops	Continuous Intelligence... Is it all about automation?
13:00:00	Frank Geisler	BI Arch/Admin: Design, ETL, SSIS, EDW	Code Your Report Environment
13:00:00	Michael Wall	Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc.	Lightning Talks Session 3
14:45:00	Rob Volk	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	That's So Metadata: Discover Your Database From The Inside
14:45:00	Ted Stathakis	BI Arch/Admin: Design, ETL, SSIS, EDW	Reporting Services Tips, Tricks, Templates and Considerations
14:45:00	Frank Geisler	DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR	SQL on Docker 101
14:45:00	Christopher Unwin	DevOps: Agile Processes between Dev and Ops	Protect your Data by Design: Creating a Data Masking Strategy
14:45:00	Asgeir Gunnarsson	BI Design: Delivery: Power BI, SSRS, Visualization	Enterprise Power BI - Development Lifecycle [VIDEO]
14:45:00	Randy Knight	Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips	Locks? We don't need no stinkin' locks!
14:45:00	Heidi Hasting	Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips	Intro to Azure Data Studio
14:45:00	Michael Curry	Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.	Theory Driven Data Science: Cyber-security Improvement using SQL, R and machine learning [Video]
14:45:00	Michael Wall	Professional Development: Career, Skills, Interviewing, Managing, WIT	Lightning Talks - Session 4
16:15:00	Thomas Norman	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	Encrypting Data Within SQL Server
16:15:00	Slava Murygin	BI Design: Delivery: Power BI, SSRS, Visualization	Power BI: From Zero to 101
16:15:00	Christine Assaf	Professional Development: Career, Skills, Interviewing, Managing, WIT	Mastering your Resume Interview: Tips to Get Hired
16:15:00	Julie Koesmarno	Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc.	Azure SQL Database Edge - Tiny but mighty
16:15:00	Kathi Kellenberger	DevOps: Agile Processes between Dev and Ops	What is DevOps and Why Should DBAs Care? [VIDEO]
16:15:00	Janis Griffin	DBDev: Development, Tools, Scalability, Query Tuning and Indexing	Inside the Query Store. What Knowledge can You Gain?
16:15:00	Jamey Johnston	BI Design: Delivery: Power BI, SSRS, Visualization	Enterprise Row Level Security in SQL Server and Power BI [VIDEO]
16:15:00	Hamish Watson	DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR	Essential Linux skills for SQL Server DBAs
16:15:00	Michael Wall	BI Arch/Admin: Design, ETL, SSIS, EDW	Lightning Talks - Session 5

SessionID: 96168

Using Clustered Column Store Indexes at Scale

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

Speaker: Thomas Grohser

Title: Using Clustered Column Store Indexes at Scale

Abstract:

Using a real world example that is in production this session will go though pitfalls I experienced and how to avoid these mistakes in the beginning which will save you lots of data wrangling over time.

Clustered Column Store Indexes are a great tool when used correctly. This session will explain on how to plan, configure, and operate Clustered Colum Store indexes to handle trillions of rows.

SessionID: 96183

Power BI Premium: Just the Facts

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Steve Wake

Title: Power BI Premium: Just the Facts

Abstract:

What is Power BI Premium and how is it different then Power BI and Power BI Pro? What do you get for the $5000/month that Power BI Premium costs and what are the alternatives (if any)? In this session, we will go over all the differences between the Power BI offerings from Microsoft and some of the features yet to come. With multiple demos we will walkthrough the features of Power BI Premium so that you can see if it provides value to your company. Come to this session if you have been thinking about Power BI Premium, but you have been unable to determine if it is right for your company. At the end of this session, you will be armed with all of the knowledge you will need to make the right decision.

SessionID: 96273

Windowing Functions: Shedding some light

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

Speaker: James McGillivray

Title: Windowing Functions: Shedding some light

Abstract:

One of the simplest ways to enhance the value of the information we provide is to add context. Supplementing each data point with information from a larger data set is a common way of adding this context. In T-SQL, we achieve this by using Windowing Functions.

In this demo-heavy session, we will walk through the uses of Windowing Functions, from simple row orders to more complicated calculations like rolling averages. We'll explore each keyword in turn, building more sophisticated functions as we do. Each concept is illustrated in a visual, and T-SQL example so it is clearly understood.

So whether it's tracking a value against the previous row, creating running totals, or a rolling sum, when you walk out of this session, you'll be able to write a windowing function to make it happen.

SessionID: 96323

Defining What's Normal -- The Basics of Database Normalization

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips

Speaker: Aaron Cutshall

Title: Defining What's Normal -- The Basics of Database Normalization

Abstract:

Determining how to efficiently design database structures for a given application has always relied on the same old answer: "It depends!" So, how do you determine what level of normalization your data requires? This session will review the principles of data normalization, show the impact that normalization can have on performance and data integrity, and just as importantly, show you when it's OK to break the rules and denormalize. We will cover some case situations where it's better not to be normal!

SessionID: 96706

Data Science 101: An Introduction to Data Science Using Python

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.

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

Certificates and EXECUTE AS - Putting Permissions Inside Stored Procedures

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR

Speaker: Erland Sommarskog

Title: Certificates and EXECUTE AS - Putting Permissions Inside Stored Procedures

Abstract:

The basic mechanism when we want to give users access to data or actions in SQL Server in a controlled way through stored procedure is ownership chaining. This is something we use everyday as SQL workers, although we may not be aware of it. Every once in a while, we run into situations where it seems that it is not sufficient to put a statement in a stored procedure, but that users need to be granted explicit permissions – something we may not always be comfortable with, because that would permit the users to do things we do not want them to be able to.

There are two additional mechanisms in SQL Server we can employ in these situations: certificate signing and the EXECUTE AS clause. In this session I will start by exploring how ownership chaining works and its limitations. I will then proceed to explore the other two options and I will particularly focus on certificate signing, as this is the preferred method. At first it may seem overly complex, but I will show how it easily can be automated. EXECUTE AS may seem simpler, but I will point out potential problems with it, not the least if you try to use it on server level and consider to set the database as TRUSTWORTHY.

This session is directed towards both developers and DBAs, as this session deals with problems you may face in either roles.

SessionID: 98181

Data Privacy and Data Security in a Data-Driven world

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: Professional Development: Career, Skills, Interviewing, Managing, WIT

Speaker: Martin Catherall

Title: Data Privacy and Data Security in a Data-Driven world

Abstract:

New advances in technology coupled with the rate of change in the data-driven world are placing the issue of Privacy and Ethics at the forefront of public consciousness – forcing a discussion around the ethical use of data within business and the role that each data professional must play in ensuring that the highest standards are reached, maintained, and constantly evaluated. Technologies such as machine learning, artificial Intelligence, and big data processing are providing new business opportunities that must also account for privacy and ethics issues while maintaining a balance with compliance, security, and integrity of data.

But what are the issues that individual data professionals should be aware of to avoid reputational damage to their companies and themselves? And what are the tools that can help them in their endeavors?

This session will take a close look at some of these challenges and the tools that are available to help mitigate these issues and risks.

SessionID: 98189

Common Data Model - Our new buddy for Data Governance

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Oliver Engels

Title: Common Data Model - Our new buddy for Data Governance

Abstract:

Common Data Model as the foundation of Power BI Dataflows and as part of the Open Data Initiative with SAP and Adobe, seems to be a pretty good move from Microsoft. We want to take a closer look to this approach. In this session we show how the Common Data Model will allow you to combine Self-Service ETL and Corporate Data Engineering. We will show you how Power BI and more specialised tools like ADF, DataBricks etc. can work together on the Azure Data Lake with one common model. We than extend this and show, what opportunities this standard brings to you, when we unleash the possibilities you have on managing Data Quality and Governance. We also will have a look in how you integrate CDM in a DataOps Methodology.

SessionID: 99584

Lightning Talks Session 1

Back to calendar

Event Date: 02-11-2019 - Session time: 08:30:00 - Track: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips

Speaker: Michael Wall

Title: Lightning Talks Session 1

Abstract:

Catherine Siverts: Diverse Voices in Analytics: Designing Case Studies

Slava Murygin: SQL joins Slava Murygin: SSMS Shortcuts

SessionID: 96216

Be Part of the Solution with Automation

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc.

Speaker: Kellyn Pot'Vin-Gorman

Title: Be Part of the Solution with Automation

Abstract:

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. Unlike a session on concepts, this session surrounds itself with a real-life situation and how automation was used with DevOps practices to build a solution.

The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.

SessionID: 96330

PowerBI Model Designs Techniques

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: BI Design: Delivery: Power BI, SSRS, Visualization

Speaker: Neil Hambly

Title: PowerBI Model Designs Techniques

Abstract:

Building effective PowerBI reports and dashboards requires a well-designed data model with the right relationships and measures.

This session will tackle these design challenges head on and show how to approach this critical phase. With an example project to guide us through the design phase and the various stages as we progress to a completed working data model and have a template for reusing on other projects. Along the way we will show the DevOps approach to building the design model .

SessionID: 96502

Tips and Tricks for the PowerShell DBA [VIDEO]

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR

Speaker: Ben Miller

Title: Tips and Tricks for the PowerShell DBA [VIDEO]

Abstract:

Do you have more than 1 server that you manage? More than 1 database? Then this session is for you. PowerShell interest is on the rise and it is one of the coolest tools you can learn as a DBA. Learn tips and tricks using PowerShell that will help you manage SQL Servers and get more done with less effort. From getting started in PowerShell to getting information about your servers/databases to making changes to your SQL Servers all using PowerShell. This is one tool you will want in your toolbelt to help sharpen your skills.

SessionID: 96521

SQL for Product Mangers and Business Line Managers

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips

Speaker: Brian Ziff-Levine

Title: SQL for Product Mangers and Business Line Managers

Abstract:

If you’re a product manager or business owner who’s relied on others, be it data analysts, DBAs, or other data professionals to pull data for you to analyze and visualize, then this is the session for you. This session will focus on real-world examples of how to use SQL to get the data you need to improve your product, speed up your innovation cycles, gain product insights faster, and generally become a leaner, more functional product manager through the use of data.

This session will focus on basic SQL queries that are common for product managers (date ranges, sorting, basic aggregate functions like SUM and COUNT) and useful tools to help make the process easier to implement (Azure Data Studio, Docker, Kitematic, MySQL, Azure SQL, PowerBI, and others). Attendees will come away from this session with a better understanding of SQL and how it can be used and applied for more product and business focused applications and testing.

SessionID: 97958

Grabbing the brass ring: tools for better self-advocacy in the tech workplace

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: Professional Development: Career, Skills, Interviewing, Managing, WIT

Speaker: Padmashree Koneti

Title: Grabbing the brass ring: tools for better self-advocacy in the tech workplace

Abstract:

Have you ever felt passed up for a promotion or a stretch assignment because you identify as a woman, non-binary and/or as BIPOC (black, indigenous, or a person of color)? Have you ever had a chance to reach for the proverbial brass ring but did not or was prevented from doing so?

Many workplaces endeavor to create an inclusive and equitable workplace but end up missing the mark by perpetuating systemic biases that impact the ability for folks to realize their fullest career potential, or even get access to the game at all. Join a panel of prolific speakers from PDX Women In Tech who will address topics like what to do when gender and/or race set the tone for the environment, and what to do when leadership doesn’t recognize an opportunity to promote equity. Audience (all are welcome) will be able to learn new ways to approach self-advocacy (or, in the case of allies, advocacy) and tips and techniques to further the conversation around equity and inclusion in their workplace.

SessionID: 98176

The SQL Server Performance Tasting Menu

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

Speaker: Erik Darling

Title: The SQL Server Performance Tasting Menu

Abstract:

You’re a DBA or Developer, and you’ve been using SQL Server for a few years.

You know there are different ways to make queries faster, but you’re not sure when to use them.

I’m Erik Darling, and I’ll be your sommelier for the evening.

Over several courses of delicious demos, I’ll show you the types of performance problems different tuning techniques pair well with, and which ones to avoid.

When we’re done, you’ll understand exactly what patterns to look for when you’re troubleshooting slow queries, and how to approach them.

You’ll have the secret recipe for gourmet queries.

SessionID: 98183

The Jupyterian Snake Invasion: Intro to Jupyter Notebooks, Python, Azure and Beyond [VIDEO]

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.

Speaker: Robby Boney

Title: The Jupyterian Snake Invasion: Intro to Jupyter Notebooks, Python, Azure and Beyond [VIDEO]

Abstract:

Python and Jupyter Notebooks have become popular with data professionals and cloud platforms such as Azure and Google. With applications in data exploration, analysis, model training, visualization, and data sharing, they've transformed how data professionals work. In conjunction with the growth of these tools, data workflows are also utilizing cloud resources for easier collaboration, access to powerful hardware, and distributed storage/computation. Join us in this interactive session for an intro to Jupyter Notebooks and Python, where they came from, when you should use them and how they are being used on the cloud today. We will walk through a basic data project using some core data packages in Python to explore a dataset and see these tools in action. By the end of this session you will be ready to join the Jupyterian Snake Invasion in data questing!

To get a head start with Jupyter, explore your first notebook with Azure notebooks: https://notebooks.azure.com

SessionID: 98199

BI in Modern Excel: The value is in the Refresh

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Ken Puls

Title: BI in Modern Excel: The value is in the Refresh

Abstract:

2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and one interactive Excel dashboard = mind blowing awesomeness in under 60 minutes. But while the analysis is important, the real value in the refresh. Can your model pull in another 22 text files and next year's budgets in less than a minute? This model can.

Come and see how Excel 2016 gives us the ability to not only rapidly create business intelligence, but also allows us to build engaging and interactive models that can be quickly updated and shared via Power BI.

SessionID: 99585

Lightning Talks Session 2

Back to calendar

Event Date: 02-11-2019 - Session time: 10:15:00 - Track: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips

Speaker: Michael Wall

Title: Lightning Talks Session 2

Abstract:

Session Two :

Melody Zacharias: Resumable Index Rebuild In Action! Ted Stathakis: Commenting your Code! Ted Stathakis: ProperCase - My Favorite UDF Janice Gerbrandt: Automate Tests in your Database with tSQLt.

SessionID: 96181

KingswaySoft - Supercharge your ETL Dev with Advanced SSIS Components

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Daniel Cai

Title: KingswaySoft - Supercharge your ETL Dev 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: 99179

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

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

OH22 - Data Quality in Action

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Tillmann Eitelberg

Title: OH22 - Data Quality in Action

Abstract:

In this session we will discuss how you can get your data quality problems under control on the Microsoft Data Platform. We'll show you how to quickly and easily integrate a duplicate search into your applications, how to migrate Microsoft SQL Server Data Quality Services to Azure, how to clean data with the SSIS-IR and how to improve your self-service processes in Power BI. All this with HEDDA.IO directly on Azure.

SessionID: 99224

VMWare - Virtualizing SQL Server on vSphere

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR

Speaker: Brandon Leach

Title: VMWare - Virtualizing SQL Server on vSphere

Abstract:

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

SessionID: 99265

Marquam - How to Make Beautiful Dashboards in Power BI

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: BI Design: Delivery: Power BI, SSRS, Visualization

Speaker: Jackie Wilushewski

Title: Marquam - How to Make Beautiful Dashboards in Power BI

Abstract:

Want to polish your Power BI dashboards and take them to the next level of design? In this presentation Jackie Wilushewski, a User Experience Designer at Marquam, will guide you through her methodology of User Experience Design. Then, starting with a typical “all-business” dashboard, Jackie will demo step-by-step how to implement simple changes to improve usability and aesthetics.

SessionID: 99278

Becoming Data-Driven with Snowflake

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Brian Whittington

Title: Becoming Data-Driven with Snowflake

Abstract:

To stay competitive in today’s world is to stay agile by making swift, intelligent, data-driven decisions. Join us to see how you can enable your organization to be data-driven with the fastest growing cloud-enabled data warehouse, Snowflake.

Especially if any of the following interests you: • Escaping the constraints of legacy technology. • Delivering insight from all your data to all your business users. • Creating your own data sharing economy. You will also learn: • The ease of Snowflake’s intuitive user interface • How to easily load, integrate and query structured and semi-structured data • What it’s like to run large queries in a fraction of the time • How to effortlessly connect your BI/ETL tools

SessionID: 99496

Power BI - Ask Microsoft Anything

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: BI Design: Delivery: Power BI, SSRS, Visualization

Speaker: Chris Finlan

Title: Power BI - Ask Microsoft Anything

Abstract:

"We are pleased to host a Power BI Ask Microsoft Anything (AMA) at SQL Saturday! This is your opportunity to ask and share feedback directly with Christopher Finlan, Principal Program Manager on the Power BI team. Chris owns the SSRS, Power BI Report Server, Paginated Reports and Power BI product areas along with related items like exporting and subscriptions all-up. Feel free to discuss these (or any) topic related to Power BI and hear the answers straight from the product team. Special guest appearance by Paginated Report Bear as well.”

SessionID: 99549

Interject - Are you prepping for the Data Apocalypse?

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.

Speaker: Elliott Whitling

Title: Interject - Are you prepping for the Data Apocalypse?

Abstract:

The era of unchecked data costs is about to end. Businesses are tired of initiatives that rely on unproven technology, unattainable talent, uncontrolled spending, and, most important, unsatisfactory data literacy. Gartner predicts 80% of the data workforce to be outsourced by 2021. What can we do, as data professionals, to prove our value? How can data literacy become an organizational imperative before it's too late?

SessionID: 99550

Talend - Delivering Trusted Data at Speed

Back to calendar

Event Date: 02-11-2019 - Session time: 11:45:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Karan Kumar

Title: Talend - Delivering Trusted Data at Speed

Abstract:

Data-driven strategies are now a competitive imperative to succeed in every business and industry. To support business objectives such as revenue growth, profitability, and customer satisfaction, organizations are increasingly reliant on data to make decisions.

Talend Data Fabric solves some of the most complex aspects of the data value chain from end to end. Users can collect data across systems, govern it to ensure proper use, transform it into new formats, and improve quality, and share it with internal and external stakeholders – all in a collaborative, multi-cloud data integration environment.•

A unified environment that provides access to all Talend capabilities Native code generation for better performance Self-service data access with governance for increased productivity Pervasive data quality for more confidence and less risk

Talend Data Fabric enables customers to deliver trusted data at speed, providing them with a complete solution for all data n

SessionID: 96155

Back to the Future with Temporal Tables

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

Speaker: Randolph West

Title: Back to the Future with Temporal Tables

Abstract:

Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing. There's even a bit of In-Memory OLTP. There might even be time for demos!

SessionID: 96187

Introduction to AI

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.

Speaker: Melody Zacharias

Title: Introduction to AI

Abstract:

What was AI in the past, what is it now and where will the future take us? Data Science, Azure Machine Learning, and Analytics are all becoming core pieces of a many successful businesses. What are people doing with it and how can it be used in all aspects of business. As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients. Using an easy to follow example, I will show the flow from problem to solution. A demonstration of AI used in the real world.

SessionID: 96219

Introduction to GitHub

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

Speaker: Joshua Higginbotham

Title: Introduction to GitHub

Abstract:

Getting started with GitHub can at times be overwhelming. Especially when you've been working with other source control and project management systems your whole career. In this session, we will overview the below tasks to ensure your success with GitHub.

• Initial setup of a Repository in GitHub.
• Build Issue templates for new features, bugs, or custom tasks.
• Securing the check-in/merge process to your root branch.
• Integrating GitHub with other productivity tools to keep on top of changes.

SessionID: 96320

What is Power BI?

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: BI Design: Delivery: Power BI, SSRS, Visualization

Speaker: Angela Henry

Title: What is Power BI?

Abstract:

You’ve heard all the buzz about Power BI, but you have no idea what it is and how it works. This session explains what Power BI is, who can use it and why you would want to. It’s an introductory session that gives you the information you need to determine if Power BI is right for you and your organization.

SessionID: 96336

SQL Server Management Studio - Beyond the basics

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips

Speaker: Adrian Mee

Title: SQL Server Management Studio - Beyond the basics

Abstract:

Almost all of us use SQL Server Management Studio to interact with SQL Server, and thankfully it works right out of the box. But did you know there are so many tricks and shortcuts that hide just under the surface that can make working with SSMS feel like second nature?

In this session, I will take a fresh install of SSMS and step through customizing it. I will demonstrate features and help you become more efficient at utilizing SSMS to it's fullest potential - a lot of the time without using the mouse. Finally, I’ll show you some cool text editing tricks that will take your SQL skills to a whole new level.

SessionID: 96830

Get Faster Queries with Better Statistics Management

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR

Speaker: Vern Rabe

Title: Get Faster Queries with Better Statistics Management

Abstract:

Statistics are key to the selection of a good execution play. But statistics aren’t perfect, and they often require management over and above what the default SQL Server configurations supply.

In this session we’ll look into why statistics, and specifically the histogram, are so important to good query performance. We’ll see how they’re not perfect, and how that can result in an occasional bad execution plan (slow query). I’ll also present a few methods to resolve those statistics-caused performance issues. Of course there will be plenty of examples.

SessionID: 98192

Continuous Intelligence... Is it all about automation?

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: DevOps: Agile Processes between Dev and Ops

Speaker: Gabi Münster

Title: Continuous Intelligence... Is it all about automation?

Abstract:

Continuous Intelligence is commonly used to describe approaches to constantly analyze data by applying machine-learning algorithms. But you can also understand it to be a combination of the terms of Continuous Integration and Business Intelligence.

Support for BI projects in CI has been a field for improvement in even the near past. But why was that? BI offers some special challenges for CI processes that we want to discuss during this session.

SessionID: 99551

Code Your Report Environment

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Frank Geisler

Title: Code Your Report Environment

Abstract:

You too can build a development Environment for Reporting Services and SQL Server with Azure completely in PowerShell without any GUI!! Additionally, Frank Geisler will be discussing the ReportingServicesTools in PowerShell.

SessionID: 99586

Lightning Talks Session 3

Back to calendar

Event Date: 02-11-2019 - Session time: 13:00:00 - Track: Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc.

Speaker: Michael Wall

Title: Lightning Talks Session 3

Abstract:

Session Three :

Martin Cairney: Azure SQL Database – Building a Deployment Standard Martin Cairney: Data Governance and Protection in SQL Server Josh Smith: What Use is Data Catalog?

SessionID: 96158

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

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

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:

• 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: 96174

Reporting Services Tips, Tricks, Templates and Considerations

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Ted Stathakis

Title: Reporting Services Tips, Tricks, Templates and Considerations

Abstract:

This session is an overview of some of the features and capabilities of Reporting Services. In it you will see a variety of reports styles and template considerations and get an understanding of the power of Linked Reports and Shared Data Sets along with a brief look at some of the Enterprise Edition capabilities with KPIs and Mobile Reports.

We will also cover how to use the data in the ReportServer database to determine which reports are being utilized and determine which reports to migrate to a new implementation of SSRS. Come see how you can use PowerShell to extract the reports and datasets from the database in order to build a new solution for deployment to a new server.

Experience managing SSRS and ideally an understanding of the ReportServer database is useful but not required in order to benefit from this session.

SessionID: 96309

SQL on Docker 101

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR

Speaker: Frank Geisler

Title: SQL on Docker 101

Abstract:

In this session German Data Platform MVP Frank Geisler will explain the basics of Docker. He will explain what Docker is, how it works and most importantly how you can use Docker to run SQL Server within seconds on Windows, Linux or Mac. This demo packed session is the right session for you if you heard about Docker and want to get started. [Video]

SessionID: 96315

Protect your Data by Design: Creating a Data Masking Strategy

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: DevOps: Agile Processes between Dev and Ops

Speaker: Christopher Unwin

Title: Protect your Data by Design: Creating a Data Masking Strategy

Abstract:

Data Breaches are seemingly neverending in today's world with new ones coming to light every single day. To try and mitigate the fallout of a data breach we can implement a data masking strategy throughout our environments, so why haven't we already? In this session, you'll learn the traditional blockers to, and issues with masking data, how to overcome these, and how you can build your own masking plan to ensure the security of your data in pre-production.

SessionID: 96385

Enterprise Power BI - Development Lifecycle [VIDEO]

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: BI Design: Delivery: Power BI, SSRS, Visualization

Speaker: Asgeir Gunnarsson

Title: Enterprise Power BI - Development Lifecycle [VIDEO]

Abstract:

When your development team is up to a certain size and often no matter what size it is you want to start following best development practices. These include things like source control, multiple environments, deployment processes and governance.

As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are these things can get tricky.

In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, dev, test and production and deployment of Power BI content. We will then look at the different options when it comes to distribution of content to the end user. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI.

SessionID: 96556

Locks? We don't need no stinkin' locks!

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips

Speaker: Randy Knight

Title: Locks? We don't need no stinkin' locks!

Abstract:

"I've got a locking problem", "I need to get rid of blocking," and "deadlocks are normal behavior" are all things heard way too many times.

In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.

SessionID: 98169

Intro to Azure Data Studio

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips

Speaker: Heidi Hasting

Title: Intro to Azure Data Studio

Abstract:

Azure Data Studio, keeping in line with Microsoft's ethos of tooling that works on many platforms this one runs on Windows, macOS and Linux.

This session is to give you an introduction to the product give you an idea of where/how it can be used in the Data Platform space. We will also cover some of the main features (code snippets, widgets, extensions) and time permitting Notebooks.

Hopefully by the end of the session you will be aware of Azure Data Studio and be ready to give it a go!

Level: Beginner Level 100

SessionID: 98228

Theory Driven Data Science: Cyber-security Improvement using SQL, R and machine learning [Video]

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc.

Speaker: Michael Curry

Title: Theory Driven Data Science: Cyber-security Improvement using SQL, R and machine learning [Video]

Abstract:

Data science seeks to uncover actionable data relationships to solve pressing organizational needs e.g. improved cyber security behavior, and this talk presents three steps for doing just that. The aim is an exemplary theory driven approach to data evidence of better preparedness against cybersecurity threats. We will present a theory of cybersecurity behavior and how data was collected from training participants then stored in SQL server for analysis in R with a ML classifier. The ML random forest classifier implemented in R is used to analyze survey responses to theoretically-inspired questions. It creates a preferred multi-model integration that can be reused on future data to identify the individuals less likely to participate in the security training who may also be a higher security risk. The talk concludes by summarizing the three tips for actionable data science projects covered here. A short video will preview for SQL Saturday attendees.

SessionID: 99587

Lightning Talks - Session 4

Back to calendar

Event Date: 02-11-2019 - Session time: 14:45:00 - Track: Professional Development: Career, Skills, Interviewing, Managing, WIT

Speaker: Michael Wall

Title: Lightning Talks - Session 4

Abstract:

Session Four :

William Assaf: I Was Once a Crappy Carpenter Jessica Aguilar: Purposeful Learning Jessica Aguilar: The Art of Documentation

SessionID: 96159

Encrypting Data Within SQL Server

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

Speaker: Thomas Norman

Title: Encrypting Data Within SQL Server

Abstract:

Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data?

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. Also, let’s learn how to classify data which should be protected and how to audit sensitive data usage.

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

Power BI: From Zero to 101

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: BI Design: Delivery: Power BI, SSRS, Visualization

Speaker: Slava Murygin

Title: Power BI: From Zero to 101

Abstract:

Power BI is already proven technology and everyone should know at least basics of it.

That is elementary startup session at which you will learn:

• How to use PowerBI Desktop application;
• How to get source data, build reporting dashboards, manipulate with columns, present the data in forms of a table and different kinds of diagrams;
• How to apply different formatting settings to the diagrams and setup interactions between them;
• How to do comprehensive filtering, drill down and drill through of your data.

After this session you will be really able to work with Power BI on your own.

SessionID: 96284

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: Professional Development: Career, Skills, Interviewing, Managing, WIT

Speaker: Christine Assaf

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract:

Looking for a job? Learn trade secrets from an HR professional! Resume blunders and interview tips, this session will focus on the most important things you can do to get hired.

SessionID: 96339

Azure SQL Database Edge - Tiny but mighty

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc.

Speaker: Julie Koesmarno

Title: Azure SQL Database Edge - Tiny but mighty

Abstract:

Have you ever thought what would it be like to run SQL Server engine in a small footprint? Well, wait no more.

Running on Arm and x64 architecture with a reduced footprint, the proven performant and most secure Microsoft SQL engine is coming to the Edge in interactive devices and edge gateways. Combining new capabilities on data streaming and time-series, with in-database machine learning (ML), Azure SQL Database Edge is optimized for low-latency analytics right on the Edge. This session will showcase the scenarios Azure SQL Database Edge can enable.

SessionID: 96344

What is DevOps and Why Should DBAs Care? [VIDEO]

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: DevOps: Agile Processes between Dev and Ops

Speaker: Kathi Kellenberger

Title: What is DevOps and Why Should DBAs Care? [VIDEO]

Abstract:

You may have heard the term “DevOps” a lot lately, but is this just one of those buzzwords that gets thrown around and means something different depending on who’s talking? While traditional software methodologies pit developers and operations folks like DBAs against each other, DevOps requires that they work together for a common goal. And, ultimately, shouldn’t the software project’s success be everyone’s goal?

Attend this session to learn how DevOps is changing the DBAs world for the better.

SessionID: 96347

Inside the Query Store. What Knowledge can You Gain?

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: DBDev: Development, Tools, Scalability, Query Tuning and Indexing

Speaker: Janis Griffin

Title: Inside the Query Store. What Knowledge can You Gain?

Abstract:

The Query Store houses valuable information on performance of your queries, as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what's new in the 2017 Query Store, the new adaptive query processing features, and how to incorporate Query Store queries into the new SQL Operation Studio for monitoring slow running queries and analyzing waits. You'll learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits that caused them. Both DBAs and developers can increase their performance-tuning skills by attending this session.

You will learn:

How to quickly find plan changes and analyze performance issues How to use the new wait classifications in order to get clues on how to tune your statements About the new adaptive query processing features and SQL Operation Studio

SessionID: 96683

Enterprise Row Level Security in SQL Server and Power BI [VIDEO]

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: BI Design: Delivery: Power BI, SSRS, Visualization

Speaker: Jamey Johnston

Title: Enterprise Row Level Security in SQL Server and Power BI [VIDEO]

Abstract:

The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/2017/2019 and Azure SQL DB/DW with predicate based RLS and in Power BI, as well. This session will show how organizational asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/2017, Azure SQL Database and Power BI without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations.

Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS.

SessionID: 96873

Essential Linux skills for SQL Server DBAs

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR

Speaker: Hamish Watson

Title: Essential Linux skills for SQL Server DBAs

Abstract:

When Microsoft released SQL Server 2017 it allowed data professionals to run SQL Server on Linux and in containers, providing a wider and more open platform to deploy and run SQL Server.

This session will showcase both the differences of SQL Server on Linux and the things that will be familiar for DBAs. The top Linux commands that SQL Server DBAs should know will be discussed and demonstrated.

This session will incorporate a demonstration that will showcase the fundamentals of Linux management for SQL Server as well as s sneak peek at SQL Server on containers.

This session will help you understand the basics and will present the exciting future of SQL Server on Linux.

SessionID: 99588

Lightning Talks - Session 5

Back to calendar

Event Date: 02-11-2019 - Session time: 16:15:00 - Track: BI Arch/Admin: Design, ETL, SSIS, EDW

Speaker: Michael Wall

Title: Lightning Talks - Session 5

Abstract:

Session Five:

Russ Loski: Parsing Fixed Width Files with Azure Data Factory Daniel Cai: Build Sophisticated Data Solution Using Adv. SSIS Components Hari Mahesh: Predicta

This site is open source. Improve this page.