Sessions Title

These are the sessions submitted so far for SQLBits XIV.

Filter Sessions:
200
Dev
The basic function of the MERGE statement is the ability to synchronize imported data with base data, inserting new rows and updating existing rows, all in one go. But step beyond basics and MERGE becomes a tool that can do much, much more.

In this demo-rich session, we will present the full syntax of the MERGE statement, explain all the options, and show the possibilities. We will also demonstrate the pitfalls that you need to be aware of if you, or even someone else, uses MERGE – and show you how to solve them.

Whether you already used MERGE or not, this session will show you new ways to tackle problems that would otherwise be much harder to solve.
300
BI
Configuring Kerberos can be easy. Indeed, with favourable conditions and some preparation,  the whole thing can be over in minutes. However, if hours later it still does not work, troubleshooting can take many days even with help of experts.

As you all know, real world implementations can deviate dramatically from lab scenarios considered in common whitepapers. What most resources usually cover is, at best, some step by step configuration instructions for a particular architecture. Such instructions often lack explanation of why it has to be done that way in terms of the role of every step in the authentication process, i.e. they do not explain principles, only give certain examples.

I would like to present easy to follow principles of Kerberos constrained delegation and protocol transition with handy tips and templates to get this right the first time for your particular environment. The goal is to explain the meaning of the settings in terms of the role in the Kerberos constrained delegation authentication rather than simply presenting another example of a particular scenario. I will also include a
jargon-busting glossary of terms to help you get started.

This presentation covers some very useful resources to help you tame your three-headed monster and make it behave in case it decides to go on a strop. I will also mention some useful tips and resources
on dealing with Claims To Windows Token services, an important part to Kerberos configuration. It plays a very important part in delegating authentication for services requiring protocol transition (Claims -> Windows), such as Excel Services, Performance Point and Power View.
300
DBA
When learning about SQL Server, really deeply learning, there were a few “key” concepts that you hear repeated often by top speakers and SQL MVP’s. Internals, recovery models, and backups.  They are interconnected.  As the learning continued, it was self-evident how understanding basic data internals with pages, extents, and allocation bitmaps or database recovery models, the transaction log, and VLF’s
or advanced backup options backups like stripping and piecemeal restores affected the uses of SQL Server.  They affected not just SQL Server but the way you make decisions in order to determine how best to use SQL Server to support your business.  This session enables you to have that core set of understanding required for advanced SQL learning.   
400
Dev
Anchor Modelling is a fantastic database modelling paradigm that uses sixth normal form (6NF) to store data in and provides third normal form (3NF) views for ease of use. This session showcases Anchor Modelling to allow for a purely additive development process for databases that reduces development, testing and deployment time. Covering the theory and practical tips from our experience it provides a solid intro to a great design model for OLTP and DW databases alike.


The session covers the fundamentals of database theory giving you enough to get going, it explores the Anchor Model system, the benefits it brings, and then dives into how you can start incorporating Anchor Modelling into your current database schema and ETL.
300
Dev
We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some pretty subtle and some downright 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 and concurrency.  Not only will we dig into lots of code examples, we will also cover numerous performance analysis AND tuning techniques.  Profiler, statistics IO and query plan issues.  Learn about how the Heisenberg Uncertainty Principle applies to SQL Server performance analysis.  Don't worry, I actually DO have a degree in physics, so my head won't explode. :-)  See how data value skew mocks parameter sniffing.  Learn about a common mistake that actually caused a client to go out of business - and yes, I DID tell them it was going to happen! I have given this talk almost 75 times now and it is always very highly rated!  Two hours is not nearly enough time, so come prepared for a JAM-PACKED session!

300
Dev
Columnstore indexes were introduced in SQL Server 2012 & have been wholly re-architected & optimized in SQL Server 2014.  Columnstore indexes are optimized for data warehouse workloads & are a hybrid technology leveraging the best of off-disk & in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at sub-second response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. The presentation is rich in demos. Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit & why columnstore manifests my motto, “Change the world or go home!”
300
DBA
People are aware that you can use an execution plan to tune a query, but do they have other uses? This session will drill down on all the hidden information within execution plans. The structures and information with an execution plan shows many of the inner workings of SQL Server. From calculated columns to referential integrity, these, and many other functions, are exposed through execution plans. From this session you’ll be able to better understand the inner workings of SQL Server as well as your own databases and queries.
300
DBA
You need to implement AlwaysOn Failover Clustering or Availability Groups, but you need help with the Windows Clustering part.  I have you covered.  We'll talk about how to plan for network, DNS, Active Directory, and storage.  I'll even provide you with a check list you can use to plan your implementation.  We'll also discuss quorum, how to decide which one to use, and the effect that choice can have on your Failover Cluster Instance and/or Availability Group.
300
DBA
Is your SQL Server instance running at its peak performance level?  Probably not but the real question is do you know why not? Is your disk subsystem too slow or are you lacking enough CPU’s or is it something else completely?  We will see just how easy it is to capture and analyze the file & wait stat information that is automatically provided by SQL Server. So stop chasing your tail and focus on which area of SQL Server performance bottlenecks are doing you the most harm. This should be part of every DBA’s arsenal so come make it part of yours as well.
300
Dev
Take what you’ve learned about SQL Server and turn it upside down.

In this humorous session I’ll be debating many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.
  • When you should NOT use stored procedures.
  • When we don’t need indexes.
  • When Clustered Tables are bad.
  • When Identity Columns should not be Primary Keys.
  • When we don’t care about fragmentation.
  • When good naming convention’s go bad.
  • Why Partitioning often makes your queries slower.
  • Why do ORMs really makes sense when they make all your parameters nvarchar (max)


Health Warning: These may not be the design tips you should be using on your production OLTP.
300
BI
Power Query is a desktop ETL tool, right? Well, yes - but it's a lot more than that. In fact you can use Power Query to build an impressive Excel-based reporting solution without going near Power Pivot, and in some cases this approach can be better than using Power Pivot. In this session you'll learn how to:
  • Connect to multiple data sources and combine data from them in Power Query
  • Create parameterised queries in Power Query, and pass parameters to them from your Excel worksheet
  • Build a Reporting Services-like user interface for your reports in Excel
  • Ensure that your reports work in Excel Services as well as on the desktop
  • Make sure that you get the best possible performance in Power Query using query folding
  • Learn when to load data to the Excel Data Model/Power Pivot, and when not to
200
Car
Nowadays presentation skills are important. Full stop! Presentations are everywhere and we are expected to be good at delivering them - be that because of work or because we, ourselves, want to train and teach people. In this session we will discuss the most important aspects of a successful presentation. You will learn what makes a great talk and how you should approach, prepare and deliver your sessions. We will also discuss tips and tricks around presentation design and most importantly - how we should prepare and deliver our demos because the reality is that your demo has to work. It just has to! And there are ways you can guarantee it will... The session is suitable for both people that are new to the world of speaking and to speakers who already have experience in the field. 
200
DBA
An introduction to Installing and Using "Policy Based Management" , the PBM is a feature designed to aid you in maintaining your SQL Servers to certain Standards and Policies you have determined are suitable for your environment

This session will show you how to quickly set-up and deploy your selected Policies, how to report or prevent actions that would break those policies and Includes using PBM via Powershell



Discovering how the key components of PBM fit together is needed to fully understand and make effective use, we look @ Polices, Conditions, Facets and all of the properties that are part of the PBM feature
300
DBA
In my job as a SQL Consultant, I have my weekly recurring customers. They don’t have a DBA, so I have to perform the daily DBA checklist on a weekly basis ;) Initially, I've started with executing some T-SQL scripts to verify the SQL Servers. But as more servers were installed, my DBA checklist became really time consuming and I didn't even have the time for a coffee… In this session you will learn how you can perform your DBA morning checklist while sipping coffee. I will demonstrate how you can use Policy Based Management to evaluate your servers and how I configured my setup. By the end of this session, I guarantee you will have more time for your morning coffee!
500
DBA
In this session we'll dig into the internal structures of indexes.  We will explore the differences between clustered and non-clustered indexes, what's laid out within each page of the indexes and how the SQL Server uses the data within the indexes to find rows quickly.
400
BI
In this session, we will look at data visualisation using:

  • Gephi
  • d3
  • R
  • Python
  • Power BI

We will look at how we can enhance the suite of offerings to your data consumers by opening your toybox of Open Source data visualisation tools, as well as Power BI.

Using Microsoft SQL Server as a source, we will look at these open source tools as an accompaniment to Power BI - not a replacement.

Join us for this demo-heavy session, and be sure to download the code from Jen's blog afterwards in order to try it out for yourself. The emphasis is on practical takeaways that you can apply when you go back to your office after SQLBits, and try it out for yourself.
400
DBA
The Query Optimizer is a black box.  It can be intimidating until you understand it.  Understanding the Optimizer beings with knowing the Rules.  The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.  This is the first step in learning how to use the Optimizer's rules to make your queries faster!
200
Dev
Need to automate a process in your database? Create audit tables, generate stored procedures, or any other type of manually repeatable process? In this session we'll look at how to start and the thought processes and design considerations involved. From initial idea to fully-functional solution, metadata can be used to drive processes and object creation and maintenance in your database. It does however need to be designed right to avoid pain in the future.

Whether you want to create simple audit tables or build a whole ETL solution is immaterial, you need to start the project right and make it bulletproof. This is more a session on the thought process involved in designing such a solution but will have an example we will work through during the session. A small amount of work and planning at the start will save you days in the future, so let’s get on with it!
200
DBA
Yes, my 9 year old daughter can install SQL Server just like your admin probably did (next-next-next?!?).  And then she can install a third-party application and VOILA - she has a functioning database application. And SQL Server is SOO DARN GOOD that it will just keep on working hard and amazingly effectively to give you the results you desire, despite some DEVASTATINGLY BAD defaults!  But if you are lucky, your company becomes successful and then you just got to do some things correctly and stop doing some things suboptimally or you will never be able to achieve the kind of throughput, SLA, response time, scalability, concurrency, etc. that your clients desire.

This session will cover a laundry list of such improvements, from data and log file growth factors to Windows power settings to disk configurations and many useful items in between.  We will cover a myriad of performance-robbing issues.  But there is much more at stake.  You really need to make sure you set things up properly, because to fix some of them you have to go back to bare metal.  Others can leave you unable to access your server in a crisis.  One is the leading cause of database corruptions.  There's much more - join me to find out the details!

BTW, this session is listed as 200-level because it is FUNDAMENTAL, not because it is a beginner topic!
400
DBA
This session will delve into how modern CPUs work, how batch mode leverages CPU caches and where the pressure points on the CPU are. As a teaser it will demonstrate how a larger column store can out perform a smaller one. It will use tools that go to a level below what those furnised by SQL Server server and Windows can provide, be that the debugger or windows performance analysis toolkit. CPU level stats will be used to explain the 'Science' behind the teaser problem in terms of clock cycles usage, last level cache usage. Finally, the session will take a look at the pressure points are on the CPU when running queries in batch mode. This is a genuine level 400 session and will not feature many demos. There is a two hour long version of this session which provides a more comprehensive overview of how SQL Server leverages memory and includes more demos. The full deck ( which may be subject to change prior to presentation ) can be found here: http://www.slideshare.net/chris1adkin/sql-sever-engine-batch-mode-and-cpu-architectures.
300
DBA
Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different.  Join Tim as he goes over what to look for when tweaking your index strategy: poor clustering key decisions, under-used indexes, covering indexes gone wrong, overlooked heaps and fill factor failures are just a few of the blunders to be identified.  Pointing out what is sub-par is only part of the process though.  As a group we will discuss what the better options are based upon what we uncover over these two hours.

In a combination of instructor-led training and group discussion formats we will use various constructs including Dynamic Management Objects and System Catalaog Views to identify improvement points and then discuss what we would do differently should we see these issues in our environemnts.
200
DBA
In this session I will talk about Central Management Server and how it can help you manage a disperse environment.  I will also cover what Policy Based Management is and how you can leverage its power to better manage your environment.  With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise.  I will demonstrate PBM from creating and evaluating policies to receiving alerts on policy violations.
300
Dev
In this session we will present and demonstrate many tips & tricks that can help developers take the best out
of SQL Server. The tips you'll learn in this session will help you increase productivity and improve performance of your application. We picked the topics that are less known and yet have a great impact.
The session is based on SQL Server 2014, and includes some of the new features in the new version, but it is relevant also for SQL Server 2008/R2/2012.
200
DBA
Flash storage is a game changer for virtually every app in which it is used.  Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head.    Learn how flash flips the /faster bit & what it means not just in terms of performance, but also cost, data & log file placement, & other issues.
200
Dev
How do you deploy your SQL scripts across environments? If you run them individually or have no process this is just the session for you. Primarily aimed at developers but also useful for DBAs, this session will explain ways in which the SQLCMD utility can be used to improve the SQL script deployment process across environments. The type of script doesn't matter – table, stored procedure, function, DDL – you can package them all up and execute them with a single command.

If you are interested in learning more about the SQLCMD utility or just want some ideas on how your deployment process can be improved, this could the session you've been looking for.
200
BI
Self-Service BI functionality is one of the big goals of the modern Microsoft BI stack. But with the ability to bring business intelligence functionality to a much broader audience the danger of inconsistency, redundancy of information and accountability as well as security concerns and data quality problems can increase.



In this session, we will show data governance best practices and what capabilities for data governance Power BI has in place. In addition, we’ll discuss how you can enhance your self-service BI landscape with Master Data and Data Quality Services for improved governance.
400
DBA
A good backup and restore strategy is the most important thing that a DBA should be worried about each day.

Most DBA's know the standard options for implementing a basic backup and restore plan. But there are also not so well known options that can help you with a more advanced recovery plan and that will increase the speed of your backups and restores. This session is bulk loaded with demos and it will give you a good idea what infrequently features can be helpful in your environment, like:  
  • Backup
    • Partial backups
    • Full File Backups
    • Backup Encryption
    • Backup striping and backup I/O buffers
  • Restore
    • Restart an Interrupted Restore
    • Files and Filegroups
    • Online Restore
    • Restore pages
    • Piecemeal Restore
  • Backup and Restore System Databases
 
200
DBA
A real DBA don’t need a GUI -A Guided Tour of SQL Server Management Studio

SQL Server Management Studio is at the heart of any SQL Server DBA or developer’s day. We take it for granted  but rarely do we take a look at how we can customise or improve it to make our day to day work easier and more productive. 

This presentation will show you how to use SSMS and will look at many of the hidden features and shortcuts that you had forgotten about or didn’t know were there.

At the end of this session you will have learnt at least one new feature of SSMS that you can use to improve your productivity.
200
BI
Did you know that Power View is not any longer limited to getting data from Tabular models ? Now that Power View users can connect to multidimensional BI Semantic Model (Cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models. The session will present - An understanding of the Multidimensional Model Objects in Power View - How to create a Shared Report Data Source Connection to a Multidimensional Model - How to create a Power View Report with a Multidimensional Model Data Source - An visual exploration of a Multidimensional Model by using Power View 
300
DBA

SQL Server Resource Governor

- Overview of concepts
- Permissons required to manage resource governor
- Managing Resource pools
- Manging Workload groups
- Classification functions
- Templates
- Changing Resource Pool Settings
- Moving a workload group
- Viewing resource governor setup using DMVs
- 2014 enhancements for physical io management

Performance Data Warehouse.
- Concepts (Create Warehouse,Data Collection Items and Sets,Collection Target,Configure Collection, Analyse Results)
- Collector Types (T-SQL Query,Trace,Performance Counter,Query Activity)
- Configuring Performance Data Warehouse
- Configuring Data Collection
- Review Results
200
Dev
In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output.  This includes looking at the graphical as well as the XML version of the execution plan.  We'll explore the variety of operators that the execution plan can present you with, and show you how to tell the SQL Server that you want to change the execution plan to get rid of the operators that you don't want to be using any more.
400
DBA
Big Data is here to stay, no doubt about that. And Hadoop is THE framework for Big Data. But what is Hadoop? Is it a friend or foe for SQL Server DBA? Let’s explore what Hadoop is and how to make it work together with SQL Server.

I will discuss Hadoop features, components and extensions (Map-Reduce, YARN, Spark, Hive and Impala). I will show how to start a proof-of-concept Hadoop project on a small budget, including hardware, software, network, installation, configuration, testing, and tuning details. We will walk through several demos on a small desktop, 3-node Hadoop cluster with data access via ODBC from familiar Windows tools (Excel, SSMS, SSIS, SSRS, SSAS).
300
DBA
Have you ever been in a situation where suddenly all the records of a table have been deleted and everybody was playing Manuel, I know nothing?  A lot of DBA’s want to know who did what and when on their SQL Server. Since SQL Server 2008, Microsoft introduced a new feature SQL Audit. It allows you to audit your users on several actions on your databases and server. In this session you will learn the principles of SQL Server Audit and the different configurations along with practical examples. By the end of this session, you can easily tell who did what and when on your database.
400
BI
A SSAS MDX Deep Dive session covering the implementation of a business requirement to identify rogue behaviour over time and within SCD organisation groups.
300
DBA
In this session we'll take a look at a wide variety of topics, from useful and little known TSQL coding constructs to best case indexing advice and a whole lot more.


Using lots of demos and examples we'll examine things such as query and join simplification, SARGability and inverse predicates and lots more things.


This will be a lighthearted session and attendees will leave with a wealth of tips, tricks and ideas to take away and put into use almost immediately
300
BI
Data Warehouses and OLTP systems are different!  But there are some core concepts that we need to understand for managing and maintaining both.  Do you want to know how you can load data faster, just by setting up your database correctly?  Are your queries running slow?  Want to understand how you can reduce locking and blocking in reporting queries?  Do you have a system with views, that reference views, which reference more views?  Let's discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!
400
DBA
This session covers how modern CPU architectures work and are laid out in terms of instruction pipelines, front and back ends, CPU caches, the root complex, how memory is fed into the CPU, NUMA, the relevance of using large pages and why it makes a difference. To whet the appetite of the attendee as to why this matters a simple scenario will be presented which defies conventional wisdom in which a fact to dimension table join with column store can outperform the same query using a smaller column small. The second part of the session will "Join up" modern CPU architectures and batch mode by covering off via demos the pressure points that batch mode places on the CPU, cache usage and CPU cycle usage. Column store technology is designed to be CPU aware, by this it achieves stunning performance gains over row mode for OLAP style queries and work loads by leveraging CPU caches and pre-fetching to the full, this session aims to provide a comprehensive level 400 insight into the hardware and database engine theory behind this. This session will be be pased in part on the material in this slide deck: http://www.slideshare.net/chris1adkin/sql-sever-engine-batch-mode-and-cpu-architectures.
400
DBA
This critical situation still exists in many live production environments in various organizations. This quick Life Saver techniques will quickly enable you to provide prompt solution as a patch with Resource Governor features. This helps to manage memory, cpu resources and enables various applications & reporting to perform better by creating resource pools and allocating the memory for various groups, users, databases, applications. This session answers below questions.
  1. What does Resource Governor do? 
  2. What is a resource Pool? 
  3. Why any basic/intermediate users are given caution before implementing Resource Governor?
  4. What is this capable of doing in terms of allocating resources to the users, databases and applications? 
  5. What are the methods to implement Resource Governor & how to monitor the resource pools in terms of GUI & T-SQL?
There are plenty of questions raised for implementing the Resource Governor. Let us take a deep dive in understanding the internals & architecture of Resource Governor and implementing & maintaining a live environment with live sample.

You can take away working scripts, functions, tools to make a Resource Governor work and manage them.

Prerequisites:
Basic idea about memory & other resources within SQL Server.

Session Goals:
  1. To better understand the CAUTION given to basic/intermediate users.
  2. To enlighten the admins to use Resource Governor and the ways to identify and help a specific P1 applications to perform much better.
  3. Organize and streamline the users, ad-hoc requests and other congestions that make the SQL Server perform very poor.
300
DBA
Ever came across those rogue queries that ended up maxing out the CPU/memory/IO resources and caused SQL Server to become very slow and almost unusable? I bet you were not happy and neither would the CEO be when his critical and time-sensitive business report took ages to complete.

Don’t worry, you can stop this –the power is in your hands. Resource Governor is a real working dog and can be the DBA’s best friend. It provides DBAs with a way to deal with rogue and runaway queries which could affect SQL Server’s performance and all other users.

SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. It enables you to specify limits on the amount of CPU, physical IO(since SQL Server 2014), and memory that incoming application requests can use.

By leveraging resource governor in SQL Server, you can achieve Predictable Performance especially in consolidated or shared SQL Server instances. Those rogue queries can be throttled to prevent them affecting everybody else.

Come to learn (with the help of some demos) how to get started with Resource Governor and how to use it to limit the resources which particular users/applications can use or how to ensure some of them get guaranteed amount of resources.

We will cover the SQL Server 2014 enhancement to Resource Governor – the ability to restrict IO, in detail.
300
DBA
The most powerful tool when tuning a single query or a single batch is the execution plan. By analyzing the execution plan of a query, you can learn all you need to know about how the query processor chose to execute the query, what causes the execution to take so long, and what you can do in order to make it run faster.
But there are several common pitfalls that you should be aware of when analyzing an execution plan. These pitfalls can be very misleading, and they might cause you to spend your tuning effort in the wrong direction. By understanding these pitfalls and avoiding them, you can save a lot of time and effort, and you can get your query to run faster - faster…
300
BI
Any business report requires some sort of time intelligence
calculation: year-to-date, month-to-date, same period last year, growth in
absolute value and as a percentage. You can implement most of the time
intelligence calculations using standard DAX functions but, when it comes to
handling complex scenarios, only modeling, imagination and technique together
can help you solve the challenge.

In this session, Alberto Ferrari will quickly run through
the basic time intelligence technique and then performs a deep analysis of more
advanced scenarios, like week-based calendar, non-contiguous date selection,
moving windows over time and handling of holidays in different countries. It is
also a good chance to see how DAX and data modes can help you solve complex problems.
300
DBA
This session is 90% live demonstrations.  I'll walk you through a complete AlwaysOn deployment.  You will see firsthand how to install and configure an AlwaysOn Failover Cluster.  I'll also show you how to setup an AlwaysOn Availability Group across 5 nodes using both the GUI and T-SQL so you know why and when to use each method.  I'll finish up by showing how you can connect to a readable secondary.
300
DBA
While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
200
DBA
Availability Groups, first introduced in SQL 2012 has enjoyed a lot of investment from Microsoft and without doubt is the “goto” HADR technology for the foreseeable future.

In this demo based session we will start with a single un-protected database and attempt to migrate it to Availability Groups stretching between on-premise and cloud while  utilising as many new features as possible

This session will be useful for anyone who has not yet used Availability Groups in SQL 2014 and wants to see it in action.
200
Car
Let’s talk about your career. You’ve been a DBA for a week, a month, a year, or ten, but do you know all you need to about keeping up to date? Job hunting and recruiters? Are you an interview ace? We’ll talk about all of this, and much more. To answer your specific questions, we’ll wrap up with a question and answer session.

We've given this talk again and again, and attendees give the highest marks and ask the best questions, time after time. Come and hear the best career advice you've never heard.
300
DBA
SQL Server Replication Introduction

- Replication Architecture (Publish,Distribute,Subscribe)
- Replication Types
- Snapshot Replication
- Transaction Replication
- Peer to Peer Replication
- Merge Replication
- Replication Monitor
- Using NOT FOR Replication on Contraints,Columns,Triggers.
- Limitations on Replication including Replicating to other database products.
400
DBA
The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators. 
What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare.
This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works
200
Dev
In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2000-2014 databases.  We will also be looking into the new indexing features that are available in SQL Server 2012/2014 (and SQL Server 2005/2008) and how you the .NET developer can make the best use of them to get your code running its best.
200
BI
All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or whip it up in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!
300
DBA
In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query. 

We will also take a look at various operators, how they work, why they are chosen and how to avoid them being used in the wrong place / context,.
Attendees of this session will walk away with a greater understanding of query plans and the operators, which will enable them to both better interpret their query plans and also write more efficient SQL code
300
BI
Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis out of operational databases. By the way there are some challenges in design and implementing Data Warehouses which needs robust and reliable ETL implementation. In this session you will learn an ETL Architecture implemented by SSIS and MDS to solve couple of most challengeable Data Warehousing scenarios which are Slowly Changing Dimension and Inferred Dimension Member. There will be many demos through this session which helps you to understand design and implementation of the architecture.
500
Dev
In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server 2012 and SQL Server 2014 work. We are going to use Soundex Transact-SQL function, four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. Finally, we are going to introduce how SQL Server 2012 Data Quality Services (DQS) help us here. We are also going to tackle the performance problems with string matching merging. 
300
Dev
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.
200
BI
Statistical analysis and different methodologies are being practiced in terms of dealing with junks of data. In terms of big-data there are many tools available including Hadoop, Insight to deal with it perfectly. But where does this 'R' fit in and how does it help high end analysts to answer statistical related questions. 

In terms of 'R' programming analysis with SQL Server database, we can see the best possible methodologies availale to find the ways how the graphs and chart can improve its performance as well as what are the various analysis can be done with it.

Prereq:
Knowledge in Database
T-SQL Querying
'R' Programming Concepts is a plus
200
DBA
SQL backups within your enterprise should be like making coffee, good and often!  One of the most important aspects for a database environment is ensuring reliable backups are being executed and a dependable recovery plan is established in case of a system failure or data corruption. Setting up basic backups is quite simple.  Adding on log backups and differentials is easy as well. However, in real life, we still see a lot of wrong backup configurations and backup failures! In this session, you will learn about the backup and restore strategies, the different recovery models, the main backup types, implementing restore scenarios, restoring a full backup, restoring to a point in time and backup/restore best practices.
200
Dev
Everyday more and more people are moving towards CI/CD development. Before users take the step to implementing CI/CD they're unsure of what tooling to use and which is the "best". This session is aimed as an introduction to MSBuild and how you can leverage the engine to build and deploy your source code. We'll look at the full Business Intelligence stack. 
300
BI
Learn from more than a dozen real-world scripting patterns in SSIS. In this session, you’ll walk away with piles of code to do more advanced data cleansing in SSIS, watch for files and stop performing the same task over and over again.
400
DBA
In SQL Server 2014 query processing has been improved. What we can expect from new cardinality estimator? Does it really estimate better? Will our execution plans be better after migration to 2014? All of them? Is the key ascending column statistics problem solved in new version? Do we finally can have more than 200 steps in the statistics histogram per table? What about column correlation and cardinality estimates - are the predicates still completely independent?

This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.
300
BI
Budgeting is one of the most challenging scenarios in the
Power Pivot arena. For example, you might need to summarize sales in previous
years and to allocate the budget forecasts. You have to work with data at
different granularities and to find a way to author DAX code to compute the
forecasts at the desired granularity.

When it comes to budgeting, each company is a unique
scenario. In this session, Alberto will show you some common techniques to use when
building a budget model with Power Pivot and Power Query, including previous
year allocation, multiple-step budgeting with linked back tables, handling of
budget on products which do not yet exist.
300
DBA
There are always performance problems that could happen in your production database. But you will be surprised how many of them occur as a result of DBA’s actions or lack of attention to SQL Server Instance and database level configuration settings. If you know them and how they harm your database system it will be easier to not get there. During the session Magi shows some of the worst practices in configuring your SQL Server, explains their whys and gives you the hints to the right settings. Sometimes you are just a few clicks away from a good SQL Server configuration. This session gets them to your fingers.
300
BI
Data Scientist is said to be one of the hottest jobs in the world. And Machine Learning is one of used tools of a data scientist to get insights out of raw data. Microsoft release last summer AzureML, their cloud offering for machine learning. And in the Hadoop world Apache Spark is gaining more and more momentum and Hortonworks, Microsofts Hadoop partner, has added Spark to their platform. Two flavors, but how do they compare or can you use both? Do they compete or are they complementary to each other? What is Machine Learning and how can I it in my solutions? A lot of questions and let’s find the answers in this session.
300
DBA
Using one of the various tracing capabilities of SQL Server, is the best way to keep track of what is going on in your SQL Server to cause performance problems. But if you haven't set up any tracing, what can you do to find out what problematic queries might be running? In this session, we'll explore SQL Server's plan cache, from the way it is managed in memory, to the tools and techniques for discovering what plans are in cache, how long they've been there, how often they've been run, and whether they contain any suspected sub-optimal operators, such as table scans and hash joins. Knowing what's happened is the first step in knowing what needs to be fixed.
200
Dev
With the explosion in data and 24x7 requirements it is important to understand how to process and load large volumes of data into your OLTP environment. (This is certainly a recipe to stress out your DBA!) 

In this session, we will discuss how SQL Server 2014 comes with new Transact-SQL functions and index enhancement to help solve high volume data processing requirements. Which should result in less impact on your production server(s) and less stressed DBAs!

We will demonstrate ultimate batching techniques to conquer high volume data processing in SQL Server 2014, and compare it with your options in SQL Server 2012 and earlier. This should help justify an investment in SQL Server 2012 from both a development and performance perspective. 

Session takeaways: 
• Understand batching techniques to adopt and their usefulness for managing high volumes of data 
• Learn SQL Server 2012 enhancements for high volume data processing 
• Learn how the Balanced Data Distributor task in SSIS can be used for types of high volume data processing 

300
BI
Analysis of raw data requires us to find and understand complex patterns in that data. We all have a toolbox of techniques and methodologies that we use; the more tools we have, the better we are at the job of analysis. Some of these tools are well known, data mining for example. This talk covers some of the less well-known techniques that are still directly applicable to this kind of analytics. These include: Monte Carlo simulations (MCS) Nyquist’s Theorem Benford’s Law Simpson’s paradox This session will focus on how understanding these techniques can help you understand complex data patterns in your day-to-day work. For example, it turns out that some problems are very, very difficult to solve by standard mathematics. Take the random walk problem, for example. If you stand in a desert and take each step in a random direction, how far are you from your origin (on average) after n steps? Given that Albert Einstein worked on the problem, the mathematical proof is obviously non-trivial. (Unlike the answer, which is simply the square root of n). That self-same problem can be solved using a Monte Carlo simulation which can be written in just nine lines of code. I fully understand that you are unlikely to want to solve this particular problem (for a start, it’s already been solved and, in addition, who would really walk like that in a desert?). But the point is that many problems, from understanding web page usage to the behaviour of users of a video-on-demand system, are horribly difficult to solve as a mathematical problem and ludicrously easy (in relative terms) using a Monte Carlo simulation. Nyquist’s Theorem can be used to tell us, for example, how often to sample smart electricity meters, and much more. Benford’s Law is fabulously powerful for detecting fraud and so on. This session will NOT include any heavy (or, indeed, light!) mathematics; instead, it will focus on how understanding these techniques can help you understand complex data patterns in your day-to-day work. It is a shortened version of a pre-conference, day-long session that I gave at PASS earlier this year.
300
DBA
Microsoft document a lot on how to configure AlwaysOn, but most of this is focussed on standalone replicas, which to be frank are relatively simple to implement. What about those tier 1 solutions that want to also take advantage of SQL FCI as well as AG’s? Again this is fine if it is in one data centre. What about cross site?

Again, fine if you have SAN/ hardware replication. What about if you don’t have cross site storage replication due to budget or other technical constraints? I will walk through a solution that I have built which gives a true tier 1 solution consisting of 1 Windows Cluster, 2 DC’s, 3 SQL FCI’s & 4 AG’s.

300
BI
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 the tools mentioned.
400
Dev
SQL Server 2014 includes a new cardinality estimator and, in this version, the old cardinality estimator is available as well. A cardinality estimator is the component of the query processor whose job is to estimate the number of rows returned by relational operations in a query and this estimation, along with some other data, is used by the query optimizer to select an efficient execution plan. Since every query in SQL Server has to work with either the new or the old cardinality estimator it is essential to understand how they work, what their differences are and how to detect and troubleshoot related problems. This session will explain these and other topics including why a new cardinality estimator was built, how to detect and fix plan regressions and some of the cardinality estimator assumptions.
300
BI
Microsoft offering has seen many improvements lately in terms of providing suitable tools for Managing the entire Lifecycle (ALM) of Business Intelligence (BI) Applications. However, for many reasons, uptake of these tools have not been particularly great. One of such reasons is a steep learning curve for many BI professionals, who came from analytical or admin backgrounds with little experience of .Net development with Team Foundation Server (TFS).

This presentation aims to provide a learning framework. It gives an overview of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit. The presentation will also cover unit testing using MS Test, continuous integration with MS Build and a demo of TFS Deployment Manager for a typical BI application. This will include a database project, SSIS, and SSAS projects.

The material does not assume prior knowledge of TFS administration, but some experience using TFS source control and general TFS terminology will be helpful.
200
BI
Data warehouse designers often ignore the specific needs of an OLAP database when formulating their schema design. They consider the cube as 'just another reporting layer', with no specific needs. In a world where businesses need instant answers, this approach can be dangerous as it can seriously degrade your cube's load performance and make incremental loads nigh on impossible.

This session will outline the best way to optimise your data warehouse schema so that it complements, rather than fights, your multidimensional OLAP database, allowing your cube to be loaded efficiently and moreover facilitating fast incremental loads so that new data is brought on-line quickly. We will cover the design of database tables and views with specific emphasis on data types. The use of table and cube partitioning. Also, how to support incremental loads of not only fact data into partitions, but also dimensional data.
400
Dev
Dr Manhattan has god like powers, he has the ability to control matter at a subatomic level, so why can't we? If you have heard you can modify the build and deployment actions for a database project, but you are not sure where to start, this session will be the one for you. Join me to take an in depth look into how you can customize the database build and deployment, and become your very own super hero. 
300
BI
Reporting Services is a great tool to send out reports by email or files. But if you ran into limitations with the subscriptions microsoft offers, or if it's not as easy as you would like to, this session is for you. I'll show you how to integrate your reporting tasks in ETL jobs, how to manage your distribution lists centrally, how to update parameters and manage smtp issues. Spoiler: This will be using Reporting Services web services, some c# programming, and some free tools.
400
DBA
Distributed Replay controller (DRC) was added in 2012, it is a powerful feature

Previously the ability to replay workloads from multiple computers to simulate mission-critical workloads was a complex task

Come find out how easy it is with DRC Starting with Installing and Configuring DRC, after which we will then explore the approach & steps for Load & Stress testing your workloads on a database from multiple clients We will also cover the following

Preparing Trace files for DRC clients

Command line Options

Evaluate Results

Explore usage scenarios such as Application Compatibility Testing, Performance Testing, or Capacity Planning
200
DBA
Are you currently running maintenance plan tasks but don’t fully understand what they are doing? Do you rely on the maintenance plan wizard for all your maintenance tasks? Are you seeing slowness in performance during or after your maintenance plan runs? You will learn several common mistakes repeated in the field that could hurt performance, put your recoverability at risk and be able to mitigate them. We will cover in detail the Shrink Database Task, Backup Tasks, Check Database Integrity Task, Rebuild Index Task, Reorganize Index Task, and Update Statistics Task. We will cover why you might not want to include some of these native tasks in your enterprise maintenance tasks. Finally, we will cover how you perform a maintenance plan assessment across your SQL Server Farm.

Goals:
1. Identify common maintenance task mistakes and learn best practices to mitigate these commonly repeated mistakes.
2. Learn how to quickly assess your maintenance strategy across your SQL farm.
3. Understand why native maintenance tasks can cause performance problems and learn best practices for properly configuring maintenance plans.

300
Dev
Any data professional who is responsible for performance tuning, has their way of gathering data to troubleshoot and solve issues. But what if I told you there was a different way, a better way, to collect the data you need without consuming additional SQL Server resources?

Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees will learn about some .Net classes to control timer events and the PowerShell Register-Objecteven cmdlet.

Attendees are encouraged to send their challenges to me by email. They can find additional details and instructions in my blog post -> http://goo.gl/Q2GjH3   I will review their scripts and select some of them to demonstrate in the session by offering an alternative using PowerShell and the event subsystem.
200
Dev
We will first understand why accurate Cardinality Estimation is crucial. What model assumption we have while calculating Cardinality. What are the major changes made on new CE compared to legacy CE-70. Also we will see how can we implement new CE without changing the compatibility level. In this session also I will show Troubleshooting Methods with New CE.
300
BI
If you are developing SSRS reports on top of an Analysis Services cube, this is a session not to miss.

We will explain the internals of reporting services architecture, along with how to spot and correct common design and performance issues.

In addition we will show you how logging information provides all the information you need to identify key performance issues in production.
100
Dev
Ever wonder how someone else does it? There’s no right way or wrong way, but in this session, you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries, tries various techniques to make them faster, and shows how he measures the before-and-after results.

You'll learn:
  • How to measure your changes as you tune the query
  • How to read execution plans
  • Why user-defined-functions and table variables can backfire
  • How SQL Server 2014's new cardinality estimator affects your queries
  • How to tell if SQL Server threw in the towel while building your query plans
  • What free tools make the process much easier
300
DBA
Do you know exactly what happens with your Microsoft SQL Server and what happens inside the Microsoft SQL Server? Does your manager report delays in the queries and you have to find the bottleneck quite fast?

The daily business of a dba is focused on the stability of the SQL Server databases and this session will help you to understand and monitor the activity on your Microsoft SQL Server with given tools by SQL Server itself.

- monitor the physical connection from the client to the Microsoft SQL Server
- see, what requests are currently running on your Microsoft SQL Server
- what process is blocking the execution of the management report?
- what command is the application fireing against your SQL Server?
- what tasks have to wait and why do they have to wait?
- how does the scheduler handle multiple requests / tasks and how can you monitor it?

If you are interested in the above scenarios and want to see solutions you should visit this session which will approve your dba skills.
400
BI
If you work with an amazing visualisation plugin NodeXL for Microsoft Excel you might have asked yourself the question - how do I get my custom data for getting those great visualisation for analysis.

This session will show you a couple of different ways of getting data into NodeXL using some standardised ways as GraphML and diving into writing your own custom wrapper that you can use for the projects or giving back to the community.

You will need to have good knowledge of XML as well as some C# knowledge in order to understand this session. This is a programmer's oriented session with focus on programming skills.
200
BI
Are multidimensional modelsdead on arrival? Are tabular models the future of analysis? Come to this
session to learn the similarities and differences between these two approaches to analytical modeling available in SQL Server 2012 and 2014 Analysis Services. We’ll explore the pros and cons of each type of model and review how to select the appropriate model to your analytical requirements.
300
BI
The future of data analysis is the in-memory xVelocity Tabular analytic engine but is this newer product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012 & 2014? Maybe… It depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.
300
BI
As more and more Projects adopt to the agile approach the need to be able to safely deliver changes to a running solution is becoming more and more important. By setting up your toolbox and adding some community tools, every team can gain the ability to deliver requirements fully tested and in a timely manner. Join this session to learn how to setup automatic processes for the deployment of BI Projects including SSIS, SSAS and databases.
400
Dev
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. It starts by explaining how the query optimizer is used in Hekaton by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. The session will then move to cardinality estimation. SQL Server 2014 includes a new cardinality estimator and, since every query has to work with either the new or the old cardinality estimator, it is essential to understand how they work, what their differences are and how to detect and troubleshoot plan regressions and other related problems. The session concludes explaining incremental statistics. Incremental statistics is a new feature that you can use to update statistics at the partition level which can be an enormous help in updating statistics in large tables.
200
BI
Give your queries a multidimensional makeover. In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes.

We'll start at the beginning, so you need no previous MDX experience, but it does help to understand what a cube is.

We'll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or (). We'll look at examples of each, and show how you can easily access the immense power of cubes with relative ease.
400
BI
There

are some challenges in implementing ETL for real world data warehouse. In this one day conference we will deep in dive for challenges such as; Inferred Dimension Member, Slowly Changing Dimension, Late and Early Arriving fact tables, Durable natural Keys, Accumulating fact tables. SSIS best practice and practical solution will be discussed and you will see live demos of solving above challenges with SSIS (combined with MDS sometimes). Challenges above are avoidable in most of the data warehouses, so a pragmatic solution with considering best practices would be necessary learning for every ETL and BI developer, consultant, and architect.

Each challenge will be discussed in this way; defining the problem, exploring what is data warehousing solution for the problem, exploring issues of ETL implementation for that solution, elaborating different methods to implement the solution, proposing the best practice and practical real world ETL solution for the problem. Lots of live demos will be used in each step.



Here is the more detailed explanation for the Inferred Dimension Member Solution with SSIS and MDS; 

Combining Master Data Services with Data Warehouses, will cause some challenges in ETL Scenarios. In this section we will go through a demo of Inferred Dimension Members implementation with SSIS considering the fact that MDS keeps the single version of truth for the dimension record. In this section you will learn how we will write back new record's data into MDS entity as an Inferred member. The staging structure of Master Data Services and Batch Processing will be used for this. Then you will learn what is the best practice to add the inferred record into Data Warehouse dimension. Updating the existing dimension member also would consider the Inferred member and apply SCD types only if this is not an inferred Member.



Each component of this precon (each scenario) presented in different conferences and received well feedback as informative session.
200
Dev
Continuous Integration (CI) is a well known process in the software development world, but it’s not often implemented with databases. This is despite the fact that database code could benefit from the practice of checking the changes on a regular basis for potential issues. This talk will show how to implement continuous integration for databases and include more realistic testing of the code for potential issues. We will cover the following concepts: CI configuration of a build, linking your CI server to a VCS, generating random data, testing a build, catching a bug with the CI process and correcting it.
300
DBA
You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008 to SQL Server 2014. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to monitor your checklist items against the whole SQL Server farm.
300
BI
You have invested tons into your datawarehouse, only to build static reports in SSRS. That’s sad! After all, a good star schema is the perfect foundation to easy Machine Learning. So let’s do what the analysts say and leverage all that potential synergies, directly into the Cloud! ;) Well, at least, let’s talk about Machine Learning, in words understandable by BI professionals, and check out what Azure ML is all about.
200
DBA
Database replication doesn't get much attention, especially now that the AlwaysOn features have been released into the wild. However, replication offers another way to make data available on multiple servers/locations that steps outside of "normal" HA/DR scenarios. This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication. The content will be valid for all versions of SQL Server from 2005 onward.
300
Dev
Microsoft has clearly positioned the Entity Framework 6 (EF) as the primary data access platform for .NET applications. But many developers have yet to embrace the powerful Object Relational Mapping (ORM) capabilities that EF offers. Whether you’re new to ORM, or you’ve dabbled in other ORM technologies, Lenni will show how quickly you can start working with EF6 and boost your productivity when building data-centric .NET applications. We’ll begin with a quick introduction to ORM and EF, and then explain many of the special ORM features in EF6, such as the Entity Data Model (EDM), and support for table splitting, inheritance, entity splitting, and many-to-many relationships. With the basics covered, Lenni will then dive right into live demos that show what EF can do for you as a data access layer, using database-first, model-first, and code-first approaches with both direct SQL and stored procedures. We’ll also discuss new features introduced in EF6, and show how to use EF in N-Tier scenarios.  
300
DBA
SQL Server 2014 introduced two amazing technologies: In-Memory OLTP and Clustered Columnstore Indexes. Amazing as they are, they don't fit every scenario and require special care in order to maximize the benefit from them.

