Learn the ins and outs of Azure Data Lake in this deep dive
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 and see how queries use them.
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.
With the latest release of SQL Server Reporting services, more and more organizations are adopting it as an organizational reporting solution. Join this session as I explain how to architect and deploy a scalable and highly available solution.
An example of how Azure Data Catalog lets users understand and consume data sources.
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.
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.
In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system.
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
In this session you will learn how to use Extended Events and Dynamic Management Views (DMVs) to build a performance-monitoring system for your database environment.
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.
A practical look at the components of Cortana Intelligence Suite.
Have you ever considered a situation where Columnstore Index can be quite the opposite of what one expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources ...
Columnstore Engine killed OLAP ... or did it really ?
Learn how to use this fantastic package in R for high-speed, low-code table wrangling.
Data architects and DBAs have debated database design best practices for decades. Join us for some great debates and laughs.
In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB.
The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many and RLS.
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.
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions.
A look inside SQL Server distribution statistics
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
How easy is it to hack a SQL Server? In this session we'll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll also cover recommendations on how to avoid these attacks.
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
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.
Many organizations want to build software in a DevOps framework, but struggle to include the database. Come see how Continuous Integration, Testing, and Continuous Deliver can work with a database.
SQL Server vNext R Services and the new MicrosoftML package
A query was running fast yesterday and today it suffers from performance problems. What will you do? - restart the server (did work) - drop the procedure cache (read in a blog article) - get a coffee and pass in review this session about statistics
This session, designed for developers and data scientists, will ramp up the attendee very quickly on Microsoft's powerful machine learning algorithm APIs as a part of Cognitive Services and chat bot development tools as part of the Bot Framework
The Query Store will change how you tune queries and gather metrics about them in both SQL Server 2016 and Azure SQL Database.
Learn to build Analysis Services models in the cloud
What is the future going to look like? When are we going to reach true Artificial Intelligence? Is the Singularity going to happen? There is a lot of talk today about AI and what it means for the human society.
In this session, Program Managers from Microsoft will provide an introduction to SQL Server and how it runs on Linux and container platforms.
The Tiger team will showcase the environments that help you keep your environment Always On
In this session Richard Conway will show you from grass roots no knowledge of Spark how to navigate the Spark framework ecosystem and build complex batch and near real time applications that use Spark's machine learning library mllib
In this session you will get a brief introduction to the basic principles of Master Data Services, together with an overview of all the new features brought to you with Master Data Services 2016.
Discover the ins and outs of some of the newest capabilities of our favorite data language, and walk away with a long list of reasons to consider upgrading to the latest version - or the next version.
Many people think that normalization stops at Third Normal Form. But there are lots of higher normal forms. And they are not as complex or as irrelevant as often claimed. If you want to design better databases, then come attend this session!
Learn about the powerful 8600 series of trace flags which additional details about how the query optimizer behaves as it processes a query.
In this session we will show you how Tabular performs when you are querying a model with many billions rows, conduct a complete analysis of the model searching for optimization ideas and implement them on the fly, so to look at the effect of using th
See how Azure Data Factory orchestrates the movement of data in Azure.
Learn how object-oriented T-SQL hurts performance.
Ask with T-SQL the "what" and delegate to the engine the "how". With few slides and a lot of real-case scenarios, you can see the advantages of writing the query for high performance, even when they are written by that "someone else" called ORM
What are the pros and cons of SSRS compared to Power BI? How can you benefit from Power BI on-premises?
We will take a look into my favourite Powershell scripts
An in depth look at query plans and the query optimiser
The Query Store functionality in SQL Server 2016 will change the way we look at performance going forward. Come see why.
SQL Server 2016 is a class leading Tier One product but how do you get customers to upgrade and migrate? How can you address the "so what" SQL does everything I need to do now?
This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 and Microsoft Azure SQL Database
As we have always seen a steady growth in SSRS since 2005, we now have much more advanced brand new features in 2016 SQL Server Reporting Services, beyond our imagination and in particular using Revolution R Models.
You are hitting performance and scalability issues with the database engine, conventional wisdom and tools and getting you nowhere, where do you go ?, windows performance toolkit has the answers.
Come take a deep dive and behind the scenes look at why SQL Server 2016 "Just Runs Faster" with little or no application changes.
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.
SQL Server Replication: What is it? How does it work? Why would you want to use it in your environment?
Row counts are the primary factor for choices made by the query optimizer. This session explores how row counts affects query performance.
In this fun session we'll review a bunch of problem implementations that have been seen in the real world. Most importantly we will look at why these implementations went horribly wrong so that we can learn from them and never repeat these mistakes.
In this talk Laura will go through the theory and practice of time series analysis with examples in R covering concepts such as lag, serial correlation and Box-Ljeung tests.
Clustered instances (FCIs) and availability groups (AGs) can still be the source of pain and confusion for many. Learn from one of the world's experts on clustering SQL Server about some of the most important considerations to clustering success.
This session will cover common DBA troubleshooting scenarios on SQL Server on Linux. In this demo rich session, we will cover various every-day from troubleshooting startup and configuration to performance and bottleneck analysis.
This session covers various T-SQL tips and tricks that illustrate creative ways to handle querying tasks elegantly and efficiently.
Tired of Bar Charts? We'll build out a custom PowerBI Visual and show the power of PowerBI whilst going into a deep dive on how this is achieved.
In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Pivot tables are very powerfull for analysing data, but a bit difficult to learn. This session will explain all the features to unlock the real power of the PivotTable
Learn to use the M language to load data into the next version of SQL Server Analysis Services Tabular.
Attend this session to get an overview of the wide array of significant changes and investments with Azure SQL Database, including parity with SQL Server 2016 and Intelligent database capabilities.
Learn about identity management in Azure. You will learn about how to manage identity across your cloud environments.
Learn how poor data type choices can cripple SQL Server.
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.
Come to this session to see how you can create a more efficient database development platform by integrating your VCS with SQL Server. In real-time, you’ll see how versioning, branching, merging, and the other manual tasks you hate can fade away with
Join Joseph for a fascinating look into SQL Server 2016 and its unmatched innovation across on-premises and the cloud to help you turn data into intelligent action
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.
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
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
This session will compare Microsoft’s options for deploying highly available SQL Server data platforms in mid-2016.
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.
Join this session on moving a legacy enterprise organisation into the modern BI world using the power of positive disruption and the Attunity tool set. This real world case study will explore Zurich Insurance’s journey featuring both the challenges and successes they faced.
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.
The typical performance bottleneck in your data warehouse is using SSIS to insert massive amount of data into SQL Server. In this session, you will learn how to improve the load performance with SSIS into SQL Server.
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
Lindsey Allen will peel back the curtain on SQL Server 2016 new feature Operational Analytics. We continue to invest heavily in in-memory technology and have now introduced one of the more important features we are releasing as part of SQL Server.
Learn from a real customer how they developed and deployed a series of BI Office solutions to support various business functions including: Finance, Web Analytics Supply, Pricing.
An introduction with worked examples of the new Data Lake storage platform in Azure.
  1 to 100 of 929 first 1 2 3 4 5 6 7 8 9 10 last  Show 10 25 50 100 sessions per page