sqlsathistory

Nr: 280

Back to Main list

SQLSaturday #280 - Vienna 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Boris Hristov	A - Administration	Replay your workload as it's your actual one!
00:00:00	Boris Hristov	A - Administration	The nightmare of locking, blocking and isolation levels!
00:00:00	Constantin Klein	D - Development	SQL Server Data Tools - The IDE for database developers
00:00:00	Dejan Sarka	D - Development	Temporal Data in SQL Server
00:00:00	Niko Neugebauer	A - Administration	Clustered Columnstore Deep Dive
00:00:00	Inna Selipanov	D - Development	Product-Demo: MelissaData
00:00:00	Jen Stirrup	C - Cloud	WiT-Panel
00:00:00	Jen Stirrup	C - Cloud	The 'Secret Sauce' in your Big Data: R, HDInsight and PowerBI
00:00:00	Kennie Pontoppidan	D - Development	SQL anti patterns
00:00:00	Markus Ehrenmueller-Jensen	D - Development	Opening Keynote
00:00:00	Peter Myers	B - Business Intelligence Big Data	Preparing a Tabular Data Model for Power View Reporting
00:00:00	Regis Baccaro	C - Cloud	ETL for the masses with Power Query and "M"
00:00:00	Rasmus Reinholdt	B - Business Intelligence Big Data	Optimizing BI with SQL2014 In-Memory tables
00:00:00	Rudolf Brandstötter	A - Administration	Product-Demo: Idera
00:00:00	Scott Klein	C - Cloud	SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive
00:00:00	Scott Klein	C - Cloud	Windows Azure SQL Database - your cloud database and why you need it
00:00:00	Gerhard Brueckl	C - Cloud	Scaling Analysis Services in the Cloud
00:00:00	Tillmann Eitelberg	B - Business Intelligence Big Data	Siena calling! Project Siena a RBID App?
00:00:00	Kevin Boles	D - Development	Windowing Functions: THE Reason to Upgrade to 2012
00:00:00	Kevin Boles	A - Administration	Indexing Deep Dive
00:00:00	Wolfgang Ennikl	B - Business Intelligence Big Data	Product-Demo: cubido
00:00:00	Wolfgang Rick Kutschera	A - Administration	SQL2014 InMemory OLTP - Features, Limitations, Reasons and Workarounds
00:00:00	Andrey Zavadskiy	B - Business Intelligence Big Data	MDS + DQS + SSIS = EIM or How to build master data management solution

SessionID: 10919

Replay your workload as it's your actual one!

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: A - Administration

Speaker: Boris Hristov

Title: Replay your workload as it's your actual one!

Abstract:

Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there's a feature for that! It's called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!

SessionID: 10920

The nightmare of locking, blocking and isolation levels!

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: A - Administration

Speaker: Boris Hristov

Title: The nightmare of locking, blocking and isolation levels!

Abstract:

I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a real nightmare! In this session, you will be able to see and understand why and how locking actually works, what problems it causes and how can we use isolation levels and various other techniques to resolve them!

SessionID: 11790

SQL Server Data Tools - The IDE for database developers

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: D - Development

Speaker: Constantin Klein

Title: SQL Server Data Tools - The IDE for database developers

Abstract:

Since March 2012, SQL Server Data Tools (SSDT) are available for database developers as a project-based development environment within Visual Studio.

Although SSDT is installed automatically with Visual Studio 2012, this method of database development and the functions provided are completely new to many developers.

This session aims to change that and to provide an overview of the advantages and potentials of SSDT. You will see how you can develop, debug, refactor, deploy and maintain SQL Server and Azure databases from a single IDE.

SessionID: 13528

Temporal Data in SQL Server

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: D - Development

Speaker: Dejan Sarka

Title: Temporal Data in SQL Server

Abstract:

Although temporal data is part of many business applications, most RDBMS’, including SQL Server, do not support it out of the box. However, SQL Server provides full infrastructure to build your own temporal data support. After introduction of temporal problems, we are going to develop interval CLR data type that supports validity time. Then we are going to discuss what kind of constraints pertain to temporal data, and how we can implement those constraints. We are going to use T-SQL to develop two very useful temporal operators: PACK and UNPACK. In addition, we are going to introduce the proposed sixth normal form that deals with temporal data, and show how you can implement it correctly.

SessionID: 15408

Clustered Columnstore Deep Dive

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: A - Administration

Speaker: Niko Neugebauer

Title: Clustered Columnstore Deep Dive

Abstract:

When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.

SessionID: 15430

Product-Demo: MelissaData

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: D - Development

Speaker: Inna Selipanov

Title: Product-Demo: MelissaData

Abstract:

Product-Demo: MelissaData

SessionID: 16404

WiT-Panel

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: C - Cloud

Speaker: Jen Stirrup

Title: WiT-Panel

Abstract:

Women in Technology

SessionID: 16408

The 'Secret Sauce' in your Big Data: R, HDInsight and PowerBI

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: C - Cloud

Speaker: Jen Stirrup

Title: The 'Secret Sauce' in your Big Data: R, HDInsight and PowerBI

Abstract:

Big Data is not so much about storing massive amounts of data in a common database. It is also a force of change for the organisation, and it means that we have to consider the collective capabilities of the platform to serve the business: from data source to secret sauce to help the business to make data-driven decisions to drive the enterprise forward. How can you get your organisation's secret sauce? Data scientists need a way of combining the scalability of Big Data with the ability to conduct extensive data analysis to obtain the 'secret sauce'. In this session, we will look at R, the world's favourite free data analysis tool, and HDInsight, which is Microsoft's distribution of Hadoop. In this session, we will look at an end-to-end solution to discover our secret sauce from data ingredients. We will then visualise the results in Microsoft's latest BI toolset, Power BI.

SessionID: 18116

SQL anti patterns

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: D - Development

Speaker: Kennie Pontoppidan

Title: SQL anti patterns

Abstract:

You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet.

We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.

SessionID: 19685

Opening Keynote

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: D - Development

Speaker: Markus Ehrenmueller-Jensen

Title: Opening Keynote

Abstract:

Opening and Keynote

SessionID: 21998

Preparing a Tabular Data Model for Power View Reporting

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: B - Business Intelligence Big Data

Speaker: Peter Myers

Title: Preparing a Tabular Data Model for Power View Reporting

Abstract:

This presentation will describe how to prepare a tabular data model (PowerPivot or Tabular Project) to fully exploit the reporting capabilities of Power View. Theory and demonstrations will describe why and how to configure the Reporting Properties, and how to enable images to surface within Power View reports.

SessionID: 22831

ETL for the masses with Power Query and "M"

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: C - Cloud

Speaker: Regis Baccaro

Title: ETL for the masses with Power Query and "M"

Abstract:

Power Query allows users to incorporate public data and organizational data seamlessly in Excel. The purpose of this session is to take a deeper dive into the capabilities of Power Query and of the "M" language.

The more I use Power Query and the M language that underpins it, the more I see how useful it is – quite apart from its abilities to import data from other data sources – as a third option to solve problems in Excel itself. Furthermore it provides a simple interface over the data transformation engine (powered by M), and it has become a tool of choice anytime I need to get data into Excel. In this demo-driven session I will show how you can use Power Query to do some initial data shaping, visualize, and then automate the data loading process through SSIS.

SessionID: 23508

Optimizing BI with SQL2014 In-Memory tables

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: B - Business Intelligence Big Data

Speaker: Rasmus Reinholdt

Title: Optimizing BI with SQL2014 In-Memory tables

Abstract:

Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can't optimize our BI solutions with this new feature.

This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process. The session will use the latest CTP release and is constantly updated to include the latest news on the topic.

SessionID: 23571

Product-Demo: Idera

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: A - Administration

Speaker: Rudolf Brandstötter

Title: Product-Demo: Idera

Abstract:

Product-Demo: Idera

SessionID: 24176

SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: C - Cloud

Speaker: Scott Klein

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Abstract:

Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine.

SessionID: 24177

Windows Azure SQL Database - your cloud database and why you need it

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: C - Cloud

Speaker: Scott Klein

Title: Windows Azure SQL Database - your cloud database and why you need it

Abstract:

This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how the database formally known as SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about.

SessionID: 25106

Scaling Analysis Services in the Cloud

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: C - Cloud

Speaker: Gerhard Brueckl

Title: Scaling Analysis Services in the Cloud

Abstract:

Over the last years Analysis Services has proven its scalability with big data volumes and also with many users. Those high-end solutions are usually very strongly tied to the hardware they are running on. When moving those solutions to the cloud we need to reconsider this whole setup as a single on-premise hardware still outperforms a cloud machine by far. In order to achieve the same overall performance we need to scale out our Analysis Services instances across multiple hosts in the cloud and that's what this session is about.

SessionID: 25971

Siena calling! Project Siena a RBID App?

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: B - Business Intelligence Big Data

Speaker: Tillmann Eitelberg

Title: Siena calling! Project Siena a RBID App?

Abstract:

With Project Siena Microsoft has introduced a beta release of a new technology for business experts, business analysts, consultants, and other app imagineers. This session will review if Siena is useful for Business analysts. We will show how to combine simple app development (Rapid R Business Intelligence BI Development D) with different data sources from Excel Sheets (Power Query driven) , RSS Feeds, SharePoint Lists or Windows Azure Tables and how to deploy your little app in minutes. We will discuss the use cases of Siena from a BI perspective, what you can do already and what is missing.

SessionID: 26397

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: D - Development

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 26399

Indexing Deep Dive

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: A - Administration

Speaker: Kevin Boles

Title: Indexing Deep Dive

Abstract:

Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.

SessionID: 27552

Product-Demo: cubido

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: B - Business Intelligence Big Data

Speaker: Wolfgang Ennikl

Title: Product-Demo: cubido

Abstract:

Product-Demo: cubido

SessionID: 27553

SQL2014 InMemory OLTP - Features, Limitations, Reasons and Workarounds

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: A - Administration

Speaker: Wolfgang Rick Kutschera

Title: SQL2014 InMemory OLTP - Features, Limitations, Reasons and Workarounds

Abstract:

The session is centered around what was codenamed "Hekaton", the SQL 2014 inMemory OLTP Engine. It Shows an overview of the most critical Feature Areas (from a Migration Point of view), Shows the limitations of those Features and Workarounds where they exist. There will also be a Focus on explaining the reasons and thoughts behind some limitations.

SessionID: 28301

MDS + DQS + SSIS = EIM or How to build master data management solution

Back to calendar

Event Date: 06-03-2014 - Session time: 00:00:00 - Track: B - Business Intelligence Big Data

Speaker: Andrey Zavadskiy

Title: MDS + DQS + SSIS = EIM or How to build master data management solution

Abstract:

The process of entering data into corporate dictionary is not as simple as you can see at the first glance. Just imagine the process of collection information about the new retail store. It starts from discovering the possible place, then estimating the size, format and revenue, making a decision to buy or rent this place and so on. At the end you have to liquidate the goods remained unsold, reassign you workers to another store, demount all equipment, close accounts, etc. This process may involve 5, 10 and even 20 different workers who collect and enter different pieces of information about a retail store.

At this session we will talk about the approaches of creating a master data management solution and take a look at the implementation with the services of Microsoft SQL Server 2012.

This site is open source. Improve this page.