sqlsathistory

Nr: 411

Back to Main list

SQLSaturday #411 - Cambridge 2015

Start Time (24h) Speaker Track Title
09:00:00 Benjamin Nevarez DEV (Animals) SQL Server Query Tuning Optimization
09:00:00 Niko Neugebauer BI (Wish You Were Here) A Day with Columnstore Indexes
09:00:00 Penelope Coventry SharePoint (Dark Side of the Moon) Automating business processes with SharePoint, Office 365 and Azu
09:00:00 Mark Broadbent SharePoint (Dark Side of the Moon) Implementing Business Intelligence SharePoint High Availability
09:00:00 Rasmus Reinholdt BI (Wish You Were Here) Building tomorrows ETL architecture with BIML and MDS today
09:00:00 Kennie Pontoppidan DEV (Animals) SQL Anti-Patterns
09:00:00 Microsoft and Guests DBA (The Wall) Microsoft – Building a Data Driven Strategy
08:30:00 John Martin DBA (The Wall) Availability Group Maintenance Operations
08:30:00 Terry McCann BI (Wish You Were Here) SSRS Inception: Reporting on Reporting services.
08:30:00 Kennie Pontoppidan Other (A Momentary Lapse of Reason) Ask the CEO - Infrastructure for your new business
08:30:00 André Kamman Cloud (Piper at the Gates of Dawn) How to be a Cloud DBA
08:30:00 Frank Geisler DEV (Animals) Testing T-SQL Code with tSQLt
08:30:00 Ryan Yates SharePoint (Dark Side of the Moon) Using SharePoint as a Service Delivery Platform
08:30:00 Andy Talbot SharePoint (Dark Side of the Moon) SharePoint Enterprise Platforms: Build Run Lessons Learnt
10:00:00 Boris Hristov Cloud (Piper at the Gates of Dawn) Securing your SQL Azure Database. How?
10:00:00 Chris Webb BI (Wish You Were Here) Common Analysis Services Multidimensional Design Mistakes And How To Avoid Them
10:00:00 Denis Reznik DEV (Animals) SQL Server Performance Tuning. Practical Guide.
10:00:00 Johan Ludvig Brattås BI (Wish You Were Here) Performance tuning a PowerPivot and Tabular model, notes from the field
10:00:00 Kenneth Nielsen Cloud (Piper at the Gates of Dawn) Azure Big Data Solution – automation of deployment
10:00:00 Peter Baddeley SharePoint (Dark Side of the Moon) Understanding SharePoint reporting options for SQL Server
10:00:00 Uwe Ricken DBA (The Wall) Efficient Index maintenance through DMVs
10:00:00 Al Eardley SharePoint (Dark Side of the Moon) SharePoint Databases - What you need to know
11:15:00 Denis Reznik DBA (The Wall) Hidden gems of SQL Server 2014
11:15:00 Jens Vestergaard BI (Wish You Were Here) Introduction to MDX
11:15:00 Uwe Ricken DEV (Animals) Building abstract layers for data protection and business logic
11:15:00 Ruben Pertusa Lopez BA (The Division Bell) AzureML: Welcome to the future of predictive analytics
11:15:00 John Tunnicliffe DEV (Animals) Continuous Integration and the Data Warehouse
11:15:00 David Dye BI (Wish You Were Here) Dealing With Errors in SSIS 2012
11:15:00 Sonja Madsen SharePoint (Dark Side of the Moon) Quick Start Guide to JavaScript Frameworks for SharePoint Apps
12:20:00 James Rowland-Jones Cloud (Piper at the Gates of Dawn) Introducing Azure SQL Data Warehouse
12:55:00 James Rowland-Jones BI (Wish You Were Here) Scale Out Data Warehouse QA with Big Bang Data Co
13:30:00 Enrico van de Laar DBA (The Wall) Efficient Indexing Strategies
13:30:00 Regis Baccaro SharePoint (Dark Side of the Moon) SharePoint as a Business Intelligence platform
13:30:00 Kennie Pontoppidan Other (A Momentary Lapse of Reason) How to build an IT operations expert
13:30:00 Mladen Prajdić DEV (Animals) Digging Into the .Net SqlClient
13:30:00 Frank Geisler BI (Wish You Were Here) Datazen - An overview
13:30:00 David Dye BI (Wish You Were Here) Creating Dynamic Packages
13:30:00 Corey Burke SharePoint (Dark Side of the Moon) Re-engineering the SharePoint Migration
13:30:00 André Kamman DBA (The Wall) No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt
13:30:00 Allan Mitchell BA (The Division Bell) Azure Data Factory - The New SSIS?
14:45:00 Niko Neugebauer DBA (The Wall) Understanding Solving Columnstore Problems
14:45:00 John Martin Cloud (Piper at the Gates of Dawn) Building your first Microsoft Azure IaaS infrastructure
14:45:00 Jens Vestergaard BI (Wish You Were Here) Scaling out Analysis Services
14:45:00 Rasmus Reinholdt DEV (Animals) Taking your application to memory
14:45:00 Tomaž Kaštrun BA (The Division Bell) Benefits of analytics using Microsoft Azure Machine Learning
14:45:00 Penelope Coventry SharePoint (Dark Side of the Moon) Extending SharePoint solutions: Without spending money
14:45:00 Ruben Pertusa Lopez BI (Wish You Were Here) A journey through the Modern Data Warehouse
14:45:00 Al Eardley SharePoint (Dark Side of the Moon) Office 365 - The Art of the Possible
16:00:00 Benjamin Nevarez DEV (Animals) Dive into the Query Optimizer-Undocumented Insight
16:00:00 Christopher Adkin DEV (Animals) SQL Server Batch Mode and CPU Architectures
16:00:00 Rasmus Reinholdt BI (Wish You Were Here) Optimizing BI with SQL2014 In-Memory tables
16:00:00 Thomas Sykes Cloud (Piper at the Gates of Dawn) Blue Sky Thinking: SQL Azure Geospatial Mashup
16:00:00 Mladen Prajdić BI (Wish You Were Here) Visualizing streaming data in real time
16:00:00 Anthony Obi SharePoint (Dark Side of the Moon) SharePoint - Migrating Databases and Farm Configuration using PowerShell
16:00:00 David Parker SharePoint (Dark Side of the Moon) Visualising SharePoint and SQL Data with Visio Professional
16:00:00 Allan Mitchell BA (The Division Bell) HBase on HDInsight

