sqlsathistory

Nr: 298

Back to Main list

SQLSaturday #298 - Jacksonville 2014

Start Time (24h) Speaker Track Title
00:00:00 Bradley Ball BI Inside the Query Optimizer
00:00:00 Brian McDonald BI Rapid Data Warehouse Design and ETL
00:00:00 Chris Skorlinski DBA Check Engine Lights
00:00:00 Dmitri Korotkevitch DBA From S to 3XL: Implementing Data Partitioning and Tiered Storage
00:00:00 Dustin Ryan BI (Auditorium 2) What The Tabular???
00:00:00 Jorge Novo BI ETL Frameworks using SSIS Programming with .NET
00:00:00 Eric Wisdahl DBA Free tools from the SQL Server Community
00:00:00 Jason Carter DBA Maintenance and Backups: Intro to Ola Hallengren
00:00:00 Jason Strate DBA Shredding XML in SQL Server
00:00:00 Jeffrey Garbus DBA Indexing for performance
00:00:00 John Welch Big Data (Auditorium 1) Moving Big Data - SSIS, Pig, and Sqoop
00:00:00 Jorge Segarra BI (Auditorium 2) What is a BI DBA?
00:00:00 Josh Luedeman Big Data (Auditorium 1) Show me whatcha workin' with: Big Data Edition
00:00:00 Joe Salvatore BI Fundamentals of Data Warehouse Architecture and Design
00:00:00 Devin Knight Kids Camp Kids Camp
00:00:00 Devin Knight Big Data (Auditorium 1) Big Data Panel
00:00:00 Lisa Jackson-Neblett DBA SQL Server Extended Events
00:00:00 Mark Kromer Big Data (Auditorium 1) SQL Server and Big Data Projects in the Real World
00:00:00 Maximo Trinidad DBA Powershell Working with Windows Azure SQL Database Server
00:00:00 Mike Davis DBA Mastering the Technology Interview
00:00:00 Gareth Swanepoel DBA SQL Server 2014 for the DBA
00:00:00 Michael Antonovich BI Putting Quality Back Into Your Data Analysis
00:00:00 Mike Lawell DBA Performance Tuning for Mere Mortals
00:00:00 Mitchell Pearson BI (Auditorium 2) Introduction to SSIS, SQL 2012
00:00:00 Michael Reed Big Data (Auditorium 1) Intro to Big Data
00:00:00 Nengah Mustika BI Working with Maps in Reporting Services
00:00:00 Troy Gallant DBA Indexing your Data Warehouse
00:00:00 Pam Shaw BI Tips Tricks for dynamic SSRS Reports
00:00:00 Robert Biddle BI Detecting Changes in SQL Server
00:00:00 Ronald Dameron DBA SQL Server Security Easy Button
00:00:00 Sandhya Hawaldar BI SSRS 2012 Introduction and Capabilities
00:00:00 Shawn Harrison BI (Auditorium 2) SSIS Performance Tuning
00:00:00 Chad Churchwell DBA Introduction to SQL Server Clustering
00:00:00 Steve Schneider BI (Auditorium 2) SQL 2012 Empowers SharePoint BI
00:00:00 VIKAS HAWALDAR HAWALDAR BI Add power to SSAS Cube Using MDX
00:00:00 Damu Venkatesan BI DAX 101
00:00:00 Jason Virtue DBA Breakthrough Data Platform Performance with SQL Server 2014
00:00:00 Valentin Iamandi DBA Ola Hallengren Maintenance - How to and Advanced configurations
00:00:00 Adam Jorgensen Big Data (Auditorium 1) On-Demand Compute and Analytics with Powershell, Hadoop and Azure
00:00:00 Andy Warren DBA Building Your Professional Development Plan
00:00:00 Robert Cain BI So you think MDX is hard?

SessionID: 10156

Inside the Query Optimizer

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Chris Skorlinski

Title: Check Engine Lights

Abstract:

Problem with Windows server, IO storage or SQL Server stopped your business dead in its tracks? Together we'll explore "check engine lights" for your SQL Server warning you of pending doom. I'll cover Performance Monitor, IO STACK, Dashboards, ErrorLogs, and DMVs to keep your server and SQL Server running smooth.

SessionID: 13290

From S to 3XL: Implementing Data Partitioning and Tiered Storage

Back to calendar

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:

Support of the large databases is not a trivial task. Large amount of data negatively impacts system performance and make administration and SLA compliance much more complicated. Data partitioning can help to solve those problems and reduce support and hardware cost. This session demonstrates various approaches of data partitioning available in SQL Server. It compares pros and cons of different partitioning techniques from performance, scalability and administration standpoints. The session also discusses how to reduce hardware cost by implementing tiered storage and demonstrates how to move data between filegroups and/or disk arrays keeping the system online in the different versions and editions of SQL Server.

