Azure stream analytics is a new Azure service for analyzing streaming data.
Azure Data Factory is a managed service for extracting, transforming and processing data, with ability to define pipelines and data driven workflows. in this session you will learn differences between this tools and SSIS with demos
Azure Machine Learning is a fully managed cloud service for predictive analytics.
In this 1hour session, we will run through;
ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.
Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.
The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.
You're hearing a lot about the new features in SQL Server, but you're not hearing a lot about the drawbacks. Ever wonder why? Join Brent Ozar, the guy behind DBAreactions.com, for a sarcastic, funny look at SQL Server 2014's "features" and bugs.
Does the concept of analytics make you nervous? Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies.
This session will look at providing cost effective DR capability with Azure.
Need to search your data efficiently whilst in the cloud? This session introduces you to MSFT's highly scalable search solution in Azure
In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies.
One of the crawl, walk then run onramps to the cloud would be to exploit Hybrid computing. Microsoft SQL Server gives you this on ramp as it continues to extend the value to your on premise environment with features that let you extend to the cloud
Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.
In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.
Microsof IT's Cloud strategy involves migrating hundreds of applications to Azure. The scale on which it is being done may be unprecedented. Lessons Learned are numerous. This session exposes the most important—& painful—ones.
Power BI is the Self-Service BI offering of Microsoft to all Information Workers out there, but hey: Is there anything for developers? We will have a look.
In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies. This presentation will provide an outline of the scenarios and requirements for a database service.
Peter O'Connell will talk about how SpotlightEssentials.com uses SQL Azure to collect and mine over 40TB of SQL Server Performance data across thousands of instances to drive unique insights into SQL Server Performance.
Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.
Microsoft is moving to the cloud and SQL Server 2014 is the first release with features designed specifically to extend your datacentre into the cloud. In this session we'll look at these features with end-to-end demos, discussions and scenarios so you can understand what the future could look like in your own SQL Server environment.
Firstly we will show off Microsoft's enhancements to the Hadoop open source stack with HDInsight showing you how easy it is to get started with Hadoop. Secondly we'll explore an interesting big data use case
In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and the demo performance, scalability and monitoring impacts.
Once you've decided to move to Azure with any of your databases, you're going to need to know how they're performing, this session shows you.
This session will discuss the recommended approaches and best practices for partitioning and scaling Windows Azure SQL Database, allowing you to fully leverage the managed relational database service and take advantage of massive scale-out scenarios.
The way our data will be stored is changing and it's all about your network. Come find out why CSVs, SMB, Windows Scale Out File Servers, fast networks, and maybe even the cloud are in your future.
This session will focus on 5 great hybrid cloud features available in SQL Server 2014 that show how you can use these features to lower your TCO and leverage the cloud to provide new disaster recovery and backup solutions.
An overview of the architectural reasons to consider cloud-based SQL Server solutions and insights into the differences you need to know between Windows Azure SQL Database and on-premises SQL Server.
While there are many similarities between SQL Server and SQL Azure, there are different kinds of applications that are easier to build in one or the other. One of the major differences relates to how to build an application that “scales”. This presentation will provide an introduction into the difference between scale-up (SQL Server) and scale-out (SQL Azure) architectures and give you a primer on how you can build a large, Internet-facing service that can scale to arbitrarily large sizes on commodity hardware. This talk is targeted at SQL Server practitioners to give them a working knowledge of how the two platforms differ based on Microsoft’s experiences with its largest Software-as-a-Service (SaaS) customers running on SQL Azure.
Just because you're using an Azure SQL database does not mean you can avoid tuning queries. This session will introduce you to the tools you have available to identify poor performing queries, understand, and fix them. All in the cloud.
In this session we are going to look at the some of the flavours of SQL in Azure, namely Windows Azure Database and SQL on IaaS. We will discuss the differences between them, look at what this means from a DBA stand point
Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.
This session provides an architectural blueprint to deploying disaster recovery solutions combining on-premise and Windows Azure cloud technologies. The session looks at a design pattern to solve a long standing and often expensive issue of DR.
We aim to cover the fundamental concepts that you should know on the Cloud and Windows Azure. In this demo based hour we will step through building Azure applications, deploying and managing them and what storage choices you will face.
While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.
As a shared database infrastructure in the cloud, SQL Azure provides the opportunity for creating large workloads in a scalable and reliable environment.
When your boss sends you to a conference, she expects you to learn something useful. Like all of the buzzwords she has to explain to her boss. Make it worth her while (and budget) and bring back the info she craves.
Come see what a Database Private Cloud is all about. If you have many SQL Server instances already or need to grow use of on-premises SQL Server and other demanding workloads you may need a database private cloud.
Do you want to learn how Microsoft helped one of the largest Financial Services organizations in the world design a Private Cloud infrastructure using Windows Hyper-V and System Center 2012 to standardize and consolidate hundreds of SQL Servers?
Microsoft Codename "Data Explorer" provides a new way to organize, manage, enrich, share and gain new insights from your data.
In this presentation, we provide an introduction to SQL Azure Federations and also show
some interesting patterns that provide additional capabilities such as
scale-out query processing, cross-shard schema management and multi-key sharding.
Sql user group leaders present an A-Z of nuggets
Learn how the SQL Server Data Tools can help you migrate your on-premise SQL Server databases to SQL Azure
Juneau is a new developer tool in Denali. Brings VS paradigms to SQL Server like Debug, Refactor and Declarative maintenance. Come to this session and learn what these tools are really about.
Basic outline of SQL Azure: How SQL Azure fits in with other Azure Storage Options. Main differences between SQL Azure and SQL 2008. Brief new design challenges.
The leaders from every SQL user group across England, Scotland & Wales have got together and created the definitive dictionary of essential SQL know-how, and crammed all of this into a single fast paced romp through the SQL alphabet.
With a myriad of options available, choosing the most appropriate storage solution for your company can be challenging. This session will give you a brief introduction to the technologies available, and what to focus on when making the decision.
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
All developers and DBAs make mistakes when programming in SQL Server. Learn to avoid the most common mistakes.
This session will teach you how to successfully plan, implement and manage SQL Server consolidation and virtualization within your organization
Mark Souza (General Manager in the SQL Server product team) will spend an hour of presentation and discussion of Microsoft's next generation database platform followed by a discussion on cloud technology.
SQL Azure is Microsoft’s new strategy for storing your data in the cloud, but what to do when you exceed the 10/50GB limit. This is where sharding or partitioning comes into play – this session shows you how it can be done in an OLTP system and show you some of the common pitfalls of SQL azure as we have discoverd in analyzing SQL Azure as an alternative to onsite SQL Server instances at different clients.
Consolidation of SQL Server infrastructure has become increasingly popular.
This is true from both a technological and financial perspective, may it be through virtualization, instance concentration or in building SQL Server hotel environments.
This is an in-depth presentation on one of the biggest consolidation projects ever in the Nordic countries based on SQL Server 2008.
This presentation will cover both the business aspects as well as the technical reasons behind this project by two of its top resources.
In one year the customer went from nearly 200 physical machines hosting over 1100 databases to only 20 servers without using any form of virtualization!
Everything you need to know to get up and running with this new technology
Comparison between Azure storage and SQL Data Services
Taking a look at what ADO.NET Data Services does for us in exposing data over a set of RESTful protocols for easy access from any kind of client.