SessionID: 39171

SQL Server Query Tuning Optimization

Back to calendar

Event Date: 12-09-2015 - Session time: 09:00:00 - Track: DEV (Animals)

Speaker: Benjamin Nevarez

Title: SQL Server Query Tuning Optimization

Abstract:

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]

This full-day seminar will show you how to optimize SQL Server queries and create high-performance applications. You will learn about the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. You’ll also get tips for troubleshooting under-performing queries. In-Memory OLTP (Hekaton), a key new feature of SQL Server 2014, will be covered as well. Topics include:

How the query optimizer works Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools Work with query operators for data access, joins, aggregations, parallelism, and updates Speed up queries and dramatically improve application performance by creating the right indexes Understand statistics and how to detect and fix cardinal

SessionID: 39188

A Day with Columnstore Indexes

Back to calendar

Event Date: 12-09-2015 - Session time: 09:00:00 - Track: BI (Wish You Were Here)

Speaker: Niko Neugebauer

Title: A Day with Columnstore Indexes

Abstract:

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]

Make sure you spend the whole day learning about the most important technology Microsoft has launched since the beginning of SQL Server – Columnstore Indexes. We will investigate how you can optimise your BI DataWarehousing solutions and take the advantage of the modern Columnstore Architecture significantly boosting your query performance and analytics reporting.

Learn how to get the very best out of your existing database environments and how you can monitor, optimise, implement and solve many Columnstore Indexing problems.

Discover how to take the full advantage of the Batch Processing mode for Columnstore Indexes, which can significantly accelerate your query processing by hundreds of times, and learn about its limits.

Through the use of Dynamic Management Views, Extended Events and Traceflags we shall analyse traditional Rowstore tables and turn them into highly

SessionID: 39189

Automating business processes with SharePoint, Office 365 and Azu

Back to calendar

Event Date: 12-09-2015 - Session time: 09:00:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Penelope Coventry

Title: Automating business processes with SharePoint, Office 365 and Azu

Abstract:

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]

Many people are forced to use Microsoft#174; SharePoint#174; because it is already there or part of the Office 365™ ecosystem; therefore many users see it just as another task to add to their burgeoning workload of tasks they have to complete in their busy working day. When any technology is introduced into a business it should help not hinder users. It should enable users to do more, not less. Technology should meet business needs and not be focused around a single product.

With this in mind, Penny will look at automating business processes using out-of-the-box functionality of SharePoint and with the use of Azure™ Logic Apps outside SharePoint, beyond firewalls and beyond even your own datacentre. You can create these workflows using no-code visual designers.

SharePoint topics that will be cover

SessionID: 39025

Implementing Business Intelligence SharePoint High Availability

Back to calendar

Event Date: 12-09-2015 - Session time: 09:00:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Mark Broadbent

Title: Implementing Business Intelligence SharePoint High Availability

Abstract:

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]

High Availability solutions have been around for nearly as long as SQL Server and with “Maintenance Windows” becoming an increasingly rare luxury, businesses are relying more and more on their Data Warehouse and Business Intelligence reporting platforms being available 24 hours a day for 365 days a year.

In this pre-conference session we shall explain how to design, plan, implement and maintain an end-to-end Highly Available Business Intelligence and analytic platform laying not only the conceptual foundations for your learning, but providing the practical technical hands on know-how for Business Intelligence professionals, Database (and Windows) administrators, and Technical Architects.

For more detail about this session please visit http://sqlcambs.org.uk/precon6/

SessionID: 39167

Building tomorrows ETL architecture with BIML and MDS today

Back to calendar

Event Date: 12-09-2015 - Session time: 09:00:00 - Track: BI (Wish You Were Here)

Speaker: Rasmus Reinholdt

Title: Building tomorrows ETL architecture with BIML and MDS today

Abstract:

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]

In this hands-on / bring your own laptop pre-con, Rasmus will show how you can take your ETL to the next level. You will go from “Zero to BIML to BIMLScript” in the duration of the day. That means, that leaving the pre-con, you will never ever again have to go over hundreds of packages to change a datatype or add a column, all you’ll need to do, is to change your meta-data and you are home free.

As our meta-data repository, we will use SQL Servers built-in Master Data Services. You will be given a thorough introduction to this component and learn how to use and administer it. Besides getting a working knowledge of BIML AND MDS, and become able to use that in your ETL development, you will also get an overview of, and get to work with, the following advanced ETL concepts:

Early arriving facts Slowly Changing Dimensions (SCD) with script task Least interdependent structu

SessionID: 39170

SQL Anti-Patterns

Back to calendar

Event Date: 12-09-2015 - Session time: 09:00:00 - Track: DEV (Animals)

Speaker: Kennie Pontoppidan

Title: SQL Anti-Patterns

Abstract:

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]

You can learn the basics of SQL in three days but it’ll take you 10 years to become good at it.

In this full training day we will take a look at a range of common design and coding mistakes to get an idea of the patterns and practices that absolutely do not work well for optimum performance, scale and design.

Anti-patterns are a way of naming these common design mistakes in order to make them easier to identify and remember (and correct!). Sooner or later as the demands on your database performance increase, so will the need to identify and resolve your anti-patterns.

During the day we will grow acquainted with anti-patterns on a physical level, a logical level, a SQL Query and application level, and spice it them up with some seriously foolish errors made by both myself, my colleagues and the industry at large!

Examples of SQL Anti patterns that we will address dur

SessionID: 40202

Microsoft – Building a Data Driven Strategy

Back to calendar

Event Date: 12-09-2015 - Session time: 09:00:00 - Track: DBA (The Wall)

Speaker: Microsoft and Guests

Title: Microsoft – Building a Data Driven Strategy

Abstract:

For more details visit http://sqlcambs.org.uk/precon7/

IDC research, commissioned by Microsoft, shows that better outcomes from data and analytics projects correlate with greater competitiveness of an organization in its industry or a better ability to fulfil its mission in the public sector. Although correlation does not equate to causation, a growing body of research shows financial and productivity benefits directly linked to better data-driven decision making enabled by business analytics solutions.

Four characteristics distinguish leaders in analytics—the use of more diverse data types and sources beyond social media to include the Internet of Things (IoT), adoption of more diverse analytical and self-service tools, methods, and metrics suited to broad range of users from data scientists to business analysts and executives, distribution of insights to a more diverse audience of business users, and the right-time application of most timely data.

SessionID: 17292

Availability Group Maintenance Operations

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: DBA (The Wall)

Speaker: John Martin

Title: Availability Group Maintenance Operations

Abstract:

AlwaysOn Availability Groups provide an excellent way to build a High Availability platform with SQL Server at its core, however with these new capabilities come new and interesting maintenance requirements. In this session we will look at a number of the things you must do when making use of Availability Groups, and some of the things that you can do in order to ensure that you have a stable, reliable platform.

SessionID: 26106

SSRS Inception: Reporting on Reporting services.

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: BI (Wish You Were Here)

Speaker: Terry McCann

Title: SSRS Inception: Reporting on Reporting services.

Abstract:

Still using Reporting Services? Yeah me too! Does this scenario sound familiar? You already have a large SSRS environment but the users still want more reports. You create a new, all singing, all dancing dashboard that removes the need for a bunch of reports, awesome. You launch it and explain to the business that you are deprecating the old reports. "WAIT! We still need that for Jill in HR to do her end-of-month", or "We might still need that" - these types of comments are what leads to having a load of reports that are not being used.

Wouldn't it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn't it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.

SessionID: 35732

Ask the CEO - Infrastructure for your new business

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Other (A Momentary Lapse of Reason)

Speaker: Kennie Pontoppidan

Title: Ask the CEO - Infrastructure for your new business

Abstract:

Want to start a new business? You have the great idea, but what about creating a business plan, web site, invoicing, CRM, social media and all the other infrastructure you need to operate that great startup. Come and spend an hour with me and see how we did it with our new company Effektor. Ask all the questions you have. I might even be able to answer them.

SessionID: 37073

How to be a Cloud DBA

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Cloud (Piper at the Gates of Dawn)

Speaker: André Kamman

Title: How to be a Cloud DBA

Abstract:

Traditional DBA's do not just take care of making sure the backups work. We help teams promote their databases from DEV to Production, we make copies from Production to Dev and perhaps anonimize some data on the way. In this session we will look at a bunch of our tasks that are traditionally the domain of the DBA and we will look at how to perform these tasks in a cloud or hybrid cloud situation.

SessionID: 37853

Testing T-SQL Code with tSQLt

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: DEV (Animals)

Speaker: Frank Geisler

Title: Testing T-SQL Code with tSQLt

Abstract:

Unit-Test are a mature tool in traditional programming languages like C# and meanwhile accepted as de-facto standard. Using Stored Procedures and Functions you can put much programming logic right into the database. This logic has to be tested too. SQL Server Data Tools from Microsoft are one possible approach to generate unit tests for T-SQL Code. One of the disadvantages of SSDT is that the tests are implemented as C# or VB Solutions outside of the database. An alternative to these approach is using tSQLt, a Testing-Framework that is written entirely in T-SQL and is run completely in the database. So you are able to write unit tests in SQL Server Management Studio. In his talk SQL Server MVP Frank Geisler will show how the tSQLt Framework is set up and how it works and how you can write Unit Tests for different SQL Server Objects. Besides the free Version of tSQLt you can buy SQL Test from Redgate which is a very useful GUI for tSQLt and is demonstrated as well.

SessionID: 39974

Using SharePoint as a Service Delivery Platform

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Ryan Yates

Title: Using SharePoint as a Service Delivery Platform

Abstract:

Large organisations usually have their own dedicated Service Delivery IT platform for tracking and managing "Service Requests", but what happens in smaller organisations?

Without the right management tools and software, tracking and delivering service request resolutions can be a resource intensive task in itself and does not bode well for the quality of service to the end-user.

If your organisation has a SharePoint deployment, it doesn't have to be this way.

In this session we will utilise SharePoint's Out-Of-The-Box functionality and through a selection of customisations and technical know how, we will lay the foundations so that you may implement your own Service Delivery platform and enable your organisation to provide the type of efficient service delivery your end users expect.

SessionID: 39976

SharePoint Enterprise Platforms: Build Run Lessons Learnt

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Andy Talbot

Title: SharePoint Enterprise Platforms: Build Run Lessons Learnt

Abstract:

To point and click our way through a SharePoint installation is relatively easy, but will more than likely result in some form of disaster. Join SharePoint expert, Andy Talbot for a detailed discussion on building and running SharePoint platforms fit for enterprise customers.

In this session, Andy will address some of the common challenges that can take some enterprises by surprise, lessons learnt by large organisations, factors that we should have planned for, and common failure points. Attendees will benefit from this discussion regardless of if you are just starting out with your deployment, or you’re already in production. Although this is mainly targeted at the IT PRO audience, key points are made that very relevant to business users too.

SessionID: 10971

Securing your SQL Azure Database. How?

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: Cloud (Piper at the Gates of Dawn)

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

Common Analysis Services Multidimensional Design Mistakes And How To Avoid Them

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: BI (Wish You Were Here)

Speaker: Chris Webb

Title: Common Analysis Services Multidimensional Design Mistakes And How To Avoid Them

Abstract:

When you're starting out on your first Analysis Services Multidimensional cube project it's very easy to make design mistakes that can cause problems for you later on. In this session you'll learn about the mostly frequently made Analysis Services design mistakes, what the consequences of making them are, and how to fix them.

SessionID: 13126

SQL Server Performance Tuning. Practical Guide.

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: DEV (Animals)

Speaker: Denis Reznik

Title: SQL Server Performance Tuning. Practical Guide.

Abstract:

Nothing is perfect, which means that your database may be not perfect as well. And one day you may decide that your database is slow and it's time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in process of performance tuning. And in this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way we will learn practical techniques of performance tuning and solve bunch of issues. All this will be done using tools, which are installed on your system by default. Minimum of theory and a lot of practice.

SessionID: 17141

Performance tuning a PowerPivot and Tabular model, notes from the field

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: BI (Wish You Were Here)

Speaker: Johan Ludvig Brattås

Title: Performance tuning a PowerPivot and Tabular model, notes from the field

Abstract:

In-memory means blazingly fast, at least most of the time.

But modeling for the xVelocity/Vertipaq engine is a completely different beast than modeling for your trusty multi-dimensional SSAS cubes.

Join me on a session of improving a malfunctioning PowerBI Excel sheet and pick up handy tips and tricks you will need to tune your xVelocity models.

SessionID: 18616

Azure Big Data Solution – automation of deployment

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: Cloud (Piper at the Gates of Dawn)

Speaker: Kenneth Nielsen

Title: Azure Big Data Solution – automation of deployment

Abstract:

By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask.

Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts This session will show you how : • Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account. • Create a storage account and container for the HDInsight Cluster. • Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly. • The HDInsight cluster is provisioned and configured for access to the sample data. • A partitioned Hive table is created over top of the sample data • Exploration of the result • And how to automate these task either in Powershell or SSIS.

