sqlsathistory

Nr: 551

Back to Main list

SQLSaturday #551 - Holland 2016

Start Time (24h)	Speaker	Track	Title
09:00:00	William Durkin	Enterprise Database Administration Deployment	You don't need Enterprise Edition to do that!
09:00:00	Jan Van humbeek	BI Platform Architecture, Development Administration	Bridging the gap - Introducing Mobile Reports
09:00:00	Koos van Strien	BI Platform Architecture, Development Administration	Connect your Shack: Building a Poor Man's IoT
09:00:00	André Melancia	Analytics and Visualization	If a machine can learn, why can't YOU learn Azure Machine Learning?
09:00:00	Ola Hallengren	Enterprise Database Administration Deployment	Building a Performance Monitoring System Using XEvents
10:15:00	Joost van Rossum	BI Platform Architecture, Development Administration	Using PowerShell for SSIS
10:15:00	Joseph D'Antoni	Cloud Application Development Deployment	Flying Through the Clouds--Performance Tuning in Azure
10:15:00	Jan Pieter Posthuma	Analytics and Visualization	Extending Power BI via the REST API and Power BI Embedded
10:15:00	Arthur Baan	Enterprise Database Administration Deployment	What’s new in SQL Server 2016 Availability Groups
10:15:00	Klaus Aschenbrenner	Enterprise Database Administration Deployment	Latches Spinlocks
11:30:00	James Rowland-Jones	Cloud Application Development Deployment	A developers guide to Azure SQL Data Warehouse
11:30:00	Enrico van de Laar	Enterprise Database Administration Deployment	Introducing the SQL Server 2016 Query Store
11:30:00	Lord Richard Douglas	Application Database Development	Natural Born Killers, Performance Issues to Avoid
11:30:00	Remko de Boer	BI Platform Architecture, Development Administration	Master Data Services: Onbekend maakt Onbemind
11:30:00	Jose Manuel Jurado Diaz	Enterprise Database Administration Deployment	SQL SERVER - Next station Azure
13:30:00	Christopher Adkin	Enterprise Database Administration Deployment	Super Scaling the LMax Queuing Pattern With SQL Server
13:30:00	n/a n/a	Analytics and Visualization	Session Details not available
13:30:00	Andre Batista	Application Database Development	Temporal Data in SQL Server 2016: Why, where and how we should use it ?
13:30:00	Torsten Strauss	Professional Development	Query Optimizer (engl)
13:30:00	John Tunnicliffe	BI Platform Architecture, Development Administration	Continuous Integration and the Data Warehouse
14:45:00	John Martin	Enterprise Database Administration Deployment	Securing SQL Server, Patterns and Practices
14:45:00	Henk van der Valk	BI Platform Architecture, Development Administration	SQL Server 2016 Polybase- Benefits how to get started?
14:45:00	Uwe Ricken	Application Database Development	Mastering DML Operations like a master
14:45:00	Sebastian van den Putten	Application Database Development	NoLock, What does it exactly do ?
14:45:00	Rik Opdam	Cloud Application Development Deployment	Streaming Fast data with SQL Server Azure
16:00:00	Pass NL	Enterprise Database Administration Deployment	QA DBA
16:00:00	Pass NL	Application Database Development	QA DB Development
16:00:00	Pass NL	BI Platform Architecture, Development Administration	QA BI
16:00:00	Pass NL	Cloud Application Development Deployment	QA Cloud

SessionID: 49437

You don't need Enterprise Edition to do that!

Back to calendar

Event Date: 15-10-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: William Durkin

Title: You don't need Enterprise Edition to do that!

Abstract:

The most coveted features of SQL Server are made available in Enterprise Edition and are sometimes released into Standard Edition a few years later. This often leaves a vast group of users who "window shop" the latest and greatest features and return to the office wishing they never saw those features presented.

This session will show you how you can achieve the same, or at least a similar, outcome to some of those features without having to fork out for Enterprise Edition licenses or breaking any license agreements.

You will leave the session with a set of solution concepts covering Partitioning, Data Compression and High Availability that you can build upon or extend and maybe save you and your company a nice pile of cash.

SessionID: 49531

Bridging the gap - Introducing Mobile Reports

Back to calendar

Event Date: 15-10-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jan Van humbeek

Title: Bridging the gap - Introducing Mobile Reports

Abstract:

As Microsoft continues to invest in its presence on the mobile end of the BI spectrum, it manages to think beyond just mobile.

An added layer of integration has been put in place between the revamped Reporting Services and Mobile Reports (Datazen reincarnate). We'll show you how you start from your existing SSRS reports and leverage that information onto mobile-friendly reports.

SessionID: 51033

Connect your Shack: Building a Poor Man's IoT

Back to calendar

Event Date: 15-10-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Koos van Strien

Title: Connect your Shack: Building a Poor Man's IoT

Abstract:

Azure IoT is here, and here's one thing MS has done very well: the integration with Azure Service Bus, Event Hub and Power BI. In this session, we start with a high-level overview of IoT stuff (protocols, mesh networks, sensors, etc.) and discuss architecture of an IoT solution. Finally, we'll look at a small Proof of Concept I've built to connect my home without spending too much: the "Poor Man's IoT".

SessionID: 53801

If a machine can learn, why can't YOU learn Azure Machine Learning?

Back to calendar

Event Date: 15-10-2016 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: André Melancia

Title: If a machine can learn, why can't YOU learn Azure Machine Learning?

Abstract:

Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?

AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too... Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.

SessionID: 54467

Building a Performance Monitoring System Using XEvents

Back to calendar

Event Date: 15-10-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ola Hallengren

Title: Building a Performance Monitoring System Using XEvents

Abstract:

You are using Extended Events and dynamic management views (DMVs) to analyze performance problems in your databases. How do you go from there to building a performance-monitoring system that is easy to use and that works at scale? In this session, learn techniques for loading and parsing Extended Events into a central monitoring database in close to real time, correlating the events with query plans, indexing the data for performance, and making the information easily available.

SessionID: 50296

Using PowerShell for SSIS

Back to calendar

Event Date: 15-10-2016 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Joost van Rossum

Title: Using PowerShell for SSIS

Abstract:

This sessions shows you all the benefits when using PowerShell with(in) SSIS. Use it for deploying enviroments and projects, for maintenance or for example as a source within an SSIS package. Lot's of demo's and just a few slides. Contact me via my blog or twitter if you have an SSIS PowerShell challence for me to show during this presentation.

SessionID: 50362

Flying Through the Clouds--Performance Tuning in Azure

Back to calendar

Event Date: 15-10-2016 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Joseph D'Antoni

Title: Flying Through the Clouds--Performance Tuning in Azure

Abstract:

So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:

• Optimizing TempDB in an Azure VM • Reducing latency between application VMs and database VMs • Right sizing Azure VMs for performance and cost • Striping I/O across devices in Azure VMs • Performance Tuning in Azure DB

You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.

SessionID: 50990

Extending Power BI via the REST API and Power BI Embedded

Back to calendar

Event Date: 15-10-2016 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: Jan Pieter Posthuma

Title: Extending Power BI via the REST API and Power BI Embedded

Abstract:

Nowadays Power BI can be called via an API. The API provides the capability of delivering real-time dashboarding scenarios via REST or an easy way to integrate Power BI reports in your application via Power BI embedded.

During this session I will show the possibilities of the API and how it can be integrated with Azure services, like Stream Analytics and AzureML, or embedded into a custom .NET application with Power BI Embedded to provide either a real-time dashboard for Business and/or IoT scenarios or custom solutions with integrated Power BI dashboards.

SessionID: 53806

What’s new in SQL Server 2016 Availability Groups

Back to calendar

Event Date: 15-10-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Arthur Baan

Title: What’s new in SQL Server 2016 Availability Groups

Abstract:

With the introduction of SQL Server 2016 there are many improvements like a better failure detection, synchronization improvements for better performance and load balancing readonly replicas. Some of the new features include the basic Availability Groups, direct seeding and distributed Availability Groups. In this session (with demos!) we will look at these features and their pros and cons.

SessionID: 54333

Latches Spinlocks

Back to calendar

Event Date: 15-10-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Klaus Aschenbrenner

Title: Latches Spinlocks

Abstract:

Latches Spinlocks

SessionID: 49468

A developers guide to Azure SQL Data Warehouse

Back to calendar

Event Date: 15-10-2016 - Session time: 11:30:00 - Track: Cloud Application Development Deployment

Speaker: James Rowland-Jones

Title: A developers guide to Azure SQL Data Warehouse

Abstract:

Azure SQL Data Warehouse is a scale out database service designed to answer your ad hoc queries and questions. By spreading your data across distributions SQL Data Warehouse is designed for analytics at scale. To make the most of your database there are opportunities to tailor your table design and optimize for performance. This session will cover the fundamentals of data distribution, table design and query optimization; helping you to deliver the best performance for your solution.

SessionID: 49496

Introducing the SQL Server 2016 Query Store

Back to calendar

Event Date: 15-10-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Enrico van de Laar

Title: Introducing the SQL Server 2016 Query Store

Abstract:

With the release of the public preview versions of SQL Server 2016 we were finally able to play with, in my opinion, one of the most exciting new features in SQL Server 2016, the Query Store! The Query Store serves as a flight recorder for your query workload and provides valuable insights into the performance of your queries. It doesn’t stop there however, using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query. If those two features aren’t enough, the Query Store provides all this information inside easy-to-use reports and Dynamic Management Views (DMVs) removing a great deal of the complexity of query performance analysis.

During this session we will take a thorough look at the Query Store, it’s architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you!

SessionID: 50382

Natural Born Killers, Performance Issues to Avoid

Back to calendar

Event Date: 15-10-2016 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Lord Richard Douglas

Title: Natural Born Killers, Performance Issues to Avoid

Abstract:

Learning SQL is easy, mastering it is hard. In this session you’ll learn simple but effective tricks to design your database objects better and write more optimized code. As an attendee you will gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.

Ever thought that you were adhering to best practices but still seeing performance problems? You might well be. In this session I will be covering why the optimizer isn’t using all available processors, when the database engine fails to report all the resources a query has used and why the optimizer doesn’t always use the best plan.

You will leave this session with a list of things that you can check for in your environment to improve performance for your users.

SessionID: 50412

Master Data Services: Onbekend maakt Onbemind

Back to calendar

Event Date: 15-10-2016 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Remko de Boer

Title: Master Data Services: Onbekend maakt Onbemind

Abstract:

Master Data Services (MDS) bestaat al sinds SQL 2008, maar wordt vaak niet gebruikt. Vo0ornamelijk vanwege de onbekendheid van MDS. En dat terwijl MDS veel van de beheer vraagstukken kan beantwoorden. Zeker gezien de nieuwe features in SQL Server 2016 is MDS een oplossing waar veel organisaties baad bij kunnen hebben. In deze sessie worden verschillende scenario's getoond hoe MDS een BI omgeving kan versterken.

SessionID: 52566

SQL SERVER - Next station Azure

Back to calendar

Event Date: 15-10-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jose Manuel Jurado Diaz

Title: SQL SERVER - Next station Azure

Abstract:

This session will cover the main aspects to start or migrate from an OnPremise model to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment for our requirements.

We will cover:

1. Red pill or blue pill SQL Server on Azure VM (IaaS) vs SQL Azure DB (PaaS) Which one?
2. Always available. High availability in Azure
3. Now what ... Best practices and configuration connectivity.

SessionID: 49585

Super Scaling the LMax Queuing Pattern With SQL Server

Back to calendar

Event Date: 15-10-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Christopher Adkin

Title: Super Scaling the LMax Queuing Pattern With SQL Server

Abstract:

This session will cover how implement a high performance queue via the LMax queuing pattern with both the legacy row store engine and the in-memory OLTP engine. With the aim of squeezing every last ounce of performance out of the database engine, this session will cover database engine internals at a deep level and make use of stack traces and windows performance tool kit. The session will also cover spin locking and principles which will before other types of exacting OLTP workloads.

SessionID: 51015

Session Details not available

Back to calendar

Event Date: 15-10-2016 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: n/a n/a

Title: Session Details not available

Abstract:

Session Details not available

SessionID: 52821

Temporal Data in SQL Server 2016: Why, where and how we should use it ?

Back to calendar

Event Date: 15-10-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Andre Batista

Title: Temporal Data in SQL Server 2016: Why, where and how we should use it ?

Abstract:

Temporal Data is one of the new features that got released on the new SQL Server 2016 version that will allow users to audit data changes over time. With this feature, it will be possible, to see our records on a "point-in-time" perspective.

In this session i will cover some scenarios of why we should use this feature, in what kind of system and how we can implement it. Also i will show you how we can audit data, or even recover some data that got updated or deleted by mistake.

SessionID: 53021

Query Optimizer (engl)

Back to calendar

Event Date: 15-10-2016 - Session time: 13:30:00 - Track: Professional Development

Speaker: Torsten Strauss

Title: Query Optimizer (engl)

Abstract:

Despite of the fact the Query Optimizer represents one of the core features of SQL Server there is only little know about the internals. In this session we will deal with the different tasks, methods and phases of this important feature. The knowledge will leverage the tuning of query plans but will also emphasize the limits of the query engine.

The session (level 300 – 400) assumes that you are familiar with the fundamentals of the query plan.

SessionID: 53274

Continuous Integration and the Data Warehouse

Back to calendar

Event Date: 15-10-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

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:

• Setting up SQL Server Data Tools for automated deployments: DAC Publish profiles SQLPackage.exe

• Automating your build and deployments with PowerShell and psake

• Guide to configuring TeamCity as your build server

• Automated Integration and Regression testing of your Data Warehouse using NBi test framework

• Automating cube and tabular model deployment

SessionID: 49443

Securing SQL Server, Patterns and Practices

Back to calendar

Event Date: 15-10-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: John Martin

Title: Securing SQL Server, Patterns and Practices

Abstract:

Security is at the forefront of many organizations minds, but there are many options to choose from and getting a security configuration right can take time and effort. Let me give you a head start when it comes to helping secure your SQL Servers from the malicious, inquisitive, and opportunists.

Starting with a good security baseline configuration that you can then build on is vital, it provides a strong foundation on which to build more robust configurations. I will show you how to secure data during transmission, and at rest, demonstrating how to get Manages Service Accounts to work for your systems. From here we look at securing systems for PCI-DSS and PII that falls under the data protection act, two of the main compliance requirements encountered today.

After attending this session, you will be in a strong position to effectively secure your SQL Server systems.

Security should be the rule, not the exception, together we can make this happen.

SessionID: 49560

SQL Server 2016 Polybase- Benefits how to get started?

Back to calendar

Event Date: 15-10-2016 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Henk van der Valk

Title: SQL Server 2016 Polybase- Benefits how to get started?

Abstract:

SQL PolyBase has been an high-end feature for SQL APS and now also introduced in SQL2016! It allows you to use regular T-SQL statements to ad-hoc access data stored in Hadoop and/or Azure Blob Storage from within SQL Server. This session will show you how it works how to get started!

SessionID: 49634

Mastering DML Operations like a master

Back to calendar

Event Date: 15-10-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Uwe Ricken

Title: Mastering DML Operations like a master

Abstract:

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

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

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

SessionID: 53064

NoLock, What does it exactly do ?

Back to calendar

Event Date: 15-10-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Sebastian van den Putten

Title: NoLock, What does it exactly do ?

Abstract:

It must be the most common query-hint but exactly why; what does it do?

In this 60 minutes talk, the NoLock-hint will be explained. Starting simplistic with explaining the way the ignoring locks works, quick touch on isolation-levels and continue with more difficult example and concept; Read-Past, Ghost-Reads and even duplicate reads. Only to end with how the 'magic speed' comes to be and what other ways can used to achieve the extra speed.

SessionID: 53879

Streaming Fast data with SQL Server Azure

Back to calendar

Event Date: 15-10-2016 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Rik Opdam

Title: Streaming Fast data with SQL Server Azure

Abstract:

Providing the right data at the right time is critical to creating value from business intelligence or operational intelligence. As we record and generate a growing amount of data every millisecond, we also need to be able to understand this data just as quickly. By “Fast Data” we’re talking about as-it-happens information enabling real-time decision-making. In this session we discuss the cloud architecture of streaming technology, in Azure and on premise , with StreamInsight.

SessionID: 54049

QA DBA

Back to calendar

Event Date: 15-10-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Pass NL

Title: QA DBA

Abstract:

If you have a question related to database administration. This is the time to get answers. Most, if not all, presenters in the field of database administration will be present to answer them

SessionID: 54050

QA DB Development

Back to calendar

Event Date: 15-10-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Pass NL

Title: QA DB Development

Abstract:

If you have a question related to database development. This is the time to get answers. Most, if not all, presenters in the field of database development will be present to answer them

SessionID: 54051

QA BI

Back to calendar

Event Date: 15-10-2016 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Pass NL

Title: QA BI

Abstract:

If you have a question related to BI. This is the time to get answers. Most, if not all, presenters in the field of business intelligence will be present to answer them.

SessionID: 54052

QA Cloud

Back to calendar

Event Date: 15-10-2016 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Pass NL

Title: QA Cloud

Abstract:

If you have a question related to cloud technology. This is the time to get answers. Most, if not all, presenters in the field of cloud technology will be present to answer them

This site is open source. Improve this page.