Nr: 279
SQLSaturday #279 - Phoenix 2014
SessionID: 10772
Optimizing SQL Server for SharePoint
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA / Prof Dev
Speaker: Brian Alderman
Title: Optimizing SQL Server for SharePoint
Abstract:
Knowing the vast majority of the content accessed via SharePoint is stored in SQL Server, and also knowing an incorrect configuration of SQL Server can have a detrimental impact on the performance of SharePoint it is important to understand the integration of these two products. Regardless of whether you have a dedicated DBA, or the SharePoint administrator is also the DBA, there are critical SQL Server configurations that can be made that will improve the performance of SharePoint. Often DBA’s are familiar with how to manage SQL Server, but may not be familiar with some nuances that SQL Server has when integrated with SharePoint. In this session we will demonstrate how some default SQL Server settings negatively impact SharePoint and what changes can be made to improve the performance of SharePoint. These changes include database file settings and SQL Server instance settings. We'll also examine how to properly install SQL Server and SharePoint so they work together efficiently.
SessionID: 10843
SQL 2012 Extended Events
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Jason Brimhall
Title: SQL 2012 Extended Events
Abstract:
SessionID: 10846
Murder They Wrote
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Brimhall
Title: Murder They Wrote
Abstract:
Joint Session with Wayne Sheffield
SessionID: 11349
Getting started with Big Data and BI
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: Carlos Bossy
Title: Getting started with Big Data and BI
Abstract:
SessionID: 11350
Enterprise Tabular Models
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: Carlos Bossy
Title: Enterprise Tabular Models
Abstract:
SessionID: 11511
Becoming Certified In Microsoft SQL Server
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI/ APP DEV
Speaker: Chris Hyde
Title: Becoming Certified In Microsoft SQL Server
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 12444
Biml – The Next Step in Agile Data Warehousing
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: ETL / SSIS
Speaker: David Stein
Title: Biml – The Next Step in Agile Data Warehousing
Abstract:
SessionID: 12446
Data Warehouse Mistakes You Can’t Afford to Make
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: David Stein
Title: Data Warehouse Mistakes You Can’t Afford to Make
Abstract:
Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.
SessionID: 13897
Make Your DBA Happy: 5 Habits Developers Can Implement Today
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV
Speaker: Eric Oszakiewski
Title: Make Your DBA Happy: 5 Habits Developers Can Implement Today
Abstract:
Don't make your DBA groan each time you need to start a project! There are best practices and good habits developers can be using when developing databases that not only make your DBA happy, but keep the application and entire database server healthy. Learn about 5 good habits developers can be using right now to show your database admin you really care, including but not limited to T-SQL query construction and database design.
SessionID: 13904
Preparing SQL for SharePoint the balance of resources
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Eric Stoltze
Title: Preparing SQL for SharePoint the balance of resources
Abstract:
In this session we will discuss recommended practices around the preparation of SQL for SharePoint 2013.
SessionID: 14663
Power BI – Cloud Self-Service BI
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI / Big Data
Speaker: Ginger Grant
Title: Power BI – Cloud Self-Service BI
Abstract:
Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.
SessionID: 14664
The Sqoop on Big Data from it’s humble beginnings to rise to notoriety
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI / Big Data
Speaker: Ginger Grant
Title: The Sqoop on Big Data from it’s humble beginnings to rise to notoriety
Abstract:
SessionID: 14841
SQL 2012 AlwaysOn
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Gene Stout
Title: SQL 2012 AlwaysOn
Abstract:
Class will cover the basics of AlwaysOn and it is terminology. It will also cover basic setup and configuration using asynchronous commit mode.
SessionID: 16878
Getting Started with Execution Plans
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI/ APP DEV
Speaker: Jason Kassay
Title: Getting Started with Execution Plans
Abstract:
There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager 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, one of the first things 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: 17155
Enterprise-grade MDM On SQL Server - the Keys to Success
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI / Big Data
Speaker: John McAllister
Title: Enterprise-grade MDM On SQL Server - the Keys to Success
Abstract:
This session discusses a proven organizational approach and important technical considerations that lead to the successful adoption of Master Data Management (MDM) on SQL Server.
Organizational considerations include building buy-in, team capability expertise, and selling MDM to the rest of the organization while building a subject-area center of excellence. We also discuss approaches to improved time-to-value and to ensure that the technology and staff investment is matched to the expected outcome.
Great technology choices will help ensure that your best laid plans succeed and the second half of this session goes over some important technology considerations. In this part of the session we discuss User Experience, Integration Patterns, Matching, Programmability, and Data Quality.
SessionID: 17179
Powershell for SQL Server DBA's
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA / Prof Dev
Speaker: John Sterrett
Title: Powershell for SQL Server DBA's
Abstract:
Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an introduction to PowerShell with a focus on SQL Server. In this session, we will cover the basics towards configuring and using PowerShell. We will also cover the basic syntax of PowerShell that will help you get started in the right direction. Finally, we will conclude the session with some examples that could make your SQL Admin life a lot easier.
SessionID: 17506
Introduction to Microsoft Power Query
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI/ APP DEV
Speaker: Josh Sivey
Title: Introduction to Microsoft Power Query
Abstract:
Microsoft Power Query is an Excel plugin that enhances self-service business intelligence by allowing for discovering, merging, and enriching data from a variety of data sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia. In this session we’ll explore the basics of Power Query including how to use the plugin to source, merge, and enrich data to support self-service analytics.
SessionID: 17623
Fundamentals of Data Warehouse Architecture and Design
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI/ APP DEV
Speaker: Joe Salvatore
Title: Fundamentals of Data Warehouse Architecture and Design
Abstract:
This session will cover key ideas for organizing the hardware and software environment into appropriate logical and physical tiers in order to best support data warehouse extraction, staging, and data mart processes. Additionally the session will cover key differences in leading data warehouse architectures and will finish with a primer on dimensional modeling.
SessionID: 17825
An End-to-End Big Data Architecture to Improve Marketing ROI
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI / Big Data
Speaker: John Yang
Title: An End-to-End Big Data Architecture to Improve Marketing ROI
Abstract:
In this presentation you will learn about a real life big data use case to increase web and directly mail marketing ROI, using different components - R, Hadoop, Mahout, data warehouse, Powerpivot and Powerview. Those different technologies are implemented to work together to deliver a smart auto-learning system to produce prediction models, such as lead to buyer conversion prediction, search engine marketing optimization and spending allocation optimization. This data architecture solution will help you to determine how big data solution can help your organization to full utilize your existing data.
SessionID: 18247
SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Cox
Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive
Abstract:
SessionID: 18248
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI/ APP DEV
Speaker: Kevin Cox
Abstract:
SessionID: 18432
Writing Better T-SQL Queries with Window Functions
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV
Speaker: Kathi Kellenberger
Title: Writing Better T-SQL Queries with Window Functions
Abstract:
This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
SessionID: 18434
Women in Tech Panel
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Kathi Kellenberger
Title: Women in Tech Panel
Abstract:
This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women -- and men -- in tech. Everyone welcome to this very interactive session.
SessionID: 18853
The Curious Case of Isolation Levels
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Keith Tate
Title: The Curious Case of Isolation Levels
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: 19235
SQL Server Statistics – What Are The Chances?
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Lori Edwards
Title: SQL Server Statistics – What Are The Chances?
Abstract:
For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. At the end of this session, you should have a better idea of how SQL Server makes decisions on how to gather data.
SessionID: 19340
Unlock the Power in Power BI
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: Matt Smith
Title: Unlock the Power in Power BI
Abstract:
Power BI is Microsoft's latest cloud self service BI offering. Join me as we peel back the layers and features of Power BI. What's available? When, How, and Why do I use Power BI? See how Power BI can truly enable business users to lead the way and build justification for critical business decisions without needing IT data gurus.
SessionID: 19422
SQL Server 2012 Master Data Services / Data Quality Services
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: Marc Jellinek
Title: SQL Server 2012 Master Data Services / Data Quality Services
Abstract:
Tired of seeing your name spelled 27 different ways... all from the same company? Tired of making the same corrections over and over and over again? Would it be better if business users could directly correct data and have the corrections recorded and consistently applied?
Surely someone has come up with a solution to these problems?
Come check out how software you likely already own can solve these problems.
This session was originally presented at SQL Saturday 158 in NYC, but has been enhanced with additional content and all filler has been mercilessly cut, folded, spindled and mutilated.
http://www.sqlsaturday.com/viewsession.aspx?sat=158sessionid=9892
SessionID: 19566
Probing into the Microsoft SSIS Model: Reconfiguring SSIS Packages Using an Automated Approach
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: ETL / SSIS
Speaker: Mark Paszli
Title: Probing into the Microsoft SSIS Model: Reconfiguring SSIS Packages Using an Automated Approach
Abstract:
While many in the BI realm are comfortable performing SSIS tasks using Microsoft Business Intelligence Studio, there is that other world of exploration that utilizes the SSIS programming interface API. Why use it? In this session we will go over some basic approaches as to how to take advantage of the SSIS API model to perform package configuration and property changes in an automated manner. This is especially advantageous in enterprise systems that maintain numerous dtsx packages. Automating changes to SSIS packages reduces the amount of development time that otherwise would be spent if one were to go in and manually apply these changes using the graphical interface.
SessionID: 19752
Designing and Loading Slowly Changing Dimensions
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: Martin Schoombee
Title: Designing and Loading Slowly Changing Dimensions
Abstract:
The first part of this session takes a look at all the different design elements and considerations of SCD's. We'll look at whether it is feasible to create a snowflake, how to deal with relationships between dimensions as well as 1:1 and many:many relationships with fact tables.
Afterwards, we will walk-through a practical and effective method (with code) to load SCD's with T-SQL.
SessionID: 21163
What secrets does your table schema hold?
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV
Speaker: Andre DuBois
Title: What secrets does your table schema hold?
Abstract:
We begin with discussion on best practices for choosing data types and why the right data type is important for performance and data integrity. We will then run scripts to spotlight inconsistent field lengths and data types as examples of secrets that will be revealed.
This session will help you design better tables so your data is more stable and reliable. It is also a good review if you will be taking exam 70-461.
SessionID: 21590
Introduction to the Hive Query Language for BI Developers
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI / Big Data
Speaker: Orion Gebremedhin
Title: Introduction to the Hive Query Language for BI Developers
Abstract:
The Hadoop ecosystem has emerged as the most viable means of working on huge amount of data which is now commonly referred to as “BigData”. The piping- and parallelism approach of breaking heavy tasks in to smaller manageable tasks and executing them in parallel on readily available commodity hardware, relies on the MapReduce programing framework. One of the challenges facing the enterprise BI team is the learning curve in moving from existing solutions built on traditional databases to Hadoop clusters which are primarly designed to be queries using MapReduce programing constructs . Initially developed by Facebook, and used and enhanced by other companies like Netflix and Amazon; the Hive Query Language (HQL), bridges the gap between MapReduce and Traditional SQL. In this presentation I will be discussing the basic commands required to interact with Hadoop File System (HDFS), as well as the fundamental query constructs of Hive. Demos will done on a Hortonworks , Apache Hadoop SandBox.
SessionID: 22522
Understanding the SQL Server Transaction Log
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA / Prof Dev
Speaker: Randy Knight
Title: Understanding the SQL Server Transaction Log
Abstract:
The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.
SessionID: 22523
Locks, Blocks, and Deadlocks Oh My!
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV / DBA
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: 22758
Increase your SSIS productivity with Biml
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: ETL / SSIS
Speaker: Reeves Smith
Title: Increase your SSIS productivity with Biml
Abstract:
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
SessionID: 22912
Battle of the Finch Bots
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI/ APP DEV
Speaker: Jeff Renz
Title: Battle of the Finch Bots
Abstract:
Robots, SQL, Twitter and games! In an ongoing battle across SQL Saturdays, our two Finch bots RGPDEV (represents developers) and RGPDBA (represents DBAs) will compete against each other. You the audience will help determine the winner of the finch bot race by voting real time on twitter for your favorite robot. After all games are over we will use the data collected by the finch bots to select 4 participants to advance to a cyber boxing tournament to win a finch bot.
SessionID: 22915
Dashboards - More than One Way to Visualize Data
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI / Big Data
Speaker: Jeff Renz
Title: Dashboards - More than One Way to Visualize Data
Abstract:
Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical). Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.
SessionID: 23089
Event Notification in SQL Server 2012
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Robert Miller
Title: Event Notification in SQL Server 2012
Abstract:
This session will cover an introduction to Event Notification usage in SQL Server 2012.
SessionID: 23704
SQL Clustering - what it is, what it isn't, and how to get both
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Ryan McCauley
Title: SQL Clustering - what it is, what it isn't, and how to get both
Abstract:
Windows Failover Clustering has been a common solution to providing failover and high-availability in SQL Server environments, and can be used to cluster an instance of sql server, as well as serve as the supporting infrastructure for AlwaysOn. But for a new server deployment, which should you use - traditional clustered instances or AlwaysOn, and what's the difference? While not delving into advanced implementation, this session will describe what clustering is, the components involved, how it's used (both historically and with AlwaysOn), clear up some common terminology around clustering, and help set the stage for your next deployment.
SessionID: 24631
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Shawn Meyers
Abstract:
SessionID: 26401
SQL Server 2014 New Features
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
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: 26402
SQL Injection
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Boles
Title: SQL Injection
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
SessionID: 26622
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: ETL / SSIS
Speaker: Tim Mitchell
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter.
In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
SessionID: 26623
Handling Errors and Data Anomalies in SSIS
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: ETL / SSIS
Speaker: Tim Mitchell
Title: Handling Errors and Data Anomalies in SSIS
Abstract:
SessionID: 26897
Database Release Management: Tips to help organize it
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: TJay Belt
Title: Database Release Management: Tips to help organize it
Abstract:
The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases. The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities.
We will discuss various terms, define processes, share ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion.
SessionID: 26898
Documentation – you know you love it
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: TJay Belt
Title: Documentation – you know you love it
Abstract:
SessionID: 27372
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Vern Rabe
Abstract:
Maintaining SQL Server performance is a constant task. Whether you are a developer or a database administrator, there are many things that you can do to avoid those poorly performing queries. In this session we’ll discuss some common guidelines and offer some tidbits for developing fast queries; and if you already have some poorly performing queries, we’ll discuss some ways to identify the source of the poor performance.
SessionID: 27554
Introduction to FileTables in SQL 2012
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV
Speaker: Warren Sifre
Title: Introduction to FileTables in SQL 2012
Abstract:
SessionID: 28123
Beyond Plateaux: Optimize SSAS via Best Practices
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: Beyond Plateaux: Optimize SSAS via Best Practices
Abstract:
SessionID: 28124
Getting Started with MDX
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
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: 34672
Master Data Services - 4 Key Features in 60 Minutes
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: BI
Speaker: John McAllister
Title: Master Data Services - 4 Key Features in 60 Minutes
Abstract:
SessionID: 9391
Where did I put my (primary) keys?
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV / DBA
Speaker: Ami Levin
Title: Where did I put my (primary) keys?
Abstract:
In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.
We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.
SessionID: 9392
Physical Join Operators
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: APP DEV
Speaker: Ami Levin
Title: Physical Join Operators
Abstract: