sqlsathistory

Nr: 749

Back to Main list

SQLSaturday #749 - Baton Rouge 2018

Start Time (24h) Speaker Track Title
09:15:00 Karlyn LeBlanc Professional Development Creating your Vision
09:15:00 Marsha Pierce SQL Server Administration How To Talk To Your Storage Admin
09:15:00 Christine Assaf Professional Development Giving Feedback: How to Effectively Communicate to your Employees
09:15:00 Brandon Ringe .NET Dev Learn to Love Lisp: A look into Clojure
09:15:00 Angela Henry SQL Server Development Data Types Do Matter
09:15:00 Adam Saxton Business Intelligence Power BI Security Deep Dive
09:15:00 Leslie Andrews Business Intelligence The Power of Data: The Complete Beginners Data Warehouse Kit
09:15:00 Michael Fal PowerShell Exploring the new SqlServer PowerShell module
09:15:00 Steve Jones SQL Server Development A Tour of SQL Server 2016 Security Features
09:15:00 Mike Huguet .NET Dev Create a rich no-code model driven app using PowerApps
09:15:00 Mark Verret Business Intelligence SQL Server 2017 and R: More than stats
09:15:00 William Assaf StemUP Kid's Track STEMupBR Track for Kids
09:15:00 James Alt .NET Dev Introduction to Application Security
09:15:00 Jamey Johnston PowerBI Enterprise Row Level Security in SQL Server and Power BI
10:30:00 George Mauer .NET Dev CQRS Lite and Otherwise
10:30:00 Jennifer McCown SQL Server Administration Effortless Backups with Minion Backup
10:30:00 Kris Hokanson SQL Server Development Random Acts of Senseless Databasing
10:30:00 Bryan McCoy .NET Dev Intro to Docker for .Net Developers
10:30:00 Russel Loski Business Intelligence Managing Azure Data Lake with PowerShell
10:30:00 Paulo de Souza Windows Server/Virtualization Demystifying NUMA and RightSizing
10:30:00 Mechelle Roberthon Business Intelligence Knowledge Mapping-Sharing the Wealth of Your Team's Expertise
10:30:00 Patrick LeBlanc Business Intelligence Deploying Power BI in your Enterprise
10:30:00 Michael Fal SQL Server Development Getting Started with Git/GitHub
10:30:00 Steve Jones Professional Development Branding Yourself for a Dream Job
10:30:00 Jamey Johnston Business Intelligence Code Like a Snake Charmer - Intro to Python!
10:30:00 Casey Phillips CIO/Executive Diversity in Tech
12:15:00 Stan Geiger SQL Server Development JSON Processing in SQL Server 2016 or Why I hate XML
12:15:00 Janis Griffin SQL Server Administration What’s New in the 2017 Query Store
12:15:00 Christine Assaf Professional Development Mastering your Resume Interview: Tips to Get Hired
12:15:00 James Davis Business Intelligence Pandas Dataframes: The Kevin Bacon of the data structures in data analytics
12:15:00 Sean McCown PowerShell Beginning Powershell for DBAs 1.0
12:15:00 Daniel Janik SQL Server Administration A DBA's guide to full stack performance troubleshooting
12:15:00 William Assaf .NET Dev Twilight TimeZone: Handling Time in Your App Architecture
12:15:00 Rie Irish SQL Server Development Is My Application Bias Showing?
12:15:00 Diane Schuster Business Intelligence CozyRoc: Dynamic Data Flows in SSIS Without Programming
12:15:00 David Pechon Windows Server/Virtualization How to be a lazy sysadmin and get away with it.
12:15:00 David Reid Professional Development Open Management Style
12:15:00 Steve Jones .NET Dev Adopting A DevOps Process for Your Database
12:15:00 Shawn Weisfeld .NET Dev Get insights from data with Cognitive Services
13:30:00 Steven Tidwell SQL Server Development Dynamic SQL: Tables, Parameters and More
13:30:00 John Wells SQL Server Development Fundamentals That Will Improve Your Query Performance!
13:30:00 Marsha Pierce SQL Server Administration SQL Server with Docker Containers
13:30:00 Angela Henry PowerBI What is Power BI?
13:30:00 Kevin Boles SQL Server Development Know What Your Code is Doing to SQL Server!
13:30:00 Al Manint .NET Dev 3.NET Development with Windows 10 IoT Core
13:30:00 William Assaf Professional Development Think Like a Certification Exam
13:30:00 Jeff Renz Business Intelligence Fishing for Answers: Azure Data Lake
13:30:00 Jonathan Jefferson SQL Server Beginner How to index, win friends, and influence people.
13:30:00 Zane Moreign SQL Server Administration SQL on Linux ¦ Microsoft ♡ Linux … what about (us) Windows folks?
13:30:00 Jamey Johnston Business Intelligence Code Like a Pirate ... Intro to R and Data Science Tools in MS
13:30:00 Rie Irish Professional Development Mentoring Women in Tech: A Guide for Men Women Who Want to Help
14:45:00 Janis Griffin SQL Server Administration HiHo! HiHo! SQL Server on Linux, We Go!
14:45:00 Jennifer McCown SQL Server Development T-SQL's Hidden Support Feature
14:45:00 Michael Viron Career Careers in IT - Baton Rouge 2018
14:45:00 Jay Tulk .NET Dev Composing Functions With Javascript
14:45:00 Kevin Boles SQL Server Administration SQL Server Defaults SUCK!!
14:45:00 Russel Loski .NET Dev Developing Custom Extractors for Azure Data Lake
14:45:00 Daniel Janik SQL Server Administration Performance Tuning with a Microsoft MVP
14:45:00 Paul LaGrone Business Intelligence 2017 SSIS Scale Out: How and Why
14:45:00 Rie Irish Professional Development Well, actually... An entertaining WIT session for the men
14:45:00 Patrick LeBlanc Business Intelligence Power BI Report Server: A Deep Dive
14:45:00 Jeff Renz Business Intelligence Introduction to Azure Cosmos DB SQL API
14:45:00 Mike Huguet .NET Dev Building Great Services
14:45:00 William Assaf StemUP Kid's Track STEMupBR Kid's Showcase
14:45:00 Anthony {Tex} Moreign CIO/Executive The DATA⋅CLOUD Talk

SessionID: 73566

Creating your Vision

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Creating your Vision

Abstract:

Dreams become reality and it's time for you to create the life you want. What's your vision? Where do you see yourself in 5 years? What's the next step in your professional career? Are you living life to the fullest and doing what really makes you happy? Discover a new you and learn to succeed and live without regrets in this very interactive seminar.

SessionID: 74391

How To Talk To Your Storage Admin

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: SQL Server Administration

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 76961

Giving Feedback: How to Effectively Communicate to your Employees

Back to calendar

Event Date: 11-08-2018 - Session time: 09: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: 77476

Learn to Love Lisp: A look into Clojure

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: .NET Dev

Speaker: Brandon Ringe

Title: Learn to Love Lisp: A look into Clojure

Abstract:

Clojure is a dialect of Lisp. It's a dynamic, general-purpose programming language, combining the approachability and interactive development of a scripting language with an efficient and robust infrastructure for multi-threaded programming. Clojure is predominantly a functional programming language, and features a rich set of immutable, persistent data structures. Though it's functional, it was designed to be practical, and features specific constructs for mutability such as software transactional memory (STM). We'll talk about the core features of Clojure, some of the fundamental ideas behind functional programming, and how to develop "live" with the REPL.

SessionID: 78694

Data Types Do Matter

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: SQL Server Development

Speaker: Angela Henry

Title: Data Types Do Matter

Abstract:

They're just numbers, right? A date's a date. It's just string data, who cares? I can't tell you how many times I've heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.

SessionID: 80500

Power BI Security Deep Dive

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Business Intelligence

Speaker: Adam Saxton

Title: Power BI Security Deep Dive

Abstract:

One hot topic with Power BI is security, in this deep dive session, we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored and we even look at how to leverage additional Azure services to secure it even more.

SessionID: 83010

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Business Intelligence

Speaker: Leslie Andrews

Title: The Power of Data: The Complete Beginners Data Warehouse Kit

Abstract:

For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can't without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!

SessionID: 83092

Exploring the new SqlServer PowerShell module

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: PowerShell

Speaker: Michael Fal

Title: Exploring the new SqlServer PowerShell module

Abstract:

If you’ve dabbled in PowerShell, you probably know that there are many ways to use it in conjunction with SQL Server. While using the provided tool set has been a challenge for many data professionals, recent upgrades and improvements to the PowerShell module for SQL server provide a solid tool set for new and experienced users. This session will cover the SqlServer module in detail, exploring the various commands and demonstrating various use cases for the tool set. Attendees will get a solid overview of the module and real world examples of how users can get the most out of their code.

SessionID: 83163

A Tour of SQL Server 2016 Security Features

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: SQL Server Development

Speaker: Steve Jones

Title: A Tour of SQL Server 2016 Security Features

Abstract:

Protecting our data from unauthorized access becomes more and more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always Encrypted, TDE, Row Level Security, Dynamic Data Masking, and column level encryption can protect your systems.

SessionID: 83318

Create a rich no-code model driven app using PowerApps

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: .NET Dev

Speaker: Mike Huguet

Title: Create a rich no-code model driven app using PowerApps

Abstract:

Microsoft has been hard at work converging multiple business application platforms, including PowerApps, XRM/Dynamics CRM/CE, and the Common Data Service, enabling you to create rich, complex, and extensible apps that span devices with little or no code. In this session we will create a model-driven app with no code that includes the data model, user interface, visualizations, and logic. This is an introductory session and is for anyone who has used line of business applications and can work with Excel or Access.

SessionID: 83571

SQL Server 2017 and R: More than stats

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Business Intelligence

Speaker: Mark Verret

Title: SQL Server 2017 and R: More than stats

Abstract:

New language integration in SQL 2016/2017 provides powerful functionality for various tasks in addition to statistical models. This session will focus on R with demonstrations of various packages and corresponding projects. We will work through a small end to end project using R in multiple facets of the project.

SessionID: 83770

STEMupBR Track for Kids

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: StemUP Kid's Track

Speaker: William Assaf

Title: STEMupBR Track for Kids

Abstract:

REGISTRATION REQUIRED: https://foundationebr.org/brstem/calendar.html/event/2018/08/11/sqlsatbr-2018-stemupbr-kids-track/205026

PARENTS MUST REMAIN ONSITE.

Questions? Email sqlpassbr@gmail.com

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

SessionID: 83972

Introduction to Application Security

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: .NET Dev

Speaker: James Alt

Title: Introduction to Application Security

Abstract:

Do you ever get the feeling that your Information Security department is out to make your life hard? Do you think perhaps they think the same thing about developers? (hint: They usually do.) Have you ever wondered how you could make that relationship better? Then this session is for you!

In this introduction to application security we will go over the “basics” of security, specifically in regards to web applications. We will touch on things like what that OWASP thing is, the differences between authorization and authentication, and why most Two-Factor authentication has an off by one error. We will also look at ways to test your applications for security vulnerabilities so that the next time you hand your applications off to the security team you can have a better feeling about the results you will get back.

SessionID: 84413

Enterprise Row Level Security in SQL Server and Power BI

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: PowerBI

Speaker: Jamey Johnston

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

Abstract:

The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/2017 and Azure SQL DB with predicate based RLS and in Power BI, as well.

This session will show how organizational asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/2017, Azure SQL Database and Power BI without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations.

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

SessionID: 73662

CQRS Lite and Otherwise

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: .NET Dev

Speaker: George Mauer

Title: CQRS Lite and Otherwise

Abstract:

SessionID: 73754

Effortless Backups with Minion Backup

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: SQL Server Administration

Speaker: Jennifer McCown

Title: Effortless Backups with Minion Backup

Abstract:

Minion Backup is a stand-alone backup solution that can be deployed on any number of servers, for free. Once installed, Minion Backup (or just, MB) automatically backs up all online databases on the SQL Server instance, and will incorporate databases as they are added or removed.

While the solution is designed to be as simple as possible to get up and running, MB is deeply configurable for every backup scenario. In this session, attendees will learn about:

SessionID: 73824

Random Acts of Senseless Databasing

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: SQL Server Development

Speaker: Kris Hokanson

Title: Random Acts of Senseless Databasing

Abstract:

After years of snake oil salesmen and good-meaning but part-time developers, Acme Oil Gas company’s databases have become something Rube Goldberg would be proud of and they've hired you to sort everything out. What are some of the things you can expect to find and how can you fix them? From spaghetti code that references views inside of views nested in other views, to overly indexed tables that generate 10x the disk IO and contention they should, we’ll talk about database development, administration, and plenty of things in between.

SessionID: 75776

Intro to Docker for .Net Developers

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: .NET Dev

Speaker: Bryan McCoy

Title: Intro to Docker for .Net Developers

Abstract:

Building, deploying, maintaining, and scaling apps are a part of our daily lives as developers. In this talk we will discuss how a .Net web developer can leverage Docker Containers to make all of these things easier. We will cover the basics of getting a project setup to be ran in a container for local development with .Net Core. The benefits of running Docker Containers for development. Talk about how to manage our containers and their images. The different types of container images available to us. We will also, cover basic terminology so that reading through the docs become less intimidating. While using Docker files and Docker Compose to run multiple projects and other external dependencies such as Redis or Sql Server 2017.

SessionID: 80536

Managing Azure Data Lake with PowerShell

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Business Intelligence

Speaker: Russel Loski

Title: Managing Azure Data Lake with PowerShell

Abstract:

PowerShell can perform common tasks in Azure Data Lake. Learn how to authenticate and then upload files, run jobs and inventory your site.

In this session, we will look at how to authenticate in Azure Data Lake using PowerShell. From there, I will demonstrate how to upload a set of files and how to get information about the files. In addition, we will submit U-SQL jobs to Azure Data Lake Analytics.

SessionID: 82285

Demystifying NUMA and RightSizing

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Windows Server/Virtualization

Speaker: Paulo de Souza

Title: Demystifying NUMA and RightSizing

Abstract:

One of the most misunderstood aspects of virtual machine performance is vNUMA. In addition to an overview on the CPU architecture, NUMA and CPU scheduling; we'll discuss some nuances of the CPU that are not commonly known. We will deep dive into how a single VM's misconfiguration can cause performance problems for itself and also how many misconfigured VMs degrade the norm of performance of your virtual infrastructure.

DBAs will be taught to identify misconfigured virtual machines and be explained what the infrastructure engineer can do to resolve it. The presentation will be completed with a discussion on virtual machine RightSizing and how it benefits the larger virtual infrastructure.

SessionID: 82487

Knowledge Mapping-Sharing the Wealth of Your Team's Expertise

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Business Intelligence

Speaker: Mechelle Roberthon

Title: Knowledge Mapping-Sharing the Wealth of Your Team's Expertise

Abstract:

Picture this: Employee A left your company after working there for 5 years. Employee A was a jack of all trades. They created some processes, participated on committees, and overall had great business knowledge. Employee B gets hired, and is looking for information to be effective in their role. Unfortunately Employee A's knowledge and how to's of daily tasks went undocumented. It has become challenging to reach Employee A to inquire about these things.

Organizational survival depends on many things, and one of the critical things it depends on is the flow and exchange of knowledge of business practices. Knowledge mapping is an activity that outlines business tasks critical to organizational life, the people responsible, required resources, outputs, and inputs. This session will inform participants about the purpose of knowledge mapping, the process, how to capture knowledge, and how to support a successful knowledge management initiative.

SessionID: 82832

Deploying Power BI in your Enterprise

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Business Intelligence

Speaker: Patrick LeBlanc

Title: Deploying Power BI in your Enterprise

Abstract:

Have you wondered what the right approach is for creating and deploying your Power BI content? Which tools are the right ones? When do you use app workspaces and apps? How to understand your licensing options? And how to keep your data up to date? If, so this session is for you. During this session we will discuss and show: Deployment options, Licensing Options, Refreshing Data, Collaborating and Sharing options and many more details about deploying Power BI.

SessionID: 83093

Getting Started with Git/GitHub

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: SQL Server Development

Speaker: Michael Fal

Title: Getting Started with Git/GitHub

Abstract:

SessionID: 83161

Branding Yourself for a Dream Job

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Professional Development

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it's important to raise your profile in today's highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.

SessionID: 84322

Code Like a Snake Charmer - Intro to Python!

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Business Intelligence

Speaker: Jamey Johnston

Title: Code Like a Snake Charmer - Intro to Python!

Abstract:

The session will be an introduction to the Python language including:

1.) Installing and Configuring Python

2.) Access and Manipulate Data

3.) Install and Manage Packages

4.) Create and Use Objects/Variables

5.) Control Flows and Functions

6.) Managing the Python installation in MSSQL

Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowl

SessionID: 85080

Diversity in Tech

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: CIO/Executive

Speaker: Casey Phillips

Title: Diversity in Tech

Abstract:

A multi-layered talk is introduced by Walls Project director, Casey Phillips, explaining the importance of diversity in the tech industry, especially introducing new job opportunities to minorities and women. This is further broken down by the introduction of The Futures Fund, The Walls Project’s program in which students are taught coding and able to intern and grow their skills in real work environments.

SessionID: 73652

JSON Processing in SQL Server 2016 or Why I hate XML

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: SQL Server Development

Speaker: Stan Geiger

Title: JSON Processing in SQL Server 2016 or Why I hate XML

Abstract:

For years XML was the generic data format for the masses. With the advent of JSON, there is a much easier, readable format for storing data that is platform agnostic. In this presentation we will explore what JSON is and how its different from XML as well as how to read an write JSON files using new functions available in SQL Server 2016

SessionID: 73677

What’s New in the 2017 Query Store

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: SQL Server Administration

Speaker: Janis Griffin

Title: What’s New in the 2017 Query Store

Abstract:

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

SessionID: 76963

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15: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: 77142

Pandas Dataframes: The Kevin Bacon of the data structures in data analytics

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: Business Intelligence

Speaker: James Davis

Title: Pandas Dataframes: The Kevin Bacon of the data structures in data analytics

Abstract:

In the 'Seven Degrees' game, the goal is to connect actors with, or through, Kevin Bacon. If we can connect you to Kevin, we win. Likewise, data scientists seek structures that allow for data importation, transformation, manipulation, analysis, and export. Luckily, all Python data science roads lead to the popular Pandas package and the trusty dataframe. If we can get the data into a dataframe, we win.

SessionID: 80413

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: PowerShell

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 81968

A DBA's guide to full stack performance troubleshooting

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: SQL Server Administration

Speaker: Daniel Janik

Title: A DBA's guide to full stack performance troubleshooting

Abstract:

Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood.

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.

SessionID: 82511

Twilight TimeZone: Handling Time in Your App Architecture

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: .NET Dev

Speaker: William Assaf

Title: Twilight TimeZone: Handling Time in Your App Architecture

Abstract:

Join two experts in their fields of SQL and .NET architecture for an informative and thought-provoking talk about handling timezones in your application architecture. You might walk away unsettled by your past date/time storage choices, but you'll be more confident than ever that dealing with Time Zones is disconcerting, rarely straightforward, and often complicated! We'll deep dive into the storage and serialization of date/time information from the worlds of both SQL Server and web/mobile application development, in a joint presentation by Sparkhound principal consultants William Assaf and Steve Schaneville.

SessionID: 82616

Is My Application Bias Showing?

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: SQL Server Development

Speaker: Rie Irish

Title: Is My Application Bias Showing?

Abstract:

Computers can't be biased, right? I mean, it's just lines of code. Yes or No. Ones Zeros. Those lines of code are written by people. People have life experiences that color how they see the world. Okay, let's be blunt. People have baggage. And that baggage is seeping into your application, surveys and web forms.

You've got an idea for a new app and it's going to change the world! Right? It's a brilliant idea no one has ever thought of it before. You're working on the GUI for your company's web portal and you know just what information to collect from the user. Are you sure about that? Odds are pretty good that the information you're going to collect is a reflection of your life your experiences.
Learn how to identify bias when it seeps in, how to code to be inclusive instead of exclusive , and some quick tips tricks to make sure you're accounting for all the users that will use YOUR application to change the world. Instead of just the ones that look like you.

SessionID: 82749

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: Business Intelligence

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 82951

How to be a lazy sysadmin and get away with it.

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: Windows Server/Virtualization

Speaker: David Pechon

Title: How to be a lazy sysadmin and get away with it.

Abstract:

Are you lazy? Do you hate doing the same mundane tasks over and over again. Well so do I. Come meet David Pechon, Louisiana’s laziest sysadmin and learn the dark arts of automation.

SessionID: 83065

Open Management Style

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: Professional Development

Speaker: David Reid

Title: Open Management Style

Abstract:

Interactive session with cover key aspects of defining, explaining its Best Practices, Problems and Conclusion regarding this innovative approach.

SessionID: 83162

Adopting A DevOps Process for Your Database

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: .NET Dev

Speaker: Steve Jones

Title: Adopting A DevOps Process for Your Database

Abstract:

DevOps is changing today's software development world by helping us build better software, faster. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.

SessionID: 83187

