sqlsathistory

Nr: 440

Back to Main list

SQLSaturday #440 - Pittsburgh 2015

Start Time (24h)	Speaker	Track	Title
08:50:00	Matt Slocum	Enterprise Database Administration Deployment	What Every DBA Needs To Know About Storage For SQL Server
08:50:00	Michael John	Enterprise Database Administration Deployment	What is a DBA?
08:50:00	Janis Griffin	Enterprise Database Administration Deployment	Query Tuning - Get it Right the First Time
08:50:00	Kevin Feasel	Application Database Development	APPLY Yourself
08:50:00	Dan Clark	BI Platform Architecture, Development Administration	Self-Service ETL with Power Query
08:50:00	Slava Murygin	Application Database Development	Get Familiar with Spatial Data
08:50:00	Pat Phelan	Application Database Development	Data Architecture 101
10:00:00	Katie Vetter	BI Platform Architecture, Development Administration	Introduction to the Script Task in SSIS
10:00:00	Warren Sifre	Enterprise Database Administration Deployment	DBA Monitoring and Maintenance Fundamentals
10:00:00	Jeremiah Peschka	Application Database Development	Dynamic SQL: Build Fast, Flexible Queries
10:00:00	Drew Furgiuele	Enterprise Database Administration Deployment	SQL Server and PowerShell: Let's Get Serious
10:00:00	Rick Heiges	Enterprise Database Administration Deployment	First Look at SQL Server 2016
10:00:00	Jeff Moden	Enterprise Database Administration Deployment	Disabling xp_CmdShell…Is it Really a “Best Practice”?
10:00:00	Matt Gallentine	Professional Development	A typical day in the life of a DBA
11:10:00	Brent Ozar	Strategy and Architecture	Licensing Simplified Into Awesome Diagrams
11:10:00	John Sterrett	Enterprise Database Administration Deployment	Make Your SQL Server Queries Go Faster
11:10:00	Reed Powell	Professional Development	Surviving a Technical SQL Interview
11:10:00	Steve Hood	Application Database Development	Fixing Page Life Expectancy
11:10:00	Carlos L Chacon	Application Database Development	The TSQL Review for the Busy Data Professional
11:10:00	Brandi Dollar	Professional Development	What makes a good DBA?
11:10:00	Konstantin Melamud	BI Platform Architecture, Development Administration	Optimizing your data warehouse for OLAP Processing
12:50:00	Matt Nelson	Other	Dell Lunchtime session
12:50:00	Matt Nelson	Other	Profisee lunchtime session
12:50:00	Matt Nelson	Other	Pyramid Analytics lunchtime session
12:50:00	Katie Vetter	Professional Development	Women In Technology
13:30:00	Eugene Meidinger	Application Database Development	Going beyond SELECT *
13:30:00	Gigi Bell	Professional Development	Dealing With Difficult People
13:30:00	Tony Milne	Strategy and Architecture	14 Features in SQL Server 2014 You Haven't Considered
13:30:00	Thomas Grohser	Enterprise Database Administration Deployment	SQL Server Storage Engine under the hood
13:30:00	Jeff Moden	Information Delivery	Automating "Excel Hell" with T-SQL
13:30:00	Dan King	BI Information Delivery	Convert from T-SQL to MDX queries
13:30:00	Jeb Sears	BI Information Delivery	Business Intelligence
14:40:00	Brent Ozar	Cloud Application Development Deployment	Watch Brent Tune Queries
14:40:00	Adam Belebczuk	Enterprise Database Administration Deployment	Availability Groups 101: An Introduction
14:40:00	Ravi Kumar	BI Platform Architecture, Development Administration	What Makes SSIS Tick? A Look at Internals for Performance
14:40:00	Allen White	Enterprise Database Administration Deployment	Maintain SQL Server Performance Baseline w/PowerShell
14:40:00	Chris Bell	Strategy and Architecture	Hacking Expos#233; - Using SSL to Secure SQL Server Connections
14:40:00	Kermit Seubert	Strategy and Architecture	Basics of relational database design
15:50:00	Adriano da Silva	Professional Development	An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.
15:50:00	Danette Riviello	Enterprise Database Administration Deployment	Become a SQL Server Performance Detective
15:50:00	Paul Popovich Jr	Enterprise Database Administration Deployment	Clusters! From the ground up, let's build one together
15:50:00	Mike Hillwig	Enterprise Database Administration Deployment	Do More With Less: Inside SQL Agent Multi-Server Administration
15:50:00	Jeremy Frye	BI Platform Architecture, Development Administration	"Can I Get A Report of This?": Introduction to SSRS
15:50:00	Greg Baldini	BI Information Delivery	Agile BI with Power BI
15:50:00	Matt Nelson	Professional Development	Experts Panel

SessionID: 36726

What Every DBA Needs To Know About Storage For SQL Server

Back to calendar

Event Date: 03-10-2015 - Session time: 08:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Slocum

Title: What Every DBA Needs To Know About Storage For SQL Server

Abstract:

Do you have issues communicating your needs to your Storage/SAN Administrator? Do they seem to speak a different language when it comes to determining and providing your SQL Server storage needs? In this session we'll review storage technologies so that you can communicate effectively with your Storage/SAN Administrator as well as methods of monitoring your storage to ensure that your needs are met.

In this session we will discuss RAID types, Local/Direct Attached Storage vs SAN Storage, and Flash Storage (including how it fits into multiple storage models). We'll also review methods for monitoring and testing your storage performance. With the information gathered in this session, you'll be able to have thorough, informed discussions with your Storage Administrator as well as being able to provide solid metrics to confirm storage performance.

SessionID: 36730

What is a DBA?

Back to calendar

Event Date: 03-10-2015 - Session time: 08:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael John

Title: What is a DBA?

Abstract:

What are the different kinds of DBA’s? What are the popular RDMS’s?

Presented by Michael John and Ed Wagner

SessionID: 36790

Query Tuning - Get it Right the First Time

Back to calendar

Event Date: 03-10-2015 - Session time: 08:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Query Tuning - Get it Right the First Time

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

SessionID: 36801

APPLY Yourself

Back to calendar

Event Date: 03-10-2015 - Session time: 08:50: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: 37723

Self-Service ETL with Power Query

Back to calendar

Event Date: 03-10-2015 - Session time: 08:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dan Clark

Title: Self-Service ETL with Power Query

Abstract:

Before any significant data analysis can take place the data often needs to be transformed, aggregated, and combined. This is often referred to as the ETL (Extraction, Transfer, and Load) process. Power Query is an excellent tool in the Microsoft self-service BI stack that allows business users to discover, combine, and refine data before loading it into a Power Pivot model for further analysis. In addition Microsoft has made connecting to a wide variety of sources including relational, structured, and semi structured data a consistent intuitive experience. This session guides you through using Power Query to extract, transform, and load data from various sources into a Power Pivot model. In addition we will look at the M language created by the tool and look at some advanced queries you can create using M.

SessionID: 37879

Get Familiar with Spatial Data

Back to calendar

Event Date: 03-10-2015 - Session time: 08:50:00 - Track: Application Database Development

Speaker: Slava Murygin

Title: Get Familiar with Spatial Data

Abstract:

You've never worked with spatial data and would like to know how to do it.

We'll go through very basic SQL Server Spatial data functionality and draw some Spatial pictures using Management Studio.

SessionID: 39423

Data Architecture 101

Back to calendar

Event Date: 03-10-2015 - Session time: 08:50:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Data Architecture 101

Abstract:

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

SessionID: 36769

Introduction to the Script Task in SSIS

Back to calendar

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

Speaker: Katie Vetter

Title: Introduction to the Script Task in SSIS

Abstract:

What is the Script Task? What can I do with it? When should I use it?

I'll introduce you to the SSIS Script Task and beginner-intermediate level vb script while we walk through some live examples.

SessionID: 36898

DBA Monitoring and Maintenance Fundamentals

Back to calendar

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

Speaker: Warren Sifre

Title: DBA Monitoring and Maintenance Fundamentals

Abstract:

The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.

SessionID: 37093

Dynamic SQL: Build Fast, Flexible Queries

Back to calendar

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

Speaker: Jeremiah Peschka

Title: Dynamic SQL: Build Fast, Flexible Queries

Abstract:

Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so!

Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. In this session, we’ll be dispelling these misconceptions and demonstrating how dynamic SQL can become a part of every DBA’s tool kit.

SessionID: 37965

SQL Server and PowerShell: Let's Get Serious

Back to calendar

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

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.

SessionID: 38218

First Look at SQL Server 2016

Back to calendar

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

Speaker: Rick Heiges

Title: First Look at SQL Server 2016

Abstract:

Microsoft has been busy working on the next version of SQL Server - SQL Server 2016. We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB. Row Level Security allows you to add another layer of security to your environment. StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.

SessionID: 39750

Disabling xp_CmdShell…Is it Really a “Best Practice”?

Back to calendar

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

Speaker: Jeff Moden

Title: Disabling xp_CmdShell…Is it Really a “Best Practice”?

Abstract:

XP_CmdShell is a powerful tool that can greatly simplify the life of DBAs.

You can quickly and easily write full ETL systems, up/down-load FTP files, call PowerShell scripts to interrogate the status of hard-disks across the enterprise with nary a 3rd party tool in sight, and much more. And it’s all done under the control a scheduled job system that you already know and that keeps its own logs. Yet, you'll find millions of people that agree that disabling xp_CmdShell is a "best practice". Some even say that it should never be used. Why? Disabling it supposedly decreases the system "surface area" of possible attack and never using it supposedly solves the problem of someone elevating their privileges with it. Well, surprise! Disabling xp_CmdShell doesn't actually solve any of those problems. In fact, disabling it may actually hurt security. Come to this session to find out why turning off xp_CmdShell may be a "worst practice" and how to allow individuals/applications to run it safely.

SessionID: 40929

A typical day in the life of a DBA

Back to calendar

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

Speaker: Matt Gallentine

Title: A typical day in the life of a DBA

Abstract:

A typical day in the life of a DBA

SessionID: 36934

Licensing Simplified Into Awesome Diagrams

Back to calendar

Event Date: 03-10-2015 - Session time: 11:10:00 - Track: Strategy and Architecture

Speaker: Brent Ozar

Title: Licensing Simplified Into Awesome Diagrams

Abstract:

How does licensing work? Sure, you understand the difference between Standard and Enterprise, but what happens with AlwaysOn Availability Groups, virtualization, clustering, and disaster recovery? Microsoft Certified Master Brent Ozar will cut through all the confusion and explain your high availability and disaster recovery options, show how licensing impacts them, and keep you out of prison.

SessionID: 39560

Make Your SQL Server Queries Go Faster

Back to calendar

Event Date: 03-10-2015 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: Make Your SQL Server Queries Go Faster

Abstract:

Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries, and apply proper indexes while avoiding common mistakes. Finally we will cover coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.

SessionID: 39564

Surviving a Technical SQL Interview

Back to calendar

Event Date: 03-10-2015 - Session time: 11:10:00 - Track: Professional Development

Speaker: Reed Powell

Title: Surviving a Technical SQL Interview

Abstract:

At some point every SQL interview is going to get technical. This session will go through my favorite questions as an interviewer and talk about their overall relevance and answers. We'll talk about how to handle the situations where you aren't sure of the answer - or when you know that you don't know the answer The questions will cover database design, DBA, SSIS and SSRS aspects of SQL server. Pointers to resources will also be given.

SessionID: 39732

Fixing Page Life Expectancy

Back to calendar

Event Date: 03-10-2015 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Steve Hood

Title: Fixing Page Life Expectancy

Abstract:

Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.

SessionID: 39760

The TSQL Review for the Busy Data Professional

Back to calendar

Event Date: 03-10-2015 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Carlos L Chacon

Title: The TSQL Review for the Busy Data Professional

Abstract:

How does the way I write my query affect the way data gets returned to me? If I use an inner join here, how does that affect my results? This session will review some of the ways we write queries and how these decisions affect us. We will also review database design concepts and how our architecture can influence our ability to make data available to users.

SessionID: 40930

What makes a good DBA?

Back to calendar

Event Date: 03-10-2015 - Session time: 11:10:00 - Track: Professional Development

Speaker: Brandi Dollar

Title: What makes a good DBA?

Abstract:

What makes a good DBA?

SessionID: 41191

Optimizing your data warehouse for OLAP Processing

Back to calendar

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

Speaker: Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Abstract:

Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.

SessionID: 40918

Dell Lunchtime session

Back to calendar

Event Date: 03-10-2015 - Session time: 12:50:00 - Track: Other

Speaker: Matt Nelson

Title: Dell Lunchtime session

Abstract:

Join Dell for a lunchtime session about their products and services

Food is not permitted in the classrooms. Please eat lunch in the gallery first and then join dell afterwards for this session.

SessionID: 40919

Profisee lunchtime session

Back to calendar

Event Date: 03-10-2015 - Session time: 12:50:00 - Track: Other

Speaker: Matt Nelson

Title: Profisee lunchtime session

Abstract:

Join Profisee for a lunchtime session to learn about leveraging Microsoft SQL Server and Profisee’s Maestro solution for Master Data Management.

Food is not permitted in the classrooms. Please eat lunch in the gallery first and then join Profisee afterwards for this session.

SessionID: 40920

Pyramid Analytics lunchtime session

Back to calendar

Event Date: 03-10-2015 - Session time: 12:50:00 - Track: Other

Speaker: Matt Nelson

Title: Pyramid Analytics lunchtime session

Abstract:

Join Pyramid Analytics for a lunchtime session about their products and services

Food is not permitted in the classrooms. Please eat lunch in the gallery first and then join Pyramid Analytics afterwards for this session.

SessionID: 40931

Women In Technology

Back to calendar

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

Speaker: Katie Vetter

Title: Women In Technology

Abstract:

Come to participate in (or just eat and listen to) an informal discussion about women in technology. All are welcome to attend.

Food is not permitted in the classrooms, so please eat in the Gallery first and then join us for this round table.

SessionID: 36752

Going beyond SELECT *

Back to calendar

Event Date: 03-10-2015 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Eugene Meidinger

Title: Going beyond SELECT *

Abstract:

You know how to do the basics: selects, joins, filtering. What comes next? Sometimes it can be difficult to figure out what comes after SELECT * FROM. This session covers some of the more advanced features of TSQL that you may not know about. We will cover subqueries and the different ways they can be used. We will cover the different windowing functions and how they can be used. And finally we will cover the MERGE command.

SessionID: 37003

Dealing With Difficult People

Back to calendar

Event Date: 03-10-2015 - Session time: 13:30:00 - Track: Professional Development

Speaker: Gigi Bell

Title: Dealing With Difficult People

Abstract:

John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.

SessionID: 38561

14 Features in SQL Server 2014 You Haven't Considered

Back to calendar

Event Date: 03-10-2015 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: Tony Milne

Title: 14 Features in SQL Server 2014 You Haven't Considered

Abstract:

SQL Server 2014 was released in early 2014. Since then, most are struggling to understand why they should upgrade. This talk will uncover 14 features in SQL 2014 that you may have not thought of. Including in-memory tables, hybrid cloud environments, BI enhancements, and others. After this talk you'll be armed with the knowledge to take full advantage of the amazing improvements in SQL Server 2014.

SessionID: 39265

