Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 31
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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Knud

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Knud

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator?  Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.
Speaker:

Session Type:
Regular Session

Track:
Gorm

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Svend

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Harald

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Harald

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

You have worked with SQL Server Integration Services (SSIS) for a few years, but would like to know what is happening behind the scene. Join this session to get a deep dive into the internals of SSIS, and find out what is happening when your packages are executed. You will learn about the data flow engine, what buffers are used for, how the different transformations behave, and what execution trees are and why they are important.

Understanding the SSIS internals is not only very interesting in itself, but will also make you able to respond to design and performance problems – as well as solve them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Knud

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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!
Speaker:

Session Type:
Regular Session

Track:
Svend

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

With an alarming number of high-profile data breaches in the last 12 months, perhaps SQL Server encryption should be a topic to revisit in your data protection strategy. After a brief overview of column-level encryption and TDE, we discuss SQL Server encryption with regard to performance, application-tier and operations.
Speaker:

Session Type:
Regular Session

Track:
Svend

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Since SQL Server 2012 a paradigm shift is occurring in how SQL Server platforms are designed and built. Come and hear why you no longer will need a SAN to create a high-available SQL Server and why I/O is no longer a problem.
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
Speaker:

Session Type:
Regular Session

Track:
Gorm

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

What has the biggest impact on SQL Server overall performance? Hardware, SQL Server configuration or maybe query tuning? No, none of those frequently discussed options. They are important, but the single, most important factor is the database design.
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Svend

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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 
Speaker:

Session Type:
Regular Session

Track:
Gorm

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will go through the topics of performance, scalability and availbility - the 3 core topics that every DBA needs to know. Performance is at the core and required for every database application (small or mission-critical). In this talk we will go through the concepts, tools and procedures that will help you in monitoring and start fine-tuning the performance or find the root-cause on your data platform. The subject covered here is excerpted from my book "Microsoft SQL Server 2008 R2 Administration cookbook". This will also be an ideal beginning for any IT person who is willing step-into DBA world. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Magnus

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this fun session, we will use Microsoft's Big Data and PowerBI tools to learn about Denmark! We will mix and mashup data from a variety of sources such as 'The Spirit Level' by Prof Richard Wilkinson, UNICEF, the World Bank and even the CIA to learn more about Denmark.
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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Gorm

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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
Speaker:

Session Type:
Regular Session

Track:
Magnus

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Harald

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Session Type:
Regular Session

Track:
Knud

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to optimize DAX measures and queries in this very technical and deep-dive session. Starting from simple performance issues, you will see how to read and understand the query plan of a DAX query. With this information, you will be able to locate bottlenecks in calculation and improve performance by changing DAX expressions, moving the workload from the formula engine to the storage engine and get a complete understanding of the internals of the DAX query engine. A previous knowledge of the xVelocity In-Memory engine and some basics of the DAX Query Engine are suggested in order to follow this session in a more productive way.
Speaker:

Session Type:
Regular Session

Track:
Gorm

Level: Advanced

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Harald

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Knud

Level: Intermedia

Session Code:

Date: March 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 31
SQLSaturday