Microsoft Docs - Latest Articles

As the new home for Microsoft technical documentation, docs.microsoft.com has not only modernized the web experience for content, but also how we create and support the content you use to learn, manage and deploy solutions. It is the one-stop shop for everything related to Microsoft technologies. In order to make sure you can keep up to date on what’s new and exciting on docs.microsoft.com, we’ve created a dedicated feed for you.


Selected Feed: SQL

Azure built-in roles - Azure RBAC

https://learn.microsoft.com/en-us/azure/role-based-access-control/built-in-roles This article describes the Azure built-in roles for Azure role-based access control (Azure RBAC). It lists Actions, NotActions, DataActions, and NotDataActions.
Published Date : Sunday, October 2, 2022

ThreadPool.SetMaxThreads(Int32, Int32) Method (System.Threading)

https://learn.microsoft.com/en-us/dotnet/api/system.threading.threadpool.setmaxthreads Sets the number of requests to the thread pool that can be active concurrently. All requests above that number remain queued until thread pool threads become available.
Published Date : Saturday, October 1, 2022

SqlClient Support for High Availability, Disaster Recovery - ADO.NET

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/sqlclient-support-for-high-availability-disaster-recovery Learn about SqlClient application support for high-availability, disaster recovery in SQL Server, using Always On Availability Groups or Always On Failover Cluster Instances.
Published Date : Saturday, October 1, 2022

Get Analytics insights comparable to those provided by SQL Reporting Services reports - Azure DevOps

https://learn.microsoft.com/en-us/azure/devops/report/sql-reports/analytics-insights-comparable-sql-reports Learn how to get insights using Analytics comparable to those provided by the legacy SQL Reporting Services reports.
Published Date : Saturday, October 1, 2022

Use notebooks - Azure Databricks

https://docs.microsoft.com/en-us/azure/databricks/notebooks/notebooks-use Learn how to use a notebook by developing and running cells.
Published Date : Friday, September 30, 2022

Enable Serverless SQL warehouses - Azure Databricks - Databricks SQL

https://docs.microsoft.com/en-us/azure/databricks/sql/admin/serverless Learn about Serverless warehouses and how to manage them.
Published Date : Friday, September 30, 2022

Create tables - Azure Databricks

https://docs.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/create-tables Learn how to create tables in Unity Catalog.
Published Date : Friday, September 30, 2022

September 2022 - Azure Databricks

https://docs.microsoft.com/en-us/azure/databricks/release-notes/product/2022/september September 2022 release notes for new Azure Databricks features and improvements.
Published Date : Friday, September 30, 2022

Azure Databricks platform release notes - Azure Databricks

https://learn.microsoft.com/en-us/azure/databricks/release-notes/product/ Release notes index for the Azure Databricks platform.
Published Date : Friday, September 30, 2022

Configure clusters - Azure Databricks

https://learn.microsoft.com/en-us/azure/databricks/clusters/configure Learn how to configure Azure Databricks clusters, including cluster mode, runtime, instance types, size, pools, autoscaling preferences, termination schedule, Apache Spark options, custom tags, log delivery, and more.
Published Date : Friday, September 30, 2022

May 2021 - Azure Databricks

https://learn.microsoft.com/en-us/azure/databricks/release-notes/product/2021/may May 2021 release notes for new Azure Databricks features and improvements.
Published Date : Friday, September 30, 2022

Databricks Runtime 11.2 - Azure Databricks

https://docs.microsoft.com/en-us/azure/databricks/release-notes/runtime/11.2 Release notes about Databricks Runtime 11.2, powered by Apache Spark.
Published Date : Friday, September 30, 2022

Create, run, and manage Azure Databricks Jobs - Azure Databricks

https://docs.microsoft.com/en-us/azure/databricks/workflows/jobs/jobs Learn how to view, create, and run jobs in Azure Databricks.
Published Date : Friday, September 30, 2022

Constraints on Azure Databricks - Azure Databricks

https://docs.microsoft.com/en-us/azure/databricks/tables/constraints Learn how how to apply constraints on tables in Azure Databricks.
Published Date : Friday, September 30, 2022

Best practices: Cluster configuration - Azure Databricks

https://docs.microsoft.com/en-us/azure/databricks/clusters/cluster-config-best-practices Learn best practices when creating and configuring Azure Databricks clusters.
Published Date : Friday, September 30, 2022

Build a Node.js app for Azure Cosmos DB Core (SQL) in Visual Studio Code - Training

https://learn.microsoft.com/en-us/training/modules/build-node-cosmos-app-vscode/ Build a database app to store and query data in Azure Cosmos DB Core (SQL) by using Visual Studio Code, Node.js and JavaScript.
Published Date : Friday, September 30, 2022

See a View by Using SQL Server - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/how-to-see-a-configuration-manager-view-by-using-sql-server The following examples demonstrate various Microsoft Configuration Manager SQL view queries.
Published Date : Friday, September 30, 2022

Schema view mapping - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/configuration-manager-schema-view-mapping Learn how the SQL Server schema of the Configuration Manager site database maps to the WMI schema.
Published Date : Friday, September 30, 2022

SMS_CMSiteConfiguration Class - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/develop/reference/core/servers/configure/sms_cmsiteconfiguration-server-wmi-class Learn how to retrieve the site's monitored configuration status, such as the SQL Server port, SQL Server Service Broker port, and SQL Server Firewall port.
Published Date : Friday, September 30, 2022

Set up your lab - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/get-started/set-up-your-lab Set up a lab for evaluating Configuration Manager with simulated real-life activities.
Published Date : Friday, September 30, 2022

Schema SQL Views - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/configuration-manager-schema-sql-views Creates schema information views. These are particularly useful for determining the names for custom inventory resource type (architecture) tables.
Published Date : Friday, September 30, 2022

Evaluate in a lab environment - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/get-started/evaluate-with-lab-environment Create a lab environment to evaluate Configuration Manager for use in your organization.
Published Date : Friday, September 30, 2022

Schema Overview - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/configuration-manager-schema-overview This article discusses the Configuration Manager Schema Overview.
Published Date : Friday, September 30, 2022

Product lifecycle dashboard - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/core/clients/manage/asset-intelligence/product-lifecycle-dashboard View the Microsoft Lifecycle Policy with the product lifecycle dashboard in Configuration Manager.
Published Date : Friday, September 30, 2022

Asset intelligence deprecation - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/core/clients/manage/asset-intelligence/deprecation More information about the deprecation of the asset intelligence feature of Configuration Manager.
Published Date : Friday, September 30, 2022

Client health checks - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/clients/manage/client-health-checks The checks that the Configuration Manager client runs regularly to keep healthy.
Published Date : Friday, September 30, 2022

Extended WMI Query Language - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/extended-wmi-query-language A superset of the Windows Management Instrumentation (WMI) Query Language (WQL) known as Extended WQL. Configuration Manager supports both WQL and Extended WQL.
Published Date : Friday, September 30, 2022

Create a lab in Azure - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/core/get-started/azure-template Automate the creation of a Configuration Manager technical preview lab or current branch evaluation lab using Azure templates
Published Date : Friday, September 30, 2022

Date and Time Formats - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/date-and-time-formats When you write queries or compose reports from information that is stored in the Configuration Manager site database, you can express the date and time in any valid SQL format.
Published Date : Friday, September 30, 2022

Configuration Manager programming - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/getting-started-with-configuration-manager-programming Learn the basics of programming and automation with the Configuration Manager software development kit (SDK).
Published Date : Friday, September 30, 2022

Technical preview releases - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/get-started/technical-preview Learn about the technical preview branch to test-drive new functionality and capabilities in Configuration Manager.
Published Date : Friday, September 30, 2022

Technical preview 2109 - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/core/get-started/2021/technical-preview-2109 Learn about new features available in the Configuration Manager technical preview branch version 2109.
Published Date : Friday, September 30, 2022

Collection evaluation - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/clients/manage/collections/collection-evaluation Learn about the collection evaluation process, types, and triggers. Understand the collection evaluation graph and hierarchy.
Published Date : Friday, September 30, 2022

Collections best practices - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/clients/manage/collections/best-practices-for-collections Get recommendations for configuring collections and collection evaluation in Configuration Manager.
Published Date : Friday, September 30, 2022

Windows client prerequisites - Configuration Manager

https://learn.microsoft.com/en-us/mem/configmgr/core/clients/deploy/prerequisites-for-deploying-clients-to-windows-computers Learn about the prerequisites for deploying the Configuration Manager client to Windows computers.
Published Date : Friday, September 30, 2022

Data flow for CMG - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/clients/manage/cmg/data-flow Understand how data flows between components of the cloud management gateway (CMG), including network ports and internet endpoints.
Published Date : Friday, September 30, 2022

Client security and privacy - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/core/clients/deploy/plan/security-and-privacy-for-clients Learn about security and privacy for Configuration Manager clients.
Published Date : Friday, September 30, 2022

Architectural overview - Configuration Manager

https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/architectural-overview A description of Configuration Manager server and client architectures.
Published Date : Friday, September 30, 2022

September 2022 announcements - Partner Center

https://docs.microsoft.com/en-us/partner-center/announcements/2022-september September 2022 announcements for Microsoft Partner Center including new capabilities, promotions, offers, markets, or changes to existing offers.
Published Date : Friday, September 30, 2022

Migration guide for Az 9.0.0

https://learn.microsoft.com/en-us/powershell/azure/migrate-az-9.0.0 This migration guide contains a list of breaking changes made to Azure PowerShell in the Az version 9.0.0 release.
Published Date : Friday, September 30, 2022

Best practices with Query Store - SQL Server

https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store Learn best practices for using SQL Server Query Store with your workload, such as using the latest SQL Server Management Studio and Query Performance Insight.
Published Date : Friday, September 30, 2022

Monitor performance by using the Query Store - SQL Server

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store Query Store provides insight on query plan choice and performance for SQL Server, Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. Query Store captures history of queries, plans, and runtime statistics.
Published Date : Friday, September 30, 2022

Secure SQL Server Linux containers - SQL Server

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-docker-container-security Understand the different ways to secure SQL Server Linux containers and how you can run containers as different non-root user on the host
Published Date : Friday, September 30, 2022

SQL Server 2022 Release Notes - SQL Server

https://docs.microsoft.com/en-us/sql/sql-server/sql-server-2022-release-notes Find information about SQL Server 2019 (16.x) limitations, known issues, help resources, and other release notes.
Published Date : Friday, September 30, 2022

Troubleshooting Active Directory authentication for SQL Server on Linux and containers - SQL Server

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-ad-auth-troubleshooting Troubleshoot Active Directory authentication issues with SQL Server on Linux and containers, configuration tips, common errors. Includes Kerberos, keytabs and DNS.
Published Date : Friday, September 30, 2022

SQL Server Big Data Clusters cumulative updates history - SQL Server Big Data Clusters

https://learn.microsoft.com/en-us/sql/big-data-cluster/release-notes-cumulative-updates-history This article describes the updates and known issues for SQL Server Big Data Clusters.
Published Date : Friday, September 30, 2022

Rotate SQL Server on Linux keytabs - SQL Server

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-ad-auth-rotate-keytabs Recommendations on rotating keytabs for SQL Server on Linux using adutil when configured for Active Directory authentication
Published Date : Friday, September 30, 2022

Introduction to adutil - Active Directory Utility - SQL Server

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-ad-auth-adutil-introduction Overview of adutil, a utility for configuring and managing Active Directory domains for SQL Server on Linux and containers
Published Date : Friday, September 30, 2022

SQL Server 2019 Big Data Clusters platform release notes - SQL Server 2019 Big Data Clusters

https://docs.microsoft.com/en-us/sql/big-data-cluster/release-notes-big-data-cluster This article describes the latest updates and known issues for SQL Server Big Data Clusters.
Published Date : Friday, September 30, 2022

Configure DNN listener for availability group - SQL Server on Azure VMs

https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-distributed-network-name-dnn-listener-configure Learn how to configure a distributed network name (DNN) listener to replace your virtual network name (VNN) listener and route traffic to your Always On availability group on SQL Server on Azure VM.
Published Date : Friday, September 30, 2022

Configure a domain-independent workgroup availability group - SQL Server on Azure VMs

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-clusterless-workgroup-configure Learn how to configure an Active Directory domain-independent workgroup Always On availability group on a SQL Server virtual machine in Azure.
Published Date : Friday, September 30, 2022

Migrate failover cluster instance - SQL Server on Azure VMs

https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-failover-cluster-instance-to-sql-on-azure-vm Learn how to lift and shift your Always On failover cluster instance high availability solution to SQL Server on Azure VMs using Azure Migrate.
Published Date : Friday, September 30, 2022

sys.database_query_store_internal_state (Transact-SQL) - SQL Server

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-query-store-internal-state-transact-sql sys.database_query_store_internal_state contains information about queue length and memory usage for the Query Store when Query Store for secondary replicas is enabled.
Published Date : Friday, September 30, 2022

sys.query_store_replicas (Transact-SQL) - SQL Server

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-store-replicas The sys.query_store_replicas system view contains information about Query Store replicas.
Published Date : Friday, September 30, 2022

sys.plan_forcing_locations (Transact-SQL) - SQL Server

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-plan-forcing-locations The sys.plan_forcing_locations system view contains information about plan forcing on Query Store replicas.
Published Date : Friday, September 30, 2022

Single database vCore resource limits - Azure SQL Database

https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases This page describes some common vCore resource limits for a single database in Azure SQL Database.
Published Date : Friday, September 30, 2022

SQL Server 2019 Big Data Clusters CU17 release notes - SQL Server Big Data Clusters

https://docs.microsoft.com/en-us/sql/big-data-cluster/release-notes-cumulative-update-17 This article describes the SQL Server 2019 Big Data Clusters Cumulative Update 17 contents.
Published Date : Friday, September 30, 2022

SQL Server 2019 Big Data Clusters CU18 release notes - SQL Server Big Data Clusters

https://learn.microsoft.com/en-us/sql/big-data-cluster/release-notes-cumulative-update-18 This article describes the SQL Server 2019 Big Data Clusters Cumulative Update 18 contents.
Published Date : Friday, September 30, 2022

Commercial marketplace general listing and offer policies

https://docs.microsoft.com/en-us/legal/marketplace/certification-policies Microsoft commercial marketplace general listing and offer policies apply to all publishers and offerings in the Microsoft commercial marketplace.
Published Date : Friday, September 30, 2022

Create and update statistics using Azure Synapse SQL resources - Azure Synapse Analytics

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics Recommendations and examples for creating and updating query-optimization statistics in Azure Synapse SQL.
Published Date : Friday, September 30, 2022

Power BI and serverless SQL pool to analyze Azure Cosmos DB data with Synapse Link

https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link-power-bi Learn how to build a serverless SQL pool database and views over Synapse Link for Azure Cosmos DB, query the Azure Cosmos DB containers and then build a model with Power BI over those views.
Published Date : Friday, September 30, 2022

Configure and use Azure Synapse Link for Azure Cosmos DB

https://docs.microsoft.com/en-us/azure/cosmos-db/configure-synapse-link Learn how to enable Synapse link for Azure Cosmos DB accounts, create a container with analytical store enabled, connect the Azure Cosmos database to Synapse workspace, and run queries.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for Australian Government ISM PROTECTED - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/australia-ism Details of the Australian Government ISM PROTECTED Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Frequently asked questions about Azure Synapse Link for Azure Cosmos DB

https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link-frequently-asked-questions Get answers to frequently asked questions about Synapse Link for Azure Cosmos DB in areas such as billing, analytical store, security, time to live on analytical store.
Published Date : Friday, September 30, 2022

Upgrade datastore management to SDK v2 - Azure Machine Learning

https://docs.microsoft.com/en-us/azure/machine-learning/migrate-to-v2-resource-datastore Upgrade datastore management from v1 to v2 of Azure Machine Learning SDK
Published Date : Friday, September 30, 2022

Configure private endpoints for Azure Cosmos DB analytical store.

https://docs.microsoft.com/en-us/azure/cosmos-db/analytical-store-private-endpoints Learn how to set up managed private endpoints for Azure Cosmos DB analytical store to restrict network access.
Published Date : Friday, September 30, 2022

What is Azure Cosmos DB analytical store?

https://docs.microsoft.com/en-us/azure/cosmos-db/analytical-store-introduction Learn about Azure Cosmos DB transactional (row-based) and analytical(column-based) store. Benefits of analytical store, performance impact for large-scale workloads, and auto sync of data from transactional store to analytical store
Published Date : Friday, September 30, 2022

Azure Synapse Link for Azure Cosmos DB, benefits, and when to use it

https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link Learn about Azure Synapse Link for Azure Cosmos DB. Synapse Link lets you run near real time analytics (HTAP) using Azure Synapse Analytics over operational data in Azure Cosmos DB.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for Canada Federal PBMM - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/canada-federal-pbmm Details of the Canada Federal PBMM Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for CIS Microsoft Azure Foundations Benchmark 1.3.0 (Azure Government) - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/gov-cis-azure-1-3-0 Details of the CIS Microsoft Azure Foundations Benchmark 1.3.0 (Azure Government) Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for CIS Microsoft Azure Foundations Benchmark 1.1.0 (Azure Government) - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/gov-cis-azure-1-1-0 Details of the CIS Microsoft Azure Foundations Benchmark 1.1.0 (Azure Government) Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for CIS Microsoft Azure Foundations Benchmark 1.3.0 - Azure Policy

https://learn.microsoft.com/en-us/azure/governance/policy/samples/cis-azure-1-3-0 Details of the CIS Microsoft Azure Foundations Benchmark 1.3.0 Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for IRS 1075 September 2016 (Azure Government) - Azure Policy

https://learn.microsoft.com/en-us/azure/governance/policy/samples/gov-irs-1075-sept2016 Details of the IRS 1075 September 2016 (Azure Government) Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for Azure Security Benchmark - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/azure-security-benchmark Details of the Azure Security Benchmark Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for CMMC Level 3 (Azure Government) - Azure Policy

https://learn.microsoft.com/en-us/azure/governance/policy/samples/gov-cmmc-l3 Details of the CMMC Level 3 (Azure Government) Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for PCI DSS 3.2.1 - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/pci-dss-3-2-1 Details of the PCI DSS 3.2.1 Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Near real-time analytics use cases with Azure Synapse Link for Azure Cosmos DB

https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link-use-cases Learn how Azure Synapse Link for Azure Cosmos DB is used in Supply chain analytics, forecasting, reporting, real-time personalization, and IOT predictive maintenance.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for UK OFFICIAL and UK NHS - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/ukofficial-uknhs Details of the UK OFFICIAL and UK NHS Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022

Regulatory Compliance details for New Zealand ISM Restricted - Azure Policy

https://docs.microsoft.com/en-us/azure/governance/policy/samples/new-zealand-ism Details of the New Zealand ISM Restricted Regulatory Compliance built-in initiative. Each control is mapped to one or more Azure Policy definitions that assist with assessment.
Published Date : Friday, September 30, 2022