In this video, will learn how to use text and code cells to build an interactive document experience.
In addition, you’ll see some basics to edit your SQL notebook.
Learn more about SQL Notebooks here:
Here’s a great blog post on SQL Server 2019 Big Data Cluster and how it integrates Microsoft SQL Server and the best of big data open-source solutions.
Our testing demonstrates that the performance scales linearly from 1TB to 100TB datasets seamlessly and the various system resources are effectively utilized. Microsoft SQL Server 2019 Big Data Cluster leverages the high performance of Intel® Xeon® processors and Intel® SSDs to deliver great performance for complex queries. In addition, the benchmark results demonstrate powerful elasticity and performance of the entire platform.
The combination of Microsoft SQL Server 2019 Big Data Cluster and Intel’s Xeon Scalable platform can address many of your Big Data challenges. You can store and analyze data from multiple sources at scale, in various data formats, with scale-out compute for data processing and machine learning, together with the industry-leading experience of SQL Server.
In this video learn about the high availability options you have for the mission critical services running within the SQL Server Big Data Clusters.
Find out more here:
Chris Seferlis covers the Data Discovery and Classification options available in Azure SQL Database offerings in this video.
In this video from Microsoft Developer, learn anout Accelerated Database Recovery, and how it can solve many availability challenges with no operational or application changes.
Find out more about ADR here: https://docs.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-concepts?view=sql-server-ver15?WT.mc_id=dataexposed-c9-niner
[00:00] – Introduction
[00:40] – What is Accelerated Database Recovery (ADR)
[01:36] – The current SQL Server Database Recovery process
[03:00] – Database Recovery process with ADR
[04:58] – Benefits of ADR
[06:00] – Enabling ADR
[07:02] – Truncating transaction log strategy with ADR
[07:44] – Summary and wrap-up
Want to get started with Azure Data Studio (https://docs.microsoft.com/en-us/sql/azure-data-studio/download) but don’t know where to begin?
In this video, Anna Hoffman shows you how to get connected to Azure SQL Database for the first time using Azure Data Studio.
In this video, you will see how to use PolyBase in SQL Server 2019 big data cluster to query data from HDFS and join the data with other tables in the database.
Read more about configuring PolyBase to query HDFS.
In this Data Point, Andy chats with SentryOne CEO Bob Potter while roaming the expo floor at PASS 2019 Summit.
This is part of our on going coverage of PASS 2019 Summit.
Let us know in the comments how we’re doing and what you’d like to see.
Live video version of this Data Point is at https://www.facebook.com/DataDrivenTV/videos/2362966150499722/
Watch all our live videos at https://www.facebook.com/DataDrivenTV
Like us on Facebook to be notified of when we go live.
Press the play button below to listen here or visit the show page at DataDriven.tv.
Memory-Optimized TempDB Metadata is one of the new In-Memory Database features in SQL Server 2019. In this video, learn how to detect the TempDB metadata contention that this feature is intended to address, as well as how to enable and measure the impact of the feature.
Follow Pam Lahoud on Twitter.
More Data Exposed:
SQL Server 2019 is the latest version of the versatile and venerable SQL Server.
This latest version continues to redefine SQL Server from a traditional relational database system to a data platform for every data scenario from OLTP to DW to now big data and analytics.
In this video, get a quick overview of all the new things in SQL Server 2019 and introduce all of the other videos in this series that dive into the details.
Comments
What’s the right forecasting method?
Why Big Tech Is Getting Into Finance
How The Health Industry Is Being Revolutionized by Tech
How The Health Industry Is Being Revolutionized by Tech
Free 7 Hour Course on Statistics for Data Science