SessionID: 21909

Understanding SharePoint reporting options for SQL Server

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Peter Baddeley

Title: Understanding SharePoint reporting options for SQL Server

Abstract:

The SharePoint landscape has changed dramatically over the last few years, and this session is designed to help Business Decision Makers, IT Managers and SQL Professionals understand what it offers as reporting platform. Exploring the different options, benefits and considerations for using SharePoint to report on data in SQL Server. Explaining that there are important decisions to make about which platform to use, and whether cloud based services should be considered. It will show a number of SharePoint options including Business Connectivity Services, Reporting Services, Excel Services and Power BI. It will consider the differences in functionality and configuration for different versions of SharePoint and SQL. Including comparing the platforms of SharePoint Server, SharePoint Foundation and Office 365. Finally it will challenge attendees to think about the purpose of the solution being delivered, who it is for and the long term strategy.

SessionID: 27294

Efficient Index maintenance through DMVs

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: DBA (The Wall)

Speaker: Uwe Ricken

Title: Efficient Index maintenance through DMVs

Abstract:

Indexing is the most important task for a good performing database. An optimized database need to be checked regularly for all kind of index problems. This session will Show the usage of DMV (dynamic management objects) for the maintenance of indexes. Get familiar with the physical thresholds for optimal Indexes; approve the usage of Indexes within a few minutes and demonstrate the results to the vendors!

We will take a deep look into the dmos for the new Column Stored Indexes too!

SessionID: 36688

SharePoint Databases - What you need to know

Back to calendar

Event Date: 12-09-2015 - Session time: 10:00:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Al Eardley

Title: SharePoint Databases - What you need to know

Abstract:

An introduction to the different databases that SharePoint uses, with recommendations for High Availability, Disaster Recovery and configuration settings for SQL Server, including the constraints imposed in a single farm, a stretched farm between data centres and a separate DR farm.

SessionID: 13127

Hidden gems of SQL Server 2014

Back to calendar

Event Date: 12-09-2015 - Session time: 11:15:00 - Track: DBA (The Wall)

Speaker: Denis Reznik

Title: Hidden gems of SQL Server 2014

Abstract:

SQL Server 2014 is full of new features and improvements. Some of them are "Killer" features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.

SessionID: 17800

Introduction to MDX

Back to calendar

Event Date: 12-09-2015 - Session time: 11:15:00 - Track: BI (Wish You Were Here)

Speaker: Jens Vestergaard

Title: Introduction to MDX

Abstract:

Multi Dimensional eXtension (MDX) query language is still the most prominently used language, used to query Multi Dimensional Cubes. If you are ventouring into the world of MOLAP or taking over projects that contains cubes, this will bring you a basic understanding of the MDX language and hopefully give you a good platform to advance from.

Aspects covered in the session: • Select, From and Where clauses • Sets, Tuples, Members • Period, Hierarchy, String, Math and Filtering functions

SessionID: 27298

Building abstract layers for data protection and business logic

Back to calendar

Event Date: 12-09-2015 - Session time: 11:15:00 - Track: DEV (Animals)

Speaker: Uwe Ricken

Title: Building abstract layers for data protection and business logic

Abstract:

Many developers are working with direct access to the data layer of a database (tables) by ORM or .NET, Access, ... This access methode maybe a good choice for small applications which use a dedicated database where no security or business requirement is needed.

This session demonstrates the protection of data by using schemata for data protection and implementation of business logic for multiple applications. I will demonstrate the usage of schemata in an application life cycle to reuse codes for reporting in the same way as for the web application or the fat client application.

SessionID: 37013

AzureML: Welcome to the future of predictive analytics

Back to calendar

Event Date: 12-09-2015 - Session time: 11:15:00 - Track: BA (The Division Bell)

Speaker: Ruben Pertusa Lopez

Title: AzureML: Welcome to the future of predictive analytics

Abstract:

Predictive analytics is touching more and more lives every day. Machine Learning lets you predict and change the future. Do you know that Microsoft products like Xbox and Bing integrate some machine learning capabilities in their workflows? Come to the session and take a look of the new cloud-based machine learning platform called AzureML from a BI architect perspective, without all the data scientist knowledge.

Real machine learning solutions and some best practices when integrating ML on Apps and websites.

SessionID: 37102

Continuous Integration and the Data Warehouse

Back to calendar

Event Date: 12-09-2015 - Session time: 11:15:00 - Track: DEV (Animals)

Speaker: John Tunnicliffe

Title: Continuous Integration and the Data Warehouse

Abstract:

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects. In particular, the session will cover:

SessionID: 37905

Dealing With Errors in SSIS 2012

Back to calendar

Event Date: 12-09-2015 - Session time: 11:15:00 - Track: BI (Wish You Were Here)

Speaker: David Dye

Title: Dealing With Errors in SSIS 2012

Abstract:

Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail.

You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details

SessionID: 39971

