SQLSaturday Jacksonville is right around the corner, and we are so excited for it! It seems that almost the entire Pragmatic Works' Jacksonville office will be participating in the conference, and they are presenting on some great topics.
SQLSaturday Jacksonville will be held Saturday, May 9, 2015, at the University of North Florida Campus, Main Campus, 1 UNF Drive, Jacksonville, FL 32224, Building 50.
Additional precon sessions will be held at UNF on Friday, May 8, 2015.
SQLSaturday Jacksonville Precon Sessions - Friday, May 8, 2015
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.
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 us as we dive into the SQL Server Internals spanning from the Query Processor, through the Storage Engine, the Plan Cache and in between.
SQLSaturday Jacksonville Sessions - Saturday, May 9, 2015
SSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation, we will cover many basic options and features that you can use to performance tune any SSIS package. Who wouldn’t want better package performance?
In this session, Michael will introduce the data mining capabilities of Excel. We will talk about scenarios for the use of the tools and how to interpret the results. We will cover data preparation with respect to the mining models. We will also discuss the very important issue of "margin of error" and the dangers of misinterpreting and/or misapplication of the tools and results. Attendees can expect to leave with a clear understanding of the available data mining tools along with how and when to use them.
In today's world of technology interview, employees have come up with more and more tricks and puzzles to test your brain. How would you move mount fuji? How many basketballs would fit in this room? In this session Mike will cover these questions and many more. You will leanr what not to say and how to handle tough questions.
So you have used SSIS for years to do all your ETL and loading of your data warehouse, but did you know you could also handle all your cube processing inside of SSIS? In this session Mitchell will introduce you to four little know tasks in SSIS that will help to automate the processing of your cube.
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!
Join Gareth in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. He will run through the simple process of configuring a Windows Azure SQL database, investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases and even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.
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.
In this session, Brad will explore how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files. He will then discuss some of the DOs and DON’Ts of the SSIS ETL world. We will discuss ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that you may not be able to handle all in memory, and bring multiple sources into one destination. Other topics to be covered include the types of transforms (partially blocking vs fully blocking), which transforms are right for which jobs and which transforms to avoid for efficient ETL creation.
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data. Most data warehouses are in a constant state of flux. There are new requirements coming in from the business, updates and improvements to be made to existing data and structures, and new initiatives that drive new data requirements. How do you manage the complexity of keeping up with the changes and delivering new features to your business users in a timely manner, while maintaining high quality? Continuous delivery is an approach for managing this. It focuses on automation of many steps in the process, so that time is spent on adding new functionality, rather than repetitive steps. Attend this session and learn how Continuous Delivery can be applied to your data projects.
The Azure platform is ever changing. Today is no different. Azure has released a new tool called Data Factory. It is a cloud PaaS that is SSIS in the cloud. Are you curious what all it entails and if you can use it? In this session, we'll go over the basics of Data Factory like structure, billing, and building blocks. We'll go over a couple instances on how you can use Data Factory in current processes that you have in your data warehouse ETL.
In this session you 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. This is the first step in learning how to use the Optimizer's rules to make your queries faster!
Get up and close with developing a predictive model with Azure ML. This session will build a predictive model using mobile advertising click-through data. Gain an understanding of how a predictive model is evaluated, validated and given a return on investment to ensure it is capable of making real world predictions.
Our Kids' Camp is a technology adventure camp which aims to help kids ages 9-17 understand the basics of programming and other fun technology-related subjects.The students will get to create their own exciting games and robots while learning fundamental technology concepts. All programming is done through a free interactive game design system called Kodu, and Lego Mindstorm programmable robots.
Plan on attending SQLSaturday Jacksonville? Tweet and let us know! @PragmaticWorks