4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


Sessions

Voting is now open to help us choose the general sessions at SQLBits.

You are not logged in at the moment, to vote you need to be logged in to the site Click here to login or register on the site
 

Filter Sessions:
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
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!
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.
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.
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.
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
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.
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
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
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. 
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
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
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
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
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
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!
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
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.
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.  
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
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
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
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.    
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
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
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
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.    
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.    
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.    
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.    
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
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.
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 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
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. 
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.
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
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!
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.
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
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.









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

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

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

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
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.
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.
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
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.
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.
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 
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.
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.
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.
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.
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?
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.
200
DBA
Let’s face it.  You can effectively do many IT jobs related to SQL Server without knowing the internals
of how SQL Server works.  Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the
scenes.  But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture.  This session will answer questions like:

-       What are the various areas of memory inside of SQL Server?
-       How are queries handled behind the scenes?
-       What does SQL Server do with procedural code, like functions, procedures, and triggers?
-       What happens during checkpoints? Lazywrites?
-       How are IOs handled with regards to transaction logs and database?
-       What happens when transaction logs and databases grow or shrinks?

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information.  So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek! 
200
DBA
You have heard about PowerShell and may be spent a little bit of time exploring some of the ways in which it will benefit you at work. You want to be able to perform tasks more specific to your organisation and need to share them with your team.
I will show you how you can achieve this by demonstrating
An easy way to learn the syntax
How to explore SQL Server with Powershell 
How to turn your one off scripts into shareable functions
How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions
Where else to go for help
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.
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.
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.
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
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.
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
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.
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.
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.
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.
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. 
300
BI
Data Profiling is a vital step that is often overlooked in the development process. Integration Services (SSIS) built-in support for data profiling is limited and takes manual user intervention. Learn a new approach to automate data profiling and increase your data awareness.

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 easily 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.
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
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.
200
Dev
Microsoft SQL Server 2005 through 2014 include a fantastic feature that few people understand or use.  That feature is the Microsoft SQL Server Service Broker.  The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature. In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing.  We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting. By the end of this session you'll understand where SQL Service Broker is the right fit to be used, and you'll hopefully be ready to deploy it within your environment.
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.
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.
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.
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.
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
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
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.
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
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
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.
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
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!
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.
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.
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
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.
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
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.
100
Car
A light-hearted tour of Azure, focussing on the benefits you can get for free by way of your MSDN subscription and how to get them up and running.


Covering:
  • Blogs
  • VMs for studies
  • Storage for films, music & photos
  • Visual Studio Online for project collaboration
  • Backups of home PCs
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.
200
DBA
If you're not a DBA but find yourself needing to diagnose your database for problems what do you do? When I was in this position a few months back, instead of panicking, I asked the #SQLFamily and got back some fantastic help. This session distils the information received and hands over to you a simple process using free scripts to diagnose problems and gives you pointers on resolving common issues. 


Starting off with the permissions you'll need to diagnose the database and how to get the scripts running, we then run scripts like Brent Ozar's sp_Blitz to gather information and compile it into a comprehensive report. Once we've gathered all the facts, it's time to diagnose what's wrong and move forward with solid recommendations. 


By the end of this session, you'll be able to diagnose most common database performance and health issues reliably by yourself - a big achievement in my book!
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.
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.
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
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.
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.
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
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
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.
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
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.
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
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.
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
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.
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
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.
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.
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. 
300
DBA
Microsoft has a lot of useful Business Intelligence (BI) tools in both SQL Server and Office. But why would you only use them to analyze your business? Whether you want to keep a business up and running or a bunch of servers... both can benefit from the same tools.
In this talk we have a look at typical problems SQL Server administrators are facing... and how to analyze them using the Microsoft BI tools. From simple reporting up to data mining, this talk covers (and uncovers) them all... 
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
TempDB is not your ordinary user database and should definitely not be treated like one.  The usage patterns and internals dictate that the configuration, monitoring and usage be done in a different way to get the best performance. We will see why aspects such as configuration and file placement play such a key role and why you need to plan ahead for TempDB.  See how to detect the memory and space usage associated with the various users in TempDB along with some of the most common performance related scenarios that you will encounter with a well-used TempDB database.  In addition we will explain the differences between temp tables and table variables and when to use one over another.  Both DBA’s and Developer’s should understand the concepts of TempDB and how some relatively simple changes in code or configuration can potentially make a huge difference in the overall performance of SQL Server.
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
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
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.
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.
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.
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.
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
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.
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.
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
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)
200
DBA
Working on full abstract...i'll update this week.
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!
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
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.
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
DBA
SQL Server comes with a powerful built-in permission management system. However, as most powerful tools, this one too can be difficult to use and get right.
 
This is a two-part session. During the first part, we will go through a review of SQL Server security terms and concepts, particularly the GRANT, REVOKE and DENY statements. For the second part, the audience selects topics that we will cover in detail. You will be able to choose from 12 different security pitfalls and misconceptions. All these pitfalls/misconceptions have one thing in common: If you are not aware of them, you might GRANT or DENY more permissions than you intended.

After attending this session, you will be able to 
  • explain important security related terms and concepts in the context of SQL Server.
  • grant, revoke and deny permissions and demonstrate their differences.
  • identify security inconsistencies in the SQL Server permission model and revise your current security plan to avoid potential issues.
To get the most out of this 200 level session, you should feel comfortable writing simple queries and creating basic tables and procedures.
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.
200
DBA
So, you got told you need to encrypt "the database". Now what?
Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the DBA, you will learn the difference between symmetric and asymmetric encryption, discover what a cryptographic one-way hash function is and probe into cryptographically secure pseudo random number generation. After exploring the different definitions, you will be able to observe how to implement encryption, decryption, transparent data encryption (TDE) and hashing in SQL Server. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies. 
After attending this session, you will be able to 
  • explain the difference between symmetric and asymmetric encryption.
  • select the right cryptographic technology for your special security requirement.
  • identify when to use one-way hashing instead of encryption.
To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and have basic permission management skills.
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.
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
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).
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.
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
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.
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
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.
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
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.
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
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.
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
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
Have you ever gotten tired of your database taking hours to back up? Are you sick of your users breathing down your neck because the database restore is taking too long? Now you won't have to worry about that anymore. In this session I show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. You'll learn about the backup "execution plan" and how to access it. Understanding how to tune the individual portions of your backup process will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15 years to tune my backups and I’ve had great success.
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.
300
DBA
Graphing Perfmon metrics doesn’t have to be left to 3rd party applications with hefty price tags.  Windows and SQL Server already have all you need to collect and report on server performance.  And DIY (Do-It-Yourself) reporting is more flexible than what you’ll get from a vendor.  Creating your own reports is much more than a “poor man’s method”; I’ll show you why it’s really the preferred method.  Not only are DIY reports free, you can customize them to do things that expensive solutions don’t even think of, like handling clusters, AvailabilityGroups, mirroring, or any other custom scenario you have.  You’ll be surprised how easy it is to create your own reports with Perfmon data. A savvy DBA can stand-up a solution in just a couple hours. And after attending this session you’ll have with a framework you can setup and start using with very little effort.  You will also walk away with the skills you need to turn your reporting solution into an enterprise-level baseline repository. 
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
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!

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
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!
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
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
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
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.
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
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!
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.
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.
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.
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. 
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.
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
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.
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
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. 
200
BI
What's your data visualization vegetables, and what's your candy? This session will look at data visualization theory and practice of hot data visualization topics such as: - how can you choose which chart to choose, and when?



- how can you best structure your dashboard?



- what about pie charts? What is the fuss about, and when are they best used?



- Colour blindness - how can you cater for the 1 out of 12 colour blind males (and not forgetting the 1 out of 100 colour blind females?)



- To 3D or not to 3D? Why is it missing in Power View? And any other data visualization topics you care to mention! Come along for dataviz fun, and to learn the 'why' along with practical advice.
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. 
200
BI
Investigative exploration of data is very often ad-hoc in nature. We might need to interact with many types and soures of data. The Questions we need to ask, and the data we might need to answer them are not set in stone, and as a result following traditional modelling is not always an option. Rather, we follow the data, to an unknown end.

In this session, we take the European Economic Crisis, and the Euro, and see what publically available data can do to give us insights into one of the largest currencies in the world.

See the Microsoft Power BI stack used to tell a real world story.
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
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.
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.
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
 
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.
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.
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
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
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.
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.
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
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
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.
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
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
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. 
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. 
300
BI
Attend this session to get an overview of two different real-world approaches to automate your testing of Analysis Services cubes.
  • The first approach captures snapshot of the cube metadata/structure and a representative sample of values from all measures. With a set of reports it is possible to compare the snapshot and find the differences - ie before and after deployment or between two different environments. 
  • The second approach uses the test framework nBI to test result sets, performance, syntax, structure and dimension members.
