Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type



Sessions Found: 57
[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]
Make sure you spend the whole day learning about the most important technology Microsoft has launched since the beginning of SQL Server – Columnstore Indexes. We will investigate how you can optimise your BI & DataWarehousing solutions and take the advantage of the modern Columnstore Architecture significantly boosting your query performance and analytics reporting.

Learn how to get the very best out of your existing database environments and how you can monitor, optimise, implement and solve many Columnstore Indexing problems.

Discover how to take the full advantage of the Batch Processing mode for Columnstore Indexes, which can significantly accelerate your query processing by hundreds of times, and learn about its limits.

Through the use of Dynamic Management Views, Extended Events and Traceflags we shall analyse traditional Rowstore tables and turn them into highly
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-conference Session (480 minutes)

Track:
BI (Wish You Were Here)

Level: Intermedia

Session Code:

Date: September 10

Time: 9:00 AM - 5:00 PM

Room: Wizball room

The traditional data warehouse has been the key of our business analytics architecture for many years. In a world ruled by the data culture concept, new challenges are emerging: data growth; unstructured data; hidden patterns and cloud-born data.
Which is the best architecture in order to get over these new challenges? 
Join this session and learn how to enable the Modern Data Warehouse in your organization using Cubes, HDInsight, AzureML, Stream Analytics and DocumentDB. All through a continuous example using a retail shop scenario.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI (Wish You Were Here)

Level: Intermedia

Session Code:

Date: September 12

Time: 2:45 PM - 3:45 PM

Room: Boulderdash room

Want to start a new business? You have the great idea, but what about creating a business plan, web site, invoicing, CRM, social media and all the other infrastructure you need to operate that great startup. Come and spend an hour with me and see how we did it with our new company Effektor.  Ask all the questions you have. I might even be able to answer them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other (A Momentary Lapse of Reason)

Level: Beginner

Session Code:

Date: September 12

Time: 8:30 AM - 9:30 AM

Room: Paradroid room

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]
Many people are forced to use Microsoft® SharePoint® because it is already there or part of the Office 365™ ecosystem; therefore many users see it just as another task to add to their burgeoning  workload of tasks they have to complete in their busy working day. When any technology is introduced into a business it should help not hinder users. It should enable users to do more, not less. Technology should meet business needs and not be focused around a single product.

With this in mind, Penny will look at automating business processes using out-of-the-box functionality of SharePoint and with the use of Azure™ Logic Apps outside SharePoint, beyond firewalls and beyond even your own datacentre. You can create these workflows using no-code visual designers.

SharePoint topics that will be cover
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-conference Session (480 minutes)

Track:
SharePoint (Dark Side of the Moon)

Level: Intermedia

Session Code:

Date: September 10

Time: 9:00 AM - 5:00 PM

Room: Pyjamarama room

AlwaysOn Availability Groups provide an excellent way to build a High Availability platform with SQL Server at its core, however with these new capabilities come new and interesting maintenance requirements. In this session we will look at a number of the things you must do when making use of Availability Groups, and some of the things that you can do in order to ensure that you have a stable, reliable platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA (The Wall)

Level: Intermedia

Session Code:

Date: September 12

Time: 8:30 AM - 9:30 AM

Room: Manic Miner room

By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask.
Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts
 This session will show you how :
• Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account.
• Create a storage account and container for the HDInsight Cluster.
• Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly.
• The HDInsight cluster is provisioned and configured for access to the sample data.
• A partitioned Hive table is created over top of the sample data 
• Exploration of the result
• And how to automate these task either in Powershell or SSIS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Piper at the Gates of Dawn)

Level: Intermedia

Session Code:

Date: September 12

Time: 10:00 AM - 11:00 AM

Room: Boulderdash room

For a long time people have been asking where is SSIS for the cloud.  Truth is it was never going to happen.  Azure Data Factory has been designed from the ground up.  It is designed for moving data at scale and with agility.  Come to this session to learn about this new service and how it come provide value to your business processes
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BA (The Division Bell)

Level: Beginner

Session Code:

Date: September 12

Time: 1:30 PM - 2:30 PM

Room: Elite room

Predictive analytics is touching more and more lives every day. Machine Learning lets you predict and change the future. Do you know that Microsoft products like Xbox and Bing integrate some machine learning capabilities in their workflows? Come to the session and take a look of the new cloud-based machine learning platform called AzureML from a BI architect perspective, without all the data scientist knowledge.
Real machine learning solutions and some best practices when integrating ML on Apps and websites.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BA (The Division Bell)

Level: Intermedia

Session Code:

Date: September 12

Time: 11:15 AM - 12:15 PM

Room: Elite room

Data mining on-premises has a long tradition with Microsoft SQL Server and Machine learning in Azure is the cloud based brother, both supporting a hand-full of great algorithms for  your business to grow.
This session will be focused on benefits of building a predictive model using Azure Machine Learning (ML) studio and exploring its capabilities. We will cover from 1) Quick introduction to ML to 2) creating ML workspace with data upload, 3) training the data-set and evaluating the solutions/models and 4) using this solutions with ML API Service.  With a great support to R language in Azure ML, we will also explore the usage of R script in Azure ML. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BA (The Division Bell)

