Nr: 418
SQLSaturday #418 - Manchester 2015
SessionID: 38678
Machine Learning without a PhD in statistics
Event Date: 25-07-2015 - Session time: 09:00:00 - Track: Azure
Speaker: Andrew Fryer
Title: Machine Learning without a PhD in statistics
Abstract:
Traditional BI has been all about creating consistent data sets fronted with easy to use tools to allow our users to explore data and make decisions. While this still has its place it doesn't cover predictions well nor does it deliver any actionable insight. That gap is starting to be filled by machine learning and while this has been expensive and complex to implement, Azure Machine Learning takes away a lot of this and at low risk. So if you are curious, you know the data you work with and the business you are in let us enlighten you about how this might really transform your business with only the most basic knowledge of statistics!
SessionID: 38679
Session Details not available
Event Date: 25-07-2015 - Session time: 09:00:00 - Track: Business Intelligence
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 38694
Building Big Data Solutions with Microsoft Azure HDInsight
Event Date: 25-07-2015 - Session time: 09:00:00 - Track: Azure
Speaker: Graeme Malcolm
Title: Building Big Data Solutions with Microsoft Azure HDInsight
Abstract:
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.
SessionID: 38695
Practical R: A hands-on training day
Event Date: 25-07-2015 - Session time: 09:00:00 - Track: Business Analytics
Speaker: Stephanie Locke
Title: Practical R: A hands-on training day
Abstract:
Bring your own laptop!
R is a powerful language to add to the BI, analytics and data science technologies you may already be using. This one day training session circumvents the painful experience of on-boarding a new technology and will give you the foundation needed to use R effectively via a series of focussed modules complete with hands-on labs.
Topics covered will include effective R coding, development best-practices, using R as a reporting tool, and how to build and administer a solid platform for analysis. •Effective R will take you from "0 to Hero" and with no prior knowledge required, we'll get R installed and get you wrangling and visualising data in no time.
•DevelopeR Skills teaches you how to build robust, scalable, and version controlled code.
•R is for Reporting takes you through the "reproducible research" and reporting functionality so you can deliver cost free awesome reports to your business
SessionID: 38699
SQL Server 2014 In-memory technologies - Columnstore, In-Memory O
Event Date: 25-07-2015 - Session time: 09:00:00 - Track: DBA
Speaker: Tony Rogerson
Title: SQL Server 2014 In-memory technologies - Columnstore, In-Memory O
Abstract:
Assuming no prior knowledge of In-memory technologies we first introduce concepts, what do we mean by in-memory, what features exist in SQL Server 2012 and SQL Server 2014. We then drill into each feature giving you a working knowledge that can be applied into your own environments, the day will be example led.
Introduction to in-memory technologies and features baked into SQL Server 2012 and 2014
OLAP - Columnstore •Nonclustered
•Clustered
•Design considerations, how it works and troubleshooting/monitoring
OLTP - In-memory OLAP •Tables
•Natively compiled stored procedures
•Design considerations, how it works and troubleshooting/monitoring
SessionID: 39035
Database source control workshop
Event Date: 25-07-2015 - Session time: 09:00:00 - Track: Data Practices
Speaker: Alex Yates
Title: Database source control workshop
Abstract:
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
SessionID: 36456
Event Date: 25-07-2015 - Session time: 09:45:00 - Track: DBA
Speaker: Satya Jayanty
Abstract:
Why Upgrade?
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.
In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 SQL Server 2012 (with a good overview on 2014 too) by using best practices and available resources.
A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday SQLbits UK.
We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.
SessionID: 36713
Approaches to database Unit Testing
Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Data Practices
Speaker: Gavin Campbell
Title: Approaches to database Unit Testing
Abstract:
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.
SessionID: 37021
Creating Mobile Dashboards with DataZen
Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Business Intelligence
Speaker: Bob Duffy
Title: Creating Mobile Dashboards with DataZen
Abstract:
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.
SessionID: 37201
BI Application Lifecycle Management with TFS and Octopus Deploy
Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Business Intelligence
Speaker: Dmytro Andriychenko
Title: BI Application Lifecycle Management with TFS and Octopus Deploy
Abstract:
SessionID: 38677
Session Details not available
Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Azure
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 17297
Building your first Microsoft Azure IaaS infrastructure
Event Date: 25-07-2015 - Session time: 11:05:00 - Track: Azure
Speaker: John Martin
Title: Building your first Microsoft Azure IaaS infrastructure
Abstract:
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.
SessionID: 25280
Agile BI
Event Date: 25-07-2015 - Session time: 11:05:00 - Track: Data Practices
Speaker: Stephanie Locke
Title: Agile BI
Abstract:
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.
SessionID: 36672
Data modeling for data analysis and cubes
Event Date: 25-07-2015 - Session time: 11:05:00 - Track: Business Intelligence
Speaker: Alex Whittles
Title: Data modeling for data analysis and cubes
Abstract:
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.
SessionID: 38203
Everything’s bigger these days – even data!
Event Date: 25-07-2015 - Session time: 11:05:00 - Track: Azure
Speaker: Graeme Malcolm
Title: Everything’s bigger these days – even data!
Abstract:
SessionID: 38698
Deep Dive into In-Memory OLTP (Hekaton)
Event Date: 25-07-2015 - Session time: 11:05:00 - Track: DBA
Speaker: Tony Rogerson
Title: Deep Dive into In-Memory OLTP (Hekaton)
Abstract:
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.
SessionID: 37231
The first step towards continuous integration for SQL Server
Event Date: 25-07-2015 - Session time: 12:40:00 - Track: Sponsor
Speaker: Alex Yates
Title: The first step towards continuous integration for SQL Server
Abstract:
Continuous integration (CI) is a development practice that has become widely adopted for the application layer because it allows teams to detect problems quickly and locate errors more easily. By regularly integrating code into a shared repository and automatically verifying it you'll build confidence in your code.
But database CI continues to be a painful, manual process in many projects. There are many reasons for this, most obviously the issue of data persistence, but there are ways to handle these issues.
In this session, I will show you:
-How easy it is to get your SQL Server database changes in source control
-How to set up an automated build process for your databases
-How this process helps you spot and fix errors quicker
-How to produce an artifact you can use for reliable, repeatable deployments in the future
SessionID: 38362
Data Quality Improvement through Master Data Driven Business Inte
Event Date: 25-07-2015 - Session time: 12:40:00 - Track: Sponsor
Speaker: Ben Cooper
Title: Data Quality Improvement through Master Data Driven Business Inte
Abstract:
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.
SessionID: 38705
SanDisk – Delivering the Application Accelerated Data Centre
Event Date: 25-07-2015 - Session time: 12:40:00 - Track: Sponsor
Speaker: Steve Wharton
Title: SanDisk – Delivering the Application Accelerated Data Centre
Abstract:
Since the acceptance of enterprise flash technology as a viable alternative to legacy hard disk drives; there has emerged a diverse range of solid state products. Consumers are faced with daunting task of needing to consider (amongst others) cost, capacity, endurance, interfaces; and the reality that not all flash is the same.
Principal Solutions Architect Phil Clarke, will discuss these challenges, enabling you to make an informed choice for your SQL infrastructure
SessionID: 39085
Event Date: 25-07-2015 - Session time: 12:40:00 - Track: Sponsor
Speaker: Ian Macdonald
Abstract:
SessionID: 18262
Tempdb - a database developer's perspective
Event Date: 25-07-2015 - Session time: 13:30:00 - Track: DBA
Speaker: Kevan Riley
Title: Tempdb - a database developer's perspective
Abstract:
Ask the internet for help when you have a performance issue with tempdb and you will find a slew of articles on how to configure and setup tempdb on your server, how many files to use, where to place them on the disk subsystem, even what hardware to use. But what if you are a developer, with no access or control over the configuration of the server. In this session Kevan explains what tempdb is and what it is used for and leading on from that how you can, through development approaches, control how you use it. The usage of tempdb will go hand-in-hand with the overall performance of your queries, so do not be surprised if you learn how to make your queries fly at the same time.
SessionID: 35639
Introduction to Replication from concepts to a running system!
Event Date: 25-07-2015 - Session time: 13:30:00 - Track: DBA
Speaker: David Williams
Title: Introduction to Replication from concepts to a running system!
Abstract:
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.
SessionID: 35765
AD 2015. 2 AM. A Disaster just began...
Event Date: 25-07-2015 - Session time: 13:30:00 - Track: Data Practices
Speaker: Tobias Koprowski
Title: AD 2015. 2 AM. A Disaster just began...
Abstract:
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.
SessionID: 37143
Advanced SSIS Techniques
Event Date: 25-07-2015 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: David Dye
Title: Advanced SSIS Techniques
Abstract:
As an ETL developer using SQL Server Integration Services have you ever wondered how to:
- Import all .csv files from a folder
- Replace dynamic SQL using variables in SSIS
- How to configure the data flow buffer
- Create custom logging solutions
- 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:
- Import/export multiple sources/destinations
- Use an execute SQL task with variables to replace dynamic SQL within a package
- Dynamically handle errors within any part of a package
SessionID: 38202
Machine Learning without a PhD in statisitcs
Event Date: 25-07-2015 - Session time: 13:30:00 - Track: Azure
Speaker: Andrew Fryer
Title: Machine Learning without a PhD in statisitcs
Abstract:
Machine learning is the science of making computers act without being unambiguously programmed. Machine learning is something that we use every day when we search and shop on the web and talk to our devices. Microsoft AzureML is a fully-managed cloud service that enables data aware developers to efficiently embed predictive analytics into their applications, without a PhD in statistics helping organizations use massive data sets and bring all the benefits of the cloud to machine learning. So join Andrew for a practical insight into the fascinating world of Machine Learning, where you can be significantly different but never certain, deviation is normal, and you are amongst friends if you found the above quote funny.
SessionID: 26105
SSRS Inception: Reporting on Reporting services.
Event Date: 25-07-2015 - Session time: 14:45:00 - Track: Business Intelligence
Speaker: Terry McCann
Title: SSRS Inception: Reporting on Reporting services.
Abstract:
Wouldn't it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn't it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.
SessionID: 27310
INSERT / UPDATE / DELETE - deep dive
Event Date: 25-07-2015 - Session time: 14:45:00 - Track: DBA
Speaker: Uwe Ricken
Title: INSERT / UPDATE / DELETE - deep dive
Abstract:
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
SessionID: 37212
Event Date: 25-07-2015 - Session time: 14:45:00 - Track: Azure
Speaker: John Martin
Abstract:
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.
SessionID: 37232
The elephant in the room: Continuous Delivery for Databases
Event Date: 25-07-2015 - Session time: 14:45:00 - Track: DBA
Speaker: Alex Yates
Title: The elephant in the room: Continuous Delivery for Databases
Abstract:
Let’s talk about constraints. What’s holding you back from achieving Continuous Delivery?
Databases.
If it’s painful, do it often... Your app is automatically integrated, tested and packaged for deployment in minutes. But what about databases?
Of course, databases come with complications and risks. We’ll talk about both the human and technical changes which are necessary to achieve a reliable, nimble, and automated database deployment process.
You’ll learn how to bring Dev and Ops closer together as well as customise established practices and existing toolsets to build a database deployment pipeline and speed up delivery while at the same time protecting the data (and your sanity).
In particular, we’ll look at two alternative solutions to the problem and their relative pros and cons. Declarative/state based development vs purely migrations driven development.
By the end of the session, delegates will have learned not only that this elephant in the room can be tamed, b
SessionID: 38667
Introducing Azure SQL Data Warehouse
Event Date: 25-07-2015 - Session time: 14:45:00 - Track: Azure
Speaker: James Rowland-Jones
Title: Introducing Azure SQL Data Warehouse
Abstract:
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 documentationlt;https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-develop/gt;!
SessionID: 11504
SQL Server Batch Mode and CPU Architectures
Event Date: 25-07-2015 - Session time: 16:00:00 - Track: DBA
Speaker: Christopher Adkin
Title: SQL Server Batch Mode and CPU Architectures
Abstract:
SessionID: 14145
Implementing and Maintaining an Azure SQL Database project
Event Date: 25-07-2015 - Session time: 16:00:00 - Track: Azure
Speaker: Emanuele Zanchettin
Title: Implementing and Maintaining an Azure SQL Database project
Abstract:
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.
SessionID: 34543
The 30 minute data warehouse
Event Date: 25-07-2015 - Session time: 16:00:00 - Track: Business Intelligence
Speaker: Adam Aspin
Title: The 30 minute data warehouse
Abstract:
This session takes you through the Power BI product set and explains how you can get analyse, experiment and iterate during the first stages of data warehouse proof of concept using Excel and Power BI. You will see how to model your data warehouse schema, make the processes more intuitive and specify the required outputs, aggregations and KPIs more efficiently while giving users an instant feel for the necessary outputs,
SessionID: 35803
DBA Guide to Extended Events
Event Date: 25-07-2015 - Session time: 16:00:00 - Track: DBA
Speaker: Neil Hambly
Title: DBA Guide to Extended Events
Abstract:
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
SessionID: 36673
Beginners Guide to MDX
Event Date: 25-07-2015 - Session time: 16:00:00 - Track: Business Intelligence
Speaker: Alex Whittles
Title: Beginners Guide to MDX
Abstract:
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.