Sessions Title

These are the sessions submitted so far for SQLBits XIV.

Filter Sessions:
300
Dev
UNIQUEIDENTIFIERs as Primary Keys in SQL Server - a good or bad best practice? They have a lot of
pros for DEVs, but DBAs just cry when they see them enforced by default as
unique Clustered Indexes. In this session we will cover the basics about
UNIQUEIDENTIFIERs, why they bad and sometimes even good, and how you can find
out if they affect the performance of your performance critical database. If
they are affecting your database negatively, you will also learn some best
practices how you can resolve those performance limitations without changing
your underlying application.    
400
DBA
The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. Many DBAs have large collections of gathered spells with DMVs/DMFs and scripted Extended Events sessions. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#. Empower your daily tasks and in case of an emergency yourself and your colleagues with a perfect customized toolkit to visualize your workloads and find quickly the gremlins.
300
BI
SQL Server 2012 provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case as used customers to present a business case for using SQL Server within your business:

Topics include:
 
  • Microsoft Business Intelligence: The Growing Landscape
  • Business Intelligence Roles
  • PowerPivot
  • PowerView
  • Business and IT collaboration with PowerPivot
  • Report Builder
  • Additional Technologies
  • Cloud Collaboration
400
Dev
Do you believe the myths that “Third Normal Form is good enough”, or that “Higher Normal Forms are hard to understand”?
Do you believe the people who claim that these statements are myths?
Or do you prefer to form your own opinion?

If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!


PS: I have entered this session for the DBA track, but it could equally well go into the Dev track. Every workplace appears to have their own ideas on whether the DBA or the Developer needs to be in charge of database design.
300
BI
We have all been through the Business Intelligence / Data Warehouse development cycle.

Endless theoretical cycles, data mapping exercises, wire-frames for reports. Excel and possibly Visio as the only tools in our armoury. Cheery scrum masters intent on convincing management and users that anything can be refactored in a few hour’s work – even a 20 dimension Terabyte data warehouse and 50 reports that were signed off months ago but that now need “revisiting” given the “new input” from users – who, now that they have finally got their hands on something to play with can begin to imagine what they really want.

Well, perhaps Power BI can help you laugh rather than cry when developing your next data warehouse. Instead of starting out with the industrial-strength tools in the SQL Server toolkit consider:

• Testing data sources and load processes with Power Query.

• Building your initial star schema and aggregations and KPIs with Power Pivot.

• Creating reports based on real data using Power View.

• Delivering proof of concept via the Cloud with Power BI.

Use this toolset to get the feedback that lets you make core adjustments – and potentially discover fundamental issues - sooner rather than later in the development cycle. Then build the solution that you always knew was possible, having scoped and planned more accurately.

This short talk takes you through the Power BI product set and explains how you can get analyse, experiment and iterate during the first stages of data warehouse development using Excel and Power BI.  You will see how to give users an instant feel for the possibilities, make the concepts more intuitive and specify the required outputs, aggregations and KPIs more efficiently.

300
DBA
Plan Caching is the most powerful concept in SQL Server. But on the other hand it's
also the most dangerous thing that can lead to queries that are executed with a
completely wrong Execution Plan. In this session we will have a more detailed
look into the Plan Cache of SQL Server, in which different ways SQL Server can
cache Execution Plans in the Plan Cache, and how you can troubleshooting wrong
performing queries directly from the Plan Cache.    
200
BI
Want to do data transformations in the cloud?  Been wondering when SSIS would port to the cloud?  Azure Data Factory is not SSIS but a ground up rethink of moving data in Azure.  
Come to this session to understand how to take your data and move it through a cloud based transformation at scale.
300
Dev
For developers, the database is like a mythical land where data (un)happily lives on green pastures.
For DBA's, the applications are annoying things that make their finely tuned servers loose breath.
Because they are both involved in the development, and to achieve harmony, we must learn about the whole request/query life cycle.
In this session we'll take two queries, a read and a write one, and look at the whole trip from the client 
through the server and back to the client. On this journey we'll try to identify where things might go wrong, 
thus helping to bring friendship between developers and DBA's back.
200
Dev
You've got a piece of code that you want to implement as a trigger, but you've read that triggers can grind your performance to a halt. Developers everywhere write triggers to implement business logic, to enforce certain types of constraints, or to avoid changing database schema or external code. Many triggers are inefficient and violate best practices, but it doesn't have to be this way.

Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.
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
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
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. 
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!
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
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
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

- Overviewof cncepts
- Permissons required to manage resource governor
- Managing Resource pools
- Manging Workload groups
- Classification functions
- Templates
- Changing Resource Pool Settings
- Moving a worload group
- Viewing resource governor setup using DMVs
- 2014 enhancements for physical io management
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.
300
DBA
Azure Windows SQL Database is now an attractive option for
archiving but how do you keep the data available without multiple connections?
In this session you will see how! Is having less data to backup but that's
still highly available and managed an attractive proposition? It is for finance
folk, so come see how it can be done.

Utilising the concept of Distributed Partition Views, coupled
with some linked servers, a pinch of synonyms, some funky triggers, and boom –
anything is possible. In this light-hearted session we’ll take a look at how
this can work and why it is not as silly as it sounds.
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.
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.
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.
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
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
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.
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.
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. 
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.
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
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
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.
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.  
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
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
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
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
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.
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
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
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.
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.
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
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 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. 
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.
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
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.
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.
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. Using live demo, we will walk through ways to channel users focus on actionable analytics.
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
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
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
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
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
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
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.
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
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. 

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?
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.
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.
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
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.
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!
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.
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
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
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 
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.
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
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.
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.
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. 
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
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
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
300
DBA
Replication is a powerful feature that has long been available in SQL Server. However, with great power come great headaches! Replication normally runs happily once set up, but if things go wrong it can turn into a seemingly never ending list of errors. In this session I will dig into how replication can go wrong (and has gone wrong for me) and what steps you can take to fix these issues. Along the way I will go into what monitoring options you have when working with replication and also a couple of gotchas that have caught me out in the past.
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
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
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.
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

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