Nr: 413
SQLSaturday #413 - Denmark 2015
SessionID: 10979
Securing your SQL Azure Database. How?
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Azure
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: 13963
From Navision to Power BI Dashboard in 45 minutes
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: BI
Speaker: Erik Svensen
Title: From Navision to Power BI Dashboard in 45 minutes
Abstract:
In this session I will show you how you can build a Power BI dashboard based on your sales data in your Navision database.
We will travel through the data from Navision on a SQL Server database to the visualization possibilities in Power BI Dashboard using the travel companions - Power Query, Excel Power Pivot , Power BI Designer and will end with Q A on the data.
Join me on an exciting journey through the Power BI tool belt on Navision data.
SessionID: 27093
PowerQuery and M
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: BI
Speaker: Peter ter Braake
Title: PowerQuery and M
Abstract:
SessionID: 27290
CDC - Change Data Capture in Detail
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Dev
Speaker: Uwe Ricken
Title: CDC - Change Data Capture in Detail
Abstract:
This session demonstrates the basic concepts, detailed components and implementation strategies of CDC.
The demo is based on a real scenario which has been implemented that way!
SessionID: 36742
How to create a Windows app with Project Siena, SharePoint and Of
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: SharePoint
Speaker: Knut Relbe-Moe
Title: How to create a Windows app with Project Siena, SharePoint and Of
Abstract:
SessionID: 36916
A deep dive into SQL Server Plan Cache Management
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: DBA
Speaker: Margarita Naumova
Title: A deep dive into SQL Server Plan Cache Management
Abstract:
SessionID: 11242
Upgrading from SSIS Package Deployment to Project Deployment
Event Date: 19-09-2015 - Session time: 10:15:00 - Track: BI
Speaker: Cathrine Wilhelmsen
Title: Upgrading from SSIS Package Deployment to Project Deployment
Abstract:
Are you still using the package deployment model in your SSIS projects, but want to upgrade to the project deployment model? Are you unsure how to go from using package configurations, configuration files and the SSIS configurations table, to using parameters, environments and the SSISDB catalog?
In this session I will explain the differences between the package deployment model and the project deployment model, and show you step-by-step how you can upgrade your SSIS projects. You will learn how to configure the SSISDB catalog, set up environments and environment variables, work with parameters and monitor your projects.
SessionID: 17781
Excel Services in SharePoint 2013
Event Date: 19-09-2015 - Session time: 10:15:00 - Track: SharePoint
Speaker: Just Blindbaek
Title: Excel Services in SharePoint 2013
Abstract:
We start with an overview of the new features in Excel Services in SharePoint 2013 and go on with the publish options with focus on the “Items in the workbook” option which is especially handy when you will embed in SharePoint without it resembles Excel too much. Second item on the agenda is the integration in SharePoint with a demonstration of three possibilities:
(1) Full page - The lazy solution.
(2) PerformancePoint Services Dashboard - The smart solution.
(3) WebPart page - The customizable solution.
Last but not least the session will include “Tips Tricks” including how to remove the Excel look. How to control the layout with “Named Items” and the "Name Manager" and how you can burst the limits from PivotTables with the of use "Cube Functions" and "Names Sets".
SessionID: 20730
Akademisk Track: Hvordan kan man bruge Big Data i det offentlige
Event Date: 19-09-2015 - Session time: 10:15:00 - Track: DBA
Speaker: Mikkel Freltoft Krogsholm
Title: Akademisk Track: Hvordan kan man bruge Big Data i det offentlige
Abstract:
Vi lever i en tidsalder, hvor alt digitaliseres og registreres. Den generation, der fødes nu erden første, hvor hele deres liv er registreret. Fra det offentliges sundhedsdata i spædbarnsårene til Facebooks registrering af kærlighedskvaler i teenageårene. Deres liv er digitalt fra vugge til grav.
Det offentlige vil kunne forudsige Big Data områder såsom behov for infrastruktur og børneinstitutioner. Og det vil kunne forudsige Small Data områder såsom hvilken undervisning, der passer bedst til hvert enkelt barn eller hvilken pleje, der passer passer bedst til netop denne patient.
SessionID: 28261
Event Date: 19-09-2015 - Session time: 10:15:00 - Track: BI
Speaker: Wolfgang Strasser
Abstract:
SessionID: 35645
Introduction to Replication from concepts to a running system!
Event Date: 19-09-2015 - Session time: 10:15:00 - Track: DBA
Speaker: David Williams
Title: Introduction to Replication from concepts to a running system!
Abstract:
We will be taking you through how to setup replication, what types of options are available to you (snapshot,merge,transaction,peer to peer), how to implement them, an explanation of the various SQL Agent Jobs and Replication binaries involved and what the limitations are. This session will provide you with almost everything you need to know to get started with replication or give you a valuable refresher to the topic if you haven't done it in a while.
SessionID: 9187
Event Date: 19-09-2015 - Session time: 10:15:00 - Track: BI
Speaker: Alberto Ferrari
Abstract:
How do you optimize a DAX expression? This session will introduce you to the useful tools to measure performance, gathering data to find the bottlenecks and helping you in writing new optimized versions of DAX. Starting from SQL Profiler, you will learn which events are relevant for DAX, and how to collect them in different environments (Analysis Services, Power Pivot, Power BI). We will show DAX Studio, which simplify and speed-up the data collection process, and makes it easy to find bottlenecks in storage engine and formula engine. The goal of the session is to provide you a methodology to measure performance of your DAX measures, to find the bottleneck and to identify the main reason of a performance issue.
SessionID: 12157
Power BI – getting it right
Event Date: 19-09-2015 - Session time: 11:30:00 - Track: BI
Speaker: Dandy Weyn
Title: Power BI – getting it right
Abstract:
First we’ll start with an introduction to each of the components of Power BI, you’ll learn about the evolution, how to get access, and how some of the great capabilities are enabled within some of the data visualizations directly in Excel and learn about the differences with the Power BI Desktop. In this part we’ll also discuss Power Pivot, Power View, and Power Map data visualizations, as well as use case scenarios to maximize gaining fast insights into any data.
You’ll get an introduction to Dashboard creation using a variety of data sources including content packs. By the end of the session you have anything you need to ingest data from multiple data sources and bring data into quick visualizations, you’ll understand how to create quick dashboards, content packs, and build visualizations on top of streaming data.
SessionID: 17802
Introduction to MDX
Event Date: 19-09-2015 - Session time: 11:30:00 - Track: Dev
Speaker: Jens Vestergaard
Title: Introduction to MDX
Abstract:
Aspects covered in the session:
• Select, From and Where clauses
• Sets, Tuples, Members
• Period, Hierarchy, String, Math and Filtering functions
SessionID: 20145
This is how developers might punish your database
Event Date: 19-09-2015 - Session time: 11:30:00 - Track: DBA
Speaker: Mogens Heller Grabe
Title: This is how developers might punish your database
Abstract:
SQL Server has traditionally been the go-to database for software development teams looking for a way of persisting their data, but the recent NoSQL movement has rendered visible just how limiting the relational model can be - and that may have led people to use other kinds of databases, like key-value stores, document databases, etc.
SQL Server does have some ways of misusing it, though, that you might have missed! In this session we’ll take a look at three alternative ways of using SQL Server, since we’ll see exactly how your favorite RDBMS can be turned into a document database, a reliable message queue, and an event store in a CQRS architecture.
Participants will get an introduction to all the mentioned concepts, and there will be code examples in C#.
SessionID: 23532
Event Date: 19-09-2015 - Session time: 11:30:00 - Track: BI
Speaker: Rasmus Reinholdt
Abstract:
Topics covered in the session
- BIML SSIS
- MDS
- Near Real-time reporting, what it takes and how to do it.
SessionID: 36186
AzureML: Welcome to the future of predictive analytics
Event Date: 19-09-2015 - Session time: 11:30:00 - Track: Azure
Speaker: Ruben Pertusa Lopez
Title: AzureML: Welcome to the future of predictive analytics
Abstract:
Real machine learning solutions and some best practices when integrating ML on Apps and websites.
SessionID: 37113
Branding SharePoint and Office 365
Event Date: 19-09-2015 - Session time: 11:30:00 - Track: SharePoint
Speaker: Sonja Madsen
Title: Branding SharePoint and Office 365
Abstract:
Drive user adoption and get more business value of your investment by branding and customizing smarter and not harder. While for end-users, SharePoint still looks pretty much the same, branding SharePoint on Office 365, the cloud technology, and continuous Microsoft updates require a different approach to branding.
I'll talk about what it takes to apply consistent corporate branding on Office 365, and how to keep up with Office 365 updates that roll out new features and changes in design and navigation.
SessionID: 40518
SQL Server Data Warehouse Fast Track – Understanding the Program
Event Date: 19-09-2015 - Session time: 12:35:00 - Track: Sponsor
Speaker: Niall MacLeod
Title: SQL Server Data Warehouse Fast Track – Understanding the Program
Abstract:
The SQL Server Data Warehouse Fast Track (DWFT) program is designed to provide customers standard and proven system architectures optimised for a range of enterprise data warehousing needs. DWFT is a joint effort between Microsoft and many hardware partners. The goal is to help enterprise customers deploy Data Warehouse solutions with recommended hardware configuration appropriate for the requirements of the workload with reduced risk, cost and complexity.
SessionID: 40629
Data Quality Improvement through Master Data Driven Business Inte
Event Date: 19-09-2015 - Session time: 12:35:00 - Track: Sponsor
Speaker: Dave Lawrence
Title: Data Quality Improvement through Master Data Driven Business Inte
Abstract:
Today’s Business Intelligence systems are increasingly perceived as mission critical, but their value is only as good as the quality of data they contain. How can you improve BI value by ensuring data quality through Microsoft SQL Server Master Data Services, accelerated by Profisee’s Master Data Maestro.
SessionID: 40716
Event Date: 19-09-2015 - Session time: 12:35:00 - Track: Sponsor
Speaker: Henrik Andersen
Abstract:
Henrik Andersen from Kroll Ontrack will show you how to restore tables with Ontrack PowerControls from native SQL backups without restoring the entire database – in seconds!
SessionID: 40769
( virtual ) SQL on Steroids
Event Date: 19-09-2015 - Session time: 12:35:00 - Track: Sponsor
Speaker: Frank Brix Pedersen
Title: ( virtual ) SQL on Steroids
Abstract:
What if one could guarantee SQL Server latency would take a vacation as In-Memory performance would be smoking fast without any of the challenges that contemporary approaches incur? In this presentation Frank Brix Pedersen will introduce '( virtual ) SQL on Steroids' as a bullet proof way of providing RAM performance for SQL Server without any side effects, any application rewrites or changes to infrastructure.
SessionID: 40841
In-Memory or Violin Memory - or both?
Event Date: 19-09-2015 - Session time: 12:35:00 - Track: Sponsor
Speaker: Jens Melhede
Title: In-Memory or Violin Memory - or both?
Abstract:
What is an In-Memory database and what impact does it have on requirements for storage IO.
Violin Memory technology and why this is almost required if you deploy In-Memory databases.
Can Violin Memory be used instead of In-Memory database configurations? Use case combining
SQL2014 In-Memory (Hekaton) and Violin Memory storage acceleration.
SessionID: 15756
Introduction to SQL Server high availability solutions
Event Date: 19-09-2015 - Session time: 13:45:00 - Track: DBA
Speaker: Janos Berke
Title: Introduction to SQL Server high availability solutions
Abstract:
This presentation is about the high availability solutions in SQL Server starting w/ SQL 2005 SP1 until the latest versions. It is for decision makers mainly and for those who just started working with SQL Server and interested about the different options.
The followings will be covered:
- DBM
- FCI
- AAG
- Log Shipping
- Replications
Presentation will try to show all in cost and feature set point of view along with their pro's and con's.
Demos:
- DBM: basic setup + failover + monitoring
- FCI: basic setup + failover
- AAG: basic setup + failover + monitoring
SessionID: 26996
Blue Sky Thinking: SQL Azure Geospatial Mashup
Event Date: 19-09-2015 - Session time: 13:45:00 - Track: Azure
Speaker: Thomas Sykes
Title: Blue Sky Thinking: SQL Azure Geospatial Mashup
Abstract:
In this session we'll be integrating a variety of geospatial data sources to provide a scalable website using a Windows Azure SQL Database and it's built in Geospatial features such as nearest neighbour. Then we'll take this a step further and introduce another live data stream, finally rendering it all using Bing Maps to an Azure Website. The presentation is targeted at individuals wanting a quick overview of the rapidly evolving Azure Service offerings for today’s cloud ready business.
SessionID: 36032
WTF with SQL
Event Date: 19-09-2015 - Session time: 13:45:00 - Track: Dev
Speaker: Kennie Pontoppidan
Title: WTF with SQL
Abstract:
SQL is based on the relational algebra, right? Relational algebra is based on set theory, right? So we would expect SQL to kind-of respect common sense from set theory. Like A union A has the same number of elements as A. Well, this is not always the case with SQL.
Come and have fun when we explore scenarios of simple SQL statements, where I guarantee you moments of inner WTF.
SessionID: 36140
Azure SQL Database Tips and Tricks for Beginners
Event Date: 19-09-2015 - Session time: 13:45:00 - Track: Azure
Speaker: Tobias Koprowski
Title: Azure SQL Database Tips and Tricks for Beginners
Abstract:
Microsoft released SQL Azure more than three years ago - that's enough time for testing. So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually (sic!) restoring data. In this session, you’ll see the differences, functionalies, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012/2014. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
SessionID: 37139
Event Date: 19-09-2015 - Session time: 13:45:00 - Track: SharePoint
Speaker: Anders Dissing
Abstract:
This session will cover how to setup your on-premises SharePoint environment for App/Add-in. The session will start with some theory and basis understanding of the nuts and bolts for configuring app/add-in for SharePoint. It ends with a “how-to” walkthrough, for a complete setup and deployment of a provider-hosted app.
SessionID: 38108
From MDS to SSRS - a short walkthrough
Event Date: 19-09-2015 - Session time: 13:45:00 - Track: BI
Speaker: Gabi Münster
Title: From MDS to SSRS - a short walkthrough
Abstract:
MDS makes the administration and maintenance of your master data quite easy and comfortable. But how is the effect on your business interfaces? This session will present demos of how the changes to your master data will effect your cube and reports - and how quick they can be available to your business users.
SessionID: 14614
SQL Server Security In An Insecure World
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: DBA
Speaker: Gianluca Sartori
Title: SQL Server Security In An Insecure World
Abstract:
One of your first responsibilities of a SQL Server DBA is to safeguard the data and protect it from unauthorized access.
Over and over we hear about hacker attacks and data leaks: if you don't want to be the next Sony, you have to take action and activate all the available protection measures.
In this session you'll learn how attackers take advantage of weaknesses in your infrastructure and how to secure it using SQL Server security features and best practices.
SessionID: 21570
Under Construction - Power BI Development
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: DBA
Speaker: Oliver Engels
Title: Under Construction - Power BI Development
Abstract:
SessionID: 36408
Putting Your head in the Cloud - Working with SQL Azure
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: Azure
Speaker: David Postlethwaite
Title: Putting Your head in the Cloud - Working with SQL Azure
Abstract:
You've learnt the basics of cloud computing and taken a tour of Microsoft Azure. It's now time to take a deeper look at using SQL Azure.
In this presentation we will have wall to wall demos on creating, configuring, connecting, using, securing, monitoring, uploading, scheduling and syncing your SQL Azure database.
By the end of this sessions you will some way to becoming an Azure Jedi
SessionID: 36865
Datazen - On-premise mobile bi
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: BI
Speaker: Bent Pedersen
Title: Datazen - On-premise mobile bi
Abstract:
Introducing Microsofts Onpremise Mobile BI solution, Datazen, a leader in mobile business intelligence and data visualization on Windows, iOS and Android devices serving for the on-premise mobile BI.
I want to show you how simply and easy it is to gets started and find data insights that you can use to improve your business. This session will contain a demo of the UI, creation of dashboards, KPIs and a walk-through of the current architecture and security of the software.
SessionID: 37118
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: Dev
Speaker: André Kamman
Abstract:
Love to run Brent's sp_Blitz and use Ola's MaintenanceSolution, but you have dozens or even hundreds of servers?
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.
SessionID: 40599
5 reasons I am excited for IoT and Cortana Analytics
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: Azure
Speaker: Iman Eftekhari
Title: 5 reasons I am excited for IoT and Cortana Analytics
Abstract:
Internet of Things (IoT) is now even more practicable with the power of the cloud analytics. Now with Cortana Analytics which have included components across a broad set of Azure Services, Power BI and APIs, you can connect your sensors and devices to the cloud to do more intelligent stuff and “Connect the Dots”. In this session you will get an overview of the capabilities in Cortana Analytics, and Iman will show you an outlook of the future.
SessionID: 13578
Event Date: 19-09-2015 - Session time: 16:15:00 - Track: Dev
Speaker: Dejan Sarka
Abstract:
SessionID: 25282
Intro to R
Event Date: 19-09-2015 - Session time: 16:15:00 - Track: BI
Speaker: Stephanie Locke
Title: Intro to R
Abstract:
R, a fantastic open-source language, will rock your world.
Instead of showing you how to do dry old statistics and worrying about your random trees and bagging methods, this session is going to take you through the super-cool stuff. No TLAs allowed in this session, only cool terms like shiny LaTeX!
We're gonna get your data out of SQL Server in just a few lines, then we're going to chart it for awesomeness, and then the fun begins.
We'll go through the easy experience of using shiny to make interactive, real-time reports.
I'll show you how you can add markdown to the mix to replace PowerPoint Word so that you can save yourself months over your lifetime formatting bullet points and headers.
By the end of this session, you'll truly know your Rs from your elbow.
SessionID: 36066
End to end risk assessment – affordable solution using Power BI
Event Date: 19-09-2015 - Session time: 16:15:00 - Track: Azure
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: 36686
SQL Server Batch Mode and CPU Architectures
Event Date: 19-09-2015 - Session time: 16:15:00 - Track: Azure
Speaker: Christopher Adkin
Title: SQL Server Batch Mode and CPU Architectures
Abstract:
SessionID: 36991
Desigining Complex Tabular Models - A Case Study
Event Date: 19-09-2015 - Session time: 16:15:00 - Track: BI
Speaker: Bob Duffy
Title: Desigining Complex Tabular Models - A Case Study
Abstract:
While building of Tabular Models may be straight forward it rapidly becomes more complex when you steer off-piste and into more complex design pattern such as:
- Many to Many relationships
- Semi-Additive Measures
- Last Ever Non Empty
- Events in Progress
- Versioned Fact Tables
- Almost real time processing requirements
- Huge volume
- Non Star Schema Data Warehouses
- measure explosion and lack of calculated dimensions
- Selecting Hardware
This one hour session will walk through an actual case study of a tabular model and discuss the pain points we encountered on the way, along with solutions and workarounds.
SessionID: 37131
Shadow prediction: SQL 2014 spatial data types and astronomy well mixed
Event Date: 19-09-2015 - Session time: 16:15:00 - Track: DBA
Speaker: Arne Bartels
Title: Shadow prediction: SQL 2014 spatial data types and astronomy well mixed
Abstract:
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 SQL2014 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 2014. Apart from 2-3 formulas everything will be handeled in SQL and no complex math is needed.