sqlsathistory

Nr: 515

Back to Main list

SQLSaturday #515 - Baton Rouge 2016

Start Time (24h) Speaker Track Title
09:15:00 Theresa Eller SharePoint SharePoint 101 for Beginners
09:15:00 Mel Lusk SQL Server Beginner Hiding Data from Prying Eyes: Using SQL Server 2016 Always Encrypted
09:15:00 Ken Clement SQL Server Development SQL Anti-Patterns and when it's Okay to be Bad
09:15:00 Andie Saizan .NET Dev Get addicted to MEF and use it in your architecture.
09:15:00 Mike Robbins PowerShell PowerShell Fundamentals for the Absolute Beginner
09:15:00 Robert Canzonire SQL Server Administration Optimizing Backup and Restore Performance in Sql Server
09:15:00 James Alt Mobile App Dev Creating Cross-Platform Mobile Applications with Xamarin
09:15:00 Brandon Cornett .NET Dev Continuous Integration and Delivery
09:15:00 Niraj Kumar Career Should you care about Leadership Skills? A System Engineer's view
09:15:00 Chris Hyde Business Intelligence SQL Server R Services in SQL 2016
09:15:00 Stacy Vicknair Career Simple Steps for Starting Your Business
09:15:00 Alex Clavelle Web Dev Building an Awesome UI with React and Redux
09:15:00 Patrick Thompson IT Executive CIO Strategy Panel
10:30:00 Tim Mitchell Business Intelligence Testing SSIS Packages
10:30:00 Josh Dicharry IT Executive Organizing the Chaos.... Utilizing JIRA Confluence for your project teams
10:30:00 Robert Bishop SQL Server Beginner Hostile Takeover
10:30:00 Lynsey Gwin Design User Experience: Empathy for our users (and teammates)
10:30:00 Brian Rigsby .NET Dev The Binary Language of Music
10:30:00 Trace Armstrong SharePoint The Dirtiest Word in SharePoint - Governance
10:30:00 Thomas LaRock SQL Server Development Cardinality Estimates in Microsoft SQL Server 2014
10:30:00 Jason Rowlen Design Effective Software Application Logging
10:30:00 Amy Herold PowerShell Hi, my name is Powershell, let's be friends! An Intro to PoSH
10:30:00 Brandon Cornett Mobile App Dev Connecting Mobile Apps with an ASP.NET Web API
10:30:00 Stephen Fulcher SQL Server Development Building a Simple SQL Server Partitioning Solution
10:30:00 Russel Loski SQL Server Development Meet JSON in SQL Server 2016
10:30:00 Nicole Payne-Jack Career Stand and Deliver: Elements of Effective Presentations
12:15:00 Mechelle Roberthon IT Executive Strategic Decision Making and Problem Solving
12:15:00 Christine Assaf IT Executive Giving Feedback: How to Effectively Communicate to your Employees
12:15:00 Theresa Eller SharePoint Secrets for a Better SharePoint Experience
12:15:00 Mike Robbins PowerShell PowerShell Desired State Configuration from the Trenches
12:15:00 Mike Byrd SQL Server Development SS2014/2016 In-Memory Tables --Formula One Performance Unleashed???
12:15:00 Lori Brown SQL Server Administration Actively Proactive – Straightforward Ways to Manage and Diagnose SQL
12:15:00 Lizzie Broussard .NET Dev Ad Hoc Quality Assurance: A Practical Guide
12:15:00 Quinton Jason Jr Design Use SVG to Bring the Web to Life
12:15:00 Steven McGee IT Executive Agile Myths and Lessons Learned
12:15:00 Tim Costello Business Intelligence Simplify ETL with BIML
12:15:00 Seth Valdetero Mobile App Dev From Dev to Deployment: DevOps for Your Mobile App
12:15:00 Daniel Janik SQL Server Administration Everything you ever wanted to know about query tuning in SQL 2016!
12:15:00 Jim Brown Career Toastmasters and what it can do for you
13:30:00 Michael Viron Career Careers in IT
13:30:00 Jeremy Abbott .NET Dev Advanced Topics in F#
13:30:00 Jamey Johnston SQL Server Development Overview of Security Investments in SQL Server 2016 and Azure SQL Database
13:30:00 Sven Aelterman SQL Server Administration Azure SQL Database: 12 Things To Know
13:30:00 Cody Gros SharePoint Planning Your SharePoint Online Migration Strategy
13:30:00 Calvin Fabre Career Beauty and the Bits: Why both Left and Right Brain MUST be Engaged
13:30:00 Eric Trivette .NET Dev Digging Into ASP.NET Core 1
13:30:00 Amy Herold PowerShell Beginning Automation with Powershell
13:30:00 Thomas LeBlanc Business Intelligence Business Analytics with Microsoft Business Intelligence
13:30:00 Sean McCown SQL Server Administration DIY Performance Reporting
13:30:00 Patrick Thompson IT Executive Business Analytics for Cadence Management
13:30:00 Steve Schaneville .NET Dev Unit Testing in a Team - A Kick Starter
13:30:00 Karen Lopez SQL Server Administration A Database Designer's Favorite Features in 2016: Security, Privac
14:45:00 Stan Geiger IT Executive The Data Warehouse of the Future
14:45:00 Joe Hellsten SQL Server Administration Fun Facts about Availability Groups
14:45:00 Jennifer McCown SQL Server Development Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos
14:45:00 Lance Tidwell SQL Server Administration Ways SQL Server Lies and the Performance Tuning Headaches It Can Cause.
14:45:00 Anthony Nocentino SQL Server Administration Performance Monitoring AlwaysOn Availability Groups
14:45:00 George Mauer .NET Dev History of the web and why even Javascript
14:45:00 Robert Cain PowerShell Pester the Tester: PowerShell Bugs Beware!
14:45:00 William Assaf Career SQLSaturday Jeopardy!
14:45:00 Keyur Vadhvana SharePoint Advanced SharePoint App Development
14:45:00 James Davis IT Executive Scrum: The Brazilian Jiu-Jitsu of agile application development
14:45:00 Jeffry Schwartz SQL Server Administration Rx for Demystifying Index Tuning Decisions
14:45:00 Adam Culpepper Web Dev Rapid Prototyping with Google Spreadsheets and using your DBA budget for bacon

SessionID: 44743

SharePoint 101 for Beginners

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: SharePoint

Speaker: Theresa Eller

Title: SharePoint 101 for Beginners

Abstract:

In this introduction to SharePoint session, attendees will learn about the building blocks of SharePoint, such as: What is a list? What is a library? What is a web part? Should I view/edit documents in the browser or in the client? What is versioning? How do I check out and check in a document? Additionally, attendees will learn how to create, modify, and switch views, as well as set up and manage alerts. This session will include demos in Office 365, but the concepts apply to all versions of SharePoint, from 2003 to 2016.

SessionID: 48696

Hiding Data from Prying Eyes: Using SQL Server 2016 Always Encrypted

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: SQL Server Beginner

Speaker: Mel Lusk

Title: Hiding Data from Prying Eyes: Using SQL Server 2016 Always Encrypted

Abstract:

Past versions of SQL Server didn't include many options for encrypting data outside of network traffic and at rest. This is going to change with SQL Server 2016, which has a new feature named "Always Encrypted". This talk will show the fundamentals of using this technology and a demo of how to configure it and work with the encrypted data.

SessionID: 49299

SQL Anti-Patterns and when it's Okay to be Bad

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: SQL Server Development

Speaker: Ken Clement

Title: SQL Anti-Patterns and when it's Okay to be Bad

Abstract:

Did I really do that? If you didn't, you probably will. And even if you don't ever, it's a good bet that you will still have to deal with others' legacies of Anti-Patterns. Decades of practice by thousands of software and database developers around the world have produced a large corpus of recognized best practices, Anti-Patterns are the antithesis of best practice - they are recognized as approaches to be avoided. SQL databases including SQL Server are no exception. A number of SQL Anti-Patterns will be described here, along with better practices and exceptions where the Anti-Pattern may actually be a good answer. This presentation ought to be a spectator's delight - a chance to slow down and admire the train wrecks of others. For nothing is as instructive as mistakes or as fun to dissect.

SessionID: 49652

Get addicted to MEF and use it in your architecture.

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: .NET Dev

Speaker: Andie Saizan

Title: Get addicted to MEF and use it in your architecture.

Abstract:

In this session we will go over the benefits of using MEF and how to implemented it in a MVC web application.

SessionID: 50038

PowerShell Fundamentals for the Absolute Beginner

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PowerShell Fundamentals for the Absolute Beginner

Abstract:

Interested in PowerShell but not sure how to get started? Already have some experience but still having trouble with the basic concepts? This session is for you! Learn to easily figure out what the commands are and how to use those commands without searching the Internet. Extend PowerShell’s functionality to manage products like SQL Server. During this presentation, PowerShell MVP Mike F Robbins will demonstrate several of the core PowerShell cmdlets along with writing one-liners and basics scripts. We’ll discuss how to prevent resume generating events when making changes with PowerShell. Learn what objects, properties, and methods are along with how they’re used in PowerShell. Not a developer? PowerShell is one of those technologies that you can be extremely effective with whether you’re a developer or an IT Pro.

SessionID: 50370

Optimizing Backup and Restore Performance in Sql Server

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: SQL Server Administration

Speaker: Robert Canzonire

Title: Optimizing Backup and Restore Performance in Sql Server

Abstract:

Microsoft SQL Server offers the several ways of speeding up backup and restore operations

I will discuss and demonstrate way I took a backup that ran in 279 minutes down to 34 minutes with multiple options. I will also discuss the several backup types (full, differential, and log) to minimize to recovery time.

SessionID: 50452

Creating Cross-Platform Mobile Applications with Xamarin

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: Mobile App Dev

Speaker: James Alt

Title: Creating Cross-Platform Mobile Applications with Xamarin

Abstract:

We are quickly moving towards becoming a mobile first world and you don't want to be left behind. Leverage your vast .NET knowledge and learn how to build mobile apps on the .NET stack with Xamarin. Recently acquired by Microsoft, Xamarin allows you to build native, fast, beautiful cross-platform mobile applications in C# (or even F#). In this session we will go over the basics of creating a mobile application using Xamarin.Forms, utilizing C# to build a real-world application using a single shared codebase. We will also cover the latest from Build and Evolve, looking at the latest changes from Microsoft/Xamarin and what they will mean for you. This session expects that you have an understanding of the C# language and .NET development.

SessionID: 50584

Continuous Integration and Delivery

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: .NET Dev

Speaker: Brandon Cornett

Title: Continuous Integration and Delivery

Abstract:

Continuous integration and continuous delivery are two practices that can drastically reduce any software company's testing and deployment times. In this talk, we will be discussing several tools (including TeamCity and Octopus Deploy) that you can use to streamline these tasks, as well as how you can go from having nothing to a baseline project set up using a template that you've previously created on a publicly accessible development environment in less that 5 minutes. The days of copying and pasting files to a server to deploy your code are over.

SessionID: 50856

Should you care about Leadership Skills? A System Engineer's view

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: Career

Speaker: Niraj Kumar

Title: Should you care about Leadership Skills? A System Engineer's view

Abstract:

As more businesses need technical acumen in their management ranks, acquiring and mastering leadership skills are paramount for a technical professional seeking career growth. Why and how should you approach the leadership discipline? Learn how you can approach your own leadership growth, as Niraj presents a case to view leadership with the lens of a Systems Engineer. You will gain an understanding of a leadership framework that you can start applying right away. Niraj started his career as a programmer, and later served in multiple management roles.

SessionID: 50862

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: Business Intelligence

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 51054

Simple Steps for Starting Your Business

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: Career

Speaker: Stacy Vicknair

Title: Simple Steps for Starting Your Business

Abstract:

Do you dream about starting a business? You’re not alone—millions of Americans share that dream. And yet, not everyone has the courage to get started. But if you’re reading this, you have already taken the first steps toward turning your dream into reality.

Obviously, dreaming alone isn’t enough. You have to do your homework, create a plan and take action. You will have good days and bad ones. But don’t get discouraged. As Walt Disney said, “If you can dream it, you can do it. Always remember this whole thing was started by a dream and a mouse.”

Simple Steps for Starting Your Business is more than just a guide to business ownership. It’s really a blueprint for helping make your dreams a reality.

In this session Bob Breaux from the Baton Rouge SCORE chapter will introduce you to the foundations of starting your own business and give you insight into the resources that are available to you within the state of Louisiana to do so!

SessionID: 51080

Building an Awesome UI with React and Redux

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: Web Dev

Speaker: Alex Clavelle

Title: Building an Awesome UI with React and Redux

Abstract:

In this presentation I will give an introduction to building UIs with React and managing application state with Redux. I will also demonstrate some cool tricks such as serverside rendering of react components, time travel debugging, and some general javascript and es6 best practices.

SessionID: 51091

CIO Strategy Panel

Back to calendar

Event Date: 06-08-2016 - Session time: 09:15:00 - Track: IT Executive

Speaker: Patrick Thompson

Title: CIO Strategy Panel

Abstract:

A panel of regional CIO's gathers to discuss questions for modern IT Leadership and Enterprise Performance Management.

SessionID: 44779

Testing SSIS Packages

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: Business Intelligence

Speaker: Tim Mitchell

Title: Testing SSIS Packages

Abstract:

Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.”

As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system.

This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these:

SessionID: 46913

Organizing the Chaos.... Utilizing JIRA Confluence for your project teams

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: IT Executive

Speaker: Josh Dicharry

Title: Organizing the Chaos.... Utilizing JIRA Confluence for your project teams

Abstract:

Organizing the Chaos

Utilizing JIRA Confluence to bring clarity to your projects and teams

Do you have a difficult time keeping your teams organized? Do you struggle with providing real time reporting on your projects? Do you feel like your project tracking system is difficult to customize? We will show you how we have used JIRA and Confluence to organize and increase the visibility of not only our IT projects, but also our non-IT projects. We will also show you how these tools allowed us to improve client communication and satisfaction for a variety of our service lines.

SessionID: 48306

Hostile Takeover

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: SQL Server Beginner

Speaker: Robert Bishop

Title: Hostile Takeover

Abstract:

In the spirit of Tim Ford's year long Entry Level Challenge, what do you do when given a SQL Server to manage? This presentation will walk you through how to gain access to a SQL Server you have never seen before, what are the basic tools to use to collect inventory information, and what scripts I use to best determine the "health" of the server.

SessionID: 48417

User Experience: Empathy for our users (and teammates)

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: Design

Speaker: Lynsey Gwin

Title: User Experience: Empathy for our users (and teammates)

Abstract:

At the core of User Experience is Empathy. The ability to be empathetic to your end user can be deceptively challenging. Just because something works does not always mean it is the best and easiest functionality to serve to your audience. In this session, we will review some common areas of practice in the User Experience process to get into the mind of your target user and make design and development decisions based on empathy. As an added bonus, we will also discuss how to achieve empathy for the product team around you in order to build the best possible solution for your client together.

SessionID: 48481

The Binary Language of Music

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: .NET Dev

Speaker: Brian Rigsby

Title: The Binary Language of Music

Abstract:

Take a fascinating and entertaining journey into the binary and mathematical patterns found in music and how they can be used to learn the underlying language of music theory and applied to other disciplines.

SessionID: 49189

The Dirtiest Word in SharePoint - Governance

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: SharePoint

Speaker: Trace Armstrong

Title: The Dirtiest Word in SharePoint - Governance

Abstract:

Governance is tricky within any organization no matter its size. This session will highlight best practices for gathering requirements and setting policies in the process of Records Management in SharePoint and what tools are available out of the box to help your organization succeed.

SessionID: 50400

Cardinality Estimates in Microsoft SQL Server 2014

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: SQL Server Development

Speaker: Thomas LaRock

Title: Cardinality Estimates in Microsoft SQL Server 2014

Abstract:

SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.

SessionID: 50603

Effective Software Application Logging

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: Design

Speaker: Jason Rowlen

Title: Effective Software Application Logging

Abstract:

This session presents an overview of effective methods and strategies for capturing and managing useful information about how your software applications are running, what they are doing (which may or may not be what they are expected to be doing), and most importantly, when, where, and sometimes even why, they are malfunctioning. Software application logging is an often neglected, poorly implemented, and under-appreciated aspect of the software development process. But if implemented wisely, logging can be an invaluable tool for debugging, testing, error handling, and auditing. This session will present a case for a more diligent and rewarding approach to logging, and provide useful tips that can cost very little extra development time, but pay off in the long run, most especially when production issues arise and must be resolved quickly.

SessionID: 50672

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: PowerShell

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 51062

Connecting Mobile Apps with an ASP.NET Web API

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: Mobile App Dev

Speaker: Brandon Cornett

Title: Connecting Mobile Apps with an ASP.NET Web API

Abstract:

In this talk, we'll create an ASP.NET Web API from scratch, and then demonstrate how you can communicate with it and manipulate data using a cross-platform (iOS, Android, and Windows Phone) Xamarin Forms app. Because ASP.NET Web API is a RESTful framework, you'll also be able to use this API with any other platform that can make HTTP calls.

SessionID: 51085

Building a Simple SQL Server Partitioning Solution

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: SQL Server Development

Speaker: Stephen Fulcher

Title: Building a Simple SQL Server Partitioning Solution

Abstract:

SessionID: 51141

Meet JSON in SQL Server 2016

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: SQL Server Development

Speaker: Russel Loski

Title: Meet JSON in SQL Server 2016

Abstract:

There have been many data lingua franca over the years (EDI, CSV, XML). Let's meet a new comer JSON (aka Jason). JSON is the web developers new best friend, providing a schema free way to transmit and persist data. SQL Server 2016 has provided new functionality to work with JSON. In this session we will look at how to read a JSON document using the OPENJSON function. We will also look at other methods for extracting information from JSON. Finally, we will look at how to generate JSON documents from TSQL queries.

SessionID: 53044

Stand and Deliver: Elements of Effective Presentations

Back to calendar

Event Date: 06-08-2016 - Session time: 10:30:00 - Track: Career

Speaker: Nicole Payne-Jack

Title: Stand and Deliver: Elements of Effective Presentations

Abstract:

75% of U.S. Americans have some level of fear of public speaking. A lot of that fear comes from not understanding the basic elements of effective presentations. In today's work world, your ability to present with authority and confidence can mean the difference between success and set-back. In this session, trainer Nicole Payne-Jack will bring these elements to help you to stand and deliver effective presentations. Topics include: finding your voice, elements of presentation construction, best visual aids practices, and how to overcome nervousness.

SessionID: 46340

Strategic Decision Making and Problem Solving

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: IT Executive

Speaker: Mechelle Roberthon

Title: Strategic Decision Making and Problem Solving

Abstract:

The key to finding creative solutions is not just creativity, although that will certainly help. The answer rests in our ability to identify options, research them, and then put things together in a way that works. Having a process to work through can take the anxiety out of problem solving and make decisions easier. That’s what this session is all about. Participants will learn how to: Apply problem solving steps and tools/Analyze information to clearly describe problems/Identify appropriate solutions/ Think creatively and be a contributing member of a problem solving team/ Select the best approach for making decisions/ Create a plan for implementing, evaluating, and following up on decisions/ Avoid common decision-making mistakes

SessionID: 46565

Giving Feedback: How to Effectively Communicate to your Employees

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: IT Executive

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

Secrets for a Better SharePoint Experience

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: SharePoint

Speaker: Theresa Eller

Title: Secrets for a Better SharePoint Experience

Abstract:

What are the secrets to having a better SharePoint experience? In this session, we will take a look at the secrets, tips, and tricks a large healthcare organization employs to improve their employees' SharePoint experience. Topics include selecting a browser, granting permissions properly, avoiding prohibited characters in file names, replacing folders with metadata, preparing for the list view threshold, saving your skin with versioning, and more. Demos will be conducted in Office 365 but concepts apply to SharePoint on-premises as well.

SessionID: 50041

PowerShell Desired State Configuration from the Trenches

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PowerShell Desired State Configuration from the Trenches

Abstract:

SessionID: 50444

SS2014/2016 In-Memory Tables --Formula One Performance Unleashed???

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: SQL Server Development

Speaker: Mike Byrd

Title: SS2014/2016 In-Memory Tables --Formula One Performance Unleashed???

Abstract:

Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables.

This session is all about when and how to apply in-memory tables in a production environment. After this session you will

  1. Understand what in-memory tables are and how to create and maintain them including their limitations
  2. Be able to identify performance gains over equivalent disk back tables
  3. Comprehend the new data monitoring needed for in-memory table

SessionID: 50620

Actively Proactive – Straightforward Ways to Manage and Diagnose SQL

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: SQL Server Administration

Speaker: Lori Brown

Title: Actively Proactive – Straightforward Ways to Manage and Diagnose SQL

Abstract:

SessionID: 50709

Ad Hoc Quality Assurance: A Practical Guide

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: .NET Dev

Speaker: Lizzie Broussard

Title: Ad Hoc Quality Assurance: A Practical Guide

Abstract:

In this presentation, I will guide the audience through where and how Quality Assurance can be applied to all phases of a development project as well as practical instructions on how to full test and confirm requirements of a feature using ad hoc testing.

SessionID: 51024

Use SVG to Bring the Web to Life

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: Design

Speaker: Quinton Jason Jr

Title: Use SVG to Bring the Web to Life

Abstract:

SVG is more than just an image format. It’s a solution that solves many problems with today’s rapidly growing web, especially in responsive design. SVG also contains many features to enhance the user's experience: accessibility, resolution independence, and interactivity. We'll see why we should use SVG, how to style SVG using CSS, how to animate SVG to bring the web to life, and much more.

SessionID: 51089

Agile Myths and Lessons Learned

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: IT Executive

Speaker: Steven McGee

Title: Agile Myths and Lessons Learned

Abstract:

No Documentation! No plan! those and other myths and lessons learned

SessionID: 51095

Simplify ETL with BIML

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: Business Intelligence

Speaker: Tim Costello

Title: Simplify ETL with BIML

Abstract:

You want to download a file from FTP, process the data into a staging table in your database and archive the file ... I'll show you how to do all that with BIML. I'll share the code I use and show you just how easy it is to simplify your ETL with BIML.

SessionID: 51103

From Dev to Deployment: DevOps for Your Mobile App

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: Mobile App Dev

Speaker: Seth Valdetero

Title: From Dev to Deployment: DevOps for Your Mobile App

Abstract:

Visual Studio Team Services has some new integrations for your Xamarin mobile apps. We#39;ll be taking an existing mobile app and adding Continuous Integration to ensure your app builds, connecting to build agents, and Continuous Deployment to HockeyApp. We will also discuss another CI/CD service, Bitrise, which has its own build agents. With all of the different platforms and integration points, there#39;s no reason why these steps should be manual. Learn how to leverage your existing Microsoft tools and subscriptions to get your app out faster and with less human interaction.

SessionID: 51104

Everything you ever wanted to know about query tuning in SQL 2016!

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: SQL Server Administration

Speaker: Daniel Janik

Title: Everything you ever wanted to know about query tuning in SQL 2016!

Abstract:

Learn the new features of SQL 2016 that not only apply to 2016 but can also help manage and tune your older versions! This advanced session covers the query store and many new features of Management Studio, as well as a deep dive into the query plan and optimizer itself. Join me as I cover the noteworthy tuning tools and techniques that every DBA and developer should know!

SessionID: 51151

Toastmasters and what it can do for you

Back to calendar

Event Date: 06-08-2016 - Session time: 12:15:00 - Track: Career

Speaker: Jim Brown

Title: Toastmasters and what it can do for you

Abstract:

Introduction to Toastmasters International and what they can do to enhance your Leadership and Speaking abilities.

SessionID: 45368

Careers in IT

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: Career

Speaker: Michael Viron

Title: Careers in IT

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

Advanced Topics in F#

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: .NET Dev

Speaker: Jeremy Abbott

Title: Advanced Topics in F#

Abstract:

You know that F# .NET's functional programming language. You know that it supports default immutability, functions as types, and type inference, and even OOP. But do you know about the other awesome language features like pattern matching, discriminated unions, sequences, mailbox processors, type providers, and a plethora of other awesome tools? Learn how F# can make you productive in your day to day work using these awesome language features.

SessionID: 46594

Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: SQL Server Development

Speaker: Jamey Johnston

Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Abstract:

Join me for an overview of the most recent security investments for SQL Server 2016 and Azure SQL Database in the areas of encryption, data filtering and data masking. I will showcase a real-life user scenario with examples and demos of Always Encrypted, Row Level Security and Dynamic Data Masking. The demos include a real working .NET application with source code for testing. This is based on the session and demos I co-presented with Microsoft at SQL Summit 2015 so if you missed Summit or the presentation and are interested in learning what Microsoft is doing in the area of security in SQL Server 2016 and Azure SQL DB then this is the session for you.

SessionID: 48540

Azure SQL Database: 12 Things To Know

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: SQL Server Administration

Speaker: Sven Aelterman

Title: Azure SQL Database: 12 Things To Know

Abstract:

Up and running with Azure SQL Database already? This session will provide a grab bag of 12 how-to items you'll need to know to successfully keep your database running. Among those, we'll cover PowerShell for Azure SQL DB, geo-replica and other disaster recovery features and monitoring.

SessionID: 50110

Planning Your SharePoint Online Migration Strategy

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: SharePoint

Speaker: Cody Gros

Title: Planning Your SharePoint Online Migration Strategy

Abstract:

With the advantages of Office365/SharePoint Online, many organizations are evaluating their SharePoint on-prem environments for cloud migration readiness. If you are not sure where to start on the road-map to migration from SharePoint on-prem to SharePoint Online, this session is for you. In this session, we will cover the key points when developing a strategy for migrating to SharePoint Online. Whether you are currently using SharePoint On-Prem for Enterprise Content Management, Team Sites Collaboration, Process Automation, or all of the above, this session will provide tips for developing a migration road-map to make your migration successful.

SessionID: 50281

Beauty and the Bits: Why both Left and Right Brain MUST be Engaged

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: Career

Speaker: Calvin Fabre

Title: Beauty and the Bits: Why both Left and Right Brain MUST be Engaged

Abstract:

Whether you plan to run your own consulting business, be a freelancer, or be a healthy part of a software or design team you will need to understand the importance of engaging both your left- and right-brain in the future. Sure, you are smart and you have a good left-brain, but raw processing power, reasoning, and logic are not enough to compete, provide, or even survive in the coming "Conceptual Age." Just as manufacturing automation put much of the "human back" out of business in the Industrial Age, certain forces threaten to put the "human brain" out of business in the age to come. This talk will prepare you for its arrival and insulate you for its duration. Learn how to recognize and utilize the value of well-rounded thinking as you progress throughout your career.

SessionID: 50513

Digging Into ASP.NET Core 1

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: .NET Dev

Speaker: Eric Trivette

Title: Digging Into ASP.NET Core 1

Abstract:

With the release of ASP.NET Core 1, a slew of major changes have been made to the way ASP.NET applications are built. In this presentation, we will talk about the new structure of ASP.NET projects, covering aspects like project structure, the updated project file, the new request pipeline, dependency injection, and middleware. We will also cover the new features of ASP.NET Core 1 MVC like tag helpers, view components, and bundling changes. This presentation assumes the attendee has some experience with the ASP.NET MVC framework.

SessionID: 50671

Beginning Automation with Powershell

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: PowerShell

Speaker: Amy Herold

Title: Beginning Automation with Powershell

Abstract:

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.

SessionID: 50675

Business Analytics with Microsoft Business Intelligence

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Thomas LeBlanc

Title: Business Analytics with Microsoft Business Intelligence

Abstract:

It all starts with formatting your data in a dimensional model. Then, you need to be able to take that model and create a fast database in analysis services. This will consolidate the business rules and give us fast retrieval of the information.

PowerBI and Excel can be used by analysts to view this data and produced fixed dashboards and scorecards. But we also need to be able to create interactive displays for current data.

SessionID: 51060

DIY Performance Reporting

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: SQL Server Administration

Speaker: Sean McCown

Title: DIY Performance Reporting

Abstract:

Stop relying on vendors to provide you with performance data. Between Windows and SQL Server you’ve already got all you need to collect and report on server performance. And it’s far more flexible than you’ll ever get from a vendor. This is often called a poor man’s method, but it’s so much more than that. I’m going to show you what your options are for collecting performance data for free and you’ll even walk away with a framework you can plug into your own environment and start using tomorrow with very little effort.

SessionID: 51092

Business Analytics for Cadence Management

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: IT Executive

Speaker: Patrick Thompson

Title: Business Analytics for Cadence Management

Abstract:

The secret to running a successful analytics program is knowing which projects to tackle, and how to use those analytics to improve your company’s overall performance. We'll review how SQL Server and Power BI technologies can play a role in the architecture of Enterprise Performance Management.

Join Patrick Thompson, Sparkhound General Manager Partner and former CIO for several Louisiana Fortune 500 companies, as he highlights proven strategies for selecting the key lead and lag metrics to align IT with business goals, organizing those measurements and forecasts into a cadence management dashboard, and coaching your teams to use that dashboard effectively.

SessionID: 51150

Unit Testing in a Team - A Kick Starter

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: .NET Dev

Speaker: Steve Schaneville

Title: Unit Testing in a Team - A Kick Starter

Abstract:

I (and a team of people much sharper than me) tried to push unit testing onto established development teams on multiple occasions in the past, and we failed repeatedly... until we figured out the things that we'll discuss in this session. We will cover a set of rules and guidelines for bringing the practice of unit testing into a team of developers who may or may not be interested in persuing unit testing. We will include patterns and approaches for ensuring that the tests that we write are highly legible, maintainable, and bring genuine value to the team. We will learn to structure our unit testing practices so that our efforts do not fade away in time due to lack of upkeep.

Unlike most of my sessions in the past, we won't be writing any code or doing demos in this session. This will be more about the patterns and rules. Target audience is anyone interested in bringing unit tests to their development team, or anyone has struggled to keep unit testing efforts afloat in the past.

SessionID: 52899

A Database Designer's Favorite Features in 2016: Security, Privac

Back to calendar

Event Date: 06-08-2016 - Session time: 13:30:00 - Track: SQL Server Administration

Speaker: Karen Lopez

Title: A Database Designer's Favorite Features in 2016: Security, Privac

Abstract:

The launch of SQL Server 2016 means there will be a lot of blog posts and webinars of people talking about all the great administration features that come with this new release. Karen Lopez and Thomas LaRock will be sharing the best features from a database designers point of view -- from Always Encrypted to Zombie Datatypes.

We'll look at the new features, why you should consider them, where they work, where they don't, who needs to be involved in using them, and what changes, if any, need to be made to applications or tools that you use with SQL Server.

SessionID: 44712

The Data Warehouse of the Future

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: IT Executive

Speaker: Stan Geiger

Title: The Data Warehouse of the Future

Abstract:

So you think you have the ultimate Data Warehouse...well think again. The landscape or should I say the data lake is changing constantly. We are getting data from all over the place. How do we make it available and relevant for the consumers of a data warehouse. Is Kimbell obsolete now, what about unstructured data, how about the gazillioin rows of click data, etc. So the data and BI architects are all on suicide watch. Well its not really that bad. Microsoft has woken up and seen all that is going and has brought functionality to SQL Server to solve some of these issues. This presentation provides an overview of technologies such as Polybase, Temoporal Tables, Columnstore Index, In memory tables, JSON support, etc. that can be utilized to build the data warehouse of the future.

SessionID: 45607

Fun Facts about Availability Groups

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Joe Hellsten

Title: Fun Facts about Availability Groups

Abstract:

Discussion regarding "Fun Facts" pertaining to AGs

Review of AGs from pre requisites to backups and lots in between. Highlighting differences from everyday DBAdom either recommended for use with or mandated by the use of AGs. For Example "max worker threads" minus 40 or Cross database ownership chaining support in AGs

SessionID: 46139

Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: SQL Server Development

Speaker: Jennifer McCown

Title: Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos

Abstract:

Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious!

SessionID: 46842

Ways SQL Server Lies and the Performance Tuning Headaches It Can Cause.

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Lance Tidwell

Title: Ways SQL Server Lies and the Performance Tuning Headaches It Can Cause.

Abstract:

Have you ever tried to tune a query or searched for a performance bottleneck just to have SQL Server lead you down a rabbit hole? In this session we will look at some common performance issues that can occur that might be masked or hidden by misleading information you get from SQL Server. We will also talk about why SQL Server gives you the information it does, and how to see past this information and find the real issues causing your performance problems.

SessionID: 48267

Performance Monitoring AlwaysOn Availability Groups

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Anthony Nocentino

Title: Performance Monitoring AlwaysOn Availability Groups

Abstract:

SessionID: 49485

History of the web and why even Javascript

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: .NET Dev

Speaker: George Mauer

Title: History of the web and why even Javascript

Abstract:

SessionID: 49700

Pester the Tester: PowerShell Bugs Beware!

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: PowerShell

Speaker: Robert Cain

Title: Pester the Tester: PowerShell Bugs Beware!

Abstract:

So you've been developing PowerShell for a while, or perhaps you're taking over maintenance of an existing set of scripts. It would be great to get extra confidence in your scripts through testing, but how? You're in luck, there's a new module in town, Pester!

Pester is a friendly testing framework designed for testing your PowerShells scripts and modules. In this session you'll be introduced to Pester. You'll see how to use Pester to uncover bugs, as well as using it for test driven development. Make your own PowerShell more robust through the use of Pester. Kill those PowerShell bugs, dead!

SessionID: 49904

SQLSaturday Jeopardy!

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: Career

Speaker: William Assaf

Title: SQLSaturday Jeopardy!

Abstract:

Do you have what it takes to be a Jeopardy Champion?

The first ever SQLSaturday Baton Rouge game show, where we will need 3 volunteers to be our SQLSaturday Jeopardy contestants, picked out of the audience at the start of the session!

SessionID: 50016

Advanced SharePoint App Development

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: SharePoint

Speaker: Keyur Vadhvana

Title: Advanced SharePoint App Development

Abstract:

Are you tired of hearing SharePoint App part working in development environment but not working production ? Do you constantly find your self changing web part details because associated parameters changed ? Then you are ready for creating app part. App part development simply allow you to make web part responsive, light weight and robust. It also provide a user some contemporary features of bootstrap and makes maintenance of the app very easy. This session will also focus belief on JS framework knockout and how developer can benefit from combining that with SharePoint.

SessionID: 50037

Scrum: The Brazilian Jiu-Jitsu of agile application development

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: IT Executive

Speaker: James Davis

Title: Scrum: The Brazilian Jiu-Jitsu of agile application development

Abstract:

Occasionally, something comes along that causes a shift in the way we do things. In modern software development, that shift is agile project methodologies with Scrum leading the way. Though Scrum, organizations learn to focus on the product and embrace change. Adopting the Scrum methodology of software development will increase team performance and decrease development time. During this session, attendees will develop an understanding of agile project management and the basic techniques of Scrum.

SessionID: 50621

Rx for Demystifying Index Tuning Decisions

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: SQL Server Administration

Speaker: Jeffry Schwartz

Title: Rx for Demystifying Index Tuning Decisions

Abstract:

Indexes are one of the most troubling and mysterious areas for DBAs and developers. Adding, deleting, or modifying them can yield dramatically positive or negative changes in query performance. The mystery is knowing how indexes need to be adjusted and what outcomes will result. This uncertainty often leads to great reluctance to eliminate indexes that are used sparingly or only because the optimal ones are missing. This leads to index proliferation, which ultimately produces inconsistent and poor query performance. Some believe that the SQL Server Database Tuning Advisor will solve all these issues, but it frequently does not. In fact, it often compounds the proliferation problem significantly. This presentation will enable a DBA to make informed decisions regarding what query and index metrics to monitor, determine how indexes are used, and devise appropriate index strategies to improve query performance through index addition, deletion, or modification.

SessionID: 51102

Rapid Prototyping with Google Spreadsheets and using your DBA budget for bacon

Back to calendar

Event Date: 06-08-2016 - Session time: 14:45:00 - Track: Web Dev

Speaker: Adam Culpepper

Title: Rapid Prototyping with Google Spreadsheets and using your DBA budget for bacon

Abstract:

I'll go through the problem (needing a quick and easy way to get a database set up to start developing), the solution (Google Spreadsheets and how to get setup for development) and then I'll show a couple examples of the projects I've developed with it. I'll also make good on my promise of using your DBA budget allocation for bacon.