SessionID: 13495

What The Tabular???

Back to calendar

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

Back to calendar

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

Free tools from the SQL Server Community

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Eric Wisdahl

Title: Free tools from the SQL Server Community

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

Back to calendar

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

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Jason Strate

Title: Shredding XML in SQL Server

Abstract:

Whether your a DBA or a developer, you will eventually need to write a query transforms XML data into rows and columns. It's there in client data feeds, files shipped from customers, and underneath the covers of SQL Server's own execution plans. The fact is, it's there, and you need query that data. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to tear apart any XML like an old pro.

SessionID: 16326

Indexing for performance

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Jeffrey Garbus

Title: Indexing for performance

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

Back to calendar

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:

Wondering about Hadoop, and how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.

SessionID: 17418

What is a BI DBA?

Back to calendar

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

Back to calendar

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:

Congratulations. You've setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.

SessionID: 17622

Fundamentals of Data Warehouse Architecture and Design

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Lisa Jackson-Neblett

Title: SQL Server Extended Events

Abstract:

This session will cover extended events and how to use it for troubleshooting performance issues.

SessionID: 19671

SQL Server and Big Data Projects in the Real World

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Performance Tuning for Mere Mortals

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Mike Lawell

Title: Performance Tuning for Mere Mortals

Abstract:

Performance tuning is a very large very scary task as an early DBA. This session will tackle the most important steps for getting started and go over some of the best free tools for getting started in the performance tuning specialty. Throughout this session will be demonstrations of how to leverage the free tools to identify performance issues.

SessionID: 21010

Introduction to SSIS, SQL 2012

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)

Speaker: Mitchell Pearson

Title: Introduction to SSIS, SQL 2012

Abstract:

SessionID: 21113

Intro to Big Data

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Troy Gallant

Title: Indexing your Data Warehouse

Abstract:

One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.

SessionID: 22357

Tips Tricks for dynamic SSRS Reports

Back to calendar

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

Back to calendar

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

SQL Server Security Easy Button

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Ronald Dameron

Title: SQL Server Security Easy Button

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

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI

Speaker: Sandhya Hawaldar

Title: SSRS 2012 Introduction and Capabilities

Abstract:

During this session the presenter will present an hands on session on basic steps to develop SSRS reports with some basic features. After this presentation the presenter will present several pre-built examples to show capabilities of SSRS like Conditional Formatting, Linked Reports, Sub Reports etc. as well as some advanced features like Custom Code.

SessionID: 24406

SSIS Performance Tuning

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)

Speaker: Shawn Harrison

Title: SSIS Performance Tuning

Abstract:

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?

SessionID: 24898

Introduction to SQL Server Clustering

Back to calendar

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

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: BI (Auditorium 2)

Speaker: Steve Schneider

Title: SQL 2012 Empowers SharePoint BI

Abstract:

I will bring to life how SQL 2012 empowers the BI of SharePoint BI. Meaning...what parts of SQL yield what parts of SharePoint BI. Where are the SQL parts, where can you see and manage them? How does the consumer see them. How can you tell what the consumer is seeing? What tools are used to build what parts of SharePoint BI? Real-life examples of how SharePoint BI is implemented in the City of Jacksonville will be used as examples.

SessionID: 27318

Add power to SSAS Cube Using MDX

Back to calendar

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

Back to calendar

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

Breakthrough Data Platform Performance with SQL Server 2014

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Jason Virtue

Title: Breakthrough Data Platform Performance with SQL Server 2014

Abstract:

This session covers the following topics: evolution of the data platform, mission critical performance, faster insights from any data, platform for hybrid cloud and complete data platform. SQL Server 2014 will go GA and be the first ones to see the new release.

SessionID: 9043

Ola Hallengren Maintenance - How to and Advanced configurations

Back to calendar

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

Back to calendar

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:

This session will take the beginner in big data and show them how to use powershell, HDinsight and Microsoft's Azure platform to enable on demand analytic and compute. These capabilities are critical in the modern data warehouse environment and can only be delivered by technologies working together to create an analytic fabric that the organization can use. From developers the analysts and operations folks, this session will have something for all of you.

SessionID: 9563

Building Your Professional Development Plan

Back to calendar

Event Date: 10-05-2014 - Session time: 00:00:00 - Track: DBA

Speaker: Andy Warren

Title: Building Your Professional Development Plan

Abstract:

Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.

SessionID: 9723

So you think MDX is hard?

Back to calendar

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.