sqlsathistory

Nr: 518

Back to Main list

SQLSaturday #518 - Maine 2016

Start Time (24h) Speaker Track Title
08:45:00 Steve Simon Application Database Development Efficient and Effective coding of Stored Procedures
08:45:00 Thomas Norman Cloud Application Development Deployment Beginning Azure
08:45:00 Chris Seferlis BI Platform Architecture, Development Administration Scratching the Surface: Designing your first Power View Report
08:45:00 Ravi Kumar BI Platform Architecture, Development Administration What Makes SSIS Tick? A Look at Internals for Performance
08:45:00 Justin Randall Enterprise Database Administration Deployment Putting the Squeeze on Large Tables: Improve Performance and Save Space with Data Compression
10:00:00 George Walters Enterprise Database Administration Deployment Organizational Security Compliance with SQL 2012 through 2016
10:00:00 Edward Pollack Performance Database Design: Solving Problems Before they Start!
10:00:00 Bryan Cafferky Analytics and Visualization Introduction to R Programming
10:00:00 Paresh Motiwala BI Platform Architecture, Development Administration SQL 2016 Upgrade as a Project
10:00:00 George Walkey Enterprise Database Administration Deployment Using Powershell to Document SQL Server
10:00:00 David Klee Enterprise Database Administration Deployment Virtual SQL Servers. Actual Performance.
11:15:00 Thomas Grohser Enterprise Database Administration Deployment Optimizing SQL Server and Databases for large Fact Tables
11:15:00 David Benoit Strategy and Architecture An Introduction To Big Data For The SQL Server DBA
11:15:00 Ben Miller Enterprise Database Administration Deployment PoshDBA: Practical PowerShell for the DBA
11:15:00 Kevin Feasel Application Database Development APPLY Yourself
11:15:00 Josef Richberg BI Platform Architecture, Development Administration Unseen Minions: Improving Parallel Processing in SSIS
12:30:00 Sayed Saeed BI Information Delivery The Business Intelligence Side of SQL Server
12:30:00 Argenis Fernandez Strategy and Architecture SQL Server and Pure Storage: Redefining Database Engineering
13:45:00 Mike Hillwig Enterprise Database Administration Deployment Maintenance Plans: Planning to Fail
13:45:00 Meagan Longoria BI Platform Architecture, Development Administration Building your ETL Framework with Biml
13:45:00 Chris Lumnah Enterprise Database Administration Deployment Taking the pain out of database migrations
13:45:00 Andy Roberts Advanced Analysis Techniques SQL Server 2016 R Integration - how do I do it and why would I want to??
13:45:00 Aaron Bertrand Application Database Development New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database
15:00:00 Dan Clark Cloud Application Development Deployment Azure Machine Learning – Bringing Advanced Analytics to the Masses
15:00:00 Ben Miller Application Database Development Be Friendly to SQL Server with TSQL Best Practices
15:00:00 Sunil Kadimdiwan BI Information Delivery SSRS 2016 - End-to-end Mobile BI on any device
15:00:00 Andrew Kelly Performance The Art of War with Bad Code
15:00:00 Bob Pusateri Enterprise Database Administration Deployment Introduction to SQL Server Encryption
15:00:00 Andrzej Pilacik Enterprise Database Administration Deployment Refresh a 1TB+ database in under 10 seconds

SessionID: 45151

Efficient and Effective coding of Stored Procedures

Back to calendar

Event Date: 04-06-2016 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Steve Simon

Title: Efficient and Effective coding of Stored Procedures

Abstract:

Data does not become information until decision makers are able to view it and make those decisions that affect the enterprise as a whole. Stored procedures are one means of getting the data from the database tables to the reports in an effective and efficient manner.

In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.

SessionID: 45830

Beginning Azure

Back to calendar

Event Date: 04-06-2016 - Session time: 08:45:00 - Track: Cloud Application Development Deployment

Speaker: Thomas Norman

Title: Beginning Azure

Abstract:

The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let's put SQL Server into the cloud!

SessionID: 45965

Scratching the Surface: Designing your first Power View Report

Back to calendar

Event Date: 04-06-2016 - Session time: 08:45: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: 46389

What Makes SSIS Tick? A Look at Internals for Performance

Back to calendar

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

Speaker: Ravi Kumar

Title: What Makes SSIS Tick? A Look at Internals for Performance

Abstract:

You can build basic SSIS packages, or you can build packages that perform. In this session, you'll learn about the internals of Integration Services. Using this knowledge, we'll review the DOs and DON'Ts that lead to improved ETL performance. (This session applies to SSIS versions from 2008, 2012, 2014 and 2016.)

SessionID: 46909

Putting the Squeeze on Large Tables: Improve Performance and Save Space with Data Compression

Back to calendar

Event Date: 04-06-2016 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

Title: Putting the Squeeze on Large Tables: Improve Performance and Save Space with Data Compression

Abstract:

Your databases are growing faster than your servers. Large tables consume ever-increasing amounts of storage while putting a drag on query response time. What’s a DBA to do? The data compression feature of SQL Server is one tool DBAs can use to save storage space and improve performance. In this presentation you will learn about the types of data compression, how to determine when compression is the right option, and how to make the magic happen

SessionID: 45161

Organizational Security Compliance with SQL 2012 through 2016

Back to calendar

Event Date: 04-06-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walters

Title: Organizational Security Compliance with SQL 2012 through 2016

Abstract:

You need to deal with more security requirements in your role. How can SQL Server features help you comply? We will delve into Audit, Compliance, and Encryption. New 2016 features like Always Encrypted will be detailed at the end.

SessionID: 45177

Database Design: Solving Problems Before they Start!

Back to calendar

Event Date: 04-06-2016 - Session time: 10:00:00 - Track: Performance

Speaker: Edward Pollack

Title: Database Design: Solving Problems Before they Start!

Abstract:

The most effective form of performance optimization is to design your database correctly the first time around. Explore the most important topics in database design and discuss examples of where design mistakes can lead to bad data, poor performance, and other headaches that your future self would love to avoid!

SessionID: 45200

Introduction to R Programming

Back to calendar

Event Date: 04-06-2016 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Bryan Cafferky

Title: Introduction to R Programming

Abstract:

In this session you will learn the basics of the R programming language. We will cover R syntax and constructs while demonstrating why R is an ideal language for analytics. Then we will delve into the amazing presentation features of R and how easy it is to visualize your data. R is here to stay and growing. Microsoft is adding R support to SQL Server 2016 so don't miss this chance to see why R has become such a phenomena.

SessionID: 46213

SQL 2016 Upgrade as a Project

Back to calendar

Event Date: 04-06-2016 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paresh Motiwala

Title: SQL 2016 Upgrade as a Project

Abstract:

As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects.

In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time. We will use the PMI's approach to a project. We will examine ways to break down the large project into smaller Agile segments. We will look at various documents/forms/reports/steps and phases.

This presentation will lay out this rather complex project into a simple laid out plan.

SessionID: 46593

Using Powershell to Document SQL Server

Back to calendar

Event Date: 04-06-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walkey

Title: Using Powershell to Document SQL Server

Abstract:

Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects.

Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers

SessionID: 51123

Virtual SQL Servers. Actual Performance.

Back to calendar

Event Date: 04-06-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Virtual SQL Servers. Actual Performance.

Abstract:

Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

SessionID: 45139

Optimizing SQL Server and Databases for large Fact Tables

Back to calendar

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

Speaker: Thomas Grohser

Title: Optimizing SQL Server and Databases for large Fact Tables

Abstract:

A session full of demos demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster.

We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.

SessionID: 45315

An Introduction To Big Data For The SQL Server DBA

Back to calendar

Event Date: 04-06-2016 - Session time: 11:15:00 - Track: Strategy and Architecture

Speaker: David Benoit

Title: An Introduction To Big Data For The SQL Server DBA

Abstract:

The boss comes to you and says that he wants to implement big data technologies into your environment. Is this the end of your career with SQL Server? Where do you start learning about this rapidly changing world of big data?

This presentation will answer all those questions, and will introduce you to the concepts that are the driving force behind a move to utilize "big data" technologies. It will introduce you to some of the key vendors and tools that are the most recognized today, which can help get a SQL Server DBA working on these systems very quickly. During the presentation we will cover those scenarios where big data technologies can be helpful, where they really just don't fit, and why.

