sqlsathistory

Nr: 276

Back to Main list

SQLSaturday #276 - Silicon Valley 2014

Start Time (24h) Speaker Track Title
00:00:00 Bala Narasimhan Business Intelligence Decouple Database Performance from Database Capacity
00:00:00 Dan Bulos Bonus Track Dimensional Modeling: The Basics Beyond
00:00:00 Carlos Bossy Big Data/Azure Getting started with Big Data and BI
00:00:00 Sios Technology and Allan Hirt Database Administration Clusters Your Way - #SANLess clusters for physical, virtual and cloud environments
00:00:00 Fabian Pascal Development The Last NULL in the Coffin: Missing Data, SQL the Relational Model
00:00:00 Eddie Wuerch Database Administration What is a Latch, and Why Should I Care?
00:00:00 Jarek Kazmierczak Big Data/Azure Faster Insights From Any Data
00:00:00 Kalen Delaney SQL Server 2014 Launch Track Unblock yourself -- Optimistic concurrency in Hekaton
00:00:00 Karen Lopez Development $#*! Your Database Says About Me
00:00:00 Kevin Kline Bonus Track Team Leadership Fundamentals
00:00:00 Leonard Lobel Development Database Development with SQL Server Data Tools
00:00:00 Lynn Langit Big Data/Azure Machine Learning Smack Down
00:00:00 Mickey Stuewe Business Intelligence Best Practices for Efficient SSRS Report Creation
00:00:00 Mitchell Bottel Bonus Track Want a promotion? It’s up to you!
00:00:00 Denny Cherry SQL Server 2014 Launch Track SQL Server's In Memory Database Objects
00:00:00 Pat Sheehan SQL Server 2014 Launch Track SQL Server 2014 In-Memory Architecture - Microsoft xVelocity Engine
00:00:00 Paul Turley Business Intelligence BI Expert Panel - Part 1
00:00:00 Paul Turley Business Intelligence BI Expert Panel - Part 2
00:00:00 Randy Knight Database Administration Locks, Blocks, and Deadlocks Oh My!
00:00:00 Roberto Arnetoli and Andrew Eichenbaum Big Data/Azure An Analytics Sandbox in A World of Big Data
00:00:00 Sean Mikha Big Data/Azure Parallel Data Warehouse
00:00:00 Steve Jones Bonus Track Branding Yourself for a Dream Job
00:00:00 Stacia Varga Bonus Track Reduce, Reuse, Recycle: Automating your BI Framework
00:00:00 Christian Wade Business Intelligence SSAS 2012 Tips/Tricks with Tabular Schema Compare
00:00:00 Thomas LaRock Database Administration Monitoring Databases in a Virtual Environment
00:00:00 Kevin Boles Database Administration SQL Server 2014 New Features
00:00:00 Vicky Harp Database Administration Edge Case Testing for the Database Professional
00:00:00 Virginia Mushkatbat Development Data Flow Architectures in Software Development Life-Cycle
00:00:00 Gary Serda SQL Server 2014 Launch Track What Happens When SQL Server 2014 Meets Cisco UCS? Simplified Cloud Adoption
00:00:00 Allan Hirt SQL Server 2014 Launch Track Hybrid Solutions: The Future of SQL Server Disaster Recovery
00:00:00 Ami Levin SQL Server 2014 Launch Track Migration considerations for In-memory OLTP - What, Why, How and What not
00:00:00 Angel Abundez Business Intelligence Self-Service BI with PowerPivot and Power View
00:00:00 Argenis Fernandez Development Peace of Mind: Making DBCC CHECKDB Go Faster

SessionID: 10110

Decouple Database Performance from Database Capacity

Back to calendar

Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Bala Narasimhan

Title: Decouple Database Performance from Database Capacity

Abstract:

Virtualizing SQL Server has many benefits, but performance isn't one of them. Typically, I/O bottlenecks (due to storage) in a virtualized environment lead to poor and unpredictable database performance. Throwing money at the problem by purchasing more storage hardware is often expensive, disruptive and doesn't quite solve the problem.A better way is to accelerate virtualized SQL Servers by reducing I/O latency with Flash Hypervisor software.In this session, we will discuss:. Leveraging the virtualization platform to reduce costs and complexity of SQL Server deployments. The performance challenges of virtualizing SQL Server. Using Flash Hypervisor software to accelerate I/O and create high-performance SQL Servers. Real-world results – faster queries, more transactions and shorter processing times

SessionID: 11103

Dimensional Modeling: The Basics Beyond

Back to calendar

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

Back to calendar

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:

HDInsight is the latest evolution of Hadoop on the Windows platform. It allows you to manage big and unstructured data while using the rich Business Intelligence tools provided by SQL Server. This session will cover big data architecture and demonstrate map/reduce, the nucleus of big data technology. You will also see how you to get maximum value out of big data by incorporating it into your BI architecture with tools such as Hive, Excel, PowerQuery, and Tabular models.

SessionID: 12413

Clusters Your Way - #SANLess clusters for physical, virtual and cloud environments

Back to calendar

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

Back to calendar

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?

Back to calendar

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

Back to calendar

Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Big Data/Azure

Speaker: Jarek Kazmierczak

Title: Faster Insights From Any Data

Abstract:

Today’s organizations face growing challenges extracting business value from their data. The need for rapid insight is made more challenging by the expanding volume, complexity, and velocity of data. Traditional approaches to information management fail to harness this “data deluge”. New paradigms for data management and data analytics are emerging. Transformation of data to business insight requires a holistic approach that aligns the right platforms, technologies, and processes to support the decision process and analysis that business demands. During the session, we will the examine the Microsoft’s vision of enabling organizations to manage any data at any scale while empowering business users through self-serve information management and self-serve business intelligence. Through demos and interactive discovery we will explore how the PowerBI BI tools can be used with Hadoop /HDInsight to accelerate organizations’ journey from data to insight.

SessionID: 17846

Unblock yourself -- Optimistic concurrency in Hekaton

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Bonus Track

Speaker: Kevin Kline

Title: Team Leadership Fundamentals

Abstract:

Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, communication skills and project/job tracking skills. Attendees will learn:

  1. What are the fundamental ways that a new leader can build credibility and trust with their team?
  2. What are the unique ways in which IT people are motivated?
  3. How can a leader effectively communicate with their IT team using a variety of communication channels?
  4. How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?

SessionID: 19071

Database Development with SQL Server Data Tools

Back to calendar

Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Development

Speaker: Leonard Lobel

Title: Database Development with SQL Server Data Tools

Abstract:

With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and Windows Azure SQL Database. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the new generation of database tools for developers!

SessionID: 19323

Machine Learning Smack Down

Back to calendar

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

Back to calendar

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:

You always have more report requests than you can possibly fulfill. Wouldn't it be great if you could speed up the generation of reports? Templates can streamline the life cycle of a report for the whole team. In this session, you'll learn how templates in your tool belt can help you efficiently gather requirements, quickly design mock-ups, and standardize the look and feel of your SSRS reports.

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

Want a promotion? It’s up to you!

Back to calendar

Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Bonus Track

Speaker: Mitchell Bottel

Title: Want a promotion? It’s up to you!

Abstract:

Self-promotion is often times the best promotion you can get. In this session, we will talk about how to promote yourself, your brand and your career without looking like “That Guy”. We will discuss Social Medias, communities, volunteering and other ways to get your name out… What are the first steps? Come find out.

SessionID: 21021

SQL Server's In Memory Database Objects

Back to calendar

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

Back to calendar

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:

In this session we will review the xVelocity engine enhancements for columnar data and In-Memory OLTP. • For OLAP/DSS: provide an overview of columnstore –v- rowstore, learn how/when to apply columnstore indexes, demonstrate the radical improvement in columnstore can provide. There will be a demonstration where a DW system will be optimized using columnstore indexing. • For OLTP: describe the bottleneck inherent in OLTP operations, review a radical new approach to resolving the issue, and demonstrate the results. There will be a demonstration where an OLTP database will be converted to leverage SQL Server 2014’s new in-memory optimization. Benefits of attending: • You will learn where columnstore indexes are best suited, and, just as importantly, scenarios where they are not suited • You will learn how and why columnstore may provide orders of magnitude performance increase for your DW systems • You will learn how to create columnstore indexes • You will learn how to diagnose a specif

SessionID: 21852

BI Expert Panel - Part 1

Back to calendar

Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Paul Turley

Title: BI Expert Panel - Part 1

Abstract:

Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions. Join Rushabh Mehta (former PASS President), Brett Tomson and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world. Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, design your solution.

SessionID: 21853

BI Expert Panel - Part 2

Back to calendar

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!

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

Targeted at experienced SSAS practitioners, this session covers topics geared to enterprise implementations such as tabular schema compare, deployment of large tabular models, branching/merging models, and standardization of models in the enterprise. BISM Normalizer, a free tool for the SQL community, is included.

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

Back to calendar

Event Date: 15-03-2014 - Session time: 00:00:00 - Track: Database Administration

Speaker: Thomas LaRock

Title: Monitoring Databases in a Virtual Environment

Abstract:

When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.

SessionID: 26406

SQL Server 2014 New Features

Back to calendar

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

Back to calendar

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:

Are you confident that your application performs as expected on Leap Day? Do you know how long it would take to run out of identity values in your major tables? Can you support case-sensitive collations and non-standard sort orders? If not, odds are good that you are not edge and corner testing your application. In this session, learn how to define the edges of your application and start to stretch those boundaries by setting up challenging test and development environments. For database administrators, learn what configurations in your environment may be a source of bugs in application code and what you can do about it. Learn about edge cases that you can start hardening your code against on Monday morning!

SessionID: 27452

Data Flow Architectures in Software Development Life-Cycle

Back to calendar

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

Back to calendar

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:

Learn about Cisco Unified Computing System (UCS) and how it can enable an efficient and optimal platform for Microsoft SQL Server. During this session we will be discussing key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Service Profile Templates, Virtual Interface Adapters, and how they all can help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators can help to drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.

SessionID: 9260

Hybrid Solutions: The Future of SQL Server Disaster Recovery

Back to calendar

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

Back to calendar

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

Back to calendar

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:

PowerPivot in Excel is a free, easy to use data analytics engine capable of flexible calculations on large data sets with numerous connectivity options. Come and learn how you can take advantage of this data modeling tool in Excel and then promote it to the enterprise with Analysis Services and SharePoint. Also learn how to visualize this data with Power View, a fluid and highly interactive data visualization tool that will take your analysis to a new level.

SessionID: 9759

Peace of Mind: Making DBCC CHECKDB Go Faster

Back to calendar

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:

Along with backups, consistency checks are arguably the two most important tasks that DBAs need to perform regularly. Our databases are getting bigger every day, and CHECKDB run times, along with its performance impact to Production systems, keep increasing. In this session we discuss how to improve your system so that you can reduce the time that it takes to run CHECKDB or the individual DBCC CHECK* commands. We will cover topics like Transaction log and VLF management, tempdb configuration, trace flags, Resource Governor, and many more. In one of many the demos we will explore a real life example where SurveyMonkey's consistency checks were taken from 7 days down to 6 hours.