sqlsathistory

Nr: 524

Back to Main list

SQLSaturday #524 - South Florida 2016

Start Time (24h)	Speaker	Track	Title
09:45:00	Pankaj Satyaketu	Enterprise Database Administration Deployment	What's new in SQL Server 2016
09:45:00	Mindy Curnutt	Application Database Development	TSQL Coding Techniques - Are You Playing with Fire?
09:45:00	Devin Knight	BI Information Delivery	Developing an End to End Power BI Solution
09:45:00	Sebastian Meine	Professional Development	The Phenomenal IT Consultant
09:45:00	Jose L. Rivera	Advanced Analysis Techniques	Advance Analytics with SQL Server R Services
09:45:00	Simon Cho	BI Platform Architecture, Development Administration	Build ETL efficiently (10x) with Minimal Logging
09:45:00	Konstantin Melamud	Enterprise Database Administration Deployment	Turbo Boost Performance: In Memory Tables index optimizations
09:45:00	Silvia Doomra	Cloud Application Development Deployment	Seamlessly Scaling Azure SQL DB with Elastic Database Tools
09:45:00	Kevin Boles	Application Database Development	SQL Injection
11:00:00	Jeffrey Garbus	Application Database Development	Bad, less Bad, not Bad; rewriting bad SQL Code
11:00:00	Michael Keleher	Enterprise Database Administration Deployment	Building Defense in Depth Using the Full Spectrum of SQL Server Encryption
11:00:00	Karlyn LeBlanc	Professional Development	Whip Away Stress at Home Work to Create a Better You
11:00:00	Joe Homnick	BI Information Delivery	Business Intelligence - Current State of the Art
11:00:00	Maximo Trinidad	Application Database Development	SSIS - Integrating PowerShell in a ScriptTask component
11:00:00	Sam Mesel	Application Database Development	Query Data Store
11:00:00	Kendal Van Dyke	Enterprise Database Administration Deployment	Mastering Plan Guides: Tell The Query Optimizer You're The Boss
11:00:00	Herve Roggero	BI Information Delivery	Query Zip Documents, CSV Files, and Azure Tables with T-SQL directly.
12:30:00	Yoav Yetinson	BI Information Delivery	New Capabilities on top of Microsoft SQL SSAS (Necto)
12:30:00	Olivier Renard	Strategy and Architecture	Database Use Cases: When to utilize an All Flash Array (Kaminario
12:30:00	Jemini Joseph	BI Platform Architecture, Development Administration	SSIS Factory (Dobler Consulting)
12:30:00	Gordon Cornelius	Enterprise Database Administration Deployment	Easily optimize and tune SQL Server performance anywhere on any device!
12:30:00	Robert Torres	Strategy and Architecture	Transform SQL Server (by Pureshare)
12:30:00	Ed Cho	Application Database Development	Building a Better Mousetrap: Using Cisco UCS for SQL Server Deployments
13:30:00	Pankaj Satyaketu	Cloud Application Development Deployment	Advancements in Azure SQL Database
13:30:00	Niran Even-Chen	Enterprise Database Administration Deployment	Architecting virtual SQL server for performance
13:30:00	Simon Cho	Application Database Development	Myths and Truths about SQL Server Transaction
13:30:00	Ben Galluzzo	Application Database Development	Using Common Table Expressions (CTE)
13:30:00	Konstantin Melamud	Enterprise Database Administration Deployment	Scaling for best performance: Partitioned views.
13:30:00	Marilyn Rousseau	Professional Development	Becoming Certified in SQL Server 2012/2014
13:30:00	Shabnam Watson	BI Platform Architecture, Development Administration	A SQL Developer’s Guide to MDX Basics
13:30:00	Kevin Boles	Application Database Development	SQL Server 2014 Column Store Index vNEXT
14:45:00	Alex Funkhouser	Other	For Love or Money, Your I.T. Career
14:45:00	Alexander Nykolaiszyn	BI Platform Architecture, Development Administration	SSAS The Primer... Or How I Learned to Love the Cube!
14:45:00	Richie Rump	Application Database Development	Who's Afraid of Entity Framework?
14:45:00	Kendal Van Dyke	Enterprise Database Administration Deployment	SQL Server Disaster Recovery and High Availability Overview
14:45:00	Pam Shaw	Analytics and Visualization	Power BI – Exploring New Frontiers
14:45:00	Sebastian Meine	Application Database Development	Introduction to Unit-Testing in SQL Server
14:45:00	David Crook	Analytics and Visualization	Analytical Computing Device to Cloud and Back Again
14:45:00	Rodney Landrum	Advanced Analysis Techniques	Traveling through the 4th Dimension with T-SQL and PowerBI
16:00:00	Mindy Curnutt	Application Database Development	The Ins and Outs of SQL Indexes
16:00:00	Salvi Pascual	Analytics and Visualization	How SQL is helping to connect Cuba to the Web for free
16:00:00	Ben Galluzzo	BI Information Delivery	MongoDB for SQL Developers and Accessing MongoDB with SSIS
16:00:00	Diana Betancourt	Professional Development	SQL Speaker Idol

SessionID: 46098

What's new in SQL Server 2016

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Pankaj Satyaketu

Title: What's new in SQL Server 2016

Abstract:

In this session we will be reviewing the highlights of what's new with SQL Server 2016. I will also be demonstrating several of the hero features in SQL Server 2016 such as Always Encrypted, Operational Insights, Polybase, Hybrid Cloud and much, much more.

SessionID: 48950

TSQL Coding Techniques - Are You Playing with Fire?

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: TSQL Coding Techniques - Are You Playing with Fire?

Abstract:

The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL, Parameter Sniffing and Value List Handling. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!

SessionID: 49466

Developing an End to End Power BI Solution

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: BI Information Delivery

Speaker: Devin Knight

Title: Developing an End to End Power BI Solution

Abstract:

Power BI has a many moving parts that can make it difficult to know when and where each part of the tool is necessary. In this half day session get a clear end to end journey through creating a Power BI solution. Start with the data discovery phase by importing and applying business rules to your data. Then load that data into a data model where you can apply hierarchies and calculations. Finally using that data model design reports to visualize the results. Once complete learn how the results can be shared with others by creating dashboards on the Power BI service. Taking this end to end trip through the tool will allow you to fully understand how each piece fits together.

SessionID: 49899

The Phenomenal IT Consultant

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: Professional Development

Speaker: Sebastian Meine

Title: The Phenomenal IT Consultant

Abstract:

Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone.

In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you…

• if you are struggling to find enough new clients,
• if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you,
• if you feel like you are treading water when it comes to marketing. Join this session and get started on your way to becoming a Phenomenal IT Consultant.

SessionID: 50044

Advance Analytics with SQL Server R Services

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: Advanced Analysis Techniques

Speaker: Jose L. Rivera

Title: Advance Analytics with SQL Server R Services

Abstract:

SQL Server R Services provides a platform for developing intelligent applications that uncover new insights. In this session we will show how to get started with SQL Server R Services to operationalize R solutions or to create powerful data exploration and predictive modeling solutions.

SessionID: 50117

Build ETL efficiently (10x) with Minimal Logging

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Cho

Title: Build ETL efficiently (10x) with Minimal Logging

Abstract:

This session is designed to teach DBAs and developers the best strategy to transfer large data.

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.

SessionID: 50190

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 50193

Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Silvia Doomra

Title: Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Abstract:

Elastic Database Tools for Azure SQL DB offers a set of features that make it easier to build and manage a scaled-out data tier for cloud applications. With elastic database tools, applications can easily access data spanning multiple DBs, coordinate management tasks and manage how data is distributed among them. As part of the session, we explore workloads that are a natural fit for Azure SQL DB's elastic database tools. Patterns discussed in depth include multi-tenant applications created by cloud ISVs and SaaS vendors, and applications relying on temporal data distribution. The session will illustrate how easy it is now to build, scale and manage cloud applications in SQL DB when using elastic tools capabilities such as the elastic database client library for .NET.

SessionID: 50785

SQL Injection

Back to calendar

Event Date: 18-06-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: SQL Injection

Abstract:

Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!

SessionID: 45608

Bad, less Bad, not Bad; rewriting bad SQL Code

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Jeffrey Garbus

Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Abstract:

This session provides case studies in rewriting bad SQL, with a lot of discussion on what makes sql code "bad"

SessionID: 48319

Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Keleher

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract:

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

SessionID: 48468

Whip Away Stress at Home Work to Create a Better You

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Whip Away Stress at Home Work to Create a Better You

Abstract:

If you are a working professional there is a chance that stress has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.

SessionID: 49608

Business Intelligence - Current State of the Art

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: BI Information Delivery

Speaker: Joe Homnick

Title: Business Intelligence - Current State of the Art

Abstract:

Join Joe on a fun and informative session on the current state of Microsoft Business Intelligence (BI) offerings. We will look at the array of tooling around BI in SQL Server 2016, Power BI and Cortana Intelligence. There have been major changes in reporting and cognitive data source capabilities the last few months. This session will get you caught up on your current BI possibilities with many dazzling demos.

SessionID: 49886

SSIS - Integrating PowerShell in a ScriptTask component

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Maximo Trinidad

Title: SSIS - Integrating PowerShell in a ScriptTask component

Abstract:

This session will demostrate how you can reuse a PowerShell script in SSIS "Script Task" component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend.

SessionID: 50202

Query Data Store

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Sam Mesel

Title: Query Data Store

Abstract:

Analyzing query performance can be tricky. It involves knowing several dynamic management views (DMVs) and accessing query plans that are still in the query cache. If you need to get performance metrics for a query which is no longer in the cache, or if your server is restarted it will be an impossible task.

Query Data Store is a new feature that comes to help DBAs. By persisting query execution data over time, it allows reviewing of statements / plans / properties / statistics. This session will show you how to enable and use QDS features, like: obtaining queries with plan changes over time; analyze queries by CPU / Memory / other counters; forcing a plan; and other gems.

SessionID: 50248

Mastering Plan Guides: Tell The Query Optimizer You're The Boss

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kendal Van Dyke

Title: Mastering Plan Guides: Tell The Query Optimizer You're The Boss

Abstract:

It's Monday morning and everyone is complaining that the database is slow. You see the problem - even though indexes aren't fragmented and statistics are up to date the query optimizer is choosing a bad plan. Users want it fixed (now!) and you know a way to get things working again but you're not allowed to change code because...it's production. What's a good DBA going to do? Show the query optimizer that you're the boss with plan guides! In this session you'll learn what plan guide are, how they work, and when to (and not to) use them to make under-performing queries behave.

SessionID: 50782

Query Zip Documents, CSV Files, and Azure Tables with T-SQL directly.

Back to calendar

Event Date: 18-06-2016 - Session time: 11:00:00 - Track: BI Information Delivery

Speaker: Herve Roggero

Title: Query Zip Documents, CSV Files, and Azure Tables with T-SQL directly.

Abstract:

In this session I will show you how to access multiple data sources (including databases, flat files on FTP sites, Azure Tables and even MySQL) in parallel, all at the same time, using a single T-SQL command, and return data from these data sources into a single output. This allows you to remove complex intermediate processing steps, query multiple data sources without moving data, and get to your information faster. This session introduces you to a project that has been in development for a few years, and is meant to open new doors to data acquisition and analytics. If you deal with importing data in SQL Server from multiple sources, this session is for you.

SessionID: 52359

New Capabilities on top of Microsoft SQL SSAS (Necto)

Back to calendar

Event Date: 18-06-2016 - Session time: 12:30:00 - Track: BI Information Delivery

Speaker: Yoav Yetinson

Title: New Capabilities on top of Microsoft SQL SSAS (Necto)

Abstract:

We will speak about the current BI Market, current BI trends and we will explain how the capabilities of Necto on top of the Microsoft SQL SSAS are a game changer for the BI market and specially for the Microsoft segment.

SessionID: 52372

Database Use Cases: When to utilize an All Flash Array (Kaminario

Back to calendar

Event Date: 18-06-2016 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Olivier Renard

Title: Database Use Cases: When to utilize an All Flash Array (Kaminario

Abstract:

You've used every database trick you know and the latencies and user experience are still unacceptable. Now what?

Join Kaminario as we discuss a number of Use Cases where helped clients database challenges by deploying a cost effective All Flash Array (AFA).

SessionID: 52387

SSIS Factory (Dobler Consulting)

Back to calendar

Event Date: 18-06-2016 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jemini Joseph

Title: SSIS Factory (Dobler Consulting)

Abstract:

Assume that you want to create packages to load 100's files (text or Excel) that you receive from vendors and structure of data in the files are different. How long it can take? How about creating a simple tool for your manager who doesn't know anything about SSIS to create packages for transferring data between servers? You want to find out which package, among 100's of them already running, update/insert a particular table . How long it will take to open each package and get the answer?

We can automate all these process using C# (or Visual Basic) and SSIS SDK. Can it be more interesting if the conversion of those 2008 packages to 2012/2014 and deploy it to the new SSISDB using project deployment model can be automated too? If you are an SSIS expert with some knowledge of programming and like automation, you will have fun in this session.

SessionID: 52442

Easily optimize and tune SQL Server performance anywhere on any device!

Back to calendar

Event Date: 18-06-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Gordon Cornelius

Title: Easily optimize and tune SQL Server performance anywhere on any device!

Abstract:

Come see Dell Software’s premier SQL Server diagnostics solutions Spotlight. Spotlight can ensure peak performance around the clock with unmatched monitoring, diagnosis and optimization of SQL Server environments. Come learn how Spotlight can provide intuitive overviews of performance health, automated alerts with actions, and mobile device support. Everyone who attends will also receive a free 3 month license of the solution!

SessionID: 52454

Transform SQL Server (by Pureshare)

Back to calendar

Event Date: 18-06-2016 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Robert Torres

Title: Transform SQL Server (by Pureshare)

Abstract:

Please join the local Pure Storage account team for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage FlashArray helps your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally a storage array you can love to use, and be proud to own! Come see what the fuss is all about.

SessionID: 52485

Building a Better Mousetrap: Using Cisco UCS for SQL Server Deployments

Back to calendar

Event Date: 18-06-2016 - Session time: 12:30:00 - Track: Application Database Development

Speaker: Ed Cho

Title: Building a Better Mousetrap: Using Cisco UCS for SQL Server Deployments

Abstract:

Learn how Cisco and Microsoft's strategic partnership has led to the creation of a powerful joint solution-MSFT SQL Server on Cisco UCS-to help companies migrate their SQL Server workloads to 2014/2016 versions.

SessionID: 46099

Advancements in Azure SQL Database

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Pankaj Satyaketu

Title: Advancements in Azure SQL Database

Abstract:

In this session we will review our database as a service offering, Azure SQL Database. We will also recap and demo the recent advancements such as Threat Detection, Query Performance Insight, Query Store, Database Index Advisor and more.

SessionID: 49989

Architecting virtual SQL server for performance

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Niran Even-Chen

Title: Architecting virtual SQL server for performance

Abstract:

Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications.

Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the author of the official SQL server on VMware best practices guide.

SessionID: 50118

Myths and Truths about SQL Server Transaction

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Simon Cho

Title: Myths and Truths about SQL Server Transaction

Abstract:

This session is well suited for DBAs and Developers who are constantly exposed to production environment because the session covers the common issues many neglect without recognizing.

We demonstrate examples of incorrect development methodologies and analyze internal transaction logs in multi-transaction cases. After identifying the common mistakes, we will cover the best practice to avoid nested transactions in a stored procedure for smart error handling. We will also learn the basics of minimally logged operations.

SessionID: 50181

Using Common Table Expressions (CTE)

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Ben Galluzzo

Title: Using Common Table Expressions (CTE)

Abstract:

Common Table Expressions (CTE) are a temporary result set used within an SQL statement, such as SELECT, INSERT, UPDATE, or DELETE, that can be used in place of a subquery and can help simplify more complex queries such as when joining to the same result set multiple times.

We'll begin with an overview of how a Common Table Expression is constructed. Then we'll build some queries using derived tables, and as the queries we build get more unwieldy, demonstrate how the query can be simplified by the use of a CTE.

SessionID: 50189

Scaling for best performance: Partitioned views.

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Konstantin Melamud

Title: Scaling for best performance: Partitioned views.

Abstract:

Partitioning has long been one of the key feature sets utilized to improve performance or reduce contention within our large tables in SQL Server. However, table partitioning has been solely the prerogative of SQL Server Enterprise edition. Even though that is correct, there are techniques available to us in Standard edition which would accomplish the same result as table partitioning.

In this session we will go through the steps needed to configure and use the partitioned views to achieve the same result as table partitioning. We will also configure the maintenance jobs to imitate the sliding window functionality, and for those of us who are lucky to have Enterprise edition, we will see how to be able to take advantage of combining both partitioned views and table partitioning as well as inMemory tables to give us an ability to use double partition elimination based on two different keys as well as the ability to move hot spots data into inMemory OLTP.

SessionID: 50240

Becoming Certified in SQL Server 2012/2014

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: Professional Development

Speaker: Marilyn Rousseau

Title: Becoming Certified in SQL Server 2012/2014

Abstract:

Becoming certified in SQL Server is a great career move and can be very rewarding for a new or seasoned database professional. This session will provide you with an overview of the SQL Server Certification program, including the changes made to the program for certification on SQL Server 2012 and 2014. You’ll also discover the benefits of becoming certified, and some of the best ways in which to do so. You’ll leave the session armed with great tips and tricks to pass the exams on the first try. If you are thinking about getting certified in SQL Server in the near future, then this session is definitely for you.

SessionID: 50598

A SQL Developer’s Guide to MDX Basics

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: A SQL Developer’s Guide to MDX Basics

Abstract:

You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL.

In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel, SQL Server Management Studio and other third party tools, to use as practical examples of how to write MDX queries.

SessionID: 50786

SQL Server 2014 Column Store Index vNEXT

Back to calendar

Event Date: 18-06-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: SQL Server 2014 Column Store Index vNEXT

Abstract:

The Column Store Index functionality released in SQL 2012 did allow for stunning performance gains for OLAP-style queries, but as a v1.0 release it suffered from a number of caveats, limitations, provisos, etc. The one BIGGIE was that it made it's underlying table NON-UPDATABLE. Well, that often implementation-killing restriction has been addressed, along with a huge number of other fixes and enhancements. We will cover what those are and also see actual usage with some nice demos.

SessionID: 48700

For Love or Money, Your I.T. Career

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: Other

Speaker: Alex Funkhouser

Title: For Love or Money, Your I.T. Career

Abstract:

• Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?

• Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are using the latest, most marketable technologies?
In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career.

SessionID: 49434

SSAS The Primer... Or How I Learned to Love the Cube!

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Alexander Nykolaiszyn

Title: SSAS The Primer... Or How I Learned to Love the Cube!

Abstract:

A Primer for SSAS for those who know of SSAS but not what SSAS is and why we use it.

In this session we will answer: What are Cubes? Why do we Use Them? Is it the Right Tool For the Job? What Makes a Cube a Cube? How do they work? and any general questions or perspectives around SSAS.

SessionID: 50144

Who's Afraid of Entity Framework?

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Richie Rump

Title: Who's Afraid of Entity Framework?

Abstract:

Do any applications in your environment use SQL written not by a person but by the application itself? No, the system isn't self-aware. Chances are it is using the Microsoft Entity Framework (EF).

EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it's changed over time. We'll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we'll review EF-generated T-SQL and give some tips on how to improve performance. If you're a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.

SessionID: 50247

SQL Server Disaster Recovery and High Availability Overview

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kendal Van Dyke

Title: SQL Server Disaster Recovery and High Availability Overview

Abstract:

When it comes to disaster recovery and high availability with SQL Server, there are a lot of options. Most business owners (and many DBAs) lump disaster recovery (DR) and high availability (HA) together. And while they do share some pieces, they also call for different strategies. Should you use one or more of these options? And what criteria should you use to make the choice? It’s important that you understand the decision tree that can guide you to select the right option(s) for your organization and that you can clearly explain those choices to the stakeholders. It’s not as complicated as it sounds, but it is complicated. This session will give you a high-level understanding of the options, their costs and complexities, and reasons for using each of them.

SessionID: 50579

Power BI – Exploring New Frontiers

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Pam Shaw

Title: Power BI – Exploring New Frontiers

Abstract:

Everyone is eager to get started with Microsoft’s new offering: Power BI. It promises to be a great delivery system of information and analytics. This session will show some tips and tricks to getting started fast and deliver some real WOW factor to your users. We will explore bringing in data, enhancing it, and then displaying it. We will look at how to work with the standard visualizations as well as a few custom visualizations. We will discuss publishing options to allow us to show off our work. Come join the fun and see why there is so much ado about Power BI.

SessionID: 50790

Introduction to Unit-Testing in SQL Server

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Sebastian Meine

Title: Introduction to Unit-Testing in SQL Server

Abstract:

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.

SessionID: 51135

Analytical Computing Device to Cloud and Back Again

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: David Crook

Title: Analytical Computing Device to Cloud and Back Again

Abstract:

Today we live in a world where quad core cell phones is becoming a common theme. Cloud computing is cheap and the services are advanced. The sheer quantity of services can blow your mind. This talk goes through how to deliver product where intelligence is at the core of the product. We will cover building intelligence into the device, retrieving data from the device, analyzing it in the cloud and then surfacing important insights back into the device.

SessionID: 52520

Traveling through the 4th Dimension with T-SQL and PowerBI

Back to calendar

Event Date: 18-06-2016 - Session time: 14:45:00 - Track: Advanced Analysis Techniques

Speaker: Rodney Landrum

Title: Traveling through the 4th Dimension with T-SQL and PowerBI

Abstract:

Time. We are all cursed and blessed with it. We run out of it, often need more of it, sometimes forget it but are always keeping track of it. In this session, we will delve into the functions provided in T-SQL and PowerBI to demonstrate how to solve both simple and complex problems with time and dates for your reports and dashboards. Ever wondered what is so special about 01/01/1900 and what will happen on January 1, 10,000? Do you want to know how to find gaps in time between systems or forecast the future? Are you interested to know how to accurately tally hours from minutes (it may not be as easy as you thought), then this session will not be a waste of your time.

SessionID: 48949

The Ins and Outs of SQL Indexes

Back to calendar

Event Date: 18-06-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: The Ins and Outs of SQL Indexes

Abstract:

This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

SessionID: 50095

How SQL is helping to connect Cuba to the Web for free

Back to calendar

Event Date: 18-06-2016 - Session time: 16:00:00 - Track: Analytics and Visualization

Speaker: Salvi Pascual

Title: How SQL is helping to connect Cuba to the Web for free

Abstract:

Salvi works on a non-profit that connects thousands of Cubans to the web, via email. In Cuba, 25% of the population can access to email only, while 5% access to the Web without restrictions. After three years of work, his non-profit organization has collected several gigs of data that can re-shape our understanding about Cuba.

Salvi will show data collected by this great technology, and how fascinating can be interpreting row information from a country that has been censored internally and externally for generations . The audience will have a unique opportunity to learn this technology, access this data and to use their skills to make a worldwide impact.

SessionID: 50180

MongoDB for SQL Developers and Accessing MongoDB with SSIS

Back to calendar

Event Date: 18-06-2016 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Ben Galluzzo

Title: MongoDB for SQL Developers and Accessing MongoDB with SSIS

Abstract:

Just because NoSQL is taking off doesn't mean that SQL developers are left behind. We'll begin with an overview of what MongoDB and NoSQL is and how it relates to our existing world of SQL. Then, we'll go over some of terminology in MongoDB and how these terms map to the SQL world. Lastly, we'll demonstrate how we can work with MongoDB from SSIS.

SessionID: 51136

SQL Speaker Idol

Back to calendar

Event Date: 18-06-2016 - Session time: 16:00:00 - Track: Professional Development

Speaker: Diana Betancourt

Title: SQL Speaker Idol

Abstract:

If you've ever enjoyed or admired the knowledge and know-how of a speaker at an event like this, remember that they started where you are, with an interest in SQL and I.T. topics, a passion to learn more, but also with the desire to share what they know with their peers. If you have an interest in SQL or any of the Data platform technologies, and have learned something useful in your I.T. career, consider giving back to the community by sharing what you know. While it may seem intimidating to give an hour long talk at an event like this, remember that every great speaker had to start somewhere. And for you, maybe that start is Speaker idol. Speaker Idol is a friendly competition for anyone, even first time speakers, to share for 5 - 10 minutes on a technical topic, SQL or otherwise, that is informative, useful and engaging. This is a great way to get experience presenting a technical topic to the community, and a great way to find and develop the next generation of speakers!

This site is open source. Improve this page.