Quick Start Guide to JavaScript Frameworks for SharePoint Apps

Back to calendar

Event Date: 12-09-2015 - Session time: 11:15:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Sonja Madsen

Title: Quick Start Guide to JavaScript Frameworks for SharePoint Apps

Abstract:

Learn about JavaScript frameworks and new developer practices in SharePoint and on Office 365. JavaScript frameworks are there for you to help you develop faster and easier. You don't need to do your apps from scratch.

Apps and the cloud app model have brought not only new ways to interact, send, write, and receive data from SharePoint. Apps have also brought JavaScript frameworks into SharePoint development. JavaScript frameworks are right there as part of the app template when you start a SharePoint hosted or a Cloud app. In this session, I'll show what you can do with JavaScript frameworks that are part of the app template. I'll show jQuery, Bootstrap, and modernizr.

SessionID: 39831

Introducing Azure SQL Data Warehouse

Back to calendar

Event Date: 12-09-2015 - Session time: 12:20:00 - Track: Cloud (Piper at the Gates of Dawn)

Speaker: James Rowland-Jones

Title: Introducing Azure SQL Data Warehouse

Abstract:

Microsoft recently launched a new service into Azure; SQL Data Warehouse. SQL Data Warehouse is a scale out, distributed database that can scale its compute resources on demand. Come to this session and learn all about it from the co-author of the official documentation https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-develop/

SessionID: 39832

Scale Out Data Warehouse QA with Big Bang Data Co

Back to calendar

Event Date: 12-09-2015 - Session time: 12:55:00 - Track: BI (Wish You Were Here)

Speaker: James Rowland-Jones

Title: Scale Out Data Warehouse QA with Big Bang Data Co

Abstract:

Got a question about Azure SQL Data Warehouse (SQLDW), Analytics Platform System (APS) and/or Parallel Data Warehouse (PDW)? Then this is the session for you! Big Bang Data Co are hosting an open QA session about these technologies where we aim to answer your questions. We will also have some fun give-aways too!

Please join us! Ask a question or just sit in, learn and share your experiences on Microsoft's distributed data platform. It's all good!

SessionID: 13817

Efficient Indexing Strategies

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: DBA (The Wall)

Speaker: Enrico van de Laar

Title: Efficient Indexing Strategies

Abstract:

Indexes are incredibly powerful objects to optimize your database performance. However, when not implemented optimally, indexes can also have a negative impact on your queries! In this session we will take a close look at the different index types, how they work and how we can use that knowledge to design an efficient indexing strategy for your databases. We will also spend time analyzing existing indexes. Are those indexes being used? Can we combine indexes? Those are some of the questions you will learn to answer in this session.

SessionID: 22842

SharePoint as a Business Intelligence platform

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Regis Baccaro

Title: SharePoint as a Business Intelligence platform

Abstract:

SharePoint – let’s admit it – is here to stay; It has become the business collaboration platform of choice for the enterprise and the binding element in the Office family of tools. However deploying and configuring can be a challenging task for the IT pro.

In this session we will walk through the configuration of a complete on-premises BI platform with SharePoint. We will configure different scenarios, and the technologies necessary for building the infrastructure. After this session you will be able to setup the applications and all the supporting services to make SharePoint a successful and performant BI platform. From Excel services to Kerberos delegation.

SessionID: 35733

How to build an IT operations expert

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: Other (A Momentary Lapse of Reason)

Speaker: Kennie Pontoppidan

Title: How to build an IT operations expert

Abstract:

My thesis in the Master of IT management program was about the life of IT operations people and how they learn.

Specifically I worked on the following three research questions:

  1. What is the difference between a normal IT operations professional and a true expert
  2. How can you make your IT operations professionals better
  3. What can you do to make your experts thrive

Come and hear about my results and how to make your IT operations professionals grow

SessionID: 35862

Digging Into the .Net SqlClient

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: DEV (Animals)

Speaker: Mladen Prajdić

Title: Digging Into the .Net SqlClient

Abstract:

The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? In this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader() and SqlCommand.ExecuteNonQuery().

SessionID: 37851

Datazen - An overview

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: BI (Wish You Were Here)

Speaker: Frank Geisler

Title: Datazen - An overview

Abstract:

Recently, in April 2015, Microsoft aquired the company Datazen a specialist for mobile BI. This aquisition enables Microsoft to offer mobile, self service BI tools for Windows, iOS, Andorid and HTML. Besides using BI solutions on mobile devices online it is also possible to use these BI solutions offline. SQL Server MVP Frank Geisler will give insights into how Datazen works and how you can build BI Dashboards on different Datasources. He will show how a Datazen Server is installed and configured and how the Datazen Apps work on Windows 8.

SessionID: 37907

Creating Dynamic Packages

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: BI (Wish You Were Here)

Speaker: David Dye

Title: Creating Dynamic Packages

Abstract:

In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table. Unfortunately this case is the exception rather than the rule. How can you use SSIS to:

  1. Iterate through all files in a folder and import their content into SQL
  2. Dynamically create and name table based on a data source
  3. Dynamically create a T-SQL statement at runtime based on run time conditions This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment. Each attendee will leave with the knowledge and toolset necessary to:
  4.  Use expressions within SSIS packages
    
  5.  Use variables to dynamically create SQL statements
    
  6.  Configure custom dynamic logging
    
  7.  Use package configurations and parameters and environments to make packages more portable at execution
    
  8. Replace dynamic SQL using expressions in SSIS

SessionID: 39975

Re-engineering the SharePoint Migration

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Corey Burke

Title: Re-engineering the SharePoint Migration

Abstract:

This session will discuss a high level overview of the migration process, the steps involved, and examine the many ways in which PowerShell can help reduce the time and pain associated with large scale Farm migrations. This will include live PowerShell demonstrations of the concepts being discussed throughout the session.

SessionID: 40583

No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: DBA (The Wall)

Speaker: André Kamman

Title: No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt

Abstract:

One of my client engagements lately was about replaying a workload. The system had so many batches per second that I couldn't actually do a replay but had to run in stress mode and try to slow down the replay in such a way that it resembled the production system.

I'll show you how to do that amongst a bunch of other things that I learned and would love to share with you. If you are thinking about using OSTRESS / RML Utilities to analyse your system and stress test it on a different machine to find bottlenecks, then this session is for you.

SessionID: 9345

Azure Data Factory - The New SSIS?

Back to calendar

Event Date: 12-09-2015 - Session time: 13:30:00 - Track: BA (The Division Bell)

Speaker: Allan Mitchell

Title: Azure Data Factory - The New SSIS?

Abstract:

For a long time people have been asking where is SSIS for the cloud. Truth is it was never going to happen. Azure Data Factory has been designed from the ground up. It is designed for moving data at scale and with agility. Come to this session to learn about this new service and how it come provide value to your business processes

SessionID: 15411

Understanding Solving Columnstore Problems

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: DBA (The Wall)

Speaker: Niko Neugebauer

Title: Understanding Solving Columnstore Problems

Abstract:

Dive deep into Columnstore Indexes and discover their advantages and some of the limitations.

Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode Query Processing with another depth.

Can you make your Columnstore queries ran even faster ? Can you actually lower the Degree of Parallelism and get a better performance ? How much memory does Columnstore Index actually use when working with queries ? How can you test your Columnstore queries in Row Mode and what is the actual difference between Row Batch Modes.

The answers on those questions are to be revealed at this session.

SessionID: 17288

Building your first Microsoft Azure IaaS infrastructure

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: Cloud (Piper at the Gates of Dawn)

Speaker: John Martin

Title: Building your first Microsoft Azure IaaS infrastructure

Abstract:

Want to get your systems to the cloud, not entirely sure how to go about it? Let me guide you through the design considerations and process for building a Highly Available and resilient SQL Server infrastructure, looking at entirely cloud based and hybrid options. By the end of this session we will not only have discussed, but actually built and deployed a HA/DR SQL infrastructure and website that accesses it.

SessionID: 17799

Scaling out Analysis Services

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: BI (Wish You Were Here)

Speaker: Jens Vestergaard

Title: Scaling out Analysis Services

Abstract:

Experience how Maersk Line implemented a best practice installation on the SQL Server Stack. Focus in this session will be on three major aspects of delivering a smoothly running platform, from an IT perspective.

How to accommodate for: A) A large number of Business Users simultaneous hitting the servers B) Keeping a high frequency processing/synchronization pipeline C) Ease of management

SessionID: 23536

Taking your application to memory

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: DEV (Animals)

Speaker: Rasmus Reinholdt

Title: Taking your application to memory

Abstract:

Based on our work with converting an existing application to memory optimized tables and natively compiled stored procedures this session, will take you through this journey and show you the (large) gaps between what we have in our normal SQL belt and what is possible in Natively compiled stored procedures. I will show how to overcome all the gaps and get all out normal stuff to work in these monster fast procedures – even the things that the documentation says cannot be done.

You will therefore be taken through the concept of in-memory tables and what to be aware of when considering converting your database tables and code to In-Memory tables and through a life migration demo be given all the tips and tricks I picked up while doing so. After attending this session, you will be able to leverage on the new concepts and work your way around its current limitations to gain enormous speed increase and a lock-free environment.

SessionID: 27001

Benefits of analytics using Microsoft Azure Machine Learning

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: BA (The Division Bell)

Speaker: Tomaž Kaštrun

Title: Benefits of analytics using Microsoft Azure Machine Learning

Abstract:

Data mining on-premises has a long tradition with Microsoft SQL Server and Machine learning in Azure is the cloud based brother, both supporting a hand-full of great algorithms for your business to grow.

