This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages along with what Microsoft Azure has to offer.
This session covers the more advanced aspects of development for Azure SQL Data Warehouse. Areas such as data movement, workload concurrency and resource management will all be covered during this intense 60 minute session.
Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.
Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.
In this session, we are going to look at a typical machine learning process and how to apply it to real world data. We are going to use Azure Machine Learning to transform data and ideas into models that are production ready in minutes.
In this talk, you will get an overview on what to think about when storing data in a document database.
Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS/DECOMPRESS, from SESSION_CONTEXT() to DATEDIFF_BIG(), and new query hints.
The Internet of Things starts with your things. It's a great time to take a look at game changing technologies you can use today to make your IoT ideas stand out from the rest using Microsoft Azure.
SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.
Data Warehouses are changing. This session will run through the architecture of the modern warehouse, from structured/unstructured Azure Data Lakes to platform as a service Azure Data Warehouse and bringing the two together.
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.
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.
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.
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.
Microsoft Codename "Data Explorer" provides a new way to organize, manage, enrich, share and gain new insights from your data.
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.
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.
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!
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.