sqlsathistory

Nr: 444

SQLSaturday #444 - Kansas City 2015

Start Time (24h)	Speaker	Track	Title
09:00:00	David Maxwell	Enterprise Database Administration Deployment	The Usual SUSPECTs: When Good Databases Go Bad
09:00:00	John Deardurff	Application Database Development	The PROCESS of Queries
09:00:00	Kathi Kellenberger	Application Database Development	T-SQL Window Function Performance
09:00:00	Ed Leighton-Dick	Enterprise Database Administration Deployment	Extending Your Availability Group for Disaster Recovery
09:00:00	John Morehouse	Enterprise Database Administration Deployment	Database Continuous Delivery Your Salvation!
09:00:00	Steve Wake	BI Platform Architecture, Development Administration	Date Dimension: Past Future in One Script
09:00:00	Chris Miller	Application Database Development	SQL Server and ElasticSearch Integration
10:30:00	Scott Shaw	BI Platform Architecture, Development Administration	Navigating the Hadoop Stack
10:30:00	Keith Tate	Enterprise Database Administration Deployment	Profiler is Dead! Long Live Extended Events!
10:30:00	Jason Horner	BI Platform Architecture, Development Administration	Dimensional Modeling Design Patterns: Beyond Basics
10:30:00	Rob Kraft	Other	Defense in Depth - Minimizing the Risk of SQL Injection
10:30:00	Tristan Wilson	Strategy and Architecture	Sql Server Architecture for World Domination
10:30:00	Andre DuBois	Enterprise Database Administration Deployment	Setting up your PowerShell Environment
10:30:00	Russ Thomas	BI Platform Architecture, Development Administration	In Memory Tables; Not Just For OLTP
12:15:00	KC SQLSaturday	Other	Dell Software Performance Monitoring Solutions for SQL Server
12:15:00	KC SQLSaturday	Other	Data Science at Rockhurst
13:00:00	Bill Graziano	Application Database Development	Building a Modern Transaction System on SQL Server
13:00:00	Zane Brunette	Enterprise Database Administration Deployment	Cardinality estimation and how it affects your execution plan
13:00:00	Melissa Coates	BI Platform Architecture, Development Administration	Power BI: Architecture, Integration Points, Implementation Options
13:00:00	Sudhir Gajre	Cloud Application Development Deployment	What, Why, and How of Cloud Migrations
13:00:00	Wendy Pastrick	Application Database Development	Visualizing Your Indexes - Science vs Art
13:00:00	Xuan Pham	BI Information Delivery	SQL in SAS and R
13:00:00	Dave Fackler	BI Platform Architecture, Development Administration	CSI: DW -- Anatomy of a VLDW!
14:30:00	Reeves Smith	BI Platform Architecture, Development Administration	Data Integration with Master Data Services
14:30:00	Leslie Weed	BI Platform Architecture, Development Administration	Source Control practices for your BI World
14:30:00	Michael Bourgon	Enterprise Database Administration Deployment	Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH
14:30:00	Chase Aucoin	Advanced Analysis Techniques	Azure Machine Learning - Building New Value From Old Data
14:30:00	Brandon Reno	Application Database Development	Splitting your tables: Partitioning Basics
14:30:00	Dave Walden	Enterprise Database Administration Deployment	A Look At SQL Server 2016 Always Encrypted
14:30:00	Myles Gartland	Advanced Analysis Techniques	Trees, Forests and Predictive Models
14:30:00	KC SQLSaturday	Other	Lightning Talks
16:00:00	Matt Wigdahl	Application Database Development	"But It Sounded So Simple!": Building a Messaging System in Service Broker
16:00:00	JD Wade	BI Platform Architecture, Development Administration	Connected at the hip for MS BI: SharePoint and SQL
16:00:00	Jeff Renz	Application Database Development	Introduction to Microsoft Azure DocumentDB
16:00:00	Brian Hansen	Enterprise Database Administration Deployment	Create a Simple Operational Data Store
16:00:00	Christopher Wolff	Application Database Development	Continuous Deployments using SSDT
16:00:00	Bill Fellows	BI Platform Architecture, Development Administration	What is Biml and why are SSIS people talking about it?
16:00:00	Melissa Coates	BI Platform Architecture, Development Administration	Power BI Open QA

SessionID: 37136

The Usual SUSPECTs: When Good Databases Go Bad

Back to calendar

Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: The Usual SUSPECTs: When Good Databases Go Bad

Abstract:

You just finished patching your SQL Server. After rebooting it, though, some of your databases aren't coming online. What do you do? In this session we'll cover some of the various states that a database can be in. We’ll look at useful states like OFFLINE and STANDBY, as well as damaged states like SUSPECT or RECOVERY_PENDING. You’ll learn how databases get into those states, and the proper techniques to bring your data safely back online.

SessionID: 38173

The PROCESS of Queries

Back to calendar

Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Application Database Development

Speaker: John Deardurff

Title: The PROCESS of Queries

Abstract:

This session focuses on the PROCESS of queries and how this effects Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.

SessionID: 38379

T-SQL Window Function Performance

Back to calendar

Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: T-SQL Window Function Performance

Abstract:

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

SessionID: 39036

Extending Your Availability Group for Disaster Recovery

Back to calendar

Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Leighton-Dick

Title: Extending Your Availability Group for Disaster Recovery

Abstract:

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.

SessionID: 39291

Database Continuous Delivery Your Salvation!

Back to calendar

Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: John Morehouse

Title: Database Continuous Delivery Your Salvation!

Abstract:

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.

SessionID: 39767

Date Dimension: Past Future in One Script

Back to calendar

Event Date: 03-10-2015 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Wake

Title: Date Dimension: Past Future in One Script

Abstract:

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!

SessionID: 39841

SQL Server and ElasticSearch Integration

Back to calendar

Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Chris Miller

Title: SQL Server and ElasticSearch Integration

Abstract:

SessionID: 37482

Navigating the Hadoop Stack

Back to calendar

Event Date: 03-10-2015 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

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

Profiler is Dead! Long Live Extended Events!

Back to calendar

Event Date: 03-10-2015 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Keith Tate

Title: Profiler is Dead! Long Live Extended Events!

Abstract:

Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.

That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool! In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!

SessionID: 38498

Dimensional Modeling Design Patterns: Beyond Basics

Back to calendar

Event Date: 03-10-2015 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond Basics

Abstract:

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.

SessionID: 39511

Defense in Depth - Minimizing the Risk of SQL Injection

Back to calendar

Event Date: 03-10-2015 - Session time: 10:30:00 - Track: Other

Speaker: Rob Kraft

Title: Defense in Depth - Minimizing the Risk of SQL Injection

Abstract:

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!

SessionID: 39780

Sql Server Architecture for World Domination

Back to calendar

Event Date: 03-10-2015 - Session time: 10:30:00 - Track: Strategy and Architecture

Speaker: Tristan Wilson

Title: Sql Server Architecture for World Domination

Abstract:

It's common to start with a small database server; but when activity increases, how do you know when to scale? This session will cover scaling Sql Server from express to enterprise and VM to a scale-out HADR architecture. You'll learn common upgrade and migration techniques along with things to keep in mind when building new environments. We'll start with a stand alone server and work our way up to a large scale out and scale up deployment.

SessionID: 39970

Setting up your PowerShell Environment

Back to calendar

Event Date: 03-10-2015 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Andre DuBois

Title: Setting up your PowerShell Environment

Abstract:

Whether you are new to PowerShell or have some experience, have you ever looked at customizing your environment? Do you know how many profiles PowerShell has? Do you hate typing a long command and wish there was a shortcut? Do you want to quickly setup your environment so you don’t have to setup the same aliases each time you start PowerShell? Learn the answer to these questions and more during our discussion. You will walk away with many quick tips and tricks you can use immediately.

SessionID: 40749

In Memory Tables; Not Just For OLTP

Back to calendar

Event Date: 03-10-2015 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Russ Thomas

Title: In Memory Tables; Not Just For OLTP

Abstract:

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.

SessionID: 41151

Dell Software Performance Monitoring Solutions for SQL Server

Back to calendar

Event Date: 03-10-2015 - Session time: 12:15:00 - Track: Other

Speaker: KC SQLSaturday

Title: Dell Software Performance Monitoring Solutions for SQL Server

Abstract:

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

SessionID: 41153

Data Science at Rockhurst

Back to calendar

Event Date: 03-10-2015 - Session time: 12:15:00 - Track: Other

Speaker: KC SQLSaturday

Title: Data Science at Rockhurst

Abstract:

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

SessionID: 39049

Building a Modern Transaction System on SQL Server

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Bill Graziano

Title: Building a Modern Transaction System on SQL Server

Abstract:

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.

SessionID: 39199

Cardinality estimation and how it affects your execution plan

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Zane Brunette

Title: Cardinality estimation and how it affects your execution plan

Abstract:

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.

SessionID: 39369

Power BI: Architecture, Integration Points, Implementation Options

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Power BI: Architecture, Integration Points, Implementation Options

Abstract:

In this session we will review Power BI V2 architecture and integration points with corporate data sources, SaaS services, Azure, and third party apps. We will examine and demonstrate key capabilities in the Power BI web-based service, Power BI Desktop, Excel, and mobile apps. Implementation options for Power BI involving cloud, on-premises, and hybrid approaches will be explored. Finally, the concept of "Bimodal BI" will be introduced with use cases for how Power BI might be utilized for both self-service BI and certain corporate BI initiatives.

SessionID: 39505

What, Why, and How of Cloud Migrations

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Sudhir Gajre

Title: What, Why, and How of Cloud Migrations

Abstract:

IaaS, PaaS, SaaS, Storage, Hybrid etc. etc. are you confused? If you are, that’s ok. In this session I explore the different capabilities that are available to migrate on-prem workloads to the cloud. I discuss what workloads are more conducive to a cloud migration and how you can determine the ‘low hanging fruit’. I will walk you through a framework I developed to examine all the dependencies that you need to understand and evaluate before migrating to the cloud. I will also lead you through various migration options and architectures that are being commonly deployed in the cloud.

SessionID: 40023

Visualizing Your Indexes - Science vs Art

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Wendy Pastrick

Title: Visualizing Your Indexes - Science vs Art

Abstract:

Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.

SessionID: 40212

SQL in SAS and R

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Xuan Pham

Title: SQL in SAS and R

Abstract:

SAS and R, two statistical programming languages, have adopted SQL into their environments. The purpose of this presentation is to introduce novice users to PROC SQL in SAS and the sqldf package in R. Topics cover include select and join statements.

SessionID: 40358

CSI: DW -- Anatomy of a VLDW!

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dave Fackler

Title: CSI: DW -- Anatomy of a VLDW!

Abstract:

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.

SessionID: 39234

Data Integration with Master Data Services

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reeves Smith

Title: Data Integration with Master Data Services

Abstract:

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

SessionID: 39565

Source Control practices for your BI World

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Weed

Title: Source Control practices for your BI World

Abstract:

Source Control is a critical part of any development effort. For small shop developers tools like TFS can be overwhelming especially for developers that come from organizations with little to no source control experience. Let's talk about practices and ways to implement source control for SSIS, SSRS and Database Projects in both multi-developer and multi-tiered environments. We will cover when and how to branch, merge and shelve and discuss ideas around process for deployment and continuous integration.

SessionID: 39733

Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Bourgon

Title: Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH

Abstract:

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.

SessionID: 39810

Azure Machine Learning - Building New Value From Old Data

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Chase Aucoin

Title: Azure Machine Learning - Building New Value From Old Data

Abstract:

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.

SessionID: 39822

Splitting your tables: Partitioning Basics

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Brandon Reno

Title: Splitting your tables: Partitioning Basics

Abstract:

Partitioning is a strategy in SQL Server that allows you to physically separate data in your table along a given field, granting benefits to performance in specific circumstances, but at the cost of some additional maintenance. Here we'll discuss the benefits and drawbacks of Table Partitioning in MS SQL Server, as well as when you should, or should not, consider partitioning your tables.

SessionID: 39845

A Look At SQL Server 2016 Always Encrypted

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Walden

Title: A Look At SQL Server 2016 Always Encrypted

Abstract:

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.

SessionID: 40214

Trees, Forests and Predictive Models

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Myles Gartland

Title: Trees, Forests and Predictive Models

Abstract:

This session will introduce people to a couple of modern forms of data mining for predictive analytics problems. We will review Decision Trees, Random Forests and other ensemble methods. These are methods are highly popular in data science. We will show some cases studies of how these are used in business for increased prediction .

SessionID: 41175

Lightning Talks

Back to calendar

Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Other

Speaker: KC SQLSaturday

Title: Lightning Talks

Abstract:

This session will contain 3 lightning talks: "Trees, Forests and Predictive Models" by Myles Gartland; "Power BI: From Nothing to Dashboard in 10 Minutes!" by Steve Wake; "Why Data Viz is Important for All Data Professionals" by Meagan Longoria

SessionID: 37041

"But It Sounded So Simple!": Building a Messaging System in Service Broker

Back to calendar

Event Date: 03-10-2015 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Matt Wigdahl

Title: "But It Sounded So Simple!": Building a Messaging System in Service Broker

Abstract:

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.

SessionID: 37351

Connected at the hip for MS BI: SharePoint and SQL

Back to calendar

Event Date: 03-10-2015 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: JD Wade

Title: Connected at the hip for MS BI: SharePoint and SQL

Abstract:

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.

SessionID: 38576

Introduction to Microsoft Azure DocumentDB

Back to calendar

Event Date: 03-10-2015 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Jeff Renz

Title: Introduction to Microsoft Azure DocumentDB

Abstract:

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.

SessionID: 39775

Create a Simple Operational Data Store

Back to calendar

Event Date: 03-10-2015 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Create a Simple Operational Data Store

Abstract:

SessionID: 40084

Continuous Deployments using SSDT

Back to calendar

Event Date: 03-10-2015 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Christopher Wolff

Title: Continuous Deployments using SSDT

Abstract:

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.

SessionID: 40303

What is Biml and why are SSIS people talking about it?

Back to calendar

Event Date: 03-10-2015 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bill Fellows

Title: What is Biml and why are SSIS people talking about it?

Abstract:

This session is designed for you, the experienced SSIS developer who's been hearing about Biml but hasn't taken the plunge. We will cover what Biml is and walk through some examples from Hello World equivalent to a fully baked truncate and reload pattern. You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.

SessionID: 41147

Power BI Open QA

Back to calendar

Event Date: 03-10-2015 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Power BI Open QA

Abstract:

Bring your questions, problems, concerns, and ideas to this open QA and we'll talk through them. There's no predefined agenda for this session, though potential discussion topics may include things like production considerations, integration with Office 365 unified groups, how to manage organizational content distributed to a group of users, importing vs. connecting to data sources, changes since V1 of Power BI, and use of Excel vs. Power BI Desktop.

This site is open source. Improve this page.