Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Development

Level: Beginner

Session Code:

Date: August 01

Time: 12:15 PM - 1:15 PM

Room: 1510 (Main SQL)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: August 01

Time: 9:15 AM - 10:15 AM

Room: 1125 (Business Intelligence)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Executive

Level: Advanced

Session Code:

Date: August 01

Time: 1:30 PM - 2:30 PM

Room: 1920 (Executive)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Development

Level: Advanced

Session Code:

Date: August 01

Time: 10:30 AM - 11:30 AM

Room: 1220 (Mixed SQL)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 01

Time: 12:15 PM - 1:15 PM

Room: 1125 (Business Intelligence)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Career Foundations

Level: Beginner

Session Code:

Date: August 01

Time: 2:45 PM - 3:45 PM

Room: 1425 (IT Management)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
PowerShell

Level: Intermedia

Session Code:

Date: August 01

Time: 12:15 PM - 1:15 PM

Room: 1835 (PowerShell/Scripting)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Development

Level: Beginner

Session Code:

Date: August 01

Time: 9:15 AM - 10:15 AM

Room: 1220 (Mixed SQL)

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

Accompanying Materials:

Session Type:
Regular Session

Track:
Career Foundations

Level: Beginner

Session Code:

Date: August 01

Time: 9:15 AM - 10:15 AM

Room: 1510 (Main SQL)

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

Session Type:
Regular Session

Track:
Web/Mobile Development

Level: Beginner

Session Code:

Date: August 01

Time: 10:30 AM - 11:30 AM

Room: 1735 (Dev)

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

Session Type:
Regular Session

Track:
Web/Mobile Development

Level: Intermedia

Session Code:

Date: August 01

Time: 1:30 PM - 2:30 PM

Room: 1620 (Web)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Executive

Level: Advanced

Session Code:

Date: August 01

Time: 10:30 AM - 11:30 AM

Room: 1920 (Executive)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Advanced

Level: Advanced

Session Code:

Date: August 01

Time: 1:30 PM - 2:30 PM

Room: 1800 (Windows/Virtualization)

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

Accompanying Materials:

Session Type:
Regular Session

Track:
SQL Development

Level: Intermedia

Session Code:

Date: August 01

Time: 1:30 PM - 2:30 PM

Room: 1510 (Main SQL)

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

Accompanying Materials:

Session Type:
Regular Session

Track:
.NET

Level: Beginner

Session Code:

Date: August 01

Time: 9:15 AM - 10:15 AM

Room: 1700 (Dev 2)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Executive

Level: Beginner

Session Code:

Date: August 01

Time: 12:15 PM - 1:15 PM

Room: 1920 (Executive)

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

Session Type:
Regular Session

Track:
SQL Development

Level: Intermedia

Session Code:

Date: August 01

Time: 10:30 AM - 11:30 AM

Room: 1510 (Main SQL)

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

Accompanying Materials:

Session Type:
Regular Session

Track:
.NET

Level: Beginner

Session Code:

Date: August 01

Time: 12:15 PM - 1:15 PM

Room: 1700 (Dev 2)

Today's businesses are continually to look at the best solution for their development needs and budgets.  Being able to deliver solutions globally with a multi-shore approach has its risks and its rewards.  Let's talk about why that's important for IT leaders to evaluate using multi-shore solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
IT Manager

Level: Beginner

Session Code:

Date: August 01

Time: 9:15 AM - 10:15 AM

Room: 1425 (IT Management)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Advanced

Level: Beginner

Session Code:

Date: August 01

Time: 2:45 PM - 3:45 PM

Room: 1321 (SQL DBA)

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