Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 38
There's a lot of general verbiage and API documentation about Service Broker, but how do you fit the queues, services, contracts, and conversations together to actually make something that will work reliably in production?  In this session you'll follow the architecture, design, implementation, and troubleshooting of a simple but production-tested Service Broker messaging framework and get a battlefield-level view of the pitfalls and the payoffs involved in Service Broker development.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 03

Time: 4:00 PM - 5:15 PM

Room: ARP 116

A deep-dive into what is sure to become a very critical feature of SQL Server 2016. We'll walk through some use-cases for the technology, and discuss why this kind of technology is needed - and how it can make a DBA's life easier - including making some regulatory compliance easier. We'll then walk though a typical implementation scenario live, and walk though a few demos and practical examples. 
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 03

Time: 2:30 PM - 3:45 PM

Room: ARP 210

We have lots and lots of data. Typically when it comes to data analysis we have to know what our measures of success are before we design our BI. These are typically manifested by competency, or domain driven KPI's but what if those metrics don't actually measure success at all?

In this talk we will be discussing how to leverage azure machine learning to answer questions in your organization about success and how to find the KPI's that really matter and drive results. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 03

Time: 2:30 PM - 3:45 PM

Room: ARP 212

Developers today face an onslaught of data storage applications. Various NoSQL offerings promise performance, scalability and easy development on commodity boxes. How does one get these benefits in SQL Server? What does a SQL Server application built today using the newest features and best practices look like? This session will discuss client applications, new SQL Server features and application architectures to support a modern, high-throughput transaction environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 03

Time: 1:00 PM - 2:15 PM

Room: ARP 224

What is cardinality estimation and how you can use it to your advantage. In this session we'll cover the mechanics behind cardinality estimation and why it is so very critical to query performance. We will also be discussing some of the changes that were made to the estimator for SQL Server 2014.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 03

Time: 1:00 PM - 2:15 PM

Room: ARP 114

SQL Server has always been the foundation of the Microsoft Business Intelligence (BI) story. However, SharePoint has quickly moved into being the presentation layer for this important data. In this session, you will learn the many different options for combining SharePoint and SQL, the location of all the different pieces, how these pieces communicate, some licensing hints, and how Kerberos helps tie it all together.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 03

Time: 4:00 PM - 5:15 PM

Room: ARP 316

DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I'll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 03

Time: 4:00 PM - 5:15 PM

Room: ARP 224

If you or your users frequently run large, sweeping reporting-style queries against your OLTP system, you know the pain of having your system grinding to a halt under the resulting strain.  One solution is to create a basic operational data store on another server where those big queries can execute.  In this session, I will share some scripts to create a simple ODS system and to automatically refresh your databases.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 03

Time: 4:00 PM - 5:15 PM

Room: ARP 314

Put on your CSI caps as we delve into the anatomy of a Very Large Data Warehouse environment!  During this case study session, we'll take a look at the data warehouse environment at the Department of Veterans Affairs.  The VA is the largest healthcare organization in the US and has an extensive national DW and BI infrastructure, now in its seventh year of evolution.  We'll take a look at the database infrastructure, the data loading process, and the various reporting and analytics solutions that provide over 150,000 knowledge workers and report consumers with timely data and information.  We'll also take a look at some of the processes in place to support the myriad of extended reporting and analytics teams throughout the VA who build and manage second-tier downstream data marts and other reporting solutions.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 03

Time: 1:00 PM - 2:15 PM

Room: ARP 116

Master Data Services (MDS) enables the management of non-transactional data that defines business entities within the enterprise. Get a good business and technical understanding of how MDS can help obtain better business clarity across the organization through a Data Governance strategy. Data Governance is a methodology that represents quality, policies, and process management, in relation to handling your enterprise data. 
The session will demonstrate the architecture of a Master Data Management solution and the data integration required to implement it within the enterprise.
In this session, you will learn:
* A brief introduction to Master Data Management and Data Governance
* Master Data Management staging architecture
* Data integration with the entity-based staging tables
* Batch processing to move data in the MDS specific tables
* Publishing data to external systems with subscription views and web services
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 03

