sqlsathistory

Nr: 223

Back to Main list

SQLSaturday #223 - Oklahoma City 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Ben Miller	DBA	SMO Internals for High Performance PowerShell
00:00:00	Bryan Smith	Bonus	Let's Hadoop!
00:00:00	David Stein	Bonus	Data Warehouse Mistakes You Can’t Afford to Make
00:00:00	David Stein	Developer	Have You Got the Urge to (T-SQL) Merge?
00:00:00	Garrett Edmondson	Business Intelligence	Scaling a SQL Data Warehouse to 100s of TBs
00:00:00	Garrett Edmondson	Business Intelligence	Data Warehouse ETL
00:00:00	Jennifer McCown	Developer	Unraveling Tangled Code
00:00:00	John Sterrett	DBA	Table Partitioning: the Secret Weapon for your Big Data Problems.
00:00:00	John Sterrett	DBA	Building Your First AlwaysOn Failover Cluster Instance
00:00:00	Kat Long	DBA	Case Studies of Disaster Recovery
00:00:00	Kat Long	Developer	Database Design from User Requirements
00:00:00	Kristin Ferrier	Bonus	3D Geospatial Visualization Using Power Map
00:00:00	Matthew Brimer	DBA	SQL Security Best Practices Shrinking Your Attack Surface
00:00:00	Russel Loski	Developer	Introduction to the XML Source
00:00:00	Russel Loski	Business Intelligence	Introduction to BIML and BIMLScript
00:00:00	Ryan Adams	Bonus	How Active Directory affects SQL Server
00:00:00	Sean McCown	DBA	Beginning Powershell for DBAs 1.0
00:00:00	Rob Sullivan	Developer	SQL Server vs The World
00:00:00	Tim Mitchell	Business Intelligence	Handling Errors and Data Anomalies in SSIS
00:00:00	Tim Costello	Business Intelligence	Agile Data Warehouse Design
00:00:00	William E Pearson III	Business Intelligence	Getting Started with Analysis Services 2012 Tabular
00:00:00	William E Pearson III	Bonus	Practical Self-Service BI with Excel 2010/2013
00:00:00	Allen Smith	Developer	Sharing SQL Data in SharePoint

SessionID: 10254

SMO Internals for High Performance PowerShell

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Ben Miller

Title: SMO Internals for High Performance PowerShell

Abstract:

Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behind the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You'll be glad you did.

SessionID: 11044

Let's Hadoop!

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Bonus

Speaker: Bryan Smith

Title: Let's Hadoop!

Abstract:

This session provides a demonstration-rich introduction to the fundamentals of Hadoop and the Microsoft implementation, HDInsight. If you have heard of Hadoop but have struggled to get started with the technology, this session is for you.

SessionID: 12438

Data Warehouse Mistakes You Can’t Afford to Make

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Bonus

Speaker: David Stein

Title: Data Warehouse Mistakes You Can’t Afford to Make

Abstract:

Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system.

Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.

SessionID: 12439

Have You Got the Urge to (T-SQL) Merge?

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Developer

Speaker: David Stein

Title: Have You Got the Urge to (T-SQL) Merge?

Abstract:

You’ve got data to load into an already existing table, perhaps a slowly changing dimension, and need a method that is simple, supportable, and performs well. The T-SQL Merge statement, introduced in SQL 2008, can do all of this and more. Many DBAs investigate it, but find it unintuitive, time consuming, or they couldn’t get it to perform well. This doesn’t need to be difficult; after attending this session you’ll thoroughly understand the fundamentals of the merge statement and how to write them. You will also leave with scripts which automatically write well formed merge statements for you in less than 1 minute, guaranteed. Come see how.

SessionID: 14377

Scaling a SQL Data Warehouse to 100s of TBs

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Garrett Edmondson

Title: Scaling a SQL Data Warehouse to 100s of TBs

Abstract:

Learn how to architect a data warehouse that gets predictable and reliable performance into the HUNDREDS of terabytes. This presentation will focus on both hardware and software best practices for data warehouse specific workloads and will also provide and introduction to Parallel Data Warehouse V2 which scales into multi-petabytes.

SessionID: 14378

Data Warehouse ETL

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Garrett Edmondson

Title: Data Warehouse ETL

Abstract:

SQL provides many ways to move data from an OLTP source system to a data warehouse server, however choosing the most efficient and scalable ETL solution can be challenging. Various

ETL architectures will be explored by analyzing their strengths and weaknesses with data warehouse workloads. Best practices based on having developed ETL systems that load 1+ TB/hr. will be presented.

SessionID: 16470

Unraveling Tangled Code

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Jennifer McCown

Title: Unraveling Tangled Code

Abstract:

Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will emerge victorious!

SessionID: 17710

Table Partitioning: the Secret Weapon for your Big Data Problems.

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: DBA

Speaker: John Sterrett

Title: Table Partitioning: the Secret Weapon for your Big Data Problems.

Abstract:

Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, its time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks. In this session you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.

SessionID: 17711

Building Your First AlwaysOn Failover Cluster Instance

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: DBA

Speaker: John Sterrett

Title: Building Your First AlwaysOn Failover Cluster Instance

Abstract:

Are you starting to plan for high availability and curious to see how clustering can keep your databases online and mitigate downtime during patching? Have you heard about clustering but have no idea what is required to build a successful cluster? If so, this session is for you. During this session we will compare the pros and cons of Failover Cluster Instances to ensure you implement the best solution to handle you’re HA requirements. We will build a windows cluster from scratch and go over all the requirements including failover cluster manager, nodes, shared storage, active directory, client access points, quorums and installing a SQL Server clustered instance. Finally, we will go over a basic framework to help you quickly perform a root cause analysis to determine why your SQL services went down.

SessionID: 17986

Case Studies of Disaster Recovery

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Kat Long

Title: Case Studies of Disaster Recovery

Abstract:

From the expect disasters of failed hardware, malicious and unintentional data corruption, to the more unusual disasters of HVac failures, water main breaks, and fire, we will walk through case studies of each type, discuss what went right and what went wrong with the disaster recovery plan and how to plan better in the future. This session is intended to be interactive, to have you thinking about your own environment and what you need to put into place to help you successfully recover from disasters.

SessionID: 17987

Database Design from User Requirements

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Kat Long

Title: Database Design from User Requirements

Abstract:

Designing databases from User requirements is an art form even when you focus on implementing a strict ANSI compliant system. There is more to the database design then table structures and T-SQL statements. In this session you will learn how to translate user requirements into a database design which utilizes the new and existing features to create an efficient and manageable system.

SessionID: 18846

3D Geospatial Visualization Using Power Map

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Bonus

Speaker: Kristin Ferrier

Title: 3D Geospatial Visualization Using Power Map

Abstract:

Power Map, formerly called GeoFlow, is one of Microsoft’s latest releases in the BI spectrum. It provides for 3D geospatial and temporal visualization of data. In this session we’ll first compare and contrast the geospatial reporting capabilities of SSRS, Power View, and Power Map. We’ll then quickly learn the Power Map tool and create some interactive geospatial animated tours. We’ll also discuss the concept of datums, which is relevant for those using latitude and longitude.

SessionID: 19862

SQL Security Best Practices Shrinking Your Attack Surface

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Matthew Brimer

Title: SQL Security Best Practices Shrinking Your Attack Surface

Abstract:

SQL Security is a very broad and scary topic, one which

many days could be dedicated to speaking on it. In this session Matt will give a high level overview of what Database Security is, what tools Microsoft gives you to accomplish it and some simple things that you can do to shrink your attack surface.

SessionID: 23644

Introduction to the XML Source

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Russel Loski

Title: Introduction to the XML Source

Abstract:

XML is all over the place. But how do you get that data into SQL Server? SSIS provides an XML Source, but it is not easy to use. In this session we will handle increasingly complex XML documents. After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets. This includes hierarchically structured XML documents.Attendees will be able to import simple XML using SSIS. They will be able to create import routines that pull data from different elements of more complex XML. They will understand the role the XML Schema plays in defining the XML data they import.

SessionID: 23645

Introduction to BIML and BIMLScript

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Russel Loski

Title: Introduction to BIML and BIMLScript

Abstract:

Microsoft has provided some great tools for creating and editing SSIS packages. First Business Intelligence Development Studio (BIDS) then SQL Server Data Tools (SSDT). However, when creating an SSIS package you frequently repeat the same steps over and over. BIML is an XML markup language designed for representing the structure of an SSIS package. BIML Script takes that structure and generates an SSIS package.In this session we will use BIDS Helper to create a simple SSIS package using BIML. We will handle a couple SSIS scenarios with BIML and BIML Script.

SessionID: 23732

How Active Directory affects SQL Server

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Bonus

Speaker: Ryan Adams

Title: How Active Directory affects SQL Server

Abstract:

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session. SQL Server has a large surface area and Active Directory can influence a big part of it. I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.

SessionID: 24275

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: DBA

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 25869

SQL Server vs The World

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Rob Sullivan

Title: SQL Server vs The World

Abstract:

While SQL Server is the 3rd most used database in the world, the landscape of how we build applications and the technology supporting them is quickly changing. As if keeping up with SQL Server isn't enough on its own, we now have to deal with the terms and technology that comes with NoSQL (Not-Only-SQL) as well as fast moving, feature rich open source Relational DBs. In this session, we will explore some of the popular data stores, why AppDevs like using them and how your skills in SQL Server translate to them. Note: This session is geared towards OLTP systems. BI Solutions are NOT on the radar for this.

SessionID: 26598

Handling Errors and Data Anomalies in SSIS

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Tim Mitchell

Title: Handling Errors and Data Anomalies in SSIS

Abstract:

Even in the most reliable ETL system, it's eventually going to happen: A package will fail, an output row count won't match what is expected, a data anomaly will force a forensic search of the package infrastructure... In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.

SessionID: 26786

Agile Data Warehouse Design

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Tim Costello

Title: Agile Data Warehouse Design

Abstract:

Ever wonder what should go in a fact table and what belongs in a dimension? Have a suspicion that you’re forgetting important dimensions? Wouldn't it be great if somehow your design was self-documenting? In this session I’ll give you a couple new tools and show you a new way to look at your star schema. We’ll go past ‘why’ to see ‘how’ dimensional design is a great fit with the agile principles.

SessionID: 28091

Getting Started with Analysis Services 2012 Tabular

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: William E Pearson III

Title: Getting Started with Analysis Services 2012 Tabular

Abstract:

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM"). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.

SessionID: 28093

Practical Self-Service BI with Excel 2010/2013

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Bonus

Speaker: William E Pearson III

Title: Practical Self-Service BI with Excel 2010/2013

Abstract:

SQL Server MVP and Business Intelligence Architect Bill Pearson leads an introduction to using Excel 2013 to deliver self-service business intelligence. The focus of this session is to help those unfamiliar with the BI features that debut in Excel 2013 to become familiar with the assembly of data from diverse sources into models that deliver BI upon demand. We’ll discuss accessing and relating data, and employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise. Moreover, we will overview other BI-related features, including Data Mining and the exciting new Power View reporting capabilities.

SessionID: 9932

Sharing SQL Data in SharePoint

Back to calendar

Event Date: 24-08-2013 - Session time: 00:00:00 - Track: Developer

Speaker: Allen Smith

Title: Sharing SQL Data in SharePoint

Abstract:

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a 'List' using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.

This site is open source. Improve this page.