Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 24
Although SQL Server is considered "secure by default", one of the most often successfully attacked targets is the data that resides in a SQL Server. Most of the exploited weaknesses are due to misconfiguration or weak coding practices. In this purely demo-based security session, I will show several real life attack scenarios on different layers. Due to special request this includes some special SQL Injection types. Furthermore I show how an elevation of privileges attack is possible due to a not uncommon configuration as well as an “insider-exploit” with a database root kit.
 – Note: there will be no instructions on how to attack a system, but rather highlight common weaknesses. – (almost) no slides: Demos Demos Demos
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Your SSIS packages are taking longer than they should, but you are not sure what to do about it. Join this session to get 10 tips and tricks for gaining better performance. You’ll learn not only 10 reasons to why your packages are running slow, but also 10 ways to do something about it. Find out when to use T-SQL instead of SSIS transformations, why you should care about data types, what a blocking transformation is, why buffers are important, and much more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

-
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Server 2014

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Session Type:
Regular Session

Track:
SQL Server 2014

Level: Beginner

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

I/O errors, what CHECKDB does, how it works, how to run it, CHECKDB FAQ, how to interpret the output, choosing between repair and restore and has a bunch of demos of recovering from corruptions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

What's Data Mining
Which sectors are using DM? Real Life Samples
When companies should use Data Mining Algorithms?
Which Algorithms are supported by Microsoft SQL Server?
Data Mining Sampling using Microsoft SQL Server
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

With the new Data Quality Services (DQS) Microsoft has an offering for Data Quality Management. This session gives you insights how to use DQS efficiently. In demos you will understand best practises in setting up a knowledge base, correct matching rules and how to integrate DQS to your processes as DQS is never an island solution. DQS performance aspects and how to report your quality improvements will round up the session. The session assumes that you have already tested DQS and want to get further with this toolset.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

"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.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
SQL Server 2014

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session! In this session we will walk into the heart of SQL Server, and you will see performance bottlenecks and error conditions, from which your production SQL Server's should be afraid of. You will learn some troubleshooting techniques with which you can identify and solve the most difficult SQL Server problems. Agenda at a glance:

*) Hold Locks with Read Committed
*) ThreadPool Starvation
*) TempDb Latch Contention
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover brief explanations and demonstrations of the new features in the next version of SQL Server, including In-Memory technology, HA/DR scenarios, updatable columnstore, AlwaysOn capabilities, and much more. 
Speaker:

Session Type:
Regular Session

Track:
SQL Server 2014

Level: Beginner

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2014 introduces memory-optimized database technology for optimizing the performance of OLTP workloads. In particular, it introduces memory-optimized tables for efficient, contention-free data access, and natively compiled stored procedures for efficient execution of business logic. In this demo-packed presentation we will learn everything about Hekaton.
Speaker:

Session Type:
Regular Session

Track:
SQL Server 2014

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

With the explosion of data, the open source Apache™ Hadoop™ Framework is gaining traction thanks to its huge ecosystem that has arisen around the core functionalities of Hadoop distributed file system (HDFS™) and Hadoop Map Reduce. As of today, being able to have SQL Server working with Hadoop™ becomes increasingly important because the two are indeed complementary. For instance, while petabytes of data can be stored unstructured in Hadoop and take hours to be queried, terabytes of data can be stored in a structured way in the SQL Server platform and queried in seconds. This leads to the need to transfer data between Hadoop and SQL Server.

In this session, We will explore how SQL Server Integration Services (SSIS), i.e. the SQL Server Extract, Transform and Load (ETL) tool, can be used to automate Hadoop + non Hadoop job executions, and manage data transfers between Hadoop and other sources and destinations
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

-
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is based on how you can make performance analysis both real time and historically by using DMVs. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Power BI tools within Excel are available in the cloud with Office 365, allowing customers to access and share BI reports and models across the desktop and web, and all within a managed environment. Power BI for Office 365 includes Power Pivot and Power View, and two new Excel capabilities have been added to allow the over one billion Office 365 users the ability to do more with their data! These two new features are Power Query which was formerly Project Codename “Data Explorer”, and Power Map formerly Project Codename “Geoflow”. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Power Query is an Information Worker focused ETL Tool integrated in Excel 2013. We will show this cool new tool to mash up data from different data sources (from Active Directory to Windows Azure Marketplace , from SQL Server to Files in a directory) and using the transformation capabilities of PQ. We will take a closer look to “M” the scripting language behind this Excel Add In and how you use it to do some pretty cool stuff.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

We will talk about how SQL Server produces query plans using estimates and statistics and why are they so important. I will share my experience of managing statistics and show you cases where wrong estimates guessing by optimizer can lead to performance issues. The session will be useful for both administrators and developers.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

We will talk about those tiny blocks which form query plan and I will show you some of them in details. There are plenty of properties each operator have and some of them contain more valuable information than others. Knowing this details can help you better understand query plan and find causes of performance issues.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Spatial Data is very important for the new applications, related with Data Visualization and BI. Windows Azure offers possibility to use 
advantages of spatial data suing cloud computing. In this lecture will talk about the use of spatial data in the Windows Azure - loading data 
from Windows Azure SQL Database Spatial, optimizing Windows Azure applications and their use of different types of customers: WEB based, WPF, WP7. We will learn how to import spatial data in different formats in Windows Azure SQL Database Spatial and will create a several sample Windows Azure applications, that use this data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure

Level: Intermedia

Session Code:

Date: October 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 24
Back to Top cage-aids
cage-aids
cage-aids
cage-aids