Nr: 532
SQLSaturday #532 - Oslo 2016
SessionID: 49295
The Query Store and Query Tuning in SQL Server
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: Database Administration
Speaker: Grant Fritchey
Title: The Query Store and Query Tuning in SQL Server
Abstract:
SessionID: 49357
Entity Framework, from a database perspective
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: Database Development
Speaker: Mattias Lind
Title: Entity Framework, from a database perspective
Abstract:
SessionID: 50068
Branding Yourself for a Dream Job
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: Other
Speaker: Steve Jones
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.
SessionID: 50791
Can Power BI Replace SSRS and should you
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: BI Analytics and Visualization
Speaker: Erik Svensen
Title: Can Power BI Replace SSRS and should you
Abstract:
SessionID: 51026
How to load your data faster and safer using Change Tracking in SQL Server
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: BI Architecture and Development
Speaker: Antonio Abalos Castillo
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.
SessionID: 48538
SQL Server and PowerShell: Let's Get Serious
Event Date: 03-09-2016 - Session time: 10:20:00 - Track: Database Administration
Speaker: Drew Furgiuele
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.
SessionID: 48679
SQL Server High Availability for Virtualized and Cloud Deployments
Event Date: 03-09-2016 - Session time: 10:20:00 - Track: Azure and Cloud Services
Speaker: John Martin
Title: SQL Server High Availability for Virtualized and Cloud Deployments
Abstract:
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.
SessionID: 49731
Dimensional Modeling Design Patterns: Beyond the Basics
Event Date: 03-09-2016 - Session time: 10:20:00 - Track: BI Architecture and Development
Speaker: Jason Horner
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.
SessionID: 50295
SQL Server Foreign Keys – De-mystifying the Rest of the Story
Event Date: 03-09-2016 - Session time: 10:20:00 - Track: Database Development
Speaker: Mike Byrd
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.
SessionID: 50956
Predictive maintenance in aerospace with Cortana Intelligence Suite
Event Date: 03-09-2016 - Session time: 10:20:00 - Track: BI Analytics and Visualization
Speaker: Erik Flateby
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.
SessionID: 47523
Data Science and Machine Learning with Azure - Experiences from the field
Event Date: 03-09-2016 - Session time: 11:40:00 - Track: BI Analytics and Visualization
Speaker: Kjetil Åmdal-Sævik
Title: Data Science and Machine Learning with Azure - Experiences from the field
Abstract:
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.
SessionID: 48107
Social Engineering: Hacking People
Event Date: 03-09-2016 - Session time: 11:40:00 - Track: Other
Speaker: Mladen Prajdić
Title: Social Engineering: Hacking People
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.
SessionID: 48472
Dive into SSIS Catalog and SSISDB using PowerBI
Event Date: 03-09-2016 - Session time: 11:40:00 - Track: BI Architecture and Development
Speaker: Prathy Kamasani
Title: Dive into SSIS Catalog and SSISDB using PowerBI
Abstract:
SessionID: 49177
Re-architecting your old-school database to maximize Azure cloud options
Event Date: 03-09-2016 - Session time: 11:40:00 - Track: Azure and Cloud Services
Speaker: André Kamman
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.
SessionID: 51066
SQL Server 2016 - is it worth the upgrade?
Event Date: 03-09-2016 - Session time: 11:40:00 - Track: Database Administration
Speaker: William Durkin
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.
SessionID: 53930
Improve Data Quality: BI Value through Master Data Management
Event Date: 03-09-2016 - Session time: 13:00:00 - Track: Other
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
SessionID: 54023
EVRY - How is it to be recent graduated and new in our company?
Event Date: 03-09-2016 - Session time: 13:00:00 - Track: Other
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
SessionID: 54075
Event Date: 03-09-2016 - Session time: 13:00:00 - Track: Other
Abstract:
Speaker: Are Skaar, NextBridge
SessionID: 47017
Scripting Tabular Models
Event Date: 03-09-2016 - Session time: 14:00:00 - Track: BI Analytics and Visualization
Speaker: Bent Pedersen
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.
SessionID: 49294
Azure SQL Database for the DBA
Event Date: 03-09-2016 - Session time: 14:00:00 - Track: Azure and Cloud Services
Speaker: Grant Fritchey
Title: Azure SQL Database for the DBA
Abstract:
SessionID: 49958
SSIS: Supercharge your data flows
Event Date: 03-09-2016 - Session time: 14:00:00 - Track: BI Architecture and Development
Speaker: Alex Whittles
Title: SSIS: Supercharge your data flows
Abstract:
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.
SessionID: 50069
Continuous Integration for Databases
Event Date: 03-09-2016 - Session time: 14:00:00 - Track: Database Development
Speaker: Steve Jones
Title: Continuous Integration for Databases
Abstract:
SessionID: 51067
You don't need Enterprise Edition to do that!
Event Date: 03-09-2016 - Session time: 14:00:00 - Track: Database Administration
Speaker: William Durkin
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.
SessionID: 47074
Introducing R and Using R in MS BI Suite
Event Date: 03-09-2016 - Session time: 15:20:00 - Track: BI Analytics and Visualization
Speaker: Dejan Sarka
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.
SessionID: 48110
Algorithms For Searching Through Encrypted Data
Event Date: 03-09-2016 - Session time: 15:20:00 - Track: Database Development
Speaker: Mladen Prajdić
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.
SessionID: 48293
Event Date: 03-09-2016 - Session time: 15:20:00 - Track: Other
Speaker: John Martin
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?
SessionID: 50890
Level Up Your Biml: Best Practices and Coding Techniques
Event Date: 03-09-2016 - Session time: 15:20:00 - Track: BI Architecture and Development
Speaker: Cathrine Wilhelmsen
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!
SessionID: 50987
Working with the Azure Data Lake for modern BI architecture
Event Date: 03-09-2016 - Session time: 15:20:00 - Track: Azure and Cloud Services
Speaker: Helge Rege Gårdsvoll
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.