sqlsathistory

Nr: 359

Back to Main list

SQLSaturday #359 - Istanbul 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Belkis Ozhorasan	Adara	Easy Way of Data Consumption Visualization with SSRS, PowerPivot and Power View
00:00:00	Benjamin Nevarez	Jupiter 2	Query Processing in In-Memory OLTP (Hekaton)
00:00:00	Boris Hristov	Adara	The nightmare of locking, blocking and isolation levels!
00:00:00	Burak Tufanoglu	Adara	See the POWER of PowerBI
00:00:00	Batuhan Yildiz	Jupiter 2	Monitoring and Assessing SQL Server with extended events
00:00:00	Denis Reznik	Jupiter 1	Effective T-SQL. To be effective or not to be.
00:00:00	Faruk Celik	Mira	How to tune your applications before moving your database to Microsoft Azure SQL Database (PaaS)
00:00:00	Işıl Efe	Adara	SQL 2014 Column Store Index Enhancements
00:00:00	Ismail Adar	Jupiter 1	Write Quick, Readable and High Performance Queries Using Window Functions with SQL Server 2014
00:00:00	Alexander Karl	Vega	DQS step-by-step with Domain Management, Knowledge Discovery and Matching Policies
00:00:00	Koray Kocabas	Vega	Predictive Modelling with SQL Server and Azure ML
00:00:00	Levent Oktar	Jupiter 2	SQL Server 2014: High Availability and Disaster Recovery Solutions
00:00:00	Mihail Mateev	Mira	Scaling Out Microsoft Azure SQL Databases
00:00:00	Mine Tokus	Mira	Relational Data Management on Microsoft Azure
00:00:00	Mustafa Acungil	Adara	One Small Step for Power BI, Four Giant Tools for Power Users
00:00:00	Gokan Ozcifci	Vega	Deep dive to SQL Server configuration for SharePoint Server
00:00:00	Serdar Altug	Vega	Why "Big Data" Is a Big Deal? Converting Big Data into Value
00:00:00	Saverio Lorenzini	Jupiter 1	How to improve SQL query performances by analyzing the cached code in buffer pool
00:00:00	Chandra Mohan Situmalli	Mira	Backups for Azure SQL Databases and SQL Server instances running on Azure Virtual Machines
00:00:00	Satya Jayanty	Jupiter 2	Let's cook 'best SQL Server DBA practices'
00:00:00	Kevin Boles	Jupiter 1	Common TSQL Mistakes
00:00:00	Tomaž Kaštrun	Vega	Making customer segmentation using SQL Server SSAS
00:00:00	Turgay Sahtiyan	Jupiter 1	How Latch Contention Affects the Performance? Common Scenarios and Workarounds from the Field
00:00:00	Umit Sunar	Mira	Introduction to Document DB and Azure Search
00:00:00	Yigit Aktan	Jupiter 2	Troubleshooting: How to understand if the storage is a problem on the database server?

SessionID: 10206

Easy Way of Data Consumption Visualization with SSRS, PowerPivot and Power View

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Adara

Speaker: Belkis Ozhorasan

Title: Easy Way of Data Consumption Visualization with SSRS, PowerPivot and Power View

Abstract:

Abstract: This session will cover presentation of the capabilities of the data visualization with Reporting Services, Self-Service BI with Report Builder and Self-Service BI with PowerPivot for Excel. Data source sample will be RDBMS, Data Warehouse and a CSV file.

SessionID: 10386

Query Processing in In-Memory OLTP (Hekaton)

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 2

Speaker: Benjamin Nevarez

Title: Query Processing in In-Memory OLTP (Hekaton)

Abstract:

In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.

SessionID: 10945

The nightmare of locking, blocking and isolation levels!

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Adara

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

See the POWER of PowerBI

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Adara

Speaker: Burak Tufanoglu

Title: See the POWER of PowerBI

Abstract:

Over the course of this session, you will see the improvements that Microsoft has made in the SharePoint 2013 stack to take this new focus from being a nice idea to a truly powerful reality. We will explore the improvements made to Excel, PowerPivot, Power View, PowerQuery and PowerMap. We will explain the underlying technology that makes the new features possible and walk through demos of some of the shinier toys. At the end of the session, you will walk away with a better understanding of what is new in 2013 for business intelligence and an extreme desire to build reusable data model that will undoubtedly bring real value to your business.

SessionID: 11138

Monitoring and Assessing SQL Server with extended events

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 2

Speaker: Batuhan Yildiz

Title: Monitoring and Assessing SQL Server with extended events

Abstract:

Configuring SQL Server Extended Events in terms of the data load

Importing data to SQL Server Analyzing data for Expensive Queries, Adhoc queries, wait statistics If extended events is still heavy to run in production environment, discussion on alternative method

SessionID: 13148

Effective T-SQL. To be effective or not to be.

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 1

Speaker: Denis Reznik

Title: Effective T-SQL. To be effective or not to be.

Abstract:

Almost any database query can be written in several ways. T-SQL, as any other query language, contains many language constructions and has a lot of aspects, that can both make life easier and more complex. Under "complex life", I understand bad readability and poor performance. In this session we will consider a number of typical tasks, solved with the help of T-SQL, and will look at effective and ineffective task solutions.

SessionID: 14184

How to tune your applications before moving your database to Microsoft Azure SQL Database (PaaS)

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Mira

Speaker: Faruk Celik

Title: How to tune your applications before moving your database to Microsoft Azure SQL Database (PaaS)

Abstract:

OK, you've jumped into your Azure journey by creating your Azure SQL Database. Created your schema and filled up your data or just used import/export wizard. Then, you've plugged your application(s) to this new Azure SQL Database but something goes wrong by means of performance. It was working perfectly ok when your database was running on your on premises SQL Server. But now it does not perform very well with Azure SQL Database and your users started reporting interesting error message that you did not see before. "What could it be wrong ?" Some possible answers you may think of are :

A) This Azure SQL Database thingy is not for me, I give up! B) I guess I'm missing some details

If you are answering this as "B", plase come join us to learn what you could have been missing

SessionID: 15436

SQL 2014 Column Store Index Enhancements

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Adara

Speaker: Işıl Efe

Title: SQL 2014 Column Store Index Enhancements

Abstract:

Start with Column Store Index concept which is a new feature coming with SQL 2012. Explain the architecture of CSI and the workload types fit with CSI. Explore the new great enhancements in SQL 2014 with useful demos by comparing the results with traditional and column store indexes.

SessionID: 15443

Write Quick, Readable and High Performance Queries Using Window Functions with SQL Server 2014

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 1

Speaker: Ismail Adar

Title: Write Quick, Readable and High Performance Queries Using Window Functions with SQL Server 2014

Abstract:

In this session we will cover how Windows Functions works and explain how they can help-us to write better. Also we describe the improvements in Windows Functions T-SQL support from SQL Server 2005 through SQL Server 2014.

SessionID: 17935

DQS step-by-step with Domain Management, Knowledge Discovery and Matching Policies

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Vega

Speaker: Alexander Karl

Title: DQS step-by-step with Domain Management, Knowledge Discovery and Matching Policies

Abstract:

Data Quality Services (DQS/ new since SQL Server 2012) include Domain Management, Knowledge Discovery and Matching Policies.

The session gives an introduction to each of the three parts and shows the preconditions, the configuration and the implementation in the workflow. The improvement of the DataQuality can be seen as the result.

SessionID: 18808

Predictive Modelling with SQL Server and Azure ML

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Vega

Speaker: Koray Kocabas

Title: Predictive Modelling with SQL Server and Azure ML

Abstract:

Nowadays there is no meaning : Big Data if you are digging. The important thing is how can we find a benefits of our business strategy using our structured or non-structured data. Predictive modelling is based on statistical algorithms and usually that can be difficult situations for Developers. Azure Machine Learning that is the new products to build predictive Data Mining models easily. In this session we create an Azure, Azure Machine Learning systems and show how can we generate statistical predictive models using SQL Server Data and HDInsight. On the other hand we'll show real samples to real business to understand benefits of our business.

SessionID: 19145

SQL Server 2014: High Availability and Disaster Recovery Solutions

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 2

Speaker: Levent Oktar

Title: SQL Server 2014: High Availability and Disaster Recovery Solutions

Abstract:

Today almost all of the business applications/databases need High Availability and Disaster Recovery solutions for uninterrupted service continuity. In this session we'll have a look at High Availability and Disaster Recovery (HA/DR) Solutions of SQL Server 2014.

SessionID: 20338

Scaling Out Microsoft Azure SQL Databases

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Mira

Speaker: Mihail Mateev

Title: Scaling Out Microsoft Azure SQL Databases

Abstract:

Microsoft Azure SQL offers a variety of service tiers and performance levels to fit the diverse needs of database applications in the cloud. For each tire, the maximum database size is limited (up to 500GB), so when additional resources are required scaling out becomes necessary. This requires sharding, which horizontally partitions data across multiple databases. Each database in this model is referred to as a shard.

Azure SQL Database supports three methods to implement sharding: Elastic Scale, Custom Sharding and Federations This talk is a comparison and overview of these approaches, to be possible to choose the best one in your practice.

SessionID: 20797

Relational Data Management on Microsoft Azure

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Mira

Speaker: Mine Tokus

Title: Relational Data Management on Microsoft Azure

Abstract:

Start with data management features available on Microsoft Azure and learn about the various options for using SQL Server in Windows Azure. Explore the differences between Azure SQL Database (PaaS) and SQL Server in infrastructure as a service (IaaS), and see how to deploy and manage both approaches.

SessionID: 21227

One Small Step for Power BI, Four Giant Tools for Power Users

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Adara

Speaker: Mustafa Acungil

Title: One Small Step for Power BI, Four Giant Tools for Power Users

Abstract:

Connect any source to discover and combine any data with Power Query

Establish your model Analyze with Power Pivot Visualize your data to create interactive reports with Power View and gain more insights on 3D maps with Power Map Share your reports, create Collaborative BI sites, ask Qs and get As with Power BI for Office 365

SessionID: 21602

Deep dive to SQL Server configuration for SharePoint Server

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Vega

Speaker: Gokan Ozcifci

Title: Deep dive to SQL Server configuration for SharePoint Server

Abstract:

If you're using SQL Server 2012 or SQL Server 2014 as the database server for SharePoint 2013, you must perform particular set of steps to install SQL Server and then configure it specifically to host your SharePoint 2013 farm. In this session, we’ll walk through the installation process for SQL Server. I'll explain the post-installation configuration changes that are foreseen to SharePoint 2013. We’ll also have a look on how to configure SQL as SharePoint backups – all via PowerShell - for sure! As last point bottlenecks for HA/DR environments will be explained in a few steps.

After this session you will serve admirably the database back end to your SharePoint 2013 farm.

SessionID: 23814

Why "Big Data" Is a Big Deal? Converting Big Data into Value

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Vega

Speaker: Serdar Altug

Title: Why "Big Data" Is a Big Deal? Converting Big Data into Value

Abstract:

This session will discuss architecture differences between SQL Server Analytics Platform System (APS) vs SQL Server 201x in terms of data warehouse implementations. It will discuss transitioning from SMP to MPP, the why and the how. Session will also discuss managing “Data Lakes” with Hadoop integration. There will be demos to show the concepts in real life implementations.

SessionID: 24004

How to improve SQL query performances by analyzing the cached code in buffer pool

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 1

