sqlsathistory

Nr: 391

SQLSaturday #391 - Jacksonville 2015

Start Time (24h)	Speaker	Track	Title
00:00:00	Gene Webb	Other	Learn How To Build A Golden Record for Any Subject Over Lunch!
09:00:00	John Kauffman	DBA – Troubleshooting and Performance Tuning	Data Compression – Why and How
09:00:00	Lisa Jackson-Neblett	DBA – Database Development	PowerShell for SQL Server Administrators
09:00:00	Mike Davis	Personal Development	Interview Puzzles and how to handle them
09:00:00	Mitchell Pearson	Enterprise BI	Process SSAS Cubes with SSIS
09:00:00	Michael Reed	Self-Service BI	Data Mining with Excel 2013
09:00:00	Shawn Harrison	Enterprise BI	SSIS Performance Tuning
09:00:00	Shawn Meyers	DBA – Troubleshooting and Performance Tuning	HA in an about an Hour
09:00:00	Devin Knight	Other	Kids Camp
10:15:00	Dmitri Korotkevitch	DBA – Troubleshooting and Performance Tuning	Size does matter: 10 ways to reduce the database size and improve performance
10:15:00	Dustin Ryan	Enterprise BI	Welcome to SSAS Tabular Models
10:15:00	Jeffrey Garbus	Other	Indexing for performance
10:15:00	Kurt Amundson	Self-Service BI	Power BI 101
10:15:00	Steve Schneider	Enterprise BI	Government Transparency Powered by SharePoint 2013 and Sql 2012
10:15:00	Jason Virtue	Azure	Azure Data Services – Real-time Analytics
10:15:00	Arvin Meyer	DBA – Database Development	Access As A Front-end to SQL-Server
12:00:00	Kevin Feasel	Big Data	Much Ado About Hadoop
12:00:00	Jason Thomas	Enterprise BI	DataViz You Thought You Couldn't Do with SSRS
12:00:00	Jonathon Moorman	DBA – Database Development	Database Projects: Development and Deploying
12:00:00	Gareth Swanepoel	Azure	A practical guide to Windows Azure SQL Database for the DBA
12:00:00	Troy Gallant	DBA – Troubleshooting and Performance Tuning	Indexing your Data Warehouse
12:00:00	Andy Warren	Personal Development	Turbocharge Your Career With a Learning Plan
12:00:00	Robert Cain	Enterprise BI	So you think MDX is hard?
13:15:00	Leigh Freijo	Personal Development	Why I won't hire you and what you can do about it!
13:15:00	Michael Antonovich	Self-Service BI	Calculated Columns, Measures, and KPIs, Oh My!
13:15:00	Robert Biddle	Other	Introduction To R
13:15:00	Rodney Landrum	DBA – Database Development	Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure
13:15:00	Chad Churchwell	DBA – Troubleshooting and Performance Tuning	Introduction to SQL Server Clustering
13:15:00	Tricia Reynolds	Enterprise BI	Smooth Data Moves
13:15:00	Bill Anton	Enterprise BI	Analysis Services: Show Me Where It Hurts
14:45:00	Fred Stimler	Self-Service BI	Poor Man's GIS using Tabular and Power View
14:45:00	Geoff Hiten	Azure	Cloudy with a Chance of Data
14:45:00	Janis Griffin	DBA – Troubleshooting and Performance Tuning	Query Tuning - Get it Right the First Time
14:45:00	Jason Hall	Personal Development	Launching your career in data management
14:45:00	John Welch	Enterprise BI	Continuous Delivery for Data Warehouses and Marts
14:45:00	miguel Cebollero	DBA – Database Development	SQL Server 2014 In-Memory Programming
14:45:00	Sukhmani Bains	Enterprise BI	Tracking Usage of Analysis Services with SharePoint
16:00:00	Brandie Tarvin	DBA – Troubleshooting and Performance Tuning	Troubleshooting Tips 101
16:00:00	Florin Ursu	Other	Using mindmaps - Lightweight documentation for testing
16:00:00	Josh Luedeman	Azure	Data Factory: Data Integration in the Cloud
16:00:00	Jason Schuh	Enterprise BI	Monetizing Your Data with Predictive Analytics
16:00:00	Devin Knight	Self-Service BI	Dashboard Creation with the new Power BI
16:00:00	Michael Mollenhour	Enterprise BI	SSIS Destination Fast
16:00:00	Wes Springob	Enterprise BI	Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
16:00:00	Bradley Ball	DBA – Troubleshooting and Performance Tuning	Inside the Query Optimizer

SessionID: 14450

Learn How To Build A Golden Record for Any Subject Over Lunch!

