Hello all!  Fueling up for the long haul!  I am contemplating fueling up the SQL Bug and doing a cross country run!  If I had the time, I probably would do it!  That would be quite the cross-country jaunt, over the hills, through the woods, and over the dunes, to the Atlantic coast of Florida.  This time I will be catching a plane, but thinking about the SQL Bug adventures in-flight.

However ,if you are in the Jacksonville, Florida area SQL Saturday Jacksonville 2016 is coming to you live on Saturday, May 7, 2016.  SQL Saturday Jacksonville is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This year’s event will be held at The University of North Florida Campus, 1 UNF Drive, Jacksonville, Florida, 32224.   All that is required of you, is to go to the SQL Saturday Jacksonville 2016 website and register for the event.

The Jacksonville SQL Server Users Group Officers  work diligently to make sure this is the best SQL Saturday event in the world!  These guys really work hard behind the scenes to make this ALL happen.  So as both an attendee and a speaker, I really appreciate what you guys do!  Additionally, a BIG “THANK YOU” to all of the sponsors who have provided their support for this year’s event.  We can’t do it without your continued generosity and support!

There are a lot of talented people that will be speaking and providing sessions on an array of topics.  There is content and sessions for all levels.  However, I am going to take this opportunity to promote some of my Pragmatic Works family members who will be speaking.

 

Name	Twitter/Linked In	SQL Saturday Session(s)	Blog
Mitchell Pearson	@MitchellSQL	Designing a Data Warehouse from the Ground Up Advanced T-SQL for BI Developers	Mitchell SQL
Dan Taylor	@DBABullDog	More than Just a basic Database Backup and Recovery	DBA BullDog – Thoughts of a tenacious DBA
Phillip Labry	@PhillipLabry	Why do I need Analysis Services?	philliplabry.com
Adam Jorgensen	@wadmj	Step by Step – How to Build World Class Data Culture The Future of the Data Professional	Helping Find Your Maximum Volume
Maggie Goodhart	@MaggieGoodhart	Step by Step – How to Build World Class Data Culture
Devin Knight	@knight_devin	Kids Camp Advanced Power BI: Solving the Hard Problems	Devin Knight SQL
Brian Knight	@brianknight	Kids Camp
Chris Albrektson	@ChrisAlbrektson	Building your First Cube with SSAS	Chris Albrektson – SQL Tips and Tricks
Brad Gall		What’s new in Reporting Services 2016
Rowland Gosling	@BigSQL	Accelerating Batch Processing with Apache Spark	Big SQL
Shawn Harrison	@ShawnBHarrison	SSIS Performance Tuning	The SQL Goth
Mike Davis	@MikeDavisSQL	Mastering the Technology Interview	Mike Davis SQL

A full list of all the sessions can be found here!

Introduction to Azure Data Factory Service

At SQL Saturday Jacksonville 2016, I will be delivering a session titled  Introduction to Data Factory Service.

Today’s data landscape for enterprises continues to grow exponentially in volume, variety, and complexity.   It is more diverse than ever with on-premises and cloud-born data of different forms and velocities. Data processing must happen across geographic locations, and includes a combination of open source software, commercial solutions and custom processing services.

The agility needed to adapt to today’s changing Big Data landscape is an opportunity to merge the traditional EDW with capabilities required for a modern information production system. The Azure Data Factory service is the composition platform to work across traditional EDWs and the changing data landscape to empower enterprises to leverage all data that is available to them for data-driven decision making.

The Azure Data Factory service empowers enterprises to harness this diversity by providing a platform to compose data processing, storage, and movement services into information production pipelines, and manage trusted data assets.

See the  FalconTek Solutions Central blog post – Introduction to Azure Data Factory Service

SSAS Design and Performance Best Practices

Additionally, I will be delivering a presentation on SSAS Design and Performance Best Practices.

This is a topic that is a continual series on my blog. To date there have been four posts dedicated to this topic.  There are still some additional posts (3 – 4) coming in the near future.  As some people may not have the opportunity to attend the presentation, it is essentially a journey through a compilation of best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting SSAS cubes better optimized to better match the needs of your organization. My hope is that you are able to experience and have the following takeaways:

• best practice design patterns
• high level understanding of the SSAS internal engine and what role it plays
• tuning techniques that provide performance gains
• emphasis on the importance of solid multidimensional database design

See the  FalconTek Solutions Central blog post series:

• SSAS Multidimensional Best Practices Series – Part I – Introduction

• SSAS Best Practices Series – Part II – Identifying and Locating the Performance Issues

• SSAS Best Practices Series – Part III – Relational Data Source Design

• SSAS Best Practices Series – Part IV – Data Source Design Best Practices

See you at Jacksonville SQL Saturday!

Regards,

Alan Faulkner