Welcome to SQLSaturday #391
SQL Saturday Jacksonville (Saturday May 9, 2015)
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 9, 2015 at Jacksonville, FL. Admittance to this event is free, all costs are covered by donations and sponsorship. Please register soon as seating is limited, and let friends and colleagues know about the event.
A full list of session tracks will be available soon but in the meantime, please suggest a session you'd like to see!
It is a great opportunity to learn from Microsoft MVPs, SQL Server authors, and professionals who have been through and can relate to the obstacles you have day to day. This one day training event is unlike any other providing free food, training and networking.
Saturday, May 9, 2015.
University of North Florida Campus, Main Campus, 1 UNF Drive, Jacksonville, FL 32224. Building 50.
Campus Map Link:
So what are you waiting for? Register today to be a part of SQL Saturday! #391!
Markets At Town Center
4840 Big Island Drive #05
Jacksonville, FL 32226
May 9, 2015 6:00-9:00 PM
Kid's Camp: Sign up now
Preconference Seminars (Friday May 8, 2015)
$129.00 per person
SSIS: Problem, Design, Solution
Join this full-day session to learn how to solve real world data extraction problems using SSIS with a variety of battle tested design patterns.
The session will start out with one of the most common challenges in ETL: data warehouses. We will show you a variety of competing patterns to load your dimensions and facts more efficiently and discuss the pros and cons of each. You’ll learn how to use SQL Server Change Data Capture integration into SSIS (CDC) and incremental loads to effectively load your data warehouse in the fastest way possible.
One of the most common design patterns needed is how to deal with duplicate data. The speakers will show an end-to-end solution to scrub duplicate data and give rows a scoring system to sift out the best records. You'll also see a number of advanced patterns for lesser-used tasks in SSIS like Term Extraction and Data Mining Transform.
These are just a few of the patterns that we will be demonstrating. With all of the solutions shown, you will be given an end-to-end project with all the packages and data. You'll come out of the session with a lot of options on how to do your ETL job.
Remember to bring your laptop since you’ll be able to work with the speakers on many of the patterns.
Also, please note that you will want to have at least beginner SSIS experience for this session.
Brian Knight, a SQL Server MVP, MCITP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. He is the author of a dozen SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Devin Knight, a Microsoft MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the President of the local users group (JSSUG).
Sign Up Now!
Full Day SQL Internals, Optimization, and Indexing Deep Dive Pre-con
Congratulations you’re a SQL Server DBA/Developer/BI Developer. How does SQL Server work? We have tables, views, and indexes. We write queries. How do the queries and the tables work together? Have you ever wondered? Why should you? Understanding how SQL Server works internally allows you to know how and when to use SQL Server to solve business problems. We need to understand the relational engine, index, transaction log, data, and locking internals. We need to know how these apply to business decisions that we make every day! Most importantly we need DEMOS!!! Join SQL Server MVP Bradley Ball & Gareth Swanepoel as we dive into the SQL Server Internals spanning from the Query Processor, through the Storage Engine, the Plan Cache and in between.
1. Inside the Query Optimizer
When it comes to making your queries run you need to understand how SQL Server reads a query and how the Optimizer works and return our physical data. How constraints, statistics, and simplification allow us to write better queries and use advanced techniques for solving every day issues.
Lab: Fixing the terrible, rotten, no good RBAR query
2. Deep Dive Data Internals
As a DBA we learn backwards. Most of the time you get a DBA job and you have Databases, that have tables, and in those tables you have data. Nobody tells you that we have records, stored on Pages, grouped in Extents, assigned by Allocation Bitmaps, with IAM Pages and Allocation Units that span Partitions and Filegroups. Today is your lucky day, we will start at the bottom and build our way up. We'll cover byte swapping, bitmaps, and dive a little into decoding Hex & binary. Working to give you a full understanding of database internals, and how you use them every day!
Lab: To Corrupt and Fix a Database
3. Index Internals
Why does SQL Server use an index for some queries and not for others? What makes a good index? How many indexes should I have? Have you ever asked these questions? When you want to understand an application you look at its core architecture. Underneath the covers SQL Server is just a C++ application. Together we will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.
Lab: Building A Better Index
4. Dive into the Transaction Log
One of the easiest areas to bottleneck the performance of a SQL Server instance is in the configuration of the transaction logs. In this section, we'll look at the internals for transaction logs and some of the important considerations that need to be taken into account while working with SQL Server. You'll learn how transaction logs work and their potential impact on performance.
Lab: VLF Fragmentation, Finding it and Fixing it
5. Deep Dive into Locking Internals & Latches
This topic sounds scary, but it’s not. Regardless of whether you have a small database with only a few users, or if you have a large multi-tenant system you have Locking, Blocking, Latches, and Spinlocks. Understanding what they are and how they work is the first step in understanding how to troubleshoot them. Deadlocks are a problem, but they are a problem we can fix. In this module we will explain and investigate how to find and fix the problems that we see in our database every day.
Lab: Fixing a Deadlock, with Your Hands Tied Behind Your Back
*Bonus Lab:* (if there is time) – Fixing Unbalanced Parallelism 3 Different Ways (Using Internals)
Sign Up Now!
Bradley Ball, a Microsoft SQL Server MVP with almost 15 years of IT experience. Bradley spent 8 years working as a defense contractor for clients such as the U.S. Army, The Executive Office of the President of the United States, and Publix Supermarkets. Currently the Data Platform Management Lead for Pragmatic Works and Microsoft VTSP. He has presented at many SQL Saturdays, for PASS SSUG’s, SQL Rally, DevConnections, SQL Live 360, & the PASS Summit 2011 - 2014. Published Author, including the recent SQL Server 2014 Pro Administrators Guide. He can be found blogging on http://www.sqlballs.com about SQL Server or anything else that interests him.
Gareth Swanepoel, a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 23 years. He enjoys solving the complex problems that his clients encounter when performance tuning SQL Server or when deploying SQL Server in data warehouse environments. He is originally from South Africa and currently lives in the quiet outskirts of Jacksonville, Florida. He is an accomplished author and speaker. Current projects include various speaking engagements at user groups, SQL Saturdays, the PASS Summit and other technical conferences. He currently serves as one of the PASS Regional Mentors for the US SouthEast region.