Nr: 867
SQLSaturday #867 - Baton Rouge 2019
SessionID: 89739
Azure Data Factory Ingestion Framework
Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Business Intelligence
Speaker: Sean Forgatch
Title: Azure Data Factory Ingestion Framework
Abstract:
*Data Factory the right way.
SessionID: 89861
A Map To Success: Functional Programming For Database Developers
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
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
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
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:
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
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
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
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:
SessionID: 94223
The Latest SharePoint Features: What They Are and Why They Matter
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
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
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
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
Event Date: 17-08-2019 - Session time: 09:15:00 - Track: SQL Server Beginner
Speaker: Scott Minar
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
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
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
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:
SessionID: 89995
Database People and DevOps: The Fundamentals
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:
- a (VERY) brief history of DevOps
- why DBA's make the best DevOps engineers
- what admins can teach developers, and what developers can teach admins
SessionID: 90140
Mastering your Resume Interview: Tips to Get Hired
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
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
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:
SessionID: 93216
Ethical Computing
Event Date: 17-08-2019 - Session time: 10:30:00 - Track: AI and Machine Learning
Speaker: Shermaine Haymer
Title: Ethical Computing
Abstract:
This interactive discussion on Ethical Computing will inspire you to think about the cultural, social, and legal contexts of the digital experiences we create for humanity. Computing technologies including intelligent software and hardware artifacts are increasingly integrated into most aspects of our professional, social, and private lives. Intelligent Data technologies are running well in advance of public awareness, ethical reflection and regulatory frameworks.
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
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:
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!
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
Event Date: 17-08-2019 - Session time: 10:30:00 - Track: SQL Server Administration
Speaker: Tracy Boggiano
Title: Intro to Query Store
Abstract:
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?
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:
SessionID: 94226
Everything I know about UX I learned at Disney
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
Event Date: 17-08-2019 - Session time: 10:30:00 - Track: SQL Server Beginner
Speaker: Andy Yun
Abstract:
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
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:
- Discover where all the cloud servers disappeared to
- Define what "serverless" actually means
- Discuss use cases that are a good fit for serverless (there will be code!)
- Drive through a top ten list of pitfalls to look out for, and how those pitfalls can enable us to design more resilient applications
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
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
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
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.
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:
SessionID: 89965
Designing Data Intensive Cloud Native Applications
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
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:
SessionID: 92657
The SQL Career Roadmap for Women (and Men)
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
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
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:
SessionID: 93899
Building, Debugging Deploying Containerized .NET Apps in Visual Studio
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
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
Event Date: 17-08-2019 - Session time: 12:15:00 - Track: CIO/Executive
Speaker: Zane Moreign
Abstract:
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
Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Business Intelligence
Speaker: Russel Loski
Title: Managing ETL Change using BIMLScript
Abstract:
SessionID: 95253
Birds of a Feather Conversations in the Auditorium
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
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:
SessionID: 89832
Careers in IT - Baton Rouge 2019
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
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:
SessionID: 90141
Organizational Behavior Voodoo! Learn how to get more effort out of your team.
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
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
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Agile
Speaker: George Mauer
Title: TDD With No Tears
Abstract:
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
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?
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: Balaji Nedurumalli
Title: Feeling SETSy?
Abstract:
SessionID: 93916
Inside Kubernetes - An Architectural Deep Dive
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:
SessionID: 93993
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: SQL Server Administration
Speaker: Tracy Boggiano
Abstract:
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
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
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Professional Development
Speaker: David Reid
Title: Communicating with Non -Techies
Abstract:
SessionID: 94799
Let it Flow: Data Flows in Azure Data Factory
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
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:
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
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:
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
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:
SessionID: 93859
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Career
Speaker: Peter Doyle
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
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!
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
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:
The topics I will address include:
- What data is captured by the SQL Server Telegraf plugin
- Querying Telegraf data on InfluxDB
- Writing InfluxDB queries for Grafana panels
- Grafana panel/dashboard configuration options
- Grafana permissions authentication
- Querying SQL Server directly from Grafana
SessionID: 94778
The Game Master's Guide to People Management
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
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
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
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: STEMupBR Kid's Track
Speaker: Kenneth Neal
Title: STEMupBR Kid's Showcase
Abstract:
SessionID: 94993
Extend Azure DevOps with a Custom PowerShell-based Pipeline Task
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?
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
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: .NET Dev
Speaker: oscar garcia
Abstract:
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