The session will wrap up with introduction to implement the unit testing in your deployment process.
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
BI
Project Scoping and Tool Selection Understand the criteria for selecting the right tool for each stage of a BI solution and planning for scale & growth. Data sourcing and cleansing with Power Query Import, cleanse and transform data from multiple sources using the Power Query add-in for Excel and Power BI.  Automating data loads and planning for enterprise scale ETL. Dimensional modeling in SQL Server The core design patterns and rules of data governance remain constant in the new age of self-service BI.  However, new tools and technologies change the way we think about relational modelling for BI.  Do you need a data mart, star or snowflake schema or can you build semantic models without them?  Start Your Modeling Career with Power Pivot (Semantic modelling essentials) What to do and what not to do when designing a semantic model for analysis and reporting.  Balance simplicity, scale and flexibility in model designs. DAX: the way we like it.  Uh huh The DAX calculation and query language is powerful and impressive.  It can be simple and elegant or a Pandora’s Box.  Explore DAX best practices and avoid common roadblocks. Dashboards that Excel Excel is the dashboard and BI reporting tool you already know how to use.  Explore sophisticated capabilities that make Excel an excellent data analysis tool for many reporting scenarios. Power View: Making Business Data Pop Touch and interact with your data; visualize, analyze, compare and cross-drill with dashboards and scorecards on a mobile device and desktop. Delivering the Goods:  Production Deployment Options What options are available in an on premises solution or in the cloud?  What are the advantages and considerations for each?  Explore delivery models for IT-managed and self-service BI.
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.
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
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.
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
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
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
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
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
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.
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
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
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.
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.
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!
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.
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.
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
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
DBA
A common use case in many databases is a very large table, which serves as some kind of activity log, with an ever increasing date/time column. This table is usually partitioned, and it suffers from heavy load of reads and writes. Such a table presents a challenge in terms of maintenance and performance. Activities such as loading data into the table, querying the table, rebuilding indexes or updating statistics become quite challenging.
SQL Server 2014 offers several new features that can make all these challenges go away. In this session we will analyze a use case involving such a large table. We will examine features such as Incremental Statistics, New Cardinality Estimation and Delayed Durability, and we will apply them on our challenging table and see what happens...
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.
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 precon we will analyze many 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 precon, you'll have a list of tips and techniques to apply on your environment.
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
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.
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.
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…
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
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
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
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.

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.  
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.
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.
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!
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.
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
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.
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
DBA
As DBAs, we all know about the big new features, like AlwaysOn Availability Groups, Columnstore Indexes and In-Memory OLTP ("Hekaton").
But there are other "small" hidden features you may have not heard about that can make your life a lot easier. In this presentation, we will go over some of the cool "small" features that were introduced in SQL Server 2012 and SQL Server 2014, and see how they can help us.

Among other topics, we will talk about:
·        
  • The new revolutionary sys.dm_exec_query_profiles DMV·        
  • Delayed Durability·        
  • Changes in the storage world and how you can leverage them·        
  • Buffer Pool Extension to SSD drives·        
  • IO throttling using Resource Governor·        
  • Parallelism improvements ·        
  • Partition Switch and Online Index Operations improvements·        
  • Online Schema Changes·        
  • Features that can boost your productivity when working with SSMS
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
DBA
TDS is the protocol used by Sql Server to handle requests and deliver responses, you likely use it every day and over a lan it just works, but the world is moving out of the lan into distributed and cloud environments where the database server is no longer guaranteed to be close to the application.

Learn or get a refresher on how networks and TCP/IP work and learn what TDS is, how it works and how it can be affected by slow or unreliable connections.

Look at what help there is, both built into applications such as .Net connection pooling as well as commercial products.

There is nothing tedious about TDS, it is a really interesting protocol and a great combination of being one of the most used but least understood parts of Sql Server.
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.
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
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
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.
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.
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
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.
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.
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
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.

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.
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
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.
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.
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
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
BI
Want to quickly roll out ultra-flexible reports that will wow your end users? Want to learn how to display the data in multiple layouts on the same report? Want to consolidate similar reports while still providing flexibility to your end users? This can all be achieved by leveraging the three controls based on the Tablix template: Table, Matrix, and the List control.

In this demo-heavy session, you'll learn how to create a columnar report that grows vertically as well as horizontally. You'll see the magic of having multiple layouts for the same data on the same report. You'll see how to do more useful things with fewer reports, and you’ll come away with a bag full of new tricks to make your reports flexible and scalable works of art.
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.
400
Dev
Everyone wants to work smarter and not harder. In the database world we are no different. If doesn’t matter if you work on OLTP or OLAP databases, there are fundamental constraints which we all work upon. I would like to present to you, Temporal Databases. They have the benefit of:
  • Always write
  • Never lock
  • Never lose a change
  • See the data at any point in time
A Temporal Database enables you to create a database schema with the Golden 3 properties. This way, your users are happy, management is happy and the system is consistent and clean at all times. How does this work and what is this Holy Grail? Come to the talk and see for yourself, with code examples, database schemas and of course a full explanation. Come and explore the futures, where you have it all!
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
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.