Back to calendar

Event Date: 09-05-2015 - Session time: 00:00:00 - Track: Other

Speaker: Gene Webb

Title: Learn How To Build A Golden Record for Any Subject Over Lunch!

Abstract:

Attend the lunch demo and see how you can use Master Data Services and Maestro to:

• Create a golden record for any subject area in a matter of minutes Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? • Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? • Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting • Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise

SessionID: 17153

Data Compression – Why and How

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: DBA – Troubleshooting and Performance Tuning

Speaker: John Kauffman

Title: Data Compression – Why and How

Abstract:

SQL Server’s index compression can have substantial benefits for administration, resource utilization, and query performance. However, implementing compression can be challenging. This session will discuss the benefits of compression, some occasional costs to be aware of, and then provide scripts to estimate compression benefits for indices, as well as generate the SQL needed to implement compression for those indices that warrant it.

SessionID: 19168

PowerShell for SQL Server Administrators

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: DBA – Database Development

Speaker: Lisa Jackson-Neblett

Title: PowerShell for SQL Server Administrators

Abstract:

In this session we will be discussing how SQL Server developers and database administrators can use PowerShell.

SessionID: 19979

Interview Puzzles and how to handle them

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: Personal Development

Speaker: Mike Davis

Title: Interview Puzzles and how to handle them

Abstract:

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.

SessionID: 21014

Process SSAS Cubes with SSIS

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: Enterprise BI

Speaker: Mitchell Pearson

Title: Process SSAS Cubes with SSIS

Abstract:

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.

SessionID: 21112

Data Mining with Excel 2013

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: Self-Service BI

Speaker: Michael Reed

Title: Data Mining with Excel 2013

Abstract:

In this session I 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.

SessionID: 24407

SSIS Performance Tuning

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: Enterprise BI

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: 24636

HA in an about an Hour

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: DBA – Troubleshooting and Performance Tuning

Speaker: Shawn Meyers

Title: HA in an about an Hour

Abstract:

This session will cover the basics for SQL server native tools to provide high availability to your databases. Overview of AlwaysOn, Clustering, Mirroring, and Log Shipping. Pros and cons for each will be covered and direct comparisons of the technologies. After attending this session attendees should be able to know the questions to answer to select the proper HA solution for their environment.

SessionID: 36027

Kids Camp

Back to calendar

Event Date: 09-05-2015 - Session time: 09:00:00 - Track: Other

Speaker: Devin Knight

Title: Kids Camp

Abstract:

For SQL Saturday attendees' children only (children 9-17)

Registration for this event must be done from our meetup site. You cannot register on the day of the event for Kids Camp.

http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/221067174/

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.

An Adult must remain on campus at SQL Saturday during the day.

SessionID: 13300

Size does matter: 10 ways to reduce the database size and improve performance

Back to calendar

Event Date: 09-05-2015 - Session time: 10:15:00 - Track: DBA – Troubleshooting and Performance Tuning

Speaker: Dmitri Korotkevitch

Title: Size does matter: 10 ways to reduce the database size and improve performance

Abstract:

Large multi-terabyte databases are fun to work with; however, they are expensive to host and hard to support.

In this session, Dmitri will show you the set of techniques that help to reduce the size of the databases, lower hardware requirements and improve performance of the systems.

SessionID: 13502

Welcome to SSAS Tabular Models

Back to calendar

Event Date: 09-05-2015 - Session time: 10:15:00 - Track: Enterprise BI

Speaker: Dustin Ryan

Title: Welcome to SSAS Tabular Models

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: 16341

Indexing for performance

Back to calendar

Event Date: 09-05-2015 - Session time: 10:15:00 - Track: Other

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: 17858

Power BI 101

Back to calendar

Event Date: 09-05-2015 - Session time: 10:15:00 - Track: Self-Service BI

Speaker: Kurt Amundson

Title: Power BI 101

Abstract:

An introduction to Power BI for the beginner. This session will take you from a total beginner to someone who prepares simple useful analytical solutions. The session will discuss the different applications that make up the Power BI Suite; Power Pivot, Power View, Power Map and Power Query, how they interact with each other and what a final solution looks like. The session will also provide a Quick-Start Guide that will help you get started with your first BI analytical solution.

SessionID: 25303

Government Transparency Powered by SharePoint 2013 and Sql 2012

Back to calendar

Event Date: 09-05-2015 - Session time: 10:15:00 - Track: Enterprise BI

Speaker: Steve Schneider

Title: Government Transparency Powered by SharePoint 2013 and Sql 2012

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. See how your city is using Microsoft Technology to open up the city's data to its citizens. Think PowerView and Excel (services).

SessionID: 27468

Azure Data Services – Real-time Analytics

Back to calendar

Event Date: 09-05-2015 - Session time: 10:15:00 - Track: Azure

Speaker: Jason Virtue

Title: Azure Data Services – Real-time Analytics

Abstract:

SessionID: 9880

Access As A Front-end to SQL-Server

Back to calendar

Event Date: 09-05-2015 - Session time: 10:15:00 - Track: DBA – Database Development

Speaker: Arvin Meyer

Title: Access As A Front-end to SQL-Server

Abstract:

Microsoft Access makes an unparalleled front-end for any version of SQL-Server. This session will explain the how and why.

SessionID: 14217

Much Ado About Hadoop

Back to calendar

Event Date: 09-05-2015 - Session time: 12:00:00 - Track: Big Data

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

SessionID: 15909

DataViz You Thought You Couldn't Do with SSRS

Back to calendar

Event Date: 09-05-2015 - Session time: 12:00:00 - Track: Enterprise BI

Speaker: Jason Thomas

Title: DataViz You Thought You Couldn't Do with SSRS

Abstract:

Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes to visualization techniques, very few venture beyond its ready-made charts. Most of the time, all it takes to build a chart considered “outside the scope” of SSRS is a bit of lateral thinking. Sometimes, we need to go a little further and use custom code. Join this session as we bust popular myths around "impossible in SSRS" visualizations and construct them live in SSRS!

SessionID: 16390

Database Projects: Development and Deploying

Back to calendar

Event Date: 09-05-2015 - Session time: 12:00:00 - Track: DBA – Database Development

Speaker: Jonathon Moorman

Title: Database Projects: Development and Deploying

Abstract:

A look at the advantages of using Database Projects within Visual Studio. We'll look at partial database projects, tools for sql developers, TFS integration, DACPACs, and what happens during the build and publish steps. This will be demo heavy with a slide deck to remind you of the key points of the session.

SessionID: 20039

A practical guide to Windows Azure SQL Database for the DBA

Back to calendar

Event Date: 09-05-2015 - Session time: 12:00:00 - Track: Azure

Speaker: Gareth Swanepoel

Title: A practical guide to Windows Azure SQL Database for the DBA

Abstract:

What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ?

If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.

SessionID: 21588

Indexing your Data Warehouse

Back to calendar

Event Date: 09-05-2015 - Session time: 12:00:00 - Track: DBA – Troubleshooting and Performance Tuning

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: 9594

Turbocharge Your Career With a Learning Plan

Back to calendar

Event Date: 09-05-2015 - Session time: 12:00:00 - Track: Personal Development

Speaker: Andy Warren

Title: Turbocharge Your Career With a Learning Plan

Abstract:

What will you learn next quarter and why? How will you learn it? How much time and money will it cost? What is the ROI on learning those skills? Those are the questions that you answer by building a learning plan and, if you do it well, you’ll find yourself steadily pulling away from your peers. It starts with a learning list, a place to capture skills you think you need to learn. That’s where you score each topic by estimating the effort to learn it in time and money and the value it adds to your career now and later. It’s absolutely an analog process, but it gives you the framework for answering one question: what do I learn next and why?

Once you’ve picked a topic, how do you learn more about it? Do you read blogs, buy books, or attend a class? Or all of the above? How much time makes sense? Join this session and learn how to dig into the topic to answer the questions that lead to a learning plan. After that, it’s just a matter of executing the plan!

SessionID: 9746

So you think MDX is hard?

Back to calendar

Event Date: 09-05-2015 - Session time: 12:00:00 - Track: Enterprise 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.

SessionID: 19007

Why I won't hire you and what you can do about it!

Back to calendar

Event Date: 09-05-2015 - Session time: 13:15:00 - Track: Personal Development

Speaker: Leigh Freijo

Title: Why I won't hire you and what you can do about it!

Abstract:

SessionID: 20500

Calculated Columns, Measures, and KPIs, Oh My!

Back to calendar

Event Date: 09-05-2015 - Session time: 13:15:00 - Track: Self-Service BI

Speaker: Michael Antonovich

Title: Calculated Columns, Measures, and KPIs, Oh My!

Abstract:

To do serious work in a Power Pivot table or even a SQL Analytics Cube, you must know the difference between calculated columns, measures, and KPIs, how to define them, use them, and display them. This session will take you step by step through the creation of each of these components of a typical pivot table or cube showing you how to define the necessary expressions and then how they are displayed in tables and charts that transform mere data into meaningful managerial information. To keep examples simple enough for all attendees to go back and try on their own, Excel Power Pivot Tables will be used, but the same techniques apply almost without change to SSAS cubes.

