sqlsathistory

Nr: 267

Back to Main list

SQLSaturday #267 - Lisbon 2014

Start Time (24h) Speaker Track Title
00:00:00 Bob Duffy 4 - Super Development Optimising a dot.net solution on the SQL platform
00:00:00 Brent Ozar 1 - DBA How to Think Like the Engine
00:00:00 Brent Ozar 1 - DBA Real-Life SQL 2012 and 2014 Availability Group Deployments
00:00:00 Bruno Basto 5 - Mixed Data Data in, Information out
00:00:00 Constantin Klein 4 - Super Development SQL Server Data Tools - The IDE for database developers
00:00:00 Dejan Sarka 2 - Developers High Performance Statistical Queries
00:00:00 Edwin M Sarmiento 1 - DBA The Transaction Log and How It Affects HA/DR
00:00:00 Edwin M Sarmiento 5 - Mixed Data Integrating Big Data with SharePoint 2013
00:00:00 Etienne Lopes 4 - Super Development Securing SQL Server
00:00:00 Fernando Marçal 6 - Clustered Data Smart SSIS with BIML
00:00:00 Hugo Kornelis 5 - Mixed Data Create Your Own Aggregate
00:00:00 Niko Neugebauer 1 - DBA Clustered Columnstore Deep Dive
00:00:00 Jen Stirrup 5 - Mixed Data Power View from the Data Visualisation Perspective
00:00:00 Paulo Matos 6 - Clustered Data Project Sienna - The gist
00:00:00 Mark Broadbent 6 - Clustered Data Olde Cluster Curiosity Shoppe - A Miscellany of top tips from the field
00:00:00 Mihail Mateev 2 - Developers Entity Framework 6 New Features
00:00:00 Miloš Radivojević 2 - Developers Hekaton challenges from Database Development point of view
00:00:00 Miloš Radivojević 2 - Developers SQL Server 2014 - New Cardinality Estimator
00:00:00 Murilo Miranda 6 - Clustered Data Clustered Instance - Storage Introduction
00:00:00 Nabeel Derhem 7 - Free Data Introduction to NoSQL
00:00:00 Oliver Engels 3 - Business Intelligence Power BI - The self service BI Lifecycle in the cloud
00:00:00 Oliver Engels 3 - Business Intelligence M versus P versus R - Languages for Data Exploration
00:00:00 Paul Turley 3 - Business Intelligence Visualization Choices: What, When, and How?
00:00:00 Paul Turley 3 - Business Intelligence Tabular Models: Easier Faster Than Cubes; Really?
00:00:00 Pedro Simoes 7 - Free Data Good fellows: System Center and SQL Server
00:00:00 Paul te Braak 7 - Free Data Analytical Data Mining - Using Data Mining to Understand Data
00:00:00 Quilson Antunes 2 - Developers Data auditing
00:00:00 Regis Baccaro 5 - Mixed Data DBAs are from Mars, SharePoint admins are from Venus
00:00:00 Ruben Pertusa Lopez 6 - Clustered Data Improving our BI solutions with Geolocated data
00:00:00 Scott Klein 4 - Super Development SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive
00:00:00 Sergey Olontsev 4 - Super Development Analyzing Query Plans Deep Dive
00:00:00 Tim Mitchell 3 - Business Intelligence 15 Quick Tips for SSIS Performance
00:00:00 Tim Mitchell 3 - Business Intelligence Handling Errors and Data Anomalies in SSIS
00:00:00 Peter ter Braake 7 - Free Data MDX, it is not that hard!
00:00:00 Turgay Sahtiyan 2 - Developers Top 10 Performance Tips for SQL Server Developers
00:00:00 Andreas Wolter 1 - DBA SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive
00:00:00 Allan Mitchell 6 - Clustered Data Happy as a Pig in Muck
00:00:00 Johan Bijnens 1 - DBA Powershell: The DBA as a consumer
00:00:00 Artur Vieira 5 - Mixed Data SQL PDW vs SQL Server, let's see the big differences

SessionID: 10550

Optimising a dot.net solution on the SQL platform

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 4 - Super Development

Speaker: Bob Duffy

Title: Optimising a dot.net solution on the SQL platform

Abstract:

In this case study we will take a sample dot.net ecommerce application running in a load test harness and show common performance worst practices, how to correct them and the impact on performance. During a series of live demos we aim to test just how far we can optimise transactional processing.This session is aimed to help developers and DBA’s understand the performance impact of choices made within a dot.net application and its interaction with SQL Server.

SessionID: 10738

How to Think Like the Engine

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 1 - DBA

Speaker: Brent Ozar

Title: How to Think Like the Engine

Abstract:

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this session with Microsoft Certified Master Brent Ozar, you’ll role play as the database engine while Brent gives you queries. You’ll learn first-hand about clustered indexes, nonclustered indexes, execution plans, sargability, statistics, TempDB spills, and T-SQL anti-patterns.

SessionID: 10739

Real-Life SQL 2012 and 2014 Availability Group Deployments

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 1 - DBA

Speaker: Brent Ozar

Title: Real-Life SQL 2012 and 2014 Availability Group Deployments

Abstract:

You want to deploy AlwaysOn, but you're concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 and SQL 2014 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he's found in real-life deployments of AlwaysOn.

SessionID: 11006

Data in, Information out

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 5 - Mixed Data

Speaker: Bruno Basto

Title: Data in, Information out

Abstract:

Get a look through the tools that enable us to get information from data. In the last years BI became something that we all can get! Experience some of the patterns, tools and visualizations that are enablers of that change. SQL Tools through Excel is one of the keys…

SessionID: 11797

SQL Server Data Tools - The IDE for database developers

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 4 - Super Development

Speaker: Constantin Klein

Title: SQL Server Data Tools - The IDE for database developers

Abstract:

Since March 2012, SQL Server Data Tools (SSDT) are available for database developers as a project-based development environment within Visual Studio.

Although SSDT is installed automatically with Visual Studio 2012, this method of database development and the functions provided are completely new to many developers.

This session aims to change that and to provide an overview of the advantages and potentials of SSDT. You will see how you can develop, debug, refactor, deploy and maintain SQL Server and Azure databases from a single IDE.

SessionID: 13518

High Performance Statistical Queries

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 2 - Developers

Speaker: Dejan Sarka

Title: High Performance Statistical Queries

Abstract:

SQL Server 2012 database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient statistical queries that use the new Window functions and are optimized through proper indexing, including columnstore indices. We will also explain the formulas and usage of those statistical procedures. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.

SessionID: 13732

The Transaction Log and How It Affects HA/DR

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 1 - DBA

Speaker: Edwin M Sarmiento

Title: The Transaction Log and How It Affects HA/DR

Abstract:

When choosing the appropriate SQL Server HA/DR solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you choose. In this session, we will look at transaction log basics, how logging and recovery works and how it affects all of the HA/DR solutions available in SQL Server. You’ll be surprised to know that the transaction log is the most important part of your database.

SessionID: 13734

Integrating Big Data with SharePoint 2013

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 5 - Mixed Data

Speaker: Edwin M Sarmiento

Title: Integrating Big Data with SharePoint 2013

Abstract:

Are you currently working with Big Data? Do you wish it were easy to share that information with key stakeholders in your organization? In this demo-driven session, you will learn how to take the analysis you've done and share it with the entire organization via SharePoint 2013.

We will look at surfacing Big Data via Excel with PowerView and eventually publishing it in a SharePoint 2013 farm. We will also look at the security and performance implications of integrating Big Data with SharePoint 2013, so you will be able to properly design your Business Intelligence infrastructure.

SessionID: 13976

Securing SQL Server

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 4 - Super Development

Speaker: Etienne Lopes

Title: Securing SQL Server

Abstract:

Protecting our data from unwanted access is extremely important, wouldn't you agree?

In this session, using lots of demos to ilustrate each situation, I'll cover some pretty relevant topics such as: Authentication; SQL Injection; Encryption (source code/sensitive data/entire database/comunications/encrypted backups (new in SQL 2014)); Proper use of permissions over database objects (using intermediate layer, execution context, users without login, etc.); Proxy accounts; alerts for potencial security risks when using clr integration or database cross ownership; Auditing and more...

SessionID: 14255

Smart SSIS with BIML

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 6 - Clustered Data

Speaker: Fernando Marçal

Title: Smart SSIS with BIML

Abstract:

In this presentation we will show you the power that lies in BIML for SSIS – the power to subtract a significant amount of time from repetitive tasks and add that to tasks that bring real value. Join us for a session where we will show hands-on how to use BIML to generate an SSIS BI framework. This session will be co-presented with João Lopes.

SessionID: 15089

Create Your Own Aggregate

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 5 - Mixed Data

Speaker: Hugo Kornelis

Title: Create Your Own Aggregate

Abstract:

Have you ever flipped the pages of Books Online, only to find that the aggregate function you need is simply not there? So why not add it?

Ever since SQL Server 2005, you can easily create your own aggregate functions. All it takes is a bit of .NET code. This session will show you exactly how to create a CLR user-defined aggregate function, and how to use it in your queries. But it will also show you many workarounds to avoid having to do this for many commonly requested aggregates.

SessionID: 15359

Clustered Columnstore Deep Dive

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 1 - DBA

Speaker: Niko Neugebauer

Title: Clustered Columnstore Deep Dive

Abstract:

When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.

SessionID: 16530

Power View from the Data Visualisation Perspective

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 5 - Mixed Data

Speaker: Jen Stirrup

Title: Power View from the Data Visualisation Perspective

Abstract:

Power View is Microsoft's Data Visualisation tool. Where does it get it right, and where does it get it wrong? Using demos, we learn about Power View whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will:

Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View.

SessionID: 19402

Project Sienna - The gist

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 6 - Clustered Data

Speaker: Paulo Matos

Title: Project Sienna - The gist

Abstract:

Let's get to know Project Sienna and build simple apps for Windows 8.

SessionID: 19516

Olde Cluster Curiosity Shoppe - A Miscellany of top tips from the field

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 6 - Clustered Data

Speaker: Mark Broadbent

Title: Olde Cluster Curiosity Shoppe - A Miscellany of top tips from the field

Abstract:

Welcome to the strange and mysterious world of SQL Failover Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from the nearly two decades of installing and troubleshooting SQL Clusters.

SessionID: 20292

Entity Framework 6 New Features

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 2 - Developers

Speaker: Mihail Mateev

Title: Entity Framework 6 New Features

Abstract:

TThis talk is about new features in Microsoft Entity Framework 6 - the new major release of EF. In December 2012 Entity Framework 6 beta was announced and made publicly available. In October 2013 were released EF 6.00 (major release) and EF 6.01. This is the first new version of EF since the announcement in 2012 that the product would be Open Sourced. Entity Framework is hosted on CodePlex. This presentation is about the new features, included in EF 6: Async Query and Save, Custom Code First Conventions, Multi-Tenant Migrations, Configurable Migrations History Table, Code-Based Configuration, Dependency Resolution, Updated Provider Model, Enums, Spatial and Better Performance on .NET 4.x, Stored Procedures Functions in Code First, Connect

SessionID: 20739

Hekaton challenges from Database Development point of view

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 2 - Developers

Speaker: Miloš Radivojević

Title: Hekaton challenges from Database Development point of view

Abstract:

This session covers the Hekaton challenges for the developers at the 300-400 level including native compiled SPs but also some concerns about hekaton constraints etc.

SessionID: 20741

SQL Server 2014 - New Cardinality Estimator

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 2 - Developers

Speaker: Miloš Radivojević

Title: SQL Server 2014 - New Cardinality Estimator

Abstract:

In SQL Server 2014 query processing has been improved. What we can expect from new cardinality estimator? Does it really estimate better? Will our execution plans be better after migration to 2014? All of them? Is the key ascending column statistics problem solved in new version? Do we finally can have more than 200 steps in the statistics histogram per table? What about column correlation and cardinality estimates - are the predicates still completely independent?

This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.

SessionID: 21177

Clustered Instance - Storage Introduction

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 6 - Clustered Data

Speaker: Murilo Miranda

Title: Clustered Instance - Storage Introduction

Abstract:

With the evolution of SQL Server new possibilities are being opened, and today we have a vast range of possibilities to achieve our objectives. For a clustered instance is not different, as nowadays a shared storage living in a SAN is not the only possibility.

On this session I will introduce all the available ways to store database files in a clustered SQL Server instance, including the news of SQL Server 2014. If you never installed or even worked with a clustered instance, this is not an issue! A quick introduction about the role of clustered instance will be made.

I'll wait for you there!

SessionID: 21482

Introduction to NoSQL

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 7 - Free Data

Speaker: Nabeel Derhem

Title: Introduction to NoSQL

Abstract:

Understanding when and how to use NoSQL is already becoming essential, even for database professionals currently focusing only on the RDBMS world. This session will explain NoSQL for the SQL Server professional, discussing the history and needs that led to NoSQL solutions and the strengths and weaknesses in comparison with RDBMSs. We'll also explore the several NoSQL data models available in the market today (Key-Value, Column-Family, Document, and Graph) and cover the current solutions that implement them (Cassandra, MongoDB, Redis, Neo4j, etc.).

SessionID: 21537

Power BI - The self service BI Lifecycle in the cloud

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 3 - Business Intelligence

Speaker: Oliver Engels

Title: Power BI - The self service BI Lifecycle in the cloud

Abstract:

With the new Power BI Preview Microsoft brings more Self-service BI functionality to the users. In this session we will look from a different perspective to the offering: What about Governance, Application LifeCycle, Enterprise Integration? We will review what is currently possible in the preview for sharong querys, integrating the cloud offering with your enterprise data sources, monitoring datasources and gateways and what is possible to use it on Windows Mobile devices. This session is complete demo driven.

SessionID: 21538

M versus P versus R - Languages for Data Exploration

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 3 - Business Intelligence

Speaker: Oliver Engels

Title: M versus P versus R - Languages for Data Exploration

Abstract:

Power Query the new Excel Add In is a great data exploration toolset combined with other add ons

like Power Pivot, Power View and Power Map This session will take a deep dive into the language behind the Power Query: "M". We will take the language concepts and possibilities and try to compare them with another cool kids in town: "R" and "P" aka Python. What possibilities do these languages offer, where can you use them best and how good is the integration to the Microsoft stack. The session is driven by demos and you will take away a good starting point how to work with these three languages.

SessionID: 21825

Visualization Choices: What, When, and How?

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 3 - Business Intelligence

Speaker: Paul Turley

Title: Visualization Choices: What, When, and How?

Abstract:

When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models.

SessionID: 21826

Tabular Models: Easier Faster Than Cubes; Really?

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 3 - Business Intelligence

Speaker: Paul Turley

Title: Tabular Models: Easier Faster Than Cubes; Really?

Abstract:

The future of data analysis is the new, in-memory xVelocity Tabular analytic engine but is this new product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012? Maybe… It depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.

SessionID: 21917

Good fellows: System Center and SQL Server

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 7 - Free Data

Speaker: Pedro Simoes

Title: Good fellows: System Center and SQL Server

Abstract:

Let's meet these two friends that can help us in our daily lives.

The System Center Operations Manager can greatly help us to manage our SQL Server. Let's see what is the SCOM and meet some tips for monitoring our server SQL-server.

SessionID: 22383

Analytical Data Mining - Using Data Mining to Understand Data

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 7 - Free Data

Speaker: Paul te Braak

Title: Analytical Data Mining - Using Data Mining to Understand Data

Abstract:

Data mining is a technique used to derive previously unknown information from large amounts of data. The process of this knowledge discovery can help uncover new patterns within data and help analysts better understand the large datasets. Additionally, once these patterns have been defined, you can use them as part of predictive modelling estimating the likelihood of some event occurring.

SQL Server Analysis Services includes a data mining engine that can be used at various levels within an organization, from analyst to developer. This session will look at data mining as tool for data investigation by the business analyst. We examine the business case, requirements and outcomes of data mining so that it can enhance our understanding of datasets. We will look at both simple and complex implementations of data mining that allow new information to be extracted from data and used in novel ways within the MS Stack.

SessionID: 22408

Data auditing

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 2 - Developers

Speaker: Quilson Antunes

Title: Data auditing

Abstract:

This presentation's want to demonstrate some features of Data Auditing in SQL Server 2012.

What are the advantages and disadvantages of its use, where and in what environments to apply. The three approaches used were : • DML Triggers • Change Tracking • Change Data Capture

SessionID: 22819

DBAs are from Mars, SharePoint admins are from Venus

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 5 - Mixed Data

Speaker: Regis Baccaro

Title: DBAs are from Mars, SharePoint admins are from Venus

Abstract:

SharePoint databases are considered a black box - touch them and you lose support. Furthermore, SharePoint leaves an unintelligible track of database names and GUIDs on your server. They are supposed to scale, but how and how much? Here are some techniques DBAs should be aware of to optimize SharePoint performance and scalability. This demo-packed session, based on real-life experiences, will show you how to tune your SQL Server for SharePoint and how to customize your SharePoint installation so that it fits your IT conventions, not the other way around.

SessionID: 23486

Improving our BI solutions with Geolocated data

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 6 - Clustered Data

Speaker: Ruben Pertusa Lopez

Title: Improving our BI solutions with Geolocated data

Abstract:

The Business Intelligence capabilities are with us several years. Nowadays,the needs of analysis have changed and the geolocation of data is essential - not only qualitative information. We need to see our data on maps. We need to integrate it with external services to add value to our insights. In this session you will learn to improve our BI solutions with geolocation and take advantage with the SharePoint tools to share and publish this information. Custom DLLs, Excel Apps, Tabular/Multidimensional techniques and the new Power BI capabilities will be shown in different examples using a mapping tool already developed by SolidQ.

SessionID: 24097

SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 4 - Super Development

Speaker: Scott Klein

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Abstract:

Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine.

SessionID: 24341

Analyzing Query Plans Deep Dive

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 4 - Super Development

Speaker: Sergey Olontsev

Title: Analyzing Query Plans Deep Dive

Abstract:

Query plan shows how your query is physically executed and without a doubt, it is the best way to analyze most of the performance problems. We will delve into the internals of query plan operators, investigate how they work and where to look into query plan to find any problems.

SessionID: 26610

15 Quick Tips for SSIS Performance

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 3 - Business Intelligence

Speaker: Tim Mitchell

Title: 15 Quick Tips for SSIS Performance

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: 26611

Handling Errors and Data Anomalies in SSIS

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 3 - Business Intelligence

Speaker: Tim Mitchell

Title: Handling Errors and Data Anomalies in SSIS

Abstract:

Even in the most reliable ETL system, it's eventually going to happen: A package will fail, an output row count won't match what is expected, a data anomaly will force a forensic search of the package infrastructure... In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.

SessionID: 27076

MDX, it is not that hard!

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 7 - Free Data

Speaker: Peter ter Braake

Title: MDX, it is not that hard!

Abstract:

My first experience with MDX was: good, it looks like SQL: SELECT .. FROM .. WHERE. On my second glance it turned out to be completely different than SQL. But after a while SQL and MDX started to feel similar. In this session I bring you to the point of seeing the similarities instead of the differences. We will use your SQL experience to give you a head start with MDX. The session is also good for those with a bit of experience who want to know a bit more about the background. Of course all theory is backed by demo’s.

SessionID: 27148

Top 10 Performance Tips for SQL Server Developers

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 2 - Developers

Speaker: Turgay Sahtiyan

Title: Top 10 Performance Tips for SQL Server Developers

Abstract:

Performance of a SQL Server depends on many factors and due to the nature of development SQL Server developers sometimes miss basic performance tips. Easily implemented tips such as using an appropriate index or solving a data mismatch problem on where conditions could affect the application performance significantly. In this session, we will cover the top 10 tips to improve the performance of your SQL Server with real life examples.

SessionID: 8804

SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 1 - DBA

Speaker: Andreas Wolter

Title: SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive

Abstract:

You have heard about Hekaton, respectively the new Acronym XTP (eXtreme Transactional Processing) and you want to know how it works under the cover? In this session we will take a closer look at the architecture, where the performance benefits come from and how it works in detail. What kind of files is SQL Server using for transactional consistency, what happens when you delete data inside the log and inside the data files. We will see the Merge-Process and the Garbage collector in action, see how memory management works for XTP enabled databases, and thereby get an in-depth understanding of how this completely new storage engine works and how to optimize for it.

SessionID: 9294

Happy as a Pig in Muck

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 6 - Clustered Data

Speaker: Allan Mitchell

Title: Happy as a Pig in Muck

Abstract:

This session will take a look at Pig. Pig is a platform for analysing large datasets using a high level language in Hadoop. It is easy to use, intuitive and embarrassingly parallel. It was developed in order to avoid the complexities of Map Reduce. It is useful for ad-hoc analysis and of course ETL. During this session we will see it being used to manipulate structured and unstructured data.

SessionID: 9354

Powershell: The DBA as a consumer

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 1 - DBA

Speaker: Johan Bijnens

Title: Powershell: The DBA as a consumer

Abstract:

Focus for this session is demonstrating some quick benefits Powershell brings to day-to-day operations for a DBA and some gotchas experienced during the learning curve.

SessionID: 9874

SQL PDW vs SQL Server, let's see the big differences

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: 5 - Mixed Data

Speaker: Artur Vieira

Title: SQL PDW vs SQL Server, let's see the big differences

Abstract:

In this session we will present a live comparison between the SMP and MPP versions of SQL Server, with a special attention to architecture and Performance, and the spirit of the session will be “Forget the slides… let’s just do Demos”

This site is open source. Improve this page.