sqlsathistory

Nr: 239

Back to Main list

SQLSaturday #239 - East Iowa 2013

Start Time (24h) Speaker Track Title
00:00:00 Doug Lane Track 2 Hailing Frequencies: SSAS Terms and Concepts
00:00:00 Doug Lane Track 1 From Minutes to Milliseconds: High-Performance SSRS Tuning
00:00:00 Louis Davidson Track 2 How to Write a DML Trigger
00:00:00 Louis Davidson Track 1 Database Design Fundamentals
00:00:00 Ed Leighton-Dick Track 3 Service Broker: The Queue Continuum
00:00:00 Eric Selje Track 4 Unit Testing Fundamentals
00:00:00 Jason Strate Track 2 Extended Events, Work Smarter Not Harder
00:00:00 Jason Strate Track 1 XQuery Basics for the DBA
00:00:00 Kirby Richter Track 2 Break it up! Implement Table Partitioning
00:00:00 Mark Skiles Track 3 Mission Critical Confidence – (SQL 2012 AlwaysOn) and Availability Groups
00:00:00 Mark Vaillancourt Track 4 MDX Trek: First Contact
00:00:00 Mike Hays Track 4 Troubleshooting your TCP/IP connections
00:00:00 Paul Timmerman Track 3 An Optimistic Approach: Snapshot Isolation in SQL
00:00:00 Rick Krueger Track 3 SQLSaturday: Design Your Game Plan to Maximize ROI
00:00:00 Frank Gill Track 4 Interrogating the Transaction Log
00:00:00 Tim Mitchell Track 3 SSIS Incremental Load Design Patterns
00:00:00 Tim Mitchell Track 2 Parent/Child Structures in SSIS
00:00:00 William E Pearson III Track 1 Getting Started with Analysis Services 2012 Tabular
00:00:00 William E Pearson III Track 1 Prototyping with PowerPivot: Handling External Analysis Services 2012 Grouping
00:00:00 Andy Thiru Track 4 Moving Enterprise database to cloud

SessionID: 13383

Hailing Frequencies: SSAS Terms and Concepts

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Doug Lane

Title: Hailing Frequencies: SSAS Terms and Concepts

Abstract:

In this Star Trek-themed presentation, we will explain the terms and concepts important to understand when participating in projects involving SQL Server Analysis Services (SSAS).

You’ll learn the key differences between SSAS Multidimensional Model (Cubes) and SSAS Tabular Model. You’ll also learn the definitions and examples of key terms for each model, including but not limited to: measure groups, measures, dimensions, attributes, and hierarchies in the SSAS Multidimensional Model and tables, columns, and calculated measures in the SSAS Tabular Model. We will also demonstrate the basics of browsing of both Multidimensional and Tabular models using Excel 2013.

SessionID: 13384

From Minutes to Milliseconds: High-Performance SSRS Tuning

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Doug Lane

Title: From Minutes to Milliseconds: High-Performance SSRS Tuning

Abstract:

Even though you're an experienced report developer or administrator, performance tuning for SQL Server Reporting Services still feels as bewildering and hopeless as folding a fitted bed sheet. You've made your data sets smaller and timeouts longer, but it's not enough to remove the slowness dragging down your reporting environment.

In this session, you'll learn how design and configuration choices put pressure on your report server and techniques to relieve that pressure. You’ll see how to configure your Reporting Services databases for speed, houseclean your subscription schedules, and use caching for high-demand reports. You'll also learn some design strategies to lighten your report processing load. If you want to maximize the speed of your Reporting Services environment and minimize the pain of performance tuning, this session is for you.

SessionID: 13457

How to Write a DML Trigger

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Louis Davidson

Title: How to Write a DML Trigger

Abstract:

Triggers are extremely powerful and useful (if somewhat rarely needed) objects that are coded very similar to a common stored procedure. Yet for their similarity, there are some very important differences that need to be understood. In this session, I will walk through what goes into writing a robust DML trigger, starting with a simple version of a trigger, and working through some very useful applications of DML Triggers..