SessionID: 23158

Introduction To R

Back to calendar

Event Date: 09-05-2015 - Session time: 13:15:00 - Track: Other

Speaker: Robert Biddle

Title: Introduction To R

Abstract:

Data Science is a relatively new discipline. Core to this is the visualization of data. R is a language and environment used for data visualization and statistical computing.

In this session we'll explore the basics of the R language and review some examples. Additionally we'll review an implementation that integrates R into an ASP.NET application, allowing for sophisticated ways to display dashboards.

SessionID: 23397

Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure

Back to calendar

Event Date: 09-05-2015 - Session time: 13:15:00 - Track: DBA – Database Development

Speaker: Rodney Landrum

Title: Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure

Abstract:

Using BI Power tools to visualize your SQL Infrastructure DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can learn more than the basics of PowerView, PowerPivot and Data Mining using data you are already familiar with as a DBA, your SQL Server installation data. We will look at new and interesting way to load, transform, merge and analyze configuration and performance data for many servers simultaneously. I will also demonstrate how to best utilize that data for reports in Excel, SSRS and Visio to get the most out of automation, standardization and visualization with the new Power tools.

SessionID: 24926

Introduction to SQL Server Clustering

Back to calendar

Event Date: 09-05-2015 - Session time: 13:15:00 - Track: DBA – Troubleshooting and Performance Tuning

Speaker: Chad Churchwell

Title: Introduction to SQL Server Clustering

Abstract:

This session 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: 27112

Smooth Data Moves

Back to calendar

Event Date: 09-05-2015 - Session time: 13:15:00 - Track: Enterprise BI

Speaker: Tricia Reynolds

Title: Smooth Data Moves

Abstract:

An exploration into a way to move database data from a source to one or more destinations. This session will show you how to use dynamic bindings at runtime to avoid having to rebuild SSIS packages when schemas change. We will look at sending data to both SQL Server and Oracle databases without even knowing the column names. This metadata-driven solution will help you to develop faster and move data quickly with bcp capabilities. Attend this session to see how ODP .Net can help you look like a rock star.

SessionID: 28178

Analysis Services: Show Me Where It Hurts

Back to calendar

Event Date: 09-05-2015 - Session time: 13:15:00 - Track: Enterprise BI

Speaker: Bill Anton

Title: Analysis Services: Show Me Where It Hurts

Abstract:

"It's slow" are probably the 2 most dreaded words for any data professional...(right behind "You're fired!")...What's slow? Since when? Compared to what?

Join me in this "something-everyone-should-be-doing-but-isn't" session where we will discuss baselines and performance monitoring for your Analysis Services environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Attendees will walk away from this session with a plan that can be implemented next week to help avoid the pain of being caught off guard with Analysis Services performance issues and make troubleshooting a breeze.

SessionID: 14353

Poor Man's GIS using Tabular and Power View

Back to calendar

Event Date: 09-05-2015 - Session time: 14:45:00 - Track: Self-Service BI

Speaker: Fred Stimler

Title: Poor Man's GIS using Tabular and Power View

Abstract:

SessionID: 14511

Cloudy with a Chance of Data

Back to calendar

Event Date: 09-05-2015 - Session time: 14:45:00 - Track: Azure

Speaker: Geoff Hiten

Title: Cloudy with a Chance of Data

Abstract:

Cloud, Cloud, Cloud. Microsoft is "all in". CxOs love the idea of renting compute resources. You know this is where our profession is headed, but when and how fast. When should you jump on board? The good news is cloud will not eliminate or even reduce the need for IT and Data professionals. The bad news is our world and our profession is changing. Adapt or be left behind. Come see what Microsoft Azure has to offer Data Professionals.

SessionID: 15750

Query Tuning - Get it Right the First Time

Back to calendar

Event Date: 09-05-2015 - Session time: 14:45:00 - Track: DBA – Troubleshooting and Performance Tuning

Speaker: Janis Griffin

Title: Query Tuning - Get it Right the First Time

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

SessionID: 16781

Launching your career in data management

Back to calendar

Event Date: 09-05-2015 - Session time: 14:45:00 - Track: Personal Development

Speaker: Jason Hall

Title: Launching your career in data management

Abstract:

Maybe you are a student thinking about what comes next, or a professional looking for a change. Either way, if you're interested in joining the ranks of data management professionals, it will help to know a few things.

We'll cover some real world basics to help get your foot in the door: 1.) Finding companies that hire interns or entry level positions, and getting an interview 2.) What hiring managers are really looking for when hiring for entry level positions 3.) The first 90 days 4.) Getting noticed at the office 5.) Your ongoing commitment to an ever evolving (and rewarding) career path

