Welcome to SQLSaturday #85 - OrlandoFree
SQL Server training! Lots of chances to win great prizes! What more
could a SQL Server Professional ask for? If this sounds good to you
then don’t miss your opportunity to attend SQL Saturday! #85 in the Orlando area.
#85? What is it? Why should you sacrifice a Saturday? When is it? Where is it? How do I get involved? Let me fill
is a one day training event for SQL Server DBAs and Developer
professionals and those wanting to get some intensive technical
It is a great opportunity to learn from people who have been there and
to network with other professionals doing the same thing you are
doing. Free training that can set yourself apart from others!
When: Saturday, September 24, 2011. Register online
now to reserve your spot now. Attendee check-in will begin at 7:30am
until 8:15am with opening comments from 8:15am to 8:25am and the first
sessions beginning at 8:30am.
Where: Seminole State College, Main Campus, 100 Weldon Boulevard Bld UP, Sanford, FL 32773.
How: All you have to do to get involved is Register online to reserve your spot. Show up and attend the sessions that you like.
So what are you waiting for? Register today to be a part of SQL Saturday! #85!
Call For Speakers is
* We do ask that you consider to OPT-IN for the Sponsors of this
event. Without their assistance, we cannot bring this FREE event to
you. You can always opt-out if and when they contact you! Thank you for
Pre-Con 1 - Buck Woody (Microsoft) - SQL Server Performance Tuning Using Application Path Analysis
There are a lot of resources, products and features you can use to tune the performance of your SQL Server system. Many assume you’re familiar with 400-level concepts, others don’t consider the whole stack of the client, the network, the operating system, platform and the database server. Buck Woody, Microsoft’s real-world DBA, will explain a simple, repeatable process you can follow to tune your entire application – from the client to the server. All of the tools we’ll cover are included with Windows and SQL Server:
· Using Windows System Monitoring Tools
· The SQL Profiler and Server Trace
· Database Engine Tuning Advisor
· Management Data Warehouse / Data Collector
· Performance and Configuration Reports
· The new Activity Monitor
· Dynamic Management Views and System Views
· Query Plans
· Extended Events
· Resource Governor
In this pre-conference session you’ll cover not only the process, but also review a real-world evaluation. You’ll take home a system and a spreadsheet you can use to monitor and tune your applications, in a simple, easy-to-understand session.
Buck Woody is a Senior Technical Specialist for Microsoft, working with enterprise-level clients to develop computing platform architecture solutions within their organizations. With over twenty-five years professional and practical experience in computer technology, he is also a popular speaker at TechEd, PASS and many other conferences; the author of over 500 articles and five books on databases; and teaches a Database Design course at the University of Washington
RSVP your spot in this all day Pre-Con session here!
Pre-Con 2 - Jorge Segarra, Bradley Schacht, Kyle Walker, Mike Davis (Pragmatic Works) - Business Intelligence Workshop
In this full-day workshop, you'll learn from the author team of Jorge Segarra, Mike Davis, Brad Schacht, and Kyle Walker how to build a data warehouse for your company and support it with the Microsoft business intelligence platform. We'll start with how to design and data model a data warehouse including the system preparation. Then, we'll jump into loading a data warehouse with SSIS. After SSIS, you're ready to roll the data up and provide the slice and dice reporting with SSAS. The team will walk through cube development and data enrichment with things like key performance indicators, which are essential for your future dashboards. Lastly, we will cover how to report against the data warehouse with SSRS including a primer in how to write MDX queries against the SSAS cube.
Practical knowledge of building a Dimensional Model
Designing a simple ETL process using SSIS
Designing a Cube
Designing simple SSRS Reports
Building an integrated process that fully leverages the entire MS BI stack to load a Data Warehouse
Jorge is a BI Consultant for Pragmatic Works and a SQL Server MVP. In addition to being a member of the Jacksonville SQL Server User Group (JSSUG) he is also a PASS Regional Mentor for the U.S. Greater Southeast region. He has also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“. Redgate Exceptional DBA of the Year 2010 Finalist.
Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer. Bradley has experience on many part of the Microsoft BI platform. He has spoken at events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).
Kyle is a Business Intelligence consultant for Pragmatic Works. His current and past work experience includes Integration Services, data warehousing concepts, Reporting Services, and Crystal Reports. He is active in the local and online community as a speaker for SQL Lunch, Jacksonville SQL Server Users Group, and past SQLSaturday events, as well as a blogger on BIDN.com.
Mike Davis, MCTS, MCITP, is a Senior BI consultant at Pragmatic Works. He is an author of a few Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQL Rally, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
RSVP your spot in this all day Pre-Con session here!