Nr: 199
SQLSaturday #199 - Bulgaria 2013
SessionID: 10611
Data Mining 2012 with Microsoft Excel 2013 and PowerPivot
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DV Windows Azure
Speaker: Boriana Petrova
Title: Data Mining 2012 with Microsoft Excel 2013 and PowerPivot
Abstract:
This presentation introduces the decision-making ability possible with the free Excel add-ins for PowerPivot and SQL Server Data Mining. The data mining is a service hosted in Microsoft SQL Server Analysis Services 2012, but the Excel add-in exposes the enterprise-strength server technology to analysts and executives. This talk introduces some functions from the "Analyze" and “Data Mining” tabs, including data mining model creation from Excel data. Having seen this presentation some had thought it was all Excel since the functions seem so seamless. The Excel interface provides a familiar way for professionals to make actionable decisions.
SessionID: 10917
Replay your workload as it's your actual one!
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DBA
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: 10998
SQL Internal Storage
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development 2
Speaker: Bruno Basto
Title: SQL Internal Storage
Abstract:
SessionID: 12429
Data-driven Subscription using SSIS and SharePoint
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DV Windows Azure
Speaker: David Smeets
Title: Data-driven Subscription using SSIS and SharePoint
Abstract:
SessionID: 13098
ColumnStore Indexes - In-Memory feature
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development
Speaker: Denis Reznik
Title: ColumnStore Indexes - In-Memory feature
Abstract:
SessionID: 13099
Deadlock detected! All is lost or it's too early to sound the alarm?
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Denis Reznik
Title: Deadlock detected! All is lost or it's too early to sound the alarm?
Abstract:
"Deadlock" is a terrible word, isn't it? Is it as scary as it sounds? Why do they occur and how can they affect an application? Significantly important question is how to solve "Deadlock" issues? The answers to these questions can be found in my session, which is completely dedicated to the fundamental principles of locking and isolation levels.
SessionID: 15134
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Ignacio Salom Rangel
Abstract:
SessionID: 15265
All you need to know about Reporting Services in Sharepoint mode
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: BI Platform
Speaker: Ivan Donev
Title: All you need to know about Reporting Services in Sharepoint mode
Abstract:
Description: SQL Server Reporting Services 2012 was released with some core feature redesigns and new functionalities. Come and join me in this sessions where I will cover the setup, report deployment, RS configuration and managing of the RS engine in Sharepoint mode. We will also talk about Data Alerts - the new custom alerting solution of Microsoft that enable you to receive reports as soon as the source data changes
SessionID: 15267
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development 2
Speaker: Ivan Donev
Abstract:
SessionID: 15377
Clustered Columnstore - Introduction
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development 2
Speaker: Niko Neugebauer
Title: Clustered Columnstore - Introduction
Abstract:
SQL Server 2014 receives a very new important feature - Clustered Columnstore Indexes. Using a xVelocity compression and a batch processing mode this type of indexes which was introduced in SQL Server 2012 is greatly enhanced by making it a Clustered and making it a default recommend solution for the DataWarehouse solutions. Join to discover the Clustered Columnstore Indexes by understanding on which principles they are built and what should you do get the best out of them.
This new feature is targeted at the OLAP installations and it is already available for the PDW (Parallel DataWarehouse) v2.
SessionID: 15378
Deep Dive into Clustered Columnstore
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development 2
Speaker: Niko Neugebauer
Title: Deep Dive into Clustered Columnstore
Abstract:
So you already know and understand Row Groups, Delta Stores and Compression Methods, but let me show you how Clustered Columnstore Indexes work when locking blocking, when using different compression methods and technics. Let us dive deep into the Dictionaries creation and different methods for the ETL processes.
SessionID: 15459
The Two Faces of SQL Parameter Sniffing
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development
Speaker: Ivelin Andreev
Title: The Two Faces of SQL Parameter Sniffing
Abstract:
MS SQL parameter sniffing (or "Bind Variable Peeking" in Oracle) is designed for good.
Following some common best practices developers create procedures, analyze actual execution plan, test performance with various sets of data and it is then that they deploy. How about when the same good procedure that used to run less than 100ms starts to timeout...in production? Then you may have become a victim of bad query plan due to parameter sniffing.
This may sound as a sci-fi scenario but is rather a real life use case which anyone may encounter. Join this session to get practical ideas of how to identify the cause, avoid typical mistakes and perform a fix.
SessionID: 16546
Data Visualisation with Hadoop Mashups, Power View and Excel 2013
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DV Windows Azure
Speaker: Jen Stirrup
Title: Data Visualisation with Hadoop Mashups, Power View and Excel 2013
Abstract:
Join us at this session in order to see how your Big Data can empower your business users via familiar Business Intelligence tools such as Excel and Power View.
SessionID: 18813
SQL Injection – are you ready for defense?
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: BI Platform
Speaker: Andrey Korshikov
Title: SQL Injection – are you ready for defense?
Abstract:
The fact of the matter is that SQL injection is still a problem at the end of 2013. Web sites are still being hacked by using SQL Injection on a regular basis. Are you ready to learn as to protect your systems?
SessionID: 19181
Include or not include? A fairy tale about indexes
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development 2
Speaker: Oleksii Kovalov
Title: Include or not include? A fairy tale about indexes
Abstract:
So what is the real-world difference between regular covering indexes and covering indexes with included columns?
SessionID: 19368
A deep dive into query optimizer
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development
Speaker: Margarita Naumova
Title: A deep dive into query optimizer
Abstract:
Some geeky thinks, some tips and tricks, some internals and some little known query processor details. Shortly – come and take a deep dive tour into query optimizer with me! Get inside switch the light!
SessionID: 19369
Hekaton, In-Memory OLTP, or where is the magic of SQL Server 2014?
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: BI Platform
Speaker: Margarita Naumova
Title: Hekaton, In-Memory OLTP, or where is the magic of SQL Server 2014?
Abstract:
SQL Server 2014 introduces memory-optimized database technology for optimizing the performance of OLTP workloads or In-Memory OLTP. In particular, it introduces memory-optimized tables for efficient, contention-free data access, and natively compiled stored procedures for efficient execution of business logic. How fast is the fastest? How cool are the coolest? What are those new technologies coming directly from Microsoft Research into the next version Engine? The session drills down into In_Memory OLTP as the most exciting feature of SQL Server 2014. Of course we will see some other surprises of the new version.
SessionID: 19448
Stored procedures — facts and myths
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development 2
Speaker: Marcin Szeliga
Title: Stored procedures — facts and myths
Abstract:
Everybody knows that use of stored procedures offers a number of benefits over issuing T-SQL code directly from an application. In this demo heavy session I am going to explain to you:
- Why plan caching and reuse is a good thing.
- How to avoid unnecessary recompilations for plan stability-related reasons.
- How to avoid unnecessary recompilations for plan optimality-related reasons.
- When plan reusing is not a good thing and how you can deal with this “Parameter Sniffing” problem.
- Why you should evade conditional logic inside stored procedures that do data access.
SessionID: 19449
Data in Data Mining
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: BI Platform
Speaker: Marcin Szeliga
Title: Data in Data Mining
Abstract:
Data Mining is all about data really. But what kind of data do you need? How much data do you need and how to measure data quantity? Finally, how to deal with missing data? Those questions will be answered during this session.
SessionID: 20279
Power BI for Office 365 - a Complete Self-Service BI in the Cloud
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: BI Platform
Speaker: Mihail Mateev
Title: Power BI for Office 365 - a Complete Self-Service BI in the Cloud
Abstract:
SessionID: 20281
Windows Azure SQL Reporting for App developers
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DV Windows Azure
Speaker: Mihail Mateev
Title: Windows Azure SQL Reporting for App developers
Abstract:
SessionID: 20812
Extended events in action
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Miroslav Dimitrov
Title: Extended events in action
Abstract:
In this session we will walk through the world of Extended Events and their power in monitoring SQL server instances. We will explore some real-world scenarios and see how we can benefit from Xevents in solving them. You will be able to see how to track a specific application behavior and how to troubleshoot connectivity issues
SessionID: 20949
Cloud Stakeholders - Top 10 Cloud Jobs
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DV Windows Azure
Speaker: Miroslav Lessev
Title: Cloud Stakeholders - Top 10 Cloud Jobs
Abstract:
Cloud computing is already a fact, which nobody doubts. Moreover, with cloud technologies, organizations can focus on their main activities. In the cloud each user has access to the highest quality services. Along with the various positive effects, vendors face a number of problems and undeveloped areas. Preparation of the stakeholders is crucial for each project. More or less the technologies are the same, but the way we use them is not the same in the cloud. Former flaws are today’s advantages, former fundamentals for developers are no longer available in the cloud. Are we ready to forget all that we know and start over again to learn and how sustainable is the new knowledge – these are the open questions that stakeholders raise today.
SessionID: 21445
SSIS Package Logging
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: BI Platform
Speaker: Nikolay Nyagolov
Title: SSIS Package Logging
Abstract:
If you’ve ever worked with SSIS packages there’s no doubt you’ve been in a situation where all of the sudden the package does not behave in the way you'd expect it to and you need to quickly turn around with figuring out the cause and get the package running again. For simple packages, the task might be trivial, but as we work with more and more data and build complex ETLs using SSIS, it is necessary to have a detailed outlook into your package's execution and progress.
In this lecture we will go over the different approaches and best practices for logging for SSIS packages. We will also talk about the Integration Services Catalog in SSIS 2012, specifically its capabilities for tracing package execution. Finally we will cover the built-in reports in SSMS 2012.
SessionID: 24361
Query Plan Operators Deep Dive
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development
Speaker: Sergey Olontsev
Title: Query Plan Operators Deep Dive
Abstract:
SessionID: 24362
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Sergey Olontsev
Abstract:
SessionID: 26166
Common TSQL Mistakes
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26167
SQL Server 2012 TSQL Enhancements and Additions
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: Development
Speaker: Kevin Boles
Title: SQL Server 2012 TSQL Enhancements and Additions
Abstract:
The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!
SessionID: 27165
HA DR with SQL Server 2014 AlwaysOn Availability Group
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Turgay Sahtiyan
Title: HA DR with SQL Server 2014 AlwaysOn Availability Group
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 2014 CTP1, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. In this session we will talk about what’s coming with Always On, and how does it help to improve high availability and disaster recovery solutions.
SessionID: 8788
Windows Azure Storage: Overview and Internals
Event Date: 26-10-2013 - Session time: 00:00:00 - Track: DV Windows Azure
Speaker: Anton Vidishchev
Title: Windows Azure Storage: Overview and Internals
Abstract:
The session is dedicated to Windows Azure Storage - queues, blobs and tables. We'll go through areas of applications, good and bad scenarios, and specifics of working with it.We'll also talk about how it works internally (data partitioning, moving from one partition server to another), and why it should be taken into consideration when implementing software.