It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Learn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms.

Businesses today require real-time information to make better-informed decisions, this requires a new set of tools. In this session you will learn about Azure Stream analytics and how it can help address real-time data scenarios

SQL Server and Azure are built for each other.
New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.

Come learn about the business goals and technical challenges faced by real-world customers, why they chose Azure Cosmos DB, and the patterns they used to deliver highly available, globally distributed experiences.

Let’s understand the role of this hyper-scale two tier big data technology and how to harness its power with U-SQL, the offspring of T-SQL and C#. We’ll cover everything you need to know to get started developing solutions with Azure Data Lake.

Focusing on the micro-service / OLTP domain, this talk approaches the challenge of choosing between Azure SQL Database and Cosmos Db (Document Db) by using solution use cases to test each storage's offering for appropriateness.

Many existing Data Factories include large numbers of workarounds due to limitations with the service. Now that ADF V2 is available, we can restructure our Data Factories to be lean, efficient data pipelines, and this session will show you how.

We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory

How does Big Data with Hadoop, Cloud Computing in Azure, Self Service BI and “classic” BI with
SQL 2016 interact with each other to build a modern enterprise BI architecture at InnoGames?
Watch my talk and you will know!

One hot topic with Power BI is security, in this deep dive session we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored andleverage additional Azure services to secure it even more.

Deep learning is an essential component of an analytical toolbox. There are considerable challenges in training deep learning models and this presentation explores how to overcome these using Microsoft’s scalable ML offering, Azure Batch AI.

If you have 100's SQL Servers, some legacy applications, running on older versions and no cloud subscription? Then the path is to cloud very different from a single click.
We focus on the key steps needed for a cloud SQL data migration.

The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them.

The SQL team has been working on next-gen query processing improvements to improve the performance of your queries and to enable new scenarios. This talk will explain these enhancements and how they fit into the overall product roadmap for SQL.

We’ll share in the session best practices of designing highly available SQL Databases in the context of cross region deployment; how to make your application robust to handle transient connectivity issues.

Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.

Business expects 360 view of Customer but data is difficult to build, challenging to clean and complex to de-duplicate. The challenge is to synchronise this data with systems of record. See how Profisee can solve this problem at volume & without code

By using open data and web scraping in Power BI we will examine if weather has an impact on games in the English Premier League. We will look at the advantages and disadvantages of using open data and web page data how Power BI works with it.

Come to this session to learn about AzureSQL DB migration approaches, challenges, and solutions from SQLCAT. We will present practical migration guidance and learnings from our engagements with high scale and complex customer migrations

I look at how you can take advantage of an on-premises gateway to make use of local data when creating reports and dashboards for Power BI. This will start with Power BI Desktop, and the choices you have for SQL Server and Analysis Services.

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.

This presentation will give you an overview on U-SQL, why we decided to build a new language, what its core philosophical underpinnings are as well as show the language in its natural habitat, development tooling and language capabilities

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.

System-versioned temporal tables provide information about data at any point in time rather than just the current moment, and are a must have feature for any DBA. Collect vast amounts of operational data using OSS based on PowerShell technology and Azure. Add PowerBI to the mix and get mind blowing insights, the future will never be the same.

The quickest way to migrate your on-premises OLTP database to Azure is to "Lift & Shift". In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc.

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.

PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.

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.

This presentation will focus on techniques and practices for using memory optimized tables in SQL Server to build “warm” data stores from a variety of application data sources (logs,traces, performance statistics)

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.

This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites

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.

Being able to reason over your data and accelerate your insights is essential in this cloud first mobile first world. This session visits key technologies, PowerBI, AzureML and IoT to help you start driving your data culture.

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.

Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.