Nr: 276
SQLSaturday #276 - Silicon Valley 2014
SessionID: 10110
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Bala Narasimhan
Abstract:
SessionID: 11103
Dimensional Modeling: The Basics Beyond
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Dan Bulos
Title: Dimensional Modeling: The Basics Beyond
Abstract:
Dimensional Modeling (DM) is the de facto standard for the design of databases for BI reporting analytics. Regardless of whether a database is a data warehouse used for reporting or an OLAP cube or advanced analytics, DM should be the basis for the data model. This session will cover the fundamentals of DM along with best practices in designing and implementing the data model. Additionally, we will cover practical situations that require “breaking the rules” of DM and how to implement solutions to these problems.
SessionID: 11348
Getting started with Big Data and BI
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Big Data/Azure
Speaker: Carlos Bossy
Title: Getting started with Big Data and BI
Abstract:
SessionID: 12413
Clusters Your Way - #SANLess clusters for physical, virtual and cloud environments
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Sios Technology and Allan Hirt
Title: Clusters Your Way - #SANLess clusters for physical, virtual and cloud environments
Abstract:
Allan Hirt on #SANLess Clustering on the Ground and in the Cloud...more details to follow!
SessionID: 12874
The Last NULL in the Coffin: Missing Data, SQL the Relational Model
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Development
Speaker: Fabian Pascal
Title: The Last NULL in the Coffin: Missing Data, SQL the Relational Model
Abstract:
Missing data has possibly been the thorniest aspect of database management: without a logically sound yet practical solution, data professionals and users are left between a rock and a hard place. They must either (a) rely on SQL's arbitrary and flawed implementations of three-valued logic (3VL) based on NULLs and risk results that are easy to misinterpret, or wrong in ways hard to discern, or (b) undertake in applications a prohibitively complex, error prone and unreliable burden that belongs in the DBMS.
This presentation outlines a relational (2VL) solution to missing data that is devoid of NULLs and theoretically correct.
SessionID: 14116
What is a Latch, and Why Should I Care?
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Eddie Wuerch
Title: What is a Latch, and Why Should I Care?
Abstract:
Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!
SessionID: 15527
Faster Insights From Any Data
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Big Data/Azure
Speaker: Jarek Kazmierczak
Title: Faster Insights From Any Data
Abstract:
SessionID: 17846
Unblock yourself -- Optimistic concurrency in Hekaton
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: SQL Server 2014 Launch Track
Speaker: Kalen Delaney
Title: Unblock yourself -- Optimistic concurrency in Hekaton
Abstract:
SQL Server 2014's In-Memory OLTP allows truly optimistic locking and no latching! In this session, we see how rows can be inserted, deleted and updated without the need for latches or locks.
SessionID: 17875
$#*! Your Database Says About Me
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Development
Speaker: Karen Lopez
Title: $#*! Your Database Says About Me
Abstract:
Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions. Using real-life evidence of her own data in your systems.
SessionID: 18216
Team Leadership Fundamentals
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Kevin Kline
Title: Team Leadership Fundamentals
Abstract:
- What are the fundamental ways that a new leader can build credibility and trust with their team?
- What are the unique ways in which IT people are motivated?
- How can a leader effectively communicate with their IT team using a variety of communication channels?
- How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?
SessionID: 19071
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Development
Speaker: Leonard Lobel
Abstract:
SessionID: 19323
Machine Learning Smack Down
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Big Data/Azure
Speaker: Lynn Langit
Title: Machine Learning Smack Down
Abstract:
In this class you will see various machine learning tools and products that best integrate with the Microsoft business intelligence and analytics stack. Techniques include use of clustering, time series prediction, market-basket analysis, text mining and neural networks . We also cover real-world data preparation for model building, including outlier detection and removal, discretization and other common machine learning techniques. You will take away practical experience with machine learning processes that you can use in common business scenarios with Microsoft software, and particularly Office.
SessionID: 20392
Best Practices for Efficient SSRS Report Creation
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Mickey Stuewe
Title: Best Practices for Efficient SSRS Report Creation
Abstract:
Reports don't stop changing once they're released into production, and some reports are phased out over time. Wouldn't it be great to have a way to keep track of the changes a report takes on in production over time? We'll talk about how to keep track of change requests, how to analyze the utilization of existing reports, and how to track changes in users for the reports in production.
SessionID: 20838
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Mitchell Bottel
Abstract:
SessionID: 21021
SQL Server's In Memory Database Objects
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: SQL Server 2014 Launch Track
Speaker: Denny Cherry
Title: SQL Server's In Memory Database Objects
Abstract:
SQL Server 14 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.
SessionID: 21759
SQL Server 2014 In-Memory Architecture - Microsoft xVelocity Engine
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: SQL Server 2014 Launch Track
Speaker: Pat Sheehan
Title: SQL Server 2014 In-Memory Architecture - Microsoft xVelocity Engine
Abstract:
SessionID: 21852
BI Expert Panel - Part 1
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Paul Turley
Title: BI Expert Panel - Part 1
Abstract:
SessionID: 21853
BI Expert Panel - Part 2
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Paul Turley
Title: BI Expert Panel - Part 2
Abstract:
In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization. BI solution experts and SolidQ Mentors Rushabh Mehta, Brett Tomson and Paul Turley will help you define an end-to-end BI solution including data sourcing security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.
SessionID: 22527
Locks, Blocks, and Deadlocks Oh My!
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Randy Knight
Title: Locks, Blocks, and Deadlocks Oh My!
Abstract:
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
SessionID: 23370
An Analytics Sandbox in A World of Big Data
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Big Data/Azure
Speaker: Roberto Arnetoli and Andrew Eichenbaum
Title: An Analytics Sandbox in A World of Big Data
Abstract:
As Big Data becomes the norm to deal with data volume, variety and velocity, it becomes increasingly harder for the Data Analyst to understand and work with data sets. To overcome this we introduce Platfora, a Hadoop-backed data analysis framework which nicely complements more traditional data warehousing and BI solutions. We'll go over ingestion of new data and building of data sets and visualizations in a system that requires no more work than interacting with a graphical interface. More specifically, we will do so in the context of peer-to-peer lending, to show how insights on loan applicants and their risk profiles can be quickly revealed with no ETL development or demanding data transformation.
SessionID: 24302
Parallel Data Warehouse
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Big Data/Azure
Speaker: Sean Mikha
Title: Parallel Data Warehouse
Abstract:
In this presentation we will discuss the Parallel Data Warehouse Technology from Microsoft in-depth. We will cover its main use cases, why it was built, and how PDW works. We will then talk about how we use Polybase and big-data technologies within PDW to access data stored in Hadoop. With the new Appliance Update release in 2014, we are now able to automatically create MapReduce code based on T-SQL. In this overview we will cover PDW’s ability to implement Predicate Push-Down and show how we integrate with Hadoop natively.
SessionID: 24542
Branding Yourself for a Dream Job
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 24640
Reduce, Reuse, Recycle: Automating your BI Framework
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Stacia Varga
Title: Reduce, Reuse, Recycle: Automating your BI Framework
Abstract:
Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, SSIS packages, and SSAS multidimensional or tabular models that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.
SessionID: 24847
SSAS 2012 Tips/Tricks with Tabular Schema Compare
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Christian Wade
Title: SSAS 2012 Tips/Tricks with Tabular Schema Compare
Abstract:
Also contrast multidimensional features with tabular equivalents (typically using DAX): many-to-many dimensions, measure expressions, semi-additive measures, default members, non-aggregatable hierarchies, IgnoreUnrelatedDimensions, conditional formatting, member properties, CurrentMember vs filter context, MDX vs DAX.
Some demos perform currency conversion; all are relevant to a wide range of business scenarios.
SessionID: 25143
Monitoring Databases in a Virtual Environment
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Thomas LaRock
Title: Monitoring Databases in a Virtual Environment
Abstract:
SessionID: 26406
SQL Server 2014 New Features
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Kevin Boles
Title: SQL Server 2014 New Features
Abstract:
There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. We will take a look at some of the new functionality via demos as well.
SessionID: 27402
Edge Case Testing for the Database Professional
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Vicky Harp
Title: Edge Case Testing for the Database Professional
Abstract:
SessionID: 27452
Data Flow Architectures in Software Development Life-Cycle
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Development
Speaker: Virginia Mushkatbat
Title: Data Flow Architectures in Software Development Life-Cycle
Abstract:
The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.
SessionID: 34648
What Happens When SQL Server 2014 Meets Cisco UCS? Simplified Cloud Adoption
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: SQL Server 2014 Launch Track
Speaker: Gary Serda
Title: What Happens When SQL Server 2014 Meets Cisco UCS? Simplified Cloud Adoption
Abstract:
SessionID: 9260
Hybrid Solutions: The Future of SQL Server Disaster Recovery
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: SQL Server 2014 Launch Track
Speaker: Allan Hirt
Title: Hybrid Solutions: The Future of SQL Server Disaster Recovery
Abstract:
The cloud is a polarizing buzzword in IT, especially for DBAs. The reality is that all of us will be affected by it over the next few years in one way or another much like we have been by virtualization. One of the best uses for the cloud is creating disaster recovery easier than we have been able to do in the past. This session will discuss the cloud from a SQL Server DBA perspective and how things like hybrid on premise/cloud solutions can be architected today to bring resiliency to current solutions with features like availability groups in SQL Server 2012 and 2014.
SessionID: 9390
Migration considerations for In-memory OLTP - What, Why, How and What not
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: SQL Server 2014 Launch Track
Speaker: Ami Levin
Title: Migration considerations for In-memory OLTP - What, Why, How and What not
Abstract:
In-memory OLTP is probably one of the most radical technologies to hit SQL Server in a long time. It has become the topic of endless discussions, debates, and the unavoidable myths. In this session we will cover the actual pains that drove the design of in-memory OLTP. We will understand WHAT it was created for, WHY it solves challenges that proved to be extremely hard to solve, HOW to find out if it is the right technology for you and not less important, what it was NOT designed for. We will cover a few real stories of applications that have utilized In-Memory OLTP successfully.
SessionID: 9661
Self-Service BI with PowerPivot and Power View
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Angel Abundez
Title: Self-Service BI with PowerPivot and Power View
Abstract:
SessionID: 9759
Peace of Mind: Making DBCC CHECKDB Go Faster
Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Development
Speaker: Argenis Fernandez
Title: Peace of Mind: Making DBCC CHECKDB Go Faster
Abstract: