SQLSaturday #532 - Oslo 2016

Event Date: 09/03/2016 00:00:00

Event Location:

Noroff
Mølleparken 4
Oslo, Oslo, Norway

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

Sessions
Speakers
Sponsors

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).

Sessions

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

Title: Data Science and Machine Learning with Azure - Experiences from the field

Abstract: Data Science is becoming an increasingly accessible discipline, and Microsoft Azure has several powerful, intuitive tools for doing everything from Big Data processing to Machine Learning. While the democratization of advanced analytical techniques is undeniably one of the biggest leaps within Business Intelligence in recent times, it calls for us as analysts to add a few new tools to our belts and expand our skillsets into the uncharted territories of advanced mathematics and statistics.

This sounds scary and initimidating, but it really isn’t. We’re going to prove this by sharing experiences, useful takeaways and practical guidelines we’ve established from working with Machine Learning and Data Science in Capgemini for clients within healthcare, public transport and retail, as well as in our spare time. We talk about Azure ML, Spark, R and Python, and most importantly; we cover the Data Science workflow itself and how to actually answer questions with data and analytical models.

Speaker(s):

Kjetil Åmdal-Sævik

Track and Room: BI Analytics and Visualization - Smil

Title: Algorithms For Searching Through Encrypted Data

Abstract: Proper way of storing encrypted data is to encrypt it on the client and send it to the server that doesn’t know how to decrypt it. However this solution lacks a simple way of searching through the encrypted data once it’s on the server. You can do equality checks, but that’s where most applications stop. But what to do if you have thousands of text documents you need to search through? Getting them all to the client and decrypting them there is simply out of the question as it would slow the system down to a crawl due to latency. In this session we’ll take a look at a few algorithms that enable you to search through the encrypted text data on the server without decrypting anything and returning only the search results to the client with performance in mind. Just the way a search should be performed.

Speaker(s):

Mladen Prajdić

Track and Room: Database Development - Melkesjokolade

Title: SQL Server High Availability for Virtualized and Cloud Deployments

Abstract: Virtualization and Cloud providers are providing greater and greater levels of abstraction from the hardware we run our SQL Servers on. But with this agility, ease of deployment and versatility comes a disconnect. This disconnect between what you, as the Data Platform Engineer, are trying to achieve and those handling the physical resources that your systems run on. If you don’t reconnect, understanding how your Failover Cluster Instances, Availability Groups etc. interoperate with the virtual world. Then you can have a recipe for disaster.

In this session I will help you understand some of the main issues that can arise. Issues that bring the technology components into conflict, compromising the availability of your systems. Looking at ways that you can identify, solve and prevent these from happening again. Along with looking at some simple design patterns that you can apply in order to ensure that your systems are truly Highly Available.

Speaker(s):

John Martin

Track and Room: Azure and Cloud Services - Smil

Title: Dive into SSIS Catalog and SSISDB using PowerBI

Abstract: If you have worked with SQL Server Integration Services (SSIS) 2012 or above for few years then you already familiar with SSIS Catalog reports. SSISDB Catalog reports - help us to monitor projects, which you have deployed to the server. By using these reports, we can quickly find information related to executions, logging and other interesting things with few mouse clicks. However, have you ever wondered how to design an SSIS Project so we can take maximum benefit of SSISDB Catalog? How to troubleshoot SSIS Project executions from the Catalog? How to navigate your way around the built-in catalog reports? How to design a dashboard with SSIDB Catalog data? This session will focus on these scenarios by diving into SSISDB catalog views using PowerBI.

Speaker(s):

Prathy Kamasani

Track and Room: BI Architecture and Development - Bamsemums

Title: Re-architecting your old-school database to maximize Azure cloud options

Abstract: The quickest way to migrate your on-premises OLTP database to Azure is to simply “Lift Shift”. You create a vm in Azure and size it to match your local system and move your database into it. This might not be the most cost effective way though and also, you still have to do all the database maintenance yourself. In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc. in order to truly scale our system. And we’ll see if this increases or lowers the total cost of ownership. This excercise is about an OLTP system but we will also look at how it affects loading our DWH from this new setup.

Speaker(s):

André Kamman

Track and Room: Azure and Cloud Services - Troika

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Abstract: Foreign key constraints are the ultimate Catch-22. They are necessary to ensure the relationship integrity between a parent table and its child tables. However, they may also have a significant downside effect on insert, update, and delete performance. In this session we will describe the concept of Foreign Key constraints and how they maintain data integrity when properly maintained. You will learn their syntax for creating, deleting, disabling, and re-enabling them. You will also learn the possible side effects of disabling and re-enabling Foreign Keys for data modification. We will examine the two most important Foreign Key attributes: is_not_trusted and is_disabled and their effect on query performance. All of these characteristics will be demonstrated with many script examples. Attendees should have some knowledge of Management Studio and the SELECT statement.

Speaker(s):

Mike Byrd

Track and Room: Database Development - Troika

Title: Dimensional Modeling Design Patterns: Beyond the Basics

Abstract: Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements. In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.

Speaker(s):

Jason Horner

Track and Room: BI Architecture and Development - Seigmenn

Title: Level Up Your Biml: Best Practices and Coding Techniques

Abstract: Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance!

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code with include files and the CallBimlScript method. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.

Start improving your code today and level up your Biml in no time!

Speaker(s):

Cathrine Wilhelmsen

Track and Room: BI Architecture and Development - Smil

Title: You don’t need Enterprise Edition to do that!

Abstract: The most coveted features of SQL Server are made available in Enterprise Edition and are sometimes released into Standard Edition a few years later. This often leaves a vast group of users who “window shop” the latest and greatest features and return to the office wishing they never saw those features presented.

This session will show you how you can achieve the same, or at least a similar, outcome to some of those features without having to fork out for Enterprise Edition licenses or breaking any license agreements.

You will leave the session with a set of solution concepts covering Partitioning, Data Compression and High Availability that you can build upon or extend and maybe save you and your company a nice pile of cash.

Speaker(s):

William Durkin

Track and Room: Database Administration - Smil

Title: The Query Store and Query Tuning in SQL Server

Abstract: For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store. This session will explore how the Query Store works and how it’s going to change how you tune and troubleshoot performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need to apply it to your own SQL Server 2016 tuning efforts as well as your Azure SQL Databases.

Speaker(s):

Grant Fritchey

Track and Room: Database Administration - Bamsemums

Title: SSIS: Supercharge your data flows

Abstract: SSIS is an awesome ETL tool and can perform incredibly fast, when used right. Understanding more about how it works can help you make the best design decisions to maximize performance.

In this session we’ll look at some of the internals of the data flow pipeline, as well as a number of tips tricks to supercharge your SSIS life.

We will also look at some simple c# workarounds to common SSIS bottlenecks.

Speaker(s):

Alex Whittles

Track and Room: BI Architecture and Development - Melkesjokolade

Title: Branding Yourself for a Dream Job

Abstract: Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

Speaker(s):

Steve Jones

Track and Room: Other - Seigmenn

Title: Old Dog, New tricks: Swiss Army Tool for Big Data Zoo survival

Abstract: The Big Data Landscape has hundreds of suppliers and technologies. Adopting the Big Data Zoo is a daunting task for most, and building the new skills to utilize them can seem like an overwhelming task. SQL Server 2016 provides new tools to overcome these issues using existing skillsets.

Speaker: Are Skaar, NextBridge

Speaker(s):

SQLSaturday Oslo Sponsor

Track and Room: Other - Troika

Title: EVRY - How is it to be recent graduated and new in our company?

Abstract: EVRY Young Professionals will talk about how it is to be recent graduated and new in their company. What to expect, how you can develop your skills, and all the possibilities you have in their company. EVRY is today Norway’s biggest IT company with over 9000 employees. Delivering all kind of IT solutions to customers all over the world.

Class will be in Norwegian.

Speaker: Andreas Rød-Løkkevol, EVRY

Speaker(s):

SQLSaturday Oslo Sponsor

Track and Room: Other - Bamsemums

Title: Introducing R and Using R in MS BI Suite

Abstract: R is a free software programming language and software environment for statistical computing, data mining, machine learning, and graphics. Microsoft started to support R intensively in the BI suite. You can use R inside SQL Server, in Power BI, in SSIS Execute SQL task, and more. Azure ML in the Microsoft cloud service and environment for advanced data analysis that utilizes the R algorithms intensively. This session introduces R and shows how you can use it in the MS BI suite.

Speaker(s):

Dejan Sarka

Track and Room: BI Analytics and Visualization - Seigmenn

Title: Becoming the Data Platform Engineer of Tomorrow

Abstract: You’re a DBA/Dev/BI Professional (delete as appropriate), what will your role be like in five years time? In this session we will talk about how the industry has changed over the last couple of years and hypothesize on where it is going and the type of work we might be doing and technologies that we will be dealing with.

Will the traditional developer, BI and DBA roles that we know so well today be the same, or will we need to diversify and look at expanding into other areas to stay ahead of the curve?

Speaker(s):

John Martin

Track and Room: Other - Troika

Title: SQL Server 2016 - is it worth the upgrade?

Abstract: Microsoft has shortened their release life-cycle recently, causing many companies to skip versions when there were no compelling features in them. So how does SQL Server 2016 look? This session will give you a heads-up on the newest features and improvements that are newly available in SQL Server 2016. At then end of the hour, you will have identified which new features you can’t live without and which you can happily wait until SQL Server vNext for.

Speaker(s):

William Durkin

Track and Room: Database Administration - Seigmenn

Title: Continuous Integration for Databases

Abstract: Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.

Speaker(s):

Steve Jones

Track and Room: Database Development - Bamsemums

Title: Predictive maintenance in aerospace with Cortana Intelligence Suite

Abstract: A lot of machine learning projects these days centers around predictive maintenance. This session will provide a deep-dive technical walk-through of the reference architecture described in the Cortana Intelligence Solution Template for predictive maintenance in aerospace. We will have a technical and demo-heavy look at the different parts making up the solution. A few common business scenarios will also be mentioned, but not discussed at length. Some familiarity with machine learning in general and the services in Cortana Intelligence suite is assumed.

Speaker(s):

Erik Flateby

Track and Room: BI Analytics and Visualization - Bamsemums

Title: Improve Data Quality: BI Value through Master Data Management

Abstract: Today’s Business Intelligence (BI) systems are increasingly seen as mission critical, but their value is only as good as the quality of data they contain. Learn how you can use Microsoft SQL Server Master Data Services and Profisee’s Master Data Maestro to ensure data quality and improve BI value.

Speaker: Denzil Murray-Lee, Profisee

Speaker(s):

SQLSaturday Oslo Sponsor

Track and Room: Other - Seigmenn

Title: Scripting Tabular Models

Abstract: Introducing the new scripting language for tabular models. Before SQL Server 2016 tabular models was wrapped into a multidimensional constructs. TMSL is the new native language for tabular which is build on JSON - this makes it easy to understand, modify and deploy.

During this session I will go through and explain some examples on generating a SSAS tabular model by using the new TSML to demonstrate how powerfull this feature is and how you can use it to save time and effort.

Speaker(s):

Bent Pedersen

Track and Room: BI Analytics and Visualization - Troika

Title: Can Power BI Replace SSRS and should you

Abstract: In this session I will take you through the differences between what you can do in SSRS and the features of Power BI. Power BI is moving very fast in features but SSRS still has features that Power BI doesn’t support - on the other hand - the speed of developing reports and dashboard in Power BI is very attractive - so when should you pick the one over the other. I will cover available data sources, report- and dashboard design, how to filter and how can you publish the reports / dashboards in the two tools.

Speaker(s):

Erik Svensen

Track and Room: BI Analytics and Visualization - Melkesjokolade

Title: Azure SQL Database for the DBA

Abstract: Everyone knows that Azure SQL Database only supports a small subset of SQL Server functionality, small databases, and has really bad performance. Except, everyone is wrong. In fact, Azure SQL Server Database is ready to support many, if not most, databases within your enterprise. This session reintroduces Azure SQL Database and shows the high degree of functionality and improved performance that is now available. You’ll leave this session with a more thorough understanding of the strengths and weaknesses of Azure SQL Database so that you can make a more informed choice over when or if you should use it within your environment.

Speaker(s):

Grant Fritchey

Track and Room: Azure and Cloud Services - Seigmenn

Title: Entity Framework, from a database perspective

Abstract: Entity Framework enables developers interact with databases through a logical model with entities and methods and such, and by default generate CRUD-operation and translates them to SELECT, INSERT, UPDATE and DELETE. The session is about this and how we can extend the logical model with access objects within the database to support this interaction, and by that enable for performance optimization and higher levels of security without the need of changing a single bit of code in the application layers. The session is a bit like eating the cake and still have it left.

Speaker(s):

Mattias Lind

Track and Room: Database Development - Smil

Abstract: “It is much easier to trick someone into giving a password for a system than to spend the effort to crack into the system.” This is a common line of thought in today’s world of increased cyber-security dangers. In this interactive session we’ll take a look at how social engineering works, the psychology behind it and why is it still the most effective way to gain access to your company’s secrets. The best attacks happen when people don’t even realize they are being attacked and in this session we’re going to try to fix that and educate you on how to realize when someone is trying to hack you.

Speaker(s):

Mladen Prajdić

Track and Room: Other - Melkesjokolade

Title: Working with the Azure Data Lake for modern BI architecture

Abstract: I will describe the basics of the Azure Data Lake and how it’s been put to use with other Azure services in the Cortana Intelligence Suite. This will cover Data Lake Store, Data Lake Analytics, SQL Warehouse, Data Factory, Excel and PowerBI and how these services fit in a modern BI architecture.

Speaker(s):

Helge Rege Gårdsvoll

Track and Room: Azure and Cloud Services - Bamsemums

Title: SQL Server and PowerShell: Let’s Get Serious

Abstract: Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you’re a DBA, a SSIS developer, or security professional, In this session you’ll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.

Speaker(s):

Drew Furgiuele

Track and Room: Database Administration - Melkesjokolade

Title: How to load your data faster and safer using Change Tracking in SQL Server

Abstract: Loading data into a data warehouse or a reporting database is maybe the most common task for BI professionals, something we do since the beginning.

It can start very simple, but get as complicated as one can imagine. Since SQL Server 2008, Microsoft has given us the tools to follow a structured approach for loading data. Join the session to see an introduction to Change Tracking and a demo on the data loading possibilities it has to offer.

Speaker(s):

Antonio Abalos Castillo

Track and Room: BI Architecture and Development - Troika

Speakers

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

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.

John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.

SQLSaturday Oslo Sponsor

Twitter: - @SQLSatOslo

Proudly sponsoring SQLSaturday Oslo. Please see session details for more information about the speaker.

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

André Kamman

Twitter: - @andrekamman

Contact: http://andrekamman.com

André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

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.

Antonio Abalos Castillo

Twitter: - @antonioabalos

LinkedIn: Antonio Abalos Castillo

Started as a humble .NET developer, now with several years of experience in the Microsoft Data Platform, mainly in the Azure cloud. My work involves designing and architecting Data and Analytics cloud solutions. Happy to share experiences and tales from the trenches :)

Kjetil Åmdal-Sævik

LinkedIn: Kjetil Åmdal-Sævik

Contact: http://www.kjetilamdal.com

“For an economist, you’re not so dumb,” I was once told by an engineer. I don’t think it’s possible to receive a better compliment than that. I am indeed an economist turned BI consultant turned data scientist, currently in charge of data science at Elkjøp Nordic. Data analysis and machine learning is both my job and my hobby, and my favourite tools of the trade are Python for programming, Azure for cloud services, and neural nets + boosting for modeling. When I’m not working or Kaggling, I like to cook and to spend time with my wife and little daughter.

Drew Furgiuele

Twitter: - pittfurg

LinkedIn: Drew Furgiuele

Contact: http://www.port1433.com

Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Mladen Prajdić

Twitter: - @MladenPrajdic

LinkedIn: Mladen Prajdić

Contact: http://weblogs.sqlteam.com/mladenp

Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing diﬀerent types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).

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.

Erik Svensen

Twitter: - @donsvensen

LinkedIn: Erik Svensen

Contact: http://eriksvensen.wordpress.com

Microsoft MVP - Dataplatform Leader of Denmark - Power BI Usergroup

Passionate about Power *, Excel , Analysis Services, Reporting Services.

CTO @CatManSolution - delivering a BI as service solution for suppliers to FMCG Retailers based on the Microsoft BI Stack

SQLSaturday Oslo Sponsor

Twitter: - @SQLSatOslo

Proudly sponsoring SQLSaturday Oslo. Please see session details for more information about the speaker.

William Durkin

Twitter: - @sql_williamd

LinkedIn: William Durkin

Contact: http://williamdurkin.com

William Durkin is a DBA, Data Platform MVP, and Data Platform Architect for Data Masterminds (http://datamasterminds.io). He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents, using a range of high availability solutions. William is a regular speaker at conferences around the globe, organizes the popular event SQLGrillen (http://sqlgrillen.com).

Bent Pedersen

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

LinkedIn: Bent Pedersen

Contact: http://www.biblog.eu

Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.

Prathy Kamasani

Twitter: - @pkamasani

LinkedIn: Prathy Kamasani

Contact: http://prathy.com/

Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London. She specialises in Power BI, SSIS, SSAS and SSRS. Prathy organisers London Power BI user group and co-organizes the London PASS Local Group. She is a regular speaker at events like SQLSaturday and local user groups.

William Durkin

Twitter: - @sql_williamd

LinkedIn: William Durkin

Contact: http://williamdurkin.com

Dejan Sarka

Twitter: - DejanSarka

Contact: http://blogs.solidq.com/dsarka/Home.aspx

Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

SQLSaturday Oslo Sponsor

Twitter: - @SQLSatOslo

Proudly sponsoring SQLSaturday Oslo. Please see session details for more information about the speaker.

Jason Horner

Twitter: - jasonhorner

LinkedIn: Jason Horner

Contact: http://blog.jasonhorner.com

Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.

I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games

Mladen Prajdić

Twitter: - @MladenPrajdic

LinkedIn: Mladen Prajdić

Contact: http://weblogs.sqlteam.com/mladenp

Helge Rege Gårdsvoll

Twitter: - dataHelge

Contact: https://www.datahelge.no

BI Architect at NHO and responsible for architecting and building data platform in Azure.

Mattias Lind

Twitter: - @soqool

Contact: http://blog.mssqlserver.se

A MCT and MVP on Data Platform, Senior Microsoft Data Platform amp; Business Intelligence Architect at Sogeti, speaker, blogger, cowboy, Mustang-lover, globetrotter who loves any data, any time, any how. Have been working with SQL Server since mid 90#39;s.

Alex Whittles

Twitter: - @PurpleFrogSys

LinkedIn: Alex Whittles

Contact: http://www.PurpleFrogSystems.com/blog

Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence.

He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK.

Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQLSaturdays as well as numerous SQL Pass chapters around Europe

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

SQLSaturday #532 - Oslo 2016

Sessions

Title: Data Science and Machine Learning with Azure - Experiences from the field

Title: Algorithms For Searching Through Encrypted Data

Title: SQL Server High Availability for Virtualized and Cloud Deployments

Title: Dive into SSIS Catalog and SSISDB using PowerBI

Title: Re-architecting your old-school database to maximize Azure cloud options

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Title: Dimensional Modeling Design Patterns: Beyond the Basics

Title: Level Up Your Biml: Best Practices and Coding Techniques

Title: You don’t need Enterprise Edition to do that!

Title: The Query Store and Query Tuning in SQL Server

Title: SSIS: Supercharge your data flows

Title: Branding Yourself for a Dream Job

Title: Old Dog, New tricks: Swiss Army Tool for Big Data Zoo survival

Title: EVRY - How is it to be recent graduated and new in our company?

Title: Introducing R and Using R in MS BI Suite

Title: Becoming the Data Platform Engineer of Tomorrow

Title: SQL Server 2016 - is it worth the upgrade?

Title: Continuous Integration for Databases

Title: Predictive maintenance in aerospace with Cortana Intelligence Suite

Title: Improve Data Quality: BI Value through Master Data Management

Title: Scripting Tabular Models

Title: Can Power BI Replace SSRS and should you

Title: Azure SQL Database for the DBA

Title: Entity Framework, from a database perspective

Title: Social Engineering: Hacking People

Title: Working with the Azure Data Lake for modern BI architecture

Title: SQL Server and PowerShell: Let’s Get Serious

Title: How to load your data faster and safer using Change Tracking in SQL Server

Speakers

Sponsors