SQLSaturday #239 - East Iowa 2013

Event Date: 07/27/2013 00:00:00

Event Location:

  • University of Iowa - University Capitol Centre
  • 201 S Clinton St
  • Iowa City, Iowa

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


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.

Speaker(s):

  • Andy Thiru

Track and Room: Track 4 - N/A


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.

Speaker(s):

  • Doug Lane

Track and Room: Track 1 - N/A


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

Speaker(s):

  • Tim Mitchell

Track and Room: Track 3 - N/A


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.

Speaker(s):

  • Jason Strate

Track and Room: Track 1 - N/A


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.

Speaker(s):

  • William E Pearson III

Track and Room: Track 1 - N/A


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.

Speaker(s):

  • Doug Lane

Track and Room: Track 2 - N/A


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.

Speaker(s):

  • Tim Mitchell

Track and Room: Track 2 - N/A


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.

Speaker(s):

  • William E Pearson III

Track and Room: Track 1 - N/A


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).

Speaker(s):

  • Louis Davidson

Track and Room: Track 1 - N/A


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.

Speaker(s):

  • Kirby Richter

Track and Room: Track 2 - N/A


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.

Speaker(s):

  • Eric Selje

Track and Room: Track 4 - N/A


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

Speaker(s):

  • Louis Davidson

Track and Room: Track 2 - N/A


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.

Speaker(s):

  • Mark Skiles

Track and Room: Track 3 - N/A


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.

Speaker(s):

  • Rick Krueger

Track and Room: Track 3 - N/A


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.

Speaker(s):

  • Jason Strate

Track and Room: Track 2 - N/A


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.

Speaker(s):

  • Mark Vaillancourt

Track and Room: Track 4 - N/A


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!

Speaker(s):

  • Paul Timmerman

Track and Room: Track 3 - N/A


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.

Speaker(s):

  • Mike Hays

Track and Room: Track 4 - N/A


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.

Speaker(s):

  • Frank Gill

Track and Room: Track 4 - N/A


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.

Speaker(s):

  • Ed Leighton-Dick

Track and Room: Track 3 - N/A


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Mike Hays

LinkedIn: Mike Hays

Contact: http://www.thesqlreport.com/

Mike has been working with Microsoft SQL Server for the last twenty years. Currently working as a Database Administrator for a diversified energy company, he has also worked in the retail, manufacturing, banking sectors. He holds a Master’s degree in Computer Information Science from Cleveland State University. He currently resides in Ohio with his girlfriend Alexia, her two children and their dog Lanna.

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Kirby Richter

Twitter: - @sqlkirby

LinkedIn: Kirby Richter

Kirby Richter is a Minnesota SQL Server Professional with 20 years’ experience. Currently Principal Database Architect at Dell Storage, specializing in Database Administration, large databases and Performance Tuning. Working with all versions of SQL Server since 6.5 Enjoys Development, Database Administration and Business Intelligence. Presents periodically at local events. Hobbies include kayaking, camping and amateur Astronomy.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Mark Skiles

Mark Skiles is a (BI) Solutions Architect with GNet Group based in Minneapolis, MN. He is an international consultant and has worked for EDS in Taiwan and traveled extensively in China and Southeast Asia. He has over 23 years of technology experience and has worked with SQL server since 1995. His areas of interest are designing and integrating large scale databases and continual improvement in the presentation of data – ways to turn data into information and “data to decisions”.

Mark Vaillancourt

Twitter: - @markvsql

LinkedIn: Mark Vaillancourt

Contact: http://markvsql.com

Mark is a Data Solutions Architect for Microsoft, helping organizations design data solutions in Azure. He has been working with Microsoft data technologies since 2007. Before joining Microsoft, he was a Business Intelligence consultant and two-time Microsoft Data Platform MVP. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.

Doug Lane

Contact: http://www.douglane.net

Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.

Paul Timmerman

Contact: http://blogs.lessthandot.com/index.php/author/mndba/

Paul is a Microsoft SQL Server MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has fifteen years of experience in database administration and currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQLSaturday conferences.

Jason Strate

Twitter: - @stratesql

LinkedIn: Jason Strate

Contact: http://www.jasonstrate.com/

Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Andy Thiru

Andy aka Abhi has several years of BI experience including planning, design, development and implementation in business database applications. Andy has worked primarily as a consultant holding positions primarily in the Energy, Banking, Media and Consulting fields. He is currently working on Cloud development projects.

Jason Strate

Twitter: - @stratesql

LinkedIn: Jason Strate

Contact: http://www.jasonstrate.com/

Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.

Eric Selje

Twitter: - @ericselje

Contact: http://saltydogllc.com

Eric Selje is a developer and consultant in Madison, WI who works on a wide variety of applications, from desktop to web to mobile - all of them requiring databases. Eric has for private businesses, non-profits, and is now working for the U.S. Courts. He has been a user group leader since 1995, and other than coding he loves playing Ultimate and baseball, doing crosswords and reading.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Rick Krueger

Twitter: - https://twitter.com/dataogre

LinkedIn: Rick Krueger

Contact: http://www.dataogre.com

Rick Krueger has been working with SQL Server as either a Developer or a Development DBA for over 20 years. He is a veteran Independent Consultant, Lead Development DBA and BI Developer based in the Twin Cities. Rick is giving back to the SQL Community by being an active member and presenting at PASSMN, blogging at DataOgre.com, and presenting at SQLSaturdays in the MidWest.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Doug Lane

Contact: http://www.douglane.net

Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page