Sessions Title

These are the sessions submitted so far for SQLBits XIV.

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