This session will be focused on benefits of building a predictive model using Azure Machine Learning (ML) studio and exploring its capabilities. We will cover from 1) Quick introduction to ML to 2) creating ML workspace with data upload, 3) training the data-set and evaluating the solutions/models and 4) using this solutions with ML API Service. With a great support to R language in Azure ML, we will also explore the usage of R script in Azure ML.

SessionID: 36720

Extending SharePoint solutions: Without spending money

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Penelope Coventry

Title: Extending SharePoint solutions: Without spending money

Abstract:

SessionID: 37014

A journey through the Modern Data Warehouse

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: BI (Wish You Were Here)

Speaker: Ruben Pertusa Lopez

Title: A journey through the Modern Data Warehouse

Abstract:

The traditional data warehouse has been the key of our business analytics architecture for many years. In a world ruled by the data culture concept, new challenges are emerging: data growth; unstructured data; hidden patterns and cloud-born data.

Which is the best architecture in order to get over these new challenges? Join this session and learn how to enable the Modern Data Warehouse in your organization using Cubes, HDInsight, AzureML, Stream Analytics and DocumentDB. All through a continuous example using a retail shop scenario.

SessionID: 39980

Office 365 - The Art of the Possible

Back to calendar

Event Date: 12-09-2015 - Session time: 14:45:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Al Eardley

Title: Office 365 - The Art of the Possible

Abstract:

Office 365 has many different capabilities that have historically been separated into different products. The convergence of the products on one platform is opening up new possibilities for collaborating in new, more effective ways.

This session will explain some of the ways that Office 365 is being used and demonstrate some of the capabilities that convince millions of companies to invest in Office 365 to replace existing products with a single unified environment making the most of the familiar business critical tools from Microsoft.

SessionID: 10370

Dive into the Query Optimizer-Undocumented Insight

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: DEV (Animals)

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer-Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 11501

SQL Server Batch Mode and CPU Architectures

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: DEV (Animals)

Speaker: Christopher Adkin

Title: SQL Server Batch Mode and CPU Architectures

Abstract:

This has a simple demonstration using two columns stores created on the same data, but with the larger one out performing the smaller one when used in the same query, this 'Hook' leads onto a deep dive into how modern CPU architectures are designed how they work and how batch mode leverages these, culminating in where the batch mode CPU pressure point is.

SessionID: 23538

Optimizing BI with SQL2014 In-Memory tables

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: BI (Wish You Were Here)

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 intensive session takes you through the new possibilities In-Memeory tables and Native Compiled Stored Procedures opens up to us from a BI point of view - covering both the ETL and (R)OLAP angels of the BI process.

SessionID: 26998

Blue Sky Thinking: SQL Azure Geospatial Mashup

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: Cloud (Piper at the Gates of Dawn)

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

Visualizing streaming data in real time

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: BI (Wish You Were Here)

Speaker: Mladen Prajdić

Title: Visualizing streaming data in real time

Abstract:

We're all familiar with reports or dashboards that show you a static snapshot of the data

that has to be refreshed on an interval. And those are very important visualizations. But sometimes you just have to have a real time view of your data streams and snapshots aren't enough. What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and be able to see it all happening live on a central monitoring website? This is a scenario we'll take a detailed look at and build a system for such monitoring. We'll do this by using Extended Events .Net provider to get the live data stream, SignalR to get the live stream from the server to the website and the D3 javaScript library for actual real time visualizations on any device. After seeing all this in action, you'll definitely get a few ideas on where you could use this in your company.

SessionID: 37337

SharePoint - Migrating Databases and Farm Configuration using PowerShell

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: Anthony Obi

Title: SharePoint - Migrating Databases and Farm Configuration using PowerShell

Abstract:

The session will first cover how to go about transferring SQL Databases between SharePoint Farms using PowerShell. Including common scenarios, approaches and potential gotchas, as well as some example scripts.

It will then move on to cover the often manual task of replicating Service Application Configurations between SharePoint Farms and demonstrate how this can also be simplified and automated with the use of PowerShell.

SessionID: 39981

Visualising SharePoint and SQL Data with Visio Professional

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: SharePoint (Dark Side of the Moon)

Speaker: David Parker

Title: Visualising SharePoint and SQL Data with Visio Professional

Abstract:

David will demonstrate how easy it is to not only visualise data from SQL Server and SharePoint, on-prem. or in the cloud, with Visio 2013+ Professional , but how you can use structured diagrams and validation rules to create data for your database from a drawing. He will also demonstrate how Visio diagrams stored in SharePoint 2013+ can be become interactive dashboards available on any modern device and in any modern browser.

SessionID: 9341

HBase on HDInsight

Back to calendar

Event Date: 12-09-2015 - Session time: 16:00:00 - Track: BA (The Division Bell)

Speaker: Allan Mitchell

Title: HBase on HDInsight

Abstract:

Microsoft have made available HBase on HDInsight. Use HBase when you need random, realtime read/write access to your Big Data. host very large tables -- billions of rows X millions of columns on your HDInsight cluster. Come to this session to find out more.