sqlsathistory

Nr: 292

Back to Main list

SQLSaturday #292 - Detroit 2014

Start Time (24h) Speaker Track Title
00:00:00 Christopher Campbell BI Big Data Trends with the Microsoft Parallel Data Warehouse
00:00:00 Colleen Morrow DBA SQL Audit - auditing doesn't have to be boring
00:00:00 Craig Purnell Wildcard 2 Achieving Compliance with SQL Server
00:00:00 David Klee Wildcard 1 How to Argue with Your Infrastructure Admins – and Win
00:00:00 Frank Murphy Wildcard 2 DIY Geocoding
00:00:00 Gill Rowley Wildcard 1 You're the DBA. Now What?
00:00:00 Gill Rowley Dev Dynamic Connections in SSIS
00:00:00 Ginger Grant BI The Sqoop on Big Data from it’s humble beginnings to rise to notoriety
00:00:00 Ginger Grant Wildcard 2 Power BI – Cloud Self-Service BI
00:00:00 Grant Fritchey Dev Building a Database Deployment Pipeline
00:00:00 Grant Fritchey Dev Getting Started Reading Execution Plans
00:00:00 Jeff Moden DBA Partitioning System for "WORM" Tables
00:00:00 John Gayer Wildcard 1 SQL Server 2014 Managed Backup to Windows Azure
00:00:00 Mike Hays Wildcard 1 Troubleshooting Your Network Connections
00:00:00 Michael Schulte BI Extending SQL Server with Advanced Analytics and R
00:00:00 Dustin Prescott Dev Hacking SQL Server - A Peek into the Dark Side
00:00:00 Brian Davis BI SSIS Templates Can Make Your Life Easier
00:00:00 Brian Davis Wildcard 2 Getting Started with Hekaton (In-Memory OLTP)
00:00:00 Rick Brewis DBA SQL Server 2014 - In-Memory OLTP
00:00:00 George Squillace BI All About the SSIS Catalog (SSISDB)
00:00:00 Tim Ford Wildcard 1 The Most Important Dynamic Management Objects for New DBAs
00:00:00 Tom Groszko Dev T-SQL For Beginning Developers
00:00:00 Allen White DBA Automate Your ETL Infrastructure with SSIS and PowerShell

SessionID: 11720

Big Data Trends with the Microsoft Parallel Data Warehouse

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: BI

Speaker: Christopher Campbell

Abstract:

Big Data is a hot topic in the news today. Many organizations are trying to develop their big data strategy but there is much confusion over the definition of the term and how it aligns to technology. Microsoft’s SQL Server Parallel Data Warehouse (PDW) provides a platform upon which to build your big data solution. This session will peel back the covers and discuss what big data means and provide a deep dive into the architecture of PDW.

SessionID: 11777

SQL Audit - auditing doesn't have to be boring

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Colleen Morrow

Title: SQL Audit - auditing doesn't have to be boring

Abstract:

Let's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun.

SessionID: 11997

Achieving Compliance with SQL Server

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 2

Speaker: Craig Purnell

Title: Achieving Compliance with SQL Server

Abstract:

There are a plethora of regulatory compliance mandates that affect business today with names like Sarbanes-Oxley, PCI-DSS, and HIPAA. How does a database professional implement these controls in your SQL Server infrastructure? We will review the basics of the GRC (Governance, Risk Management, and Compliance) methodology. You will learn about the tools that you can use to achieve compliance such as TDE, Auditing, and Identity Management. Come to this session and learn how to build a compliant infrastructure that keeps the DBA team, the auditors and the business leaders happy.

SessionID: 12522

How to Argue with Your Infrastructure Admins – and Win

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 1

Speaker: David Klee

Title: How to Argue with Your Infrastructure Admins – and Win

Abstract:

Do you feel like you spend hours going round-and-round with your system, storage, and virtualization administrators over SQL Server best practices? Are their application-agnostic requirements hurting your SQL Server’s performance, or worse, their reliability? David Klee (@kleegeek) will discuss valuable insight into how to start and work through the common conversations with them on the SQL Server infrastructure practices that matter to you the most, and how to succeed in getting what you need while keeping everyone happy.

SessionID: 14297

DIY Geocoding

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 2

Speaker: Frank Murphy

Title: DIY Geocoding

Abstract:

Do It Yourself Geocoding -- Step-by-step instructions on how to build a CLR assembly that will allow you to directly query various web services for geospatial data. We will also learn how to ensure a high level of confidence in the accuracy of your geospatial data.

SessionID: 14647

You're the DBA. Now What?

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 1

Speaker: Gill Rowley

Title: You're the DBA. Now What?

Abstract:

Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you're a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.

SessionID: 14648

Dynamic Connections in SSIS

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Gill Rowley

Title: Dynamic Connections in SSIS

Abstract:

Have you ever had to import a ton of CSV or DBF files into a database? Did you create a separate connection object for each file in SSIS? I will show you how to create one connection object and dynamically change that as you navigate through the file system, greatly reducing your development time. Yes, we will be typing in this demo!

SessionID: 14658

The Sqoop on Big Data from it’s humble beginnings to rise to notoriety

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: BI

Speaker: Ginger Grant

Title: The Sqoop on Big Data from it’s humble beginnings to rise to notoriety

Abstract:

Everywhere you turn in the technological literature people are talking and writing about Big Data. In this presentation you will learn about the origins of Hadoop, and how it is implemented today. In addition to the most infamous way of retrieving data from Hadoop, Map Reduce, there another way to manipulate the Hadoop data. It is possible to query the data from Hadoop in SQL Server through the use of Sqoop. In order to better understand the logic behind Sqoop, I will present information on the Hadoop components. Having this information will help you determine how the tools all fit together so that you will know which tools are the best choice for getting the desired answers from your data sources.

