Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 44
Your SSIS packages are taking longer than they should, but you are not sure what to do about it. Join this session to get 10 tips and tricks for gaining better performance. You’ll learn not only 10 reasons to why your packages are running slow, but also 10 ways to do something about it. Find out when to use T-SQL instead of SSIS transformations, why you should care about data types, what a blocking transformation is, why buffers are important, and much more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Just a slither

Level: Advanced

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

No! Access Services in SharePoint 2013 are really cool, if used in the right way and with clear expectations. This session will give you a detailed demo-driven look to the possibilities you have with Access Services, how you integrate it with SSRS, how you can use it as RAD toolset or as an simple but effective MDS approach. A comparison to the version in SharePoint 2010, deployment and change management tips and tricks will round up the session.
Speaker:

Session Type:
Regular Session

Track:
...and now for something completely different

Level: Beginner

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

As a report creator and designer, it's your role to make the message of the data come alive for data consumers and decision-makers. This requires a balance between conveying the 'truth' of the data across to the target audience, in addition to making the report look interesting that it will draw people's attentions in the first place.

SSRS is one of the most widely-used Business Intelligence products within the Microsoft stack. Come to this session to pick up some tips and tricks for advanced reporting writing, that is also  in accordance with thinking by Data Visualisation gurus such as Stephen Few and Edward Tufte.
This session will cover more advanced and less well-known features of reporting services with Data Viz in mind!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SPAM (BI)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!
Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
The Meaning of Life (DBA)

Level: Advanced

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you struggling with performance issues and your current tools are not providing answers? Confio’s flagship product, Ignite, may be your answer. This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. Neil will use real-life case studies to demonstrate the techniques. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Ministry of funny walks (DEV)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Being able to accomodate the most demanding requirements on security is more important now than ever. This session will take you through a variety of approaches on how to implement basic to complex security on dimensions in SSAS. A quick intro through the GUI will bring us to XMLA and AMO as the weapon of choice. Different concepts on hierarchy security models will also be demonstrated.
Speaker:

Session Type:
Regular Session

Track:
SPAM (BI)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

“In this speed-through session, Emma will give a bird’s eye-view of database deployment best practices, covering where – and how - automation fits into your workflow. We’ll look at how to combine your database and application code changes for maximum effect, what kind of processes to put in place, and some of the tools – like Deployment Manager – that will get you there.”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
The Meaning of Life (DBA)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server makes it simple to automate backups with jobs and maintenance, but doesn't provide a simple method to schedule test restores to prove the backups have worked. Using PowerShell we can write simple scripts that allow us to automate test restores from our SQL backups, and then check that the restored database is valid, consistent and usable. 

This session will introduce you to the basics of restoring simple databases with PowerShell scripts, and then extending this to cope with more complex situations including data file relocation, point in time restores and running DBCC checks against the restored database
Speaker:

Session Type:
Regular Session

Track:
The Meaning of Life (DBA)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

We look at how you can role your own indexing strategies to complement SQL Server's B+Tree; this session will refresh you on how SQL Server Indexes work, bitwise operations. We will then look at how Bloom Filters and Bitmap Indexing can be used to dramatically improve the performance of certain query patterns within SQL Server. Session is based partly on the blog series on Bloom Filters: http://tinyurl.com/bloomfilter
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
The Meaning of Life (DBA)

Level: Advanced

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation will provide the audience with an overview of the options available to them across the BI toolkit proivided by SharePoint 2013 and Office 2013.  We will break these options down into Personal, Team and Corporate BI and look at the pros and cons of each.  Specifically we will look at PowerView, PowerPivot, Excel Services and PerformancePoint covering a good mix of slides and demonstrations. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dead Parrot (SharePoint)

Level: Beginner

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

We've all been there, utilising Virtualisation packages on our previous Windows installations on our desktops or laptops to test new things, in this practical session I'll introduce you to the version of Hyper-V that comes with Windows 8 Professional, and show you how to utilise it to test various SQL Server 2012 scenarios on your machine and some useful tips.
Speaker:

Session Type:
Regular Session

Track:
...and now for something completely different

Level: Beginner

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever needed a data type that SQL Server simply does not support? So why not add it?
Ever since SQL Server 2005, you can easily create additional data types for use in SQL Server. Using .NET integration, you can define a data type and program all the methods you need to make it behave exactly the way you want it to - both in the database and in your .NET application programs.
This session will show you exactly how to create a CLR user-defined data type, and how to integrate it in your database. Will you be the one who creates the next Big Thing, the data type that puts Spatial and Hierarchyid to shame?
Speaker:

Session Type:
Regular Session

Track:
Ministry of funny walks (DEV)

Level: Advanced

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever had marketing send out that email saying that they are re-branding the company with new colours and fonts, normally not a problem until they mention that the 300+ SSRS reports need to be changed too...

This session will show you how to make use of SSRS project templates, and built in data sets, variable, expressions and a bit of modification to the SSRS database to help make these sorts of requests a simple matter of updating some values in a database. As opposed to pulling the reports out of source control before modifying them and trying to get a deployment scheduled.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Ministry of funny walks (DEV)

Level: Beginner

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and Windows Azure SQL Database. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the new generation of database tools for developers!
Speaker:

Session Type:
Regular Session

Track:
Ministry of funny walks (DEV)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

The DataExplorer plugin for Excel( which is currently in preview) is targeting Excel users and Business Analysts by providing them a homegrown ETL process without any additional Servers. Powered by the flexibility of the "M" language, DataExplorer is capable reaching out for such diverse sources as OData, File System, HDInsight or Facebook, for example. 
Besides providing an accessible interface for the non-IT people, the real potential behind DataExplorer lies in creating customizable functions and processes far beyond any GUI.
Join me for an hour of "DataExploration"! :)
Speaker:

Session Type:
Regular Session

Track:
SPAM (BI)

Level: Beginner

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Is DQS here to stay or is it the emperor's new clothes ? in this session we will a look at how DQS can empower data cleansing in the enterprise , how we can use it in SSIS and some advanced techniques to solved complex data cleansing problems that'll make you a cleansing and matching hero with concepts such as Term Based Relationships, Domain/Composite Domain Rules, and using Remote Data Services in Windows Azure marketplace. We will also demonstrate how to enhance your DQS KB as you cleanse, enabling a cycle of data quality improvement. If you’ve looked at DQS but aren’t sure how to get the most out of it for your data, come to this session to see how to move beyond the basics
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Just a slither

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Big Data is not so much about storing massive amounts of data in a common database. It is also a force of change for the organisation, and it means that we have to consider the collective capabilities of the platform to serve the business: from data source to secret sauce that will help the business to make data-driven decisions to drive the enterprise forward, using familiar tools such as the new Microsoft Power BI tools
 
In this session, we will look at RHadoop, which is a match made in heaven for data scientists. It is a combination of R, the world's favourite free data analysis tool, and Hadoop. In this session, we will look at an example of using RHadoop to analyse Big Data, from data to result.
 
We will also look at evangelising your secret sauce throughout the business, using Microsoft’s new Power BI tools in Office 365: Power View, Power Map and Power Query. Come and see how to make Big Data accessible, relevant and perhaps even fun!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
...and now for something completely different

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?

Are your SAN guys telling you your storage can process 2 GB/s but you're only seeing 200 MB/s?

This session will dive into how to optimise your File and Filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customer's table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include:
- Layout for OLTP
- Data Warehousing Fast Track Style
- Data Warehousing on a SAN
- Get data into your SSAS cubes faster (ProcessData)
- Hidden options and “go faster” buttons 
- How to maximise performance in enterprise edition and master read ahead
Speaker:

Session Type:
Regular Session

Track:
The Meaning of Life (DBA)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft have released a distribution of Hadoop targeted at making big data accessible to everyone.  Hadoop is different to SQL Server.  Not necessarily better, just different.  It is a tool for a job.  if you have only ever worked with an RDBMS such as SQL Server then Hadoop is going to play with your mind a little and you are going to need to rethink a few things.
This session is going to take Hadoop and break it apart.  I will also look at some of the tooling Hive and Pig.
Keep an open mind and let me show you that Hadoop has lots to offer.
Speaker:

Session Type:
Regular Session

Track:
SPAM (BI)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Join SIOS to learn how to eliminate the IO bottlenecks, costs and failure points with traditional SAN-based clustering.   By leveraging the performance of high-speed storage such as that offered by Fusion- io, and by adopting a SANless architecture to achieve higher levels of availability with SIOS – this ‘blueprint’ gives you the best of both worlds – cost effective performance and protection. Join us and you could win a £75 gift card.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SPAM (BI)

Level: Intermedia

Session Code:

Date: September 28

Time: 12:00 AM - 1:00 AM

Room: TBD

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