Finally, there will be an introduction on how Azure is playing a significant role in this move, and how this could potentially benefit you in your environment.

So, come with an open mind, and be prepared to get excited about what a future with big data might hold for you!

SessionID: 45385

PoshDBA: Practical PowerShell for the DBA

Back to calendar

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

Speaker: Ben Miller

Title: PoshDBA: Practical PowerShell for the DBA

Abstract:

Think of all the tools you use in managing your SQL Servers. All those SQL Servers being managed by tools and man that is a lot of clicks. We will show practical scripts and techniques to help you get a handle on all those clicks. Whether you are gathering data or statistics from your SQL Servers or deploying an object to all of them. Configuration items are not excluded from the need for good tools. PowerShell is that tool that will let you get away from all those clicks. Reusable scripts that let you manage all those instances with ease. This session will give you a great start on how to think about admin tasks using PowerShell scripts or modules. Many items are already out there to help you and we will take a good look.

SessionID: 45389

APPLY Yourself

Back to calendar

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

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 45967

Unseen Minions: Improving Parallel Processing in SSIS

Back to calendar

Event Date: 04-06-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Josef Richberg

Title: Unseen Minions: Improving Parallel Processing in SSIS

Abstract:

Some SQL Server Integration Services use cases are too complicated to simply read data from a source and write it to a destination. You could try looking for a third-party framework or components to help, but then again, you might just need to add some knowledge. This session is designed to help you maximize the parallel processing capabilities of SSIS.

We’ll cover in detail alternative methods of managing large workloads by using traditional programming methods, including named pipes, queues, and producers/consumer architecture – all from within SSIS itself. We'll then cover methods of dividing workloads and preventing bottlenecks, as well as techniques to improve the resource efficiency of SSIS.

SessionID: 48126

The Business Intelligence Side of SQL Server

Back to calendar

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

Speaker: Sayed Saeed

Title: The Business Intelligence Side of SQL Server

Abstract:

This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.

SessionID: 48766

SQL Server and Pure Storage: Redefining Database Engineering

Back to calendar

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

Speaker: Argenis Fernandez

Title: SQL Server and Pure Storage: Redefining Database Engineering

Abstract:

Please join SQL Server MVP and MCM Argenis Fernandez 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: 45157

Maintenance Plans: Planning to Fail

Back to calendar

Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hillwig

Title: Maintenance Plans: Planning to Fail

Abstract:

SQL Server MVP Mike Hillwig hates using maintenance plans. He believes they don't scale well and frequently lack flexibility. Maintenance plans are easy to set up and deploy. Deploying them to many servers is cumbersome. Modifying them on multiple servers at once is an exercise in futility.

The dirty little secret is that anything you can do with a maintenance plan can be done with T-SQL. And by leveraging several community-based solutions, you can accomplish anything without maintenance plans.

SessionID: 45303

Building your ETL Framework with Biml

Back to calendar

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

Speaker: Meagan Longoria

Title: Building your ETL Framework with Biml

Abstract:

Biml makes SSIS development faster and creates reusable modules that help you apply a consistent ETL framework across solutions. In this session, we will review some Biml basics and how to use it to build an SSIS package. You'll see how Biml allows you to avoid corrupted metadata and the tedious repetition of implementing simple SSIS patterns, freeing you up to take on new and interesting ETL challenges. Then we will review how to use it to create a consistent and extensible ETL framework that benefits everyone who creates or supports your SSIS projects.

SessionID: 45317

Taking the pain out of database migrations

Back to calendar

Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Lumnah

Title: Taking the pain out of database migrations

Abstract:

Database migrations are scary. The migration of a database has many moving pieces and things to think about. Some of those things have nothing to do with the DBA and are outside of their control. However, if these items are not taken into account, it is the DBA that management will hold responsible for the failure.

This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.

SessionID: 45324

SQL Server 2016 R Integration - how do I do it and why would I want to??

Back to calendar

Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Advanced Analysis Techniques

Speaker: Andy Roberts

Title: SQL Server 2016 R Integration - how do I do it and why would I want to??

Abstract:

In SQL Server 2016 we introduce language extension so that you can execute R scripts from within the SQL Server database engine. In this session I will go over the basics of setting up and executing this functionality, discuss the types of problems that you can solve with it, and when you might want to avoid it.

SessionID: 45660

New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database

Back to calendar

Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Aaron Bertrand

Title: New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database

Abstract:

Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS / DECOMPRESS, from AT TIME ZONE to DATEDIFF_BIG(), and from SESSION_CONTEXT() to new query hints like NO_PERFORMANCE_SPOOL and MIN / MAX_GRANT_PERCENT, as well as some other surprises, you’ll walk away with a long list of reasons to consider upgrading to the latest version or finally trying out Azure SQL Database.

SessionID: 45182

Azure Machine Learning – Bringing Advanced Analytics to the Masses

Back to calendar

Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Dan Clark

Title: Azure Machine Learning – Bringing Advanced Analytics to the Masses

Abstract:

While Machine Learning is not new, it has never been easy to implement. Azure Machine Learning (AML) aims to provide a set of tools that are easier to use and once a model is created easier to consume by client applications. At the core of AML is ML Studio. ML Studio provides an easy to use graphical tool that allows you to control the process from pre-processing the data, to applying learning algorithms, testing the model, and finally deploying the model for use by client applications. This session guides you through the process of creating and deploying a ML model. In addition it will demonstrate how client applications can easily use the model once it is deployed.

SessionID: 45383

Be Friendly to SQL Server with TSQL Best Practices

Back to calendar

Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Ben Miller

Title: Be Friendly to SQL Server with TSQL Best Practices

Abstract:

TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.

SessionID: 45704

SSRS 2016 - End-to-end Mobile BI on any device

Back to calendar

Event Date: 04-06-2016 - Session time: 15:00:00 - Track: BI Information Delivery

Speaker: Sunil Kadimdiwan

Title: SSRS 2016 - End-to-end Mobile BI on any device

Abstract:

Significant enhancements have been made to mobile BI reporting in SSRS 2016. We can now enable users to get business insights, anyway, anywhere and from any device. Your device could be a tablet, smartphone or laptop, which could be running under iOS, Android or Windows.

Come to this interactive session and learn how you can do it.

SessionID: 47455

The Art of War with Bad Code

Back to calendar

Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Performance

Speaker: Andrew Kelly

Title: The Art of War with Bad Code

Abstract:

Let’s face it, many of us are at war with poorly written or poorly tuned queries and processes. There is usually just one of you who has been tasked with managing one or more SQL Server instances while there are hundreds or even thousands of users of which a certain percentage will inevitably write poor code. So you must battle it out to identify the culprits before they wreak too much havoc on your systems. We will see several fairly straightforward techniques to positively identify the culprits and allow you to prioritize your efforts in tuning them to give you the biggest ROI for your time. TSQL and Extended Events code examples will be provided that you can use immediately in your environment to become more productive.

SessionID: 47486

Introduction to SQL Server Encryption

Back to calendar

Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Pusateri

Title: Introduction to SQL Server Encryption

Abstract:

High-profile attacks by hackers have made the news more and more the past few years, and your database is a prized target! Fortunately SQL Server offers many possible layers of protection, one of which is encryption. This session will cover SQL Server's encryption capabilities, how they work, and what they have to offer. Topics discussed will include certificates, encryption algorithms, backup encryption, transparent database encryption, and column-level encryption. Attend this session and learn how SQL Server can help you hide your data in plain sight!

SessionID: 48138

Refresh a 1TB+ database in under 10 seconds

Back to calendar

Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrzej Pilacik

Title: Refresh a 1TB+ database in under 10 seconds

Abstract:

The presentation covers recoverability options in SQL Server over time. It will take us through many different ways of recovering a large 1TB+ database. It will also walk us through many different options for creating development/test/uat environments. It will highlight the benefits and shortcomings of these options while delivering a business value of each. It will also evaluate a high level ROI of each of these options.

Finally, the presentation will focus on an architecture based on SAN technologies with respect to SQL Server. I will demonstrate an architecture put in place resolving many business needs in a financial trading environment, working with large data sets and many different environments. This section will highlight the benefits of using SQL Server together with newer SAN solutions and show the potential for reliability, scalability, and the delivery of a high quality HA/DR solution. That is where things get interesting...