SessionID: 14659

Power BI – Cloud Self-Service BI

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 2

Speaker: Ginger Grant

Title: Power BI – Cloud Self-Service BI

Abstract:

Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.

SessionID: 14770

Building a Database Deployment Pipeline

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Grant Fritchey

Title: Building a Database Deployment Pipeline

Abstract:

The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, it’s data.

SessionID: 14771

Getting Started Reading Execution Plans

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Grant Fritchey

Title: Getting Started Reading Execution Plans

Abstract:

The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what's important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.

SessionID: 16057

Partitioning System for "WORM" Tables

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Jeff Moden

Title: Partitioning System for "WORM" Tables

Abstract:

This isn't your typical talk on "partitioning". This is a deep dive into all the problems that you'll run into when partitioning new or existing "Write Once, Read Many" tables, such as large Audit Tables, and how to code around them. You'll also learn the methods to support three of the best reasons for partitioning such monster tables... MUCH shorter nightly index maintenance, MUCH shorter and smaller backups, and MUCH shorter "Get back in business" piecemeal restores. We'll also learn how to do the "impossible"... compact a File Group (one per partition) so that there's virtually no unused space in the underlying file. After all, we don't want to set any "free" disk-space to "Read Only". Don't let the "Advanced" rating of this session scare you away. Anyone with a decent handle on T-SQL (or wants one) will be able to understand this session because "all will be explained" and there will be oodles of well-documented code to back up the explanations.

SessionID: 16758

SQL Server 2014 Managed Backup to Windows Azure

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 1

Speaker: John Gayer

Title: SQL Server 2014 Managed Backup to Windows Azure

Abstract:

In this session you will learn how to configure, run, and monitor the new SQL Server 2014 feature SQL Server Managed Backup to Windows Azure. Also, SQL Server database recovery from Windows Azure will be covered. This session will also discuss interfacing with the Windows Azure Storage Service. Experiences from using SQL Server Managed Backup and practical guidance will be provided.

SessionID: 20657

Troubleshooting Your Network Connections

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 1

Speaker: Mike Hays

Title: Troubleshooting Your Network Connections

Abstract:

Database professionals are often challenged to troubleshoot why a user cannot connect to a SQL Server instance. Attend this session to learn the basics of how SQL Server listens for connections and how it uses its browser service. Also learn what utilities the Windows operating system offers to help you in troubleshooting those connection issues.

SessionID: 21131

Extending SQL Server with Advanced Analytics and R

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: BI

Speaker: Michael Schulte

Title: Extending SQL Server with Advanced Analytics and R

Abstract:

The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.

SessionID: 22296

Hacking SQL Server - A Peek into the Dark Side

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Dustin Prescott

Title: Hacking SQL Server - A Peek into the Dark Side

Abstract:

SessionID: 22637

SSIS Templates Can Make Your Life Easier

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: BI

Speaker: Brian Davis

Title: SSIS Templates Can Make Your Life Easier

Abstract:

How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.

SessionID: 22638

Getting Started with Hekaton (In-Memory OLTP)

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 2

Speaker: Brian Davis

Title: Getting Started with Hekaton (In-Memory OLTP)

Abstract:

So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.

SessionID: 22684

SQL Server 2014 - In-Memory OLTP

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Rick Brewis

Title: SQL Server 2014 - In-Memory OLTP

Abstract:

SQL Server 2014 has added In-Memory OLTP capabilities that provide new high-end performance for mission critical applications. This session will describe the new in-memory features and the table and stored procedure changes to support in-memory. We will review the new in-memory architecture that has been added to the SQL Server database engine and show a few demos that illustrate the tremendous performance gains SQL Server 2014 delivers.

SessionID: 25089

All About the SSIS Catalog (SSISDB)

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: BI

Speaker: George Squillace

Title: All About the SSIS Catalog (SSISDB)

Abstract:

Wow, deployment of SSIS packages in SQL Server 2012 is radically different, when the new SSIS catalog is used (“Who Moved My Cheese?”). This session examines the “new” SSISDB, its architecture and functionality and compares that to the “old” method of Package Configurations in previous versions of SSIS.

SessionID: 26872

The Most Important Dynamic Management Objects for New DBAs

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Wildcard 1

Speaker: Tim Ford

Title: The Most Important Dynamic Management Objects for New DBAs

Abstract:

The Dynamic Management Objects are a very powerful set of tools available to SQL Data Professionals. There are so many though that it's easy to get overwhelmed. Join Tim Ford, Creator of The Periodic Table of Dynamic Management Objects (http://thesqlagentman.com/go/periodic2012/) as he presents the most important DMOs for DBAs to start using immediately.

SessionID: 26985

T-SQL For Beginning Developers

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: Dev

Speaker: Tom Groszko

Title: T-SQL For Beginning Developers

Abstract:

This session will provide a variety of programing insights that I have used over many years of SQL development. This is aimed at developers who are beginning to write T-SQL. Topics will include functions, performance, thinking about how the optimizer works while writing code, debugging techniques, data architecture, CTEs, triggers and any topics you bring to the floor.

SessionID: 9983

Automate Your ETL Infrastructure with SSIS and PowerShell

Back to calendar

Event Date: 17-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Allen White

Title: Automate Your ETL Infrastructure with SSIS and PowerShell

Abstract:

Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.