Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 45
In the day-to-day operations of business, how often have we heard or even asked someone the question ourselves, “Can I get a report of this?”  Regardless of your area of expertise, reporting has become a necessity and requirement among businesses and is impacting our roles as IT professionals.  With the huge wave of trendy reporting tools and software surrounding the BI industry, many people are unaware or often overlook SSRS as a reporting solution.  In this session, we will look at the features and capabilities of SSRS, as well as supply you with the tools to begin fulfilling basic report requests.   At the conclusion of this session, you will know the difference between Report Builder and SQL Server Data Tools to determine which one is suitable for your needs.  You will also be able to create and deploy a basic report consisting of a data source, data set, a parameter and a row group.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 03

Time: 3:50 PM - 4:50 PM

Room: Room 506

SQL Server 2014 was released in early 2014. Since then, most are struggling to understand why they should upgrade. This talk will uncover 14 features in SQL 2014 that you may have not thought of. Including in-memory tables, hybrid cloud environments, BI enhancements, and others. After this talk you'll be armed with the knowledge to take full advantage of the amazing improvements in SQL Server 2014.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 03

Time: 1:30 PM - 2:30 PM

Room: Room 512

A typical day in the life of a DBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 03

Time: 10:00 AM - 11:00 AM

Room: Room 613 (WBADBA)

This session provides an overview of Agile BI strategy and approach and demonstrates how Power BI can be used to jump start BI initiatives within an organization. 
Specifically we highlight how an agile approach can address some of the following pain points:
* Long lead time on report modifications
* Waterfall delivery methodology
* Disconnect between what end users want and ask for
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 03

Time: 3:50 PM - 4:50 PM

Room: Room 514

This presentation provides a high level overview of basic Big Data and Hadoop fundamentals and concepts. It is an ideal opportunity for those considering or learning Hadoop to see Big Data in Action with examples using Microsoft Azure HDInsight, which is a 100% Apache Hadoop-based service in the cloud provided by Microsoft. We will also cover Big Data exploration and data visualization demonstrations using Microsoft products; such as PowerQuery for Excel.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 03

Time: 3:50 PM - 4:50 PM

Room: Room 501

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 03

Time: 8:50 AM - 9:50 AM

Room: Room 514

Truly automate complex monthly spreadsheet imports without monthly code changes!

Right or wrong, spreadsheets still constitute a source of data that many of us have to import every week or month. The trouble is that most spreadsheets aren’t setup to look like an SQL table. Rather, they are setup as multiple dimensions to aid in user readability and that makes column mapping and importing seriously automation resistant.

This “Black Arts” session provides an introduction to a relatively simple method to quickly, easily, and automatically import such spreadsheets and the code to do so frequently requires no changes to be used across multiple disparate spreadsheets. Creation of the necessary staging table and the related mapping is all done automatically and the monthly addition of columns is automatically handled, as well. Some of the pitfalls of more traditional import methods will also be examined.

Don’t let the “Advanced” rating of this session scare you away. It's simple!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Advanced

Session Code:

Date: October 03

Time: 1:30 PM - 2:30 PM

Room: Room 508

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 03

Time: 2:40 PM - 3:40 PM

Room: Room 512

Basics of relational database design
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 03

Time: 2:40 PM - 3:40 PM

Room: Room 613 (WBADBA)

When your database is having performance issues, you need to quickly and accurately diagnose and resolve performance issues.  Like any good detective, you need to look for clues to find “The Smoking Gun.”  We will cover various tools we have in SQL Server 2008 and above at our disposal which can help us pinpoint and resolve issues quickly, using Dynamic Management Views (DMVs), SQL Profiler and other queries.   We will discuss emergent performance issues as well as chronic issues and find ways to piece together the clues to figure out the root cause of our problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 03

Time: 3:50 PM - 4:50 PM

Room: Room 507

what it Business Intelligence, how it’s used, and why it is rapidly becoming very important to most organizations.
Covering the basics of the MS BI stack. SSIS, SSRS, SSAS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 03

Time: 1:30 PM - 2:30 PM

Room: Room 613 (WBADBA)

You're looking to protect your SQL instance from a machine failure.  Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides.  Let's learn what a cluster is and why it might be the right thing for you.  We'll explore the system, network, storage and database administration sides of the equation.  And, when it's all said and done we'll even have built a SQL clustered instance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 03

Time: 3:50 PM - 4:50 PM

Room: Room 508

SQL Server Analysis Services has become a key base of Business Intelligence integration into business decision making.  As DBA’s sometimes we are forced to change over to new coding standards.  MDX is one of the base languages used when reporting off of cubes that are built using the multi-dimensional model.  The goal of this class will be to help beginners convert from using T-SQL to understanding the basics when writing MDX queries from scratch.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 03

Time: 1:30 PM - 2:30 PM

Room: Room 506

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 03

Time: 8:50 AM - 9:50 AM

Room: Room 512

The key to becoming a great DBA is time.  The best way to regain some time is by spending less time doing the daily mundane work.  Let this mundane effort work autonomously.  We will introduce the basics in monitoring and maintenance.  The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 03

Time: 10:00 AM - 11:00 AM

Room: Room 512

John knows everything and goes out of his way to correct you at every turn.  Mary is agreeable to a fault and just placates everyone.  Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 03

Time: 1:30 PM - 2:30 PM

Room: Room 501

Join Dell for a lunchtime session about their products and services
Food is not permitted in the classrooms.  Please eat lunch in the gallery first and then join dell afterwards for this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 03

Time: 12:50 PM - 1:50 PM

Room: Room 507

XP_CmdShell is a powerful tool that can greatly simplify the life of DBAs.
You can quickly and easily write full ETL systems, up/down-load FTP files, call PowerShell scripts to interrogate the status of hard-disks across the enterprise with nary a 3rd party tool in sight, and much more. 
And it’s all done under the control a scheduled job system that you already know and that keeps its own logs.
Yet, you'll find millions of people that agree that disabling xp_CmdShell is a "best practice". Some even say that it should never be used. Why? Disabling it supposedly decreases the system "surface area" of possible attack and never using it supposedly solves the problem of someone elevating their privileges with it.
Well, surprise! Disabling xp_CmdShell doesn't actually solve any of those problems.  In fact, disabling it may actually hurt security.
Come to this session to find out why turning off xp_CmdShell may be a "worst practice" and how to allow individuals/applications to run it safely.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 03

Time: 10:00 AM - 11:00 AM

Room: Room 501

One of the of the most under-utilized management features of SQL Server is SQL Agent Multi-Server Administration, which allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. This allows you to have consistency with your SQL Agent jobs by managing them in a single location. You’ll learn about the benefits, drawbacks, workarounds, and underlying objects behind this technology. You’ll discover how to monitor job execution status and handle the security implications of the master-target relationship. Native Yinzer and SQL Server MVP Mike Hillwig will show you how to to deploy this simple, yet powerful feature right out of the box without writing a single line of additional code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 03

Time: 3:50 PM - 4:50 PM

Room: Room 512

Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! 

Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. In this session, we’ll be dispelling these misconceptions and demonstrating how dynamic SQL can become a part of every DBA’s tool kit.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 03

Time: 10:00 AM - 11:00 AM

Room: Room 507

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