sqlsathistory

Nr: 414

Back to Main list

SQLSaturday #414 - Oslo 2015

Start Time (24h) Speaker Track Title
09:00:00 Boris Hristov Database Administration Securing your SQL Azure Database. How?
09:00:00 Asgeir Gunnarsson BI Analytics Visualization End to end risk assessment – affordable solution using Power BI
09:00:00 Alex Whittles BI Architecture Development Data modeling for data analysis and cubes
09:00:00 Cédric Charlier BI Architecture Development Automating the testing of your BI solutions with NBi
09:00:00 André Melancia Database Development From rakfisk to lutefisk - Beginners guide to SQL Server
10:20:00 Gianluca Sartori Database Administration Responding to extended events in near real time
10:20:00 Bob Duffy BI Architecture Development Optimising Cube Processing
10:20:00 David Postlethwaite Database Administration Taming the Beast – How a SQL DBA can keep Kerberos under control
10:20:00 Andrey Zavadskiy Database Administration Transaction Log Internals and Troubleshooting
10:20:00 Harald Svandal Presthus BI Analytics Visualization Azure Machine Learning, notes from the field
11:40:00 Enrico van de Laar Database Development Efficient Indexing Strategies
11:40:00 John Martin Database Administration Availability Group Maintenance Operations
11:40:00 Martin Kraugerud BI Architecture Development Business Data Lakes - New architecture, and mindset, saves time and money
11:40:00 Steinar Andersen Database Administration SQL Server Magic Buttons: What are Trace Flags, and why should I care?
13:00:00 SQLSaturday Oslo Sponsor Lunch with Sponsors Capgemini: Azure Machine Learning by Kjetil #197;mdal
13:00:00 SQLSaturday Oslo Sponsor Lunch with Sponsors NextBridge: Rapid Fire Slowly Changing Dimensions by Are Skaar
13:00:00 SQLSaturday Oslo Sponsor Lunch with Sponsors Violin Memory: In-Memory or Violin Memory by Jens Melhede
14:00:00 Johan Ludvig Brattås BI Architecture Development Performance tuning a PowerPivot and Tabular model, notes from the field
14:00:00 Matan Yungman Database Development The Data Loading Performance Presentation
14:00:00 Margarita Naumova Database Administration A deep dive into SQL Server Plan Cache Management
14:00:00 Erik Flateby BI Analytics Visualization An introduction to Datazen
14:00:00 William Durkin Database Administration Stories from the Trenches: Upgrading SQL with Minimal Downtime
15:20:00 Marco Russo BI Architecture Development What’s new in DAX 2015
15:20:00 Rob Volk Database Administration Revenge: The SQL! - Director's Cut
15:20:00 Uwe Ricken Database Development INSERT / UPDATE / DELETE - deep dive
15:20:00 Terry McCann BI Analytics Visualization SSRS Inception: Reporting on Reporting services.
15:20:00 André Kamman Database Administration Build your own Monitoring Environment with Powershell

SessionID: 10975

Securing your SQL Azure Database. How?

Back to calendar

Event Date: 29-08-2015 - Session time: 09:00:00 - Track: Database Administration

Speaker: Boris Hristov

Title: Securing your SQL Azure Database. How?

Abstract:

Do you think that your data is not secured in the cloud? Is that one of the reasons for you to not migrate at least some workloads there? Things changed in the last few months in terms of Azure database security. In this session we will take a closer look at what the features Row Level Security(RLS) and Dynamic Data Masking can do for your business and how they can help you secure your data.

SessionID: 36065

End to end risk assessment – affordable solution using Power BI

Back to calendar

Event Date: 29-08-2015 - Session time: 09:00:00 - Track: BI Analytics Visualization

Speaker: Asgeir Gunnarsson

Title: End to end risk assessment – affordable solution using Power BI

Abstract:

Risk assessment is becoming an integral part of many organizations. In order to do it successfully you need to do it regularly and consistently. You need to register the risk factors, the risks them self, evaluate them and then plan the actions required to mitigate them. Besides the registration you need to have compelling and easy reading reports that help managers quickly find how the assessment is going. The familiar Excel interface helps assessors register the risk factors and risks and then plan the actions. The solutions then uses Power Query to load data into PowerPivot without overwriting and the Power View to report the results. The results can then be monitored in Power BI.

This method can easily transfer to any other data collection solution such as budgeting or incident registration

SessionID: 36669

Data modeling for data analysis and cubes

Back to calendar

Event Date: 29-08-2015 - Session time: 09:00:00 - Track: BI Architecture Development

Speaker: Alex Whittles

Title: Data modeling for data analysis and cubes

Abstract:

Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports.

In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimize it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.

SessionID: 36839

Automating the testing of your BI solutions with NBi

Back to calendar

Event Date: 29-08-2015 - Session time: 09:00:00 - Track: BI Architecture Development

Speaker: Cédric Charlier

Title: Automating the testing of your BI solutions with NBi

Abstract:

If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (nbi.codeplex.com). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources.

SessionID: 37749

From rakfisk to lutefisk - Beginners guide to SQL Server

Back to calendar

Event Date: 29-08-2015 - Session time: 09:00:00 - Track: Database Development

Speaker: André Melancia

Title: From rakfisk to lutefisk - Beginners guide to SQL Server

Abstract:

Never used SQL Server?

Do you know a little SQL (from MariaDB/MySQL, PostgreSQL, etc.)? Do you have newbie questions about SQL Server that you're too ashamed to ask? Here's your chance to learn all you need to know about SQL Server. Session suited for developers and students (beginner level).

SessionID: 14612

Responding to extended events in near real time

Back to calendar

Event Date: 29-08-2015 - Session time: 10:20:00 - Track: Database Administration

Speaker: Gianluca Sartori

Title: Responding to extended events in near real time

Abstract:

Extended events are really useful for gathering information not available otherwise. However, compared to other technologies such as trace and event notifications, it seems to be lacking a way to react to the events as soon as they happen. In this session we will see how this is possible using the APIs and which new possibilities this approach enables.

SessionID: 36979

Optimising Cube Processing

Back to calendar

Event Date: 29-08-2015 - Session time: 10:20:00 - Track: BI Architecture Development

Speaker: Bob Duffy

Title: Optimising Cube Processing

Abstract:

Ever wondered what actually happens when a cube is “processed”, why it takes so long, how you can configure and optimise cube

processing, or what strategies people commonly use for improving processing?

This session provides a deep dive into cube processing for MOLAP, to help understand how it works and what you can do to work with it.

Come to this session for a better understanding of how to configure, optimise and tune cube processing.

Included in the session is case studies from our performance lab and some sample tools to analyse processing logs.

SessionID: 37188

Taming the Beast – How a SQL DBA can keep Kerberos under control

Back to calendar

Event Date: 29-08-2015 - Session time: 10:20:00 - Track: Database Administration

Speaker: David Postlethwaite

Title: Taming the Beast – How a SQL DBA can keep Kerberos under control

Abstract:

The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators.

What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works

SessionID: 37509

Transaction Log Internals and Troubleshooting

Back to calendar

Event Date: 29-08-2015 - Session time: 10:20:00 - Track: Database Administration

Speaker: Andrey Zavadskiy

Title: Transaction Log Internals and Troubleshooting

Abstract:

In this session we'll go through the internals of SQL Server transaction log, its logical and physical architecture and the internal processes of transaction logging. You'll see how poorly managed transaction log can negatively impact the overall performance of database server.

We examine the common issues such as full transaction log, how to get rid of multiple log files and shrink the log file, and solve the log fragmentation problem. Also we take a glance at new features of SQL Server 2014 for transaction log management.

SessionID: 39597

Azure Machine Learning, notes from the field

Back to calendar

Event Date: 29-08-2015 - Session time: 10:20:00 - Track: BI Analytics Visualization

Speaker: Harald Svandal Presthus

Title: Azure Machine Learning, notes from the field

Abstract:

Machine learning makes it possible to analyse large amounts of data, and it opens the doors to new insight, operational efficiency, direct marketing and the ability to make qualified decisions about the future. The machine learning technology has been known for years, and now it's finally available, and easy to use, for everyone.

Come to my session to get an overview of the possibilities Azure Machine Learning enables, and to learn from some of the experience I've obtained working with different machine learning projects. As this is an intermediate session, we will be looking closer at some of the machine learning algorithms.

SessionID: 13813

Efficient Indexing Strategies

Back to calendar

Event Date: 29-08-2015 - Session time: 11:40:00 - Track: Database Development

Speaker: Enrico van de Laar

Title: Efficient Indexing Strategies

Abstract:

Indexes are incredibly powerful objects to optimize your database performance. However, when not implemented optimally, indexes can also have a negative impact on your queries! In this session we will take a close look at the different index types, how they work and how we can use that knowledge to design an efficient indexing strategy for your databases. We will also spend time analyzing existing indexes. Are those indexes being used? Can we combine indexes? Those are some of the questions you will learn to answer in this session.

SessionID: 17299

Availability Group Maintenance Operations

Back to calendar

Event Date: 29-08-2015 - Session time: 11:40:00 - Track: Database Administration

Speaker: John Martin

Title: Availability Group Maintenance Operations

Abstract:

AlwaysOn Availability Groups provide an excellent way to build a High Availability platform with SQL Server at its core, however with these new capabilities come new and interesting maintenance requirements. In this session we will look at a number of the things you must do when making use of Availability Groups, and some of the things that you can do in order to ensure that you have a stable, reliable platform.

SessionID: 37187

Business Data Lakes - New architecture, and mindset, saves time and money

Back to calendar

Event Date: 29-08-2015 - Session time: 11:40:00 - Track: BI Architecture Development

Speaker: Martin Kraugerud

Title: Business Data Lakes - New architecture, and mindset, saves time and money

Abstract:

Business Data Lakes - New architecture (and mindset) saves time and money

How to support the business in their need for better analysis and create a modern architecture that accommodate for faster time to market, give true support to the business needs at the same time as it reduce cost. Imaging that you can give the business what they want in days rather than months!

SessionID: 39624

SQL Server Magic Buttons: What are Trace Flags, and why should I care?

Back to calendar

Event Date: 29-08-2015 - Session time: 11:40:00 - Track: Database Administration

Speaker: Steinar Andersen

Title: SQL Server Magic Buttons: What are Trace Flags, and why should I care?

Abstract:

You have probably heard about SQL Server Trace Flags, but there are so many of them! Do you really need them? Is it safe to use them? What are they for? Is it worth spending time researching them and documenting them online? That's what I did anyway.

In this session you will get a good overview of what Trace Flags can do for you, the risks and benefits, and how you should approach bringing them in to your production environment. Then of course there will be a deep dive in to some of the most useful and interesting ones. Since there is a lot more information to this subject than can be covered in one hour, there will be an extensive list of online resources included.

SessionID: 40292

Capgemini: Azure Machine Learning by Kjetil #197;mdal

Back to calendar

Event Date: 29-08-2015 - Session time: 13:00:00 - Track: Lunch with Sponsors

Speaker: SQLSaturday Oslo Sponsor

Title: Capgemini: Azure Machine Learning by Kjetil #197;mdal

Abstract:

Azure Machine Learning

SessionID: 40293

NextBridge: Rapid Fire Slowly Changing Dimensions by Are Skaar

Back to calendar

Event Date: 29-08-2015 - Session time: 13:00:00 - Track: Lunch with Sponsors

Speaker: SQLSaturday Oslo Sponsor

Title: NextBridge: Rapid Fire Slowly Changing Dimensions by Are Skaar

Abstract:

Denne sesjonen tar for seg utfordringer rundt historikk-h#229;ndtering av data.

SSIS blir ofte slaktet i evalueringskriterier for ytelse, kompatibilitet og konfigurasjonsmuligheter n#229;r det gjelder denne viktige funksjonaliteten i et ETL verkt#248;y. I denne sesjonen vil vi vise at dette i h#248;yeste grad er basert p#229; foreldet og uriktig informasjon.

o Slowly changing dimensions o Relational (hybrid Kimball/Inmon models)

SessionID: 40294

Violin Memory: In-Memory or Violin Memory by Jens Melhede

Back to calendar

Event Date: 29-08-2015 - Session time: 13:00:00 - Track: Lunch with Sponsors

Speaker: SQLSaturday Oslo Sponsor

Title: Violin Memory: In-Memory or Violin Memory by Jens Melhede

Abstract:

In-Memory or Violin Memory by Jens Melhede

SessionID: 17143

Performance tuning a PowerPivot and Tabular model, notes from the field

Back to calendar

Event Date: 29-08-2015 - Session time: 14:00:00 - Track: BI Architecture Development

Speaker: Johan Ludvig Brattås

Title: Performance tuning a PowerPivot and Tabular model, notes from the field

Abstract:

In-memory means blazingly fast, at least most of the time.

But modeling for the xVelocity/Vertipaq engine is a completely different beast than modeling for your trusty multi-dimensional SSAS cubes.

Join me on a session of improving a malfunctioning PowerBI Excel sheet and pick up handy tips and tricks you will need to tune your xVelocity models.

SessionID: 36082

The Data Loading Performance Presentation

Back to calendar

Event Date: 29-08-2015 - Session time: 14:00:00 - Track: Database Development

Speaker: Matan Yungman

Title: The Data Loading Performance Presentation

Abstract:

Loading huge amounts of data into SQL Server can be a challenging task. When doing it, there are quite a few factors that can help or hurt you.

For that, Microsoft has published a famous whitepaper called "The Data Loading Performance Guide". The problem is that it's long and full of small details, and we're too lazy to read it.

On this session, we will turn the whitepaper into a presentation and talk about the ways you can optimize your massive data loading processes by applying the techniques mentioned in the whitepaper, as well as other advanced techniques that have emerged since the whitepaper was published.

Among other topics, we will talk about the #1 enemy of high performance data loading, Minimal Logging and Bulk Load, indexing techniques, properly leveraging parallelism and partitioning, SQL Server 2014 Delayed Durability, and more.

SessionID: 36188

A deep dive into SQL Server Plan Cache Management

Back to calendar

Event Date: 29-08-2015 - Session time: 14:00:00 - Track: Database Administration

Speaker: Margarita Naumova

Title: A deep dive into SQL Server Plan Cache Management

Abstract:

As an experienced DBA you have probably asked yourself questions like how the memory is consumed, is my system well-tuned, and is my memory configuration well defined. In order to understanding such processes as local and global Memory pressure, caches concurrency, adding and removing plans from cache we will go through the internal organization of the plan cache, the metadata available, how SQL Server finds a plan in cache, plan cache sizing, and the plan eviction policy. We will point out the important cache consumers that affect your workload and how to get metadata about them, what are the thresholds in Cache Size Management. At the end you will understand how to monitor the memory consumers in your SQL Server, what are wait types that we need to look for, how to understand if your system is well-tuned and the memory configuration is well defined. You will have a clear understanding of cache plan problems and how to avoid them.

SessionID: 37718

An introduction to Datazen

Back to calendar

Event Date: 29-08-2015 - Session time: 14:00:00 - Track: BI Analytics Visualization

Speaker: Erik Flateby

Title: An introduction to Datazen

Abstract:

With Microsofts recent aquisition of mobile analytics problems Datazen and subsequent free release for all enterprise customers, this mobile analytics tool is destined to soon become a must-know for any SQL Server BI professional. This session will, through a lot of demos, cover the basics; what the product is, when to use it, it's strengths and limitations, and how you can start

creating your own impressive dashboards for mobile devices right away.

SessionID: 37740

Stories from the Trenches: Upgrading SQL with Minimal Downtime

Back to calendar

Event Date: 29-08-2015 - Session time: 14:00:00 - Track: Database Administration

Speaker: William Durkin

Title: Stories from the Trenches: Upgrading SQL with Minimal Downtime

Abstract:

SQL Server has come a long way in the last few years, with Microsoft investing heavily in High Availability features. This session will show you how to use these features to enable you to safely upgrade a SQL Server, while ensuring you have a return path if things should go wrong. You will leave the session knowing what features you can use to upgrade either the OS, Hardware or SQL Server version while keeping your maintenance window to a minimum. The session will apply to Standard Edition as well as Enterprise Edition, so doesn't only apply to "High Rollers"!

SessionID: 19488

What’s new in DAX 2015

Back to calendar

Event Date: 29-08-2015 - Session time: 15:20:00 - Track: BI Architecture Development

Speaker: Marco Russo

Title: What’s new in DAX 2015

Abstract:

Power BI Designer is the first tool that introduced new features in DAX, which will be available in future versions of Analysis Services and Power Pivot for Excel. In this session, you will see the new DAX functions introduced in 2015. You will learn new aggregation and statistical functions, new ways to filter and manipulate tables, and new optimized techniques to query data with a table expression. These new functions, plus updates in DAX syntax, makes DAX easier to read and improve its performance, too.

SessionID: 23330

Revenge: The SQL! - Director's Cut

Back to calendar

Event Date: 29-08-2015 - Session time: 15:20:00 - Track: Database Administration

Speaker: Rob Volk

Title: Revenge: The SQL! - Director's Cut

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 27309

INSERT / UPDATE / DELETE - deep dive

Back to calendar

Event Date: 29-08-2015 - Session time: 15:20:00 - Track: Database Development

Speaker: Uwe Ricken

Title: INSERT / UPDATE / DELETE - deep dive

Abstract:

DML is used in most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level.After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated.SEE, what a workload will be caused by a "forwarded record". What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes

SessionID: 37200

SSRS Inception: Reporting on Reporting services.

Back to calendar

Event Date: 29-08-2015 - Session time: 15:20:00 - Track: BI Analytics Visualization

Speaker: Terry McCann

Title: SSRS Inception: Reporting on Reporting services.

Abstract:

Still using Reporting Services? Yeah me too! Does this scenario sound familiar? You already have a large SSRS environment but the users still want more reports. You create a new, all singing, all dancing dashboard that removes the need for a bunch of reports, awesome. You launch it and explain to the business that you are deprecating the old reports. "WAIT! We still need that for Jill in HR to do her end-of-month", or "We might still need that" - these types of comments are what leads to having a load of reports that are not being used.

Wouldn't it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn't it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.

SessionID: 37699

Build your own Monitoring Environment with Powershell

Back to calendar

Event Date: 29-08-2015 - Session time: 15:20:00 - Track: Database Administration

Speaker: André Kamman

Title: Build your own Monitoring Environment with Powershell

Abstract:

Let's build a Powershell script together that will use Remoting to run whatever script you like in parallel on any number of servers. We'll talk about remoting, remoting across domains or even without, how to run scripts in the background and in parallel. I'll show you how to store the results and report on it across all your servers in one go.

This site is open source. Improve this page.