Time: 2:30 PM - 3:45 PM

Room: ARP 116

Learn more about the Data Science degree and certificate programs sponsored by Rockhurst's Helzberg School of Management
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 03

Time: 12:15 PM - 12:30 PM

Room: ARP 116

Continuous Integration & Delivery isn’t a new concept.  Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up.  Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I'll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments.   We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.  
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 03

Time: 9:00 AM - 10:15 AM

Room: ARP 212

All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or create it in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 03

Time: 9:00 AM - 10:15 AM

Room: ARP 116

During this session you will be thrust into the role of the DBA hired to fix SQL Server to prevent it from ever getting SQL Injected, or at least minimize the damage that can be done when it does.  From bottom to top this session will cover how services should be configured, how SQL Server should be configured, benefits and risks of SQL Server security configurations, and best practices for app development.  Come learn how to defend your servers from hackers, or how to become a SQL Injection hacker yourself!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: October 03

Time: 10:30 AM - 11:45 AM

Room: ARP 224

A discussion of the Dell Software offerings in the SQL Server Performance  monitoring space.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 03

Time: 12:15 PM - 12:30 PM

Room: ARP 114

Dimensional modeling is arguably one of the most important
fundamentals of business intelligence.  It is still relevant even as
new technologies like PowerPivot and SSAS Tabular Models are becoming
more popular.  Correctly modeling your organization's data not only
protects the most important asset your company has but ensures that
your data mart or data warehouse will be responsive and capable of
accommodating emerging requirements.

This session provides a deeper dive into 
the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover  physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 03

Time: 10:30 AM - 11:45 AM

Room: ARP 116

Did you know that SQL Server Availability Groups can be a great solution for disaster recovery?  Availability groups have become well known for their high availability capabilities, and for good reason: they work well, they remove some of clustering’s limitations, and they are fairly straightforward to setup.  Extending an availability group to multiple sites for disaster recovery becomes more complicated.  A lot of moving parts have to come together for it to work properly - SQL Server, Windows, Active Directory, and DNS all get involved in this advanced configuration.  In this session, we’ll discuss some of the factors that complicate a multi-site availability group deployment, and we’ll walk through a multi-site deployment so you can see how it’s done.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 03

Time: 9:00 AM - 10:15 AM

Room: ARP 210

In Memory OLTP is one of the most popular features of SQL Server 2014. Many BI professionals are finding memory optimized objects make excellent tools in the quiver of the ETL developer as well.  Attend this session to see how "hekaton", memory optimized objects, native stored procedures, and schema only designs can be applied to staging and transformations to achieve  incredible performance gains over traditional models.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 03

Time: 10:30 AM - 11:45 AM

Room: ARP 212

In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript.
Goals: 
#1 Show how to create validate JSON strings using Notepad++, validate the JSON against a schema using C# Newtonsoft dll. Demonstrate how to work with JSON in SQL Server as a reference on how hard it is to work with JSON when it is not natively stored.
#2 Demo the basics of DocumentDB - Create the database, collections and documents using the web interface.  Demo how to perform basic selects, joins and filtering. Review java script basics as java script is fundamental in creating stored procedures
#3 Demo of how to work with DocumentDB in a C# by creating collections, documents and querying the database using lync and SQL syntax. 

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 03

Time: 4:00 PM - 5:15 PM

Room: ARP 212

There's far more occurring on your Windows servers than just SQL Server, and looking at ERRORLOG won't show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more.  We'll start by looking at different ways to collect Event Logs.  From there we'll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server.

We'll finish it off with two immediately-usable implementations you can set up on Monday.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 03

Time: 2:30 PM - 3:45 PM

Room: ARP 114

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