SQLSaturday #317 - Oslo 2014

Event Date: 08/30/2014 00:00:00

Event Location:

  • NITH Westerdals (Oslo School of Arts, Communication and Technology)
  • Schweigaardsgate 14
  • Oslo, Norway

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

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!


  • Cathrine Wilhelmsen

Track and Room: Track 3 - N/A

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.


  • Aaron Nelson

Track and Room: Track 3 - N/A

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.


  • Marco Russo

Track and Room: Track 4 - N/A

Title: FILETABLEs: What They Are and How to Use Them

Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d


  • Matija Lah

Track and Room: Track 3 - N/A

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.


  • Joe Chang

Track and Room: Track 2 - N/A

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.


  • Pieter Vanhove

Track and Room: Track 1 - N/A

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?


  • André Kamman

Track and Room: Track 4 - N/A

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.


  • Scott Klein

Track and Room: Track 2 - N/A

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.


  • Kaisa Lervik

Track and Room: Track 3 - N/A

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


  • Margarita Naumova

Track and Room: Track 1 - N/A

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.


  • Mikael Wedham

Track and Room: Track 2 - N/A

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.


  • Neil Hambly

Track and Room: Track 2 - N/A

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!”


  • Henk van der Valk

Track and Room: Track 3 - N/A

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.


  • Belkis Ozhorasan

Track and Room: Track 4 - N/A

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.


  • Sergey Olontsev

Track and Room: Track 3 - N/A

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.


  • Kalen Delaney

Track and Room: Track 2 - N/A

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.


  • Niko Neugebauer

Track and Room: Track 4 - N/A

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.


  • Kennie Pontoppidan

Track and Room: Track 1 - N/A

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!


  • Boris Hristov

Track and Room: Track 4 - N/A

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.


  • Tim Ford

Track and Room: Track 1 - N/A

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


  • Regis Baccaro

Track and Room: Track 1 - N/A

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.


  • Bob Duffy

Track and Room: Track 2 - N/A

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.


  • Erik Flateby

Track and Room: Track 1 - N/A

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


  • Johan Ludvig Brattås

Track and Room: Track 4 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Pieter Vanhove

Contact: http://pietervanhove.azurewebsites.net/

Pieter Vanhove is a SQL Server MVP and Database Consultant in Belgium and has been working with SQL Server since 2000. Performance tuning, SQL audits, migrations and training are part of the job. Pieter has also a profound knowledge in implementing HA/DR solutions and loves the new Azure stuff. Together with the SQLUG in Belgium, he helps organizing SQL Server Days and is also a regular speaker at Belgian and international events. Pieter recently won the Speaker Idol Contest at PASS Summit 2014.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

Johan Ludvig Brattås

Twitter: - intoleranse

LinkedIn: Johan Ludvig Brattås

Contact: http://brattas.org/sqlmusings

Johan Ludvig Brattås is a managing consultant at Capgemini, and a dedicated community guy. He has worked with MS SQL server since late 1999, mostly with BI in one form or another. The last 6 years, most of his work has been in Azure working on data platforms, Power BI and the last three years expanding to Azure IoT and Stream Analytics.

Combining his passion for Microsoft SQL Server with his passion for sharing knowledge, he has spoken at various events in the SQL Community. This is also a way to give back to the community for all the things he has learned over the years. When not working, Johan Ludvig either spends his time with his kids, playing with new technology, or teaching coeliacs how to bake glutenfree food.

Neil Hambly

Twitter: - Neil_Hambly

LinkedIn: Neil Hambly

Contact: http://dataidol.com/NeilHambly

Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.

Marco Russo

Twitter: - marcorus

LinkedIn: Marco Russo

Contact: https://www.sqlbi.com/blog/marco

Marco is a Business Intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and SQLBits. He also enjoys delivering evening sessions at local user groups during his trips.

Joe Chang

Contact: http://sqlblog.com/blogs/joe_chang/default.aspx

Belkis Ozhorasan


Cathrine Wilhelmsen

Twitter: - @cathrinew

LinkedIn: Cathrine Wilhelmsen

Contact: https://www.cathrinewilhelmsen.net/

Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.

Bob Duffy

Twitter: - @bob_duffy

LinkedIn: Bob Duffy

Contact: http://blogs.prodata.ie/author/bob.aspx

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.

Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.

Sergey Olontsev

Twitter: - SergeyOlontsev

LinkedIn: Sergey Olontsev

Contact: http://SergeyOlontsev.com/

I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions . I’m a regular speaker at SQL Server user group meetings, SQLSaturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

Kalen Delaney

Twitter: - sqlqueen

Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.

Henk van der Valk

LinkedIn: Henk van der Valk

Contact: http://www.henkvandervalk.com

Since 2000 Henk has specialized in optimizing large-scale Microsoft application and database solutions. He’s been authoring and contributing numerous whitepapers around SQL Server performance tuning and also produced the famous ETL Data loading World Record with SSIS.
About a year ago, Henk left Microsoft and co-founded a new company: SQLMasters BV and dedicates his time since in developing cool SQL Estate data management solutions and full stack performance tuning.
During his presentations he usually dives into the real-world performance challenges @customer sites and shares tips that will make you job easier!

Margarita Naumova

LinkedIn: Margarita Naumova

Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/

Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.

Erik Flateby

LinkedIn: Erik Flateby

Erik Flateby is Data Platform Solution Architect with Microsoft Norway. Before that he was an independent BI consultant and founder of Acuit A/S. Holding an MCSE:BI certification and having used SQL Server since version 2000 his area of expertise is ETL, data warehousing and reporting. He is also a Microsoft Certified Trainer. Outside of work he enjoys sci-fi and the great outdoors surrounding Oslo.

Boris Hristov

Twitter: - https://twitter.com/BorisHristov

LinkedIn: Boris Hristov

Contact: http://borishristov.com/blog/

Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.

Tim Ford

Twitter: - @SQLAgentMan

LinkedIn: Tim Ford

Contact: http://thesqlagentman.com

Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.

**Kaisa Lervik **

Kaisa Lervik is a manager in the Data and Analytics service line in Avanade Norway AS. She has worked with Microsoft BI tools for 10 years and love learning about new features.

André Kamman

Contact: http://andrekamman.com

André is a freelance SQL Server specialist. In previous roles he’s done a lot of DBA work on 100’s of servers where he discovered his love for Powershell and automating processes in general. Today the better part of his day he’s building and tuning ETL processes. André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Rally Amsterdam and SQLSaturday Holland

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

Contact: http://sqlvariant.com/

Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.

Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.

Regis Baccaro

Twitter: - @regbac

LinkedIn: Regis Baccaro

Contact: http://theblobfarm.wordpress.com

Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.

Mikael Wedham

Twitter: - @wedham

Contact: http://www.wedham.com

Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page