SQL Server Storage Engine under the hood

Back to calendar

Event Date: 03-10-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: SQL Server Storage Engine under the hood

Abstract:

How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up. #160; Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.

SessionID: 39377

Automating "Excel Hell" with T-SQL

Back to calendar

Event Date: 03-10-2015 - Session time: 13:30:00 - Track: Information Delivery

Speaker: Jeff Moden

Title: Automating "Excel Hell" with T-SQL

Abstract:

Truly automate complex monthly spreadsheet imports without monthly code changes!

Right or wrong, spreadsheets still constitute a source of data that many of us have to import every week or month. The trouble is that most spreadsheets aren’t setup to look like an SQL table. Rather, they are setup as multiple dimensions to aid in user readability and that makes column mapping and importing seriously automation resistant.

This “Black Arts” session provides an introduction to a relatively simple method to quickly, easily, and automatically import such spreadsheets and the code to do so frequently requires no changes to be used across multiple disparate spreadsheets. Creation of the necessary staging table and the related mapping is all done automatically and the monthly addition of columns is automatically handled, as well. Some of the pitfalls of more traditional import methods will also be examined.

Don’t let the “Advanced” rating of this session scare you away. It's simple!

SessionID: 40149

Convert from T-SQL to MDX queries

Back to calendar

Event Date: 03-10-2015 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Dan King

Title: Convert from T-SQL to MDX queries

Abstract:

SQL Server Analysis Services has become a key base of Business Intelligence integration into business decision making. As DBA’s sometimes we are forced to change over to new coding standards. MDX is one of the base languages used when reporting off of cubes that are built using the multi-dimensional model. The goal of this class will be to help beginners convert from using T-SQL to understanding the basics when writing MDX queries from scratch.

SessionID: 40935

Business Intelligence

Back to calendar

Event Date: 03-10-2015 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Jeb Sears

Title: Business Intelligence

Abstract:

what it Business Intelligence, how it’s used, and why it is rapidly becoming very important to most organizations.

Covering the basics of the MS BI stack. SSIS, SSRS, SSAS.

SessionID: 36933

Watch Brent Tune Queries

Back to calendar

Event Date: 03-10-2015 - Session time: 14:40:00 - Track: Cloud Application Development Deployment

Speaker: Brent Ozar

Title: Watch Brent Tune Queries

Abstract:

You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.

SessionID: 39070

Availability Groups 101: An Introduction

Back to calendar

Event Date: 03-10-2015 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Adam Belebczuk

Title: Availability Groups 101: An Introduction

Abstract:

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.

SessionID: 39696

What Makes SSIS Tick? A Look at Internals for Performance

Back to calendar

Event Date: 03-10-2015 - Session time: 14:40: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, and 2014.)

SessionID: 39792

Maintain SQL Server Performance Baseline w/PowerShell

Back to calendar

Event Date: 03-10-2015 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: Maintain SQL Server Performance Baseline w/PowerShell

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 40917

Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Back to calendar

Event Date: 03-10-2015 - Session time: 14:40:00 - Track: Strategy and Architecture

Speaker: Chris Bell

Title: Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Abstract:

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data?

We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! We will then secure our database connections with a simple self-signed SSL certificate. Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. *Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used.

PreReqs: This session only requires you to have a basic knowledge of SQL Server configuration and an interest in protecting the data in your database.

Goal 1: Learn what is exposed when using the default, unprotected connections to SQL Server Goal 2: Learn how to configure SQL Serve to use an SSL certificate t

SessionID: 41005

Basics of relational database design

Back to calendar

Event Date: 03-10-2015 - Session time: 14:40:00 - Track: Strategy and Architecture

Speaker: Kermit Seubert

Title: Basics of relational database design

Abstract:

Basics of relational database design

SessionID: 37785

An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.

Back to calendar

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

Speaker: Adriano da Silva

Title: An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.

Abstract:

This presentation provides a high level overview of basic Big Data and Hadoop fundamentals and concepts. It is an ideal opportunity for those considering or learning Hadoop to see Big Data in Action with examples using Microsoft Azure HDInsight, which is a 100% Apache Hadoop-based service in the cloud provided by Microsoft. We will also cover Big Data exploration and data visualization demonstrations using Microsoft products; such as PowerQuery for Excel.

SessionID: 38013

Become a SQL Server Performance Detective

Back to calendar

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

Speaker: Danette Riviello

Title: Become a SQL Server Performance Detective

Abstract:

When your database is having performance issues, you need to quickly and accurately diagnose and resolve performance issues. Like any good detective, you need to look for clues to find “The Smoking Gun.” We will cover various tools we have in SQL Server 2008 and above at our disposal which can help us pinpoint and resolve issues quickly, using Dynamic Management Views (DMVs), SQL Profiler and other queries. We will discuss emergent performance issues as well as chronic issues and find ways to piece together the clues to figure out the root cause of our problems.

SessionID: 38189

Clusters! From the ground up, let's build one together

Back to calendar

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

Speaker: Paul Popovich Jr

Title: Clusters! From the ground up, let's build one together

Abstract:

You're looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides. Let's learn what a cluster is and why it might be the right thing for you. We'll explore the system, network, storage and database administration sides of the equation. And, when it's all said and done we'll even have built a SQL clustered instance!

SessionID: 38330

Do More With Less: Inside SQL Agent Multi-Server Administration

Back to calendar

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

Speaker: Mike Hillwig

Title: Do More With Less: Inside SQL Agent Multi-Server Administration

Abstract:

One of the of the most under-utilized management features of SQL Server is SQL Agent Multi-Server Administration, which allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. This allows you to have consistency with your SQL Agent jobs by managing them in a single location. You’ll learn about the benefits, drawbacks, workarounds, and underlying objects behind this technology. You’ll discover how to monitor job execution status and handle the security implications of the master-target relationship. Native Yinzer and SQL Server MVP Mike Hillwig will show you how to to deploy this simple, yet powerful feature right out of the box without writing a single line of additional code.

SessionID: 39846

"Can I Get A Report of This?": Introduction to SSRS

Back to calendar

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

Speaker: Jeremy Frye

Title: "Can I Get A Report of This?": Introduction to SSRS

Abstract:

In the day-to-day operations of business, how often have we heard or even asked someone the question ourselves, “Can I get a report of this?” Regardless of your area of expertise, reporting has become a necessity and requirement among businesses and is impacting our roles as IT professionals. With the huge wave of trendy reporting tools and software surrounding the BI industry, many people are unaware or often overlook SSRS as a reporting solution. In this session, we will look at the features and capabilities of SSRS, as well as supply you with the tools to begin fulfilling basic report requests. At the conclusion of this session, you will know the difference between Report Builder and SQL Server Data Tools to determine which one is suitable for your needs. You will also be able to create and deploy a basic report consisting of a data source, data set, a parameter and a row group.

SessionID: 39847

Agile BI with Power BI

Back to calendar

Event Date: 03-10-2015 - Session time: 15:50:00 - Track: BI Information Delivery

Speaker: Greg Baldini

Title: Agile BI with Power BI

Abstract:

This session provides an overview of Agile BI strategy and approach and demonstrates how Power BI can be used to jump start BI initiatives within an organization.

Specifically we highlight how an agile approach can address some of the following pain points:

• Long lead time on report modifications
• Waterfall delivery methodology
• Disconnect between what end users want and ask for

SessionID: 40921

Experts Panel

Back to calendar

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

Speaker: Matt Nelson

Title: Experts Panel

Abstract:

To wrap up the Wanna Be A DBA track, join several speakers who are experts in their fields for a lightning talk round. In this hour, we will talk about career paths, hints, tricks, tidbits, and answer questions that you may have about beginning your career as a database administrator.

This site is open source. Improve this page.