|
09:00 |
Registration Opens |
|
09:30 |
Keynote
Anthony Saxby
Microsoft UK, SQL Server Product Manager |
|
10:00 |
Windows Server 2012
Wayne Meyer
Microsoft UK, Windows Server Lead
http://www.microsoftvirtualacademy.com
http://aka.ms/mvprocks
http://aka.ms/mvprocks
http://www.microsoft.com/windowsserver
Windows Server powers many of the worlds' largest datacenters, enables small
businesses around the world, and delivers value to organizations of all sizes in
between. Windows Server 2012 redefines the server category, delivering hundreds
of new features and enhancements spanning virtualization, networking, storage,
user experience, cloud computing, automation, and more. Simply put, Windows
Server 2012 helps you transform your IT operations to reduce costs and deliver a
whole new level of business value.
|
|
11:00 |
Break |
|
11:20 |
Frightening new world of Data
Tony Rogerson, SQL Server MVP
SolidQ Mentor
A light look at how we got to and what is Big Data, what it means to you and your job role and your future. |
|
11:50 |
Nimble Storage |
|
12:05 |
Confio |
|
12:20 |
Lunch |
|
|
Stream 1 - DW/BI/Analytics/BigData |
|
Stream 2 - Engine/Programability/DBA |
|
13:10 |
Eric Lawson
Star Schema Database Primer
A session covering the the core principles of the star schema database model, as
required for decision support solutions and as the bedrock for Analysis Services
cubes and the new Tabular model.
In this session we cover:
• technical comparison of databases
• features of the star schema database
• where do you get one
• how do you best exploit it
• next steps
|
|
Mark Broadbent
SQL Server 2012 AlwaysOn for Dummies
Welcome to Microsoft's world of the buzzword. Yes, they've done it again and created another ambiguous term that no one really understands. AlwaysOn is a powerful group of highly available technologies, and in this presentation, we will delve into their murky world and reveal the technology behind the buzz.
Focusing specifically on the two key components of SQL Server 2012 AlwaysOn in Failover Clustered Instances and Availability Groups, we will investigate their pre-requisites, setup, administration, use and drawbacks.
After this presentation you will have a good understanding of:
• Using Windows 2008, 2012 and Server Core
• Windows Clustering
• Quorum
• Failover Clustered Instances
• Availability Groups
• Readable Secondaries
• Clustering Tools and PowerShell
Dummies and higher are welcome! |
|
14:10 |
Break |
|
14:25 |
Jen Stirrup
Mobile Business Intelligence for Everyone, now!
Microsoft has made serious commitments to mobile Business Intelligence, as
announced at PASS Summit 2011. What's the roadmap? What's available right now?
And how can you implement it at your organization? Become your company's mobile
BI expert - attend this demo-rich session to discover a number of novel ways to
implement mobile BI from the technical perspective. You'll have the opportunity
to see mobile BI in action so you can maximize your learning experience with
this technology. And we'll look at a variety of ways to deploy mobile BI using
Microsoft technologies such as SharePoint, SQL Server Reporting Services, SQL
Azure, Excel Services, and PowerPivot. After this session, you'll be ready to
unleash mobile BI in your organization. |
|
Dave Ballantyne
Whats new in SQL Server 2012 - TSQL
With the release of SQL Server 2012, the T-SQL language has been extended
further to enable greater productivity and more optimal queries. Following the
ANSI SQL standard support has been included for PAGING and SEQUENCES. Many
cumbersome sub-queries will be banished by the clutch of new analytic functions,
but perhaps the biggest is the window framing extensions. These now allow a true
sliding window of data to process such common problems as rolling balances. This
will be a high-level look session, but will be diving a bit deeper to highlight
some caveats as we go as its not all plain sailing. |
|
15:25 |
Break |
|
15:40 |
Gavin Payne
Accelerating the data warehouse with columnstore indexes
xVelocity columnstore indexes, new in SQL Server 2012, were not just designed to make data warehouses run slightly faster, but massively faster. To make this possible, a completely new approach to index storage and utilisation has been implemented by Microsoft in the SQL Server engine; something that must now also be implemented by data warehouse developers and DBAs. With a balance of guidance and demos, this session will look at the benefits and restrictions of columnstore indexes, how they are implemented within SQL Server, and how you can use them. |
|
Francesco Quaratino
Partitioning to Manage big Log Tables
In a typical OLTP scenario, as tables become bigger, their maintenance becomes
more difficult to achieve and queries performances get worse. Therefore, the
database server needs to scale up or out, adding more resources or more nodes.
In order to avoid that, many companies are getting used to keeping tables as
small as possible by moving periodically old data to a different database server
where it's kept for a while before being either archived to cheaper disks or
cleaned up definitively. This presentation will look into the options that DBAs
have for managing the archiving process, and it will show how SQL Server 2012
Table Partitioning improvements can help DBAs in that achievement.
|
|
16:40 |
Finish - Networking |
|
|
|