SQL Server 2019

Data SQL Server

How to Automate Disaster Recovery in SQL Server On-Prem

Are you prepared if a tornado filled with sharks destroys your primary data center? Sure, you may have backed up your databases, but what about logins, agent jobs or extended events? In this episode of Data Exposed, join Chrissy LeMaire  as she demos how disaster recovery can be simplified using the SQL Community’s SQL Server […]

Read More
Azure SQL Server

How to Create Your First Azure SQL Database

Learn the differences between the Basic, Standard, and Premium tiers of Azure SQL Single Database. Provisioning is one component of maximizing the value of your deployment – licensing is another. In this video with Matt Gordon, take a walk through the differences between licensing by DTU and by vCore and talk about what may be […]

Read More
Containers SQL Server

Learn How to Deploy SQL Server 2019 in Containers in Just Minutes

Containers are taking over, changing the way systems are developed and deployed. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, using containers! In this session, we’ll get your started on your container journey learning how to deploy SQL Server in Containers. Resources: […]

Read More
SQL Server

SQL Server 2019 Improves Scalar UDF Performance

Microsoft added several features to SQL Server 2019 that can improve performance without changes to code. One of these is T-SQL Scalar UDF Inlining. The use of UDFs is a red flag when tuning queries, but, in some cases, the engine will treat these as if the underlining code was added directly to the select […]

Read More
SQL Server Uncategorized

How Resumable Indexes in SQL Server 2019 Makes Your Job Easier

Microsoft continues to push the envelope on feature capabilities with every release of SQL Server.  One of the more prominent features that was released with Microsoft SQL Server 2019 is the ability to resume or throttle certain index operations. Have you ever want to just stop and then resume an index operation picking up where […]

Read More
SQL Server

How To Create a Persistent Log Buffer in SQL 2019

Persistent Log Buffers, sometimes referred to as tail of log caching, uses persistent memory to persist the database log buffer, eliminating bottlenecks that may occur on busy systems waiting for the log buffer to flush to disk. A process known as log hardening. Learn more here. [00:00] Intro [00:45] Positioning persistent log buffer [01:13] Persistent […]

Read More
Azure Big Data

Big Data Cluster High Availability

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: https://docs.microsoft.com/en-us/sql/big-data-cluster/deployment-high-availability?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner https://docs.microsoft.com/en-us/sql/big-data-cluster/deployment-high-availability-hdfs-spark?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner

Read More
Big Data Security

Overview: Big Data Cluster Security

In this video, get an overview of security features in Big Data Clusters.  More information on security in big data clusters: https://docs.microsoft.com/en-us/sql/big-data-cluster/concept-security?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner  Follow Jeroen ter Heerdt and Nellie Gustafsson on Twitter.

Read More
Azure Big Data

Big Data Cluster Administration

This video provides an overview of administration experiences for BDC (Big Data Clusters). In big data clusters, we ensure that management services embedded with the platform provide fast scale and upgrade operations, automatic logs and metrics collection, enterprise grade secure access and high availability.

Read More
SQL Server 2019 Feature Notebooks
Big Data Spark SQL Server

SQL Server 2019 Feature Notebooks

Here’s a great collection of Jupyter notebooks that explore all the new features of SQL Server 2019. Here are some of the ones that caught my attention. SQL Server 2019 Querying 1 TRILLION rows OneTrillionRowsWarm.ipynb – This notebook shows how SQL Server 2019 reads 9 BILLION rows/second using a 1 trillion row table using a warm cache, OneTrillionRowsCold.ipynb – […]

Read More