Skip Main Navigation
Page Content
This event has ended

SQL Saturday 318 Seminar W/ Jason Horner

Friday, September 26, 2014 from 9:00 AM to 4:30 PM

SQL Saturday 318 Seminar W/ Jason Horner

Ticket Information

Ticket Type Sales End Price Fee Quantity
Zero to Dimensional Modeling Hero Ended $120.00 $0.00
SAVE $20! Attend Both Zero to Dimensional Modeling Hero and Enterprise Management and Monitoring Solutions Ended $220.00 $0.00

Who's Going

Loading your connections...

Share SQL Saturday 318 Seminar W/ Jason Horner

Event Details

Title: Zero to Dimensional Modeling Hero
SQL Speaker: Jason Horner
Speaker Bio:

Jason Is a Microsoft Certified Master SQL Server, and holds MCSE's in both Data Platform and Business Intelligence. Working with Sql Server as a DBA / Application Developer since version 6.5, he made the transition to delivering BI solutions in 2002 and began working with Spatial Data in 2008. Jason speaks frequently on a diverse range of topics from PowerShell to Dimensional Modeling at the local Colorado User Groups, SQL Saturdays, and other regional and national conferences including the Rocky Mountain Oracle User Group (RMOUG) Training Days, and PASS Business Analytics Conference (BACON)..

Abstract:

Dimensional modeling is arguably one of the most important fundamentals of business intelligence.  It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular.  Correctly modeling your organization's data not only
protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.

The precon is split into three main modules:

1. Dimensional modeling fundamentals
2. Advance Dimensional modeling design patterns
3. Group modeling exercises

Dimensional Modeling Fundamentals:
 This module will introduce the basic terminology and concepts in the Kimball methodology.  We will also provide a 15,000 foot overview of data warehouse architecture including the typical components and roles.

Case Study:
We will review some example dimensional models and point out the good, bad, and ugly.

Group Project: 
The final module will be a group project.  The class will be split into teams and given a small- to medium-size dimensional model to implement. Once this is complete, the groups will present their findings in a short 5 - 10 minute presentation highlighting some of the challenges and design tradeoffs with the reasons they were made.

Title: Enterprise Management and Monitoring Solutions with SQL Server 2012 / 2014
When: September 25th, 2014 9:00AM - 4:30PM
SQL Speaker: David Pless
Speaker Bio:

David Pless is a Senior Premier Field Engineer (PFE) at Microsoft Corporation and has been an engineer for the past seven years specializing in SQL Server performance tuning and optimization, SQL Server Reporting Services, and High Availability solutions. As a Premier Field Engineer at Microsoft, PFEs teach workshops, conduct performance reviews, complete health checks, and work to resolve reactive cases anywhere in the world. Before Microsoft, David Pless was a MCS partner consultant with Intellinet and a Database Administrator at CheckFree Corporation in Norcross, Georgia.

 David is also a Microsoft Certified Master (MCM) and has spoken a SQLSaturdays, SQLPASS, SQLIntersection, and regularly speaks at the local user groups in the Southeast.

Abstract:

In this pre-con session, we will cover performance monitoring and enterprise management strategies for SQL Server using various tools and technologies such as performance monitor, PowerShell, Extended Events, Policy Based Management, Resource Governor, and more.

This pre-con session will cover the following topics:

Real World Performance Monitoring
In this session we will discuss methods of using performance monitor for reactive analysis / long term monitoring and the best methods of capturing perfmon data. We will look at the different methods of capturing performance data through DMVs, Extended Events, PowerShell, and using various tools to obtain this performance data and automating captures. We will also focus on how to leverage the custom 'user settable' performance monitor counters to roll your own monitoring solutions. We will discuss methods to capture a performance baseline, and how to create a ready solution to obtain low-overhead, on-demand performance captures.

We will also cover the Performance Analysis of Logs (PAL) tool to analyze  perfmon counter data using engineer approved thresholds.

Report Server Performance Monitoring Strategies
In this session we will cover the best methods to track Reporting Services performance and the methods to improve report performance in your environment. We will cover methods of tracking report performance through DMVs, leveraging the ReportServer catalog ExecutionLog3 view, and finally will cover methods of rolling these solutions into a warehouse report using SSRS / SSIS to monitor report performance over time.

Resource Governor
Resource Governor, first introduced in SQL Server 2008, is a powerful solution for protecting critical workloads and limiting runaway queries in your SQL Server environment. As of SQL Server 2012 / 2014 we have the ability to set a hard-cap limits on CPU usage, the ability to affinitize one or more schedulers and NUMA nodes, and better control of memory resources. In SQL Server 2014 there is now support for controlling IO overhead. We will cover the DMVs and methods to use Resource Governor to monitor overall performance by functions such as APP_NAME() and mapping RG usage to perfmon for custom reporting.

Enterprise Policy Based Management
Policy Based Management is one of the hidden gems that has shipped since SQL Server 2008. We will take a look at some of the advanced scenarios for building a management and monitoring solution across your enterprise. We will cover using Central Management Server and Policy Based Management together, leveraging the Microsoft best practice policies, using ExecuteSQL and ExecuteWQL to extend functionality, and leveraging the Enterprise Policy Based Management Framework to report policy history usage over time.

Leveraging PowerShell for Management and Monitoring
In this lesson we will look at using PowerShell to automate management across your enterprise and extract performance related data. This lesson will cover an overview of PowerShell, using PowerShell to automatically evaluate configuration policies, using PowerShell to build an enterprise database configuration and backup compliance report, using PowerShell to parse error logs after system outages, and analyzing performance data from the operating system to SQL Server.

Have questions about SQL Saturday 318 Seminar W/ Jason Horner? Contact the organizer

When & Where


Hyatt Place Lake Mary/Orlando-North
1255 South International Pkwy
Lake Mary, FL 32746

Friday, September 26, 2014 from 9:00 AM to 4:30 PM


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.