Build Schedule

Advanced Filters:
  • Track

    clear all
















  • Speaker


  • Level


  • Session Type



Sessions Found: 69
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 17

Time: 12:15 PM - 1:15 PM

Room: 1720 (Prof Dev 1)

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Career

Level: Beginner

Session Code:

Date: August 17

Time: 2:45 PM - 3:45 PM

Room: 1735 (Prof Dev 2)

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Beginner

Level: Beginner

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: 1510 (Auditorium)

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Beginner

Session Code:

Date: August 17

Time: 9:15 AM - 10:15 AM

Room: 1700 (SQL Dev)

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Administration

Level: Advanced

Session Code:

Date: August 17

Time: 12:15 PM - 1:15 PM

Room: 1745 (SQL Admin)

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 17

Time: 9:15 AM - 10:15 AM

Room: 1735 (Prof Dev 2)

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Development

Level: Intermedia

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: 1745 (SQL Admin)

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!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Office 365/SharePoint

Level: Beginner

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: 1321 (Modern Azure Apps)

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!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
PowerShell

Level: Intermedia

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 1305 (PowerShell)

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: August 17

Time: 9:15 AM - 10:15 AM

Room: 1800(Analytics/BI)

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: 1800(Analytics/BI)

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Administration

Level: Beginner

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: 1620 (SQL Beginner)

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Agile

Level: Intermedia

Session Code:

Date: August 17

Time: 12:15 PM - 1:15 PM

Room: 1920 (Agile)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Development

Level: Intermedia

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 1700 (SQL Dev)

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!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Beginner

Level: Beginner

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 1620 (SQL Beginner)

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

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Administration

Level: Beginner

Session Code:

Date: August 17

Time: 9:15 AM - 10:15 AM

Room: 1745 (SQL Admin)

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 17

Time: 12:15 PM - 1:15 PM

Room: 1510 (Auditorium)

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 1425 (.NET Dev)

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Beginner

Session Code:

Date: August 17

Time: 12:15 PM - 1:15 PM

Room: 1425 (.NET Dev)

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Career

Level: Beginner

Session Code:

Date: August 17

Time: 1:30 PM - 2:30 PM

Room: 1720 (Prof Dev 1)

Sessions Found: 69
Back to Top cage-aids
cage-aids
cage-aids
cage-aids