Level: Intermedia

Session Code:

Date: September 12

Time: 2:45 PM - 3:45 PM

Room: Elite room

In this session we'll be integrating a variety of geospatial data sources to provide a scalable website using a Windows Azure SQL Database and it's built in Geospatial features such as nearest neighbour. Then we'll take this a step further and introduce another live data stream, finally rendering it all using Bing Maps to an Azure Website. The presentation is targeted at individuals wanting a quick overview of the rapidly evolving Azure Service offerings for today’s cloud ready business. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud (Piper at the Gates of Dawn)

Level: Beginner

Session Code:

Date: September 12

Time: 4:00 PM - 5:00 PM

Room: Manic Miner room

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 the protection of data by using schemata for data protection and implementation of business logic for multiple applications. I will demonstrate the usage of schemata in an application life cycle to reuse codes for reporting in the same way as for the web application or the fat client application.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV (Animals)

Level: Intermedia

Session Code:

Date: September 12

Time: 11:15 AM - 12:15 PM

Room: Boulderdash room

[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ]
In this hands-on / bring your own laptop pre-con, Rasmus will show how you can take your ETL to the next level. You will go from “Zero to BIML to BIMLScript” in the duration of the day. That means, that leaving the pre-con, you will never ever again have to go over hundreds of packages to change a datatype or add a column, all you’ll need to do, is to change your meta-data and you are home free.

As our meta-data repository, we will use SQL Servers built-in Master Data Services. You will be given a thorough introduction to this component and learn how to use and administer it.
Besides getting a working knowledge of BIML AND MDS, and become able to use that in your ETL development, you will also get an overview of, and get to work with, the following advanced ETL concepts:

Early arriving facts
Slowly Changing Dimensions (SCD) with script task
Least interdependent structu
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-conference Session (480 minutes)

Track:
BI (Wish You Were Here)

Level: Intermedia

Session Code:

Date: September 11

Time: 9:00 AM - 5:00 PM

Room: Jet Set Willy 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 (60 minutes)

Track:
Cloud (Piper at the Gates of Dawn)

Level: Intermedia

Session Code:

Date: September 12

Time: 2:45 PM - 3:45 PM

Room: Sabre Wulf room

When you're starting out on your first Analysis Services Multidimensional cube project it's very easy to make design mistakes that can cause problems for you later on. In this session you'll learn about the mostly frequently made Analysis Services design mistakes, what the consequences of making them are, and how to fix them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI (Wish You Were Here)

Level: Beginner

Session Code:

Date: September 12

Time: 10:00 AM - 11:00 AM

Room: Elite room

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation.  John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects.  In particular, the session will cover: 
* Automating your build and deployments with SQL Server Data Tools
* Harnessing the power of BIML
* Automated Integration and Regression testing of your Data Warehouse
* Deploying and on-going management of OLAP databases using the OlapPartitionManager
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV (Animals)

Level: Intermedia

Session Code:

Date: September 12

Time: 11:15 AM - 12:15 PM

Room: Paradroid room

In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table.  Unfortunately this case is the exception rather than the rule.  How can you use SSIS to: 
1.    Iterate through all files in a folder and import their content into SQL
2.    Dynamically create and name table based on a data source 
3.    Dynamically create a T-SQL statement at runtime based on run time conditions
This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment.
Each attendee will leave with the knowledge and toolset necessary to:
1.      Use expressions within SSIS packages
2.      Use variables to dynamically create SQL statements
3.      Configure custom dynamic logging
4.      Use package configurations and parameters and environments to make packages more portable at execution
5. 	Replace dynamic SQL using expressions in SSIS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI (Wish You Were Here)

Level: Intermedia

Session Code:

Date: September 12

Time: 1:30 PM - 2:30 PM

Room: Chuckie Egg room

Recently, in April 2015, Microsoft aquired the company Datazen a specialist for mobile BI. This aquisition enables Microsoft to offer mobile, self service BI tools for Windows, iOS, Andorid and HTML. Besides using BI solutions on mobile devices online it is also possible to use these BI solutions offline. SQL Server MVP Frank Geisler will give insights into how Datazen works and how you can build BI Dashboards on different Datasources. He will show how a Datazen Server is installed and configured and how the Datazen Apps work on Windows 8. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI (Wish You Were Here)

Level: Beginner

Session Code:

Date: September 12

Time: 1:30 PM - 2:30 PM

Room: Manic Miner room

Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail. 

You will learn:
•To identify the different error handling methods in control flow, data flow, and script tasks 
•Be able to utilize event handlers to proactively handle errors 
•Be able to redirect data error and proactively handle data flow errors 
•Be able to identify error descriptions and log error details
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI (Wish You Were Here)

Level: Intermedia

Session Code:

Date: September 12

Time: 11:15 AM - 12:15 PM

Room: Sabre Wulf room

The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? In this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader() and SqlCommand.ExecuteNonQuery().
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV (Animals)

Level: Intermedia

Session Code:

Date: September 12

Time: 1:30 PM - 2:30 PM

Room: Sabre Wulf room

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV (Animals)

Level: Advanced

Session Code:

Date: September 12

Time: 4:00 PM - 5:00 PM

Room: Elite room

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