sqlsathistory

Nr: 585

Back to Main list

SQLSaturday #585 - Boston 2017

Start Time (24h) Speaker Track Title
09:00:00 Steve Simon BI Information Delivery SQL Server Reporting Services 2016 on Steroids!!
09:00:00 George Walters Cloud Application Development Deployment How to rearchitect for Azure SQL database from on-premises SQL Server - Case Study
09:00:00 Thomas Grohser Enterprise Database Administration Deployment Optimizing the SQL Server and Databases for large Fact Tables
09:00:00 Bryan Cafferky Analytics and Visualization An Introduction to Jupyter Notebooks: The Hottest New Analytics
10:10:00 Derik Hammer Enterprise Database Administration Deployment Architecting Availability Groups
10:10:00 Sunil Kadimdiwan Analytics and Visualization Learn On-premises BI: SSRS 2016 and Power BI
10:10:00 Michael Fal Cloud Application Development Deployment Intro to Azure SQL Databases
10:10:00 Aaron Bertrand Application Database Development T-SQL : Bad Habits and Best Practices
11:20:00 Edward Pollack Application Database Development Dynamic SQL: Writing Efficient Queries on the Fly
11:20:00 Mike Walsh Enterprise Database Administration Deployment A Good DBA Works Smarter not Harder
11:20:00 Joseph D'Antoni Cloud Application Development Deployment Who Am I? Identity Management in Azure
11:20:00 Andy Leonard BI Platform Architecture, Development Administration Designing an SSIS Framework
13:20:00 Rie Irish Professional Development WIT: Identifying, Understanding and Combating Gender Bias Inequality
13:20:00 Leonard Lobel Cloud Application Development Deployment No Schema, No Problem! – Introduction to Azure DocumentDB
13:20:00 Jack Corbett BI Platform Architecture, Development Administration Dealing with Data Quality Issues in an SSIS Data Flow
13:20:00 Allan Hirt Enterprise Database Administration Deployment The SQL Server v.Next Availability Story on Linux
14:30:00 James Serra Enterprise Database Administration Deployment Should I move my database to the cloud?
14:30:00 Warren Estes Application Database Development Get-Session "Powershell 101"
14:30:00 Robert Davis Application Database Development SQLCmd Mode - The T-SQL Easy Button
14:30:00 David Klee Enterprise Database Administration Deployment SQL Server Infrastructure – Cloud and On-Prem Options
15:40:00 Paresh Motiwala BI Platform Architecture, Development Administration Big Data 101
15:40:00 David Bermingham Enterprise Database Administration Deployment SQL Server High Availability in Azure IaaS
15:40:00 Wendy Pastrick Application Database Development Read Dirty to Me - Isolation Levels/User Impact
15:40:00 Grant Fritchey Application Database Development Execution Plans: What Can You Do With Them?

SessionID: 54723

SQL Server Reporting Services 2016 on Steroids!!

Back to calendar

Event Date: 25-02-2017 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Steve Simon

Title: SQL Server Reporting Services 2016 on Steroids!!

Abstract:

Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.

In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.

SessionID: 54733

How to rearchitect for Azure SQL database from on-premises SQL Server - Case Study

Back to calendar

Event Date: 25-02-2017 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: George Walters

Title: How to rearchitect for Azure SQL database from on-premises SQL Server - Case Study

Abstract:

Considering a cloud architecture instead of on-premises? Come and walk through a Tier 1 Application with a heavy SQL on-prem footprint that was migrated to Azure. Considerations such as development changes, architecture, features required, reduced labor required, and people process to get this deployed.

SessionID: 56273

Optimizing the SQL Server and Databases for large Fact Tables

Back to calendar

Event Date: 25-02-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: Optimizing the SQL Server and Databases for large Fact Tables

Abstract:

A session 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.

SessionID: 57002

An Introduction to Jupyter Notebooks: The Hottest New Analytics

Back to calendar

Event Date: 25-02-2017 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Bryan Cafferky

Title: An Introduction to Jupyter Notebooks: The Hottest New Analytics

Abstract:

A hot new data science technology is on the scene called Jupyter notebooks. This powerful, web based, Python driven, tool supports dynamic analytics in real time. Some features that will be demonstrated are support for multiple languages including R and Python, the ability to easily interface with big data tools like Spark, built-in rendering in GitHub, the ability to weave R and Python scripts together sharing data, server based collaboration with JupyterHub, and how to share your notebooks with others. Jupyter is THE hottest thing on the data science scene. Come to this session and find out why.

SessionID: 55115

Architecting Availability Groups

Back to calendar

Event Date: 25-02-2017 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Derik Hammer

Title: Architecting Availability Groups

Abstract:

Are you a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you're considering AlwaysOn Availability Groups? This session is for you! I'll cover the pros and cons of four typical configurations of AlwaysOn Availability Groups: stand-alone instances, fail-over cluster instances, multi-subnet configurations, and disaster-recovery-on-the-cheap. I'll also discuss read-only routing, and implications and limitations of the Availability Group Listener. In addition, you'll learn why you should be using Windows Server 2012 R2 or above for your Windows clusters. Join me to learn which configuration options you should choose for your Availability Group.

SessionID: 57030

Learn On-premises BI: SSRS 2016 and Power BI

Back to calendar

Event Date: 25-02-2017 - Session time: 10:10:00 - Track: Analytics and Visualization

Speaker: Sunil Kadimdiwan

Title: Learn On-premises BI: SSRS 2016 and Power BI

Abstract:

Both Power BI and SSRS will help you deliver compelling BI solutions, whether IT managed and/or self-service. For many companies it is important to deliver such solution as on-premises option.

In this session I will give you a tour of enhancements in SSRS 2016 including KPI, mobile paginated reports. Mobile reports can now be viewed on any device; tablet, smartphone and desktop. I will also show you the newly introduced integration of Power BI views into on-premises SSRS 2016.

SessionID: 57129

Intro to Azure SQL Databases

Back to calendar

Event Date: 25-02-2017 - Session time: 10:10:00 - Track: Cloud Application Development Deployment

Speaker: Michael Fal

Title: Intro to Azure SQL Databases

Abstract:

Azure SQL Databases are still something that is new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft's Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.

SessionID: 58137

T-SQL : Bad Habits and Best Practices

Back to calendar

Event Date: 25-02-2017 - Session time: 10:10:00 - Track: Application Database Development

Speaker: Aaron Bertrand

Title: T-SQL : Bad Habits and Best Practices

Abstract:

Whether you are a developer, DBA, or anything in between, chances are you are not always following best practices when you write T-SQL. Unfortunately, many so-called “bad habits” aren’t always obvious, but can lead to poor performance, maintainability issues, and compatibility problems.

In this session, you will learn about several bad habits, how they develop, and how you can avoid them. While we will briefly discuss advice you’ve probably heard before, like avoid SELECT * and don’t use NOLOCK, you will also learn some subtleties in SQL Server that might surprise you, how some shorthand can bite you in the long run, and a very easy way to improve cursor performance.

By changing your techniques and ditching some of these bad habits for best practices, you will take new techniques back to your environment that will lead to more efficient code, a more productive workflow, or both.

SessionID: 54812

Dynamic SQL: Writing Efficient Queries on the Fly

Back to calendar

Event Date: 25-02-2017 - Session time: 11:20:00 - Track: Application Database Development

Speaker: Edward Pollack

Title: Dynamic SQL: Writing Efficient Queries on the Fly

Abstract:

Dynamic SQL can be a powerful tool that allows you to write fast efficient queries when the specifics may not be known until run-time. It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you'll ever see.

Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!

SessionID: 56490

A Good DBA Works Smarter not Harder

Back to calendar

Event Date: 25-02-2017 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Walsh

Title: A Good DBA Works Smarter not Harder

Abstract:

How many instances of SQL are in your environment? Are there any rogue SQL Servers installed? Do you manage each of them? Do you know if they are setup correctly?

There are many free tools out there to help you effectively manage your environment.

In this session we are going to be interactive, we are going to talk about points of pain and we are going to zoom in on several free tools to help you identify, manage and maintain your SQL Server environments. We'll take these tools and take you on a journey from discovering your instances, configuring the discovered environment, setting up policies to keep things happy, implement maintenance and perform baselines and performance analysis.

SessionID: 58116

Who Am I? Identity Management in Azure

Back to calendar

Event Date: 25-02-2017 - Session time: 11:20:00 - Track: Cloud Application Development Deployment

Speaker: Joseph D'Antoni

Title: Who Am I? Identity Management in Azure

Abstract:

When moving to a cloud or hybrid environment, one of the biggest challenges is maintaining a consistent login experience for users. Many firms have challenges with connecting Office 365 to their Azure infrastructure, particular in more complex designs. A bad design can raise security concerns or give users a bad experience. In this session you will learn about how Active Directory, Azure Active Directory, and Active Directory Federation Services work together to offer your users a single common logon experience. You will learn about the proper architecture for your security needs and scale.

SessionID: 58156

Designing an SSIS Framework

Back to calendar

Event Date: 25-02-2017 - Session time: 11:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: Designing an SSIS Framework

Abstract:

Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building on his previous work in the field of Data Integration Life Cycle Management (DILM) and SSIS Frameworks development, a Data Integration Architect with 10 years of SSIS experience explains the what, why, and how of an SSIS Catalog-integrated Framework that delivers metadata-driven package execution, connections management, and parameter configuration.

In this session, you will learn:

SessionID: 55016

WIT: Identifying, Understanding and Combating Gender Bias Inequality

Back to calendar

Event Date: 25-02-2017 - Session time: 13:20:00 - Track: Professional Development

Speaker: Rie Irish

Title: WIT: Identifying, Understanding and Combating Gender Bias Inequality

Abstract:

Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women and job responsibilities. We'll learn about the origins of some of these biases and how to identify gender bias when we see it. We'll discuss some strategies for how both men and women can combat this at work and in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.

SessionID: 56633

No Schema, No Problem! – Introduction to Azure DocumentDB

Back to calendar

Event Date: 25-02-2017 - Session time: 13:20:00 - Track: Cloud Application Development Deployment

Speaker: Leonard Lobel

Title: No Schema, No Problem! – Introduction to Azure DocumentDB

Abstract:

This session presents an overview of Azure DocumentDB, Microsoft's massively-scalable, fully managed NoSQL database platform designed specifically for modern web and mobile applications. Like other NoSQL platforms, DocumentDB supports a schema-free data model and scales easily. But it also offers several unique features that make it a compelling candidate for NoSQL scenarios.

We begin by explaining NoSQL and document databases, and how they compare with traditional relational database platforms. Then we tour the many features of DocumentDB, including rich querying with SQL (that’s right, you query this NoSQL database using SQL!), and client development using the REST API and the DocumentDB SDKs. Next, learn about the server-side programming model and write fully transactional stored procedures, triggers, and user-defined functions. Also explore tunable consistency, scale-out partitioning, custom indexing, attachments, and more. Attend this session, and get up to speed on DocumentDB to

SessionID: 56987

Dealing with Data Quality Issues in an SSIS Data Flow

Back to calendar

Event Date: 25-02-2017 - Session time: 13:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jack Corbett

Title: Dealing with Data Quality Issues in an SSIS Data Flow

Abstract:

Anyone who has worked with SSIS has dealt with the frustration of poor data quality and cryptic error messages. Microsoft has gotten better at providing better error messages within the Data Flow task, but still falls short in some areas. In this session we will discover how to get the real error message in a data flow task and how to isolate the rows causing the errors. We will start by reviewing a solution developed using a script component and progress to a method used to identify data quality issues before an error occurs. We will also discuss other options to handling data quality and errors.

SessionID: 58111

The SQL Server v.Next Availability Story on Linux

Back to calendar

Event Date: 25-02-2017 - Session time: 13:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: The SQL Server v.Next Availability Story on Linux

Abstract:

Although the paint on SQL Server 2016 just finished drying, Microsoft is already working on v.Next and preview builds are already available. One of the biggest changes is that SQL Server will be supported on Linux in addition to Windows Server. This means that all of the considerations we have for deploying instances and databases will be relevant and possibly different on Linux. While the story is still a work in progress, this session will cover how SQL Server v.Next can be made available based on what is known at this time. If you want to get a head start with SQL Server on Linux, this session is for you.

SessionID: 54794

Should I move my database to the cloud?

Back to calendar

Event Date: 25-02-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: James Serra

Title: Should I move my database to the cloud?

Abstract:

So you have been running on-prem SQL Server for a while now. Maybe you have taken the step to move it from bare metal to a VM, and have seen some nice benefits. Ready to see a TON more benefits? If you said "YES!", then this is the session for you as I will go over the many benefits gained by moving your on-prem SQL Server to an Azure VM (IaaS). Then I will really blow your mind by showing you even more benefits by moving to Azure SQL Database (PaaS/DBaaS). And for those of you with a large data warehouse, I also got you covered with Azure SQL Data Warehouse. Along the way I will talk about the many hybrid approaches so you can take a gradual approve to moving to the cloud. If you are interested in cost savings, additional features, ease of use, and ending the days of upgrading hardware, this is the session for you!

SessionID: 57136

Get-Session "Powershell 101"

Back to calendar

Event Date: 25-02-2017 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Warren Estes

Title: Get-Session "Powershell 101"

Abstract:

Are you a database professional who has yet to feel completely comfortable using PowerShell? Are you still copying logins between instances with sp_help_revlogin? This is a PowerShell fundamentals session that will take you on a magical(yes magical) journey from the basics of the IDE, cmdlets, syntax, and aliases to debugging, piping, SMO and installing modules. All of which will help you manipulate and gain insightful knowledge, and power, over your instances and environment.

SessionID: 57739

SQLCmd Mode - The T-SQL Easy Button

Back to calendar

Event Date: 25-02-2017 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Robert Davis

Title: SQLCmd Mode - The T-SQL Easy Button

Abstract:

Ever found yourself writing a T-SQL script and wishing you could do a relatively simple task that T-SQL just doesn't support? Like running a SQL script and passing in parameters at run-time? Or using a variable across multiple connections without using a linked server? Or run the script across multiple instances in a single window?

SQLCmd mode in SQL Server Management Studio (SSMS) is the answer to these problems and many more. Unfortunately, most people don't even know about these capabilities. It's the T-SQL easy button that almost nobody uses!

This demo-heavy session will teach you how to leverage new capabilities that have been at your finger-tips the whole time ... well at least since 2008.

SessionID: 57777

SQL Server Infrastructure – Cloud and On-Prem Options

Back to calendar

Event Date: 25-02-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: SQL Server Infrastructure – Cloud and On-Prem Options

Abstract:

Years ago, DBAs worked side-by-side with the infrastructure teams who managed the equipment their databases ran on. Today, organizations are more siloed than ever, and DBAs have less visibility into this layer than ever before. What is actually under the OS? Why does it matter?

Physical servers, enterprise virtualization, and cloud servers all provide solid platforms for you to run your databases on, but improperly configured and tuned platforms can lead to performance nightmares. Let’s explore the various layers, options, and performance characteristics of the different systems underneath SQL Server so you can improve the performance of your systems.

SessionID: 55100

Big Data 101

Back to calendar

Event Date: 25-02-2017 - Session time: 15:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paresh Motiwala

Title: Big Data 101

Abstract:

If you are new kid in the world of Big Data? Let's look at some of the topics of Big Data.

We will learn about foundations of big data and social physics, What is the importance of data quality and data privacy. We will have a quick look at personal sensors and human behavior This module will explore the various sources of data, how to leverage personal sensors to predict behavior, and introduce you to the key features of 'Funf'.

We will explore the basics of data dynamics and data interrogation, and the importance of interdisciplinary research and testing on yourself, to assist in analyzing a data set.

What are the fundamentals and structure of peer networks? I'll also introduce you to the concepts of network theory and graph clustering.

Time permitting, We will then conclude with introduction to data exploration and visualization techniques by using the 'Bandicoot' application and we will talk about how to use this data to effect behavior change through social influence an

SessionID: 56966

SQL Server High Availability in Azure IaaS

Back to calendar

Event Date: 25-02-2017 - Session time: 15:40:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: SQL Server High Availability in Azure IaaS

Abstract:

Deploying mission critical SQL Server in Azure IaaS requires an in-depth understanding of storage, virtual networks, load balancers, SQL Server AlwaysOn and more. To qualify for Azure’s SLA of 99.95% availability, steps must be taken to mitigate downtime by leveraging Fault Domains and Update Domains in conjunction with traditional HA options.

Azure Resource Manager (ARM) replaces Azure “Classic” as the preferred deployment method in Azure. New features such as Deployment Templates and Resource Groups introduced in ARM make it a powerful tool in managing the entire life-cycle of SQL Server in Azure.

In this session attendees will learn how to leverage ARM to deploy SQL AlwaysOn Availability Groups and Failover Cluster Instances. Template Deployments and manual configurations using the Azure Portal and Azure PowerShell will be demonstrated.

SessionID: 57452

Read Dirty to Me - Isolation Levels/User Impact

Back to calendar

Event Date: 25-02-2017 - Session time: 15:40:00 - Track: Application Database Development

Speaker: Wendy Pastrick

Title: Read Dirty to Me - Isolation Levels/User Impact

Abstract:

Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.

SessionID: 57806

Execution Plans: What Can You Do With Them?

Back to calendar

Event Date: 25-02-2017 - Session time: 15:40:00 - Track: Application Database Development

Speaker: Grant Fritchey

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

Abstract:

People are aware that you can use an execution plan to tune a query, but do they have other uses? This session will drill down on all the hidden information within execution plans. The structures and information with an execution plan shows many of the inner workings of SQL Server. From calculated columns to referential integrity, these, and many other functions, are exposed through execution plans. From this session you’ll be able to better understand the inner workings of SQL Server as well as your own databases and queries.

This site is open source. Improve this page.