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?
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
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.
Tabular Editor is an open source offline editor experience for SSAS Tabular, which offers lots of features in a simple UI that can vastly improve your productivity when developing Tabular Models at compatibility level 1200+
Learn how to build, debug and deploy a chatbot using the Azure Bot Service and the Microsoft Bot Framework.
Best bractices in DAX formulas from real world experience.
Introducing the ROC curve and its use in Azure ML.
Selecting the right PaaS components in Azure
Extended Events was released with SQL Server 2008, and almost 10 years later, many data professionals are still clinging to Profiler. It's time to move forward, and in this session I'll show you how.
Combining Always ON Availability Groups and Powershell will make your life easier
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
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.
Securing your Data is Easier than ever with Azure SQL Database: A Walk Around the Security Toolset. This will be a demo-heavy overview of the latest security capabilities available, including the newest intelligent data protection features.
Microsoft SQL Operations Studio is a new light-weight, free and multi-os tools for SQL Server, Azure SQLDB and DW running anywhere.
SQL disk configuration and planning can really hurt you if you get it wrong in azure. There is a lot more to getting SQL right on Azure VMs than next-next-next.
Use temporal support in SQL Server and add what is missing out of the box.
Ensure your indexes are achieving their fullest potential!
This session will reveal what's new for Azure Analysis Services in the areas of performance, scalability, advanced calculations, model management, and monitoring.
An IoT analytics solution addressing real-life issues with SCADA data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. An end-to-end solution with Azure Data Warehouse, Azure Data Factory, Azure Analysis Services and PowerBI
Discover the Microsoft technologies that enable end-to-end data science, including SQL Server and Azure PaaS Services, along with practical scenarios and demos.
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.
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
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.
If you use AlwaysOn Availability Groups, then come learn about the new enhancements shipped with SQL Server 2012 SP3 and above which allows you to troubleshoot failovers in your AG and understand reasons for latency.
Analytics is all about having a good set of analytical tools. Last year at Sqlbits I outlined 4 such tools, this session will expand on that set. We’ll cover Dark Data, Probability calculations, RFI
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
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.
Let's talk about how you can get the most out of Azure DocumentDB. In this session we will dive deep in to the mechanics of DocumentDB and explain the various levers available to tune performance.
Join me for an overview of how Azure SQL DB customers can simply secure their data using our most advanced features to-date including Always Encrypted, Transparent Data Encryption, Dynamic Data Masking and SQL Threat Detection.
SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Learn how to speed up your SSIS development by using Biml and BimlScript.
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
Buck Woody will lead you around the Cortana Intelligence Suite showing you how to create intelligent actions from data.
There's base R, modern R, the Hadleyverse, R in SQL, and more - understanding where to begin can be an exercise in frustration and cost you valuable time. This session takes you through the R you need to be productive quickly.
In this session we will talk through the process of gathering user requirements to provide a good starting point for your data model. We will use the Sun Modelling technique to aid us in this.
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
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.
These two Microsoft analytic platforms share lots of technologies and users can import and model data in any one of the environments and use the results across both.
Tabular offers only one-to-many relationships on a single column: it seems poor when compared with Multidimensional. However, with DAX, you can handle any relationship. We analyze and solve scenarios with calculated, virtual and complex many-to-many.
In this session, we will introduce a step-by-step approach to adopting the technology, aimed at beginners who are interested in how it can fit into their own environments.
In this session we will take a deep dive into one of the, in my opinion, most exciting new feature in SQL Server 2016, the Query Store. Learn all about the inner workings of the query store and how it can help you analyse query performance!
Enter the world of SQL Server concurrency to experience the age old problem of Locking, Blocking and Deadlocking. Let's investigate pessimistic isolation and whether optimistic concurrency could be the answer to all our problems or the last resort.
Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look at the three main aspects of locking, including when locks cause blocking and also examine ways to minimize blocking.
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.
<<12345678>>