sqlsathistory

Nr: 465

Back to Main list

SQLSaturday #465 - Providence 2015

Start Time (24h) Speaker Track Title
09:00:00 James Serra Strategy and Architecture Building a Big Data Solution
09:00:00 Andy Tabisz Application Database Development Creating Access 2013 Web Apps in SharePoint with SQL Azure
09:00:00 Andy Mallon Professional Development Shortcuts from an Impatient DBA
09:00:00 Bryan Cafferky Application Database Development SSIS 2012/2014: The Quiet Revolution
09:00:00 Tim Gorman Enterprise Database Administration Deployment Accelerating DevOps Using Data Virtualization
10:15:00 Jack Corbett Application Database Development What about the Data Dude? SSDT Database Projects
10:15:00 Sunil Kadimdiwan BI Platform Architecture, Development Administration Stunning Dashboards using Datazen
10:15:00 Chris Seferlis BI Platform Architecture, Development Administration Scratching the Surface: Designing your first Power View Report
10:15:00 Ray Kim Professional Development Whacha just say? Talking technology to non-technical people
10:15:00 Thomas LaRock Enterprise Database Administration Deployment Cardinality Estimates in Microsoft SQL Server 2014
10:15:00 Michael DeFehr Application Database Development Index-fu - getting the most out of your indexes
11:15:00 George Walters Cloud Application Development Deployment Hybrid Cloud Scenarios with SQL Server 2014 and 2016
11:15:00 Michael Nowill BI Platform Architecture, Development Administration Data Partitioning - Doing the splits…in the name of performance, scalability and sanity!
11:15:00 John Flannery Application Database Development What the Hekaton
11:15:00 Bryan Cafferky Application Database Development Advanced Programming in PowerShell
11:15:00 John Miner BI Platform Architecture, Development Administration Power BI Desktop Designer
13:15:00 Edward Pollack Enterprise Database Administration Deployment Diving Into Query Execution Plans
13:15:00 Thomas Grohser Enterprise Database Administration Deployment Automated Installing and Configuration of SQL2014/SQL2012 AlwaysOn Across Multiple Datacenters
13:15:00 Todd Chittenden BI Information Delivery Create a Power BI Dashboard in 90 Minutes or LESS
13:15:00 David Klee Enterprise Database Administration Deployment Right-Sizing Your SQL Server Virtual Machine
13:15:00 John Deardurff Application Database Development Batches, Transactions, and Errors
13:15:00 Andrew Novick Application Database Development 100 Times Faster: Experiences making SQL Server go fast
15:30:00 Stephen Archbold Enterprise Database Administration Deployment Getting the most from your SAN - File and Filegroup design patterns
15:30:00 Paresh Motiwala BI Platform Architecture, Development Administration Managing Copy Data for BI
15:30:00 Brandon Leach Enterprise Database Administration Deployment Data Pages, Allocation Units, IAM chains... Oh My!
15:30:00 Matt Batalon BI Platform Architecture, Development Administration Dissecting the Data Flow: SSIS Transformations, Memory the Pipeline
15:30:00 Tom Anderson Other Can the IT Job Market get any Hotter? Navigating Your Career Sea
15:30:00 Greg Celentano BI Platform Architecture, Development Administration SSRS Troubleshooting Tips

SessionID: 38973

Building a Big Data Solution

Back to calendar

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

Speaker: James Serra

Title: Building a Big Data Solution

Abstract:

As a follow-on to the presentation “Building an Effective Data Warehouse Architecture”, this vendor-free presentation will explain exactly what Big Data is and its benefits, including use cases. We will discuss how Hadoop, the cloud and massively parallel processing (MPP) is changing the way data warehouses are being built. We will talk about hybrid architectures that combine on-premise data with data in the cloud as well as relational data and non-relational (unstructured) data. We will look at the benefits of MPP over SMP and how to integrate data from Internet of Things (IoT) devices. You will learn what a modern data warehouse should look like and how the role of a Data Lake and Hadoop fit in. The Big Data boom brings new challenges to those of you who define the architectures to create and consume business-critical data. You will need guidance on the best solution for your data warehouse going forward. This presentation will help to give you that guidance!

SessionID: 38997

Creating Access 2013 Web Apps in SharePoint with SQL Azure

Back to calendar

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

Speaker: Andy Tabisz

Title: Creating Access 2013 Web Apps in SharePoint with SQL Azure

Abstract:

Access 2013 web apps are fully integrated with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data using Access or other applications, including mobile. In this session you will learn how to easily create an Access Web App with automatic views, view the online development environment and see a live, production web app in action. We’ll also discuss different ways of extending web apps through the use of hybrid applications and integrating office web apps and the best ways to utilize Access Web Apps within your organization.

SessionID: 40676

Shortcuts from an Impatient DBA

Back to calendar

Event Date: 12-12-2015 - Session time: 09:00:00 - Track: Professional Development

Speaker: Andy Mallon

Title: Shortcuts from an Impatient DBA

Abstract:

This session is about performance tuning your day.

We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient at writing code. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier.

SessionID: 41083

SSIS 2012/2014: The Quiet Revolution

Back to calendar

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

Speaker: Bryan Cafferky

Title: SSIS 2012/2014: The Quiet Revolution

Abstract:

The SQL Server 2012 release of SSIS was a complete game changer. Using sample packages, we'll show you how to deploy projects to the new SSIS catalog. You will see how project level parameters and connection managers can make your life easier. You will learn how to configure packages using the new configuration editor in SSMS. We'll show you how to define a collection of configuration settings called an Environment which can automatically configure packages deployed to a server. Find out why SQL Agent no longer captures SSIS errors in the log and how you can get information about failed packages. Get up to speed on using the latest features of SSIS to make you job easier.

SessionID: 41258

Accelerating DevOps Using Data Virtualization

Back to calendar

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

Speaker: Tim Gorman

Title: Accelerating DevOps Using Data Virtualization

Abstract:

DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.

Constraining DevOps is data. Databases and applications have grown enormous and complex. "Storage is cheap" is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.

Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality. Learn about the technical details behind this solution.

SessionID: 38987

What about the Data Dude? SSDT Database Projects

Back to calendar

Event Date: 12-12-2015 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Jack Corbett

Title: What about the Data Dude? SSDT Database Projects

Abstract:

For years the database has been treated as a second class citizen when it comes to source, change, and version control, often thought of as a dumb data store. Microsoft first addressed this with Visual Studio Team System 2008 Database Edition, aka "Data Dude". After the release of Visual Studio 2012, Microsoft pulled the database project out of Visual Studio and created SQL Server Data Tools as separate, free to SQL Server users, install on top of the Visual Studio shell. The database project was updates making managing databases as code much easier and making the database a first class citizen in the code world. We will cover how to create a database project, connect it to source control, and deploy to our database servers.

SessionID: 39428

Stunning Dashboards using Datazen

Back to calendar

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

Speaker: Sunil Kadimdiwan

Title: Stunning Dashboards using Datazen

Abstract:

Datazen is one of the newest additions to Microsoft BI offerings. Allows you to develop Dashboards, KPIs and Maps. You can either use them locally or publish them to a Datazen server. Viewing and interactivity capabilities is then possible on any device; Laptop, Phone, or Tablet based on iOS, Android or Windows. Experience and interactivity is exactly the same on all of them.

In this session I will demonstrate the power and ease of using this technology

SessionID: 39711

Scratching the Surface: Designing your first Power View Report

Back to calendar

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

Speaker: Chris Seferlis

Title: Scratching the Surface: Designing your first Power View Report

Abstract:

Dashboards have quickly become a cornerstone for decision-making by managers and business leaders in all facets of corporate operations. Microsoft Power View has enabled drastic improvements in the development of dynamic and interactive dashboards within the Microsoft SQL Stack. In this session, we will cover areas such as: Data Considerations; Deployment Options; Building your first report; and using some of the interactive features of Power View.

SessionID: 40203

Whacha just say? Talking technology to non-technical people

Back to calendar

Event Date: 12-12-2015 - Session time: 10:15:00 - Track: Professional Development

Speaker: Ray Kim

Title: Whacha just say? Talking technology to non-technical people

Abstract:

Many tech professionals are faced with the challenge of explaining technical concepts to people who don't understand technology. And only a few are able to do it well. This session provides some strategies and suggestions to go about bridging the technological knowledge gap. With time and practice, a technical person can serve as an effective interpreter of technical concepts. This is an interactive session; audience participation is expected and encouraged!

SessionID: 40464

Cardinality Estimates in Microsoft SQL Server 2014

Back to calendar

Event Date: 12-12-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas LaRock

Title: Cardinality Estimates in Microsoft SQL Server 2014

Abstract:

SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.

SessionID: 41525

Index-fu - getting the most out of your indexes

Back to calendar

Event Date: 12-12-2015 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Michael DeFehr

Title: Index-fu - getting the most out of your indexes

Abstract:

So you know the difference between a clustered and a nonclustered index. I won't review it again - I promise. This session will focus on expanding your understanding of indexes and what you can use them for. We will look at the internals of how they are structured, included columns, filtered indexes and indexed views. We will explore how to use indexes to enforce contraints beyond just simple uniqueness. Earn your SQL Black belt with this fun and informative session.

SessionID: 38949

Hybrid Cloud Scenarios with SQL Server 2014 and 2016

Back to calendar

Event Date: 12-12-2015 - Session time: 11:15:00 - Track: Cloud Application Development Deployment

Speaker: George Walters

Title: Hybrid Cloud Scenarios with SQL Server 2014 and 2016

Abstract:

SQL 2014 and 2016 have significant changes to allow seamless hybrid cloud scenarios. This session will talk about "why cloud" as well as the options available with backup, deployment, and new development scenarios with SQL 2014, 2016, and Azure.

SessionID: 39128

Data Partitioning - Doing the splits…in the name of performance, scalability and sanity!

Back to calendar

Event Date: 12-12-2015 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Michael Nowill

Title: Data Partitioning - Doing the splits…in the name of performance, scalability and sanity!

Abstract:

Does only a small portion of your data change on a routine basis? Is index maintenance taking forever? Do users mostly focus only on a subset of data such as the current year, month or day? Do you want to delete or insert massive amount s of data with almost no blocking? Well, step right up because data partitioning can do all this and more! We will take a look at the different option for partitioning, the pros and cons and how to implement them in SQL.

SessionID: 40864

What the Hekaton

Back to calendar

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

Speaker: John Flannery

Title: What the Hekaton

Abstract:

In SQL Server 2014 – Microsoft introduced In-Memory OLTP. (Formally known as project Hekaton.) In this session – we will introduce this technology, optimize an existing AdventureWorks stored procedure to use In-Memory OLTP, and discuss other applications such as ETL.

SessionID: 41082

Advanced Programming in PowerShell

Back to calendar

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

Speaker: Bryan Cafferky

Title: Advanced Programming in PowerShell

Abstract:

PowerShell is the hottest new Microsoft technology and you need to know it. Assuming a basic knowledge of PowerShell, this session will focus on advanced topics like creating modules, advanced functions, creating custom PowerShell objects, creating a GUI for your scripts, application automation and much more. Many code examples will be examined to show you how to apply the concepts. This is the presentation to attend to step up your game.

SessionID: 41833

Power BI Desktop Designer

Back to calendar

Event Date: 12-12-2015 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: John Miner

Title: Power BI Desktop Designer

Abstract:

Microsoft just released The Power Business Intelligence Desktop Designer. Learn how X-Velocity uses super compression to query data faster than ever. See how Power Query can access virtually any data anywhere turning it into business information. Discover how disparate data can be conceptualized into a single business view. New visualization technology brings all this together to see your business like never before.

SessionID: 38881

Diving Into Query Execution Plans

Back to calendar

Event Date: 12-12-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Edward Pollack

Title: Diving Into Query Execution Plans

Abstract:

There is no better way to understand how TSQL is executing than through the execution plan. We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performance. Be sure to bring your safety helmet!

SessionID: 39271

Automated Installing and Configuration of SQL2014/SQL2012 AlwaysOn Across Multiple Datacenters

Back to calendar

Event Date: 12-12-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: Automated Installing and Configuration of SQL2014/SQL2012 AlwaysOn Across Multiple Datacenters

Abstract:

Tired of watching progress bars and waiting for servers to reboot while you follow run books on how to install SQL Server. This session teaches you how to automate the whole process of installing a Windows Server (Core Installation), Install SQL Server, setup Clustering and configure an AlwaysOn availability groups.

The whole process is presented as a life demo

SessionID: 39317

Create a Power BI Dashboard in 90 Minutes or LESS

Back to calendar

Event Date: 12-12-2015 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Todd Chittenden

Title: Create a Power BI Dashboard in 90 Minutes or LESS

Abstract:

Power BI is quickly outpacing Excel as the one tool needed for self-service Business Intelligence. In this session we'll walk through Microsoft's exciting new Power BI SaaS offering, creating some Reports and Dashboards along the way. We'll explore some of the ready-made content packs for major SaaS providers such as Salesforce or Google Analytics, then create our own based on an Azure SQL Database. Next, we'll explore Power BI Desktop, a powerful new tool for creating advanced analytic data models and authoring reports using familiar experiences from the best of Excel's BI components. Finally, we'll deploy the reports to Power BI, extend and share our Dashboard, and configure Automatic Data Refresh. All inside 90 minutes! Don't miss this session on the cutting edge of Microsoft's self-service Business Intelligence offering.

SessionID: 40313

Right-Sizing Your SQL Server Virtual Machine