Get insights from data with Cognitive Services

Back to calendar

Event Date: 11-08-2018 - Session time: 12:15:00 - Track: .NET Dev

Speaker: Shawn Weisfeld

Title: Get insights from data with Cognitive Services

Abstract:

How can you take advantage of Artificial Intelligence without being a data scientist? Cognitive Services allow you use Artificial Intelligence to enrich your data through simple API calls. In this session, we will demonstrate the Cognitive Services and brainstorm how we can apply these to our applications.

SessionID: 73593

Dynamic SQL: Tables, Parameters and More

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: SQL Server Development

Speaker: Steven Tidwell

Title: Dynamic SQL: Tables, Parameters and More

Abstract:

Dynamic SQL is one of the best tools to have in your Developer tool chest. Dynamic SQL helps you design flexible code that can be manipulated at runtime. This session will walk you through the Pros and Cons of Dynamic SQL. Will give you the knowledge to build dynamic tables, pass in parameters and display your material in a pivot table. New this year, this session will give you the first steps to build multiple databases, alter tables dynamically across databases and do simple backups all through Dynamic SQL.

SessionID: 73851

Fundamentals That Will Improve Your Query Performance!

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: SQL Server Development

Speaker: John Wells

Title: Fundamentals That Will Improve Your Query Performance!

Abstract:

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

SessionID: 77698

SQL Server with Docker Containers

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: SQL Server Administration

Speaker: Marsha Pierce

Title: SQL Server with Docker Containers

Abstract:

An overview of creating SQL Server Containers and how you can clone your databases to Linux Containers. Containers are the future of DEVOPS!

SessionID: 78696

What is Power BI?

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: PowerBI

Speaker: Angela Henry

Title: What is Power BI?

Abstract:

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

SessionID: 80002

Know What Your Code is Doing to SQL Server!

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: SQL Server Development

Speaker: Kevin Boles

Title: Know What Your Code is Doing to SQL Server!

Abstract:

ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance, concurrency and scalability you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from the same flaws.

SessionID: 80512

3.NET Development with Windows 10 IoT Core

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: .NET Dev

Speaker: Al Manint

Title: 3.NET Development with Windows 10 IoT Core

Abstract:

Creating Windows IoT image for Raspberry Pi 3 and writing code that manages to the GPIO ports.

SessionID: 82510

Think Like a Certification Exam

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: Professional Development

Speaker: William Assaf

Title: Think Like a Certification Exam

Abstract:

Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation, what rules writers must follow, and review some sample questions together. We'll leave time for QA with a veteran of the Microsoft certification exam writing process.

SessionID: 83003

Fishing for Answers: Azure Data Lake

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Jeff Renz

Title: Fishing for Answers: Azure Data Lake

Abstract:

Did you ever hear someone say “make your data lake your staging area for your data warehouse” or “a data lake can handle any data format” or “if I build a data lake data everyone will use it”? Really? Are these good ideas and true statements? Is there a design strategy that I should follow so I don’t end up with a “data swamp”? Are there tools or techniques to load data into the lake and get data out easily? Can I easily visualize my data in the lake? What about security? And finally, how does a data lake really fit into my BI landscape when I have so many infrastructure and tool options to pick from?

This session will demo putting data into a data lake, pulling data, visualizing data, and testing data lake performance. I will evaluate the strengths, weaknesses and implementation approaches. At the end of the session everyone should have a clear picture of what Azure Data Lake is, how to implement it, and is it a good fit for your organization.

SessionID: 83226

How to index, win friends, and influence people.

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30: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: 84082

SQL on Linux ¦ Microsoft ♡ Linux … what about (us) Windows folks?

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: SQL Server Administration

Speaker: Zane Moreign

Title: SQL on Linux ¦ Microsoft ♡ Linux … what about (us) Windows folks?

Abstract:

SQL Server on Linux - yaaay! … wait, isn't that a whole new/open world of tech and licensing options? … and they need the info when? … but I'm already overloaded + the next build of windows is just … [vent away] …?!

PAUSE: Windows Server folks went through this a few years ago with the Cloud. Tex was a guest on TechNet-Edge Radio with John Weston speaking about it, recording on www.HybridDecisions.com

SPOILER: You actually become MORE valuable, the more you partake in the Linux world! (interested?)

CRUX: Kubernetes + Docker + SQL Server on Linux ~~ PostgreSQL on Linux … if time permits, deploy to Google Cloud and/or Microsoft Azure

AUDIENCE: Anyone (dev/pro/biz) interested in the new/open world of SQL Server on Linux (your competition/opportunity?), the newSQL DB options, and possible quick demos

SessionID: 84321

Code Like a Pirate ... Intro to R and Data Science Tools in MS

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Jamey Johnston

Title: Code Like a Pirate ... Intro to R and Data Science Tools in MS

Abstract:

Come to this session to get an introduction to the R language including:

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

SessionID: 84627

Mentoring Women in Tech: A Guide for Men Women Who Want to Help

Back to calendar

Event Date: 11-08-2018 - Session time: 13:30:00 - Track: Professional Development

Speaker: Rie Irish

Title: Mentoring Women in Tech: A Guide for Men Women Who Want to Help

Abstract:

Women make up less than 20% of the tech world and they're leaving the field at a rate over 3 times the rate that men are. Women cite lack of effective mentorship as one of the leading reasons for their exodus. Whether you're a colleague, a manager or someone who wants to change the status quo, your opportunity to effectively tip the scales changes.

What do you do for a living, what level are you at in your career and are you in any kind of management role? Can utilizing women's groups either at work or via a professional organization work for you? In this session, we'll discuss different ways you can mentor and sponsor women in tech. We'll provide concrete steps you can take to mentor, sponsor or just offer support. These solutions vary based on who YOU are, where you are in your career, if you have hiring/promotion influence, etc. Learn how you can make a difference.

SessionID: 73675

HiHo! HiHo! SQL Server on Linux, We Go!

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Janis Griffin

Title: HiHo! HiHo! SQL Server on Linux, We Go!

Abstract:

SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.

The participant will learn:

  1. The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
  2. How to install, maintain and backup SQL Server on Ubuntu Linux systems
  3. Several useful Linux commands to monitor/manage SQL Server

SessionID: 73755

T-SQL's Hidden Support Feature

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: SQL Server Development

Speaker: Jennifer McCown

Title: T-SQL's Hidden Support Feature

Abstract:

The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature's name is "comments".

In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.

SessionID: 73876

Careers in IT - Baton Rouge 2018

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: Career

Speaker: Michael Viron

Title: Careers in IT - Baton Rouge 2018

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

Composing Functions With Javascript

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: .NET Dev

Speaker: Jay Tulk

Title: Composing Functions With Javascript

Abstract:

What is this function composition wizardry?

From defining and understanding it conceptually to digging in and refactoring some code, you will gain useful insight into utilizing function composition. We will also look at common architecture strategies and take a fresh look at common composition-based design patterns.

SessionID: 80003

SQL Server Defaults SUCK!!

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Kevin Boles

Title: SQL Server Defaults SUCK!!

Abstract:

If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

SessionID: 80866

Developing Custom Extractors for Azure Data Lake

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: .NET Dev

Speaker: Russel Loski

Title: Developing Custom Extractors for Azure Data Lake

Abstract:

Azure Data Lake Analytics provides a set of built in extractors to process well-structured delimited text files. U-SQL uses these extractors to parse these files

But U-SQL is not limited to processing delimited files. Using Custom Extractors you can parse JSON or XML files. You can use Custom Extractors to work with irregularly formatted delimited files. Custom Extractors can even parse image files. Developers have created Custom Extractors for these and other file formats and made them available on the U-SQL GitHub site. We will look at two of these Custom Extractors: Flexible Schema Extractor and the JSON Extractor. We will look at how to deploy these Extractors and extend them.

SessionID: 81969

Performance Tuning with a Microsoft MVP

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Daniel Janik

Title: Performance Tuning with a Microsoft MVP

Abstract:

The life of a DBA is evolving and your tuning skills should always be sharp. Tuning is one of the key components of a great DBA and developer. In this demo rich session we'll deep dive into performance tuning for On-Prem, PaaS, and IaaS. We'll discuss tips and techniques for troubleshooting bottlenecks and how to remediate them for hardware, OS, and the database.

SessionID: 82458

2017 SSIS Scale Out: How and Why

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Paul LaGrone

Title: 2017 SSIS Scale Out: How and Why

Abstract:

2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.

SessionID: 82617

Well, actually... An entertaining WIT session for the men

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: Professional Development

