Nr: 330
SQLSaturday #330 - Charlotte - BI Edition 2014
SessionID: 10171
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Bradley Ball
Abstract:
Data Warehouses and OLTP systems are different! But there are some core concepts that we need to understand for managing and maintaining both. Do you want to know how you can load data faster, just by setting up your database correctly? Are your queries running slow? Want to understand how you can reduce locking and blocking in reporting queries? Do you have a system with views, that reference views, which reference more views? Let's discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!
SessionID: 10186
Index Tuning for the DBA
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Ben DeBow
Title: Index Tuning for the DBA
Abstract:
Indexes are like a turbocharger for your queries: they help the engine process queries faster. Without having the right index strategy, you will be stuck managing a SQL Server environment that end users may constantly complain is “too slow.” How do you avoid that situation by knowing which indexes to add or which ones to remove if they are not working—especially if you are not intimate with a particular application’s database? Knowing fundamentals such as baselining performance and proactively monitoring performance are crucial for long-term index maintenance. This session will give you those fundamentals and more to enable you to implement a solid index tuning strategy for your company’s applications.
SessionID: 11036
Source Control with MSBI Solutions
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Bryant Byrd
Title: Source Control with MSBI Solutions
Abstract:
You may not know it, but if you are building MSBI solutions then you are writing code. Treat your BI code like the first-class citizen that it is and protect it with Source Control. Come learn why Source Control matters and how you can reap the benefits with no additional money out of your software budget.
SessionID: 11093
Power This, Power That...Making Sense of Power BI
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Brett Tomson
Title: Power This, Power That...Making Sense of Power BI
Abstract:
With the introduction of Power BI, Microsoft has moved one step closer to its vision of self-service BI for all. But with this new offering comes a bevy of "Power" apps that are bound to confuse just about anyone. In this session, we will power through Power BI for Office 365 bringing meaning to the mess of names like Power Query, Power Map, Power Pivot and Power View and how these experiences are delivered through Microsoft Excel and Office 365. Expect to leave with the power of insight into an exciting new offering that captures the essence of self-service BI.
SessionID: 11131
BIML--Step by Step
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Julie Smith
Title: BIML--Step by Step
Abstract:
BIML--Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We'll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We'll move through basic syntax of plain BIML, and progress to BIMLScript, which enables exponentially faster development of SSIS packages.
SessionID: 11566
Your Best Interview Ever
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Chris Skorlinski
Title: Your Best Interview Ever
Abstract:
Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He'll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.
SessionID: 12184
Introducing Azure DocumentDB
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Dan Shaver
Title: Introducing Azure DocumentDB
Abstract:
In this session you will be introduced to Azure DocumentDB, its features and functionality, and understand when to use it for unmet needs in your environment.
SessionID: 14425
Building an MDM Center of Excellence with MDS and Maestro
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Gene Webb
Title: Building an MDM Center of Excellence with MDS and Maestro
Abstract:
Learn how to build an MDM Center of Excellence with Best Practices using extensive demo. The session will including building a complete sample customer domain including data quality, merge, match and deduplication, and business workflow.
SessionID: 14497
Cloudy with a Chance of Data
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
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: 15596
Best Practices to Deliver BI Solutions
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: James Serra
Title: Best Practices to Deliver BI Solutions
Abstract:
If your company is planning to build a data warehouse or BI solution, you need to be aware that BI projects have high failure rates. Gartner says between 70% to 80% of corporate business intelligence projects fail. And with “big data” adding more complexity you can expect even more failures. However, the major causes of these failures are well known and can be avoided by implementing a set of best practices.
I have worked on dozens of end-to-end BI projects and have seen my share of successes and failures. I will talk about the reasons BI projects fail and share best practices and lessons learned so your BI project will fall into the “successful” category.
SessionID: 15660
Querying in the 21’st century – A window into Windowing functions
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jana Sattainathan
Title: Querying in the 21’st century – A window into Windowing functions
Abstract:
SQL Server introduced Windowing functions in version 2005. Intended to offer the ability to work with windows of data (as a set) in SQL, they pack the power, ease of use and flexibility to query data that traditional SQL lacked (possible but complicated). 2012 rounded the capabilities and added quite a bit. In this session, we will take a look at the available features and how to apply them in practice with tons of practical examples.
SessionID: 15914
All Your HBase Are Belong To Us- an intro to HBase
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Howell
Title: All Your HBase Are Belong To Us- an intro to HBase
Abstract:
Join us as we take a tour of Microsoft Azure's HDInsight HBase offering. We will introduce the main HBase features, as well as the HDInsight HBase preview service hosted in Microsoft Azure. Apache HBase is an open-source "big data" database that can hold billions of rows and millions of columns. It is a distributed, versioned, non-relational database. Presented by Bill Carroll and Jason Howell from the Microsoft Big Data support team.
SessionID: 16677
What's in the SQL Server 2014 Business Intelligence Suite?
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Jessica Moss
Title: What's in the SQL Server 2014 Business Intelligence Suite?
Abstract:
SessionID: 16780
Launching your career in data management
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 7
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: 16838
Closing the SSIS Package Management Story with BIPS
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Jim Christopher
Title: Closing the SSIS Package Management Story with BIPS
Abstract:
BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.
In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.
SessionID: 17126
The Data Management Discipline (with a focus on Data Warehousing)
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Joe Dib
Title: The Data Management Discipline (with a focus on Data Warehousing)
Abstract:
We begin this session with a very brief yet important framework for data management. Then we explore the different aspects of the enterprise data management discipline. Finally, we delve into the different methodologies to design a data warehouse. We will talk about the Kimball, Inmon, Data Vault methodologies. This is a high level conceptual talk (no coding) designed to help both developers and non-technical individuals to understand data management, data warehousing, and Business Intelligence disciplines.
SessionID: 17521
From Zero to Hero - Designing and Deploying Dynamic Reports Using SSRS
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Josh Gerszewski
Title: From Zero to Hero - Designing and Deploying Dynamic Reports Using SSRS
Abstract:
SessionID: 17530
Show me whatcha workin' with: Big Data Edition
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Josh Luedeman
Title: Show me whatcha workin' with: Big Data Edition
Abstract:
SessionID: 17582
Shade Tree Mechanic's Guide to SSAS
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Justin Randall
Title: Shade Tree Mechanic's Guide to SSAS
Abstract:
SessionID: 18151
Hive 101
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Goode
Title: Hive 101
Abstract:
Hive is the SQL like interface for Hadoop, aka Big Data. Hive was developed for two audiences, the newbie and, the hive developer. For the newbie almost any query will work in hive, eventually. The first part of the session will cover the differences between SQL and HQL so that anyone that has written a SQL query can start working with Hive. The second part of the session will cover the differences, at a high level, in how a traditional query engine works and how the Hive query engine works. We will discuss how the Hive query engine makes use of the distributed nature of Hadoop and what are considered best practices when writing Hive queries.
SessionID: 21820
It's full of Star Schemas…
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Paul Waters
Title: It's full of Star Schemas…
Abstract:
Whether you are using Excel, Tableau, PowerPivot, SSAS Multi-dimensional or Tabular, QlikView, or just plain old SQL, most of the time you will get better results in less time if you can source the data from a star schema.
In this session we will cover the core principles of a star schema dimensional data model. This will include the different types of dimension attributes, dimension hierarchies, types of fact tables, and types of measures.
SessionID: 22170
Columnstore Indexes
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Patrick Keisler
Title: Columnstore Indexes
Abstract:
SessionID: 22260
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Prabhaker Potharaju
Abstract:
This session covers basic functionalities of SQL Server data tools. Learn how to create the SQL Server Database Project, import existing database objects, design new objects, add pre and post deployment scripts. And how to use SqlPackage.exe command line utility to publish a database.
SessionID: 23341
Tame Your Unruly Data...With Constraints!
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Rob Volk
Title: Tame Your Unruly Data...With Constraints!
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
SessionID: 23696
Documenting SSIS packages using XQuery
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Russel Loski
Title: Documenting SSIS packages using XQuery
Abstract:
You have been given responsibility over an SSIS package. One of the first things that you want to discover is where the data is coming from and what operations happen between the source and the target. In this session you will learn some XQuery that you can use to trace the flow of data from different sources to SQL Server. You will identify the Derived Column operations that alter the data from the source. You will see how to load XML from a file to query it.
SessionID: 24051
A New Approach to Unit Testing and Integration Testing in SSIS
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Scott Currie
Title: A New Approach to Unit Testing and Integration Testing in SSIS
Abstract:
In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This approach uses metadata authored by analysts in Excel to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic. All code will be shared with attendees for free and unrestricted use within their own projects.
SessionID: 24052
Create and Load a Staging Environment from Scratch in an Hour with Biml
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Scott Currie
Title: Create and Load a Staging Environment from Scratch in an Hour with Biml
Abstract:
Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie from Varigence will use the free BIDSHelper add-in for BIDS and SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of hundreds of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.
SessionID: 24418
PowerBI
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Scott Holmes
Title: PowerBI
Abstract:
Using the PowerBI components of O365 to pull in data from a variety of sources, develop new data models and create impressive data visualizations. Will cover loading data with Power Query, modelling data with Power Pivot, creating stunning, effortless reports with Power View and Power Map and using QA to search for data using natural language queries.
SessionID: 26548
Back(up) to Basics
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Ben Thul
Title: Back(up) to Basics
Abstract:
Are your databases being backed up? Are you sure? Are you sure they're being backed up correctly? Maybe you're an "accidental DBA" or a developer who's not quite sure of the answers to those questions. In this session, you'll learn what the different types of basic backups are, how to execute them, and (perhaps most importantly) how to restore from them if and when necessary.
SessionID: 27220
Introduction to SQL Server 2014 AlwaysOn Solutions
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Uttam Parui
Title: Introduction to SQL Server 2014 AlwaysOn Solutions
Abstract:
For your mission critical application, you need to implement a high availability (HA) and disaster recovery (DR) solution using SQL Server 2014 AlwaysOn technologies. There is a lot of documentation but it is very confusing and don't know where to start. In this session, we will introduce you to SQL Server 2014 AlwaysOn technologies and explain the concepts that you need to implement a HA/DR solution using SQL Server 2014 AlwaysOn.
SessionID: 27351
DAX 101
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 6
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: 27779
Introduction to Microsoft Azure Machine Learning
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Bill Carroll
Title: Introduction to Microsoft Azure Machine Learning
Abstract:
The session will cover an introduction to using Microsoft Azure Machine Learning (MAML). We will cover some basics of machine learning using MAML which will include the MAML studio used to create, evaluate, and run machine learning experiments. We will also publish an experiment as a web service which can be used by your application. To learn more about MAML visit http://azure.microsoft.com/en-us/documentation/services/machine-learning/
SessionID: 28177
The 20-Minute Tabular Model
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Bill Anton
Title: The 20-Minute Tabular Model
Abstract:
SessionID: 28238
Change Data Capture Change Tracking Deep Dive
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Hazzard
Title: Change Data Capture Change Tracking Deep Dive
Abstract:
Change Data Capture (CDC) and Change Tracking (CT) have been standard features in SQL Server for a few years now but there's not really that much useful information out in the blogosphere about how they work under the hood. Kevin Hazzard will dig deep into the implementations of CDC and CT in SQL Server, showing you all of the parameters you can use to make these great features serve your organization well. This will be a highly-interactive, highly-entertaining session with lots of questions answered and mysteries revealed.
SessionID: 34729
Applied Enterprise Semantic Mining
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Mark Tabladillo
Title: Applied Enterprise Semantic Mining
Abstract:
Text mining is projected to dominate data mining, and the reasons are evident: we have more text available than numeric data. Microsoft introduced a new technology to SQL Server 2014 called Semantic Search. This session's detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index, and will also provide a comparison between what semantic search is and what Delve does. The demos include a web-based Silverlight application, and content documents from Wikipedia. We'll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining.
SessionID: 34730
Data Mining Innovation with SQL Server 2014
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Mark Tabladillo
Title: Data Mining Innovation with SQL Server 2014
Abstract:
SessionID: 9100
APS/PDW – Are you ready for the next generation DW solution??
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Andy Isley
Title: APS/PDW – Are you ready for the next generation DW solution??
Abstract:
SessionID: 9142
On-Demand Compute and Analytics with Powershell, Hadoop and Azure
Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Adam Jorgensen
Title: On-Demand Compute and Analytics with Powershell, Hadoop and Azure
Abstract: