Take Control with Team Server
To establish a data culture within your company, the effort needs to be implemented across the various teams in the organization. This means giving the right visibility to the appropriate level of information about data sources and databases to both IT and business stakeholders. Embarcadero created the Team Server to help our customers take control of their data landscape. Learn how having a centralized hub for key corporate information improves your business communication and breaks down silos.

Level: All

Mohammad Ahmed - Embarcadero

Harvesting Metadata from ERP and CRM Packages: What's the Problem?
Packages like SAP, PeopleSoft and Salesforce are widely used and yet present significant challenges for Information Management professionals who have a requirement to understand what data is held in these environments. This presentation discusses the challenges of accessing metadata from these environments and explains how the large amounts of metadata in a package like SAP can be liberated and modelled.

Level: Intermediate

Nick Porter - Silwood Technology Ltd

SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions
Many believe performance tuning and troubleshooting is an art which has been lost in time. The truth is that the art has evolved with time and there are more tools and techniques to overcome ancient troublesome scenarios. There are three major resources when bottlenecks create performance problems: CPU, IO and memory. In this session, we focus on high CPU scenarios detection and their resolutions. If time permits, other performance-related tips and tricks will be also be covered. At the end of the session, attendees will have clear ideas and action items regarding what to do when facing any of the above resource intensive scenarios.

Level: Intermediate

Pinal Dave

Pragmatic Governance for Heterogeneous Data Stores
For companies operating in a very competitive market, it is vital to assist decision makers in maintaining their competitive edge by transitioning to a more distributed model for acquiring, storing and publishing the organization's enterprise data. Agility in presenting the right data to the right people at the right time as well as agility in developing new services is key to this transition. This session explores the ways ER/Studio data modeling technology is fundamental in supporting this process.

Level: Intermediate

Julian Clemas-Howard & Mark Barringer

How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance
SQL Window Functions address a wide variety of querying tasks that encompass computations, pivoting and sorting which are applied to a set of rows that is all applied by a function. Each function can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.

Level: All

Richard Baroniunas - Baron Software

The Data Balance Sheet: Is Your Data an Asset or Liability?
Data can be a double-edged sword. When it is organized with an effective data management process, it can be a valuable asset. If it is mismanaged, it can quickly become a liability. This session demonstrates how data might fall into the asset or liability column and examines the factors that contributed to its positive or negative classification.

Level: All

Joseph Maggi - Agilarc

Ensuring a Sustainable Architecture for Data Analytics
Enterprise data infrastructures must prepare for the future and adapt to support new database platforms and data sources. How can you make your data warehouse future-proof? By creating the right environment and establishing appropriate processes. Claudia Imhoff will describe what this involves by introducing the Extended Analytics Architecture, emphasizing the need to integrate multiple analytics environments, and describing how you can get started on this path to a sustainable analytics ecosystem.

Level: All

Claudia Imhoff - Intelligent Solutions, Inc.

What Performance IQ Can Do for You
The DB PowerStudio 2016 release includes several new features, one of which is Performance IQ, which provides visibility into your SQL code performance. This session walks through the Performance IQ dashboard and explains how it works and what it can do to help you improve your code.

Level: All

Scott Walz - Embarcadero

Championing the Data Model Scorecard within your Organization
The Data Model Scorecard® is the industry's benchmark on data model quality. You will receive an overview to the Scorecard and learn how to incorporate it into your organization's architecture review board.

Level: Intermediate

Steve Hoberman - Steve Hoberman & Associates, LLC

Performance Tuning your Backups and Restores
With short recovery time objectives we need to be able to recover as fast as possible. In this session, you will learn how John Sterrett was able to shave days off of the normal backup and restore times for a very large database (VLDB).

Level: Intermediate

John Sterrett - Procure SQL LLC

The Business Value of Data Modeling
With changes in software development methodologies, the role of the data modeler has changed significantly. In order to participate fully, modelers must not only adapt to an Agile work style, but must also be able to communicate and deliver business value through model-driven development. With content from a real case study, Ron Huizenga will show the contrast in metrics and cost when utilizing skilled data modelers versus a development-only approach.

Level: All

Ron Huizenga - Embarcadero