Back to calendar

Event Date: 12-12-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Right-Sizing Your SQL Server Virtual Machine

Abstract:

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

SessionID: 41016

Batches, Transactions, and Errors

Back to calendar

Event Date: 12-12-2015 - Session time: 13:15:00 - Track: Application Database Development

Speaker: John Deardurff

Title: Batches, Transactions, and Errors

Abstract:

This session is an introduction into 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: 41680

100 Times Faster: Experiences making SQL Server go fast

Back to calendar

Event Date: 12-12-2015 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Andrew Novick

Title: 100 Times Faster: Experiences making SQL Server go fast

Abstract:

How do you go about making a program run a lot faster! Like 100 times faster? It’s difficult. Microsoft tried in the Hekaton project, its in-memory tables feature of SQL 2014, and they got very close. Inspired by that effort, this presentation looks at some recent cases where I’ve been able to achieve huge performance improvements in SQL Server code and how that happens.

When I work on SQL Server performance I emphasize that the first thing to think about is how to accomplish the task in a different way that will be much faster”. Sometimes there’s a better algorithm. Sometimes a different technology is more appropriate. Sometimes it’s a combination of many changes that combine to create the desired outcome much, much faster.

This presentation is illustrated with examples from my work and we'll look for common threads that might help us all.

SessionID: 38897

Getting the most from your SAN - File and Filegroup design patterns

Back to calendar

Event Date: 12-12-2015 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Stephen Archbold

Title: Getting the most from your SAN - File and Filegroup design patterns

Abstract:

You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?

Are your SAN guys telling you your storage can process 2 GB/s but you're only seeing 200 MB/s?

This session will dive into how to optimise your File and Filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customer's table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include:

SessionID: 41086

Managing Copy Data for BI

Back to calendar

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

Speaker: Paresh Motiwala

Title: Managing Copy Data for BI

Abstract:

As BI professionals we are straddled with multiple issues pertaining to Copy Data.

We will discuss what 'Copy Data' is along with various terminologies that go with it.

The common issues are:

  1. Space
  2. Network Bandwidth
  3. Time
  4. Security
  5. Obfuscation/Masking
  6. Which Server does this go to?
  7. Onward protection of Copy Data

In this session we will study the issues above and see how we can avoid these issues. We will examine what technologies/products are available that help us mitigate such a massive problem.

SessionID: 41337

Data Pages, Allocation Units, IAM chains... Oh My!

Back to calendar

Event Date: 12-12-2015 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: Data Pages, Allocation Units, IAM chains... Oh My!

Abstract:

Understanding how SQL Server stores your data can seem like a daunting task. In this session You'll learn how objects such as tables and indexes are stored in a data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map and GAM and SGAM pages. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.

SessionID: 41740

Dissecting the Data Flow: SSIS Transformations, Memory the Pipeline

Back to calendar

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

Speaker: Matt Batalon

Title: Dissecting the Data Flow: SSIS Transformations, Memory the Pipeline

Abstract:

SQL Server Integrations Services is a robust product, with lots of different options available to the ETL developer. For someone new to SSIS, it can be daunting to be assigned a project to extract data from a source, transform it and then load it into its intended destination. What components do I use? Why pick one over another? Even if you are new to SSIS, it's good to have an understanding of what's going on under the hood when a package is run. Come to this session to learn what non-blocking, semi-blocking and fully-blocking transformations are. We'll explore how SSIS creates and manages memory buffers. You'll leave with a better understanding of how certain tasks and transformations can affect your package’s performance.

SessionID: 42300

Can the IT Job Market get any Hotter? Navigating Your Career Sea

Back to calendar

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

Speaker: Tom Anderson

Title: Can the IT Job Market get any Hotter? Navigating Your Career Sea

Abstract:

Are you thinking about making a career change in 2016? If so, this session is for you. Tom will explain the three factors that are required for you to make a career change and get you hired in either a new contract or direct hire role.

After this session, you will understand the mindset you need to make a change and be equipped to find the opportunity you want while increasing your compensation in a field you enjoy.

SessionID: 42842

SSRS Troubleshooting Tips

Back to calendar

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

Speaker: Greg Celentano

Title: SSRS Troubleshooting Tips

Abstract:

Data is everywhere, but it doesn’t do any good if users can’t see and use it efficiently. SQL Server Reporting Services can be that gateway to uncover and open the doors into different data sources. If not configured correctly or unable to recognize bottlenecks it can make for a long, bad, day. Learn some of the basic mechanics of how this SQL Server feature is configured along with some useful tricks to monitor performance,and also learn some ways to solve some common issues.