Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type


Sessions Found: 35
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? 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.
Speaker:

Session Type:
Regular Session

Track:
Data Practices

Level: Intermedia

Session Code:

Date: July 25

Time: 1:30 PM - 2:30 PM

Room: Dean Room

As an ETL developer using SQL Server Integration Services have you ever wondered how to:
1.	Import all .csv files from a folder
2.	Replace dynamic SQL using variables in SSIS
3.	How to configure the data flow buffer
4.	Create custom logging solutions
5.	Use a script component as a data flow transformation
This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer.  We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague  properties.  
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components.
Upon completion of this workshop attendees will be able to:
1.	Import/export multiple sources/destinations
2.	Use an execute SQL task with variables to replace dynamic SQL within a package
3.	Dynamically handle errors within any part of a package
4.	
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: July 25

Time: 1:30 PM - 2:30 PM

Room: John Torcher

Agile methodologies are widely used in the dev world and are becoming increasingly adopted in the database world. But what about BI? 
Covering the technology and process sides of enabling agile BI, this session is designed to give you practical tips to get things moving more quickly for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Data Practices

Level: Beginner

Session Code:

Date: July 25

Time: 11:05 AM - 12:05 PM

Room: Woods Room

Database testing can be challenging, for a number of reasons that will be touched on in this session. 

We will discuss the motivations for unit testing, as well as some of the particular challenges involved in testing database code and integrating this testing into the software development process.

Over the years, a number of tools and approaches have been developed to address these difficulties, and we will draw comparisons between some of these in order to highlight the questions you need to consider in choosing a testing approach for your own projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Data Practices

Level: Intermedia

Session Code:

Date: July 25

Time: 9:45 AM - 10:45 AM

Room: Woods Room

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.

MDX can seem a very daunting language, but when it's broken down into the basics it's easier than you think.

We'll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session!

We'll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or a (), and we'll look at some of the awesome power that MDX can provide to our reporting.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: July 25

Time: 4:00 PM - 5:00 PM

Room: Woods Room

Come round to talk about Application Lifecycle Management (ALM) and deployment/delivery of Business Intelligence (BI) Applications! You will learn how Team Foundation Server (TFS) and Release Manager or Octopus Deploy will help you in in that feat. I will share my view of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit and Octopus Deploy, with specific examples for every MS BI project type. The presentation will also compare features of Release Manager and Octopus Deploy for your deployment needs will show a demo of continuous deployment for a typical BI project using Octopus Deploy. The material does not assume prior knowledge of TFS administration, but some experience using Visual Studio database projects and general TFS terminology will be helpful.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: July 25

Time: 9:45 AM - 10:45 AM

Room: Dean Room

Register @ http://manchesterpass.ddns.net/Speaker1.html

Need to work with big data? Attend this session to learn how to use Microsoft Azure HDInsight to process big data and to generate results for analysis and reporting. The session will explain how to provision and manage Azure HDInsight, how to use Hadoop technologies like Pig, Hive, Oozie, Sqoop, HBase, and Storm to process data, and how to consume and visualize the results.
Speaker:

Session Type:
Precon (500 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: July 24

Time: 9:00 AM - 5:20 PM

Room: Woods Room

Want to get your systems to the cloud, not entirely sure how to go about it? Let me guide you through the design considerations and process for building a Highly Available and resilient SQL Server infrastructure, looking at entirely cloud based and hybrid options. By the end of this session we will not only have discussed, but actually built and deployed a HA/DR SQL infrastructure and website that accesses it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure

Level: Intermedia

Session Code:

Date: July 25

Time: 11:05 AM - 12:05 PM

Room: Dean Room

With Microsoft’s acquisition of DataZen,  dashboard and mobile BI is now easier than ever.   Come along and see how to get started with DatZen.

We will be showing an end to end demo of creating and publishing dashboards for mobile and tablet devices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: July 25

Time: 9:45 AM - 10:45 AM

Room: John Torcher

Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports.
In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimize it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: July 25

Time: 11:05 AM - 12:05 PM

Room: John Torcher

Today’s Business Intelligence systems are increasingly perceived as mission critical, but their value is only as good as the quality of data they contain. How can you improve BI value by ensuring data quality through Microsoft SQL Server Master Data Services, accelerated by Profisee’s Master Data Maestro.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Sponsor

Level: Beginner

Session Code:

Date: July 25

Time: 12:40 PM - 1:40 PM

Room: PeterLoo

If you want to take the first step in improving your database development process with DLM, this is the workshop for you.

You’ll learn how to:

1.Source control your database – the first step in any DLM process
2.Deploy your databases from source control
3.Monitor and track database changes across development, testing, and production environments

Are you ready for this workshop?

To get the most out of this workshop, you should be:

•Performing database development
•Looking to improve your processes
•Working with:
?SQL Server 2005+
?SQL Server Management Studio (SSMS)
?T-SQL
Speaker:

Accompanying Materials:

No material found.

Session Type:
Precon (500 minutes)

Track:
Data Practices

Level: Beginner

Session Code:

Date: July 24

Time: 9:00 AM - 5:20 PM

Room: PeterLoo

Extended Events is the profiler tool replacement, it is the premium tool for capturing diagnostic information for SQL Server, with advanced capabilities unlike we've had available before, using new features can take time to learn

This session is focused to make you Effective with Extended Events, find out how to be up and running with using EE in just minutes not hours or days, join us to take a look what EE can do and discover what's happening inside your SQL Servers in ways no possible before
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: July 25

Time: 4:00 PM - 5:00 PM

Room: PeterLoo

For those who already have a basic understanding of Hekaton this session takes a deeper look; the session focus will be: Row Chains and MVCC, Hash and Range index internals and when and how to use. We will cover how to diagnose and deal with issues (through DMV’s and Perfmon). Hekaton basics are assumed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: July 25

Time: 11:05 AM - 12:05 PM

Room: PeterLoo

Join us for a lightning tour of Microsoft’s Azure HDInsight service for Big Data. Based on open-source Hadoop technologies, HDInsight provides the tools you need to process and analyze large volumes of diverse data; and in this session you’ll find out how to provision an HDInsight cluster and get started with a veritable alphabet soup of Hadoop technologies such as Hive, Pig, Sqoop, Oozie, HBase, Storm, and Mahout.
Speaker:

Session Type:
Precon (500 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: July 25

Time: 11:05 AM - 7:25 PM

Room: Mary Quaille

The Microsoft Data Platform used to be Microsoft SQL Server, now we have a variety of different options spanning on-premises and cloud. With this increasing array of options the role of the DBA is changing, understanding how these technologies compliment each other and what they are will become more important for the DBA as the roles change. 

In this session we will look at Microsoft SQL Server, Azure SQL DB, DocumentDB and Azure Table Storage, all of which can be used to provide a highly effective data platform on which to build applications. I will help you understand what each of the offerings is, how it differs from the others and demonstrate some examples of when you might want to use one over another. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure

Level: Intermedia

Session Code:

Date: July 25

Time: 2:45 PM - 3:45 PM

Room: Dean Room

This session looks at how to implement, maintain and evolve solutions developed on Azure SQL Database, through the use of the tools like SQL Sever Management Studio and Visual Studio. Through examples and case studies, will be presented the versatility, power and reliability of the database as a service in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure

Level: Intermedia

Session Code:

Date: July 25

Time: 4:00 PM - 5:00 PM

Room: Mary Quaille

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 (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated.
SEE, what a workload will be caused by a "forwarded record". What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes 
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: July 25

Time: 2:45 PM - 3:45 PM

Room: PeterLoo

Microsoft recently launched a new service into Azure; SQL Data Warehouse. SQL Data Warehouse is a scale out, distributed database that can scale its compute resources on demand.  Come to this session and learn all about it from the co-author of the official documentation<https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-develop/>!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure

Level: Beginner

Session Code:

Date: July 25

Time: 2:45 PM - 3:45 PM

Room: Mary Quaille

We will be taking you through how to setup replication, what types of options are available to you (snapshot,merge,transaction,peer to peer), how to implement them, an explanation of the various SQL Agent Jobs and Replication binaries involved and what the limitations are. This session will provide you with almost everything you need to know to get started with replication or give you a valuable refresher to the topic if you haven't done it in a while. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: July 25

Time: 1:30 PM - 2:30 PM

Room: Woods Room

Sessions Found: 35
Back to Top cage-aids
cage-aids
cage-aids
cage-aids