Nr: 246
SQLSaturday #246 - Salt Lake City 2013
SessionID: 10247
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Lucas
Speaker: Ben Miller
Abstract:
SessionID: 10830
SQL 2012 Extended Events
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Lucas
Speaker: Jason Brimhall
Title: SQL 2012 Extended Events
Abstract:
SessionID: 11507
Becoming Certified In Microsoft SQL Server
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Michelangelo
Speaker: Chris Hyde
Title: Becoming Certified In Microsoft SQL Server
Abstract:
Becoming certified in SQL Server is a great career enhancement for a database professional. This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012. You'll discover several reasons why you should become certified, and some of the best ways in which to do so. You'll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last twelve years.
SessionID: 15822
Dimension Modeling Design Patterns: Beyond Basics
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Michelangelo
Speaker: Jason Horner
Title: Dimension Modeling Design Patterns: Beyond Basics
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 16880
Getting Started with Execution Plans
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Spielberg
Speaker: Jason Kassay
Title: Getting Started with Execution Plans
Abstract:
You just received a phone call from your boss telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, the first thing you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points
SessionID: 17618
SSIS 2012 - Best Practices and Design Patterns
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Atrium
Speaker: Joe Salvatore
Title: SSIS 2012 - Best Practices and Design Patterns
Abstract:
Unsure of how to use new SSIS 2012 features productively? Need to ensure you are using best practice configuration options? This session will be a deep dive into proven best practice ways of using SSIS 2012 including Parameters, Variables, Environments, Source Control, Connection Managers, and much more.
SessionID: 21159
What secrets does your database schema hold?
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Spielberg
Speaker: Andre DuBois
Title: What secrets does your database schema hold?
Abstract:
SessionID: 21749
SQL Server 2012: To NAS or not to NAS, that is the question
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Atrium
Speaker: Pat Sinthusan
Title: SQL Server 2012: To NAS or not to NAS, that is the question
Abstract:
SessionID: 22768
Master Data Services – 101
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Michelangelo
Speaker: Reeves Smith
Title: Master Data Services – 101
Abstract:
SessionID: 24058
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Rodin
Speaker: Scott Heffron
Abstract:
This presentation will discuss how we created the storage area for the metrics and how capturing metrics was implemented.
SessionID: 24751
Bulletproof Database Deployments
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Spielberg
Speaker: Stacey Glossner
Title: Bulletproof Database Deployments
Abstract:
Have you watched a DBA's facial expression when a developer says I'm giving you an automated deployment script? How can you assure your DBA that it won't fail? Deployment scripts a DBA runs may also be a risk. Saying "it worked on my machine" doesn't cut it.
Learn strategies to ensure your schema deployment goes smooth as silk. Including how and when to test deployment scripts, how to keep in sync with production schema changes, how to write transactional deployment scripts, how to back out schema changes with minimal data loss, and other great tips.
You'll leave with a better understanding of these techniques and how a botched database deployment can be avoided.
SessionID: 26017
Locks, Blocks and Isolation Oh My!
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Lucas
Speaker: Keith Tate
Title: Locks, Blocks and Isolation Oh My!
Abstract:
Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.
SessionID: 26216
SQL Server 2012 Column Store Index
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Spielberg
Speaker: Kevin Boles
Title: SQL Server 2012 Column Store Index
Abstract:
SessionID: 26905
Database Monitoring : Trying To Keep Sane
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Michelangelo
Speaker: TJay Belt
Title: Database Monitoring : Trying To Keep Sane
Abstract:
Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA's job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish.
We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better.
SessionID: 34888
Essentails of a Big Data Architecture
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Gym 1
Speaker: David Gonzalez
Title: Essentails of a Big Data Architecture
Abstract:
This presentation discusses the essentials of a Big Data architecture and how technologies are being used to influence different decisions. Scott will also discuss the skills and processes required to make a successful implementation work.
SessionID: 34889
A travelers' guide to Vertica
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Atrium
Speaker: David Gonzalez
Title: A travelers' guide to Vertica
Abstract:
SessionID: 34890
A Couple of Oracle Security Tricks
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Michelangelo
Speaker: David Gonzalez
Title: A Couple of Oracle Security Tricks
Abstract:
Trick #1: Password Security - Strong passwords, impossible passwords and password safes; how to protect your accounts. Trick #2: How to encrypt a column so effectively that not even a SYS level user can read it. Michael McLaughlin's method for utilizing User Defined Types (UDT) and DBMS_ENCRYPT to create keyed functions for encrypting and decrypting column values. This does require a SYS level user to grant your target schema user EXECUTE on the DBMS_ENCRYPT package. Some code will be provided. To follow along with this presentation, it will help if the class participant has a working knowledge of Oracle 11g's object types and a basic knowledge of Oracle's encryption technology.
SessionID: 34891
Introduction to Cassandra
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Gym 1
Speaker: David Gonzalez
Title: Introduction to Cassandra
Abstract:
SessionID: 34892
Classification and Regression in Clojure
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Rodin
Speaker: David Gonzalez
Title: Classification and Regression in Clojure
Abstract:
SessionID: 34893
Big Data Lambda Architecture Overview
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Gym 1
Speaker: David Gonzalez
Title: Big Data Lambda Architecture Overview
Abstract:
When most people think of processing terabytes and even petabytes of information, they often think of batch processing. After all, processing platforms like Hadoop or Cassandra are batch-oriented. While adding processing nodes can reduce processing latency, it does not address desired "real-time" processing requirements. How can you process big data sets in real-time while leveraging batch-oriented Big Data infrastructure? By example, how do services like Twitter consider the vast quantities of tweets, past and present, to provide real-time trending analytics? The answer lies within the architectural patterns of what is called Big Data Lambda Architecture. In this session we will establish the context of the Lambda Architecture and explore the architectural patterns and practices of implementing it to provide both a low and high latency Big Data processing capability to your business.
SessionID: 34894
Introduction to ElasticSearch
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Lucas
Speaker: David Gonzalez
Title: Introduction to ElasticSearch
Abstract:
ElasticSearch is based on a Lucene core and is an easily and highly scalable search engine. We'll start with an introduction and overview of what ElasticSearch is and how it works. We'll cover the ElasticSearch query language, it's architecture and scalability model. We'll talk about some of the different roles that ElasticSearch can play in a Big Data architecture. We'll wrap up by starting a couple of ElasticSearch nodes and showing how easy it is to startup, cluster, and run queries against ElasticSearch.
SessionID: 34895
Getting to Step 1: Automatic Installation of Big Data, Cloud, Web and HPC Cluster
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Michelangelo
Speaker: David Gonzalez
Title: Getting to Step 1: Automatic Installation of Big Data, Cloud, Web and HPC Cluster
Abstract:
SessionID: 34896
Big Data in Sports
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Atrium
Speaker: David Gonzalez
Title: Big Data in Sports
Abstract:
SessionID: 34897
Getting Down on the CouchDB
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Lucas
Speaker: David Gonzalez
Title: Getting Down on the CouchDB
Abstract:
CouchDB is a beautiful creation. It is a versioned document database with live updating map reduce indexing. It's ACID, Multi-master, and sports a clean JavaScript/JSON REST interface. Because of some of it's low level differences it really shines. This talk will show you why. We'll cover: - CouchDB core fundamentals - Illustrate CouchDB's strengths - Cover iCouchDB's weaknesses and how to deal with them - Walkthrough simple steps to integrate CouchDB into an application - Walkthrough using CouchDB in a disconnected peer scenario
SessionID: 34898
Getting to visualizations from Big Data fast
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Gym 1
Speaker: David Gonzalez
Title: Getting to visualizations from Big Data fast
Abstract:
SessionID: 34899
You Can Do That? Using Predictive Analytics To Improve Graduation Rates
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Gym 1
Speaker: David Gonzalez
Title: You Can Do That? Using Predictive Analytics To Improve Graduation Rates
Abstract:
SessionID: 34900
AWSDynamo Lessons Learned:
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Lucas
Speaker: David Gonzalez
Title: AWSDynamo Lessons Learned:
Abstract:
Learn about how we are saving two orders-of-magnitude in cost implementing a global time-series datastore for devices in ad-hoc networks. Minimum requirements: receive 50 sensor values per device every minute and store them for 10 years. |- Objectives and rationale for selecting AWS |- Developing a data lifecycle and API (hot and cold) |- Projecting costs and ROI |- Datamodel (keystore anti-patterns): (a.) AWS' affinity for Availability over C P. (b.) Avoid scans! write-time materialized views. (c.) Read/write-through caching: update-if-same consistency. (d.) Secondary indexes and CAP tradeoffs: AWSDynamo LSI vs. Cassandra and Riak, no silver bullet: cross-shard queries ("locals only"). (e.) Details about designing a smart hash strategy.
SessionID: 34901
Cure for Data Impetancy
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Spielberg
Speaker: David Gonzalez
Title: Cure for Data Impetancy
Abstract:
SessionID: 34902
Oracle Transportable Tablespaces
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Rodin
Speaker: David Gonzalez
Title: Oracle Transportable Tablespaces
Abstract:
SessionID: 34903
A simple framework for presenting complex data.
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Spielberg
Speaker: David Gonzalez
Title: A simple framework for presenting complex data.
Abstract:
Your data is spring-loaded with possibilities. How you present your data can build — or break — relationships. You have 2 choices; either, develop a strategy to make your big data meaningful, or bury your audience with boring data and trust that the gods will clean up the mess. The choice is yours; eyes open or closed.
SessionID: 34904
Scaling DNA Data Processing with HBase and Hadoop
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Atrium
Speaker: David Gonzalez
Title: Scaling DNA Data Processing with HBase and Hadoop
Abstract:
SessionID: 34905
Hadoop Shuffle - the Magic Behind Map Reduce
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Gym 1
Speaker: David Gonzalez
Title: Hadoop Shuffle - the Magic Behind Map Reduce
Abstract:
There are numerous blogs and talks about the map reduce paradigm which explain how map reduce works at an abstract level; you've likely seen how to write a word count application in map reduce more than once. But to understand how a map reduce job will perform, you also need to know how Hadoop feeds data from the mappers to the reducers. The shuffle phase provides the glue between mappers and reducers running on different nodes, and ensures that reducers get their data in a sorted fashion. In this session, we will explain how Hadoop shuffles and sorts data. We will also talk about some practical implications this has for the performance of certain common map reduce operations, such as joins, and some of the tuning parameters that can help your map reduce applications run faster.
SessionID: 34906
"Big Data" - Utah's Strong Position for Building a Big Data Cluster
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Gym 1
Speaker: David Gonzalez
Title: "Big Data" - Utah's Strong Position for Building a Big Data Cluster
Abstract:
Utah has one of the most advanced high tech sectors of any state in the United States that has grown for the last thirty years with key strengths in enterprise software, networking software, cloud technologies, and data centers. All of these are key components to developing a strong "big data" cluster and with the right positioning and collaboration, Utah can build on its core cluster strengths to become a place with deep competencies and strong differentiation in the "big data" world.
SessionID: 34907
Introduction to Machine Learning.
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Michelangelo
Speaker: David Gonzalez
Title: Introduction to Machine Learning.
Abstract:
Can a computer learn? Machine learning is all the craze in the industry. But what is it that machine learning can do? This session we will pull back the covers on machine learning and examine how a machine can actually "learn".
SessionID: 34908
Open Design and Discussion session
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Rodin
Speaker: David Gonzalez
Title: Open Design and Discussion session
Abstract:
We are leaving the room open and staffing it with various data professionals at different times. The goal will be to allow discussion of any data topic that the group would like to talk about. At registration the day of the event we will have a list of various people and topics that will be in the room at different times and you can choose to attend at various times.
SessionID: 8885
T-SQL Tips Tricks Part 2
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Atrium
Speaker: Aaron Cutshall
Title: T-SQL Tips Tricks Part 2
Abstract:
SessionID: 9347
Unleash the Power of PowerPivot
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Lucas
Speaker: Andrea Allred
Title: Unleash the Power of PowerPivot
Abstract:
SessionID: 9775
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Spielberg
Speaker: Argenis Fernandez
Abstract: