sqlsathistory

Nr: 423

Back to Main list

SQLSaturday #423 - Baton Rouge 2015

Start Time (24h) Speaker Track Title
09:15:00 Jennifer McCown SQL Development Beginning T-SQL
09:15:00 Michael Viron IT Manager Fundamentals of Disaster Planning Recovery
09:15:00 Daniel Janik DBA Advanced Locking, Blocking, Latching. OH MY!
09:15:00 Mike Robbins PowerShell PS C:\gt; Get-Started -With 'PowerShell for SQL Server'
09:15:00 Steve Jones Career Foundations Branding Yourself for a Dream Job
09:15:00 Ike Ellis Business Intelligence 60 Reporting Tips in 60 Minutes
09:15:00 Scott Shaw Career Foundations So You Want a Job in Big Data?
09:15:00 Jeremy Abbott .NET Currying in a Hurry (Functional Programming with F#)
09:15:00 Andrew Petersen .NET Internet of Things
09:15:00 Case Ahr .NET Essentials of Modern Web Application Development
09:15:00 Cody Gros SharePoint What is the right SharePoint Cloud Strategy for my Business?
09:15:00 Dave Baxter Executive The Changing Role of IT: Cloud Strategy Panel
10:30:00 Brandon Cornett Web/Mobile Development Building Cross Platform Mobile Apps with Xamarin
10:30:00 Christine Assaf IT Manager Interview Tips for Hiring Managers
10:30:00 Steven Rachui Windows Server/Virtualization Managing your mobile workforce with ConfigMgr and Intune
10:30:00 Daniel Janik SQL Development Analyze your query plan like a Microsoft Engineer!
10:30:00 Ryan Richard Web/Mobile Development Intro to AngularJS: Creating a Simple Single Page Application
10:30:00 Scott Shaw Mixed Track Navigating the Hadoop Stack
10:30:00 Thomas LaRock SQL Development Database Design: Size DOES Matter
10:30:00 Ryan Rousseau .NET Write Scripts with C# and scriptcs
10:30:00 Jeremy Cronan .NET Programming with Patterns
10:30:00 Jameson Bozeman SharePoint Leveraging SharePoint Search and Client Side Rendering
10:30:00 Patrick Thompson Executive Business Analytics for Cadence Management
10:30:00 Stacy Vicknair Career Foundations Improving your communication and leadership through Toastmasters
10:30:00 Jim Murphy SQL Development Mission Possible: Interactive Performance Troubleshooting - T-SQL
12:15:00 Christine Assaf Career Foundations Mastering your Resume Interview: Tips to Get Hired
12:15:00 Stacey Hopkins Business Intelligence Back to Basics - What is BI?
12:15:00 Sven Aelterman Mixed Track SQL Server Optimization for SharePoint
12:15:00 Matthew Borel .NET JS Approaches for the .NET Developer
12:15:00 Karen Lopez SQL Development $#*! Your Database Says About Me
12:15:00 Seth Valdetero Web/Mobile Development Ensuring Quality Mobile Apps with Testing and Crash Reporting
12:15:00 Nancy Hidy Wilson SQL DBA Foundations Managing SQL Server in the Enterprise with TLAs
12:15:00 Scott Swanberg SQL DBA Foundations Exploring Your SQL Server Databases with T-SQL
12:15:00 Travis Overmier .NET Date and Time concepts, gotchas, and best practices in .NET
12:15:00 Lyle Hutson Mixed Track What to expect from QA
12:15:00 Amy Herold PowerShell Beginning Automation with Powershell
12:15:00 Rusty Frioux Executive Dashboards for Everyone with Microsoft Power BI and Excel
12:15:00 David Pechon Windows Server/Virtualization Virtualize all the things!
13:30:00 Brian Rigsby Mixed Track The Binary Language of Music
13:30:00 Gene Webb Business Intelligence Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner
13:30:00 Michael Viron Mixed Track Startup 101: Lessons Learned
13:30:00 Steven Rachui DBA Advanced Configuration Manager and the SQL Broker Service - DRS
13:30:00 William E Pearson III Business Intelligence Possible Musics: SSAS Multidimensional vs Tabular
13:30:00 Mike Robbins PowerShell PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'
13:30:00 Steve Jones SQL Development Continuous Integration for Databases
13:30:00 Jamey Johnston DBA Advanced Row Level Security in Azure and SQL 2016 Databases using Hierarchies
13:30:00 William Assaf SQL DBA Foundations SQL Server Reporting Services (SSRS) 101
13:30:00 Alex Clavelle Web/Mobile Development Building rest and websocket APIs with Sails.js
13:30:00 Ross Murray .NET The future of C#
13:30:00 Mike Huguet .NET Staying Afloat in the .NET Asynchronous Ocean
13:30:00 Tim Goedeke Executive Aligning IT and the Business
14:45:00 Wes Springob Business Intelligence Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
14:45:00 Sven Aelterman SQL Development Gentle Introduction to T-SQL Window Functions
14:45:00 Robert Canzonire DBA Advanced Demystifying The Transaction Log
14:45:00 David Pechon Windows Server/Virtualization Spinning Brown Donuts: Why Storage Still Counts.
14:45:00 Karen Lopez SQL Development The Ticking Timebombs in Your Databases
14:45:00 Thomas LeBlanc Business Intelligence Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube
14:45:00 Calvin Fabre Career Foundations Beauty and the Bits: Why both Left and Right Brain MUST be Engaged
14:45:00 James Alt Web/Mobile Development Wearables: Android Wear and Apple Watch in C#
14:45:00 Raghu Dodda Web/Mobile Development Prefer Composition over Inheritance - What exactly does that mean?
14:45:00 Shannon Duplessis Executive Managing Customer Expectations - Are you winning or losing?
14:45:00 George Mauer Mixed Track Teaching programming
14:45:00 Patrick LeBlanc Business Intelligence Introduction to DataZen
14:45:00 Mike Huguet PowerShell Sharing and Reuse with PowerShell Advanced Functions and Modules
14:45:00 Adam Culpepper Web/Mobile Development jQuery Animation Techniques for Beginners

SessionID: 16509

Beginning T-SQL

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: SQL Development

Speaker: Jennifer McCown

Title: Beginning T-SQL

Abstract:

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

SessionID: 21254

Fundamentals of Disaster Planning Recovery

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: IT Manager

Speaker: Michael Viron

Title: Fundamentals of Disaster Planning Recovery

Abstract:

In this session, we'll cover the basics of Disaster Planning and key operational items to consider when establishing software systems. We'll cover terms and their importance as well as commonly used software and hardware techniques for disaster planning purposes.

SessionID: 35635

Locking, Blocking, Latching. OH MY!

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: DBA Advanced

Speaker: Daniel Janik

Title: Locking, Blocking, Latching. OH MY!

Abstract:

Have you run into problems with blocking or locking? Are your transactions stepping on each other? Do you know what the difference between a latch and a lock is? Is your design optimal? This session is a hands-on, technical dive into SQL Server's isolation levels and locking mechanics. Whether you're a developer or DBA this session is for you. We will cover the various issues that a developer or DBA may run into and how to resolve them. Expect this session to be interactive, so come prepared.

SessionID: 35789

PS C:\gt; Get-Started -With 'PowerShell for SQL Server'

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PS C:\gt; Get-Started -With 'PowerShell for SQL Server'

Abstract:

What’s this thing called PowerShell? Why should I care? And what can it do for me? During this beginner level session, PowerShell MVP and scripting games winner Mike F Robbins will be covering all of those questions and many more that are all too common among PowerShell noobs such as: How do I figure out what the commands are? And how do I extend PowerShell’s functionality to manage products like SQL Server? The first beta of PowerShell was released 10 years ago and with it now being part of Microsoft’s common engineering criteria, it’s not going away any time soon so what are you waiting for?

SessionID: 36195

Branding Yourself for a Dream Job

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: Career Foundations

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

SessionID: 36335

60 Reporting Tips in 60 Minutes

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: Business Intelligence

Speaker: Ike Ellis

Title: 60 Reporting Tips in 60 Minutes

Abstract:

This session will be rapid fire, fast-paced experience, focusing on all sorts of reporting tips. This session is for the YouTube generation. Do you have a short attention span? Are 15-second commercials too long to sit through? Do you want the very best reporting tips collected from watching hundreds of videos and reading a library of books, plus years of reporting experience? Come to this session. We have tips on Excel, data visualization, interviewing stake holders, organizing reporting teams, securing reports, consolidation, dashboard design, SSRS, SSIS, and T-SQL authoring. You're guaranteed to learn something actionable that will make you more effective in your career.

SessionID: 36438

So You Want a Job in Big Data?

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: Career Foundations

Speaker: Scott Shaw

Title: So You Want a Job in Big Data?

Abstract:

Have you considered expanding your current skill set and seeking a long-term career in Big Data but don't know what to learn or where to start? Do I have to learn Java, Scala, Python? Do I have to become a Unix guru or get a Ph.D in mathematics? This session will show you the different routes to a new Big Data career and provide you the resources and toolsets you'll need to know to get yourself started.

SessionID: 36803

Currying in a Hurry (Functional Programming with F#)

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: .NET

Speaker: Jeremy Abbott

Title: Currying in a Hurry (Functional Programming with F#)

Abstract:

Most of us spend our days coding in object oriented (OO) languages like C#, Java or C++. By looking at other programing paradigms we have an opportunity to reason about problems in different ways, and gain a deeper understanding of what's in our OO toolkit. This talk takes an idiomatic approach to functional programming (FP) using F#. At the end of the talk you'll have a better idea of what FP is, know what "currying" is, and have the information you need to get started with F#.

SessionID: 37347

Internet of Things

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: .NET

Speaker: Andrew Petersen

Title: Internet of Things

Abstract:

It is predicted that 4.9 billion things will be connected to the Internet in 2015 and is expected to increase to 25 billion by 2020. With this growing number of devices connected to the Internet, we will no longer be in a world of stand alone mobile apps and websites. We need to start thinking about the Internet of Things.

In this talk, we will cover statics of what is coming, how to stay secure, along with a demonstration of the integration of hardware and software.

SessionID: 37618

Essentials of Modern Web Application Development

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: .NET

Speaker: Case Ahr

Title: Essentials of Modern Web Application Development

Abstract:

You're interested in becoming a professional web application developer. You have probably already learned some of the basics, but what do you really, truly need to transform from basic website designer into a full-powered, highly sought-after web application developer? This session will highlight the absolutely necessary skills and that tools to help you. I will also be intoducing Visual Studio Code.

SessionID: 37837

What is the right SharePoint Cloud Strategy for my Business?

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: SharePoint

Speaker: Cody Gros

Title: What is the right SharePoint Cloud Strategy for my Business?

Abstract:

Differences between and benefits of SharePoint Online, On-Premise and Azure IaaS. What's right for you?

SessionID: 39040

The Changing Role of IT: Cloud Strategy Panel

Back to calendar

Event Date: 01-08-2015 - Session time: 09:15:00 - Track: Executive

Speaker: Dave Baxter

Title: The Changing Role of IT: Cloud Strategy Panel

Abstract:

A panel of regional CIO's gathers to discuss questions for modern IT Leadership. This panel discussion will be led by Sparkhound Vice President Dave Baxter, joined by Stevie Toups – Turner Industries, Bennett Cheramie – General Health, Jeremy Turner – EPIC Piping, Lee Washington – ABC Financial and Patrick Thompson - Sparkhound.

SessionID: 10177

Building Cross Platform Mobile Apps with Xamarin

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: Web/Mobile Development

Speaker: Brandon Cornett

Title: Building Cross Platform Mobile Apps with Xamarin

Abstract:

In this talk, we'll start from scratch and create a cross platform iOS and Android app using Xamarin. I'll be showing you how to share your code between platforms, as well as how to share data transfer objects with your ASP.NET Web API back end.

SessionID: 11639

Interview Tips for Hiring Managers

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: IT Manager

Speaker: Christine Assaf

Title: Interview Tips for Hiring Managers

Abstract:

If you are a Manager needing some interviewing education - this is your course! This session focuses on basic interviewing guidelines, including: preliminary interviews, types of testing, secondary or follow-up interviews, while keeping in mind EEO guidelines and best practices. Learn tips and tricks of the trade from an HR guru who is "in the trenches."

SessionID: 25816

Managing your mobile workforce with ConfigMgr and Intune

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: Windows Server/Virtualization

Speaker: Steven Rachui

Title: Managing your mobile workforce with ConfigMgr and Intune

Abstract:

Managing the mobile workforce is a continued challenge for IT administrators. This session will explore the options for management available by integrating System Center Configuration Manager with Microsoft Intune. This session will walk through the configurations necessary to configure the integration and also management scenarios including software deployment options available.

SessionID: 35636

Analyze your query plan like a Microsoft Engineer!

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: SQL Development

Speaker: Daniel Janik

Title: Analyze your query plan like a Microsoft Engineer!

Abstract:

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate.

SessionID: 36314

Intro to AngularJS: Creating a Simple Single Page Application

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: Web/Mobile Development

Speaker: Ryan Richard

Title: Intro to AngularJS: Creating a Simple Single Page Application

Abstract:

This session will present an introduction to the AngularJS JavaScript framework. In order to present the main concepts of AngularJS, we will review a simple Single Page Application (SPA) constructed with the framework. A basic knowledge of HTML and JavaScript will be helpful in understanding the concepts presented in this session.

SessionID: 36439

Navigating the Hadoop Stack

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: Mixed Track

Speaker: Scott Shaw

Title: Navigating the Hadoop Stack

Abstract:

Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We'll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.

SessionID: 36725

Database Design: Size DOES Matter

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: SQL Development

Speaker: Thomas LaRock

Title: Database Design: Size DOES Matter

Abstract:

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.

SessionID: 36888

Write Scripts with C# and scriptcs

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: .NET

Speaker: Ryan Rousseau

Title: Write Scripts with C# and scriptcs

Abstract:

In this session, we will introduce scriptcs, an opensource project that makes it easy to write and execute C# with a simple text editor. We will cover some features unique to scriptcs including modules, script packs, and script libraries. We will also highlight some interesting ways that scriptcs is being used by other projects.

SessionID: 37596

Programming with Patterns

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: .NET

Speaker: Jeremy Cronan

Title: Programming with Patterns

Abstract:

There are many types of Patterns available for programming anything from Windows to Web Developement to anything. Come learn some patterns and when best to use them.

SessionID: 37838

Leveraging SharePoint Search and Client Side Rendering

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: SharePoint

Speaker: Jameson Bozeman

Title: Leveraging SharePoint Search and Client Side Rendering

Abstract:

Teaching users at all technical levels how to use SharePoint 2013’s search webparts to display content from any location with custom visuals. This session will also discuss the strengths and limitations of search along with best practices for implementing search solutions.

SessionID: 37856

Business Analytics for Cadence Management

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: 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.

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. Sparkhound Analytics Strategist Rusty Frioux will also dive into specific business problems companies are solving through analytics and field your questions.

SessionID: 37889

Improving your communication and leadership through Toastmasters

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: Career Foundations

Speaker: Stacy Vicknair

Title: Improving your communication and leadership through Toastmasters

Abstract:

Since 1924, Toastmasters International has been recognized as the leading organization dedicated to communication and

leadership skill development. Through its worldwide network of clubs, each week Toastmasters helps more than a quarter million men and women of every ethnicity, education level and profession build their competence in communication so they can gain the confidence to lead others.

By regularly giving speeches, gaining feedback, leading teams and guiding others to achieve their goals in a supportive atmosphere, leaders emerge. They learn to tell their stories. They listen and answer. They plan and lead. They give feedback — and accept it. They find their path to leadership.

In this session we will demonstrate how a Toastmasters meeting operates, answer your questions about how toastmasters can improve your career and tell you where you can find a club that fits your schedule. Join us and find your path!

SessionID: 38642

Mission Possible: Interactive Performance Troubleshooting - T-SQL

Back to calendar

Event Date: 01-08-2015 - Session time: 10:30:00 - Track: SQL Development

Speaker: Jim Murphy

Title: Mission Possible: Interactive Performance Troubleshooting - T-SQL

Abstract:

Performance troubleshooting is detective work. We'll have a lab system being assaulted by PowerShell scripts (to simulate live users), and simulated performance problems like those that can make your on-call cell phone ring too much! Do you think you have what it takes to find these "needle in the haystack" issues and resolve them quickly? This will be a highly interactive session where we will locate the rogue queries together, work through solutions, implement them and measure the results. In this episode we'll focus primarily on poor TSQL coding as a common underlying problem and all will walk away with much better troubleshooting skills and an upgraded knowledge of performance tuning!

SessionID: 11637

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: Career Foundations

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

Back to Basics - What is BI?

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: Business Intelligence

Speaker: Stacey Hopkins

Title: Back to Basics - What is BI?

Abstract:

An overview of the various niches within the Business Intelligence area along with a brief look at some of the tools used

SessionID: 35968

SQL Server Optimization for SharePoint

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: Mixed Track

Speaker: Sven Aelterman

Title: SQL Server Optimization for SharePoint

Abstract:

DBAs know that SharePoint just doesn't play nice with SQL Server. SharePoint administrators know that DBAs just don't understand SharePoint. This session will show hands-on how to get a SQL Server instance set up effectively for SharePoint 2013. It's not black magic and it doesn't involve undocumented trace flags. Maybe DBAs and SharePoint admins can't get along in social circles, but at least you'll be able to cooperate after this session.

SessionID: 36122

JS Approaches for the .NET Developer

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: .NET

Speaker: Matthew Borel

Title: JS Approaches for the .NET Developer

Abstract:

From SPA's to sites requiring a minimal front-end, we'll explore a few different approaches for setting up, bundling, and writing JavaScript in a way that fits the demands of your specific project. The session will be delivered through examples using Visual Studio, MVC, and AngularJS, but the overall analysis of pros/cons in front-end heavy sites and project organization can be applied in ways that are framework agnostic.

SessionID: 36735

$#*! Your Database Says About Me

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: SQL Development

Speaker: Karen Lopez

Title: $#*! Your Database Says About Me

Abstract:

Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions-- using real-life evidence of her own data in your systems.

SessionID: 37591

Ensuring Quality Mobile Apps with Testing and Crash Reporting

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: Web/Mobile Development

Speaker: Seth Valdetero

Title: Ensuring Quality Mobile Apps with Testing and Crash Reporting

Abstract:

In this session, we will be testing a cross-platform mobile app with unit tests and UI Tests and then incorporate crash reporting / analytics. The cross platform app will be for iOS, Android, and Windows Phone written in C# using Xamarin.

SessionID: 37601

Managing SQL Server in the Enterprise with TLAs

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: SQL DBA Foundations

Speaker: Nancy Hidy Wilson

Title: Managing SQL Server in the Enterprise with TLAs

Abstract:

Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server features designed to make a DBA’s life easier. If you aren’t using CMS (Central Management Server), PBM (Policy Based Management), and EPM (Enterprise Policy Management Framework) – come learn what they are and the potential benefits in using them to manage your environment - from SQL 2000 to SQL 2014!

SessionID: 37669

Exploring Your SQL Server Databases with T-SQL

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: SQL DBA Foundations

Speaker: Scott Swanberg

Title: Exploring Your SQL Server Databases with T-SQL

Abstract:

As a DBA and performance tuning consultant, for Ambient Consulting in Minneapolis, I'm often asked to analyze performance issues on a SQL Server instance with which I'm unfamiliar. It can be a daunting task. Let's face it, most of the time companies do not have good documentation about their databases. Or if they do, it is outdated, or it takes a few days to locate and retrieve it.

In this present, I share a set of basic scripts that I've developed, over the years, which mine the metadata in the various system functions, stored procedures, tables, catalog views, and dynamic management views, Together, they reveal all the secrets of the databases on the instance, their size, file locations, and their design, including columns, data types, defaults, keys and indexes. You will walk away with 40 scripts to reverse engineer a database

SessionID: 37679

Date and Time concepts, gotchas, and best practices in .NET

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: .NET

Speaker: Travis Overmier

Title: Date and Time concepts, gotchas, and best practices in .NET

Abstract:

Explores the usage of the DateTime support built-in to .NET and date and time storage concepts in general. If you have ever wondered "How should I store this date and time?", "What is the difference between a time offset and a time zone?", or even "What does UTC mean anyway?" then this session is for you.

SessionID: 37700

What to expect from QA

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: Mixed Track

Speaker: Lyle Hutson

Title: What to expect from QA

Abstract:

This is a Beginner/Intermediate level discussion. I will discuss some of the basics about what QA is capable of. This will all be based around the waterfall methodology. I will demonstrate test cases, bug tracking, and discuss building a test matrix and its effectiveness with multiple checkpoints throughout a given testing session.

SessionID: 37850

Beginning Automation with Powershell

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15: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: 37855

Dashboards for Everyone with Microsoft Power BI and Excel

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: Executive

Speaker: Rusty Frioux

Title: Dashboards for Everyone with Microsoft Power BI and Excel

Abstract:

Microsoft Excel – and their next generation cloud toolset Power BI - are the best kept secrets in business intelligence and analytics software. Most of what executives and business analysts want from pricey analytics platforms can be accomplished immediately using Microsoft tools already installed on their desktops – including drag and drop visualization, mapping, business modeling, connecting to cloud data sources, and single-pane-of-glass dashboards. Join Rusty Frioux, Sparkhound’s Analytics Strategist, as he creates a working dashboard in less than one hour from real live data sources using Microsoft’s current self-service business intelligence tools including Excel, Power Pivot, Power Query, Power View, and Power BI.

SessionID: 39098

Virtualize all the things!

Back to calendar

Event Date: 01-08-2015 - Session time: 12:15:00 - Track: Windows Server/Virtualization

Speaker: David Pechon

Title: Virtualize all the things!

Abstract:

Virtualization has pretty much become the de facto standard in datacenters today. However, there are a few holdouts as people aren’t confident that today’s modern hypervisors can give their applications the performance they need. As someone who’s evangelized virtualization for nearly a decade, David Pechon will show why there’s no reason why you shouldn’t virtualize.

SessionID: 10790

The Binary Language of Music

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: Mixed Track

Speaker: Brian Rigsby

Title: The Binary Language of Music

Abstract:

Take a fascinating journey into how our minds work and discover how the binary and mathematical patterns found in music can be used to learn the underlying language of music and be applied to other disciplines.

SessionID: 14459

Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Gene Webb

Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Abstract:

What is master data management and why should I care about it?

What does the master data services components of SQL Server do for me? Overview of all features of MDS How to build out an MDM subject area How to use MDS for reference data management How to use MDS for data quality How to use MDS with a data warehouse to improve data quality

SessionID: 21253

Startup 101: Lessons Learned

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: Mixed Track

Speaker: Michael Viron

Title: Startup 101: Lessons Learned

Abstract:

In this session we'll cover key lessons learned from both creating new divisions, product launches, and starting new organizations. These can help speed up the initial startup phases, decrease expenses, and build a successful team-based environment.

SessionID: 25817

Configuration Manager and the SQL Broker Service - DRS

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: DBA Advanced

Speaker: Steven Rachui

Title: Configuration Manager and the SQL Broker Service - DRS

Abstract:

When installed in a hierarchy Configuration Manager leverages the SQL Broker service to replicate data between the various sites. Understanding how Configuration Manager leverages SQL Broker and how to troubleshoot when things go wrong is critical to maintain proper hierarchy function. This session will describe how Configuration Manager replication works along with demonstrations that will highlight replication processing. We will also work through troubleshooting techniques that can be used from easiest to more complex.

SessionID: 28153

Possible Musics: SSAS Multidimensional vs Tabular

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: William E Pearson III

Title: Possible Musics: SSAS Multidimensional vs Tabular

Abstract:

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with SSAS 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SQL Server MVP and SSAS Maestro Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing examples to illustrate approaches for given scenarios.

SessionID: 35790

PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'

Abstract:

SessionID: 36194

Continuous Integration for Databases

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: SQL Development

Speaker: Steve Jones

Title: Continuous Integration for Databases

Abstract:

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.

SessionID: 36920

Row Level Security in Azure and SQL 2016 Databases using Hierarchies

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: DBA Advanced

Speaker: Jamey Johnston

Title: Row Level Security in Azure and SQL 2016 Databases using Hierarchies

Abstract:

This session will show how an organizational asset hierarchy is leveraged together to provide predicate-based Row Level Security on tables in an Azure SQL Database without application changes.

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 an Azure SQL Database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Excel.

SessionID: 36973

SQL Server Reporting Services (SSRS) 101

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: SQL DBA Foundations

Speaker: William Assaf

Title: SQL Server Reporting Services (SSRS) 101

Abstract:

Ground floor introduction to the tools and best practices surrounding SQL Server’s built-in web-based, enterprise-level reporting engine. We'll start with what SSRS is, what you'll use it for, show a live demo of sample demonstration, and give top tips to know when developing your first reports.

SessionID: 37125

Building rest and websocket APIs with Sails.js

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: Web/Mobile Development

Speaker: Alex Clavelle

Title: Building rest and websocket APIs with Sails.js

Abstract:

Sails is a nodejs mvc framework with express and socket.io integration. I will demonstrate the basics of building an asynchronous database driven application with sails and socket.io. I will also demonstrate the benefits of using some more advanced concepts such as bluebird promises.

SessionID: 37586

The future of C#

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: .NET

Speaker: Ross Murray

Title: The future of C#

Abstract:

C# 6 is out this year, but what's after that? We'll take a look at the features the language design team is working on for C# 7, such as pattern matching and record types. We'll dive deep into how these language features work, what impact they'll have on your code, and what this means for the direction of C# and programming in general.

SessionID: 37711

Staying Afloat in the .NET Asynchronous Ocean

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: .NET

Speaker: Mike Huguet

Title: Staying Afloat in the .NET Asynchronous Ocean

Abstract:

In this session we will walk through the history of Asynchronous programming in .NET and discuss the pros and cons of the wide range of options that are available in the framework. Many examples will be shown with a focus on the modern options, such as the Task Parallel Library and the async keyword. The goal of this session is for you to gain a better understanding of when to use certain options and when not.

SessionID: 37858

Aligning IT and the Business

Back to calendar

Event Date: 01-08-2015 - Session time: 13:30:00 - Track: Executive

Speaker: Tim Goedeke

Title: Aligning IT and the Business

Abstract:

No matter how fast business moves, there’s no substitute for a smart, carefully crafted IT plan that is aligned with your business strategy. Join Sparkhound Principal Consultant Tim Goedeke as he discusses his experiences as a fractional CIO, challenged with helping IT fulfill its role as a strategic business partner for speed to market, product / service differentiation and superior end-user experience delivery. Are you ready to eliminate perceptions of IT as a cost center, and paint the vision of IT as a business driver?

SessionID: 24820

Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Wes Springob

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract:

As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

SessionID: 35967

Gentle Introduction to T-SQL Window Functions

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: SQL Development

Speaker: Sven Aelterman

Title: Gentle Introduction to T-SQL Window Functions

Abstract:

Since their infancy in SQL Server 2005 and their growth spurt in SQL Server 2012, T-SQL window functions have provided new ways to solve fairly common end-user query requests. However, their successful use requires thinking a little differently about sets than you're used to. In this session, you will explore the basic concepts of ordering, partitioning and framing. Everything will be demonstrated with easy to follow examples that you will be able to adapt quickly to your query needs.

SessionID: 36028

Demystifying The Transaction Log

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: DBA Advanced

Speaker: Robert Canzonire

Title: Demystifying The Transaction Log

Abstract:

This session will demystify the transaction log, including how to manage and optimize their performance. It is very important to understand the usage of the transaction log. The activity of transaction log for SQL Server will allow you to ensure that the operations SQL Server is successful. I hope that after the session you will have a better understanding of the transaction log and you can apply these techniques at your work.

SessionID: 36495

Spinning Brown Donuts: Why Storage Still Counts.

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Windows Server/Virtualization

Speaker: David Pechon

Title: Spinning Brown Donuts: Why Storage Still Counts.

Abstract:

Storage, next to server hardware, is pretty commoditized and probably the least exciting thing in your datacenter. However, not properly assessing your storage needs and requirements can be the difference between a great app or resume generating event. This session will cover topics such as: Why you may not need all flash, SAN is not just NAS spelled backwards, Leveraging cloud storage, Why RAID is not a sound backup solution, and cutting through the marketing to make sense of it all.

SessionID: 36734

The Ticking Timebombs in Your Databases

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: SQL Development

Speaker: Karen Lopez

Title: The Ticking Timebombs in Your Databases

Abstract:

You've worked hard to build the best systems you can, and then one night you get called in to resolve a production incident. As you peer into your database, you see it: something so bad it sends shivers down your spine. How did that get in there? Who did that? Why? And how do you fix it?

In this session, we look at the workarounds, technical debt and clever designs that can cause you grief when you least expect it. We will also include perfectly fine features that can haunt you later. We will discuss how these things happen and give you tools to identify the ones that cause the most pain.

Join us: you'll keep your job, have happier users and get more rest.

SessionID: 36949

Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Thomas LeBlanc

Title: Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube

Abstract:

You will leave this session with your brain firing on all cylinders to create cool dashboards with color enhanced backgrounds to signal to users where they should focus their efforts. The new Timeline object makes you breathe a sigh of relief about report filtering by dates. Slicers will give you clues of what data is present. Indicators, data-driven formatting, and spark lines focus attention on what is important to the viewed data set.

SessionID: 37086

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

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Career Foundations

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

Wearables: Android Wear and Apple Watch in C#

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Web/Mobile Development

Speaker: James Alt

Title: Wearables: Android Wear and Apple Watch in C#

Abstract:

Developing for Android Wear and the Apple Watch in C# using the Xamarin Platform. We'll start from scratch and build up to completely functioning wearable applications over the course of the session along with tips and tricks to help you get the most out of your wearable app.

SessionID: 37706

Prefer Composition over Inheritance - What exactly does that mean?

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Web/Mobile Development

Speaker: Raghu Dodda

Title: Prefer Composition over Inheritance - What exactly does that mean?

Abstract:

If you heard the axiom prefer composition over inheritance, this talk will demystify what exactly that means. Examples in C# and JavaScript will be used to contrast the two ideas as we apply them to class design.

SessionID: 37854

Managing Customer Expectations - Are you winning or losing?

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Executive

Speaker: Shannon Duplessis

Title: Managing Customer Expectations - Are you winning or losing?

Abstract:

Excellent customer service and high customer satisfaction must start with understanding customer expectations. Whether your customers are internal (i.e., HR, Finance, Marketing business users) or external, you need to know who your customers are and what their goals are before launching any business initiative. If not, you’ll never win.

Pulling from her industry experience in Government, Legal, Education and Healthcare, Strategic Engagement Manager Shannon Duplessis will use the Sparkhound Assessment Model (SAM) approach to show how to assess client needs, agree upon desired expectations and results, and then develop the right KPIs (Key Performance Indicators) to measure success.

SessionID: 37859

Teaching programming

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Mixed Track

Speaker: George Mauer

Title: Teaching programming

Abstract:

Tips, tricks, and lessons learned in eight months spent teaching complete beginners how to program with Operation Spark. Includes a discussion of curriculum building, course structure, and learning resources galore.

SessionID: 38766

Introduction to DataZen

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Patrick LeBlanc

Title: Introduction to DataZen

Abstract:

This is a must attend session for every data professional. Join me as I provide an overview of DataZen, Microsofts new acquired on-premises mobile BI solution. Datazen is optimized for SQL Server and designed to enable rapid development and publishing of business intelligence in a way that delivers premium user experience on any device. In this session I will provide an overview of DataZen, discuss its key features, provide an architectural overview and final demonstrate how to author and publish dashboards.

SessionID: 39211

Sharing and Reuse with PowerShell Advanced Functions and Modules

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: PowerShell

Speaker: Mike Huguet

Title: Sharing and Reuse with PowerShell Advanced Functions and Modules

Abstract:

Many people have dabbled in PowerShell or have solid experience leveraging it in the workplace, but do you have an understanding of how to simplify future use of your scripts or to fully share your scripts with others on your team or across the organization? In this session we will create advanced functions, convert them to cmdlets, create our own module and then use them. Along the way, we will also learn how to support the pipeline, properly document and leverage parameter options. This is an intermediate/advanced session that assumes you are comfortable with PowerShell and have at least a basic understanding of creating functions.

SessionID: 8954

jQuery Animation Techniques for Beginners

Back to calendar

Event Date: 01-08-2015 - Session time: 14:45:00 - Track: Web/Mobile Development

Speaker: Adam Culpepper

Title: jQuery Animation Techniques for Beginners

Abstract:

I'll be covering examples and sections from my book on how to animate HTML elements on your site using jQuery 2.0 and it's animation techniques