SQL Saturday 318 Seminar W/ Jason Horner
Friday, September 26, 2014 from 9:00 AM to 4:30 PM
|Title:||Zero to Dimensional Modeling Hero|
|SQL Speaker:||Jason Horner|
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)..
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
The precon is split into three main modules:
1. Dimensional modeling fundamentals
Dimensional Modeling Fundamentals:
|Title:||Enterprise Management and Monitoring Solutions with SQL Server 2012 / 2014|
|When:||September 25th, 2014 9:00AM - 4:30PM|
|SQL Speaker:||David Pless|
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.
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
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
Enterprise Policy Based Management
Leveraging PowerShell for Management and Monitoring