sqlsathistory

Nr: 317

Back to Main list

SQLSaturday #317 - Oslo 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Belkis Ozhorasan	Track 4	Introducing Microsoft Azure HDInsight
00:00:00	Bob Duffy	Track 2	Load Testing Analysis Services
00:00:00	Boris Hristov	Track 4	The nightmare of locking, blocking and isolation levels!
00:00:00	Cathrine Wilhelmsen	Track 3	Generate SSIS packages automatically with Biml and BimlScript
00:00:00	Erik Flateby	Track 1	CUBE-functions for fun profit
00:00:00	Henk van der Valk	Track 3	SQL Server PDW (APS) vs SQL Server, let's see the big differences
00:00:00	Niko Neugebauer	Track 4	Clustered Columnstore Deep Dive
00:00:00	Joe Chang	Track 2	Modern Performance
00:00:00	Johan Ludvig Brattås	Track 4	Visualization – tales from the field. How to build a cool Risk Analysis Dashboard on a shoestring
00:00:00	Kaisa Lervik	Track 3	What is Microsoft doing with Predictive Analytics?
00:00:00	Kalen Delaney	Track 2	Unblock yourself -- Optimistic concurrency in Hekaton
00:00:00	Kennie Pontoppidan	Track 1	SQL anti patterns
00:00:00	Margarita Naumova	Track 1	Top 10 DBA mistakes that affect the SQL Server performance
00:00:00	Marco Russo	Track 4	DAX from the field: Real World Case Studies
00:00:00	Neil Hambly	Track 2	Effective Index Partitioning, Compression Strategy
00:00:00	Pieter Vanhove	Track 1	1, 2, 3, … 100. How to manage many SQL Servers the
00:00:00	Regis Baccaro	Track 1	Power View and the Cube
00:00:00	Scott Klein	Track 2	SQL Server 2014 Top 5 - Hybrid Features
00:00:00	Sergey Olontsev	Track 3	Analyzing Query Plans Deep Dive
00:00:00	Tim Ford	Track 1	Query Tuning Superstardom for Beginners
00:00:00	Mikael Wedham	Track 2	Practical use of the SSIS Script components
00:00:00	André Kamman	Track 4	Private Cloud for DBAs
00:00:00	Aaron Nelson	Track 3	PowerShell for Data Professionals

SessionID: 10205

Introducing Microsoft Azure HDInsight

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Belkis Ozhorasan

Title: Introducing Microsoft Azure HDInsight

Abstract:

HDInsight on Azure improves your access to Hadoop and lowers the friction to getting started with learning and using big data technology, as well as to scaling to the challenges of modern information production. This session will cover a brief introduction to HDInsight Service on Microsoft Azure with hands-on scripts and demo.

SessionID: 10568

Load Testing Analysis Services

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Bob Duffy

Title: Load Testing Analysis Services

Abstract:

Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn't meet the required volumes of user concurrency?

This session focuses on tools and methodology to load test Analysis Services in highly concurrent environments. Including how to locate resource bottlenecks and the appropriate configuration settings that can help improve performance.

Sample source code will be supplied to help you load test analysis services. We will be focused on the MOLAP engine, but techniques are equally applicable to the tabular model.

SessionID: 10953

The nightmare of locking, blocking and isolation levels!

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Boris Hristov

Title: The nightmare of locking, blocking and isolation levels!

Abstract:

I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a real nightmare! In this session, you will be able to see and understand why and how locking actually works, what problems it causes and how can we use isolation levels and various other techniques to resolve them!

SessionID: 11230

Generate SSIS packages automatically with Biml and BimlScript

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Cathrine Wilhelmsen

Title: Generate SSIS packages automatically with Biml and BimlScript

Abstract:

SSIS is a powerful tool for extracting, transforming and loading data, but creating the actual SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over again. There are no easy ways to handle metadata and schema changes, and if there are new requirements you might have to go through all the packages one more time.

It's time to bring the Don't Repeat Yourself principle to SSIS development. In this session I will use the free BIDS Helper add-in to show you the basics of Biml and BimlScript, how to generate SSIS packages automatically from databases and flat files, how easy those packages can be changed, and how to move common code to separate files that can be included where needed. See why they say Biml allows you to complete in a day what once took more than a week!

SessionID: 13922

CUBE-functions for fun profit

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Erik Flateby

Title: CUBE-functions for fun profit

Abstract:

CUBE-functions are a little understood and seldomly used feature of Excel, but they have tremendous power for creating high-impact, custom reports that don’t look like pivottables at all. In this demo-rich presentation we start out by giving an introduction to what they actually do, then dive right into how to make them work for us. In the end we will investigate their use with Excel Services, Powerpivot Services and PowerBI.

SessionID: 15124

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

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Henk van der Valk

Title: SQL Server PDW (APS) 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 , hadoop integration and Performance! The spirit of the session will be “Forget the slides… let’s just do live Demos!”

SessionID: 15428

Clustered Columnstore Deep Dive

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4

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

Modern Performance

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Joe Chang

Title: Modern Performance

Abstract:

Everyone knows that hardware today is immensely powerful in all aspects- CPU, memory and even IOPS (with proper configuration). It is less appreciated that in recent versions the SQL Server query optimizer can quickly find a good executions plan from a staggering number of possibilities. And yet it is also generally understood that performance is still an important topic today. This apparent paradox stems from the fact that when mistakes happen in software – especially for database query optimization, it can happen in spectacular fashion. Several examples of SQL that can experience catastrophic performance problems are presented, along with the method of diagnosis and corrective action.

SessionID: 17140

Visualization – tales from the field. How to build a cool Risk Analysis Dashboard on a shoestring

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Johan Ludvig Brattås

Title: Visualization – tales from the field. How to build a cool Risk Analysis Dashboard on a shoestring

Abstract:

Visualization is all the rage – with the focus on Self-Service BI, In-Memory technology and fancy graphics. Tableau, QlikView and Microsoft PowerBi are showing off the eye-candy, and managers like what they see. However, either these solutions cost a lot of money, or your organization is stuck on older versions of software that lacks the functionality needed.

This session will show you how to make a cool dashboard using a database (MS SQL Server 2008), Excel 2010, and in addition how to prepare your solution for SQL2012 and the full PowerBI-suite with PowerPivot

SessionID: 17838

What is Microsoft doing with Predictive Analytics?

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Kaisa Lervik

Title: What is Microsoft doing with Predictive Analytics?

Abstract:

Data mining has been a feature of Microsoft SQL Server since 2000, but has received little attention lately. Is Microsoft up to something? What? How? When? In this session we take a look at what Predictive Analytics is, and what Microsoft has to offer.

SessionID: 17852

Unblock yourself -- Optimistic concurrency in Hekaton

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2

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

SQL anti patterns

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Kennie Pontoppidan

Title: SQL anti patterns

Abstract:

You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet.

We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.

SessionID: 19380

Top 10 DBA mistakes that affect the SQL Server performance

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Margarita Naumova

Title: Top 10 DBA mistakes that affect the SQL Server performance

Abstract:

There are always performance problems that could happen with your production database. But you will be surprised how many of them are happening as a result of DBAs actions or lack of proper attention. If you know them and how they harm your database system it will be easier to not get there. The session shows the worst practices from the field in maintaining and configuring your SQL Server databases and gives recommendations as well as tips and tricks how to avoid them

SessionID: 19472

DAX from the field: Real World Case Studies

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Marco Russo

Title: DAX from the field: Real World Case Studies

Abstract:

DAX is still relatively new for many BI practitioners, but it has being used for more than 4 years now, also in large installations that push the xVelocity in memory engine to its limit. In this session, we will share some of the lessons learned from the field, where real customers have problems harder to solve than Adventure Works scenarios. How do you make a database fit in memory, if it does not fit? How do you handle billions of rows with complex calculation? Can you perform reporting in any time zone, with time intelligence, in an efficient way? What tools do you use to benchmark and choose the right hardware? How do you scale up performance on small and large databases? What are the common mistakes in DAX formulas that might cause performance bottlenecks? These are just a few examples of the problems that you will see in this session. You will learn the solutions found and how far you can push the limits of the system.

SessionID: 21388

Effective Index Partitioning, Compression Strategy

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Neil Hambly

Title: Effective Index Partitioning, Compression Strategy

Abstract:

We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server.

When Indexing also combines 2 of the Enterprise features: Partitioning Compression, we can often see substantial gains.

Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.

Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.

SessionID: 22148

1, 2, 3, … 100. How to manage many SQL Servers the

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Pieter Vanhove

Title: 1, 2, 3, … 100. How to manage many SQL Servers the

Abstract:

Quote: “A good DBA is a lazy DBA”. When you have to manage a few SQL Servers, it’s not that hard to be a lazy DBA and to automate your day to day activities. But when you have to manage over 100 instances, it can become a tough job. Just imagine how you will deploy a new maintenance job on all your instances? Are you going to connect to each server one by one? Not really… Microsoft provides an enhanced set of multi-server management tools. The purpose of this sessions is to point out which SQL Server tools you can use for multi-server management. The session is bulk loaded with demos and it will give you a good idea what features can be helpful in your environment.

SessionID: 22856

Power View and the Cube

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Regis Baccaro

Title: Power View and the Cube

Abstract:

Did you know that Power View is not any longer limited to getting data from Tabular models ? Now that Power View users can connect to multidimensional BI Semantic Model (Cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models.

The session we'll present

• An understanding of the Multidimensional Model Objects in Power View
• How to create a Shared Report Data Source Connection to a Multidimensional Model
• How to create a Power View Report with a Multidimensional Model Data Source
• An visual exploration of a Multidimensional Model by using Power View

SessionID: 24199

SQL Server 2014 Top 5 - Hybrid Features

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Scott Klein

Title: SQL Server 2014 Top 5 - Hybrid Features

Abstract:

Microsoft SQL Server 2014 brings to market new capabilities to simplify cloud adoption and help you unlock new hybrid scenarios. This demo-filled session will highlight these top features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud by providing new disaster recovery and backup solutions.

SessionID: 24374

Analyzing Query Plans Deep Dive

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3

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

Query Tuning Superstardom for Beginners

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Tim Ford

Title: Query Tuning Superstardom for Beginners

Abstract:

In this session aimed at the novice query tuner we'll explore what big results may be yielded through the smallest of query tweaks. We will explore impacts of removing unnecessary joins, predicate blunders and problems with returning too much information. The end result is to improve those bad queries and make you look like a tuning superstar.

SessionID: 27783

Practical use of the SSIS Script components

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Mikael Wedham

Title: Practical use of the SSIS Script components

Abstract:

This session will demonstrate some of the functionality of the scripting components in Integration Services based on practical use-cases and real world applications. You'll see how to parse stange fileformats, how to create your own Data-Driven subscription of Reporting Services among other things.

SessionID: 34569

Private Cloud for DBAs

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: André Kamman

Title: Private Cloud for DBAs

Abstract:

It's probably rare that you have to install a SQL Server instance manually. You most likely have some unattended install scripts ready and perhaps even a script, using powershell, which configures the newly installed SQL Server according to your (corporate) standards.

But "at home" developers can click a few buttons in Windows Azure and have a SQL Server available within minutes. They are starting to be less impressed with your one-day process. In this session I'll walk you through the steps that you can take to create your own private cloud. Including rolling out sysprepped SQL Server vm's, giving your internal customers self-service capabilities but without losing control over your (corporate) standards. Did you know that you can even get a user interface for your internal customers which looks exacly like the Windows Azure interface?

SessionID: 8877

PowerShell for Data Professionals

Back to calendar

Event Date: 30-08-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Aaron Nelson

Title: PowerShell for Data Professionals

Abstract:

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

This site is open source. Improve this page.