Nr: 275
SQLSaturday #275 - Copenhagen 2014
SessionID: 10486
Why proper data quality and modelling matters
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Magnus
Speaker: Bjorn D. Jensen
Title: Why proper data quality and modelling matters
Abstract:
SessionID: 10551
MIgrating to the Azure and the cloud
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Harald
Speaker: Bob Duffy
Title: MIgrating to the Azure and the cloud
Abstract:
So your CTO wants you to migrate your mission critical database application to the cloud. What's involved and what are the pitfalls?
In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and then demo performance and scalability impacts.
SessionID: 10774
Dynamic Partitioning Cubes
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Svend
Speaker: Brian Boenk
Title: Dynamic Partitioning Cubes
Abstract:
In every project on Business Intelligence there comes a time when the code needs to be deplyed to the production environment.
No more development, no more manual work.
But what about the partitions on the cube? Do we really need to tell and learn the DBA how to handle that on a periodic plan?
The answer is simple: No!
SessionID: 10901
Replay your workload as it's your actual one!
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Magnus
Speaker: Boris Hristov
Title: Replay your workload as it's your actual one!
Abstract:
Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there's a feature for that! It's called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!
SessionID: 11583
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Harald
Speaker: Christina Leo
Abstract:
Have you pulled a script to identify duplicates from a blog post, but couldn’t quite get it to work, because you weren’t sure what that ROW_NUMBER() function was doing. Maybe you heard talk about creating running totals without using sub-queries, but you got frustrated when the groups weren’t totaling correctly. Or maybe, you’ve never even heard of Window Functions. All are good reasons to attend this all-demo session which demystifies this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations. When you leave, you’ll have the fundamentals you need to fully develop your mastery of Window Functions.
SessionID: 11707
The Irish Economic Crisis, Visualized with Power BI
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Harald
Speaker: Carmel Gunn
Title: The Irish Economic Crisis, Visualized with Power BI
Abstract:
It starts from a very common business angle, where people need to make sense of data, fast, but don't know what questions to ask, nor how to combine available sources in a way that makes sense.
This session converts the Irish Economic crisis into a story that can be explored in an interactive way, using familiar tools, in a way that people may feel should have been noticed in the run-up to the crisis.
Come by to find out what led to a small country owing over 200 billion euro and if Power BI could have helped.
SessionID: 13958
Prepare your Excel Power Pivot models for QA
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Harald
Speaker: Erik Svensen
Title: Prepare your Excel Power Pivot models for QA
Abstract:
The new QA function in Power BI will make it possible to ask questions to your Excel Power Pivot models and get a visualization back.
In order to give the best experience for the users of your model you need to prepare it for questions. In this session I will go through how to do this - and will also introduce the natural language syntax and thereby give you an idea of how you can help the user to get the right answer to their questions and the correct visualization as the first answer.
QA will really enable you to rock the way that users interact with data.
SessionID: 14688
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Gorm
Speaker: Glenn Berry
Abstract:
SessionID: 14939
Encryption in SQL Server - things to consider before flipping the switch
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Svend
Speaker: Hans Hansen
Title: Encryption in SQL Server - things to consider before flipping the switch
Abstract:
SessionID: 15035
Advanced Indexing
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Knud
Speaker: Hugo Kornelis
Title: Advanced Indexing
Abstract:
So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!
Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
SessionID: 16533
Let's PowerBI Denmark with Big Data!
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Gorm
Speaker: Jen Stirrup
Title: Let's PowerBI Denmark with Big Data!
Abstract:
BI and BA professionals need to tackle ever-increasing sources of data that are increasing in volume, velocity and variety. Let's look at fun example of global data about Denmark to look at common data storytelling by BI and BA professionals: analysing open data with varying degrees of data quality, business puzzles vs business mysteries, and deciding on which chart or graph to use when presenting data.
If the 'too much data, too little information' scenario is familiar, then come to this session, which isn't just for the international visitors who come to SQLSaturday Copenhagen every year - like myself! Uncover surprising facts as we mashup, slice and dice the data, and look at Big Data and Data Visualisation
SessionID: 17780
Unit testing Analysis Services
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Knud
Speaker: Just Blindbaek
Title: Unit testing Analysis Services
Abstract:
SessionID: 17792
Analysis Services Security
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Knud
Speaker: Jens Vestergaard
Title: Analysis Services Security
Abstract:
Being able to accomodate the most demanding requirements on security is more important now than ever. This session will take you through a variety of approaches on how to implement basic to complex security on dimensions in SSAS. A quick intro through the GUI will bring us to XMLA and AMO as the weapon of choice. Different concepts on hierarchy security models will also be demonstrated.
SessionID: 18103
Autogenerating a process data warehouse
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Svend
Speaker: Kennie Pontoppidan
Title: Autogenerating a process data warehouse
Abstract:
In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like "What are the typical waiting times in our order process?" are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems.
In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.
SessionID: 18591
Microsoft Master Data Services - Used for more than just data management
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Magnus
Speaker: Kenneth Nielsen
Title: Microsoft Master Data Services - Used for more than just data management
Abstract:
This session will give you an idea for some alternative uses of Master Data Management.
And how Easy it is to instantiate MDS from SSIS with T-SQL and stored procedures.
Also a short walk through of the tools in MDS from sql server 2012
SessionID: 19452
Indexing for denormalization
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Svend
Speaker: Marcin Szeliga
Title: Indexing for denormalization
Abstract:
A third normal form is great, but sometime a database really should be denormalized to gain a performance boost. This is where indices shine. During this session you will see: how important a proper table design can be, when to use indices on computed columns and why they are way better than triggers, how to create useful indexed views and how to asses their costs and benefits.
SessionID: 19465
Optimizing DAX Analyzing Query Plans
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Gorm
Speaker: Marco Russo
Title: Optimizing DAX Analyzing Query Plans
Abstract:
SessionID: 19602
Recovering Data from Fatally Corrupt Databases
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Gorm
Speaker: Mark S. Rasmussen
Title: Recovering Data from Fatally Corrupt Databases
Abstract:
Imagine the worst case scenario: Your database won't come online. Lots of checksum errors logged. DBCC CheckDB won't even run on the database. And worst of all - you have no backups! Now what do you do with this 20GB binary blob of an MDF file?
In this demo-rich session I will briefly introduce the internals of MDF files while primarly concentrating on how to manually extract data from corrupt databases. I will be using the OrcaMDF RawDatabase framework to do most of the parsing, which will also be explained during the session.
SessionID: 20121
Overview of a PDW project
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Harald
Speaker: Mark Stacey
Title: Overview of a PDW project
Abstract:
In this session, you will be introduced to the secret sauce of the PDW - MPP and column-store.
You will also learn about some of the differences between a PDW and SQL Server, and be taken through the life-cycle of a PDW project, based on the V1 and V2 projects Mark has worked on
SessionID: 20368
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Gorm
Speaker: Michael Frandsen
Abstract:
In this session I will go into the new storage features in Windows Server 2012 and R2 and how they relate to SQL Server 2012 and how SQL Server 2014 expands on this.
Through working with the Core Windows Server team in Redmond during the development of Windows 8.1/R2 I did a lot of work with technologies which have been around for some time, but unavailable to Windows Server installations. We will talk about InfiniBand, Multi-path I/O, RDMA, RoCE, NAND Flash storage, latency and much more.
Being in the Data Platforms Advisors group for the SQL Server development team in Redmond, I have worked with completely new concepts of integration between SQL Server and modern hardware, many of these surfacing in SQL Server 2014
SessionID: 20736
SQL Server 2014 - New Cardinality Estimator
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Harald
Speaker: Miloš Radivojević
Title: SQL Server 2014 - New Cardinality Estimator
Abstract:
In SQL Server 2014 query processing has been improved. What we can expect from new cardinality estimator? Does it really estimate better? Will our execution plans be better after migration to 2014? All of them? Is the key ascending column statistics problem solved in new version? Do we finally can have more than 200 steps in the statistics histogram per table? What about column correlation and cardinality estimates - are the predicates still completely independent?
This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.
SessionID: 21315
SQL Server 2012 Memory Management
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Knud
Speaker: Neil Hambly
Title: SQL Server 2012 Memory Management
Abstract:
SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory.
This session will dive into questions related to memory primarily for SQL Server 2012.
SessionID: 23512
Optimizing BI with SQL2014 In-Memory tables
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Knud
Speaker: Rasmus Reinholdt
Title: Optimizing BI with SQL2014 In-Memory tables
Abstract:
Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can't optimize our BI solutions with this new feature.
This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process.
SessionID: 25019
Let's cook 'best SQL Server DBA practices'
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Magnus
Speaker: Satya Jayanty
Title: Let's cook 'best SQL Server DBA practices'
Abstract:
SessionID: 25247
Window Functions Unleashed
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Svend
Speaker: Steen Dybboe
Title: Window Functions Unleashed
Abstract:
SessionID: 27240
INSERT / UPDATE / DELETE - deep dive
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Gorm
Speaker: Uwe Ricken
Title: INSERT / UPDATE / DELETE - deep dive
Abstract:
DML is used in most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level.
After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated.
SEE, what a workload will be caused by a "forwarded record". What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes
SessionID: 27782
Practical use of the SSIS Script components
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Svend
Speaker: Mikael Wedham
Title: Practical use of the SSIS Script components
Abstract:
SessionID: 34559
Automate your SSIS development with BIML
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Harald
Speaker: André Kamman
Title: Automate your SSIS development with BIML
Abstract:
Ever tried to import a file with the Import/Export wizard?
Or created a bunch of SSIS packages to process a data warehouse load?
Then you know how much work it is to specify the metadata correctly just to create a package that actually works.
Wouldn't it be cool if you had a descriptive language which looks at your metadata and just created the packages for you?
This is what BIML is all about.
In this session I explain what BIML is, how it works and I'll show you how you can generate your packages and quickly respond to changes.
You can expect a demo rich session with lots of notes from the field and practical examples.
This is not just for BI developers, DBA's or SQL dev's who need to import or export data occasionally will learn some quick and easy tricks as well.
SessionID: 8815
SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Gorm
Speaker: Andreas Wolter
Title: SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive
Abstract:
SessionID: 8873
PowerShell for Data Professionals
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Knud
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract: