You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
Come learn about the new adaptive query processor in SQL Server 2017 and Azure SQL Database. We will discuss how this feature works, how it can benefit your application and queries, and the future of intelligent query processing.
Automate SSRS management using Microsoft's PowerShell module
Are you still asking yourself, what is big data? What is HDInsight and how can I benefit from it? which type of HDInsight Cluster should I use? come to this session and find an answer
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.
Learn about the component of Power BI and best practices for implementations
Provision dev databases quickly and easily using containers and clones
GDPR is affecting any business that stores data including the SQL Server product group. Come and listen to how the Microsoft SQL Team approached the GDPR challenge for the SQL and SQL Azure business.
This session will dive deep into snapshotting of SQL databases
Come learn how to make your BI projects perform at their max!!
See the Magic of high-end analytics on any device, on any data source, using any database. Built in machine learning makes sophisticated analytics simple. Collaborate across the enterprise with easy implementation and real self-service analytics.
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
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.
Azure SQL Database built-in intelligence features will help you improve performance and security of your database and dramatically reduce the overhead of managing thousands of databases.
Learn how to plan and implement storage spaces direct and storage replica for FCIs.
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
Text analysis of financial documents using R & Power BI.
Ensure your indexes are achieving their fullest potential!
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
This session will reveal what's new for Azure Analysis Services in the areas of performance, scalability, advanced calculations, model management, and monitoring.
Pyramid Analytics BI Office’s Enterprise BI Platform and PrecisionPoint’s data warehousing solution for MS Dynamics ERP systems combine to deliver simplified access to key Business and Financial data.
Learn the ins and outs of Azure Data Lake in this deep dive
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 look at events that you should be monitoring, how you can use various services & IoT enabled devices to alert you in ways that were never possible. You'll leave with a new outlook of how teams can be notified to fix problems faster than ever.
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at the design considerations for clustered indexes and for nonclustered indexes.
Containers are a new and exciting technology but what does it mean for DBAs? This session will give an introduction into SQL Server running in containers and what options are available.
Continuous Integration has not yet been fully integrated into our BI standards and methods. Tool support is still somewhat unsatisfactory. Let’s look into requirements for a SSAS solution and on ways to approach your self-made solution.
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.
Azure SQLDW - WHAT, WHERE, WHEN and HOW to use it.
Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. This session gives you the details you need.
Industry independent analysts say “Pyramid Analytics is essentially the best-in-class, on-premises offering for Microsoft BI today and tomorrow” What does this mean for you and PowerBI?
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.
With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
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
Learn how to use this fantastic package in R for high-speed, low-code table wrangling.
In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB.
A session to understand the available functionality of SSISDB Catalog
Temporal Tables as a new technology in Microsoft SQL Server makes the implementation and management of data histories so easy. In this session, discover ALL the secrets of System Versioned Temporal Tables.
SQL Server normally relies on concurrency models in order to maintain the Isolation in ACID. As systems scale, this method can go from being a benefit to a hindrance, limiting the concurrency for our applications and hurting performance.
Make the right career move impressing your CEO and C-Level suite executives! Meet their specific needs with the right metrics and data visualisation. Power BI can help to bring clarity & predictability to the CEO to make strategic decisions.
A look inside SQL Server distribution statistics
Find out how the new SQL Clone enables self-service easy automation of database copies, near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.
In this session we will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot query performance.
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Write SQL unit tests with tSQLt and automate them with VSTS.
Choosing the wrong visualization can obscure the story - or worse yet, distort it! In this session, learn the vocabulary of data visualization and how to apply grammar (visualization design principles) to your data.
Learn about graph databases and how they are implemented in SQL Server vNext
This session will cover High Availability and Disaster Recovery solutions for SQL Server on Linux. What technology options are available and how to build a highly available database solution on Linux
The world’s largest enterprises run their critical business operations on SAP. See a demo of how to replicate SAP data to the Microsoft platform, avoiding the challenges of the complex underlying data models and structures.
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.