sqlsathistory

Nr: 867

Back to Main list

SQLSaturday #867 - Baton Rouge 2019

Start Time (24h) Speaker Track Title
09:15:00 Sean Forgatch Business Intelligence Azure Data Factory Ingestion Framework
09:15:00 Kevin Feasel .NET Dev A Map To Success: Functional Programming For Database Developers
09:15:00 Stuart Ainsworth Professional Development All (Data) Things Considered: The Lean Coffee Workshop
09:15:00 Jay Bienvenu Professional Development Documentation: A Habit and a Culture
09:15:00 Sean McCown SQL Server Development Monster Text Manipulation: Regular Expressions for the DBA
09:15:00 Ryan Richard .NET Dev Catching up with Angular 7
09:15:00 Mike Robbins PowerShell PowerShell + SQL Server = Better Together
09:15:00 Tim Radney SQL Server Administration Common SQL Server Mistakes and How to Avoid Them
09:15:00 Theresa Eller Office 365/SharePoint The Latest SharePoint Features: What They Are and Why They Matter
09:15:00 Mohammad Darab SQL Server Administration Big Data Clusters for the Absolute Beginner
09:15:00 Andrew Barefield Agile Why There are No Code Problems, Only Organizational Culture Problems
09:15:00 Aaron Kruger CIO/Executive Consumer Bill of Rights: Your Data and Changing Privacy Laws in 2020
09:15:00 Scott Minar SQL Server Beginner PrequelSaturday - How the SQL Server community is about to make your job easier
09:15:00 Kenneth Neal STEMupBR Kid's Track STEMupBR Track for Kids
09:15:00 Peter Doyle Professional Development How to become a SQLSaturday Presenter, Step-by-Step
10:30:00 Kevin Feasel SQL Server Development Approaching Zero: Minimizing Downtime During Deployments
10:30:00 Stuart Ainsworth Agile Database People and DevOps: The Fundamentals
10:30:00 Christine Assaf Professional Development Mastering your Resume Interview: Tips to Get Hired
10:30:00 Sean McCown PowerShell Loading SQL Server Data with Powershell
10:30:00 Rodney Landrum Business Intelligence Azure Databricks (ADB) and the Traditional DBA
10:30:00 Shermaine Haymer AI and Machine Learning Ethical Computing
10:30:00 Tim Radney SQL Server Administration Azure for the Production Data Professional
10:30:00 Anthony Nocentino Windows Server/Virtualization Containers - You Better Get on Board!
10:30:00 Tracy Boggiano SQL Server Administration Intro to Query Store
10:30:00 Theresa Eller Office 365/SharePoint Are You Ready for the Modern SharePoint Experience?
10:30:00 Ricky Tucker Professional Development Everything I know about UX I learned at Disney
10:30:00 Andy Yun SQL Server Beginner A Beginner's Guide to Seven Practices that Kill Performance
10:30:00 Jonathan Schellack CIO/Executive Serverless Cloud Computing: Promises and Pitfalls
10:30:00 John Harvey .NET Dev Customizable User Interfaces with Dynamic Components in Angular
12:15:00 Mohammad Darab Professional Development 3 Keys to Successful Consulting
12:15:00 Kellyn Pot'Vin-Gorman Agile Be Part of the Solution with Automation
12:15:00 Jonathan Jefferson SQL Server Beginner How to index, win friends, and influence people.
12:15:00 Samir Behara SQL Server Development Designing Data Intensive Cloud Native Applications
12:15:00 Christine Assaf Professional Development Giving Feedback: How to Effectively Communicate to your Employees
12:15:00 Jennifer McCown Professional Development The SQL Career Roadmap for Women (and Men)
12:15:00 Robert Canzonire SQL Server Administration Lightning Fast Backups
12:15:00 Mike Robbins PowerShell Writing Award Winning PowerShell Functions and Script Modules
12:15:00 Jeremy Cronan .NET Dev Building, Debugging Deploying Containerized .NET Apps in Visual Studio
12:15:00 Cody Gros Office 365/SharePoint Microsoft Teams: Building a Project Management Solution in Office 365
12:15:00 Zane Moreign CIO/Executive Simple_Safety™ > $0 Tools-n-Tips for Non-Techies and Techies
12:15:00 Russel Loski Business Intelligence Managing ETL Change using BIMLScript
12:15:00 Mike Huguet Professional Development Birds of a Feather Conversations in the Auditorium
12:15:00 Mike Byrd SQL Server Administration A Self-Tuning Fill Factor Technique for SQL Server
13:30:00 Michael Viron Career Careers in IT - Baton Rouge 2019
13:30:00 Bryan McCoy .NET Dev Building Quality Web APIs with Asp.Net Core
13:30:00 Christine Assaf Professional Development Organizational Behavior Voodoo! Learn how to get more effort out of your team.
13:30:00 Jennifer McCown SQL Server Beginner Beginning T-SQL
13:30:00 George Mauer Agile TDD With No Tears
13:30:00 Peter Doyle SQL Server Development Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less
13:30:00 Balaji Nedurumalli Business Intelligence Feeling SETSy?
13:30:00 Anthony Nocentino Windows Server/Virtualization Inside Kubernetes - An Architectural Deep Dive
13:30:00 Tracy Boggiano SQL Server Administration Using Open Source Software to Collect Performance Metrics
13:30:00 Kevin Cefalu PowerShell Azure Automation with PowerShell: Scripting Away the Problems of Yesterday
13:30:00 David Reid Professional Development Communicating with Non -Techies
13:30:00 Russel Loski Business Intelligence Let it Flow: Data Flows in Azure Data Factory
14:45:00 Mike Byrd SQL Server Development Climbing the SQL Server Index B-Tree
14:45:00 Kellyn Pot'Vin-Gorman PowerBI Taming of the Shrew - Optimizing Power BI
14:45:00 Cody Gros Office 365/SharePoint Employee On-boarding - building business solutions in modern SharePoint
14:45:00 Peter Doyle Career 7.5 Steps to Social Media Marketing Domination for Employees, Entrepreneurs and Aspiring Influencers
14:45:00 Brandon Brockhoeft .NET Dev Developer's Intro. to Cosmos DB
14:45:00 Andy Yun SQL Server Beginner T-SQL Tips Tricks to Make Your Life Easier!
14:45:00 Tom Shaw SQL Server Administration Monitoring SQL Server with Telegraf/InfluxDB/Grafana -- Lessons from the Trenches
14:45:00 Stacy Vicknair Professional Development The Game Master's Guide to People Management
14:45:00 Alexander Lemkin .NET Dev Goodbye Classes: Writing React the Functional Way
14:45:00 Rebecca Milazzo Professional Development How to Develop Without a Designer
14:45:00 Kenneth Neal STEMupBR Kid's Track STEMupBR Kid's Showcase
14:45:00 Mike Huguet PowerShell Extend Azure DevOps with a Custom PowerShell-based Pipeline Task
14:45:00 John Graff CIO/Executive GDPR: Does your organization need to comply?
14:45:00 oscar garcia .NET Dev Improve Dist`d System Web App Performance Using In-Memory Cache

SessionID: 89739

Azure Data Factory Ingestion Framework

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Business Intelligence

Speaker: Sean Forgatch

Title: Azure Data Factory Ingestion Framework

Abstract:

This session will teach you how to create an enterprise grade ingestion framework for a Data Lake using Azure Data Factory. We will walk through modeling the Data Factory Vault using Data Vault modeling as well as building fully dynamic pipeline to ingest metadata and data from multiple source types.

*Data Factory the right way.

SessionID: 89861

A Map To Success: Functional Programming For Database Developers

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: .NET Dev

Speaker: Kevin Feasel

Title: A Map To Success: Functional Programming For Database Developers

Abstract:

Over the past several years, we have seen a resurgence of interest in functional programming languages, particularly with the success of Scala and R in the marketplace. Although object-oriented (oo) design remains the dominant software development paradigm, even oo-first languages have seen a shift toward the functional mindset with the emphasis on LINQ in C# and lambdas in Java. This move toward a functional style should be particularly welcome for data platform specialists, who already have a leg up in understanding functional programming concepts thanks to their work with SQL.

In this talk, we will focus on one functional programming language, F#. We will look at some of the basics of the language and see how you can translate knowledge of SQL into a pipeline-driven functional programming language. We will also see areas where F# integrates smoothly with SQL, creating a powerful way to extend your SQL skills beyond queries.

SessionID: 89933

All (Data) Things Considered: The Lean Coffee Workshop

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Professional Development

Speaker: Stuart Ainsworth

Title: All (Data) Things Considered: The Lean Coffee Workshop

Abstract:

Collaboration is the heart of SQLSaturday's, but too often attendees move from session to session in a passive learning mode. This session is based on the Lean Coffee model, and is a structured workshop with no pre-planned agenda. The goal is to involve YOU in the conversation; bring your questions, your answers, your business cards, and your desire to learn. YOU set the agenda, YOU decide when to move on, and YOU engage and learn.

SessionID: 91001

Documentation: A Habit and a Culture

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Professional Development

Speaker: Jay Bienvenu

Title: Documentation: A Habit and a Culture

Abstract:

Documentation: Nobody writes it; nobody reads it; when you need it, it doesn't exist. Learn how to break this cycle by identifying sources of documentation and compiling them into a knowledge base.

SessionID: 92661

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: SQL Server Development

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you.

Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.

SessionID: 93605

Catching up with Angular 7

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: .NET Dev

Speaker: Ryan Richard

Title: Catching up with Angular 7

Abstract:

If you are new to Angular, or still working on an older version, then it's time to catch up with Angular 7. In this session, we will review a simple Single Page Application (SPA) built with the Angular 7 framework, TypeScript and Bootstrap. We will also look at the Angular Command Line Interface (CLI), used to create and manage Angular applications.

SessionID: 93876

PowerShell + SQL Server = Better Together

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PowerShell + SQL Server = Better Together

Abstract:

SessionID: 93911

Common SQL Server Mistakes and How to Avoid Them

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: SQL Server Administration

Speaker: Tim Radney

Title: Common SQL Server Mistakes and How to Avoid Them

Abstract:

Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others. In this session, Tim Radney will share experiences he has encountered supporting multiple fortune level companies. Tim will share real world experiences of environments he has worked on and the impact he has seen from administrators not knowing how to properly configure and administer SQL Server. In this session you will learn many accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smooth as possible. When you leave this session you will have a checklist of items to take back to your shop to make sure your environment is configured properly.

SessionID: 94223

The Latest SharePoint Features: What They Are and Why They Matter

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Office 365/SharePoint

Speaker: Theresa Eller

Title: The Latest SharePoint Features: What They Are and Why They Matter

Abstract:

Keeping Modern SharePoint fresh and current involves feature additions, updates, and enhancements. In this interactive session, we will examine the value, benefits, and impact of recently released features for Modern SharePoint Online sites. Concurrently, we will discuss best practices for testing, implementing, and adopting new features. The session will conclude with demonstrations based on customer applications.

SessionID: 94435

Big Data Clusters for the Absolute Beginner

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: SQL Server Administration

Speaker: Mohammad Darab

Title: Big Data Clusters for the Absolute Beginner

Abstract:

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

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

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

SessionID: 94492

Why There are No Code Problems, Only Organizational Culture Problems

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Agile

Speaker: Andrew Barefield

Title: Why There are No Code Problems, Only Organizational Culture Problems

Abstract:

Everyone is fascinated by startups. We watch in awe at the market disruption that some technology companies can create. The most successful of these plucky, fast-moving startups may grow into large companies.

The quickest and most disruptive companies may soon struggle under the weight of the increasing scale, expectations, and a shifting organizational culture. Solving code problems is suddenly no longer the most difficult issue.

Have you ever been frustrated at how long it takes to be able to change something in your job, product or organization? Have you ever measured how long it takes to get a change that's only a few lines of code into production? Have you ever wondered why the chat service Slack doesn't have a "dark mode"?

Join to discuss • how organizations (some real, some apocryphal) deal with product and technology changes • how you fit in as a developer, DBA, manager or other consultant, and • what we can all do about it when we get back to work on Monday

SessionID: 94739

Consumer Bill of Rights: Your Data and Changing Privacy Laws in 2020

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: CIO/Executive

Speaker: Aaron Kruger

Title: Consumer Bill of Rights: Your Data and Changing Privacy Laws in 2020

Abstract:

Sweeping privacy changes are moving through state legislatures across the country. California's new law is set to take effect January 2020 and it has far reaching impact across the country. An additional 14 states are right behind them. The US Congress is considering a federal version that gives consumers the right to view their data in your organization. How will these laws impact you? Will you be ready?

SessionID: 94821

PrequelSaturday - How the SQL Server community is about to make your job easier

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: SQL Server Beginner

Speaker: Scott Minar

Title: PrequelSaturday - How the SQL Server community is about to make your job easier

Abstract:

Welcome! You've already discovered the best value anywhere in SQL training; here's how to make the most of it. We'll talk about what to do while you're here and ways to keep up the learning momentum afterward.

You'll also be introduced to several invaluable (and not just because they're free) tools that anyone working with SQL Server needs to be familiar with.

If you're new to SQL Server, when you get back to work on Monday you'll know how to attack the problem you've been struggling with, you'll solve the next problem faster, and you'll know how to find help if you get stuck. Oh, and you'll know about six other problems that used to be hiding from you.

SessionID: 94985

STEMupBR Track for Kids

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: STEMupBR Kid's Track

Speaker: Kenneth Neal

Title: STEMupBR Track for Kids

Abstract:

REGISTRATION REQUIRED

http://bit.ly/SQLYouth

PARENTS MUST REMAIN ONSITE.

Questions? Email sqlpassbr@gmail.com

Want to volunteer? https://foundationebr.org/brstem/volunteer.html

SessionID: 97975

How to become a SQLSaturday Presenter, Step-by-Step

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Professional Development

Speaker: Peter Doyle

Title: How to become a SQLSaturday Presenter, Step-by-Step

Abstract:

In this hands-on interactive presentation you will learn how to plan and execute the strategies and tactics to become a SQL Saturday presenter sooner than you think.

SessionID: 89859

Approaching Zero: Minimizing Downtime During Deployments

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: SQL Server Development

Speaker: Kevin Feasel

Title: Approaching Zero: Minimizing Downtime During Deployments

Abstract:

Negotiating a downtime for a release can be difficult in this modern, 24x7 world. When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly. This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment. We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking. We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing. If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.

SessionID: 89995

Database People and DevOps: The Fundamentals

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Agile

Speaker: Stuart Ainsworth

Title: Database People and DevOps: The Fundamentals

Abstract:

DevOps is a software delivery philosophy that focuses on delivering quality, faster. The purpose of this session is to cover some of the basic principles of DevOps and how they apply to database development and administration. Everyone's environment is different, but the strategies discussed within can be translated into basic tactical gains that are easy to implement.

Topics covered include:

SessionID: 90140

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

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

Speaker: Christine Assaf

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract:

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

SessionID: 92660

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: PowerShell

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

SessionID: 92893

Azure Databricks (ADB) and the Traditional DBA

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Business Intelligence

Speaker: Rodney Landrum

Title: Azure Databricks (ADB) and the Traditional DBA

Abstract:

As more data services come online in Microsoft Azure, DBAs are being tasked with bringing these services into their organizations. Azure Databricks is one such service that has the appeal of combining scalable compute resources with collaborative development and analytic tools in Notebooks and workspaces. To the traditional DBA, however, many of the concepts and language support may be foreign. What the heck is Scala anyway? This session is designed to introduce the DBA to the Azure Databricks workspace and show how to easily integrate it with upstream and downstream services like Azure Data Factory, Machine Learning and Power BI.

SessionID: 93216

Ethical Computing

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: AI and Machine Learning

Speaker: Shermaine Haymer

Title: Ethical Computing

Abstract:

What will prevent the technological imperative from pushing us into places we don’t want to go?

SessionID: 93910

Azure for the Production Data Professional

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: SQL Server Administration

Speaker: Tim Radney

Title: Azure for the Production Data Professional

Abstract:

Microsoft Azure is an open, flexible, scalable, enterprise-grade cloud computing platform. This full day class will teach you why migrating to SQL Server running in Azure is secure, reliable, easy, as well as how to do it.

The Azure platform is vast with many services to choose from. You will get a high level overview of the various services with a focus on SQL Server running in Azure Infrastructure as a Service (Iaas) and Azure SQL Database as a Platform as a Service (PaaS).

You will see how easy it is to build a virtual machine in Azure running SQL Server and how to migrate your data. You will gain insight into licensing, security, pricing, and networking.

You will learn all about Azure SQL Database, its features and limitations for Singleton and Elastic databases as well as Managed Instances.

If you are interested in learning about Azure for your SQL Server environment, this session is for you.

SessionID: 93915

Containers - You Better Get on Board!

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Windows Server/Virtualization

Speaker: Anthony Nocentino

Title: Containers - You Better Get on Board!

Abstract:

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

SessionID: 93994

Intro to Query Store

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: SQL Server Administration

Speaker: Tracy Boggiano

Title: Intro to Query Store

Abstract:

In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.

SessionID: 94222

Are You Ready for the Modern SharePoint Experience?

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Office 365/SharePoint

Speaker: Theresa Eller

Title: Are You Ready for the Modern SharePoint Experience?

Abstract:

Are you ready for the Modern SharePoint experience? In this session, you will discover what Modern SharePoint is. Learn how to build Communication and Team sites, as well what their differences are. Explore modern document libraries, lists, and web parts. Customize SharePoint list forms with PowerApps. Add an interactive Power BI to a modern SharePoint site. Live demos included!

SessionID: 94226

Everything I know about UX I learned at Disney

Back to calendar

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

Speaker: Ricky Tucker

Title: Everything I know about UX I learned at Disney

Abstract:

Walt Disney. Dreamer. Animation Pioneer. Filmmaker. UX Designer. This talk introduces the beginner (or beginner-at-heart) to lessons learned from the Disney, such as storytelling, understanding users, and data-driven design, in creating user experiences for guests and how they can be used to create better experiences for users of websites, applications, and other digital products.

SessionID: 94680

A Beginner's Guide to Seven Practices that Kill Performance

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: SQL Server Beginner

Speaker: Andy Yun

Title: A Beginner's Guide to Seven Practices that Kill Performance

Abstract:

Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers?

Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.

When you leave, you'll be armed with knowledge and tools to tackle your current workloads and hit the ground running.

SessionID: 94822

Serverless Cloud Computing: Promises and Pitfalls

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: CIO/Executive

Speaker: Jonathan Schellack

Title: Serverless Cloud Computing: Promises and Pitfalls

Abstract:

You're hearing more and more about serverless computing, but is it really the panacea that cloud vendors make it out to be? Come learn about the promises and pitfalls of serverless cloud computing based on real-world use.

In this session we will:

This session will provide useful insights for IT decision-makers exploring where serverless fits in their enterprises and for developers who want to go out and quickly build something.

SessionID: 96758

Customizable User Interfaces with Dynamic Components in Angular

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: .NET Dev

Speaker: John Harvey

Title: Customizable User Interfaces with Dynamic Components in Angular

Abstract:

Modern component-based design has brought developer productivity to new heights, but most are unaware that this pattern can be taken even further. Designers, admins, and users alike could all benefit from additional steps which make these components truly dynamic. New abilities can be unlocked, such as combining components to suit your need or personal preference, even faster development cycles, and lazy-loading components which have not yet been created. While this talk will focus on applying this technique in Angular, the concepts are universal and can be brought to any framework or language. Learn how making your components dynamic is surprisingly easy, and be left wondering why you have not done this sooner.

SessionID: 89738

3 Keys to Successful Consulting

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Professional Development

Speaker: Mohammad Darab

Title: 3 Keys to Successful Consulting

Abstract:

Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.

SessionID: 89753

Be Part of the Solution with Automation

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Agile

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

How to index, win friends, and influence people.

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: SQL Server Beginner

Speaker: Jonathan Jefferson

Title: How to index, win friends, and influence people.

Abstract:

In this session, we'll discuss performance benefits of indexes and compare index types. If you're new to indexes in SQL Server or just in need of a refresher, this session should help.

SessionID: 89965

Designing Data Intensive Cloud Native Applications

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: SQL Server Development

Speaker: Samir Behara

Title: Designing Data Intensive Cloud Native Applications

Abstract:

Cloud is rapidly changing the way modern day applications are being designed. Data is at the center of multiple challenges while architecting solutions in cloud.

With technology changing rapidly, there are new possibilities for processing data efficiently. Come join me in this session to learn more about the tools and technologies that will help you to design data intensive systems. We will take a structured approach towards architecting data-centric solutions, covering technologies like message queues, data partitioning, search index, data cache, event sourcing and NoSQL solutions.

If you are a Data professional, Software Engineer or Architect, come join me in this session to understand the high-level design principles that will help you build scalable, resilient and maintainable systems in cloud.

SessionID: 90138

Giving Feedback: How to Effectively Communicate to your Employees

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Professional Development

Speaker: Christine Assaf

Title: Giving Feedback: How to Effectively Communicate to your Employees

Abstract:

As a manager or team leader giving effective feedback is vital to the success of projects. In this session we will discuss soft skills and best practices to give feedback, performance improvement, and even disciplinary actions. Learn how to handle confrontation tactfully.

SessionID: 92657

The SQL Career Roadmap for Women (and Men)

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Professional Development

Speaker: Jennifer McCown

Title: The SQL Career Roadmap for Women (and Men)

Abstract:

The ideal way to become a SQL Server professional is to get a degree, get a junior position, and then work your way up. But, the vast majority of data professionals don’t follow this path! Instead, most of us start out as “accidental DBAs” and fumble our way into a full time data career.

This is not ideal, and we could all use some help navigating through resumes, job hunting, interviews, and negotiating. You’ll learn about all that in this session. We will also talk about how to get around a big obstacle for both women and men: how to get back to work after a long period of not working. How can I get a database job with no experience? What’s the best way to learn the newest technology? What resources are out there? Bring your questions, and we’ll explore the answers.

SessionID: 92864

Lightning Fast Backups

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: SQL Server Administration

Speaker: Robert Canzonire

Title: Lightning Fast Backups

Abstract:

How to make your backup lightning fast.

SessionID: 93881

Writing Award Winning PowerShell Functions and Script Modules

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: PowerShell

Speaker: Mike Robbins

Title: Writing Award Winning PowerShell Functions and Script Modules

Abstract:

Transitioning from writing PowerShell one-liners and basic scripts to creating reusable PowerShell tools with advanced functions and script modules can be a daunting task and with all the different ways that you’ll find on the Internet to accomplish the same task, it can definitely seem overwhelming. During this session, I’ll demystify many of the intricacies of toolmaking while demonstrating the best practices for using parameters, parameter validation, cmdlet binding, supports should process, pipeline input, error handling, module manifests, and custom formatting.

SessionID: 93899

Building, Debugging Deploying Containerized .NET Apps in Visual Studio

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: .NET Dev

Speaker: Jeremy Cronan

Title: Building, Debugging Deploying Containerized .NET Apps in Visual Studio

Abstract:

Containers is the new buzz word going around. This session, we will discuss what a Container is. We will see how to add Containers to your current or new application, and how to debug inside a Container. We will also look at deploying Containers to Azure and Kubernetes.

SessionID: 94123

Microsoft Teams: Building a Project Management Solution in Office 365

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Office 365/SharePoint

Speaker: Cody Gros

Title: Microsoft Teams: Building a Project Management Solution in Office 365

Abstract:

Looking to build a solution to streamline your company's project management process? Need a collaboration solution for storing project artifacts, correspondence, and tasks? If so, then this session is for you. Join me as we step through a project management solution developed using SharePoint Online, Microsoft Teams, and Azure.

SessionID: 94657

Simple_Safety™ > $0 Tools-n-Tips for Non-Techies and Techies

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: CIO/Executive

Speaker: Zane Moreign

Title: Simple_Safety™ > $0 Tools-n-Tips for Non-Techies and Techies

Abstract:

After the surge of ransomware in 2016, coupled with the telemetry leaks in Windows 10, I launched my Simple_Safety™ series with $0 Tools-n-Tips carved out from the commercial Hybrid Decisions® Safer_Computing™ Platform, to help our Family-n-Friends stay reasonably safer online. We will Talk-n-Demo $0 Tools-n-Tips for Windows 10 (version 1903 aka 19H1 that was released as the May 2019 Update).

AUDIENCE: Anyone wanting to stay reasonably safer online PRE-REQ: Anyone using Windows 10

TAKEAWAYS: For those who want more via community, sign up https://www.HybridCloudGroup.org
AND for those who want to adopt NOW, welcome to Hybrid Decisions® Corp (https://www.HybridDecisions.com/connect)

SPEAKER DISCLOSURE: https://www.linkedin.com/today/author/ZaneMoreign AND {Tex} Founder⋮Advisor⋮Speaker⋮Technologist, https://www.linkedin.com/in/AnthonyTexM «±»

SessionID: 94800

Managing ETL Change using BIMLScript

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Business Intelligence

Speaker: Russel Loski

Title: Managing ETL Change using BIMLScript

Abstract:

Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata. To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.

SessionID: 95253

Birds of a Feather Conversations in the Auditorium

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Professional Development

Speaker: Mike Huguet

Title: Birds of a Feather Conversations in the Auditorium

Abstract:

Not hungry? This session will start during lunchtime. Come in and start up a discussion or use this time to continue your lunch discussions and meet new people that are interested in the same topics as you!

Azure BI and ML All things Containers PowerShell Mobile Dev .NET Core PowerApps

**Please note: This session will LSU does not allow food or drinks in the classrooms and auditorium.

SessionID: 95742

A Self-Tuning Fill Factor Technique for SQL Server

Back to calendar

Event Date: 17-08-2019 - Session time: 12:15:00 - Track: SQL Server Administration

Speaker: Mike Byrd

Title: A Self-Tuning Fill Factor Technique for SQL Server

Abstract:

Have you ever created an index and wondered what to specify for fill factor? Usually I’ve never ever given it a worry and just left it at the default value = 0 (actually this is a synonym for 100). But recently I’ve stumbled on a technique that will determine a “near” optimum fill factor value for every index in a database. I say “near” because it won’t always derive the perfect fill factor, but will get you close. We will look closely at the TSQL for this technique to see how the proof of concept was developed for a very active OLTP database. I’ve observed a decrease in overall database wait times of 30% after the tuning. The tuning is continuous and allows for changes in data skew as well as evolving application interactions with the database. IMHO this is a real break-through for making your indexes perform even better. All code will be available for download.

SessionID: 89832

Careers in IT - Baton Rouge 2019

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Career

Speaker: Michael Viron

Title: Careers in IT - Baton Rouge 2019

Abstract:

Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session. This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.

SessionID: 89985

Building Quality Web APIs with Asp.Net Core

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: .NET Dev

Speaker: Bryan McCoy

Title: Building Quality Web APIs with Asp.Net Core

Abstract:

We’ve all done “dotnet new webapi” and got our values from the ValuesController. Now what do we do next? In this talk we will discuss how to structure our project(s), create good api urls, handle versioning, unit test our api, and secure our endpoints. There are plenty of examples of best practices for .Net Core Web APIs. We will look at them and figure out why we would want to implement these practices. We will also identify the benefits for doing so.

SessionID: 90141

Organizational Behavior Voodoo! Learn how to get more effort out of your team.

Back to calendar

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

Speaker: Christine Assaf

Title: Organizational Behavior Voodoo! Learn how to get more effort out of your team.

Abstract:

Feel like your team has a gris-gris (curse)? Motivating employee's to care about their work and put effort into their jobs is hard. How do managers and team leads effectively guide employees in a way that makes them more engaged and productive? Learn some organizational behavior theory voodoo that can help ignite your team and maybe even yourself!

SessionID: 92654

Beginning T-SQL

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: SQL Server Beginner

Speaker: Jennifer McCown

Title: Beginning T-SQL

Abstract:

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!

SessionID: 92899

TDD With No Tears

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Agile

Speaker: George Mauer

Title: TDD With No Tears

Abstract:

Unit testing is hard to get right. Are you testing too much? Too little? How do you write tests that aren't a waste of time? Isn't testing supposed to enable refactoring? Then why do they seem to be in the way? What's this BDD thing I keep hearing about? Do we need to learn yet another tool?

This talk goes deep into the philosophy behind unit testing in general and test-driven development in particular. We will discuss how to keep things simple yet useful and showcase a strategy for writing tests that achieve our goals without wasting everybody's time.

SessionID: 93657

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

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: SQL Server Development

Speaker: Peter Doyle

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

Abstract:

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

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

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

SessionID: 93892

Feeling SETSy?

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Balaji Nedurumalli

Title: Feeling SETSy?

Abstract:

‘SETS’ are a powerful tool in Tableau that are often not used to their fullest potential. In this working-session, we will see how sets can be used for answering various deep analysis cases such as Segmentation, Grouping, Benchmarking, Market Basket Analysis, Cohort Analysis, Conditional Suppression, Comparative Ranking etc. Hoping you will leave this session 'Feeling SETSy'!

SessionID: 93916

Inside Kubernetes - An Architectural Deep Dive

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Windows Server/Virtualization

Speaker: Anthony Nocentino

Title: Inside Kubernetes - An Architectural Deep Dive

Abstract:

In this session we will introduce Kubernetes, we’ll deep dive into each component and its responsibility in a cluster. We will also look at and demonstrate higher-level abstractions such as Services, Controllers, and Deployments and how they can be used to ensure the desired state of an application and data platform deployed in Kubernetes. Next, we’ll look at Kubernetes networking and intercluster communication patterns. With that foundation, we will then introduce various cluster scenarios and high availability designs. By the end of this session, you will understand what's needed to put your applications and data platform in production in a Kubernetes cluster.

SessionID: 93993

Using Open Source Software to Collect Performance Metrics

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: SQL Server Administration

Speaker: Tracy Boggiano

Title: Using Open Source Software to Collect Performance Metrics

Abstract:

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will discuss sp_whoisactive and Query Store to track what queries are running. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive and easy to set up system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances, Azure Managed Instances and Azure SQL Databases.

Attendees will see how easy it is to get good performance data and visualize it interactively and combine with other tools to troubleshoot issues. Finally, we will look at problem I solved using this solution as an example.

SessionID: 94050

Azure Automation with PowerShell: Scripting Away the Problems of Yesterday

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: PowerShell

Speaker: Kevin Cefalu

Title: Azure Automation with PowerShell: Scripting Away the Problems of Yesterday

Abstract:

In your day to day job, how many times do you find yourself interrupted to complete a task you've done a thousand times? The repetitive work not only takes resources from more important work but also costs time to ramp up/down. What if you could automate the operation? Better yet, what if you could give approved access to that automation to those that request it, execute it on a regular schedule, or have it react to some event? In this session, we will explore Microsoft's Azure Automation Runbooks, its capabilities, and even demo a few use-cases. This should give you a feel for how this service can help free you from tedious duties and empower the rest of your team!

SessionID: 94637

Communicating with Non -Techies

Back to calendar

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

Speaker: David Reid

Title: Communicating with Non -Techies

Abstract:

This information provides a better understanding of tactics and methods to better allow IT Professionals and those with technical expertise to better connect with those without technical expertise - often users, customers and others, requiring technical support services. Also provides tips and methods to eliminate barriers in communicating. This presentation is augmented with You Tube Video to provide insight and perspective from IT expert and trainer.. This session is designed to be interactive to Technical professionals required to provide timely and effective Customer Service Support and Problem Resolution.

SessionID: 94799

Let it Flow: Data Flows in Azure Data Factory

Back to calendar

Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Russel Loski

Title: Let it Flow: Data Flows in Azure Data Factory

Abstract:

Azure data factory has been the main tool for copying data from one source to another. But it doesn't do a good job transforming the data, relying on tools like DataBricks, U-SQL or stored procedures for data transformation. In May 2019, Microsoft made Azure Data Factory Data Flows available in public preview . This tool, which in some ways is as powerful or more so than the SSIS equivalents makes it possible to edit the data as it comes from a source to a destination. No more do you have to process the data to a file in order to change it in flight.

SessionID: 89744

Climbing the SQL Server Index B-Tree

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: SQL Server Development

Speaker: Mike Byrd

Title: Climbing the SQL Server Index B-Tree

Abstract:

You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially

when it comes to indexes. Some of the things you have probably heard are:  keep clustered index width small  unique indexes perform better  keep non-clustered index width small  compressed indexes have fewer logical reads  add one index for each column

But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.

SessionID: 89752

Taming of the Shrew - Optimizing Power BI

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: PowerBI

Speaker: Kellyn Pot'Vin-Gorman

Title: Taming of the Shrew - Optimizing Power BI

Abstract:

No one wants to tell a report user that while running a report in Power BI they have time to go get a cup of coffee…in another town. Although data sets will often be the focus of performance issues, it’s important to know how to locate performance problems in Power BI and how to eliminate them.

This session will take the Power User through how to identify time consuming processing in Power BI and how to address it through step-by-step and proven methods used to optimize in multi-tier environments. This method removes frustration and finger-pointing and gets to the heart of the problem with a goal of correcting performance challenges. The results are satisfied end users who get the information they need, when they need it.

Take Aways: Learn how to identify what is taking the time in a Power BI data set and report. Understand the logging and tracing mechanisms and capabilities in the environment. Understand when a problem is really a problem.

SessionID: 92834

Employee On-boarding - building business solutions in modern SharePoint

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Office 365/SharePoint

Speaker: Cody Gros

Title: Employee On-boarding - building business solutions in modern SharePoint

Abstract:

What's the big deal with modern SharePoint, anyway? In this session, learn how to use a combination of tools from the Microsoft Office 365 stack, including modern SharePoint, to create a business solution for new-hire on-boarding. Topics covered will include Microsoft Forms, PowerApps, Flow, and modern lists and libraries

SessionID: 93859

7.5 Steps to Social Media Marketing Domination for Employees, Entrepreneurs and Aspiring Influencers

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Career

Speaker: Peter Doyle

Title: 7.5 Steps to Social Media Marketing Domination for Employees, Entrepreneurs and Aspiring Influencers

Abstract:

Do you have a solid social media marketing plan for 2019-2020? Are you sitting on the sidelines paralyzed at the thought of creating engaging content every day for Podcasts, Blog Posts, Twitter, Instagram, Instagram Stories, Instagram TV, Facebook, Linkedin, Twitch, YouTube and SnapChat?

In this session, you will learn the 7.5 steps to create a never-ending fountain of meaningful and engaging content across all social media channels. You will gain actionable insight on how to connect with your community as we analyze how RedBull, Buffer, Virgin and Charity Water connect with their communities.

At the end of the session, you will be equipped with the tools, resources, and energy-efficient shortcuts to create a custom and scalable marketing strategy.

SessionID: 94219

Developer's Intro. to Cosmos DB

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: .NET Dev

Speaker: Brandon Brockhoeft

Title: Developer's Intro. to Cosmos DB

Abstract:

Introduction to Cosmos DB including database features and Azure setup. Will discuss major concepts like partitions, indexing, provisioned throughput, and more. The presentation includes a SQL Server comparison and a demo of the C# SDK using an ASP.NET application. Will explore modeling data in code and the SQL API for the document database model.

SessionID: 94681

T-SQL Tips Tricks to Make Your Life Easier!

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: SQL Server Beginner

Speaker: Andy Yun

Title: T-SQL Tips Tricks to Make Your Life Easier!

Abstract:

Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you.

This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.

This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!

SessionID: 94753

Monitoring SQL Server with Telegraf/InfluxDB/Grafana -- Lessons from the Trenches

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Tom Shaw

Title: Monitoring SQL Server with Telegraf/InfluxDB/Grafana -- Lessons from the Trenches

Abstract:

Following Tracy Boggiano's presentation to the BRSSUG about using open source tools to monitor SQL Server, I tried it myself. Now I can't imagine doing my job without it. But getting to this point required a significant amount of research and trial and error. In this presentation I would like to share some of the lessons learned in this process, so you can get your monitoring solution running and tailored to your needs efficiently.

The topics I will address include:

SessionID: 94778

The Game Master's Guide to People Management

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Professional Development

Speaker: Stacy Vicknair

Title: The Game Master's Guide to People Management

Abstract:

The dust settles from the massive blow dealt by Erin's quick and, in your opinion, very creative thinking. A monster has been looming over your crew for weeks and it’s now on its last legs. All eyes make their way across the table and over to Jim, who is eager to roll the dice and deal the final blow. A final few clicks from the conference room mouse and the beast is felled. The room erupts in celebration as Jim logs into the new environment, spun up entirely by their efforts and investments in “Infrastructure as Code”.

As much as some might want to draw a line between work and play, there is much that they can have in common. In this session we'll take a look at what we, as people managers, can learn from role playing games and the relationship that evolves between a game master and their players. We'll talk about identifying what motivates our team members and tools and strategies we can employ to create an environment that keeps them challenged, interested, and engaged.

SessionID: 94779

Goodbye Classes: Writing React the Functional Way

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: .NET Dev

Speaker: Alexander Lemkin

Title: Goodbye Classes: Writing React the Functional Way

Abstract:

Whether you are new to React, or a veteran, there is plenty to gain from this talk.

In this session you will learn techniques using higher order functions to keep your React and JavaScript code functional and maintainable. The recompose library is going to be used to accomplish this in React.

We will be referencing a full front end stack utilizing the most up to date modern web stack for Single Page Application (SPA) development: Webpack 4, React 16, Redux, Bootstrap 4, ESLint with StandardJS, Sagas, and Jest.

A reasonable familiarity with JavaScript is expected, as well as Node and npm are prerequisites to running this locally.

SessionID: 94790

How to Develop Without a Designer

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Professional Development

Speaker: Rebecca Milazzo

Title: How to Develop Without a Designer

Abstract:

No designer? No problem! Get insight from a product designer on how to create visual consistency with front-end development. Learn tips on how you can create reusable components and styles that can be globally updated so your whole team can stay aligned. In the end, you are sure to have cleaner code and a final product that keeps both your internal team and users happy.

SessionID: 94986

STEMupBR Kid's Showcase

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: STEMupBR Kid's Track

Speaker: Kenneth Neal

Title: STEMupBR Kid's Showcase

Abstract:

Questions? Email sqlpassbr@gmail.com

SessionID: 94993

Extend Azure DevOps with a Custom PowerShell-based Pipeline Task

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: PowerShell

Speaker: Mike Huguet

Title: Extend Azure DevOps with a Custom PowerShell-based Pipeline Task

Abstract:

Mike Huguet is a Senior Software Engineering Lead on the PowerApps product development team at Microsoft. He and his team focus on features and tooling that aid customers and partners in improving the quality of their PowerApps and customizations to their Common Data Services and Dynamics 365 CE solutions. Mike has been a software professional for over twenty years.

SessionID: 95252

GDPR: Does your organization need to comply?

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: CIO/Executive

Speaker: John Graff

Title: GDPR: Does your organization need to comply?

Abstract:

Data privacy regulations in Europe and California are forcing companies to take a closer look at their personal data protection measures or face serious fines. With the potential for more regulations looming, many companies are using the framework of recent regulations to improve their data protection, regardless if they are subject to specific laws.

SessionID: 95655

Improve Dist`d System Web App Performance Using In-Memory Cache

Back to calendar

Event Date: 17-08-2019 - Session time: 14:45:00 - Track: .NET Dev

Speaker: oscar garcia

Title: Improve Dist`d System Web App Performance Using In-Memory Cache

Abstract:

Applications often integrate with APIs for the purpose of retrieving data from a disk-based storage system like SQL Server. This poses challenges due slow queries and amount of data sent down the wire. In this presentation, we discuss the performance concerns with this type of architecture especially for big data scenarios. Oscar Garcia shows how to address those concerns by following a series of steps in which an application is refactored with minimum changes to support an in-memory data store and data streaming. We start by discussing the challenges when using data queries. We structure the data for in in-memory storage. We replace the API requests with real-time data streaming.

Learning Objectives:

SQL Server Query Challenges

Redis Cache Basic Operations and Structure

Angular App with Socket.io integration

Node.js Backend with Socket.io and Redis support

Real-time data integration