SessionID: 13458

Database Design Fundamentals

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).

SessionID: 13665

Service Broker: The Queue Continuum

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Ed Leighton-Dick

Title: Service Broker: The Queue Continuum

Abstract:

Pop quiz: How can SQL Server help developers build scalable, distributed, and asynchronous applications? Service Broker is the answer! In this presentation, I'll show you what it is; talk about when and why you might want to use it in your applications; walk through an example of how to set it up; and share a few lessons learned from our successful implementations.

SessionID: 13888

Unit Testing Fundamentals

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Eric Selje

Title: Unit Testing Fundamentals

Abstract:

How can you be certain the "little change" you're about to make to that stored procedure isn't going to take down your whole company? Real developers use a technique called "Unit Testing" to minimize that risk, a concept that's also available to you. With unit testing you can quick ascertain whether the the changes to functions, stored procedures, and even other objects in your database had a negative unforeseen impact.

In this session we'll walk through the basics of what unit testing is, how to set up a simple Unit Testing project in SSMS, how we can tell whether something has negatively changed in our functions or procedures. We'll also enumerate any 3rd party tools available to help us with Unit Testing our databases.

SessionID: 15961

Extended Events, Work Smarter Not Harder

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Jason Strate

Title: Extended Events, Work Smarter Not Harder

Abstract:

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

SessionID: 15962

XQuery Basics for the DBA

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Jason Strate

Title: XQuery Basics for the DBA

Abstract:

For the past few years, XML has been making its way more and more into our SQL Server instances. For a moment let’s forget that developers often find the need to store XML data in their databases. Outside of those databases, XML has already invaded our SQL Servers. It’s made its way into execution plans with the SHOWPLAN XML. It’s telling us about deadlock through deadlock graphs. It’s also presented to us through service broke, event notifications, and extended events. XML is there and we need to learn how to query it. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to ease yourself into XQuery.

SessionID: 18387

Break it up! Implement Table Partitioning

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Kirby Richter

Title: Break it up! Implement Table Partitioning

Abstract:

Stuck with some huge, monolithic tables? Thought about aging out and archiving some of the data? This presentation covers the basics of table partitioning and why it might be the right solution for your database. There is a useful demo on implementing a sliding window approach for aging out data using a date partition column. We will also cover some performance considerations and maintenance tasks relevant to partitioning.

SessionID: 19574

Mission Critical Confidence – (SQL 2012 AlwaysOn) and Availability Groups

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Mark Skiles

Title: Mission Critical Confidence – (SQL 2012 AlwaysOn) and Availability Groups

Abstract:

AlwaysOn is SQL Server 2012’s High Availability solution. It provides a new standard for mission critical databases and end-to-end business intelligence at a lower total cost of ownership. It provides the required 9S of availability without the total cost and complexity.

In this session, we’ll specifically explore high availability databases – Availability Groups. AG is a new feature that enhances and combines database mirroring and log shipping. We’ll demonstrate the setup and failover of multiple databases simultaneously.

SessionID: 19635

MDX Trek: First Contact

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Mark Vaillancourt

Title: MDX Trek: First Contact

Abstract:

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

SessionID: 20643

Troubleshooting your TCP/IP connections

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Mike Hays

Title: Troubleshooting your TCP/IP 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: 22386

An Optimistic Approach: Snapshot Isolation in SQL

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Paul Timmerman

Title: An Optimistic Approach: Snapshot Isolation in SQL

Abstract:

Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case.

After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate.

Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!

SessionID: 22991

SQLSaturday: Design Your Game Plan to Maximize ROI

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Rick Krueger

Title: SQLSaturday: Design Your Game Plan to Maximize ROI

Abstract:

You may not realize this, but you need a solid plan to take advantage of the many amazing opportunities that SQLSaturday provides. SQLSatuday is structured to enable you achieve a variety of your goals; from building your professional network to attending technical sessions that solve problems you are facing right now, and more. My goal is to point out how to capitalize on those opportunities, by creating a plan to maximize your time investment.