On this session, we will take a deep dive into the internals of the two technologies and see how they "do their magic".
Once we understand the internals of the two technologies, we will talk about the right ways and the right scenarios to work with each one of them.
300
Dev
We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability. Taking an entirely disk based system and modifying it to really make use of In-memory OLTP capabilities. We will look at how to identify good candidate workloads for In-memory OLTP, then we will look at how to go about moving to a hybrid system of disk based tables with memory optimised components within the database to enhance the capability to get the system to scale. I will show some options for identifying objects to migrate and some of the design considerations you will need to take into account if you want to make use of this feature.
200
DBA
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics - the dramatically easier way to find your SQL Server's bottleneck.

You'll learn:
  • How to collect wait stats data in thirty seconds (no, seriously)
  • How to interpret confusing results like CXPACKET and PAGELATCH
  • How to explain the results to clients, end users, and developers
300
DBA
Have you ever been in the situation that an application performed well yesterday and - suddenly
- you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance!

This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!

- Why performance degradation in spite of maintenance jobs?
- just one more row in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part  bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?

See the problems in demos and learn how to handle it for a better performance!
200
DBA
While data compression is best-known for reducing a database's size on disk, it's also an effective tool for making your queries fly. Come see how reduced disk usage and increased performance mean that with compression, less really can be more! This session will arm you with the knowledge and understanding to capitalize on both of these aspects of SQL Server's row and page compression features, as well as columnstore and the new updateable columnstore indexes found in SQL Server 2014. We'll combine a lesson on the internals of compression with real-world scenarios to show you how to determine the most appropriate compression type for any situation. Since there's no such thing as a "free lunch" in computing, the drawbacks of these features will also be discussed.
300
Dev
The APPLY operator is available in T-SQL for quite some time now, but for many people it’s under the radar. People who do know it can’t stop using it, and this session will show you why. The session starts with a brief overview of the operator and its fundamental optimization aspects. Then the session demonstrates some of its more creative uses.
300
DBA
Microsoft released SQL Azure more than three years ago - that's enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services (and not only). In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
200
Car
The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field. What does the future look like for DBA's, BI Developers, and Architects? Come get the lay of the land and guidance on keeping your career and learning on the right path. 
200
BI
Q&A is a feature of Power BI that allows your end users to query data stored in Power Pivot in natural language - that's to say they can type in a question in plain English and Q&A will attempt to answer it. How well does it work though, and is this something your end users really want to do? In this session you'll learn about how Q&A works and what you need to do to optimise your model so it works as well as possible.
300
Dev
Building modern applications for elastic scale, varying performance needs, and multi-tenancy can be achieved by breaking away from the traditional on-premises design point. In this session, we’ll discuss how you can blend a variety of Azure data services to best achieve performance, scale, cost-efficiencies, and data protection based on the needs of your cloud-born application data. The cloud opens up a new world of opportunity and innovation when it comes to database and application design and this demo-heavy session will provide a clear picture into leveraging these data services.
200
BI
Every month there are some new features added to Power BI components. Power Map is the 3D Data Visualization component that works with Geo spatial data. In this session you will learn about new features of Power Map, and using these new features along with existing features in real world scenarios. this session shows how Power Map acts as an important data visualization tool for Geo spatial data visualization scenarios.
200
BI
Azure Stream Analytics, Azure HDInsight, Azure Data Factory, Azure Machine Learning… New tools that put together begin to form a new environment to grow BI platforms in, like we were never able to do before. Let’s make sense of all that and define canonical architectures for modern data platform, adapted to real world scenarios, used not only for reporting but also for analytics.
300
Dev
SQL Server has a number of encryption features that allow you to
better secure your data. This session will examine the basics of
encryption and cover the various ways in which you can encode and decode
your data to protect it from unauthorized access. Cell level
encryption, Transparent Data Encryption, and backup encryption will all
be discussed. This session is designed for those who want to learn the
basics of how to protect their data.
This talk looks at the encryption options in SQL Server that are
available, including the changes in SQL Server 2012. The agenda is:
  • What is Encryption?
  • Encryption in SQL Server
  • Transparent Data Encryption
  • Hashing
  • Symmetric Keys
  • Asymmetric Keys
  • Certificates
  • SSL Communications
100
BI
Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data that defines a business entity within the enterprise. Get a good business and technical understanding of how MDS can help obtain better business clarity across the organization through a data governance strategy. Data governance is a methodology that represents quality, policies, and process management, in relation to handling your enterprise data. The demo will walk through the basics of getting started with Master Data Services 2012 including the Excel Add-in for Master Data Services.
300
Dev
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail! We will look at raw performance, memory consumption, plan cache usage, and network bandwidth utilization. We will also discuss options for environments on which the code cannot be modified.

(Demos will include WireShark as well as extensive DMV queries)
300
BI
M is the formula language behind PowerQuery. Sometimes you need to tweak your PowerQuery query. On other occasions you might need to do things that can't be done using the GUI. In both cases you will need to write your own M formulas. In this demo rich session you will learn how to do just that.
200
DBA
The IT world is currently in cost-saving mode - cutbacks are all over the place and then Microsoft pushes out SQL Server price hikes. In this session we will discuss how consolidating SQL Server can reduce overall costs and increase efficiency. We will cover the reasons for consolidation along with the advantages and the disadvantages of consolidating SQL Servers. We will also take a look at some of the tools that can assist with a consolidation project and some pitfalls that I have experienced on previous consolidation projects.
300
DBA
In this session, Mark will run through the tools that Microsoft use to track down performance issues with SQL Server. He will demonstrate how to use these freely available tools; SQLDiag, SQLNexus and ClearTrace to not only diagnose your SQL Server issues but make to look like a SQL god to your boss. 
300
DBA
You're hearing a lot about the new features in SQL Server, but you're not hearing a lot about the drawbacks. Ever wonder why? Join Brent Ozar, the guy behind DBAreactions.com, for a sarcastic, funny look at SQL Server 2014's features, bugs, and gotchas.

You'll learn why Brent rarely deploys Hekaton, clustered columnstore indexes, Buffer Pool Extensions, Azure backups and secondaries, and even AlwaysOn Availability Groups. You'll laugh, you'll cry, and most importantly, you'll learn real lessons to avoid pain in your own deployments.
200
Dev
Many developers are working with direct access to the data layer of a database (tables) by ORM or .NET, Access, ... This access methode maybe a good choice for small applications which use a dedicated database where no security or business requirement is needed.

This session demonstrates protection of data by using schemata for data protection and implementation of business logic for multiple applications.

The session content will deal with data integrity on attribute / row / table level. It will show how to protect sensitive data without management of access from the application as well.
Usage of constraints for data integrity, schemas for security and views / stored procedures for business rules will be part of the demo driven presentation.
200
DBA
Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.
200
DBA
Whoever coined the term "one size fits all" was not a DBA. Very large databases (VLDBs) have different needs from their smaller counterparts, and the techniques for effectively managing them need to grow along with their contents. In this session, join Microsoft Certified Master Bob Pusateri as he shares lessons learned over years of maintaining databases over 20TB in size. This talk will include techniques for speeding up maintenance operations before they start running unacceptably long, and methods for minimizing user impact for critical administrative processes. You'll also see how generally-accepted best practices aren't always the best idea for VLDB environments, and how, when, and why deviating from them can be appropriate. Just because databases are huge doesn't mean they aren't manageable, attend this session and see for yourself!
400
DBA
Last year the new In-Memory OLTP Engine in SQL Server 2014 had its premiere. Now we will take a closer look at „XTP“-Engine and uncover the technical implementation of memory-optimized tables & indexes, as well as background processes that are  responsible for the data-structures: the merge-process and the garbage-collector.
400
DBA
Multi-Site configurations are the natural progression from the more orthodox Failover Cluster Instances that form the basis previous High Availability configurations. With the introduction of Availability Groups and multi-subnet capability with SQL Server 2012 it is now even easier to build a multi-site & multi-subnet solution. With this ease of deployment it is more important than ever to look at the important configuration options that can have a big impact in multi-site implementations but not in single-site.







Covering things like Asymmetric storage configurations, DNS considerations and the advances in clustering. By the end of this session, you will be in a position to confidently start building out multi-site Highly Available and effective Disaster Recovery solutions that meet the complex needs of your business, for on-premises, hybrid and cloud based deployments.
300
DBA
This session will look at SQL Database Elastic Scale through the important lens of the DBA, focusing on the critical aspects of database performance, maintenance, and management without adding unnecessary complexity. In this demo-filled session, we’ll look an inside look at SQL Database Elastic Scale which simplifies the process of scaling the data tier of a cloud application and the impact this functionality has on database performance and multi-tenancy and what this means for the DBA in his mission-critical role.
300
DBA
There's lots more to SQL Server than meets the eye. If you like to peek under the covers, this session is for you. We'll cover documented features and find some interesting but little-known tidbits, then move on to undocumented and semi-documented objects and procedures. We'll also look into the guts of SQL Server to find clues about new features, and use SQL techniques to do it! You'll learn about system objects, internals, and other utilities to peel away all the layers and discover all the hidden treasure inside.
500
DBA
The session focuses entirely on troubleshooting your SAN using free Windows and SQL Server tools - with a 100% focus on SQL Server.

Have you ever suspected that your SAN was/is the cause of bad SQL Server performance BUT you can't 100% prove it?  OR do your SAN people say 'it's all OK' but YOU know something's not right?

An unashamedly 500 session in parts - so expect an upbeat session with plenty of command-line and hardcore troubleshooting - by someone who does this every day. This session gives you the tools and techniques to peel back the curtain on how your SAN impacts SQL Server.

The concepts are useful if you host SQL Server on any SAN - and despite being a 500 session, people of all levels of SAN expertise are welcome - BUT expect to be challenged in parts . . . come along, it'll be challenging fun!
200
BI
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence development that can create packages based on database metadata. In this session we will walk through a framework that dynamically develops a group of packages that can profile data based on the existing metadata within your current environment. By dynamically tracking the metadata within your environment, you can let Biml maintain your data monitoring solution. This will enable a more thorough view of your ETL environment that will allow you to spot issues faster and create a more scaled infrastructure based on your current performance needs.  
500
Dev
The fight for better performance is a battle of wits: your mind, your intelligence, and your honor pitted against the less-than-dependable whims of the Query Optimizer. But alas, the arbitrary rewrites and clunky hints leveraged by most developers to get around optimization deficiencies make things feel less like a proper duel and more like a skirmish at the sandbox. To truly engage your enemy you must comprehend his inner workings, and in the case of the Query Optimizer, that means you must delve into the mysteries of "row goals." These internal metrics are tracked and enforced within Top iterators--and they exhibit a considerable amount of influence over plan shape and flow, both at compile time and as your query runs. Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries. En garde!
200
Dev
Indexing represents one of the most important aspects of database operations. This session is broken into two parts:

The first hour will cover the theory of the following type of indexes

  • Describe how SQL Server retrieves data.
  • Describe a heap.
  • Describe a clustered index.
  • Describe a non clustered index.
  • Describe a column store index
  • Describe how to traverse data by using indexes.
  • Describe other indexes.
The second hour -- the Power Hour itself -- is a lab to put into practise what you learned. Bring your laptop with the Adventure Works database for a unique session experience.
 
Ensure that the Adventure works 2012 Sample OLTP database is installed as found at the following url http://msftdbprodsamples.codeplex.com/downloads/get/165399
200
DBA
Working on full abstract...i'll update this week.
300
DBA
Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs. 


Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance?


In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many. 
200
Dev
Most ORM's tend to be very chatty and generate complex queries. Which is not a bad thing most of the time, but sometimes it get's out of hand and the queries will either be too complex or, and this I see the most, there will be way to many queries to answer relatively simple questions. Seeing thousands of queries for a simple webpage is not uncommon. In this session we will look at optimizing database access in ORM's. Using Nhibernate, LINQ &Entity Framework in the demos, we will examine how your ORM talks to the database and why. We will look at this problem from 2 sides. As a developer who would like to tweak and tune as little as possible and let the ORM do it's magic, and as a DBA who would like all queries to ask only for the data that you need to have at that time. Using a lot of demo's we will be looking at typical ORM features like Lazy Loading,Mapping, Caching, Inverse Relationships, etc. We will conclude with some best practices and lessons learned.
500
Car
This is not one of those career sessions that tells you to be friendly and network - forget that. In the year 2015, there are better, faster ways towards getting the work you want.

Brent Ozar will talk about his frustration of trying to find a decent job as a DBA, then how he made a few simple changes to turn things around. You'll get a simple 3-year career plan with monthly goals that you can accomplish in your spare time even if you've got a family and hobbies. You'll learn how to start a blog, how to promote yourself without being a slimy salesman, how to set your rates and salary, and why getting certifications probably isn't smart.
200
Dev
More art than engineering, database development is often disconnected from the entire SDLC process.While application developers are moving forward, adopting great new tools and practicing Agile, automation, and continuous delivery, database development is done using a less controlled process.Without proper processes, tools, and best practices in place, databases can easily throw a wrench into the works.My talk will be on how database change should be addressed in order to minimize the risks databases pose during the development life cycle.
200
DBA
The latest version of Microsoft data platform, SQL Server 2014, offers many exciting new features, which allow almost any business requirement to be satisfied easily. SQL Server 2014 is completely cloud-ready, and it's fully integrated with Microsoft Azure. It offers outstanding performance and scalability through in-memory technologies, enhanced query performance and more. It also offers first class high availability solutions under the title "AlwaysOn". And, finally, SQL Server 2014, together with Microsoft Excel and other Microsoft BI tools, offers a complete BI solution out of the box.
In this session we will present all the exciting new features in SQL Server 2014 and talk about the benefits we can gain from upgrading to the new version.
500
DBA
You know locking and blocking very well in SQL Server? You know how the isolation
level influences locking? Perfect! Join me in this session to make a further
deep dive into how SQL Server implements physical locking with lightweight
synchronization objects like Latches and Spinlocks. We will cover the
differences between both, and their use-cases in SQL Server. You will learn
about best practices how to analyze and resolve Latch- and Spinlock
contentation for your performance critical workload. At the end we will talk
about lock free data structures, what they are, and how they are used by the
new In-Memory OLTP technology that is part of SQL Server 2014.    
300
BI
With the outset in a real life solution, build to one of the largest
organizations in the World, this all demo session will take you through a
case of how to build a completely meta-driven SSIS solution relaying on
BIML and MDS to do the hard-work for you
.
Being able to do this and have the system finding the fastest way to
load data automatically using system stored procedures enables you to
offer near real-time reporting to your users.
Topics covered in the session:
  • * BIML & SSIS
  • * MDS
  • * CDC
  • * System SPs (especially sp_depends)
  • * Near Real-time ETL, what it takes and how to do it.
200
Dev
SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all.  Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

You'll learn four important lessons, along with 10 other must-have query tuning techniques:

Lesson 1: Implement a reusable Transact-SQL test harness for reliable query results.

Lesson 2: How to best simulate a large production instance on a small development server.

Lesson 3: Learn ten patterns that kill the performance of SELECT statements and how to avoid them.

Lesson 4: Discover the high-impact metadata that shows how a SELECT statement behaves … or
misbehaves.
100
DBA
One day we woke up and SQL Server were cloud-ready. But is the cloud ready for SQL Server? SQL Server 2014 got a number of new features that are related to Azure. What's up with that? And what is this hybrid cloud thing that people keep talking about?

Join Microsoft Certified Master David Peter Hansen for a journey through the possibilities using the cloud with SQL Server. With a swipe of a credit card, we can get High Availability and Disaster Recovery without having a secondary data center; we don’t need to wait for the new SAN to be installed to get space for that new database; and we can spin up a new development environment in a matter of minutes.
300
DBA
When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.

Attendees at this session will learn:
  • Proper configuration considerations for virtual servers running SQL Server
  • How to identify performance bottlenecks in a virtual environment
  • How to properly troubleshoot issues related to virtualized workloads

200
Car
Several years of work in one industry. Several years in another. The first professional exams, certification and specialization. For several years, in another area - this time in ICT. Even more exams (successful or not), requirements, specializations, orientations. Is certification is for IT guy or IT guy (or girl) for information technology certification? Where to start, what to stop. Where is the end to the possibilities, and where the boundary of joy of work. As far as proving something to someone is necessary in ICT careers. These and several other strange, philosophical, perhaps unnecessary questions I would like to answer. A few I'd like to leave it to its own assessment.
300
BI
SSIS is a well known ETL tool on premisses. Azure Data Factory is a managed service on cloud which provides ability to extract data from different sources, transform it with data driven pipelines, and process the data. in this session you will see many demos comparing ADF (Azure Data Factory) with SSIS in different aspects. you will also learn features that are available in ADF but not in SSIS with many demos.
400
BI
In the Wizard of Oz, Toto pulls back the green curtain to expose that the Wizard of Oz is a fraud. In this session, we will look behind the 'green curtain' of the data visualisation to learn how to 'poke holes' in the data that you are given, both in business and in everyday news headlines. In order to explode the myths in the data that surrounds us every day, it is a little known secret that there are hidden patterns in the data chaos that surrounds us. Deviations from these patterns highlight invention, bias, anomalies and even deliberate fraud. Join Jen Stirrup to learn how to use both data visualisation in Power BI combined with timeless data analysis and patterns such as Benford's Law to reveal or conceal efforts to distort the numbers, and question the veracity of the data. You'll need courage, heart and wisdom to analyse data, since truthful data doesn't necessarily give easy answers!
200
DBA
In today's world you're more likely to have databases both on premises and in the cloud. Managing databases in different environments can make your life more complicated, but with the new PowerShell cmdlets introduced with SQL Server 2014 it actually becomes easier.  In this session we'll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.
200
Dev
Are you working with an application supporting different time zones and international date formats? How does your choice of storing date / time values differ if you are using Windows Azure SQL Database instead of on-prem SQL Server database? Did you know that SQL Server Database Engine, Integration Services (SSIS) and Analysis Services (SSAS) all have slightly different date / time data types? How can you bullet proof your system for the ever growing data in your organization with much more date and time data to come? With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE! 
300
BI
Ever ended up with a source system where an old datatype was replaced with a new one so you had to rebuild all your SSIS packages? Entered a project with SSIS packages which needed a complete rebuild to perform but you didn’t have the time for a rebuild of your whole project?Client specifications changed (again) and you had to start all over again building all your packages?Had to import hundreds of text files but had no idea where to start?
We did it all and rebuild 100+ SSIS packages within a day using biml for generating SSIS packages. And with a generator at hand, we were able to absorb a new version of a source system including analysis of the changes made in the source in only two days. And the best of all, BIML is part of BIDSHelper and free to use!Don' t just believe what I say, In my session I will demonstrate where to start. I will show you around in BIML. After the quick basics of BIML I will show you how, with very basic programming knowledge, you can parameterize the BIML script in order to multiply the template to multiple packages over and over again (when needed of course).
300
DBA
The SQL Agent allows us to automate lots of things. When you have many servers, it can get difficult to keep your jobs consistent. Every time you change that backup script, you need to deploy the new version to every server, right? Not anymore! Join veteran DBA  and SQL Server MVP Mike Hillwig for a look at features within the SQL Agent that allow you to designate one server to be the master SQL Agent server and have every target follow its lead. He'll show you the power as well as the pitfalls. And then he'll show you how to make those pitfalls work to your advantage. 
200
Dev
Are relational databases too restrictive for you?  Developers want to store data as they get it?  Need to store arrays and query as first class citizens instead of performing gymnastics? Yes?  then this session is for you.  It introduces Microsoft's Document database.  Come see what it is and how it could make your developers happy. 
200
BI
Azure Machine Learning is a fully managed cloud service for predictive analytics. 

In this 1hour session, we will run through;
ML Studio
Getting data in to Azure ML
Processing data
Creating and running Experiments in a workspace
Visualising the results
Using R within Azure ML
Publishing and your Experiments as a web service
200
DBA
When mentioning the word cluster, people generally have one idea in mind when it comes to SQL Server – clustering the instance itself (also known as an FCI). However, Microsoft changed the game by introducing availability groups (AGs) which also require an underlying Windows Server failover cluster (WSFC). This has created a lot of confusion for DBAs and implementers alike. This session will clarify both the similarities and differences between these two major availability features as well as provide some practical deployment tips. Windows concepts will be front and center and discussed in context of implementing both AGs and FCIs.
200
BI
From scrums to sprints to a mountain of post-its, there's a world of weird and wacky project management stuff going on in the dev world. It's making it easier to get things done rapidly but how does it apply to BI and what does it all mean?


This session covers:
- agile concepts
- useful techniques for BI projects and ongoing work
- how to model and iterate data warehouses rapidly
- the technological components that can help deliver agile BI


After this session you should be equipped to start your first steps on the road to better quality, faster, and more collaborative BI.
300
Dev
Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
300
Dev
You know Bookmark Lookups in SQL Server? You like their flexibility to retrieve
data? If yes, you have to know that you are dealing with the most dangerous
concept in SQL Server! Bookmark Lookups can lead to massive performance losses
that blows up your CPU and I/O resources! Join me in this session to get a
basic understanding of Bookmark Lookups, and how they are used by SQL Server.
After laying out the foundation we will talk in more details about the various
performance problems they can introduce. After attending this session you have
a better understanding of Bookmark Lookup and you are finally able to tell if a
specific Bookmark Lookup is a good or bad one. 
300
DBA
As DBAs, we have to manage a huge number of servers and deal with a high volumes of changes/releases and implement vendor products which need elevated levels of permission to run. As a result, all the control and scrutiny that we wish to exercise becomes hard and almost impossible.

Very often, this results in undesirable settings, sub-optimal setups or bad implementations creeping in our environment – all against best practices or our mandated guidelines. e.g autoshrink, badly named objects.

Once they are in, it becomes extremely hard to fix or get rid of many of these issues and the reasons are wide ranging.

With this in mind, this session will explore ways for an administrator to implement solutions to prevent these issues from being introduced in the first place. Or if we cannot stop them, we should be notified about them when they happen.

To accomplish this, we will look at Policy Based Management with Central Management Servers.

Policy-Based Management gives us the ability to:
  • Define Standard Policies
  • Selectively Enforce Policies
  • Automate Policy Checking and Enforcement
  • Fix Out of Policy Conditions with the Click of a Button
Used in conjunction with Central Management Servers, we can easily control and manage groups of servers centrally.

Finally, for settings that Policy Based Management does not cover, we will look at some alternatives (like DDL Triggers) which can be used to prevent unwanted settings or notify us on the spot, if the changes cannot be stopped.
300
DBA
Extended Events is a highly scalable and highly configurable monitoring platform, which every DBA must be familiar with. It has many advantages over alternative tools, such as SQL Trace or Dynamic Management Views. In some cases, it is the only tool that can provide the desired monitoring solution.
In this session we will demonstrate several common use cases, such as monitoring query waits, troubleshooting deadlocks and monitoring page splits. We will demonstrate how to setup an event session for each use case, and how to analyze the collected data in a meaningful way. By the end of this session, you'll have several practical monitoring and troubleshooting solutions to apply on your environment.
300
BI
Inventory Valuation is a common problem in accounting, for which you might already have a dedicated software. From this point of view, a Tabular model should be only a reporting tool for data processed by other tools. However, the powerful in-memory engine allows alternative approaches to this problem, making it possible doing simulation and recalculation in minutes instead of hours. This technique, based on a combined use of Tabular models and DAX expressions, allows the implementation of more granular and accurate techniques in Inventory Valuation. This session shows several approaches to this scenario, using Analysis Services Tabular as a calculation engine to speed-up complete recalculation of Inventory Valuation caused by corrections to old transactions or particularly complex requirements in calculation definition.
300
DBA
Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. 

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

•           XEvents,Profiler/Traces, and PerfMon
•           Using Dynamic Management Views (DMVs)
•           Identifying bottlenecks using Wait Stats
•           Reading SQL Server execution plan

Every DBA needs to know how to keep their SQL Server in tip-top condition. If you don't already have troubleshooting skills, this session covers everything you need to know to get started.
300
BI
Since SQL Server 2000 there is a machine learning (or data mining, if you prefer) engine within SQL Server Analysis Services. But in 2014 Microsoft launched AzureML, a machine learning engine within Azure, their cloud platform. Is newer better? Should we turn our attention solely to the new kid around the block? 
In this session we will compare both products in live demos, show the strong and weak points in both of these products. So if you plan on doing predictive analysis in the near future, come to this session to see which product fits best with your project. 
200
BI
In the most marketing departments, the tactical question is about who are going to buy our products. It is more cost effective to identify and spend money on highly potential customers (than those who are not likely to purchase). This also affects the advertisement strategy. Potential customers and their traits can be identified by analysing previous purchasing information. Management experts can predict who is going to be their new customers by analysing their current customer purchase information. There are many data mining algorithms which can help with this task. Microsoft Business Intelligence employs data mining algorithms that are deployed in an easy to use environment. This demonstration based session will show how to use previous customer purchase information to predict potential customers. We will discuss
how to set data sets and use different data mining algorithms to get predictive results and then demonstrate how to find the best predictions. 
300
DBA
Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.

Attendees of this session will learn:
  • How to properly select the correct datatypes
  • How to identify poorly chosen datatypes
  • How to mitigate performance issues due to bad datatypes
300
DBA
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs.  Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
100
Dev
If there’s one thing that we, as SQL developers, don’t do, it’s use enough transactions. Transactions are critical when multiple changes need to be made entirely or not at all, but even given that, it’s rare to see transactions used at all in most production code.

In this session, we’ll look at what transactions are and why we should  use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.
200
Dev
Want to learn how to search your massive data repositories in Azure?  Come to this session and learn how.  Azure search is a new offering from Microsoft with lots of potential uses.  Want to know more, come join me.
300
Dev
User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus?

The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.

However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
200
BI
Overview:

We are all expert in Development. However, if you have been asked to estimate a development task, then the problem starts. What happens If we estimate 2 days and then it becomes 10 days to complete.Alternatively, we don’t want to say 10 days at first and then realize that 2 days work. 

As the organisations are keen to adopt the Agile Methodologies, it’s become mandatory skill for the Developers/DBA’s to accurately estimate the tasks. 

In this session, I will take an examples of two Agile BI Projects (SSRS and SSIS) and walkthrough the relevant tasks and its activities.
200
BI
We start with an overview of the new features in Excel Services 2013 and go on with the publish options with focus on the “Items in the workbook” option which is especially handy when you will embed in SharePoint without it resembles Excel too much. Second item on the agenda is the integration in SharePoint with a demonstration of three possibilities:
  • Full page - The lazy solution
  • PerformancePoint Services Dashboard - The smart solution
  • WebPart page - The customizable solution
Last but not least the session will include “Tips & Tricks” including how to remove the Excel look. How to control the layout with “Named Items” and the "Name Manager" and how you can burst the limits from PivotTables with the of use "Cube Functions" and "Names Sets".

The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective.
  1. New features in Excel 2013
  2. Overview of the publish options
  3. How to control the layout
  4. Tips & Trick from real world examples
200
Dev
It is possible to spend too much time in the search for perfect performance. However, it is not uncommon for poor design decisions in the early stage of development to catch up with you in the future. This session will take a look at some of the common design mistakes made in database development and show how they can cause problems later on.
200
Car
Unfortunately, tech skills aren't enough to keep moving up the career ladder or to be the expert folks turn to. How you work with people and focussing on value is often more important than how well you can write a specific line of code. This session takes you through the opportunities to get involved in the SQL Server community and how the different ways of contributing can help you gain the skills, knowledge, and the confidence necessary to do a great job at all levels of your career.


Whether it's blogging, presenting, room monitoring, to running a user group or conference, there are skills to be had in all these areas. This session will take you through a skills matrix and show which ways of getting involved help you hit which skills, whilst also giving you the info you need to get up and running with them.
300
DBA
Have you ever needed to refactor dozens of stored procedures or create lots of user accounts from a list given to you by a business unit?    If so then you’ve probably spent too much time manually manipulating text.  Regular Expressions (regex, for short) is one of the best tools a DBA can have.  This powerful text manipulation tool can be used in any number of scripting languages, and can even be leveraged inside of SSMS. The best part? Regex is brilliantly simple--despite what you may have heard to the contrary.  In this session you'll learn the basics of regex and the differences you'll encounter when using it in SSMS rather than a scripting tool. Along the way you'll see some really cool tricks; things you'll want to use all of the time once you're aware of them.  Next we'll move into Powershell. Here regex gets the full treatment and will help you with powerful and incredible tasks, manipulating hundreds of objects at a time.
400
Dev
You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what?
In this session we will analyze common use cases of poorly performing queries, such as improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques. By the end of this session, you'll have a list of tips and techniques to apply on your environment.
300
DBA
SQL Server needs its locking mechanism to provide the isolation aspect of
transactions. As a side-affect your workload can run into deadlock situations -
headache for you as a DBA is guaranteed! In this session we will look into the
basics about locking & blocking in SQL Server. Based on that knowledge you
will learn about the various kinds of deadlocks that can occur in SQL Server,
how to troubleshooting them, and how you can resolve them by changing your queries,
your indexing strategy, and your database settings.    
200
BI
Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go. Meanwhile, Pivot Tables and Pivot Charts in Excel can also provide greater insights both in the desktop and online version.
  
This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View and Excel, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. We will discuss fundamental data visualisation principles, business requirements gathering techniques and data modeling tips/tricks. Using live demo, we will walk through ways to channel users focus on actionable analytics on operational, strategy and analytical dashboard use cases.
200
Dev
Learn how traditional and new database technologies fit in a modern data architecture.  We will talk about the underlying concepts and terminology such as CAP, ACID and BASE and how they form the basis of evaluating each of the categories of databases. Learn about graph, Hadoop, relational, key value, document, and column family databases and how and when they should be considered. Finally, we will wrap up with 10 tips for working with new hybrid data architectures: tools, techniques and standards.
300
DBA
DBA trade is still in-demand and will remain as long as databases are alive!
If you are an average IT person/Developer/SysAdmin who has been managing development and databases in your organisation, now you want to manage SQL Server databases using tricks of DBA trade and you've got no idea what to do with it!

In this session we will overview range of topics that every DBA handles, such as: backup/restore strategy, high availability, scalability and performance tuning. We will touch base on how best SQL Server technology will offer home-grown tools to keep your BAU tasks.

Not giving opportunity of riding a super-duper car, but best learning techniques on how to manage your SQL Server database and make it efficient enough to run like a fast car on performance aspects. You will get o know what is needed to get that new features to implement, how best they can fit in.

All the examples and demos in this session are originated from real-world work from my Consulting experience.
300
BI
When loading a large amount of data, e.g. into your data warehouse, you want the data inserted into the table as fast as possible. You know you have to use bulk load, but what do you need to do to ensure that data is loaded as fast as possible?

In this session, you will learn about the different methods for bulk loading data into your data warehouse; using SSIS, BCP and T-SQL. You will also learn what is happening behind the scene of minimal logged inserts, why they are so important when doing bulk load, and what is required to achieve a minimal footprint on the transaction log. 
100
Car
Commonly, SharePoint gets handed to DBAs to administer because it relies on databases hosted in SQL Server.  

This session will provide an introduction to SharePoint, covering some of the common features and functionality that make it more than just a file store, including features such as Excel Services, Visio Services, User Profile Service and customisation options.
200
Dev
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
200
DBA
It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable. 

In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.

After attending this session, you will be able to 

  • assess the security requirements of a multi-database application.
  • explain the difference between the four methods of providing cross database access and detail their advantages and disadvantages for future use.
  • select the most appropriate cross database security solution for your situation.
To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and have basic permission management skills.
300
DBA
If you know SQL Server, then you know a lot more about Oracle than you ever thought you did.
This session is for people who know SQL Server, but what to know about Oracle.
200
Car
Are you interested in becoming certified in SQL Server?  In this session, Chris Testa-O’Neil will provide an overview of the certifications and training offered by Microsoft for SQL Server 2014.  We’ll discuss the value of being certified, and then discuss the different certification paths and the related training options for each path.  

It is not a technical session but will provide the information that you require in order to complete the following certification

Microsoft Certified Solution Associate

Microsoft Certified Solution Expert

An exploration of the available learning channel to support you meeting your certification requirements will also be explored including

Microsoft Virtual Academy

Microsoft Official Courses – (Instructor Led Training)

Microsoft Elearning

Microsoft Press Books
500
Dev
The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there?

In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are used to estimate row counts, and how filters and joins further influence those estimates.

Though the focus of this session is on understanding the cause of bad estimates, you will also learn some ways to fix the problems and get better estimates - and hence, better performing queries.
100
Car
The world of consulting can be rewarding on various levels. People often think they have the right stuff to be a consultant, but do you? Would you need to work for an agency or company that sells consulting services or could you strike out on your own? Or are you always going to be someone who needs to be a full time employee with a set schedule? What are the things you need to know if this is your ultimately succeed if this is your career path? Becoming a consultant is more than having the right technical skills. This session will cover the highs, lows, and realities of what it takes to be a successful consultant based on my experiences and those of my colleagues over the years.
300
BI
Conventional wisdom for project management is that you can have two out of three: fast, cheap, and good. This session presents a great tool that allows you to have all three. The only gotcha is this - you need a Linux box and you have to use some open source software called R!


This session takes you through the steps needed to build and deploy Shiny applications to a Linux environment. We will be building a SQLBits dashboard, configuring a Linux box in Azure for Shiny, and then deploying the SQLBits dashboard.
300
Dev
The biggest problem today with security is protecting the endpoints from attack.







The endpoints are all well known, they are your login page, sitting with a shining target placed upon them. Waiting for someone to blast through your defences. You make it too easy with a username and password.











There is a better way, move from the old style castle walls, where you keep everyone out and embrace the modern world, were online services are always on and always vulnerable. See how Personal Endpoints can solve this problem in a heartbeat. Change the way you look at the world and suddenly the problems go away.







With Personal Endpoints, we can remove that single point of vulnerability, and simultaneously boost our security. This is a cross platform and will work seamlessly with existing and new deployments and systems.







It only takes a small change to make life a whole lot safer for you and your clients and users.
  • Make more robust
  • Reduce attack surface
  • Gain better insight
  • Increased security
Full demo and walk through. Service Personal Endpoints are applicable to all systems and to any development language and environment.
300
DBA
For most DBAs and DEVs the TempDb is a crystal ball. But the TempDb is the most
critical component in a SQL Server installation and is used by your
applications and also internally by SQL Server. TempDb is also one of the
performance bottlenecks by design, because it is shared across the whole SQL
Server instance. In this session we will take a closer look into the TempDb,
how it is used by SQL Server, and how you can troubleshoot performance problems
inside TempDb and how you can resolve them.    
200
BI
After struggling with Master Data issues for many years in various BI projects, a lot of companies is now ready to take the first step towards real Master Data Management (MDM).
In this session you will learn about common MDM scenarios, and get Real Life examples on how to handle these Scenarios by building a MDM Architecture using SQL Server and Master Data Services.
300
DBA
SQL Server 2014 has was released about a year ago and if you are not already running this version, it is high time to migrate.

While SQL Server 2014 came with an abundance of new features and improvements, the In-Memory OLTP (Hekaton) and the Updatable columnstore indexes have been talked about much. While these are ground-breaking additions, there are so many other reasons why you should migrate to SQL Server 2014 and benefit from the other new features and enhancements.

This session (with the help of some demos) will cover all the SQL Server 2014 Gems (some of which are lesser known) and provide you with many reasons why you should migrate to and/or start using this version.

As a taster, some of the new features this session will cover:
  • Backup Enhancements and Encrypted 
  • Enhanced Scalability
  • New Design for Cardinality Estimation
  • Delayed Durability
  • AlwaysOn Enhancements
  • Buffer Pool Extension
  • Resource Governor Enhancements for Physical IO Control
  • New Security Features
  • Online Index Operations
  • ... and some hiddens gems
400
Dev
Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren't aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance.
In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.
300
Dev
We will overview a detailed options about how to deploy Power BI, how to implement configuration parameters and package BI features as a part of Office 365 roll out in your organisation.

A value from a best practice follow up is enormous, and it is possible to manage the deployments as trouble-free without having major hiccups on implementation. As a DBA/SystemAdmin you have biggest responsibility to deliver best possible components to data stewards and end-user.

Having said that, cloud computing is another aspect of this technology made is possible to get data within few clicks and ticks to the end-user. Let us review how to manage & connect on-premise data to cloud capabilities that can offer full advantage of data catalogue capabilities by keeping data secure as per Information Governance standards.  Not just with nuts and bolts, performance is another aspect that every Admin is keeping up, let us look into few settings on how to maximize performance to optimize access to data as a real-time and how this Power BI features can enable this solution.

300
Dev
The Dell DVD store is an open source database and online commerce application used for benchmarking hardware.

Come along to see us attempt to optimise and redesign the "Dell DVD Store" sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.

In Part I we will see just how far we can optimise a the commerce solution using traditional tuning and scale up on a single database server and making use of technologies like the In memory OLTP engine.

In Part II we look to migrate the solution to the cloud taking advantage of scalability features the Microsoft Azure platform and best practices such as sharding, data caching and asynchronous processing.

300
DBA
It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels. Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler We’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
300
Dev
A lot of companies have a philosophy of ship early with as much features as possible.
Thoughts about security are an afterthought since it isn't fun to do and no one will attack them anyway.
But the dark side never sleeps and security breaches have always happened. 
Many have left companies severely exposed or even bankrupt.

In this session we'll look at a few attack vectors that can be used against your company,
and what you as a developer can and should do to protect against them.
It will involve good mix of security conscious SQL Server and application development. 
Because you care about your work and nobody messes with you. 
300
Dev
The topic of SQL Server concurrency is one that many people want to understand really well, but at the same time is one that doesn't get the needed attention for some reason. In addition, isolation levels can play a huge role in both the performance and the scalability of every application and so the proper choice of isolation level is crucial. In this session we are going to go deep into the world of SQL Server isolation levels and see what is the behaviour of each one of them. We will discuss how we should approach the final decision on which level we should go with and how we can actually effectively troubleshoot concurrency issues. Last, but not at least, we will take a look at what is going on behind the scenes when our applications work and what differentiates one isolation level from the other. The session is suitable for both application developers and DBAs who want to advance their knowledge in the unending world of SQL Server concurrency.
200
DBA
We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment.  Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea.  Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money.  There are some other times when you will be shooting yourself in the foot and shouldn’t.  We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.
200
DBA
Quote: “A good DBA is a lazy DBA”. When you have to manage a few SQL Servers, it’s not that hard to be a lazy DBA and to automate your day to day activities. But when you have to manage over 100 instances, it can become a tough job. Just imagine how you will deploy a new maintenance job on all your instances? Are you going to connect to each server one by one? Not really… Microsoft provides an enhanced set of multi-server management tools. The purpose of this sessions is to point out which SQL Server tools you can use for multi-server management. The session is bulk loaded with demos and it will give you a good idea what features can be helpful in your environment.
300
Dev
We all know indexes can speed up queries. But why? And how? Why is “index on every column” not a good indexing strategy, why is your shiny new index not used, and why can adding indexes even hurt performance? The key to answering this is understanding how SQL Server lays out your data on disk, how this changes when you add an index, and how SQL Server uses these indexes to find the information required for your queries.

The first part of this presentation will provide in-depth insight in how heaps, clustered indexes, and nonclustered indexes are organized on disk; and how they are used for scans, seeks, and lookups. The second part will then continue on advanced features, such as included columns, indexed views, and filtered indexes. You will see the tools SQL Server itself hands you to help identify just the right subset of indexes, and their limitations and weaknesses. And finally, you will get a stunning demonstration of just how bad you can HURT performance by creating too many indexes.

Armed with this information, you should be able to find just the right set of indexes for your workload.
300
BI
When it comes to analyzing data, Hadoop or the R statistical language come readily to mind. Python is yet another one of your secret power tool for SQL Server, data analysis and business intelligence. In this session, we will look at both Python and R and how they can be used in the Microsoft SQL Server, with a focus on the Business Intelligence stack.

Come to this session to see examples of data analysis using both R and Python, and learn how to use these open source power tools to rock your data world in SQL Server. We will look at how these data tools complement each other, with guidance on 'when to use what'. The session assumes no knowledge of either tool, but is aimed at people with a healthy interest in data analysis and SQL Server who would like to know more about what is out there.
300
BI
There are clear rules of modelling an OLTP relational database developed by Boyce–Codd before I was even born. However, dimensional modelling patterns are still rather vague and modellers are faced with some tough decisions in real world of complex data relationships, tricky/absent reporting requirements and various aspects of performance and ease of use. I would like to present a set of design patterns to use when tackling common DW modelling problems and challenges: when to use star or snowflake, junk and mini dimensions, bridge tables and other data warehouse modelling tricks. 

There are many books on DW terminology and general theory, so I will assume you have at least a grasp of common lingo: dimension, fact, slowly changing dimension types, star and snowflake schemas, etc.

Patterns I present aim to follow one common structure:
Problem (What?) -> Solution(How?) -> Reasons (Why?)->Consequences (Why not?)

The idea is not just presenting a common framework for sharing what works and what doesn’t, but also explain why that is the case and what happens when the patterns are not followed.

These patterns are equally applicable for a Kimball or Inmon religion, so both camps are very welcome to attend.
400
BI
Come to this session to see how to build a scalable analytical solution on Microsoft Azure with Elastic Search and Kibana.  We take you through what you need to do, how and why.  Elastic search is a distributed restful search and analytics application. It is document oriented, schema free and based on the Lucene search engine.  Not content with being a free text search engine Elastic Search lets you do real-time analytics over your data as well.
Kibana is a visualisation tool that works seamlessly with Elastic Search.  It allows you to create time based comparisons over your data and gives the users power to derive insight from the data.  It has a large number of visualisations available and we will show you the right ones to use for the situation.

At the end of this sessions you will understand

What is Elastic search
How it fits well on Azure
How to load, index and query the data

What is Kibana
How it works with Elastic Search
What you can do with Kibana
The visualisations available to you.

This session is demo heavy as seeing is believing.
300
BI
In many database applications we first log data and then, a few hours or days later, we start analyzing it. But in a world that's moving faster and faster, we sometimes need to analyze what is happening NOW. Azure Stream Analytics allows you to analyze streams of data via a new Azure service. In this session you will see how to get started using this new service. From event hubs on the input side over temporal SQL queries: the demo’s in this session will show you all of it.
200
Car
Like in other fields of IT, certifications are an important aspect in the SQL Server world. They are still relevant and important in this day and age and can help you stand out from the crowd and go up and career ladder. In some fields, you need to have them to even be considered for certain positions.

However, the greatest benefit you get while pursuing certifications is the knowledge. In your journey to getting certified,while learning, reading books/blogs/forums and playing with SQL Server, you will gain invaluable knowledge and experience. Certifications can push you to gain both breadth and depth in SQL Server and this can only make you better at your job and possibly help you land your dream job.

Come to find out how to make the most of this journey and learn about the current SQL Server Certifications paths and how to achieve them, from somebody who started the journey a few years ago and worked his way up to achieve the SQL Server MCM (Microsoft Certified Master) Certification.
200
DBA
Statistics are the single driving factor behind most of the decisions made by the query optimizer. Because of this, you need to understand exactly what statistics are, how they're generated, how they're maintained, and what SQL Server does with them. This session will show you how to read and understand the output of DBCC SHOW_STATISTICS and how to use Extended Events to capture statistics maintenance and creation in real time. We'll also cover the new mechanisms around the cardinality estimator within SQL Server 2014. You will know how to understand your statistics and the maintenance necessary on them when you leave this session and head back to the office.
400
DBA
If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session.  SQL Server has a large surface area and Active Directory can influence a big part of it.  I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.
300
Dev
Power BI is the Self-Service BI offering of Microsoft to all Information Workers out there, but hey: Is there anything for the macro geeks and development folks? This session will have a look on anything you can do or should not do with the Power BI offering in the cloud and on your desktop. What's in it if you want to go beyond the self-service experience? Is there more than create your own cool "M" functions? Let's see in this session.
200
DBA
As part of the team leading the migration effort from Microsoft IT's on-prem servers to The Cloud, we've collected a number of best practices that can save your organization weeks or months of effort & untold dollars in development & implementation costs.  Those who think the only tool required to move SQL instances from the datacenter to IaaS VMs is a forklift have a hard lesson to learn.  In fact, it's a bit challenging than that.  This session will introduce the Top 10 Lessons Learned in the MSIT migration effort & provide actionable guidance that customers can begin using immediately.    Session Goal 1: Understand that forklifting applications to the Cloud has unexpected challenges. Session Goal 2: Understand that many fundamental best practices which have served us well on-prem remain important—& now we have new nuances to master. Session Goal 3: Understand the value of leveraging MSIT's lessons learned has the potential to save an organization weeks or months of time & hundreds of thousands, perhaps millions of dollars. Additional Notes: This is an exciting topic the work for which I'm intimately involved.  I'm extremely enthusiastic about sharing the fruits of our efforts with the Community.
300
BI
SharePoint – let’s admit it – is here to stay; It has become the business collaboration platform of choice for the enterprise and the binding element in the Office family of tools. However deploying and configuring can be a challenging task for the IT pro. In this session we will walk through the configuration of a complete on-premises BI platform with SharePoint. We will configure different scenarios, and the technologies necessary for building the infrastructure. After this session you will be able to setup the applications and all the supporting services to make SharePoint a successful and performant BI platform. From Excel services to Kerberos delegation. 
200
Dev
Deployment to production is typically a manual process and can take a lot of time. A tempting and faster alternative, but also more dangerous, is to let the developer make changes directly to the production database. Many companies use continuous integration for testing their software and continuous deployment to push out code to production in short cycles. But what will it take to do it for SQL Server development?

In this session, you will learn about the concept of continues integration and continuous deployment. You will also learn how you can use SQL Server Tooling for Visual Studio 2013 and Team Foundation Server 2013 to move to a more continuous deployment model and deliver changes to your database more frequently.
300
Dev
Columnstore is a very exciting technology that can boost the performance of our queries by orders of magnitude. However, like every technology, we have to use it the right way in order to achieve such a performance boost.

We will start the presentation with a quick overview of the technology in order to bring everyone up to speed. After that, we will start asking questions that will help us understand how to master it.

Among others, we will answer questions like:
               
  • When will a Clustered Columnstore Index boost performance by orders of magnitude, and when it won’t help so much?    
  • How to defeat the “lazy” tuple mover?                
  • How to increase segment elimination?               
  • How to load data the right way?
  • What should we do if we need a verification of data integrity?
We will end the presentation with some speculations about the Columnstore-related features Microsoft will unveil in the next version of SQL Server.
200
DBA
New Features of SQL Server 2014 DB Engine not including Hekaton


- Backup Enhancement (Azure, Encryption)

- Partition Switching and Indexing

- Managing the lock priority of online operations

- Columnstore indexes (updatable, Archival data compression)

- Incremental Statistics

- Security Enhancements

- AlwaysOn enhancements

- Buffer pool extension onto SSDs

- Resource Governor enhancements for physical IO

- Improved optimizer with new costings. 

300
Dev
So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it.  I've got some of the answers here in this session for you.  During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing. While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
300
DBA
In this 2 hour session we'll take a look at a wide variety of topics, from useful and little known TSQL coding constructs to best case indexing advice and a whole lot more.


Using lots of demos and examples we'll examine things such as query and join simplification, SARGability and inverse predicates and lots more things.


This will be a lighthearted session and attendees will leave with a wealth of tips, tricks and ideas to take away and put into use almost immediately
200
DBA
One of the most important tasks of every DBA is developing a good backup strategy. You’ve probably written your own scripts or used the maintenance solution of Ola Hallengren. But where do you store your backups? On your SAN … or on tape? And how many times did you forget to switch tapes or did you have to bring the tape to a safe deposit box? Well, Microsoft announced several new ways to back up and recover SQL Server databases with Windows Azure.  These features provide an easy way to cloud backup and disaster recovery for on-premises databases.  This session provides a detailed explanation of the new SQL Server 2014 Backup features to Windows Azure like manual & managed backup, encryption and backup to Windows Azure Tool. The session is bulk loaded with demos and it will give you an idea if these new features can be helpful in your environment.
300
DBA
Database partitioning. What is it? Do you need it? How do you implement it? With one session dedicated to Standard Edition and one to Enterprise, all will be explained. Whatever the edition, whatever the budget, if you need to partition you need to partition. End of. All the options will be discussed and demonstrated over the two sessions, so you know which one is right for you.

The following questions will all be answered:

  • Just what is database partitioning?
  • Do I even need it?
  • So what can be done in Standard edition?
  • And what can be done in Enterprise edition?
  • And what’s new in 2014?
  • And why would you want to be using it with column store indexes?
Knowledge is power and, after these sessions, those big tables won’t be so scary anymore. They can be tamed and will soon be purring like a kitten. It’s never all pain-free sailing partitioning large live tables but, armed with the correct knowledge, you can start planning and implementing your partitioning. Sweet.
300
Car
Design matters and it matters in every aspect of our life. That includes our presentations. Many technical speakers do not believe that how they design their slide deck is important. I have news for you - it is! Your design speaks a lot not only about you, but actually helps your attendees understand your presentation better. How you approach this "problem" is crucial and in this session we will learn the 10 fundamental design concepts that you should try to incorporate in each one of your presentations. Design is important and many times it can be play the role of differentiator for you.
200
DBA
Recently, everyone's talking about Big Data and noSQL datastores. As a SQL Server DBA, you need to know your own platform well, but as a Data Professional, you should also have an awareness of trends, technologies and their usage. NoSQL is a massive subject area, so this is an introduction for anyone wishing to dip their toes in their Data Lake.
500
DBA
As a DBA we learn backwards.  Most of the time you get a DBA job and you have Databases, that have tables, and in those tables you have data. Nobody tells you that we have records, stored on Pages, grouped in Extents, assigned by Allocation Bitmaps, with IAM Pages and Allocation Units that span Partitions and Filegroups.  Today is your lucky day, we will start at the bottom and build our way up.  We'll cover byte swapping, bitmaps, and dive a little into decoding Hex & binary.  Working to give you a full understanding of database internals, and how you use them every day!  
300
DBA
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance such as pre-sorting the data prior column store index creation, delta stores in action, segment elimination and the difference that batch mode makes. Back ground information on the 'Anatomy' of a column store index, how row mode works and why it is inefficient and a brief overview of CPU architectures is also provided. The full deck behind for this presentation ( which may be subject to change ) can be found here: http://www.slideshare.net/chris1adkin/an-introduction-to-column-store-indexes-and-batch-mode.
300
DBA
T-SQL provides many different ways to accomplish the same task, and as you might expect, some ways are better than others. Also, it's very simple to write your T-SQL in a way that no one else can read. In this session, you will learn specific techniques, that if followed, will make you a better T-SQL developer. The session is jam-packed with practical examples and is designed for administrators and developers who want to bring their T-SQL skills to the next level. You'll write clearer and easier to read T-SQL as well as write better performing T-SQL. In fact, you will be able to immediately implement these tips in your current projects once you get back to your office.
300
DBA
In this session we will present and demonstrate many tips & tricks that can help database administrators take
the best out of SQL Server. The tips you'll learn in this session will help you improve productivity, availability, security and performance of your system. We picked the topics that are less known and yet have a great impact.
The session is based on SQL Server 2014, and includes some of the new features in the new version, but it is relevant also for SQL Server 2008/R2/2012.
200
Dev
It seems that for years us Sql developers haven't needed to use source control, we backup our databases which contain the source so why would we need to?

Times are changing, with the addition of SSDT (Sql Server Data Tools) to our tool set we now, more than ever, need to join the rest of the development community and start using source control - if you are convinced of the benefits and maybe have even tried to get your database under source control and got stuck or don't even know where to start then this is the session for you.

Once the database is under source control then we move onto the next great thing, testing - with frameworks like DBUnit, tSQLt and even the Microsoft supplied MSTest we can easily start writing automated testing which allows us, if done correctly, to make our code:

  • Easier to write
  • Easier to understand
  • Easier to debug
  • Less prone to bugs

If you have tried to start unit testing but again did not know how to actually get started then this session will give some practical examples of how to actually get setup and working productively. There is no point in trying to do something that just adds a massive overhead to your development so come here and learn how to integrate unit testing with your development and make a step towards more modern and agile Sql Server development!

200
DBA
In this presentation I'll explain what the SQL Server AlwaysOn high availability and disaster recovery solution is all about.  I'll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups.  We'll discuss how these three things come together to protect your databases. We'll finish with a dive into availability group configuration, the new capabilities it gives us, and what's new in SQL Server 2014.
300
Dev
Do you have complex operations that have already been tuned for optimum performance, but still run too long for a good end user application experience? If you do, Service Broker may be the solution. This session will
explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required. Even in SQL Server 2014, Service Broker lacks a UI integration. Not to worry, this session will show you how to configure Service Broker correctly the first time so you can develop easy, foolproof deployments to solve complicated problems.
400
DBA
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations.
Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode & Query Processing with another depth.

Can you make your Columnstore queries ran even faster ?
Can you actually lower the Degree of Parallelism and get a better performance ?
How much memory does Columnstore Index actually use when working with queries ?
How can you test your Columnstore queries in Row Mode and what is the actual difference between Row & Batch Modes.

The answers on those questions are to be revealed at this session.
300
DBA
Beware of the Dark Side - A Guided Tour of Oracle for the SQL DBA

Today, SQL Server DBAs are more than likely at some point in their careers to come across Oracle and Oracle DBAs. To the unwary this can be very daunting and, at first glance, Oracle can look completely different with little obvious similarities to SQL Server.
This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.

At the end of this session you will have a better understanding of Oracle and the differences between the Oracle RDBMS and SQL Server. 
Although you won’t be ready to be an Oracle DBA it will give you a foundation to build on.
200
DBA
You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
300
DBA

SQL Server Auditing
- DDL Triggers
- Audit Specifications
- C2 Auditing

Transparent Database Encryption
- Encypting with a Pass Phrase vs Transparent Database Encryption
- Symmetric Keys
- Asymmetric Keys
- Certificates
- Database Master Key
- Certificate creation
- Database Encyption Keys (DEK)
- Enabling Encryption
- Backup/Restore for TDE Encrypted Databases
200
DBA
SQL Server 2014 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012.  During this session we will explore the new in memory database tables which were developed under the code name project hekaton.  During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn't be used.
200
Dev
Doesn't matter if you are a SQL Developer, BI Developer, DBA or a combination of those, we all need to have the right tools to get our jobs done. Now that many of the tools for SQL Server are no longer being included with the installer we will all have to do more work to get everything setup and ready. What are BIDS and SSDT? What version(s) of SSDT do I need? Can I install multiple different versions of these on the same workstation? Can I do .NET development and SQL Server development in the same tools? These are just the start of the questions you may be asking when getting a workstation setup. Some time will also be spent on the advantages/disadvantages to using VMs for your development workstation.
300
Dev
In this session we will take an in depth look at statistics, how they are built, stored and used. We will go over why they are so important and what role they play in selecting a query plan. We will also take a look into estimation and how this affects query plan selection and how estimation and statistics tie together.


Also in this session we will take a look into plan caching, what it is, why it is done and how it can be both a help and a hindrance.


Using lots of demos and examples attendees will leave the session with a greater understanding of these three key areas and also the tools and techniques to work with and understand them in their own enviroments
400
Dev
What are the secrets to making your queries run faster?  Why does SQL Server use an index for some queries and not for others?  What makes a good index?  How many indexes should I have?  Have you ever asked these questions? When you want to understand an application you look at its core architecture. Underneath the covers SQL Server is just a C++ application.  Together we will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.
300
DBA
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.

Migrating servers and databases within the same infrastructure is often problematic, come and discover the challenges we faced when migrating to Azure and how we overcame them.
200
DBA
FileTables are an exciting feature, new since SQL Server 2012, which enables applications to manage structured as well as unstructured data seamlessly. In this session we will demonstrate how FileTables can be used to work with files directly from the application while enjoying the benefits of management by SQL Server.
400
DBA
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server, such that all available hardware resources are utilised as fully as possible. Windows Performance Analysis toolkit will be used to ascertain where the pressure points are in order to target efforts in tuning this new feature to the full: including such things as hash partitioning in order to enhance parallel scan performance, reducing pressure on the PFS bit maps, reducing pressure on how the PFS is allocated in memory and the final performnance frontier, reducing the presure on the log cache access spin lock, the thing which ultimately ham strings all workloads that need to be ACID compliant.
200
Car
With over 15 years of experience as a semi-remote Lead DBA for a medical system, running a consultancy firm, producing SQL Cruise events and balancing a personal life Tim Ford has a pocketful of tips to share in making "remote" work for you.  He also has a long list of things that he's found over the years to be a hindrance for himself and others who have struggled and failed to make remote working formats a success.  Join him as he covers:
  • Ideas for making telecommuting work for you and for your teammates.
  • Convincing Management to adopt or attempt remote work scenarios.
  • The Good, the Bad and the Ugly of remote working.
  • Traits that lend oneself to being a successful telecommuter and those that do not.
  • Practices for improving your remote working productivity.
  • Dealing with work-life balance (the hardest part of remote working.)
Always-On may be a great term for SQL Server High Availability options but it's not so for those working in the technology.  We'll wrap the discussion with beating back the urges to be "Always On" without becoming irrelevant.
400
BI
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. Find out how to scale your SSIS data load out across multiple servers and reduce your data loads by a huge factor. See how to measure performance and how to keep SSIS from monopolizing your server's resourcing. Lastly, discover SQL Server 2012 features that will make SSIS more efficient.
300
DBA
SQLRAP is a service provided by Microsoft that you or your manager can buy. It is an auditing service that will collect data from your whole SQL Server environment and will then analyse it and point you to possible issues and problems. The improvements that will be suggested could be a lot and with different priority - ranging from "serious" to "informational". In this session you will learn what you need to know about the audit and how you should prepare your environment for it. I will share my experience from going through the SQLRAP with one of my customers - huge Fortune 500 organisation - by providing you guidance on what you should focus your attention to and where could there be some unexpected surprises that both you and your manager do not want to see.
400
BI
In this session, mainly made with demos, Alberto will show
you how to measure the performance of a DAX expression, how to get some insight
into the query plan, and then he will apply the concepts to several formulas,
optimizing them on stage.

The goal of the session is to see the basic optimization
techniques and the best practices to use when authoring DAX code.
200
Dev
In this session, you’ll learn about SQL Server stored procedures (SPs): what they are, when and why you'd use them, and how you'd go about developing a solution with one.  We will address common SP myths and learn about planning for performance. Most of all, we’ll walk through examples to explore the process of solution building in SQL Server.
300
Dev
What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic?  How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency? In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
400
BI
Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?

This session focuses on tools and methodology to load test Analysis Services in highly concurrent environments. We have a case study with some shocking results as to what you may have to do to configure and scale analysis services. We also show how to use using load testing tool to select the best cloud provider for your workload.

Sample source code and tools provided on codeplex to get you started with load testing you cubes.
300
BI
For long Hadoop and MapReduce were linked together. Additional data manipulation libraries, like Hive, were added to query the stored data more easily. But with the growth of the amount of data and cluster sizes, MapReduce became too slow and with the release of Hadoop2 YARN was introduced to schedule the resources in a Hadoop cluster. Parallel with the creation of YARN Hortonworks, Microsofts Hadoop partner, launched the Stinger initiative to speedup Hive a 100x in three waves: the first van the introduction of the ORC files, the second wave optimized the query engine and with the third wave Tez was released. In this session we will look at all the different aspects of Hive/Stinger/Tez, from the history and future to the internals and practical use.
200
DBA
Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance.  We can use partitioning to split tables or indexes across storage or use it to perform maintenance on just part of a table. We can also use it to increase the speed of our data loads through a technique called Sliding Windows. In this session we'll look at the concepts surrounding partitioning and the use cases. We'll reinforce what we cover with some cool demo's showing some really neat tricks as we go along including a sliding windows demonstration.
300
BI
Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server & SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it can be setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
200
Car
Consultancy is a bit of a strange animal, its not quite being a "permie" and its not quite being a contractor. It's somewhere in the middle. 


In this session we'll look at my experiences as a consultant that I've accumulated over a period of about 7 years. We'll compare this to the life of a "permie" and a contractor (both of which I've done) and we'll see where the contrasts lie

The aim of this session is to have a open and honest talk about this kind of working, delivered in a lighthearted and interactive manner attendees should leave the session with a much better idea of what life is like for a consultant and if it's the right choice for them
200
DBA
How long does a SQL Server failover cluster instance take to install? 3 hours, ½ day. It depends on alignments that need to be made to industry and your company best practise or policy. There are ways that we can all utilise unattended installs in a way that can significantly reduce this time. In the organisation I am currently working for, I have got a SQL Server failover cluster instance to install within 30 minutes including post install task to ensure that it conforms to the correct standards. All of this is a FREE solution that anyone can build and align with their organisation.  
500
BI
SQL Server 2012 and 2014 Database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient statistical queries that use the new Window functions and are optimized through algorithms that use mathematical knowledge and creativity. During the session, the formulas and usage of those statistical procedures are explained as well. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well. Or maybe you want to learn how to become a data
scientist? Then you need to know statistics and programming. You get the best of both in this session.
300
DBA
This session will discuss the best practices and lessons learned while implementing and configuring SQL Server 2014 in-memory OLTP as customers large and small, including many global ISVs in the financial, retail, and content management industries. We will discuss experiences and next steps, and highlight workarounds for key scenarios during implementation and rollout. We’ll look at the progression of performing benchmarking to understand the performance impact throughout the process.
300
BI
Web services usually is one of the important data sources to deal with when you are gathering data and loading it into  your data warehouse. SSIS has list of XML related components that helps to work with web services and xml data sets. In this session you will learn
  • how to use Web Service task to read data from web services. 
  • How to use Foreach Loop NodeList enumerator to loop through xml data set 
  • How to use XML Task to validate, transform xml data set
  • How to use XML Source in Data Flow to fetch data from xml data set
You will learn all above topics with live demos.
200
Car
This session is aimed at anyone who has an interest in developing their professional career and becoming the best they can be. The IT Industry is full of very capable and knowledgeable technical experts, but that is only half the story.  To be truly successful and achieve your potential in your professional career, you need to develop those soft skills and competencies that help you interact, communicate and establish professional relationships with your colleagues and customers.  Are your skills the best they can be in this area?  I shall be discussing some soft competencies such as: Verbal and written communication skills Team work Customer Relations Leadership Decision Making and personal planning. I shall present some ideas which you or your organisation can consider to develop your soft skills going forward.  Personality type also plays a significant part in the way we interact with our environment.  During this session, I will also be exploring some of these personality types and the way those types can adopt their traits to optimise their performance in the work place. You will leave this session with some great ideas about how you can take personal responsibility for developing yourself and optimising your potential in the future.
300
BI
Microsoft Analysis Services models grow bigger and bigger and it becomes harder to predict, how the performance of the model will be once the cube is in production where hundreds or thousands of user queries hit it at the same time. Therefore it is a good advice to run extensive load tests in advance to identify possible performance bottlenecks as early as possible. What you have to consider  and how to actually run a load test against Analysis Services will be shown in this session. 
200
BI
Microsoft HDInsight provides a 100-percent Apache Hadoop solution in the cloud. With HDInsight, you have a cloud-based big data platform that can manage the data of any type and any size, whether structured or unstructured. While petabytes of unstructured data can be processed in a few hours with Hadoop, SQL Server can process terabytes of structured data in a few seconds. What could be better than to connect both worlds and transfer data between HDInsight and SQL Server?



With the SQL Server Integration Services (SSIS) - since included in SQL Server 2005 - and known as high-performance ETL platform, Microsoft also provides at first glance the ideal platform for this. But is that really the case? How does SSIS metadata and unstructured data get together? In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.
300
DBA
Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, its time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks.

In this session, you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. You learn how to implement new features added in SQL Server 2014 to improve table partitioning. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.
200
Dev
You have probably heard about the Accidental DBA, but what about the Accidental Data Warehouse developer? We stumbled into the world of data warehousing, learned dimensional modeling and work with T-SQL and SSIS daily. We're masters of googling solutions to our problems and make sure our complex ETL processes run without errors. We deliver data to business users... but we don't deliver data as fast as we want.

You might not be able to rewrite your entire data warehouse or change your team's processes over night, but there are many things you can do to increase your own productivity and become a more efficient data warehouse developer.  In this session I will show you some of what I've learned and discovered that has made me burst out "Oh wow! Why did I not know this yesterday!?" including query improvements, free tools and scripts, SSMS features and even a couple of things I used to think were only useful for those scary DBAs.
200
BI
Learn how to make BI really work for you with Power Query in Excel. In this session, you’ll see how to make business intelligence truly actionable for your end users by mashing data together that might seem unrelated at first. You’ll find out how to use the Power Query platform to take data from tables in websites and mash it with data in proper relational databases. Then, see how to present the data to end users with Power BI.
300
DBA
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? Should I blame statistics for all the performance problems that I have? Let’s start from the beginning and get all you need in order to build a good understanding of what statistics are, how they work, how the QP uses them and what are their update rules. In this demo full session you will find the answers of all the stats questions you may have and more. You will feel like you can make the power of statistics work for you.
300
BI
This session will step you through how to locate SSRS performance issues, long running reports and ultimately fix performance issues.

Areas Covered are:
  • Reporting services architecture
  • Tools and processes for analysing performance
  • Replaying reports from production to QA
  • Common reporting services performance issues
200
Dev
Topics that will be covered in this session are...

1./ What is a heap.
2./What is the effect of adding a clustered index to a heap.
3/Look at fundamental structure of clustered index.
4./Do you ever need to include the clustered index reference in a non-clustered index?
5./Is a clustered index covering?
6./Order of deleting indexes. Is it important?
7./Best attributes for clustered index choice (and reasons).
8./Do clustered indexes need to be unique?
9./Should the primary key be the clustered index?
10./Fragmentation and the clustered index.
11./Performance of inserting records into a heap compared to table with clustered index (space used and time taken)
12./ Short sermon on clustered indexes.
100
Dev
Ever wonder how someone else does it? There’s no right way or wrong way, but in this session, you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries, tries various techniques to make them faster, and shows how he measures the before-and-after results.

You'll learn:
  • How to measure your changes as you tune the query
  • Why user-defined-functions and table variables can backfire
  • How SQL Server 2014's new cardinality estimator affects your queries
  • How to tell if SQL Server threw in the towel while building your query plans
  • What free tools make the process much easier
300
DBA
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.
300
BI
Office 365 Power BI offers new and exciting features that are leading a lot of companies into the cloud. However, there are several additional considerations that you must factor into deciding how to architect your overall BI solution.

In this session, you will learn about the available Microsoft Azure components and services that support a BI ecosystem. In addition, you learn how to properly configure your solution, whether it’s a completely cloud-based solution or a hybrid solution that includes on-premises data sources and on-premises client tools. You will gain an overview of Azure networking, and how it works in Azure VMs as well as for Office 365.
300
BI
This session will provide a high-level overview of a subset of the Power BI tools published by Microsoft in Office 365. Attending this session, you will see a live demonstration of Business Analytics scenarios using Microsoft Power BI. Tools included will be SQL Server, Power Pivot, Power View and Power Map.
200
Dev
In this session I'll demonstrate the use of  what is In-Memory database and how it different from disk based  database. Also will show various feature of this new database construct. Some of them are   

1- How to create In-Memory database
2- How to set up using SSMS
3- In-Memory Internals
4- Durable transaction logging 
300
BI
Flat files can be very time-consuming, and also very error prone. Columns move, some are added, data types change and you're not notified in advance. These errors are quite tricky to track down and make your ETL fail right at the beginning. SSIS isn't very helpful here, it doesn't allow new columns at runtime and the column metadata is kept inside the package. I will show what I mean with pre-processing, and how a little custom built tool can help making this robust.
200
BI
SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over again. There are no easy ways to handle metadata and schema changes, and if there are new requirements you might have to go through all the packages one more time.

It's time to bring the Don't Repeat Yourself principle to SSIS development. In this session I will use the free BIDS Helper add-in to show you the basics of Biml and BimlScript, how to generate SSIS packages automatically from databases, how easy those packages can be changed, and how to move common code to separate files that can be included where needed. See why they say Biml allows you to complete in a day what once took more than a week!
100
DBA
Have you ever wondered how companies keep their databases online through unplanned disasters? Have you wondered which high availability features might be best for our shop? In this session we will go over a quick look at log shipping, database mirroring, transactional replication, failover cluster instances and availability groups. John will identify pros and cons for each features and share some tips from the field.  
200
Dev
Profiler is very much popular among DBA's and Developers but we have a very powerful tool that is XEvents, Which is not yet very much popular. This tool is the new Hero. I will demonstrate How to tune query using XEvents.
200
BI
Azure Machine Learning (ML) is a full managed platform to perform predictive analytics. Learn how to build a powerful data mining interface using the Azure Machine Learning platform. In this session, you’ll see how to design simple and complex data predictive flows and common use cases for predictive analytics.
200
DBA
Scaling data has always been a challenge for SQL Server professionals, especially to achieve it on demand of business growing. Typically databases scale in, in order to scale out you need to perform a lot of additional design work. This amazing new level of scalability allows tables to be extended from on-premise to Azure with no need to rewrite queries. The Stretch table feature automatically moves cold data from on premise to Azure. Fully transparent, you can keep querying the on premise database as if all data was there. But you need less storage and less time for backups. Using the stretch table you can also achieve great flexibility of your on prem operational data.
300
Dev
Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
300
Dev
SQL Server Data Tools (SSDT) is a powerful integrated development environment for designing, testing, and deploying SQL Server databases—whether you’re working locally or remotely, connected or offline, or in the cloud on Microsoft Azure—all from right inside of Visual Studio. While SQL Server Management Studio (SSMS) continues to serve as the primary tool for database administrators, SSDT plugs in to Visual Studio as a special database project type designed specifically for the application developer. In this session, Lenni begins by describing the various difficulties that developers face, and then demonstrates how SSDT can be used to remedy those pain points. You will learn how to use features such as code navigation, IntelliSense, and refactoring with your database model—indispensable tools traditionally available only for application development in Visual Studio. We’ll also cover the declarative model that allows you to design databases offline and under source control right from within solution in Visual Studio, as well as how to deploy to SQL Database on Microsoft Azure. Don’t miss out on this demo-centric information-packed session on the current generation of database tools for developers!
200
DBA
You're using Profiler to trace queries, but you feel like you're still missing something. In just one hour, Brent Ozar will show you how to use much better free, easy tools to catch the killer queries lurking in the shadows.

You'll learn how to use:
  • ClearTrace - the slide-and-dice analytics tool for Profiler traces
  • sp_AskBrent - the easy way to see what's happening on your server right now
  • sp_WhoIsActive - Adam Machanic's amazing tool to get in-depth details about locks, wait stats, and more
  • sp_BlitzCache - like capturing a trace without all the pain
300
BI
Your relational Data Warehouse is suffering from performance problems. The nightly batch job is taking longer and longer to run, and users are complaining about bad query performance in the data mart. You know you need to tune it somehow, but where do you begin?

In this session we will take a look at some of the most common performance problems that tend to occur in a relational data warehouse. You will learn how to identify these performance problems, and techniques for how to resolve them.
200
DBA
Every forward-looking database vendor in the world is planning or already supporting Columnar Storage and Vector Processing. 

Find out what are the key differences in implementations for Major DB Vendors on the market, and what future for Microsoft Data Platform you can expect in the short and in the long-term.

This session is diving into some of the architectural differences and shows the spaces for potential improvements for both Columnar Storage as well as the Batch Mode.

200
DBA
Indexes are incredibly powerful objects to optimize your database performance. However, when not implemented optimally, indexes can also have a negative impact on your queries! In this session we will take a close look at the different index types, how they work and how we can use that knowledge to design an efficient indexing strategy for your databases. We will also spend time analyzing existing indexes. Are those indexes being used? Can we combine indexes? Those are some of the questions you will learn to answer in this session.
300
BI
When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder; this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools.
200
Dev
Ever thought about using event sourcing to enable CQRS (Command QueryResponsibility Segregation), or did you just want an easy manner of creating an audit trail or a notification system?

EventStore (http://geteventstore.com/) is an open source DSD (DomainSpecific Database) engine designed just for that, driven forward by GregYoung (https://twitter.com/gregyoung and http://codebetter.com/gregyoung/).

By concentrating on creating a read only store of idempotent events,supporting AtomPub in XML and JSON for reading data, and with JavaScript used to create projections (think indices) on the events being persisted,the guys at EventStore have created a highly robust, fast and scalable solution to a host of everyday problems for which a RDBMS like SQL Server and mySQL is overkill.

This is for people who want to find out what EventStore provides, the installation options, how you get data in and out, and why it's a fantastic solution if you have the right sort of problem.
300
DBA
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. 
300
Dev
Batch processing is fine if your data is stood still but what if it isn't?  What if it is coming to you in an open ended stream, how do you deal with that?  Come to this session to look at two options, Storm and Azure Streaming.  We will look at these two options and see the potential benefits they offer to you.
200
BI
How do you select the optimal fantasy team line-up to beat your friends at fantasy Formula 1? With over 1/4 million combinations of teams and drivers and a complex points scoring scheme, your odds aren’t much better than a lottery.

In this session we’ll create a PowerPivot model from scratch, import and transform data from the web using PowerQuery, and create DAX calculations including many to many relationships for some complex analysis and great interactive dashboards.

Guarantee yourself eternal glory as a braniac petrol head, and become a PowerBI and DAX pro in the process.
300
BI
Power BI is a dream tool when it comes to demos. In this session you'll see some cool things you can do with Power Query, Power Pivot, Power View, Power Map and Power BI for Office 365, and even if what's shown has very little business use you'll learn a lot by seeing how each of the demos is implemented. Prepared to be amazed!
300
Dev
tSQLt is a testing framework that is designed to help you write
repeatable, isolated tests against your database code. In this session
we will briefly examine the goals of testing, where it can be used in an
automated deployment pipeline, and introduce you to the tSQLt
framework. We’ll show you how to design and write tests to enforce
standards, check calculations and other DML operations as well as check
exception handling. You will see how a real world refactoring task can
be tested in a repeatable manner. Learn how you can incrementally write
tests that help you build higher quality code and minimize the
introduction of errors against your existing objects.
300
BI
Power Query is the Self Service ETL Tool, that is part of Power BI components. M is the powerful language that performs as the code behind of Power Query. There are many features in Power Query that does not exists in GUI. for working with those features you have to be familiar with M. in this session we will deep dive into M power query language. and we will write functions to server our data transformation requirements. there will be many live demos through this session.
300
BI
Now that we all master the delivery of a BI solution using traditional waterfall or V-model software development cycles and SQL Server components, it's time to enter the 21st century and adopt Agile Methodologies: inscribed in Agile values, iterative on functional scopes and not technical ones, part of a cycle of continuous improvement for people and solutions.
200
DBA
Have you considered consolidation? Should you consolidate on physical or virtualised hardware? Should you use VMWare or Hyper-V? What are the license implications? Should you consolidate the server, instance, or data? Do you need to save money within your SQL Estate? Would you like a more manageable solution for DBA’s?  How will this affect the business?
All of these questions will be addressed as part of a session which will present common questions asked by DBA’s, architects, CTO’s and CFO’s whom all have a say in how your database should be implemented and managed. 
200
DBA
SQL Server upgrades often promise enticing new features and much needed enhancements, but how can you perform upgrades while maintaining high availability of your SQL Server infrastructure? You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime and minimal service disruptions.  

In this session you will:

- Understand how rolling upgrades are better than in place upgrades
- Learn how to use Database Mirroring or AlwaysOn Availability Groups for rolling upgrades
- Explore how you can use Log Shipping to perform a simpler type of rolling upgrade

This is an interactive, demo-intensive talk!
300
Dev
Microsoft has a famous whitepaper called "The Data Loading Performance Guide".
The problem is that it's long and full of small details, and we're too lazy to read it. 

On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.  

Among other topics, we will talk about: 

  • Minimal Logging 
  • Transaction Management
  • Bulk Loading Methods
  • Indexing Techniques for High Performance Data Loading
  • Properly Leveraging Parallelism and Partitioning
  • SQL Server 2014 Delayed Durability
300
DBA
SQL Server 2014 introduced Buffer Pool Extensions, but the questions remain what is it, how does it work and how can I use it. Together we will answer these questions and more, to help you decide when you should consider making use of this feature to enhance your systems performance. I will help explain why we have this feature, how it works and when you should look to make use of it. Looking at which other SQL Server features it works well with and how to tell how much use it is getting. By the end of this session you will be confident in your ability to decide if and when you need this capability.
300
Dev
You store data in SQL Server, but you don't have enough work to keep a full-time DBA busy.

In just one session, you'll learn the basics of performance troubleshooting, backup, index tuning, and security. Brent Ozar, recovering developer, will teach you the basic care and feeding of a Microsoft SQL Server 2005, 2008, 2012, or 2014 instance and give you scripts to keep you out of trouble.

You'll learn:
  • Why every table needs to start with a clustered index
  • How to quickly guesstimate good-enough indexes
  • How to get the most resource-intensive queries on your server
  • How to set up the right backups for what your end users want
  • Which database roles give you simple, easy security
400
DBA
DML is used in most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level.

After finishing the theory the differen DML commands and their tremendous operational tasks for the db engine will be investigated.

See, what effect a workload will have to handle page splits and/or fowarded records.
This session is a demo session. The demonstration of the different workloads will be explained in detail while the demos are executed.
300
BI
One of the basics of the Kimball methodology is to tolerate data quality errors where at all possible and load FACT rows into the data warehouse.

FACTs need to be produced as fast as possible, often from multiple data feeds with definite bounds on load windows.

The use of FACT table clones can reduce database entity clutter, optimise the development and execution of Fact Loader SSIS packages and improve data quality.

In this session I will describe the basic components to implement this technique and demonstrate the core clone to target loader functionality.
300
DBA
With every SQL Server versions we have many performance related tools to tackle the performance related problems. What kind of tools can we use for various performance related issues? Is the commonly used SQL Server performance tools provide full support to our day to day performance issues?

There are many questions that needs an answer to help every DBA & Developers to stop scratching their heads. This session throws plates full of platter and you can decide what to choose for each different scenarios that you face in your work place.
300
DBA
Maintenance Plans for Beginners (but not only) | Each of experienced administrators used (to some extent) what is called Maintenance Plans - Plans for Maintaining Database. During this session, I'd like to discuss what can be useful for us to provide functionality when we use them and what to look out for. From SQL Server Tools in Management Studio, throught Wizard and Designer, to advanced scripts and methods.
200
DBA
Ideal database security settings usually exist in books, but rarely in reality. Is your CIO a member of the sysadmin role because they demanded it? Or maybe some users have rights for purely political reasons? Just because you can't enforce security through typical means doesn't mean you're powerless. Attend this session to learn about the features SQL Server provides that will allow you to keep track of what your users are up to at all times and sleep a little easier. Through various scenarios and demos, see how technologies such as event notifications, auditing, and extended events can help ensure nothing happens on your system without you knowing about it. Even in optimally secured environments these techniques can still come in handy. The best security is often that which cannot be seen.
300
BI
If you can build SSIS packages or reports, you can do machine learning. Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies. This new technology provides new opportunities to build and deploy machine learning algorithms in minutes instead of weeks. Come learn hands on as we deploy these together in this session!
300
DBA
Microsoft SQL Server 2014 brings to market new capabilities to simplify cloud adoption and help you unlock new hybrid scenarios. This demo-filled session will highlight these features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud to provide new disaster recovery and backup solutions. In this session we will look at 5 great hybrid scenarios that are made possible by both great new features as well as enhanced features of SQL Server 2014. We’ll not only look how to use and implement these hybrid features, but also look at look at and discuss scenarios around why you would use these hybrid cloud features to expand your on-premises options without adding complexity. We’ll look at how you can easily move workloads from your datacenter to Windows Azure while still maintaining a complete view of your infrastructure with increased proficiency and reduced cost.
300
BI
There are two components in SSIS that helps you in extensibility; Script Task in Control Flow, and Script Component in Data Flow. You can write .NET scripts within these two components. In this session you will learn how to get most of your SSIS package by doing part of the work with scripting. you will learn that there are some opportunities in SSIS packages that few lines of code saves you from big and complex ssis control flow. you will also learn how to implement some scenarios that might not be possible with mere built-in components of SSIS. 
You will also learn with many demos how to write custom component, and how to re-use that in other packages. This session is all about scripting in SSIS and make your SSIS extensible.
Presenter of this session is author of SSIS Scripting book. you will see many real world demos through this session. 
400
Dev
Sometimes it seems like business users are constantly more demanding: They want more data, more analytics, more insight, and the output needs to be faster, faster, faster. And so we database developers struggle to write ever more complex queries, tune our hardware, carefully choose indexes...and sometimes it’s just not enough. Where do you go when you’ve hit the performance wall? As more and more developers are discovering, a great choice is to make use of SQL Server’s CLR capabilities. User-defined aggregates, table valued functions, and user-defined types are more than just logical constructs; properly applied, they can make complex, logic-driven queries many times faster. This session will show you when and how to use these powerful tools in ways you may not have previously considered. You’ll learn how to speed up various types of analytical queries, do much faster XML processing, and build smart caches that will supercharge your user-defined functions. If you’re ready to take your SQL Server development skills to the next level, this session is definitely your starting point.
200
Car
Everyone wants a dream job that they enjoy going to each week.
However finding that job, and getting yourself hired can be hard for
most people. Steve Jones will give you practical tips and suggestions in
this session that show you how to better market yourself, how to get
the attention of employers, and help improve the chances that the job
you want will get offered to you. Learn about networking, blogging, and
more. Learn practical tips on
  • Networking
  • Blogging
  • Volunteering
  • Speaking
  • Authoring
  • Leadership
200
BI
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages
added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive
design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand. 
400
Dev
Cast your mind back to November 2005, Madonna had just been knocked off the Number 1 spot by the Pussycat Dolls and SQL Server 2005 was released - writing Management Studio Add-ins was a total nightmare.

Fast forward 3 years, Katy Perry was kissing a girl and SQL Server 2008 was released, guess what, Management Studio Add-ins still a total nightmare and your previous 2005 Add-ins didn’t work!

As Lady Gaga sings Bad Romance, the team in Redmond release SQL Server 2008 R2 and SSMS Add-ins break again.

Leap forward a couple more years, a guess what, the old SSMS appears is replaced by the Isolated shell... and its broken again...

Now its SSMS 2014..will Add-ins still work? Come to this session and find out.

 
300
DBA
Quorum is one of the most misunderstood aspects of planning, deploying, and maintaining clustered implementations of SQL Server that use the AlwaysOn features: failover cluster instances (FCIs) and availability groups (AGs). The reality is that quorum is crucial for maintaining uptime, and without it properly configured, you can experience downtime even though you are clustered. This session will cover multiple versions of Windows on how to approach, configure, and manage quorum for your both FCIs and AGs, including how to force quorum if necessary.
300
DBA
For many organizations having a second data centre or co-location is not a viable option, either from a financial or logistical perspective. In the past, this limited options for disaster recovery (DR). Windows Azure virtual machines and SQL Server allow you can design and build highly available hybrid solutions, which bridge your data center to the cloud. This half-day session will showcase all of SQL Server’s DR features in this hybrid model, as well as environments built only in Windows Azure. You will learn about off-site direct to Azure backups from your local SQL Server. You will gain an understanding of the networking model within Azure. You will see demos of log shipping, replication, mirroring, and Availability Groups in a hybrid model. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs, benefits and limitations of building a DR solution using Azure, and how Azure based backup and recovery works.
300
DBA
Just staring at the output from for instance sys.dm_io_virtual_file_stats is usualy not very helpful. Creating delta's from the data and then representing it as a graph helps to understand that data. Over the years I've tried various ways to look at output from SQL Server for performance tuning reasons. In this session I will share a couple of them with you. We will look at virtual_file_stats, waitstats, the buffer cache etc. and we will visualize them in various ways to make it easier to draw conclusions. The visualisation techniques vary from simple graphs that combine throughput and latency to more complicated scenarios that I saw being used by Formula 1 on tv, which translate well to Waitstats and Buffer pool cache usage.
300
Dev
Continuous delivery is all the hype in software development. However, databases are being neglected as DBAs just don't seem to trust database automation.This is not surprising when you consider the number of incidents and instances of downtime that were caused by out-of-process updates, code overrides and other database glitches.In this session, I will explain what continuous delivery for databases is all about, why DBAs are so mistrusting, and ways to overcome that mistrust and conquer database automation.
200
DBA
Walk through on creating SQL Server solutions in the cloud! Learn about the options for data storage in Azure, plus how to (very easily) configure and deploy a SQL Server. We will go over pricing, storage options, security and other details on using either Infrastructure as a Service (Iaas) or Database as a Service with Microsoft cloud solutions.

Also covering a list of pros and cons to compare and contrast IaaS and DaaS against on-premises implementations.
300
DBA
Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others. This session will share some SQL server wisdom on “gut check” strategies that can help you avoid making common SQL Server mistakes. 


Backups – are yours good enough?
Maintenance – learn about regular a maintenance that can keep your SQL Server running its best.
Instance Configurations - Which settings should you be aware of that can make a huge difference?
Baselines and why they are important.
300
DBA
Extended Events are replacing the old SQL Trace & Profiler, and there are many good reasons for that. In this session I want to demonstrate to you some of the coolest features and possibilities of this Tracing Framework,
which is actually not so new anymore, having been introduced already in SQL Server 2008 and much earlier in Windows. If you want to find out how to trace in a flexible and lightweight way, get a callstack without running a Debugger, and do advanced analysis directly inside the GUI together with some background information such as why actions are “actions” and not just simply “columns”, this session is just for you. You will never want to see Profiler again.
300
Dev
Do you have ever looked on an execution plan that performs a join between 2
tables, and you have wondered what a "Left Anti Semi Join" is?
Joining 2 tables in SQL Server isn't the easiest part! Join me in this session
where we will deep dive into how join processing happens in SQL Server. In the
first step we lay out the foundation of logical join processing. We will also
further deep dive into physical join processing in the execution plan, where we
will also see the "Left Anti Semi Join". After attending this session
you are well prepared to understand the various join techniques used by SQL
Server. Interpreting joins from an execution plan is now the easiest part for you.    
300
DBA
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW?

New version odf my old well-known session updated for whole changes which happened iin DBA World in last two years. So, from the ground to the Sky and further - everything for surviving disaster.

Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared.
200
DBA
Microsoft released SQL Azure more than three years ago - that's enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services (and not only). In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
200
DBA
Dynamic Management Views and Functions (DMV's) were first introduced in SQL 2005 and more DMV's are added with each new version of SQL Server.

DMV's can give us an insight into what is happening inside SQL Server, from running queries, transactions and locks taken to server performance and configuration.

In this session we will look at what types of DMV's there are and what useful information can be found from the most important ones. This can allow us to identify resource intensive queries, make server optimizations and useful performance tweaks.









200
BI
Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will demonstrate how to build your ETL processes and keep your data warehouse updated using Service Broker messages from your OLTP database.
300
BI
In this session you will see pros and cons of using any of Microsoft Data Visualization Tools;
  • SSRS
  • PerformancePoint
  • Excel PivotTable and PivotChart
  • Power View
  • Power Map
These tools will be compared based on different aspects in detail. you will see their difference with many live demos. there will be many comparison matrix at this session that guide you to use which tool for which scenario and requirement.
300
Dev
Indexes are essential to good database performance, but it can be hard to decide what indexes to create and the ‘rules’ around indexes often appear to be vague or downright contradictory.

In this full day session we’ll dive deep into indexes, have a look at their architecture and internal structure and how that affects the way that indexes are used in query execution. We’ll look at why clustered indexes are recommended on almost all tables and how their architecture affects the choice of columns. We’ll look at nonclustered indexes; their architecture and how query design affects what indexes should be created to support various queries.
200
BI
More organisation are currently evaluating the use of the hardware within their business. In the past, this would involve contacting hardware suppliers with replacement kit to continue business operations. The cloud offering from Microsoft is improving all the time, thus providing an alternative consideration as to where an organisation can store its IT assets, including it’s data.

Join Chris for a cloud driven, demo packed session to introduce you to the capabilities that Microsoft has to offer when it comes to the cloud. Focussing on the data properties of Azure and the capabilities of Office 365 and PowerBI. At the end of this session you will have a better understanding of what Microsoft can bring to the table for a cloud ready business.

Topics include:
 
  • What is the Cloud
  • Types of Implementation
  • Impact on the Data Professional
  • Cloud Capabilities:
    • Azure Virtual Machines
    • SQL Database
    • HDInsight
    • Machine Learning
  • Office 365 and Power BI

200
BI
Your tabular model is done, approved and ready to be used by the user. By means of using Excel the user gets very excited about the use of tabular Models. For a while the user uses Excel as a self-service business intelligence tool. Then all of a sudden the user starts asking if they can use the program to extract more and other information from the tabular model by the use of Excel. Now it is up to you to familiarize the user with all the possibilities of working with the tabular model by means of Excel.
Given the small amount of documented knowledge about the use of tabular models by means of Excel, I will show you how to get the best of your tabular models by using Excel as a self-service business intelligence tool. Filters, named sets, and calculations in the pivot table: I will explain it all!
200
DBA
One of the most under-utilized management features of SQL Server is the Central Management Server. This powerful little tool creates a catalog of servers that allows you to execute any query or script against multiple servers at the same time. Sure, you can do the same thing with PowerShell, but who has time for that? 


Join SQL Server MVP Mike Hillwig for a look at this powerful little feature. 
400
DBA
Love to run Brent's sp_Blitz and use Ola's MaintenanceSolution, but you have dozens or even hundreds of servers?

Let's build a Powershell script together that will use Remoting to run whatever script you like in parallel on any number of servers. We'll talk about remoting, remoting across domains or even without, how to run scripts in the background and in parallel. I'll show you how to store the results and report on it across all your servers in one go.
300
DBA
While you can see how to run through Setup to deploy a clustered instance of SQL Server in 60 minutes or less in other places, and you can also see how to configure SQL Server 2012's availability groups in a few minutes, what ties them together is the underlying Windows failover cluster. A DBA really needs a solid foundation of Windows failover clustering  to truly be able to understand that implementation and its subsequent administration. This session will demystify the Windows layer of clustering and present it from a DBA point of view. Some of the topics that will be shown are: failover cluster validation and its impact on installing SQL Server, a tour of the new Failover Cluster Manager and how it can be used for administration, the cluster PowerShell cmdlets, and more.
100
Car
Databases are still being managed like legacy code. Integration is difficult, automation is non-existent, and agile is not even used in the same sentence as database.Software development best practices need to be similarly applied to databases or we will be stuck decades behind.In this talk we'll look at the need for and benefits of best practices in database development including version control, deployment automation, and task-based development.
200
DBA
Some of the biggest challenges in any large SQL environment are maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. By default, SQL Server does not install with best practices for every environment. Learn best practices for system settings, file system layout and scheduling maintenance tasks. Understand what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. Completely automating the build process has great benefits, but has tradeoffs; you will get lessons learned from building a private cloud at a Fortune 100 telecommunications company with 1000s of servers. You will also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.
300
DBA
Hekaton is the Greek word for 100 - the goal of In-Memory OLTP in SQL Server 2014 is to
improve query performance up to 100 times. In this session we will look under
the cover of Hekaton and the Multi Version Concurrency Control (MVCC)
principles on which Hekaton is build. We will start the session by looking on
the challenges that can be solved by Hekaton, especially Locking, Blocking, and
Latching within SQL Server. Based on that foundation we move into the
principles of MVCC, and how a Storage Engine and Transaction Manager can be
built based on that concept.    
300
Dev
Taking you through the concept of in-memory tables and what to be aware off when considering converting your database tables and code to In-Memory tables and Native Compiled Stored Procedures (better known by its codename Hekaton), this session will give you all the tips and tricks to leverage on the new concepts and Work your way around its current limitations, to gain enormous speed increase and a lock-free environment.
300
DBA
Resource Governor is a mechanism built into SQL Server that helps you control resource utilization by different workloads. You can specify limits on CPU, memory and IO consumption for different applications or users. This feature allows you to better exploit server resources and also to provide more predictable performance. It can also serve as a powerful monitoring tool that allows you to monitor resource utilization for specific workloads.
This session will present Resource Governor from the ground up, including the new enhancements in SQL Server 2014. We will demonstrate how Resource Governor can be used to control resources and to monitor workloads in several use cases, such as a multitenancy environment and a single database serving multiple applications.
300
BI
Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources. In order to use these new features, you will continue to leverage existing skillsets, such as Tabular, Power Pivot, DAX, and you will be able to connect to database and semantic models you already built, such as existing databases in Analysis Services Multidimensional and Tabular. The goal is to create dashboards leveraging data and models that you already have both on cloud and on premise.
200
Car
The IT industry is a growth industry employing millions of workers in all industries and regions of the USA, UK, Europe and around the world. This perennial shortage of IT experienced workers, added to IT career
paths which hit a salary plateau for those who stay purely technical, means it’s very common for a talented IT pro to move into leadership and management positions. Unfortunately, the skills that made you a successful individual contributor on an IT team don’t translate into the skills needed to be a strong leader or manager. This session delves into a variety of common mistakes among new IT leaders, such as:

1. How does accepting the status quo limit productivity and inhibit innovation?
2. What does an uncommunicative leader express to their team and superiors?
3. Why is goal setting such an important part of leadership?
200
Dev
SQL server 2014 is one of the measure release. Where Microsoft has done a superb job.  There are so many enhancement we have in SQL Server 2014. In my session I will show  top 5 features i like most. 

My Top 5 Features are 
1- Memory-Optimized Tables
2- New Design for Cardinality Estimation
3- Incremental Statistics
4- T-SQL Enhancement
5- System view enhancement

My session will be loaded with demos, because I am a developer and i don't like slide based session.
200
BI
The aim of this session is to introduce easier way than corporate BI .Power BI is a self- service tool which can handle all ETL process (extract, transfer and load), manage, discover, and visualize data. Power BI consists of many features and services, and works seamlessly with Excel. In this session you will see an end to end demo which shows how easily Power BI tools provides a business intelligence (BI) solution. In this demo we will show a practical solution which using
      
  • Power Query– easily discover and connect to data from public and corporate data sources
  • Power Pivot – create a sophisticated Data Model directly in Excel
  • Power View– create reports and analytical views with interactive data visualizations
  • Power Map– explore and navigate geo spatial data on a 3D map experience in Excel
  • Power Q&A– use natural language queries to find, explore, and report over your data
200
BI
Fans of BBC Radio 4's 'More or Less' will be familiar with the mythbusting theme, where we take some ridiculously wild news headlines and explore the data to understand what really happened. Join us for a fun newspaper-headline myth bashing session using Power BI, inspired by myth busters such as Tim Harman and other headline exposers. We will look at data journalism in various media, and see how it helps us to understand better using data visualisation and PowerBI.
300
DBA
As the concept of "Hybrid Datacenter" becomes more mainstream data professionals will need to understand how to effectively manage and migrate data between on-premises and cloud servers. Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.

Attendees of this session will learn:
  • How to decide if IaaS of PaaS is the right option
  • How to prepare your database for migration to SQL Azure
  • How to best migrate data to Microsoft Azure
300
BI
SAP HANA is ubiquitous nowadays and it will also remain a hot topic in the future. But besides the technical specifications it is also very important how to work with the data in the end and the majority of users still relies on Microsoft Excel here. Especially Office 365 and Power BI enables users to work with this data in a whole new way. In this session I will show how to combine the best of both worlds by using Power BI to load and analyze data that resides in SAP HANA and will highlight the most common pitfalls and what you have to consider.
300
Dev
Despite widespread adoption of Unit Testing for general application development, adoption within database development is rare and many database developers will not have ever written a unit test, despite the advantages it can bring.  This session will provide an overview of Unit Testing using the open source tSQLt framework, demonstrating how it can increase confidence in your code, save you time and help prevent bugs from being introduced in the future.
300
BI
Developing a Report with Reporting Services is easy. But how can we deliver consistent and bug free Report in a short turnaround. Continuous Integration help us to Build, Unit Test and Deploy the components as we develop. It helps the Developers, DBAs, Test Engineers and the Release Managers.
300
BI
Power BI provides a cloud based collaborative platform to manage and share business insights anytime and anywhere. This session will explore how to access the Power BI site, manage integration with on premise data and set the availability of data to individuals within the business. Finally exploring some of the cool capabilities that will enable users to quickly create and share business data in a highly visual way.

Topics include:
  • What is Power BI
  • Starting Power BI
  • Integrating domains
  • Working with gateways and data sources
  • Role management and settings