Speaker: Saverio Lorenzini

Title: How to improve SQL query performances by analyzing the cached code in buffer pool

Abstract:

Performance improvement of T-SQL code is one of the most recurring topic. SQL Server provides developers with a very rich source of information to understand performance issues and bottlenecks: the plan cache.

The session shows a technique for deeply exploring SQL Server plan cache, in order to identify the less performing queries by automatically analyze the XML execution plans through XQuery scripts. It shows the metrics for query plan quality evaluation, how to automatically find the most expensive plans, the less performing operators, and possible optimizations suggested directly by the engine. More in general, how to identify the most resource consuming pieces of code in order to provide the developers and DBAs with precise indications in terms of code design and maintenance. Finally, the session shows news about SQL 2014 to facilitate this approach.

SessionID: 24039

Backups for Azure SQL Databases and SQL Server instances running on Azure Virtual Machines

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Mira

Speaker: Chandra Mohan Situmalli

Title: Backups for Azure SQL Databases and SQL Server instances running on Azure Virtual Machines

Abstract:

Session on backup to Azure feature (manual and managed) in SQL Server 2014 to provide a cost effective DR and best practices around the same

SessionID: 25031

Let's cook 'best SQL Server DBA practices'

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 2

Speaker: Satya Jayanty

Title: Let's cook 'best SQL Server DBA practices'

Abstract:

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

SessionID: 26438

Common TSQL Mistakes

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 1

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over SEVENTY times now and it is always very highly rated!

SessionID: 27011

Making customer segmentation using SQL Server SSAS

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Vega

Speaker: Tomaž Kaštrun

Title: Making customer segmentation using SQL Server SSAS

Abstract:

This session will show in practice how to make customer segmentation using SQL Server Analysis services. By using algorithms for segmentation available in Analysis services, we will create segments and statistically test segments (clusters).

Goal of this session is to show how to deploy customer segmentation using data mining in SSAS and what are the practical needs for people working with BI and in Marketing.

SessionID: 27169

How Latch Contention Affects the Performance? Common Scenarios and Workarounds from the Field

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 1

Speaker: Turgay Sahtiyan

Title: How Latch Contention Affects the Performance? Common Scenarios and Workarounds from the Field

Abstract:

Latches are lightweight synchronization primitives that are used by the SQL Server engine to guarantee consistency of in-memory structures including; index, data pages and internal structures such as non-leaf pages in a B-Tree. Latch contention occurs when multiple threads concurrently attempt to acquire incompatible latches to the same in-memory structure. In this session, you will learn what SQL Server Latch Contention is and how to diagnose it. The session will also cover the common application designs and access patterns lead to latch contention and what the possible workarounds are.

SessionID: 27179

Introduction to Document DB and Azure Search

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Mira

Speaker: Umit Sunar

Title: Introduction to Document DB and Azure Search

Abstract:

Microsoft Azure Document DB is a purpose built JSON document database that is ideal for use in developing the next generation of modern web and mobile applications. DocumentDB provides the scale and performance of benefits of a NoSQL database but without forcing developers to take a productivity hit at design time in order to use it. NoSQL databases bring the promise of near limitless scale out and improved developer productivity

In this session we'll deep dive into the capabilities that set DocumentDB apart from RDBMS stores as well its NoSQL. This session will focus on the recently announced Azure Document DB service, a powerful JSON store well suited to building modern web and mobile applications and a free tour of NoSQL storage options in Microsoft Azure. Guidance on selecting the right storage will be covered through best practices.

SessionID: 28288

Troubleshooting: How to understand if the storage is a problem on the database server?

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Jupiter 2

Speaker: Yigit Aktan

Title: Troubleshooting: How to understand if the storage is a problem on the database server?

Abstract:

In this demo-packed session, you will learn how reads/writes work in SQL Server and you will be able to prove whether the storage is the biggest bottleneck or not!

This site is open source. Improve this page.