Sessions Title

These are the sessions submitted so far for SQLBits XIV.

Filter Sessions:
200
DBA
Dynamic Management Views and Functions (DMV's) were first introduced in SQL 2005 and more DMV's are added with each new version of SQL Server.

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

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









200
BI
More organisation are currently evaluating the use of the hardware within their business. In the past, this would involve contacting hardware suppliers with replacement kit to continue business operations. The cloud offering from Microsoft is improving all the time, thus providing an alternative consideration as to where an organisation can store its IT assets, including it’s data.

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

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

300
DBA
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
DBA
As the concept of "Hybrid Datacenter" becomes more mainstream data professionals will need to understand how to effectively manage and migrate data between on-premises and cloud servers. Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.

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

Topics include:
 
  • Microsoft Business Intelligence: The Growing Landscape
  • Business Intelligence Roles
  • PowerPivot
  • PowerView
  • Business and IT collaboration with PowerPivot
  • Report Builder
  • Additional Technologies
  • Cloud Collaboration
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
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
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
DBA
In my job as a SQL Consultant, I have my weekly recurring customers. They don’t have a DBA, so I have to perform the daily DBA checklist on a weekly basis ;) Initially, I've started with executing some T-SQL scripts to verify the SQL Servers. But as more servers were installed, my DBA checklist became really time consuming and I didn't even have the time for a coffee… In this session you will learn how you can perform your DBA morning checklist while sipping coffee. I will demonstrate how you can use Policy Based Management to evaluate your servers and how I configured my setup. By the end of this session, I guarantee you will have more time for your morning coffee!
400
DBA
This session will delve into how modern CPUs work, how batch mode leverages CPU caches and where the pressure points on the CPU are. As a teaser it will demonstrate how a larger column store can out perform a smaller one. It will use tools that go to a level below what those furnised by SQL Server server and Windows can provide, be that the debugger or windows performance analysis toolkit. CPU level stats will be used to explain the 'Science' behind the teaser problem in terms of clock cycles usage, last level cache usage. Finally, the session will take a look at the pressure points are on the CPU when running queries in batch mode. This is a genuine level 400 session and will not feature many demos. There is a two hour long version of this session which provides a more comprehensive overview of how SQL Server leverages memory and includes more demos. The full deck ( which may be subject to change prior to presentation ) can be found here: http://www.slideshare.net/chris1adkin/sql-sever-engine-batch-mode-and-cpu-architectures.
200
Dev
How do you deploy your SQL scripts across environments? If you run them individually or have no process this is just the session for you. Primarily aimed at developers but also useful for DBAs, this session will explain ways in which the SQLCMD utility can be used to improve the SQL script deployment process across environments. The type of script doesn't matter – table, stored procedure, function, DDL – you can package them all up and execute them with a single command.

If you are interested in learning more about the SQLCMD utility or just want some ideas on how your deployment process can be improved, this could the session you've been looking for.
200
BI
Did you know that Power View is not any longer limited to getting data from Tabular models ? Now that Power View users can connect to multidimensional BI Semantic Model (Cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models. The session will present - An understanding of the Multidimensional Model Objects in Power View - How to create a Shared Report Data Source Connection to a Multidimensional Model - How to create a Power View Report with a Multidimensional Model Data Source - An visual exploration of a Multidimensional Model by using Power View 
300
DBA
Have you ever been in a situation where suddenly all the records of a table have been deleted and everybody was playing Manuel, I know nothing?  A lot of DBA’s want to know who did what and when on their SQL Server. Since SQL Server 2008, Microsoft introduced a new feature SQL Audit. It allows you to audit your users on several actions on your databases and server. In this session you will learn the principles of SQL Server Audit and the different configurations along with practical examples. By the end of this session, you can easily tell who did what and when on your database.
400
DBA
This session covers how modern CPU architectures work and are laid out in terms of instruction pipelines, front and back ends, CPU caches, the root complex, how memory is fed into the CPU, NUMA, the relevance of using large pages and why it makes a difference. To whet the appetite of the attendee as to why this matters a simple scenario will be presented which defies conventional wisdom in which a fact to dimension table join with column store can outperform the same query using a smaller column small. The second part of the session will "Join up" modern CPU architectures and batch mode by covering off via demos the pressure points that batch mode places on the CPU, cache usage and CPU cycle usage. Column store technology is designed to be CPU aware, by this it achieves stunning performance gains over row mode for OLAP style queries and work loads by leveraging CPU caches and pre-fetching to the full, this session aims to provide a comprehensive level 400 insight into the hardware and database engine theory behind this. This session will be be pased in part on the material in this slide deck: http://www.slideshare.net/chris1adkin/sql-sever-engine-batch-mode-and-cpu-architectures.
200
Car
Let’s talk about your career. You’ve been a DBA for a week, a month, a year, or ten, but do you know all you need to about keeping up to date? Job hunting and recruiters? Are you an interview ace? We’ll talk about all of this, and much more. To answer your specific questions, we’ll wrap up with a question and answer session.

We've given this talk again and again, and attendees give the highest marks and ask the best questions, time after time. Come and hear the best career advice you've never heard.
200
Dev
Everyday more and more people are moving towards CI/CD development. Before users take the step to implementing CI/CD they're unsure of what tooling to use and which is the "best". This session is aimed as an introduction to MSBuild and how you can leverage the engine to build and deploy your source code. We'll look at the full Business Intelligence stack. 
300
DBA
Using one of the various tracing capabilities of SQL Server, is the best way to keep track of what is going on in your SQL Server to cause performance problems. But if you haven't set up any tracing, what can you do to find out what problematic queries might be running? In this session, we'll explore SQL Server's plan cache, from the way it is managed in memory, to the tools and techniques for discovering what plans are in cache, how long they've been there, how often they've been run, and whether they contain any suspected sub-optimal operators, such as table scans and hash joins. Knowing what's happened is the first step in knowing what needs to be fixed.
300
DBA
Microsoft document a lot on how to configure AlwaysOn, but most of this is focussed on standalone replicas, which to be frank are relatively simple to implement. What about those tier 1 solutions that want to also take advantage of SQL FCI as well as AG’s? Again this is fine if it is in one data centre. What about cross site?

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

400
Dev
Dr Manhattan has god like powers, he has the ability to control matter at a subatomic level, so why can't we? If you have heard you can modify the build and deployment actions for a database project, but you are not sure where to start, this session will be the one for you. Join me to take an in depth look into how you can customize the database build and deployment, and become your very own super hero. 
200
DBA
Database replication doesn't get much attention, especially now that the AlwaysOn features have been released into the wild. However, replication offers another way to make data available on multiple servers/locations that steps outside of "normal" HA/DR scenarios. This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication. The content will be valid for all versions of SQL Server from 2005 onward.
300
Dev
Microsoft has clearly positioned the Entity Framework 6 (EF) as the primary data access platform for .NET applications. But many developers have yet to embrace the powerful Object Relational Mapping (ORM) capabilities that EF offers. Whether you’re new to ORM, or you’ve dabbled in other ORM technologies, Lenni will show how quickly you can start working with EF6 and boost your productivity when building data-centric .NET applications. We’ll begin with a quick introduction to ORM and EF, and then explain many of the special ORM features in EF6, such as the Entity Data Model (EDM), and support for table splitting, inheritance, entity splitting, and many-to-many relationships. With the basics covered, Lenni will then dive right into live demos that show what EF can do for you as a data access layer, using database-first, model-first, and code-first approaches with both direct SQL and stored procedures. We’ll also discuss new features introduced in EF6, and show how to use EF in N-Tier scenarios.  
300
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.
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.
200
DBA
The IT world is currently in cost-saving mode - cutbacks are all over the place and then Microsoft pushes out SQL Server price hikes. In this session we will discuss how consolidating SQL Server can reduce overall costs and increase efficiency. We will cover the reasons for consolidation along with the advantages and the disadvantages of consolidating SQL Servers. We will also take a look at some of the tools that can assist with a consolidation project and some pitfalls that I have experienced on previous consolidation projects.
300
DBA
In this session, Mark will run through the tools that Microsoft use to track down performance issues with SQL Server. He will demonstrate how to use these freely available tools; SQLDiag, SQLNexus and ClearTrace to not only diagnose your SQL Server issues but make to look like a SQL god to your boss. 
500
DBA
The session focuses entirely on troubleshooting your SAN using free Windows and SQL Server tools - with a 100% focus on SQL Server.

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

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

The concepts are useful if you host SQL Server on any SAN - and despite being a 500 session, people of all levels of SAN expertise are welcome - BUT expect to be challenged in parts . . . come along, it'll be challenging fun!
200
Dev
Indexing represents one of the most important aspects of database operations. This session is broken into two parts:

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

  • Describe how SQL Server retrieves data.
  • Describe a heap.
  • Describe a clustered index.
  • Describe a non clustered index.
  • Describe a column store index
  • Describe how to traverse data by using indexes.
  • Describe other indexes.
The second hour -- the Power Hour itself -- is a lab to put into practise what you learned. Bring your laptop with the Adventure Works database for a unique session experience.
 
Ensure that the Adventure works 2012 Sample OLTP database is installed as found at the following url http://msftdbprodsamples.codeplex.com/downloads/get/165399
500
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
When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.

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

200
Dev
Are relational databases too restrictive for you?  Developers want to store data as they get it?  Need to store arrays and query as first class citizens instead of performing gymnastics? Yes?  then this session is for you.  It introduces Microsoft's Document database.  Come see what it is and how it could make your developers happy. 
200
BI
Azure Machine Learning is a fully managed cloud service for predictive analytics. 
300
Dev
You know Bookmark Lookups in SQL Server? You like their flexibility to retrieve
data? If yes, you have to know that you are dealing with the most dangerous
concept in SQL Server! Bookmark Lookups can lead to massive performance losses
that blows up your CPU and I/O resources! Join me in this session to get a
basic understanding of Bookmark Lookups, and how they are used by SQL Server.
After laying out the foundation we will talk in more details about the various
performance problems they can introduce. After attending this session you have
a better understanding of Bookmark Lookup and you are finally able to tell if a
specific Bookmark Lookup is a good or bad one. 
300
DBA
Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.

Attendees of this session will learn:
  • How to properly select the correct datatypes
  • How to identify poorly chosen datatypes
  • How to mitigate performance issues due to bad datatypes
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
DBA
SQL Server needs its locking mechanism to provide the isolation aspect of
transactions. As a side-affect your workload can run into deadlock situations -
headache for you as a DBA is guaranteed! In this session we will look into the
basics about locking & blocking in SQL Server. Based on that knowledge you
will learn about the various kinds of deadlocks that can occur in SQL Server,
how to troubleshooting them, and how you can resolve them by changing your queries,
your indexing strategy, and your database settings.    
200
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
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.    
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. 
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
BI
SharePoint – let’s admit it – is here to stay; It has become the business collaboration platform of choice for the enterprise and the binding element in the Office family of tools. However deploying and configuring can be a challenging task for the IT pro. In this session we will walk through the configuration of a complete on-premises BI platform with SharePoint. We will configure different scenarios, and the technologies necessary for building the infrastructure. After this session you will be able to setup the applications and all the supporting services to make SharePoint a successful and performant BI platform. From Excel services to Kerberos delegation. 
200
DBA
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
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.
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!
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
In this session, you’ll learn about SQL Server stored procedures (SPs): what they are, when and why you'd use them, and how you'd go about developing a solution with one.  We will address common SP myths and learn about planning for performance. Most of all, we’ll walk through examples to explore the process of solution building in SQL Server.
300
Dev
What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic?  How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency? In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
200
DBA
How long does a SQL Server failover cluster instance take to install? 3 hours, ½ day. It depends on alignments that need to be made to industry and your company best practise or policy. There are ways that we can all utilise unattended installs in a way that can significantly reduce this time. In the organisation I am currently working for, I have got a SQL Server failover cluster instance to install within 30 minutes including post install task to ensure that it conforms to the correct standards. All of this is a FREE solution that anyone can build and align with their organisation.  
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.
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
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
DBA
Have you considered consolidation? Should you consolidate on physical or virtualised hardware? Should you use VMWare or Hyper-V? What are the license implications? Should you consolidate the server, instance, or data? Do you need to save money within your SQL Estate? Would you like a more manageable solution for DBA’s?  How will this affect the business?
All of these questions will be addressed as part of a session which will present common questions asked by DBA’s, architects, CTO’s and CFO’s whom all have a say in how your database should be implemented and managed. 
300
DBA
With every SQL Server versions we have many performance related tools to tackle the performance related problems. What kind of tools can we use for various performance related issues? Is the commonly used SQL Server performance tools provide full support to our day to day performance issues?

There are many questions that needs an answer to help every DBA & Developers to stop scratching their heads. This session throws plates full of platter and you can decide what to choose for each different scenarios that you face in your work place.
300
DBA
Replication is a powerful feature that has long been available in SQL Server. However, with great power come great headaches! Replication normally runs happily once set up, but if things go wrong it can turn into a seemingly never ending list of errors. In this session I will dig into how replication can go wrong (and has gone wrong for me) and what steps you can take to fix these issues. Along the way I will go into what monitoring options you have when working with replication and also a couple of gotchas that have caught me out in the past.
400
Dev
Cast your mind back to November 2005, Madonna had just been knocked off the Number 1 spot by the Pussycat Dolls and SQL Server 2005 was released - writing Management Studio Add-ins was a total nightmare.

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

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

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

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

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