SessionID: 17212

Continuous Delivery for Data Warehouses and Marts

Back to calendar

Event Date: 09-05-2015 - Session time: 14:45:00 - Track: Enterprise BI

Speaker: John Welch

Title: Continuous Delivery for Data Warehouses and Marts

Abstract:

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.

SessionID: 20425

SQL Server 2014 In-Memory Programming

Back to calendar

Event Date: 09-05-2015 - Session time: 14:45:00 - Track: DBA – Database Development

Speaker: miguel Cebollero

Title: SQL Server 2014 In-Memory Programming

Abstract:

SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.

SessionID: 24009

Tracking Usage of Analysis Services with SharePoint

Back to calendar

Event Date: 09-05-2015 - Session time: 14:45:00 - Track: Enterprise BI

Speaker: Sukhmani Bains

Title: Tracking Usage of Analysis Services with SharePoint

Abstract:

Tracking usage of multi-dimensional cubes and tabular projects is very valuable for an individual, organization, team, or manager. This session will show you how to set up usage analytics within your organization. The end goal of this is to capture more data about your organization, and use this data to supplement business decisions.

SessionID: 11071

Troubleshooting Tips 101

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: DBA – Troubleshooting and Performance Tuning

Speaker: Brandie Tarvin

Title: Troubleshooting Tips 101

Abstract:

Are you new to SQL Server? Did your first tasks involve problem solving someone else's work? Diagnosing SQL Server problems does not have to be a time sink, or a struggle. Learn about the most common errors in SQL Server and Brandie's top 20 tips for finding the problem fast.

SessionID: 14570

Using mindmaps - Lightweight documentation for testing

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: Other

Speaker: Florin Ursu

Title: Using mindmaps - Lightweight documentation for testing

Abstract:

Quality starts with requirements. In small to mid-size companies, it is not uncommon for the communication chain to be broken. Florin Ursu shares ways to avoid miscommunication through a streamlined process in which requirements are communicated to both developers and testers simultaneously; then developers write code while testers document what will be tested. Florin explores what mindmaps are; what they can be used for, both in general and applied to software development; and then dives deeper into how mindmaps can be used for testing. He describes how his teams use mindmaps to brainstorm, organize testing scenarios, prioritize work, review test scenarios, present results to stakeholders highlighting what was tested and (just as important) what was not tested, issues found, and risks. Using example mindmaps, Florin highlights important details captured in day to day work, including tips regarding format, communication style, and how to “sell” the idea of mindmaps to your stakeholders

SessionID: 17537

Data Factory: Data Integration in the Cloud

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: Azure

Speaker: Josh Luedeman

Title: Data Factory: Data Integration in the Cloud

Abstract:

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.

SessionID: 17643

Monetizing Your Data with Predictive Analytics

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: Enterprise BI

Speaker: Jason Schuh

Title: Monetizing Your Data with Predictive Analytics

Abstract:

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.

SessionID: 18655

Dashboard Creation with the new Power BI

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: Self-Service BI

Speaker: Devin Knight

Title: Dashboard Creation with the new Power BI

Abstract:

Creating dashboards just became a lot easier. The Power BI Designer is a dedicated development tool for creating Power BI dashboards. The designer integrates many of the tools you may already be familiar with (Power Pivot, Power Query, Power View) but in a more accessible way to businesses. The Power BI Designer allows you to acquire the necessary data, create relationships between objects and then create impressive charts, maps, graphs that can then be deployed and viewed from any device, anywhere.

SessionID: 20986

SSIS Destination Fast

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: Enterprise BI

Speaker: Michael Mollenhour

Title: SSIS Destination Fast

Abstract:

Ever face the problem of having slow SSIS packages due to either large lookups on dimensions or complicated merge methods used in SSIS? Free yourself from this tasks with no third-party tools or stage tables required. In this session Mike will demonstrate a totally different way of Increasing speed of destination merges and also eliminating large dimension lookups in SSIS via SQL triggers. I will also demonstrate how to use this same code to create a "Fast" even customizable slowly changing dimension insert.

SessionID: 24825

Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: Enterprise BI

Speaker: Wes Springob

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract:

As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

SessionID: 36045

Inside the Query Optimizer

Back to calendar

Event Date: 09-05-2015 - Session time: 16:00:00 - Track: DBA – Troubleshooting and Performance Tuning

Speaker: Bradley Ball

Title: Inside the Query Optimizer

Abstract:

The Query Optimizer is a black box. It can be intimidating until you understand it. 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. This is the first step in learning how to use the Optimizer's rules to make your queries faster!

This site is open source. Improve this page.