sqlsathistory

Nr: 449

SQLSaturday #449 - San Diego 2015

Start Time (24h)	Speaker	Track	Title
08:45:00	Grant Fritchey	Application Database Development	Execution Plans: What Can You Do With Them?
08:45:00	Charles Hyman	BI Platform Architecture, Development Administration	SQL 2016 Changes and Enhancements for BI and Beyond
08:45:00	Joseph D'Antoni	Enterprise Database Administration Deployment	Building Perfect SQL Servers, Every Time
08:45:00	Haaron Gonzalez	Enterprise Database Administration Deployment	Configuring SQL Server for a successful SharePoint Server Deployment
08:45:00	Mickey Stuewe	Application Database Development	Changing Your Habits to Improve the Performance of Your T-SQL
10:00:00	Grant Fritchey	Application Database Development	The Database: The Elephant in the ALM Room
10:00:00	Joseph D'Antoni	BI Platform Architecture, Development Administration	In-Memory Columnstore Indexes--Make Your Data Warehouse Fly
10:00:00	Daniel Upton	Strategy and Architecture	Data Modeling for Integration of RDBMS with NOSQL
10:00:00	Pam Matthews	Information Delivery	Master Data Management with SQL Master Data Services (MDS) and Maestro
10:00:00	Mickey Stuewe	Application Database Development	Silent Killers Lurking in Your Database Design
10:00:00	Prakash Heda	Enterprise Database Administration Deployment	Universal SQL Installations - Part 1
11:15:00	Ami Levin	Application Database Development	Physical Join Operators
11:15:00	Prakash Heda	Enterprise Database Administration Deployment	Universal SQL Installations – Script Review Demo
11:15:00	Andrew Karcher	Application Database Development	SQL 2012 Programmability Enhancements
11:15:00	Jason Brimhall	Enterprise Database Administration Deployment	Murder They Wrote
11:15:00	Sean McCown	Enterprise Database Administration Deployment	Monster Text Manipulation: Regular Expressions for the DBA
11:15:00	Benjamin Nevarez	Application Database Development	Understanding Parameter Sniffing
13:30:00	Ami Levin	Application Database Development	Where did I put my (primary) keys?
13:30:00	Andrew Karcher	Strategy and Architecture	A NoSQL Primer for the SQL Server Developer
13:30:00	Warren Sifre	Enterprise Database Administration Deployment	DBA Monitoring and Maintenance Fundamentals
13:30:00	Jason Brimhall	Enterprise Database Administration Deployment	Extended Events - Better than Profiler
13:30:00	Phil Helmer	Application Database Development	Building Your Way to Better Database Testing
13:30:00	Sean McCown	Enterprise Database Administration Deployment	Minion Maintenance and Backup Solutions
13:30:00	Benjamin Nevarez	Application Database Development	Dive into the Query Optimizer - Undocumented Insight
14:45:00	Denny Cherry	Enterprise Database Administration Deployment	Database Administration for the non-DBA
14:45:00	Jason Brimhall	Enterprise Database Administration Deployment	A Masters Passport to Extended Events
14:45:00	Randy Knight	Application Database Development	Understanding the SQL Server Transaction Log
14:45:00	Jennifer McCown	Application Database Development	Code Sins
14:45:00	Ted Stathakis	BI Information Delivery	Introduction to SQL Server Reporting Services
14:45:00	Sumeet Bansal	Strategy and Architecture	Architectural Designs Driving SQL Server Performance Availability
16:00:00	Denny Cherry	Application Database Development	Things You Should Never Do In Microsoft SQL Server
16:00:00	Warren Sifre	Advanced Analysis Techniques	Introduction to Azure Machine Learning
16:00:00	Randy Knight	Application Database Development	But it worked great in Dev! Perfomance for Devs
16:00:00	Jennifer McCown	Application Database Development	Designing Stored Procedure Solutions
16:00:00	Ted Stathakis	BI Information Delivery	Better Report Development and Management Techniques
16:00:00	Svetlana Marinova	BI Platform Architecture, Development Administration	Overview of Open-Source Tools of the Hortonworks Data Platform

SessionID: 37939

Execution Plans: What Can You Do With Them?

Back to calendar

Event Date: 19-09-2015 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Execution Plans: What Can You Do With Them?

Abstract:

There’s just so much to do to get your systems to run in an optimal fashion, but where do you start. This session will walk you through an extensive checklist of things you can do to better manage your servers, databases and code. We’ll start with server configurations and what you can do with them. We’ll then move through standard administrative tasks that will help with performance. Then it’s off to the intricacies of database design and how that can affect performance. We’ll finish up with T-SQL and where it can hurt or help your systems. All examples in the session will use readily available tools that are a standard part of SQL Server. Get your own systems to run faster with the information you’ll receive.

SessionID: 37991

SQL 2016 Changes and Enhancements for BI and Beyond

Back to calendar

Event Date: 19-09-2015 - Session time: 08:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Charles Hyman

Title: SQL 2016 Changes and Enhancements for BI and Beyond

Abstract:

Operational Analytics: Insights on operational data, works with in-memory OLTP or on disk

In-memory OLTP enhancements: Greater T-SQL surface area, terabytes of memory supported and greater number of parallel CPUs

Query Data Store: Monitor and optimize query plans with full history of query execution

Native JSON: Parsing storing of JSON as relational data exporting relational data to JSON

Temporal Database: Track historical changes

PolyBase: Manage relational non-relational data with the simplicity of T-SQL

Power Query for Analytics and Reporting: Pull data from countless sources into data models and reports

Enhanced SSIS: Designer support for previous SSIS versions and support for Power Query

Enterprise-grade Analysis Services: Enhanced performance and scalability for Analysis Services

Single SSDT in Visual Studio 2015: Build richer analytics solutions as part of your development projec

SessionID: 38081

Building Perfect SQL Servers, Every Time

Back to calendar

Event Date: 19-09-2015 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Joseph D'Antoni

Title: Building Perfect SQL Servers, Every Time

Abstract:

One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.

SessionID: 40246

Configuring SQL Server for a successful SharePoint Server Deployment

Back to calendar

Event Date: 19-09-2015 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Haaron Gonzalez

Title: Configuring SQL Server for a successful SharePoint Server Deployment

Abstract:

In this session we will introduce some of the main features of SharePoint Server 2013 and explain how to optimize SQL Server platform for a successful SharePoint Server deployment. Come and learn those SQL configuration settings that will make the difference when people start using and adopting SharePoint.

SessionID: 40531

Changing Your Habits to Improve the Performance of Your T-SQL

Back to calendar

Event Date: 19-09-2015 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Mickey Stuewe

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract:

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

SessionID: 37938

The Database: The Elephant in the ALM Room

Back to calendar

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

Speaker: Grant Fritchey

Title: The Database: The Elephant in the ALM Room

Abstract:

Many teams and individuals are still building their databases and maintaining them through old-fashioned manual processes. This, even as these same teams move towards an automated Application Lifecycle Management (ALM) through the adoption of DevOps best practices. These manual processes are hurting the ability of your database deployments to keep up with modern development. Is there a technical reason for this slow adoption of ALM best practices in the database world, or is there a cultural problem preventing a reassessment of these manual processes? Or, could it be both? This session will address these questions as it explores the challenges presented by ALM for databases. We will discuss the necessary first steps required to move from a manual database deployment process to a fully automated one. You will learn about tooling that can assist you in implementing these new processes. Your database deployments can take advantage of the same processes you use for application deployments.

SessionID: 38080

In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Back to calendar

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

Speaker: Joseph D'Antoni

Title: In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Abstract:

Columnstore indexes were introduced in SQL Server 2012, along with a new type of query processing "batch mode". In SQL 2014 they get even better--we can use a Columnstore index as a clustered index and update it. In this session we will explore the basics and beyond of Columnstore indexes and how they can help your warehouse performance. We will also examine their impact to insert and update performance, and the best use cases for implementation.

SessionID: 39570

Data Modeling for Integration of RDBMS with NOSQL

Back to calendar

Event Date: 19-09-2015 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Daniel Upton

Title: Data Modeling for Integration of RDBMS with NOSQL

Abstract:

Join us to explore how emerging data modeling methods and model notations help us define, and easily communicate, robust integration points between NOSQL data stores and emerging RDBMS 'Lean Data Warehouse' models that would otherwise be challenging to map across due to radical differences in normalization. Did you buy the pitch about how 'BigData and RDBMS Data Warehouses can remain in isolation'. Me neither! You will leave this sessions not only free from some rigid E/R modeling assumptions and diagramming standards, but also armed with an introduction to a practical method of logical data modeling in the new world of polyglot data storage.

SessionID: 40171

Master Data Management with SQL Master Data Services (MDS) and Maestro

Back to calendar

Event Date: 19-09-2015 - Session time: 10:00:00 - Track: Information Delivery

Speaker: Pam Matthews

Title: Master Data Management with SQL Master Data Services (MDS) and Maestro

Abstract:

In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any data domain, we will demonstrate building a sample customer domain, showing how to leverage SQL Server Master Data Services (MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.

SessionID: 40530

Silent Killers Lurking in Your Database Design

Back to calendar

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

Speaker: Mickey Stuewe

Title: Silent Killers Lurking in Your Database Design

Abstract:

A good database design goes deeper than the rules that Codd gave us. We need to leverage SQL Server to help enforce these rules. In this class we’ll look at some common questions like: I have foreign keys, why do I need foreign key constraints too? Why are smart keys not so smart? If I use an identity field, do I still need to declare it as a primary key? The wrong answers to these questions can slow your queries down over time and even create bad data. Join me in my session as we look at demos to understand how silent killers can begin to lurk in your database.

SessionID: 40562

Universal SQL Installations - Part 1

Back to calendar

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

Speaker: Prakash Heda

Title: Universal SQL Installations - Part 1

Abstract:

Session 2 will cover script review and demo...

SessionID: 37255

Physical Join Operators

Back to calendar

Event Date: 19-09-2015 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Ami Levin

Title: Physical Join Operators

Abstract:

SessionID: 37316

Universal SQL Installations – Script Review Demo

Back to calendar

Event Date: 19-09-2015 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Prakash Heda

Title: Universal SQL Installations – Script Review Demo

Abstract:

This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

You’ll take-away script to install different versions of SQL Server on supported OS systems. This script allows anyone in IT to install SQL systems with best practices baked into it which ensure all SQL installation can be streamlined.

You’ll see PowerShell scripts where a single line script can install any of these combinations: • Windows 2008R2/2012/2012R2 • SQL 2014/2012/2008R2 (Enterprise/Standard/Developer editions) • Implement best practices and configuration based on available resources for dedicated SQL Server environments

SessionID: 37644

SQL 2012 Programmability Enhancements

Back to calendar

Event Date: 19-09-2015 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Andrew Karcher

Title: SQL 2012 Programmability Enhancements

Abstract:

With SQL 2012 comes a slew of enhancements on the Programmability side. This session will explore some of those new features such as Analytic Functions, Over Clause (Window Functions), Date Functions, Conversion Functions, Sequence Objects, Paging and FileTables to name just a few. If you want to get a jump on those features you will be seeing in SQL 2012 this is the session for you.

SessionID: 38893

Murder They Wrote

Back to calendar

Event Date: 19-09-2015 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Murder They Wrote

Abstract:

Join Microsoft Certified Master, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy. This is the Solo version of the Joint version normally done as an all-day precon.

SessionID: 40415

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 19-09-2015 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you.

Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.

SessionID: 40581

Understanding Parameter Sniffing

Back to calendar

Event Date: 19-09-2015 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Understanding Parameter Sniffing

Abstract:

Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

SessionID: 37256

Where did I put my (primary) keys?

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Ami Levin

Title: Where did I put my (primary) keys?

Abstract:

In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.

We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.

SessionID: 37643

A NoSQL Primer for the SQL Server Developer

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: Andrew Karcher

Title: A NoSQL Primer for the SQL Server Developer

Abstract:

You have all probably heard about this "NoSQL" thing and wondered what is about, how does it differ from SQL Server and how will this affect me. You might want to just stick your head in the sand and ignore it, but as database professionals it is always good to know about what other technologies might be out there to compliment your existing solutions. We will not be going deep into any one solution, but by the end of this session, the goal will be that you understand the following:

The different types of NoSQL databases
Some use cases where they might be applicable
Some of the major solutions out there for each one

SessionID: 37732

DBA Monitoring and Maintenance Fundamentals

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Warren Sifre

Title: DBA Monitoring and Maintenance Fundamentals

Abstract:

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.

SessionID: 38880

Extended Events - Better than Profiler

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Extended Events - Better than Profiler

Abstract:

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

SessionID: 39798

Building Your Way to Better Database Testing

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Phil Helmer

Title: Building Your Way to Better Database Testing

Abstract:

Test Data Builders. Ever heard of them? That's ok. Neither did I before I went looking for a convenient way to set up test data in SQL Server. I will show you what they are and how they work. More importantly, you will learn an easy way to get started and what you can do with them that could make your professional value grow and earn more money. I will also cover some of the design decisions you need to make so that they'll fit your needs.

SessionID: 40416

Minion Maintenance and Backup Solutions

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Minion Maintenance and Backup Solutions

Abstract:

The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable.

In this session I’ll show you the benefits to Minion Backup: • Simple installation and configuration for all shops, large or small • Single or multi-server installation script • Table-based configuration eliminates the need for excessive jobs • Highly customizable options • Flexible include and exclude options, including the use of regular expressions • “Statement only” option generates statements without running them • Extensive logging • Live insight into the current maintenance operation

Minion Backup also provides a truly superb specialty: dynamic backup tuning. Minion Backup scales to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.

SessionID: 40579

Dive into the Query Optimizer - Undocumented Insight

Back to calendar

Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 37414

Database Administration for the non-DBA

Back to calendar

Event Date: 19-09-2015 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Denny Cherry

Title: Database Administration for the non-DBA

Abstract:

So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it. I've got some of the answers here in this session for you. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.

SessionID: 38895

A Masters Passport to Extended Events

Back to calendar

Event Date: 19-09-2015 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: A Masters Passport to Extended Events

Abstract:

As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.

It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

SessionID: 39405

Understanding the SQL Server Transaction Log

Back to calendar

Event Date: 19-09-2015 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Randy Knight

Title: Understanding the SQL Server Transaction Log

Abstract:

The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

SessionID: 39939

Code Sins

Back to calendar

Event Date: 19-09-2015 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Code Sins

Abstract:

It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.

SessionID: 40234

Introduction to SQL Server Reporting Services

Back to calendar

Event Date: 19-09-2015 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Ted Stathakis

Title: Introduction to SQL Server Reporting Services

Abstract:

Are you tired of users constantly coming to you for data? Would like to be able to quickly and easily enable your uses to go get the data themselves? Do you simply not have the budget/executive buy in to buy a solution? In this session you will see how easy this often overlooked and underutilized feature of SQL Server is to use. This session will start with a quick overview of some reporting examples and will then cover the basics of developing, publishing and using an SSRS report. It will cover all aspects from connecting to the data source through putting the data on the page to publishing to the report server. You will learn how you can return to the office and present meaningful data to your end users with minimal time and effort with this very powerful and easy to use tool that can relieve you from data delivery tasks and thrill your end users all at the same time.

SessionID: 40849

Architectural Designs Driving SQL Server Performance Availability

Back to calendar

Event Date: 19-09-2015 - Session time: 14:45:00 - Track: Strategy and Architecture

Speaker: Sumeet Bansal

Title: Architectural Designs Driving SQL Server Performance Availability

Abstract:

In this session, you’ll learn about the latest advancements in storage technology, the various ways flash can be deployed (flash caching, server-side PCIe flash, hybrid, and all-flash), and the pros and cons for each. We’ll also discuss how a well-designed infrastructure can drive efficiencies and help your organization save on licensing and maintenance costs.

SessionID: 37413

Things You Should Never Do In Microsoft SQL Server

Back to calendar

Event Date: 19-09-2015 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Denny Cherry

Title: Things You Should Never Do In Microsoft SQL Server

Abstract:

In this fun session we'll review a bunch of problem implementations that have been seen in the real world. Most importantly we will look at why these implementations went horribly wrong so that we can learn from them and never repeat these mistakes again.

SessionID: 37728

Introduction to Azure Machine Learning

Back to calendar

Event Date: 19-09-2015 - Session time: 16:00:00 - Track: Advanced Analysis Techniques

Speaker: Warren Sifre

Title: Introduction to Azure Machine Learning

Abstract:

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

SessionID: 39403

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 19-09-2015 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Randy Knight

Title: But it worked great in Dev! Perfomance for Devs

Abstract:

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.

SessionID: 39938

Designing Stored Procedure Solutions

Back to calendar

Event Date: 19-09-2015 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.

SessionID: 40238

Better Report Development and Management Techniques

Back to calendar

Event Date: 19-09-2015 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Ted Stathakis

Title: Better Report Development and Management Techniques

Abstract:

Are you already using Reporting Services (SSRS) but just not loving it? Has it become clumsy, hard to manage or just plain not great? In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.

SessionID: 40834

Overview of Open-Source Tools of the Hortonworks Data Platform

Back to calendar

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

Speaker: Svetlana Marinova

Title: Overview of Open-Source Tools of the Hortonworks Data Platform

Abstract:

I will present an overview of the open-source tools of the Hortonworks Data Platform for Hadoop applications development. In particular, we will examine (1) Sqoop for moving data between relational databases and Hadoop, (2) Pig as a platform for complex data transformations and (3) Hive as a tool for data analysis that allows writing ad-hoc SQL-like queries against large datasets.

This site is open source. Improve this page.