SessionID: 24587

Interrogating the Transaction Log

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Frank Gill

Title: Interrogating the Transaction Log

Abstract:

Without the transaction log, SQL Server would have no way of maintaining a consistent and durable view of its data. It would be pandaemonium!!! Think of the Stay-Puft Marshmallow Man!

Thankfully the transaction log is there and we can all breathe easier. In this session, you will learn how SQL Server uses the transaction log to maintain the durability and consistency of its data, along with methods for reading the transaction log and identifying active transactions.

SessionID: 26602

SSIS Incremental Load Design Patterns

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Tim Mitchell

Title: SSIS Incremental Load Design Patterns

Abstract:

The volume of data addressed by the typical ETL operation is constantly on the rise. Not so many years ago, a table with a few million records was considered to be huge. These days, it's not uncommon to deal with multibillion row tables. As a result, ETL professionals are frequently tasked with finding efficient ways to incrementally process these large sets of data without resorting to expensive and time-consuming destructive reloads. In this session, we will review the common decision points surrounding incrementally loading data, and will illustrate some of the design patterns for incremental processing. Among the topics of discussion:-- Deciding whether an incremental load is appropriate-- Pick your tool: T-SQL or SSIS?-- Methods for detecting new and changed records-- Common incremental load design patterns

SessionID: 26603

Parent/Child Structures in SSIS

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Tim Mitchell

Title: Parent/Child Structures in SSIS

Abstract:

SQL Server Integration Services provides the ability to nest packages within one another in a parent/child structure. By creating a multilayer package infrastructure using native elements of SSIS, you can easily encapsulate reusable components of your ETL layer, simplify logging, and make the development process more efficient.In this session, we'll take a tour through the parent/child facilities within SSIS, including the following:-- Benefits of using parent/child structures-- Sharing values between parent and child packages-- Parent/child logging-- Dynamic child packages-- Changes in the Execute Package Task from SQL 2008 to SQL 2012We'll also walk through some practical examples of parent/child package implementations.

SessionID: 28108

Getting Started with Analysis Services 2012 Tabular

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 1

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: 28110

Prototyping with PowerPivot: Handling External Analysis Services 2012 Grouping

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: William E Pearson III

Title: Prototyping with PowerPivot: Handling External Analysis Services 2012 Grouping

Abstract:

Once the enterprise implements SSAS, immediate reporting benefits appear as the power of OLAP is unleashed in the speed of aggregations, the support of organization-wide ad hoc analysis and reporting, and myriad other advantages. A common need that then often arises is the capability to perform extra-hierarchy groupings. In this session, BI Architect and MVP Bill Pearson presents an approach to accomplishing external grouping with PowerPivot. We examine ways to accomplish a stated, example business need for such grouping via the addition of PowerPivot to an integrated Microsoft BI solution. Moreover, we discuss ways to design a scalable solution with PowerPivot that we can then entrain into the base warehouse / mart / cube structure.

SessionID: 9950

Moving Enterprise database to cloud

Back to calendar

Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Andy Thiru

Title: Moving Enterprise database to cloud

Abstract:

Windows Azure provides several different ways of storing and managing data. Windows Azure SQL Database and SQL Server in Windows Azure Virtual Machines are solutions in Windows Azure for working with relational data. If you are familiar with SQL Server, Windows Azure SQL Database will be a natural extension of your knowledge and skills.

In this session, you will learn:

  1. Windows Azure SQL Database - Learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to Windows Azure SQL Database. We will then walk through how to manage and administer your Windows Azure SQL servers and databases.
  2. Provision the SQL Server VM on Windows Azure - We will learn provisioning the Virtual Machine through the Windows Azure Management Portal. Once created, we will open the VM through the Remote Desktop . Finally, we will connect to SQL server using SSMS.