Nr: 431
SQLSaturday #431 - Spartanburg 2015
SessionID: 36226
Getting Started with Analysis Services 2012 Tabular
Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Business Intelligence
Speaker: William E Pearson III
Title: Getting Started with Analysis Services 2012 Tabular
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM"). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
SessionID: 36576
SQL Server Performance Fundamentals: Building and Maintaining a Solid Foundation
Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Justin Randall
Title: SQL Server Performance Fundamentals: Building and Maintaining a Solid Foundation
Abstract:
Achieving great performance from your SQL Servers can be elusive. Yet for most production systems it starts with the right resources, correct configuration, and ongoing maintenance. In this session you will learn the basics of building and maintaining robust, healthy SQL Servers. You will also become familiar with the fundamentals of SQL Server performance monitoring to vastly improve your ability to detect and correct performance issues before your users know about them
SessionID: 36836
Designing an SSIS Framework in 2015
Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Data Integration
Speaker: Andy Leonard
Title: Designing an SSIS Framework in 2015
Abstract:
In this session, you will learn:
- A method for migrating packages from Development, through the data integration life cycle, to Production without editing SSIS Connection Manager Properties.
- A metadata-driven approach to SSIS package execution.
- A method for customizing enterprise data integration reporting.
SessionID: 38364
The Basics of SQL Injection
Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Application Database Development
Speaker: Dale Burnett
Title: The Basics of SQL Injection
Abstract:
SessionID: 39289
Social Networking Is Alive!!!
Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Professional Development
Speaker: John Morehouse
Title: Social Networking Is Alive!!!
Abstract:
SessionID: 40361
Execution Plans for Mere Mortals
Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Application Database Development
Speaker: Mike Lawell
Title: Execution Plans for Mere Mortals
Abstract:
For beginning database professionals, execution plans can be intimidating. This session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.
Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
SessionID: 36210
Data Pages, Allocation Units, IAM chains... Oh My! - Storage Inte
Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Brandon Leach
Title: Data Pages, Allocation Units, IAM chains... Oh My! - Storage Inte
Abstract:
Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.
We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
SessionID: 36230
Getting Started with MDX
Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Business Intelligence
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
SessionID: 36552
Smart Rats Leave First
Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Professional Development
Speaker: Geoff Hiten
Title: Smart Rats Leave First
Abstract:
IT jobs are notoriously short-lived, with most only lasting a few years. Very few people keep a single employer for their entire career. Knowing when, why, and how to leave your job is as important a career step as finding new work. Learn about how to use job transitions as opportunities to develop your career.
SessionID: 38508
Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Application Database Development
Speaker: Kathi Kellenberger
Abstract:
SessionID: 39102
Advanced Scripting Using SSIS Script Tasks and Components
Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Data Integration
Speaker: John Welch
Title: Advanced Scripting Using SSIS Script Tasks and Components
Abstract:
SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session to see how far you can stretch the scripting capabilities of SSIS.
SSIS offers significant capabilities out-of-the-box. However, many data movement projects have needs that go above and beyond the common scenarios. Have you ever needed to calculate running totals during your ETL process? What about using dynamically updated business rules during processing to determine what data is valid? These things, and much more, can be accomplished using the script task and component within SSIS. During this session, we will demonstrate several scripts in SSIS (including the ones mentioned above) that show how to take full advantage of the capabilities of SSIS. This session is intended for people who have worked with and understand SSIS, and have a basic understanding of .NET development.
SessionID: 39287
Database Continuous Delivery Your Salvation!
Event Date: 26-09-2015 - Session time: 09:30:00 - Track: DevOps
Speaker: John Morehouse
Title: Database Continuous Delivery Your Salvation!
Abstract:
SessionID: 36220
Tame Your Unruly Data...With Constraints!
Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Application Database Development
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: 36651
Building Your Yellow Brick Road: Directing Your Path to a Success
Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Professional Development
Speaker: Justin Randall
Title: Building Your Yellow Brick Road: Directing Your Path to a Success
Abstract:
For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.
SessionID: 36834
Using BIML as an SSIS Design Patterns Engine
Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Data Integration
Speaker: Andy Leonard
Title: Using BIML as an SSIS Design Patterns Engine
Abstract:
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
SessionID: 37361
What's your Character Data Type?
Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Application Database Development
Speaker: John Deardurff
Title: What's your Character Data Type?
Abstract:
This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.
SessionID: 38409
Clustering... the SQL Server Way
Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Andrew Maxwell
Title: Clustering... the SQL Server Way
Abstract:
Beginning with a two node Windows cluster with shared storage, I will walk you though setting up SQL Server as a clustered resource.
SessionID: 39041
Everything you Want to know about Power BI dependency on Office 3
Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Business Intelligence
Speaker: Patrick LeBlanc
Title: Everything you Want to know about Power BI dependency on Office 3
Abstract:
SessionID: 36225
Converting Unreliable Deployments Into Consistent Releases
Event Date: 26-09-2015 - Session time: 13:15:00 - Track: DevOps
Speaker: Thomas Norman
Title: Converting Unreliable Deployments Into Consistent Releases
Abstract:
The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or the incorrect version. Each database is made up of a lot of objects in different environments. When you create an object like a table or stored procedure, you need to get this object deployed into each environment. Together we will discover how to separate each object for proper order deployment while releasing only objects which have changed. Deployments can cause you trouble but we will provide a reliable deployment and version control process.
SessionID: 36266
What’s your Imperative doing in my Declarative?
Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Application Database Development
Speaker: Geoff Hiten
Title: What’s your Imperative doing in my Declarative?
Abstract:
SessionID: 36272
Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Ed Watson
Abstract:
SessionID: 36273
Backup Strategies are for Losers!
Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Ed Watson
Title: Backup Strategies are for Losers!
Abstract:
Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!
SessionID: 37362
The PROCESS of queries
Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Application Database Development
Speaker: John Deardurff
Title: The PROCESS of queries
Abstract:
This session focuses on the PROCESS of queries and how this effects Optimization, Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.
SessionID: 37565
Tone Analysis with HDInsight and Azure Machine Learning
Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Data Integration
Speaker: Paco Gonzalez
Title: Tone Analysis with HDInsight and Azure Machine Learning
Abstract:
People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
SessionID: 39126
Introduction To R for SQL Developers
Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Business Intelligence
Speaker: Kiran Math
Title: Introduction To R for SQL Developers
Abstract:
In this session we will explore
- Installation of R and R Studio
- R basics
- Power of R
- Getting data from databases and other sources.
- Managing Data frame using package dplyr
- Visualization of Data using Graphic package ggplots
- In-Database R in SQL Server 2016
SessionID: 36215
Table Vars and Temp Tables – What you NEED to Know!
Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Application Database Development
Speaker: Wayne Sheffield
Title: Table Vars and Temp Tables – What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 36237
DBA’s1st Date - Getting to know a new environment
Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Ryan Brickey
Title: DBA’s1st Date - Getting to know a new environment
Abstract:
With more entry level DBA positions becoming available, and non-DBA’s shifting into DBA roles, you may find yourself in a position where you need to become familiar with a new server environment quickly and efficiently but not know where to begin. In this session we will review some standard practices and personal experiences that have helped efficiently identify and spec out a new environment.
SessionID: 38096
R with AzureML
Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Business Intelligence
Speaker: Jake Switzer
Title: R with AzureML
Abstract:
SessionID: 38738
Closing the SSIS Package Management Story with BIPS
Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Business Intelligence
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: 39288
Only You Can Prevent Database Fires!
Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Speaker: John Morehouse
Title: Only You Can Prevent Database Fires!
Abstract:
Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!
SessionID: 39396
Balancing Work and Home to Create a Better You
Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Professional Development
Speaker: Karlyn LeBlanc
Title: Balancing Work and Home to Create a Better You
Abstract:
If you are a working professional there is a chance that your career has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.
SessionID: 39538
Master Data Management with MDS, DQS and SSIS
Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Data Integration
Speaker: Julie Smith
Title: Master Data Management with MDS, DQS and SSIS
Abstract:
SessionID: 36276
De-Mystifying Query Plans: Focus on the Cardinality Estimator
Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Dave Turpin
Title: De-Mystifying Query Plans: Focus on the Cardinality Estimator
Abstract:
The SQL Server optimizer is an engineering marvel. The intelligence that is built into the product is mind bending. But, sometimes queries don't run as expected. Without a basic understanding of statistics and the cardinality estimator you'll never know why.
This session will walk through an anomaly of the cardinality estimator called The Ascending Key Problem. A major focus of the discussion will include how the optimizer uses statistics to estimate row counts, which is ultimately used to build optimal query plans.
At the end of this session you will know how to assess the state of the statistics for your indexes and columns; you will know how to look at your query plans in a way that will help prevent poor query performance BEFORE the query executes; and you will better understand how the optimizer estimates row counts.
SessionID: 36393
SQL Server 2014 In-Memory Programming
Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Application 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: 37777
I'm It - Survival Techniques for the Lone DBA
Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Professional Development
Speaker: Monica Rathbun
Title: I'm It - Survival Techniques for the Lone DBA
Abstract:
Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
SessionID: 39044
Introduction to the Power BI Desktop
Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Business Intelligence
Speaker: Patrick LeBlanc
Title: Introduction to the Power BI Desktop
Abstract:
Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.
SessionID: 39104
Testing Data and Data-Centric Applications
Event Date: 26-09-2015 - Session time: 15:45:00 - Track: DevOps
Speaker: John Welch
Title: Testing Data and Data-Centric Applications
Abstract:
Testing applications that depend on data can be hard. Everyone agrees that testing is vital, but knowing what to test and how to test it is challenging. Come to this session for a methodology for testing your data, and the applications that use it.
Testing is vital to fast, successful delivery of software and information today. While application testing is generally well understood, data centric testing is not. The success of many applications depends on them producing valid, correct data, yet this is often tested as an afterthought, or not tested at all. During this session, we will discuss how to test the data produced by applications or data movement processes. We’ll cover how to determine the accuracy and quality of your data, and how to incorporate the testing into your data lifecycle. The focus will be on what you need to test, and the techniques for validating that the data produced is accurate.
SessionID: 39543
Azure Data Factory: My Data Wandered Lonely as a CLOUD.
Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Data Integration
Speaker: Julie Smith
Title: Azure Data Factory: My Data Wandered Lonely as a CLOUD.
Abstract:
This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.