Speaker: Rie Irish

Title: Well, actually... An entertaining WIT session for the men

Abstract:

IT can be an inhospitable, isolated place for women minorities. Women are leaving IT at 2.5x rate as men and are interrupted 3x as often. Our credentials are called into question. We're called emotional or aggressive. We have our own job explained to us. People of color often can't get a call back on an application, regardless of how experienced they are. Bias exists everywhere. It's in our nature.

Sometimes it's subtle. Other times it's overt. Most of the guys we work with are stand-up, respectable WIT allies. There's always that one guy who ruins it for the rest of you. The problem is, you don't always notice when it happens. Learn what those subtle forms of sexism racism look like at work. Learn how you can stop that guy in his tracks. Learn how to not BE that guy, even when you're just trying to help.

SessionID: 82829

Power BI Report Server: A Deep Dive

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Patrick LeBlanc

Title: Power BI Report Server: A Deep Dive

Abstract:

So, you think you know everything you need to know about the Power BI Report Server because you use traditional SQL Server Reporting Services. Well, don’t believe it. In this session we are going to discuss topics such as Configuring Kerberos to resolve connectivity issues. We will discuss different authentication types, when you need them, why you need them and how to use them. We will then jump into configuring your report server to host Excel workbooks using Office Online Server. Finally, we will demonstrate how to configure an SSAS Power Pivot instance for the Excel data model. In addition to these topics, we will discuss other advanced topics such as connectivity and high availability during this demo-heavy session.

SessionID: 83002

Introduction to Azure Cosmos DB SQL API

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Jeff Renz

Title: Introduction to Azure Cosmos DB SQL API

Abstract:

Developers are interested in consuming and processing very large amounts of data as quickly as possible. Azure Cosmos DB is a NoSQL document database service designed for modern mobile and web applications which require fast reads and writes of unstructured data feeds. Azure Cosmos DB natively supports JSON documents which is a key performance feature.

In this session, you will learn how to: create a Cosmos DB instance in Azure; work with JSON documents; create Ad hoc queries with familiar SQL syntax; create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript; manage security; modify indexes; stream twitter data into a collection; extract data using SSIS C# script tasks into SQL Server; visualize data using PowerBI; and finally compare performance and feature differences between SQL Server 2017 and Azure Cosmos DB when working with JSON data.

SessionID: 83322

Building Great Services

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: .NET Dev

Speaker: Mike Huguet

Title: Building Great Services

Abstract:

I am responsible for several Azure-based microservices at Microsoft that are consumed internally and exposed to customers through PowerApps, Dynamics 365, and more to come in the future. In this session we will discuss the following qualities that help make-up a great cloud based service: reliable, scalable, secure, compliant, and supportable. This is an architectural level discussion with no code.

SessionID: 83771

STEMupBR Kid's Showcase

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: StemUP Kid's Track

Speaker: William Assaf

Title: STEMupBR Kid's Showcase

Abstract:

REGISTRATION REQUIRED: https://foundationebr.org/brstem/calendar.html/event/2018/08/11/sqlsatbr-2018-stemupbr-kids-track/205026

Questions? Email sqlpassbr@gmail.com

SessionID: 84661

The DATA⋅CLOUD Talk

Back to calendar

Event Date: 11-08-2018 - Session time: 14:45:00 - Track: CIO/Executive

Speaker: Anthony {Tex} Moreign

Title: The DATA⋅CLOUD Talk

Abstract:

This talk connects the dots between quite some tangents ~ the obvious and the not-so-obvious/forgotten/new-ish aspects of DATA (Big Data, Small Data, Tiny Data, Data Lakes, Data Reservoirs, Micro Data, Macro Data), and CLOUD (Hybrid, Global, Microsoft, Non-Microsoft) available as of this point-in-time (Aug-2018) ~ and some other thoughts.

AUDIENCE: Decision makers, decision influencers, or anyone interested in how DATA tangos with the CLOUD, and the resulting INFORMATION (actionable or otherwise).

PRE-REQUISITES: none

SPEAKER DISCLOSURE: Tex (20+ year technologist) is with Hybrid Decisions®, a multi-competency Microsoft Gold Partner (consistently since year-1) and OpenSource/Linux (originally C/Unix folks who embraced Microsoft OpenSource/Linux) … speaking on behalf of HCCUG.org «±»

This site is open source. Improve this page.