Nr: 298
SQLSaturday #298 - Jacksonville 2014
SessionID: 10156
Inside the Query Optimizer
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Bradley Ball
Title: Inside the Query Optimizer
Abstract:
When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.
SessionID: 10527
Rapid Data Warehouse Design and ETL
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Brian McDonald
Title: Rapid Data Warehouse Design and ETL
Abstract:
Simply loading a data warehouse is only part of an ETL developers role. In this example driven session, Brian and Sherri will show you how to create and load a small data warehouse using SQL Server Integration Services. They will also show you how to make packages dynamic using variables and package configurations along with a few other "nice to have tricks" to include in your ETL arsenal. At the end of this session, you will be ready to take on the world. Well, maybe not the world, but you will know how to load a data warehouse.
SessionID: 11540
Check Engine Lights
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Chris Skorlinski
Title: Check Engine Lights
Abstract:
SessionID: 13290
From S to 3XL: Implementing Data Partitioning and Tiered Storage
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Dmitri Korotkevitch
Title: From S to 3XL: Implementing Data Partitioning and Tiered Storage
Abstract:
SessionID: 13495
What The Tabular???
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)
Speaker: Dustin Ryan
Title: What The Tabular???
Abstract:
Knowing how to build a Tabular model is one thing. Knowing how to build a Tabular model the right way is something completely different. In this session we’ll discuss how to decide if building a Tabular model is the right choice, how to build a Tabular model completely from scratch, best practices you should follow, and things to avoid. If you’re new to Tabular Modeling or wanting to learn best practices, this session is for you!
SessionID: 13986
ETL Frameworks using SSIS Programming with .NET
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Jorge Novo
Title: ETL Frameworks using SSIS Programming with .NET
Abstract:
Every organization has to deal with the constant loading of text,csv,excel,pipe, fixed width, and ragged right files in this session we are going to build a metadata driving ETL framework that will dynamically create an standard SSIS template that will encompass the file format, enforce standards, and keep track of data lineage across an organization.
SessionID: 14017
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Eric Wisdahl
Abstract:
No budget? That's OK! Need Tools? We've get them! Don't know where to go? We'll show you! The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out. In this session we will show you several great tools, scripts, blogs and other resources to help you out. Best of all, it's all free! But wait, there's more. Order now and we'll include an extra two tips at no additional cost!
SessionID: 15798
Maintenance and Backups: Intro to Ola Hallengren
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Carter
Title: Maintenance and Backups: Intro to Ola Hallengren
Abstract:
This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.
SessionID: 15988
Shredding XML in SQL Server
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Strate
Title: Shredding XML in SQL Server
Abstract:
SessionID: 16326
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Jeffrey Garbus
Abstract:
Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
SessionID: 17180
Moving Big Data - SSIS, Pig, and Sqoop
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: Big Data (Auditorium 1)
Speaker: John Welch
Title: Moving Big Data - SSIS, Pig, and Sqoop
Abstract:
SessionID: 17418
What is a BI DBA?
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)
Speaker: Jorge Segarra
Title: What is a BI DBA?
Abstract:
Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!
SessionID: 17528
Show me whatcha workin' with: Big Data Edition
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: Big Data (Auditorium 1)
Speaker: Josh Luedeman
Title: Show me whatcha workin' with: Big Data Edition
Abstract:
SessionID: 17622
Fundamentals of Data Warehouse Architecture and Design
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Joe Salvatore
Title: Fundamentals of Data Warehouse Architecture and Design
Abstract:
This session will cover key ideas for organizing the hardware and software environment into appropriate logical and physical tiers in order to best support data warehouse extraction, staging, and data mart processes. Additionally the session will cover key differences in leading data warehouse architectures and will finish with a primer on dimensional modeling.
SessionID: 18652
Kids Camp
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: Kids Camp
Speaker: Devin Knight
Title: Kids Camp
Abstract:
For SQL Saturday attendees' children only (children 9-17). The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program. Space is limited so you must preregister your kids here. http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/171054562/
SessionID: 18653
Big Data Panel
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: Big Data (Auditorium 1)
Speaker: Devin Knight
Title: Big Data Panel
Abstract:
A panel of Big Data experts will take part in a discussion on the current and future state of Big Data
SessionID: 19167
SQL Server Extended Events
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Lisa Jackson-Neblett
Title: SQL Server Extended Events
Abstract:
SessionID: 19671
SQL Server and Big Data Projects in the Real World
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: Big Data (Auditorium 1)
Speaker: Mark Kromer
Title: SQL Server and Big Data Projects in the Real World
Abstract:
In this session, I will skip past the Big Data 101 introductions and talk to you about specific Big Data projects that I have been involved with and how we've used Big Data technologies including Hadoop, MongoDB, Cassandra and Aster Data with SQL Server to create complex Big Data Analytics solutions. I've implemented solutions for Microsoft, Razorfish and Pentaho in this space and we're going to talk about solution architectures.
SessionID: 19909
Powershell Working with Windows Azure SQL Database Server
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Maximo Trinidad
Title: Powershell Working with Windows Azure SQL Database Server
Abstract:
In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)
SessionID: 19976
Mastering the Technology Interview
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Mike Davis
Title: Mastering the Technology Interview
Abstract:
Join Mike as he shows you how to be prepared for technology job interviews. Learn the do's and don'ts of interviewing for technology jobs. Learn what your resume says about you and your ability to grow. Learn how passion can overcome a lack of skills.
SessionID: 20034
SQL Server 2014 for the DBA
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Gareth Swanepoel
Title: SQL Server 2014 for the DBA
Abstract:
SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s to some of the new and exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton) and Extended Events enhancements.
The target of this session is SQL Server DBA’s, developers, architects or IT professionals who are excited about the new SQL Server 2014 features and are looking to learn more about them. This class assumes that you have average to good T-SQL skills already and a good understanding of SQL Server fundamentals.
SessionID: 20491
Putting Quality Back Into Your Data Analysis
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Michael Antonovich
Title: Putting Quality Back Into Your Data Analysis
Abstract:
This session introduces Data Quality Services, a feature introduced in SQL Server 2012. One of the challenges in developing Business Intelligence solutions is ensuring that the data does not have inconsistencies, incomplete records, invalid or inaccurate values, and data duplication. Sometimes when consolidating data from more than one source you have to transform data to create one standard set of domain values in a standard format. SQL 2012 answers this need with Data Quality Services (DQS). In this session, you will learn the basics of what DQS is and how it can be used to clean your data. You will see how to build a domain both manually and from an existing data table. You will then see how to use these domains to validate tables in SQL Server and Excel preparing them for use in SSAS and PowerPivot. After this session, you will understand how by putting quality back into your data, you can be your organization's BI hero.
SessionID: 20602
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Mike Lawell
Abstract:
SessionID: 21010
Introduction to SSIS, SQL 2012
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)
Speaker: Mitchell Pearson
Title: Introduction to SSIS, SQL 2012
Abstract:
In this session we will walk through the development of a complete package. This demo heavy presentation will cover the differences between the control flow and the data flow. We will also focus on the most popular and widely used tasks in SSIS. Best practices willed be emphasized and we will also explore how to use variables and expressions to make the package dynamic.
SessionID: 21113
Intro to Big Data
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: Big Data (Auditorium 1)
Speaker: Michael Reed
Title: Intro to Big Data
Abstract:
This is a primer for anyone not clear on what Big Data is and the basics of implementing a Big Data solution, focusing on the Microsoft HDInsight offering.
SessionID: 21476
Working with Maps in Reporting Services
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Nengah Mustika
Title: Working with Maps in Reporting Services
Abstract:
In this session, we are going to learn how to create Maps using Reporting Services. We will go over the detail of choosing a map file, linking a map to a dataset, visualizing data in a map, and Map elements (Viewport properties, projection, scales, legends, center points, and creating size rules).
SessionID: 21586
Indexing your Data Warehouse
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Troy Gallant
Title: Indexing your Data Warehouse
Abstract:
SessionID: 22357
Tips Tricks for dynamic SSRS Reports
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Pam Shaw
Title: Tips Tricks for dynamic SSRS Reports
Abstract:
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
SessionID: 23149
Detecting Changes in SQL Server
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Robert Biddle
Title: Detecting Changes in SQL Server
Abstract:
In this session we'll look at methodologies for detecting data changes in SQL Server. We'll look mainly at Change Data Capture but will also cover row versioning as well as a few other methodologies.
SessionID: 23441
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Ronald Dameron
Abstract:
Attendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.
DBAs will leave this session with an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data.
In addition, I’ll talk about our DBA’s real world experience with reduced permissions
SessionID: 23789
SSRS 2012 Introduction and Capabilities
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Sandhya Hawaldar
Title: SSRS 2012 Introduction and Capabilities
Abstract:
SessionID: 24406
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)
Speaker: Shawn Harrison
Abstract:
SessionID: 24898
Introduction to SQL Server Clustering
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Chad Churchwell
Title: Introduction to SQL Server Clustering
Abstract:
This session s will provide an introductory into failover clustering of SQL Server, including when and why to cluster SQL. We will cover the required components and walk through how clustering works behind the scenes
SessionID: 25300
SQL 2012 Empowers SharePoint BI
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)
Speaker: Steve Schneider
Title: SQL 2012 Empowers SharePoint BI
Abstract:
SessionID: 27318
Add power to SSAS Cube Using MDX
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: VIKAS HAWALDAR HAWALDAR
Title: Add power to SSAS Cube Using MDX
Abstract:
The presenter will provide some basic ideas about MDX and will demonstrate developing some commonly required effective calculated measures into an SSAS cube.
SessionID: 27348
DAX 101
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Damu Venkatesan
Title: DAX 101
Abstract:
In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
SessionID: 27463
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Virtue
Abstract:
SessionID: 9043
Ola Hallengren Maintenance - How to and Advanced configurations
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Valentin Iamandi
Title: Ola Hallengren Maintenance - How to and Advanced configurations
Abstract:
Overview
Simple Use for novice DBA
Stored procedures settings and parameters
CommandLog table, why and how to use it to implement further tuning and optimizations
IndexOptimize Stored Procedure modifications for a better statistics maintenance
How to add parameters inline at the maintenance job execution time
SessionID: 9137
On-Demand Compute and Analytics with Powershell, Hadoop and Azure
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: Big Data (Auditorium 1)
Speaker: Adam Jorgensen
Title: On-Demand Compute and Analytics with Powershell, Hadoop and Azure
Abstract:
SessionID: 9563
Building Your Professional Development Plan
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Andy Warren
Title: Building Your Professional Development Plan
Abstract:
SessionID: 9723
So you think MDX is hard?
Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI
Speaker: Robert Cain
Title: So you think MDX is hard?
Abstract:
A lot of people have this perception that MDX is difficult. It really isn't, when you understand what it is trying to accomplish under the hood. In this session we'll begin with a fundamental understanding of what MDX will do for you. Then we'll roll up our sleeves and dive into MDX code, starting from the simplest select statement and winding up building calculations you can put into your own SSAS Cubes.