sqlsathistory

Nr: 311

Back to Main list

SQLSaturday #311 - Bulgaria 2014

Start Time (24h) Speaker Track Title
00:00:00 Boriana Petrova 5:Mixed OSS Building Great Business Intelligence Semantic Models for Power View
00:00:00 Boris Hristov 1:Development Top 5 T-SQL Improvements in SQL Server 2014
00:00:00 Catalin Gheorghiu 5:Mixed OSS Databases for mobile
00:00:00 Denis Reznik 1:Development Deadlocks. Everything that developer needs to know
00:00:00 Dejan Sarka 3:BI Analyzing Text with SQL Server 2014
00:00:00 Dejan Sarka 1:Development Optimizing Temporal Queries
00:00:00 Enrico van de Laar 4:Mixed Azure No more waiting – an introduction to SQL Server wait statistics
00:00:00 Ivan Donev 4:Mixed Azure Get the most out of your Windows Azure SQL virtual machines
00:00:00 Ivan Donev 5:Mixed OSS Tips and tricks to optimize your SQL Server backup
00:00:00 Ivelin Andreev 3:BI Data Warehouse Design and Best Practices
00:00:00 Janos Berke 2:DBA High Availability - Partial Database Availabilty
00:00:00 Daniel Joskovski 5:Mixed OSS Introduction to Forecasting
00:00:00 Kaloyan Kosev 4:Mixed Azure Managing 999 MS SQL Servers
00:00:00 Alexander Karl 3:BI Reporting Services with Geospatial Visualization
00:00:00 Tobias Koprowski 2:DBA SQL Server Source Control
00:00:00 Oleksii Kovalov 5:Mixed OSS MySql for SQL Server developers
00:00:00 Margarita Naumova 4:Mixed Azure A deep dive into SQL Server Plan Cache Management
00:00:00 Margarita Naumova 1:Development Let those statistics be with you!
00:00:00 Marcin Szeliga 1:Development Indexing for denormalization
00:00:00 Mihail Mateev 5:Mixed OSS Node.js for Microsoft SQLServer Nerds
00:00:00 Miloš Radivojević 1:Development Hekaton Challenges from Database Development Point of View
00:00:00 Miroslav Dimitrov 4:Mixed Azure Performance Tuning for the Transaction Log
00:00:00 Murilo Miranda 2:DBA Buffer Pool Extension (BPE) - How it works?
00:00:00 Nikolay Nyagolov 4:Mixed Azure SQL Server 2012 + Hadoop. Is that possible?
00:00:00 Stefan Damyanov 3:BI Advantages using DAX in Tabular data model
00:00:00 Rasmus Reinholdt 3:BI Dos and Don'ts of Columnstore indexes
00:00:00 Sergey Olontsev 2:DBA Practical usage of partitioning
00:00:00 Satya Jayanty 2:DBA SQL Server Data platform upgrade Techniques, best practices notes from the field
00:00:00 Turgay Sahtiyan 2:DBA HADR with SQL Server AlwaysOn Availability Groups
00:00:00 Zoltán Horváth 3:BI So you are a BI Developer by Accident

SessionID: 10610

Building Great Business Intelligence Semantic Models for Power View

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 5:Mixed OSS

Speaker: Boriana Petrova

Title: Building Great Business Intelligence Semantic Models for Power View

Abstract:

In this session, we’ll explore what it takes to create the right BI Semantic Models to help your users get the answers they need and insightful results with Power View.

SessionID: 10928

Top 5 T-SQL Improvements in SQL Server 2014

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 1:Development

Speaker: Boris Hristov

Title: Top 5 T-SQL Improvements in SQL Server 2014

Abstract:

SQL Server 2014 comes with dozens of improvements in various areas. In this session we will discuss and see how the new release can make the life of each and every developer easier and what are the top 5 T-SQL enhancements that we can use in our day-to-day work.

SessionID: 11384

Databases for mobile

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 5:Mixed OSS

Speaker: Catalin Gheorghiu

Title: Databases for mobile

Abstract:

You are a Windows Phone developer or just a mobile developer and you need locally a database, what are your options? What you can do, what you cannot do, and how? How cloud is changing this story? With focus on Windows Phone (the easiest to demo, but not ignoring the “others”) these are a few of the questions this presentation will try to answer. Of course all with as much demoes and code as possible.

SessionID: 13102

Deadlocks. Everything that developer needs to know

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 1:Development

Speaker: Denis Reznik

Title: Deadlocks. Everything that developer needs to know

Abstract:

It's no secret that a deadlock - it's not very good. This is an exceptional situation, when two concurrent queries request same resources, but in a different order. Classic deadlock can occur when two concurrent transactions modifying data from the two tables in a different order. Unfortunatelly in real life deadlocks can be more complex and unobvious. One of the rules, which I always keep in mind, sounds: " You can not design a database, in which the occurrence of deadlock is impossible". So we should deal with them. The algorythm is following: catch, analyze, fix. The most challenging and interesting here is the analysis part. Once you understand why it was occured, you can fix it. In this session we will focus on the analysis of complex,

SessionID: 13532

Analyzing Text with SQL Server 2014

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 3:BI

Speaker: Dejan Sarka

Title: Analyzing Text with SQL Server 2014

Abstract:

Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media.

Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with SQL Server tools.

SessionID: 13534

Optimizing Temporal Queries

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 1:Development

Speaker: Dejan Sarka

Title: Optimizing Temporal Queries

Abstract:

Having a SQL Server solution for a problem does not mean the job is done. Of course, the next immediate issue is the performance. Temporal queries that involve intervals are typically very IO and CPU intensive. For example, a test for overlapping intervals was solved with inefficient queries for years. However, a handful of solutions with fast queries was developed lately. This high-level technical session introduces five different methods to get efficient queries that search for overlapping intervals. Of course, these solutions can be implemented on other temporal problems as well. Actually, the test for overlapping intervals is one of the most complex temporal problems.

SessionID: 13792

No more waiting – an introduction to SQL Server wait statistics

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 4:Mixed Azure

Speaker: Enrico van de Laar

Title: No more waiting – an introduction to SQL Server wait statistics

Abstract:

When you are standing in line at the grocery store you know exactly what you’re waiting for, paying the things you intend to buy. In SQL Server things aren’t usually so simple and many times you have to wait for more than only the length of the queue or the speed of the cashier. Thankfully SQL Server gathers the exact time you have been waiting and what resource you have been waiting on. In this session we will take a look at how SQL Server gathers this information and how it can help you identify, troubleshoot and proactively solve performance issues.

SessionID: 15269

Get the most out of your Windows Azure SQL virtual machines

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 4:Mixed Azure

Speaker: Ivan Donev

Title: Get the most out of your Windows Azure SQL virtual machines

Abstract:

Windows Azure Virtual Machines provide you the capability to have your SQL Server built and configured by your own DBAs, but with a lot of restrictions, that can limit your productivity and performance. In this session we will talk about optimizing SQL Server, running on Windows Azure Virtual Machines so you get out the most performance out of it.

SessionID: 15270

Tips and tricks to optimize your SQL Server backup

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 5:Mixed OSS

Speaker: Ivan Donev

Title: Tips and tricks to optimize your SQL Server backup

Abstract:

The backup strategy of every company, running SQL Server is the main reason of making the DBA happy. It the era of enormous data inputs, it is not only important to backup your data, but to back it up fast and to know you can restore it. In this session we will talk about backup strategies, tips and tricks on optimizing the SQL Server backups (both on disk and with 3-rd party software) and last but not least - how to be sure that you can recover and do it fast and in time.

SessionID: 15461

Data Warehouse Design and Best Practices

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 3:BI

Speaker: Ivelin Andreev

Title: Data Warehouse Design and Best Practices

Abstract:

A data warehouse is a database designed for query and analysis rather than for transaction processing. An appropriate design leads to scalable, balanced and flexible architecture that is capable to meet both present and long-term future needs. This session covers a comparison of the main data warehouse architectures together with best practices for the logical and physical design that support staging, load and querying.

Join this session to learn various architectural approaches our team evaluated for a 50’000+ hours EU project.

SessionID: 15754

High Availability - Partial Database Availabilty

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 2:DBA

Speaker: Janos Berke

Title: High Availability - Partial Database Availabilty

Abstract:

High availability starts at database design. This session will show how to design your database supporting partial database availability.

Session agenda is the follwoing:

SessionID: 17540

Introduction to Forecasting

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 5:Mixed OSS

Speaker: Daniel Joskovski

Title: Introduction to Forecasting

Abstract:

In this presentation we will start with description of the Data Mining Process, then we will Introduce the Microsoft Time Series Algorithm for Forecasting. We will explain the blending of two machine learning algorithms for forecasting of continuous values: ARTxp, ARIMA (since Analysis Services 2008) We will demonstrate production of forecast by: Table Analysis Tools Excel Add-In, Client Tools Excel Add-In, SQL Server Data Tools (SSDT) Project. We will finish this presentation by describing business scenarios

SessionID: 17854

Managing 999 MS SQL Servers

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 4:Mixed Azure

Speaker: Kaloyan Kosev

Title: Managing 999 MS SQL Servers

Abstract:

Managing many SQL server instances is difficult and more importantly it requires a lot of efforts from the DBAs. How can we reduce and save these efforts? Let’s dive into a session covering some great examples and best practices of multi-server management – from building a Central Management Server through gathering performance data with customized Management Data Warehouse. We will do also a showcase for proactive capacity management and see many other ideas for automating of the daily DBA tasks.

SessionID: 17921

Reporting Services with Geospatial Visualization

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 3:BI

Speaker: Alexander Karl

Title: Reporting Services with Geospatial Visualization

Abstract:

Reporting Services with Geospatial Visualization

specifically: „from address data to data-presentation in SSRS Mapcontrol in 3 steps.“ Each company has address data in the relational form [street], [postcode] und [place]. In a first step the transition to Geodata is presented in the form of longitude and latitude. The question of data source and data quality is also an issue addressed in this section. The next step deals with the selection of appropriate maps. Of special note is the data-matching of the maps with the address data. Also the own production of map sections will be illustrated in an example. The third step is to conduct the use and configuration of the control and the reference to the report data

SessionID: 18687

SQL Server Source Control

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 2:DBA

Speaker: Tobias Koprowski

Title: SQL Server Source Control

Abstract:

How to control Your data? Not only bare metal and installed environment are important. What about data? Backup and Restore Statements? Yes, both are important, but What about Data? The pure data? In the code? At this session I want to inviting You to discovering world of controlling data, for controling Your code. Which techniques You can use, where store your data and which tools are available.

SessionID: 19186

MySql for SQL Server developers

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 5:Mixed OSS

Speaker: Oleksii Kovalov

Title: MySql for SQL Server developers

Abstract:

Quick guide on why you have to be able to work with MySql and how to successfully accomplish this task.

SessionID: 19375

A deep dive into SQL Server Plan Cache Management

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 4:Mixed Azure

Speaker: Margarita Naumova

Title: A deep dive into SQL Server Plan Cache Management

Abstract:

As an experienced DBA you have probably asked yourself questions like how the memory is consumed, is my system well-tuned, and is my memory configuration well defined. In order to understanding such processes as local and global Memory pressure, caches concurrency, adding and removing plans from cache we will go through the internal organization of the plan cache, the metadata available, how SQL Server finds a plan in cache, plan cache sizing, and the plan eviction policy. We will point out the important cache consumers that affect your workload and how to get metadata about them, what are the thresholds in Cache Size Management. At the end you will understand how to monitor the memory consumers in your SQL Server, what are wait types that we need to look for, how to understand if your system is well-tuned and the memory configuration is well defined

SessionID: 19376

Let those statistics be with you!

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 1:Development

Speaker: Margarita Naumova

Title: Let those statistics be with you!

Abstract:

There are a lot of questions about statistics that I receive in my trainings, projects and during my sessions: Why I have to rebuild statistics, if my auto-update stats option in ON. Why I still have bad plans or high CPU usage? Should I disable it or use full scan instead?

We usually rely on auto-update stats database options and sometimes perform a regular stats updates additionally in order to be sure that the QP has an up to date info about our table data. But there are some specific cases when those thinks just don’t help and even recompiling don’t boost the performance of a query. Let me list and explain for you some statistics updates exceptions cases and you will understand how to proper manage your statistics in order to gain max from them.

SessionID: 19460

Indexing for denormalization

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 1:Development

Speaker: Marcin Szeliga

Title: Indexing for denormalization

Abstract:

What has the biggest impact on SQL Server overall performance? Hardware, SQL Server configuration or maybe query tuning? No, none of those frequently discussed options. They are important, but the single, most important factor is the database design.

A third normal form is great, but sometime a database really should be denormalized to gain a performance boost. This is where indices shine. During this session you will see: how important a proper table design can be, when to use indices on computed columns and why they are way better than triggers, how to create useful indexed views and how to asses their costs and benefits.

SessionID: 20315

Node.js for Microsoft SQLServer Nerds

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 5:Mixed OSS

Speaker: Mihail Mateev

Title: Node.js for Microsoft SQLServer Nerds

Abstract:

This session is to all SQL Server and Windows Azure developers, who want to build sclabble applications using Node.js and MS SQLServer / Windows Azure SQL Database.

Node.js came onto the scene four years ago, offering yet another tool for creating server-side software systems that support scalable Internet applications. With the continued support from Microsoft for Nodejs on both Windows and Windows Azure, it is bound to reach great levels. Don't worry if you don't know Node.js - this will not be necessary to understand the session.

SessionID: 20751

Hekaton Challenges from Database Development Point of View

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 1:Development

Speaker: Miloš Radivojević

Title: Hekaton Challenges from Database Development Point of View

Abstract:

This session covers the Hekaton challenges for the developers at the 300-400 level including native compiled SPs but also some concerns about hekaton constraints etc.

SessionID: 20810

Performance Tuning for the Transaction Log

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 4:Mixed Azure

Speaker: Miroslav Dimitrov

Title: Performance Tuning for the Transaction Log

Abstract:

SQL Server transaction log is one of the most critical components of the database and in the same time one of the most misunderstood. While being neglected it can easily become a bottleneck for our system. Are you interested in learning how to avoid issues with the transaction log and streamline its work? In these sessions we will explore how to optimize it, configure it and keep it under control.

SessionID: 21176

Buffer Pool Extension (BPE) - How it works?

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 2:DBA

Speaker: Murilo Miranda

Title: Buffer Pool Extension (BPE) - How it works?

Abstract:

A new feature of SQL Server 2014, Buffer Pool Extension (BPE) promises improvement on OLTP workload like systems, taking advantage of fast persistent disks.

On this session we will enter in some theoretical details regarding this new technology, as well as some demos.

SessionID: 21446

SQL Server 2012 + Hadoop. Is that possible?

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 4:Mixed Azure

Speaker: Nikolay Nyagolov

Title: SQL Server 2012 + Hadoop. Is that possible?

Abstract:

In this lecture, we will go over a hybrid data processing architecture that uses SQL Server 2012 and Cloudera Hadoop. We will give special attention to certain issues that came up during the project and how we overcame them. The content will be based on an actual project that is based on Hadoop and SSAS working together to process XXX TB every hour.

SessionID: 22051

Advantages using DAX in Tabular data model

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 3:BI

Speaker: Stefan Damyanov

Title: Advantages using DAX in Tabular data model

Abstract:

This presentation is a walk through in-memory data base and DAX queries for better performance of reporting. We will cover: I. Advantages using In Memory Data Bases and Architecture Examples for better performance using In Memory Data Bases II. Tips and tricks using DAX queries, Describe DAX architecture, DAX vs MDX in SSRS and Best practices for DAX queries III. Best Practices using SSRS with Tabular model, Best practices when using DAX queries in SSRS and Common issues in SSRS and tips and tricks to resolve them.

SessionID: 23516

Dos and Don'ts of Columnstore indexes

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 3:BI

Speaker: Rasmus Reinholdt

Title: Dos and Don'ts of Columnstore indexes

Abstract:

The Columnstore index specification states that a performance gain between 10 and a 100 times should be expected - This demo intensiv session will show you how to get closer to the 100 than 10 times.

In the session I will explain the details of xVelosity engine in generel and the columnstore index in detail and then move on to take a look on the (many) limitations the index has - and how to Work around then so you can get the full performance gain in all types of queries.

SessionID: 24334

Practical usage of partitioning

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 2:DBA

Speaker: Sergey Olontsev

Title: Practical usage of partitioning

Abstract:

You may already heard about partitioning as a way to split large tables into smaller pieces. However, is it the only way of partitioning usage? When to start using it and what are pros and cons? What are different ways to partition table? How to choose right columns, functions and schemas? I will answer all these questions by using real world examples.

SessionID: 25022

SQL Server Data platform upgrade Techniques, best practices notes from the field

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 2:DBA

Speaker: Satya Jayanty

Title: SQL Server Data platform upgrade Techniques, best practices notes from the field

Abstract:

Why Upgrade?

This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices. Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008. In this session, we will overview end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 SQL Server 2012 (with a good overview on 2014 too) by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution is offered.

SessionID: 27149

HADR with SQL Server AlwaysOn Availability Groups

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 2:DBA

Speaker: Turgay Sahtiyan

Title: HADR with SQL Server AlwaysOn Availability Groups

Abstract:

The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. In this session we will talk about pros and cons of Always On Availability Groups, and how does it help to improve high availability and disaster recovery solutions, what's new in SQL Server 2014 regarding the AlwaysOn Availability Groups.

SessionID: 34915

So you are a BI Developer by Accident

Back to calendar

Event Date: 11-10-2014 - Session time: 00:00:00 - Track: 3:BI

Speaker: Zoltán Horváth

Title: So you are a BI Developer by Accident

Abstract:

You might be a DBA who deals with databases or a developer who creates applications, and you hear that you will be appointed to provide a business intelligence solution which will empower decision makers by displaying key measures of your department, company or client. This session is to help you where to start, giving an overview about the complete on-premise BI toolset of Microsoft, along with the analysis of your infrastructure constraints which influence how your BI solution will look like at the end of the day.

The session also helps those who are planning to introduce the BI-related services (SSIS, SSRS, SSAS, MDS, DQS) of SQL Server to their companies, squeezing the last lev out of their SQL Server and Office license investments.

This site is open source. Improve this page.