Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 24
This session will begin, with a high level introduction to Azure Internet of Things, Windows 10 Core and Raspberry PI. Once we have established the basics about the technology, we will be connecting the dots, with a live demo on some of the parts. The focus during the demo, will mainly be on Azure IoT Hub, Windows 10 Core and the Raspberry PI. As visualization we will be using Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud related

Level: Beginner

Session Code:

Date: August 27

Time: 3:15 PM - 4:15 PM

Room: Asperö

If people think about big data, they always think about Twitter or Facebook. But there are other areas where much more data amounts incurred and the analyzes are more complex. In this talk, we talk about a real example from bioinformatics. We will explain the actual scenario and how the various Microsoft platforms from SQL Server to Azure Data Lake and Power BI could help us – or not.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud related

Level: Intermedia

Session Code:

Date: August 27

Time: 2:00 PM - 3:00 PM

Room: Asperö

Configuring SQL Server Analysis Services for use with Azure SQL Data Warehouse (Preferred session)
Session objectives:
·         Enable OLAP and tabular analytics against SQL DW
·         Provide technical configuration to get the best from SSAS when connecting to SQL DW
·         Recommendations for process and approach
·         Optimize OLAP and SQL DW for performance
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud related

Level: Beginner

Session Code:

Date: August 27

Time: 11:45 AM - 12:45 PM

Room: Asperö

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 27

Time: 4:30 PM - 5:30 PM

Room: Vrångö 1

You probably know that with a stored procedure you can permit users to access or update data even if they have no direct permissions on the table. But you may have noticed that this does not work when the SP uses dynamic SQL. 

In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.

The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 11:45 AM - 12:45 PM

Room: Knippla

With the introduction of SQL 2016 and all its new features, Hybrid BI is more in focus then ever. Doing BI is no longer bound to be on-premise or in the cloud. With all the new features and the Azure platform Microsoft has made it easier then ever to implement a hybrid platform.

When working with a hybrid platform your organisation will be able to select strategy and features based on the highest ROI. During this session I will go through three different aspects of Hybrid BI which is infrastructure, data-storage and reporting. 

As part of this i will go through the advantages and disadvantages of each area to supply you with the information you need to choose the right direction for your platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 4:30 PM - 5:30 PM

Room: Knippla

This is an evergreen session, it follows Azure SQL Database evolution and each time is different: it looks at how to implement, maintain and evolve/update solutions developed on Azure SQL Database, through the use of the tools like SQL Sever Management Studio and Visual Studio. Through examples and case studies, will be presented the versatility, power and reliability of the database as a service in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud related

Level: Intermedia

Session Code:

Date: August 27

Time: 9:15 AM - 10:15 AM

Room: Asperö

Proper indexing is a very time and cost-effective way to improve SQL performance. Yet it is hardly known how to get it right and how different ways to phrase a query affects indexing and performance. In this session I’ll explain why this knowledge is sparse and what developers can do about it. Finally we will go through the most important indexing mistakes by example and discuss them during a short live quiz with the audience.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: August 27

Time: 4:30 PM - 5:30 PM

Room: Donsö

Azure SQL DB has had Row Level Security and Dynamic Data Masking for a while now, SQL Server 2016 brings that on-premises. But just how can you use it, what changes do you need to make to your model to get the most from it?

These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.

In this session we will look at how you can get the most out of these features and retain the performance of your system.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 3:15 PM - 4:15 PM

Room: Vrångö 1

DML operations mean lot of work for the database engine of Microsoft SQL Server. Understanding the details of a DML transaction may give you great benefits when planning workloads for INSERT, UPDATE and DELETE operations.

Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions:

What is the difference of data page allocation for heaps and clustered indexes?
What is the amount of transaction log when you update data in a heap and/or in a clustered index?
What are the differences when data are delete from a heap and clustered index?
Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES?
What performance drawbacks have Page Splits and Forwarded Records for my application design?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: August 27

Time: 10:30 AM - 11:30 AM

Room: Donsö

In this session we will talk about the Real-Time analytics possibilities with SQL Server 2016. This will be a deep-dive on how this works, and will give you an explanation on the new Columnstore features. We will also talk about the difference between hot & warm data.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 9:15 AM - 10:15 AM

Room: Donsö

As SQL Server, Windows and Cloud availability solutions have reached maturity, their capabilities and interoperability has grown to such an extent that it is no longer clear what technologies to use, when to use them, what they deliver and when things can go wrong.

In this session we will take a look at some of the new features provided by SQL Server and Windows 2016, how existing high availability solutions can benefit from their adoption and when schizophrenic HADR can be bad idea!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 11:45 AM - 12:45 PM

Room: Donsö

This session will cover some of the most interesting features of SQL Server 2016. In 60 minutes you will get enough arguments why you should upgrade to this new version of SQL Server. There will lots of demo of and a few slides about:
QueryStore,
Temporal,
Stretch,
Row level security,
Dynamic data masking


Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 2:00 PM - 3:00 PM

Room: Donsö

In the Wind turbine industry it is often desirable to know where a wind turbine casts its shadow as it can case annoyance to neighbours.
This session is supposed to be a more entertaining then practical exercise to combine scarsely used data types in unusual fashion, combined with a bit of astronomy and math, to calculate and visualize the relationship between sun and wind turbine purely by using SQL2016 Management Studio. 

The calculation of the daily path of a shadow can be seen as a rather complex three-dimensional problem. By turning around the perspective and 'painting' the picture of turbines in the sky this can be decribed as a much simpler two-dimensional problem on a sphere. For this the geography data type will be used and in turn the richness of its functionality demonstrated. Even a sufficient visualisaton is included in SSMS 2016.  Apart from 2-3 formulas everything will be handeled in SQL and no complex math is needed. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: August 27

Time: 11:45 AM - 12:45 PM

Room: Vrångö 1

SQL 2016 is now here packed with new features such Always Encrypted, Dynamic Data Masking, temporal tables, stretched tables, Query Store, Live Query stats and more. This talk gives an overview of what's  new and improved in SQL Server 2016 and demonstrates some of these features
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 27

Time: 10:30 AM - 11:30 AM

Room: Knippla

Query performance is what it is all about.  SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation.  This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality.  This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables.  
This session is all about when and how to apply in-memory tables in a production environment.
After this session you will
1.	 Understand what in-memory tables are and how to create and maintain them including their limitations
2.	Be able to identify performance gains over equivalent disk back tables
3.	Comprehend the new data monitoring needed for in-memory table
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 10:30 AM - 11:30 AM

Room: Asperö

You learned that your statistics should be regularly updated. You even implemented Ola Hallengren's maintenance scripts. That should be enough, right? What if it's not?
Join me on some head-ache, a dive into statistics histograms, trace flags and some proof to why the terrible sentence "It depends" always applies.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 3:15 PM - 4:15 PM

Room: Knippla

In this session we will look at techniques for transforming and refining data in a stream with Reactive Linq.
We will use example data coming from a mock-up parking garage and send it to SQL Server leveraging in-memory objects.  We will also let our data streams leverage Azure Stream Analytics and Azure Machine Learning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud related

Level: Advanced

Session Code:

Date: August 27

Time: 4:30 PM - 5:30 PM

Room: Asperö

What are these DATA Scientists up to? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?

You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.

In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 10:30 AM - 11:30 AM

Room: Vrångö 1

You have probably heard about the Accidental DBA, but what about the Accidental Data Warehouse developer? We stumbled into the world of data warehousing, learned dimensional modeling and work with T-SQL and SSIS daily. We are masters of googling solutions to our problems and make sure our ETL processes run without errors. We deliver data to business users... but we rarely deliver data as fast as we want.

You might not be able to rewrite your entire Data Warehouse or change your team's processes over night, but there are many things you can do to increase your own productivity and become a more efficient Data Warehouse developer.

In this session I will show you some of what I have learned and discovered that has made me exclaim "Oh wow! Why did I not know this yesterday!?" - including SSMS features, tools for query analysis and tuning, free tools and scripts, Biml for SSIS and even a couple of things I used to think were only useful for those scary DBAs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 27

Time: 2:00 PM - 3:00 PM

Room: Vrångö 1

Sessions Found: 24
Back to Top cage-aids
cage-aids
cage-aids
cage-aids