Microsoft Docs – Últimos Artigos

Como a nova base da documentação técnica da Microsoft, o docs.microsoft.com não só modernizou a experiência Web para conteúdo, mas também o modo como criamos e damos suporte ao conteúdo que você usa para aprender, gerenciar e implantar soluções. É a escolha certa para tudo relacionado às tecnologias da Microsoft. Para garantir que fique por dentro de todas as novidades do docs.microsoft.com, criamos um feed dedicado para você.


Selected Feed: SQL

SCCM 2111 hardware inventory - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164144/sccm-2111-hardware-inventory Dears, we are facing strange problem on SCCM 2111 , it started after we did in place upgrade on windows server 2012 r2 to 2016 then upgraded SQL database from 2012 to 2019 , after 5 days we discovered that hardware inventory are no longer working or updating on clients , any thoughts about this problem ? Regards,
Published Date : domingo, 29 de janeiro de 2023

sspi handshake failed with error code 0x80090304 on SQL server after updating DC - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1091212/sspi-handshake-failed-with-error-code-0x80090304-o Dears , we have problem that started after we installed windows updates on our DCs in the environment , now when we are trying to connect remotely to sql database server we got the below errors kindly note that authentication works fine when we connect to the database from sql server itself with same user regards,
Published Date : domingo, 29 de janeiro de 2023

How to view Relation among Tables in Azure Data Studio - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1165093/how-to-view-relation-among-tables-in-azure-data-st I want to basically see the relation between tables in a schema, the extension is quite buggy. Like I am having a great experience with Azure Data Studio, and I was having great time with it, but I was hoping If in the next Azure Data Studio Update, we could get the ability to view the relationship b/w schema from the software itself. I have attached the image , this is from Dbeaver , and I am hoping we can get this feature in the next update this dbeaver and its ability to show me relation b/w tables is the only thing which is making me switch from Data Studio to Dbeaver , I was hoping if we could do the same with Azure Data Studio
Published Date : domingo, 29 de janeiro de 2023

Azure sql db instance is taking very long time for a simple select query . How can we improve his ? - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1165056/azure-sql-db-instance-is-taking-very-long-time-for Hi, I have this azure sql db instance I am having table in database which is having only 12000 rows. A week ago everything was working fine but suddenly since last 3 days even select query is taking very long time . See the snap. For fetching the 12000 rows it took almost 11 minutes Here is my azure sql db settings What happened to my azure sql db ? How can i improve the performance ?
Published Date : domingo, 29 de janeiro de 2023

Automating the Process of Checking Scale Out Deployment of SSRS using PowerShell - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1165063/automating-the-process-of-checking-scale-out-deplo I am currently working on a project that involves managing and maintaining a large number of SQL Server Reporting Services (SSRS) servers. One of the tasks that I need to perform is to check if the SSRS servers are configured for scale out deployment and what are the servers involved. Normally, I would log on to the SSRS server and use the SSRS Configuration Manager to check the deployment type. However, as the number of servers increases, this manual process becomes time-consuming and error-prone. I am looking for a way to automate this process and check the configuration of SSRS servers in a more efficient way. I have been researching and experimenting with PowerShell, and I believe that it may be a good solution for this task. I would greatly appreciate any help or guidance that anyone can provide in terms of a PowerShell script or command that can help me check the scale out deployment of SSRS. I am particularly interested in any tips or best practices for automating this process, and any pitfalls to watch out for. Any help or advice would be greatly appreciated, as I am still new to working with PowerShell and SSRS. Thank you in advance for your time and expertise.
Published Date : sábado, 28 de janeiro de 2023

Best options for creating modern C# database programs - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164995/best-options-for-creating-modern-c-database-progra Hello, I have been using Microsoft Access for a while to create programs for small business activities. I would like to create more modern programs using C# to take advantage of the new Microsoft technologies for the front-end and back-end database. What options would you recommend for me? Thank you in advance.
Published Date : sábado, 28 de janeiro de 2023

Export data to excel in .NET Core - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1165034/export-data-to-excel-in-net-core Hi All, I am developing an application in .NET Core with angular client. I have a scenario where user click on Download button and data from SQL Server will be exported to excel sheet in .NET Core WebAPI. The generated and downloaded sheet will display- Please let me know how can I achieve the same ASAP. Regards, Pratham
Published Date : sábado, 28 de janeiro de 2023

SQL Server Query to Add Column Titles to Existing Table in Server - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1165021/sql-server-query-to-add-column-titles-to-existing I imported a csv table that does not have column titles in a header row, as illustrated in the .png snip below: As you will note, the column titles are actually populated with data. I would like to obtain a SQL Server query to insert the following column titles: RPT, WKSHT,LINE,CLMN,AMT above the column row that currently contains the following data 667603,S200001,00300,00400,1. I have tried to accomplish this task by creating a second table with the desired column titles and running an append query to merger the two table. The query executed but resulted in duplication of many values. Thank you.
Published Date : sábado, 28 de janeiro de 2023

Parte 8, Razor Páginas com EF Core em ASP.NET Core – Simultaneidade

https://learn.microsoft.com/pt-br/aspnet/core/data/ef-rp/concurrency Parte 8 das Razor páginas e da série de tutoriais da Estrutura de Entidades.
Published Date : sábado, 28 de janeiro de 2023

SSIS - Database is read-only - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1165030/ssis-database-is-read-only Hello I've got an SSIS package that displays a database is read-only error (full error below) when running a Truncate table query from a SQL task . The data base is not read only as I can execute the same task successfully from another package. [Execute SQL Task] Error: Executing the query "TRUNCATE TABLE dbo.MyTableName" failed with the following error: "Failed to update database "mydBName" because the database is read-only.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. The properties are the same for each task ... Am I missing a property setting or something else in the package. Thanks in advance Ron
Published Date : sábado, 28 de janeiro de 2023

Unable to scan Azure SQL server DB in Purview due to complicated User access process - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/415661/unable-to-scan-azure-sql-server-db-in-purview-due I m unable to scan Azure SQL server DB in Purview due to complicated User access process . Error: (3867) Failed to access the Azure SQL database. The given credential has not been applied or does not have permission on the target database. Attached is the screenshot. The whole process is so complicated , not sure who designed it , truly just to scan a simple resource is a challenge. I have attached screenshot for reference. I have a key vault in the same region as the Purview is in. I know my Purview managed identity and how should it be mapped to provide access to SQL DB and PURVIEW ? I had provided Purview managed identity with owner access and yet it fails to connect
Published Date : sábado, 28 de janeiro de 2023

is there any security thread by using SQL "BCP" commands - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164998/is-there-any-security-thread-by-using-sql-bcp-comm is there any security thread by using SQL "BCP" (xp_cmdshell 'bcp') commands?
Published Date : sábado, 28 de janeiro de 2023

How to restore azure sql server database from .bak file located in blob storage automatically with sql server agent jobs - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1160862/how-to-restore-azure-sql-server-database-from-bak Hi! My current setup consists of a blob storage account cointaining .bak backup files, in addition to an SQL server running on an Azure Virtual Machine. I want to automatically restore the database located at the sql server every night (when a new .bak file will arrive to the blob container). Our plan was to set up a SQL Server Agent Job which is scheduled every night, which restores the wanted database from the newest .bak file in the blob container (note the .bak file has the same name every time so it will just be overwritten). We have almost managed to get the T-SQL script for the restore operation to work, but are struggeling with the SQL SERVER AGENT not having permission to restore the database. We have set the user that runs the restore step of the job to be the DBO user. We get the following error message: Executed as user: dbo. User does not have permission to alter database 'XXXXX', the database does not exist, or the database is not in a state that allows access checks. [SQLSTATE 42000] (Error 5011) ALTER DATABASE statement failed. [SQLSTATE 42000] (Error 5069) Cannot open backup device 'https://....blob.core.windows.net....../.bak'. Operating system error 13(The data is invalid.). [SQLSTATE 42000] (Error 3201) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. The T-SQL code for the restore step of the job is: ALTER DATABASE XXXXX SET TRUSTWORTHY ON RESTORE DATABASE [....] FROM URL = 'https://......blob.core.windows.net/.....bak' GO NOTE: We have already saved the CREDENTIAL containnig the SAS-key for the blob storage, therefore it is not in the current T-SQL script. Is there something we have to do in SSMS to make the SQL Server Agent Job manage to perform the restore? i am able to do the restore manually using the GUI, but not by using T-SWL in server agent job. Thanks in advance!
Published Date : sábado, 28 de janeiro de 2023

SQL Server no sistema operacional Windows - SQL Server

https://learn.microsoft.com/pt-br/troubleshoot/sql/general/use-sql-server-in-windows Este artigo descreve como usar o SQL Server ambientes Windows 8, Windows 8.1, Windows Server 2012 e Windows Server 2012 R2.
Published Date : sábado, 28 de janeiro de 2023

Tempo limite de mensagens expiradas ao se conectar ao SQL Server - SQL Server

https://learn.microsoft.com/pt-br/troubleshoot/sql/database-engine/connect/timeout-expired-error Corrige erros de tempo limite expirados quando você se conecta ao SQL Server e ajuda a verificar e solucionar os erros.
Published Date : sábado, 28 de janeiro de 2023

Suporte de software do servidor Microsoft para Microsoft Azure Máquinas Virtuais - Virtual Machines

https://learn.microsoft.com/pt-br/troubleshoot/azure/virtual-machines/server-software-support Discute a política de suporte para software do servidor Microsoft em um ambiente de Máquina Virtual do Microsoft Azure.
Published Date : sábado, 28 de janeiro de 2023

sql server management studio infected by Ransom malware - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164977/sql-server-management-studio-infected-by-ransom-ma hello community members Greeting of the day Any here who can help me or guide me to recover the infected file , my server is attacked by ransom malware and all database file are converted in .mallox extension , i want to recover the data from infected file. thanks you in advance #sqlserverstudio #malware
Published Date : sábado, 28 de janeiro de 2023

Bicep to deploy Azure SQL VM through Azure DevOps CI/CD - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164768/bicep-to-deploy-azure-sql-vm-through-azure-devops Hello Team, I'm trying to create Azure SQLVM using Bicep through Azure Pipeline. What tasks need to add in Pipeline for the same? What contents should be yaml file? Previously I did create SQLVM using the below link VM bicep.jpg [https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/create-sql-vm-bicep?view=azuresql&tabs=CLI Is it possible to create the above using Azure CICD Pipeline? Can Someone Elight the exact steps to create Pipeline for the above? Thanks, Rahul
Published Date : sábado, 28 de janeiro de 2023

Firewall rules for Azure App service, and Azure SQL Managed Instance - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1160971/firewall-rules-for-azure-app-service-and-azure-sql Hi Team, I have a requirement where I need to deploy below 2.a. Code (.net) from a Github pipeline to IIS of an Azure Virtual machine. b. Migrate an on-premises SQL Server to another SQL Server on an Azure Virtual machine. Can you please mention the firewall rules for 1a, 1b and 2a, 2b. please let me know if more information required from my side. Thanks, Salil
Published Date : sábado, 28 de janeiro de 2023

How to enable azure sql vm database in recovery vault using powershell - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1160994/how-to-enable-azure-sql-vm-database-in-recovery-va How to enable azure sql server on azure virtual machine which is item type sql database/sql instance./sql ag level database using powershell shell script please let me know if any automation via script
Published Date : sábado, 28 de janeiro de 2023

get back my sql virtual machine - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1162720/get-back-my-sql-virtual-machine I had to Recreate my virtual machine from the original disk because I had created the machine in a wrong virtual network. Now I realize that I have lost my SQL Virtual machine. How can I get it again. Regards,
Published Date : sábado, 28 de janeiro de 2023

Oracle on-premise database not connecting to Purview - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164961/oracle-on-premise-database-not-connecting-to-purvi Hi, I'm trying to connect on-premise oracle database to Purview but I keep getting the error : Error: (3913) JavaException: Java cannot be found. Please install and add to Path. I installed Java and gave the path: C:\Users\myusername\Documents\java\jar . Can someone help identify the issue ? The integration runtime is running on the machine as well. We have another SQL on-prem db using the same SHIR and connecting to Purview just fine. Thanks
Published Date : sábado, 28 de janeiro de 2023

I understand that elastic jobs are not supported when using private end points using azure sql db,are elastic database querries supported - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164945/i-understand-that-elastic-jobs-are-not-supported-w gettting the following error when trying to use elastic database query in azure sqldatabase trying to connect to a azure sql database using private end point from another azure sqldatabase getting the error failed (error -2146893022, state 0): A connection was successfully established with the server, but then an error occurred during the login pro cess. (provider: SSL Provider, error: 0 - The target principal name is incorrect.)
Published Date : sábado, 28 de janeiro de 2023

Gerenciar a chave de criptografia - Power Platform

https://learn.microsoft.com/pt-br/power-platform/admin/manage-encryption-key Saiba como você pode gerenciar a chave de criptografia do banco de dados de seu ambiente.
Published Date : sábado, 28 de janeiro de 2023

error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO during React install GET package - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/1164962/error-1407742e-ssl-routines-ssl23-get-server-hello I am completely new to Azure. We host an app service on Azure which comprises git version control, a node / ReactJS Frontend and a C# .NET Backend, which talks to an SQL Server Database and this deploys automatically when code is merged to the relevant branch (one app service for staging and one for development), installing the React App and building the .NET from scratch each time. We have made like this about several deployments this year and I'd say tens of deployments last year, all successful. I'm pretty sure nothing about the configuration of the app service has changed in this time, we have only redeployed the code. The last 2 or 3 deployments over a 2 day period failed during the React Web App installation, though the React installs successfully locally. The React install retrieves about 180 packages in this way... npm http GET https://registry.npmjs.org/<package name> These three recent deployments fail once each at differing points during the full 180 package retrievals with the following error passed up by the npm package: This causes the overall build to fail. At first glance this seems to me likely some kind of intermitent / dynamic / dependant comms issue, rather than a React install issue, given each failure is not at the same package GET and the install is successful locally. Is anyone able to confirm this likelihood and suggest any further investigations or is aware of any recent issues on Azure which may possibly lead to these symptoms and when these recent issue may be resolved? Or alternatively how this might actually be an issue with the deployed code and why it might only fail on deployment? Many thanks indeed.
Published Date : sábado, 28 de janeiro de 2023

Usar a autenticação do Azure Active Directory com o SqlClient - ADO.NET Provider for SQL Server

https://learn.microsoft.com/pt-br/sql/connect/ado-net/sql/azure-active-directory-authentication Descreve como usar os modos de autenticação do Azure Active Directory com suporte para se conectar a fontes de dados do SQL do Azure com o SqlClient
Published Date : sexta-feira, 27 de janeiro de 2023

Exibir bancos de dados do SQL Server - SQL Server

https://learn.microsoft.com/pt-br/sql/sql-server/azure-arc/view-databases Veja os bancos de dados no Azure de uma instância do SQL Server habilitada para Azure Arc. Use para bancos de dados de inventário e para ver propriedades de bancos de dados centralmente, como recursos habilitados para Arc.
Published Date : sexta-feira, 27 de janeiro de 2023

Criar recurso DTC clusterizado para um grupo de disponibilidade - SQL Server Always On

https://learn.microsoft.com/pt-br/sql/database-engine/availability-groups/windows/create-clustered-dtc-for-an-always-on-availability-group Este tópico descreve uma configuração completa de um recurso DTC clusterizado para o Grupo de Disponibilidade AlwaysOn do SQL Server.
Published Date : sexta-feira, 27 de janeiro de 2023

Sqlcmd utility - Start the sqlcmd utility - SQL Server

https://docs.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-start-utility Learn how to start the sqlcmd utility, which lets you enter Transact-SQL statements, system procedures, and script files, in SQLCMD mode or in scripts and jobs.
Published Date : sexta-feira, 27 de janeiro de 2023

Sqlcmd utility - Run Transact-SQL script files - SQL Server

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-run-transact-sql-script-files Learn how to use sqlcmd to run a Transact-SQL script file. It can contain Transact-SQL statements, sqlcmd commands, and scripting variables.
Published Date : sexta-feira, 27 de janeiro de 2023

Sqlcmd utility - Use the sqlcmd utility - SQL Server

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-use-utility Learn how to use the sqlcmd utility for ad hoc interactive execution of Transact-SQL statements and scripts, and automate Transact-SQL scripting tasks.
Published Date : sexta-feira, 27 de janeiro de 2023

Sqlcmd utility - Connect to the database engine with sqlcmd - SQL Server

https://docs.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-connect-database-engine Learn how to select which protocol sqlcmd uses to communicate with SQL Server. The choices are: TCP/IP, named pipes, and shared memory.
Published Date : sexta-feira, 27 de janeiro de 2023

sqlcmd Utility - SQL Server

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files using different modes, and uses ODBC to run Transact-SQL batches.
Published Date : sexta-feira, 27 de janeiro de 2023

Sqlcmd utility - Edit SQLCMD scripts with Query Editor - SQL Server

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/edit-sqlcmd-scripts-query-editor You use SQLCMD scripts when you have to process Windows System commands and Transact-SQL statements in the same script. Learn how to write and edit SQLCMD scripts using the Database Engine Query Editor.
Published Date : sexta-feira, 27 de janeiro de 2023

Sqlcmd utility - Use scripting variables - SQL Server

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-use-scripting-variables Learn how to use scripting variables to make a script that that can be used in multiple scenarios.
Published Date : sexta-feira, 27 de janeiro de 2023

go-sqlcmd utility - SQL Server

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/go-sqlcmd-utility The go-sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files using different modes.
Published Date : sexta-feira, 27 de janeiro de 2023

Novidades no Servidor de Relatório do Power BI - Power BI

https://learn.microsoft.com/pt-br/power-bi/report-server/whats-new Saiba mais sobre as novidades na atualização mais recente do Servidor de Relatórios do Power BI. Este artigo aborda as principais áreas de recursos e é atualizado conforme novas versões são lançadas.
Published Date : sexta-feira, 27 de janeiro de 2023

Farm de servidores de federação usando SQL Server

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/federation-server-farm-using-sql-server Saiba mais sobre: Farm de Servidores de Federação do AD FS herdado usando SQL Server
Published Date : sexta-feira, 27 de janeiro de 2023

Configurar redundância geográfica com Replicação do SQL Server

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/set-up-geographic-redundancy-with-sql-server-replication Saiba mais sobre: Configurar redundância geográfica com Replicação do SQL Server
Published Date : sexta-feira, 27 de janeiro de 2023

Farm de Servidores de Federação do AD FS usando SQL Server

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/federation-server-farm-using-sql-server-2012 Saiba mais sobre: Farm de Servidores de Federação usando SQL Server
Published Date : sexta-feira, 27 de janeiro de 2023

Migrar um farm AD FS servidor de federação do SQL 2.0

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/migrate-ad-fs-sql-farm Fornece informações sobre como migrar um farm de AD FS 2.0 para SQL para Windows Server 2012
Published Date : sexta-feira, 27 de janeiro de 2023

Atualizando para o AD FS em Windows Server 2016 com SQL Server

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/upgrading-to-ad-fs-in-windows-server-sql Saiba mais sobre: Atualizando para o AD FS em Windows Server 2016 com SQL Server
Published Date : sexta-feira, 27 de janeiro de 2023

preparar para migrar um farm de SQL AD FS

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/prepare-to-migrate-a-sql-server-farm fornece informações sobre como preparar-se para migrar um farm de SQL do AD FS server para o Windows Server 2012.
Published Date : sexta-feira, 27 de janeiro de 2023

Práticas recomendadas para o planejamento e a implantação seguros do AD FS

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/best-practices-for-secure-planning-and-deployment-of-ad-fs Saiba mais sobre: Práticas recomendadas para planejamento seguro e implantação do AD FS
Published Date : sexta-feira, 27 de janeiro de 2023

Considerações sobre a topologia de implantação do AD FS

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/ad-fs-deployment-topology-considerations Saiba mais sobre: Considerações sobre topologia de implantação do AD FS
Published Date : sexta-feira, 27 de janeiro de 2023

Quando criar um farm de servidor de federação

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/when-to-create-a-federation-server-farm Saiba mais sobre: Quando criar um farm de servidores de federação
Published Date : sexta-feira, 27 de janeiro de 2023

Farm de servidores de federação usando WID

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/federation-server-farm-using-wid Saiba mais sobre: Farm de Servidores de Federação do AD FS Herdado usando WID
Published Date : sexta-feira, 27 de janeiro de 2023

Determinar a topologia de implantação do AD FS

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/determine-your-ad-fs-deployment-topology Saiba mais sobre: determinar sua topologia de implantação de AD FS
Published Date : sexta-feira, 27 de janeiro de 2023

Requisitos do AD FS para Windows Server

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/ad-fs-requirements Saiba mais sobre: Requisitos do AD FS para Windows Server
Published Date : sexta-feira, 27 de janeiro de 2023

Migrar um servidor de federação AD FS autônomo ou um farm de AD FS de nó único

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/migrate-ad-fs-stand-alone-server Fornece informações sobre como migrar um servidor autônomo ou de nó AD FS 2.0 para Windows Server 2012
Published Date : sexta-feira, 27 de janeiro de 2023

Preparar para migrar o servidor AD FS 2.0 federation para AD FS no Windows Server 2012 R2

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/prepare-migrate-ad-fs-server-r2 Fornece informações sobre como se preparar para migrar o servidor AD FS para Windows Server 2012 R2.
Published Date : sexta-feira, 27 de janeiro de 2023

Farm de servidores de federação usando WID e proxies

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/federation-server-farm-using-wid-and-proxies Saiba mais sobre: Farm de Servidores de Federação do AD FS herdado usando WID e Proxies
Published Date : sexta-feira, 27 de janeiro de 2023

Migrar o servidor AD FS de federação do AD FS 2.0

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/migrate-the-ad-fs-fed-server Saiba mais sobre o ponto de partida para migrar seu servidor de federação AD FS 2.0 para Windows Server 2012.
Published Date : sexta-feira, 27 de janeiro de 2023

Configurar manualmente uma conta de serviço para um farm de servidores de federação

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/manually-configure-a-service-account-for-a-federation-server-farm Saiba mais sobre: Configurar manualmente uma conta de serviço para um farm de servidores de federação
Published Date : sexta-feira, 27 de janeiro de 2023

Quando criar um Servidor de Federação

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/when-to-create-a-federation-server Saiba mais sobre: Quando criar um servidor de federação
Published Date : sexta-feira, 27 de janeiro de 2023

migrar o servidor de federação AD FS 2,0 para Windows Server 2012 R2

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/migrate-ad-fs-fed-server-r2 saiba como exportar e fazer backup dos dados de configuração de AD FS, criar um farm de servidores de federação do Windows Server 2012 r2 e importar os dados de configuração originais para o farm de AD FS do Windows Server 2012 r2.
Published Date : sexta-feira, 27 de janeiro de 2023

Preparar para migrar o servidor de federação do AD FS 2.0

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/prepare-to-migrate-ad-fs-fed-server Fornece informações sobre como se preparar para migrar o servidor AD FS para Windows Server 2012.
Published Date : sexta-feira, 27 de janeiro de 2023

Design SSO da Web

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/web-sso-design Saiba mais sobre: Design de SSO da Web
Published Date : sexta-feira, 27 de janeiro de 2023

Preparar para migrar um servidor de Federação AD FS autônomo

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/prepare-to-migrate-a-stand-alone-ad-fs-federation-server Saiba como exportar e fazer backup dos dados de configuração do AD FS deste servidor.
Published Date : sexta-feira, 27 de janeiro de 2023

Apêndice A – Revisão dos requisitos do AD FS

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/appendix-a--reviewing-ad-fs-requirements Saiba mais sobre: Apêndice A: Revisão dos requisitos do AD FS
Published Date : sexta-feira, 27 de janeiro de 2023

Quando usar a delegação de identidade

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/when-to-use-identity-delegation Saiba mais sobre: Quando usar a delegação de identidade
Published Date : sexta-feira, 27 de janeiro de 2023

Planejando a capacidade do servidor do AD FS

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/planning-for-ad-fs-server-capacity Saiba mais sobre: Planejando a capacidade do servidor do AD FS
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de desativação do AD FS (Serviços de Federação do Active Directory (AD FS))

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/decommission/adfs-decommission-guide Descreve a maneira recomendada de desativar servidores Serviços de Federação do Active Directory (AD FS) (AD FS).
Published Date : sexta-feira, 27 de janeiro de 2023

Lista de verificação – Configurar um servidor de federação

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/checklist--setting-up-a-federation-server Saiba mais sobre: Lista de verificação: configurando um servidor de federação
Published Date : sexta-feira, 27 de janeiro de 2023

Lista de verificação – Configurando a organização do Resource Partner

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/checklist--configuring-the-resource-partner-organization Saiba mais sobre: Lista de verificação: Configurando a Organização do Resource Partner
Published Date : sexta-feira, 27 de janeiro de 2023

Cenário de delegação de identidade com o AD FS

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/development/ad-fs-identity-delegation Esse cenário descreve um aplicativo que precisa acessar recursos de back-end que exigem que a cadeia de delegação de identidade execute verificações de controle de acesso.
Published Date : sexta-feira, 27 de janeiro de 2023

Lista de verificação – Configurando a organização do parceiro de conta

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/checklist--configuring-the-account-partner-organization Saiba mais sobre: Lista de verificação: Configurando a organização de parceiros de conta
Published Date : sexta-feira, 27 de janeiro de 2023

Criar um aplicativo de várias camadas usando OBO (On-Behalf-Of) usando o OAuth com o AD FS 2016 ou posterior

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/development/ad-fs-on-behalf-of-authentication-in-windows-server Saiba mais sobre: Criar um aplicativo de várias camadas usando o OBO (On-Behalf-Of) usando o OAuth com o AD FS 2016 ou posterior
Published Date : sexta-feira, 27 de janeiro de 2023

Atualizando para o AD FS em Windows Server 2016 e 2019

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/upgrading-to-ad-fs-in-windows-server Saiba mais sobre: Atualizar para o AD FS no Windows Server 2016 e 2019 usando um banco de dados WID
Published Date : sexta-feira, 27 de janeiro de 2023

Atualizações necessária para Serviços de Federação do Active Directory (AD FS) (AD FS)

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/deployment/updates-for-active-directory-federation-services-ad-fs Saiba mais sobre: Atualizações necessária para Serviços de Federação do Active Directory (AD FS) (AD FS) e WAP (Web Proxy de Aplicativo)
Published Date : sexta-feira, 27 de janeiro de 2023

Fornecer a seus usuários do Active Directory acesso a aplicativos e serviços com reconhecimento de declarações

https://learn.microsoft.com/pt-br/windows-server/identity/ad-fs/design/provide-your-active-directory-users-access-to-your-claims-aware-applications-and-services Saiba mais sobre: fornecer aos usuários do Active Directory acesso aos aplicativos e serviços com reconhecimento de declarações
Published Date : sexta-feira, 27 de janeiro de 2023

Sql Server Configuration Manager not showing in windows 10 - Microsoft Q&A

https://learn.microsoft.com/en-us/answers/questions/166724/sql-server-configuration-manager-not-showing-in-wi Hi. I am trying to setup sql management studio and i cant connect to a server name. Been trying to find the sql config manager but i cant find it anywhere on my computer, and i have searched on youtube and on google and tried many solutions but i simply cant solve it. Even checked my firewall if it blocks the ports etc. Im not very good at this so please how do i solve this? Is it possible to download the configuration manager somewhere? I have been trying to look for it but i cant find any download link. Here is what it says: TITLE: Connect to Server A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
Published Date : sexta-feira, 27 de janeiro de 2023

Associações de SQL do Azure para o Functions

https://learn.microsoft.com/pt-br/azure/azure-functions/functions-bindings-azure-sql Entenda como usar as associações de SQL do Azure no Azure Functions.
Published Date : sexta-feira, 27 de janeiro de 2023

Tutorial: Registrar e examinar um SQL Server local - Microsoft Purview

https://learn.microsoft.com/pt-br/azure/purview/tutorial-register-scan-on-premises-sql-server Este tutorial descreve como registrar um SQL Server local para o Microsoft Purview e verificar o servidor usando um IR auto-hospedado.
Published Date : sexta-feira, 27 de janeiro de 2023

Azure AD Connect: conta de serviço do ADSync - Microsoft Entra

https://learn.microsoft.com/pt-br/azure/active-directory/hybrid/concept-adsync-service-account Este tópico descreve a conta de serviço do ADSync e fornece as melhores práticas relacionadas a ela.
Published Date : sexta-feira, 27 de janeiro de 2023

Saiba mais sobre as fontes de dados com suporte no Azure Analysis Services

https://learn.microsoft.com/pt-br/azure/analysis-services/analysis-services-datasource Descreve as fontes de fonte de dados e os conectores com suporte para modelos de dados tabulares nos níveis de compatibilidade 1200 e superior no Azure Analysis Services.
Published Date : sexta-feira, 27 de janeiro de 2023

Estender scripts U-SQL com R no Azure Data Lake Analytics

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-r-extensions Saiba como executar o código R em scripts U-SQL usando o Azure Data Lake Analytics. Inserir o código R embutido ou referência dos arquivos.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação do redutor definido pelo usuário do U-SQL para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-reducer Saiba mais sobre o guia de programação do redutor definido pelo usuário UDO do U-SQL.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação de U-SQL UDO para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-udo Saiba mais sobre a programação de UDO do U-SQL que o Azure Data Lake Analytics para permitir que você crie bons scripts USQL.
Published Date : sexta-feira, 27 de janeiro de 2023

Gerenciar assemblies do U-SQL em um pipeline de CI/CD ꟷ Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-cicd-manage-assemblies Conheça as práticas recomendadas para gerenciar assemblies de C# do U-SQL em um pipeline de CI/CD com o Azure DevOps.
Published Date : sexta-feira, 27 de janeiro de 2023

Recursos Cognitivos do U-SQL no Azure Data Lake Analytics

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-cognitive Saiba como usar a inteligência de recursos Cognitivos no U-SQL. Esses exemplos de código ajudam você a começar.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação do aplicador definido pelo usuário do U-SQL para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-applier Saiba mais sobre o guia de programação do U-SQL UDO – aplicador definido pelo usuário.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação do redutor definido pelo usuário do U-SQL para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-outputter Saiba mais sobre o guia de programação do redutor definido pelo usuário UDO do U-SQL.
Published Date : sexta-feira, 27 de janeiro de 2023

Exportar banco de dados U-SQL - Ferramentas do Azure Data Lake para Visual Studio

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-data-lake-tools-export-database Saiba como usar as Ferramentas do Azure Data Lake para Visual Studio para exportar um banco de dados U-SQL e importá-lo automaticamente em uma conta local.
Published Date : sexta-feira, 27 de janeiro de 2023

Use o catálogo de U-SQL no Azure Data Lake Analytics

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-catalog Saiba como usar o catálogo do U-SQL para compartilhar códigos e dados. Crie funções com valor de tabela, crie exibições, crie tabelas e consulte-as.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação do combinador definido pelo usuário do U-SQL para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-combiner Saiba mais sobre o guia de programação do U-SQL UDO – combinador definido pelo usuário.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação do processador definido pelo usuário do U-SQL para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-processor Saiba mais sobre o guia de programação do processador definido pelo usuário UDO do U-SQL.
Published Date : sexta-feira, 27 de janeiro de 2023

Como solucionar problemas de falhas de runtime U-SQL do Azure Data Lake Analytics

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/runtime-troubleshoot Saiba como solucionar problemas de falhas de runtime U-SQL.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação do extrator definido pelo usuário do U-SQL para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-extractor Saiba mais sobre o guia de programação do extrator definido pelo usuário UDO do U-SQL.
Published Date : sexta-feira, 27 de janeiro de 2023

Guia de programação UDT e UDAGG de U-SQL para o Azure Data Lake

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide-udt-agg Saiba mais sobre a programação UDT e UDAGG do U-SQL no Azure Data Lake Analytics para permitir que você crie bons scripts USQL.
Published Date : sexta-feira, 27 de janeiro de 2023

Desenvolver operadores U-SQL definidos pelo usuário - Azure Data Lake Analytics

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-develop-user-defined-operators Saiba como desenvolver operadores definidos pelo usuário para serem usados e reutilizados em trabalhos do Azure Data Lake Analytics.
Published Date : sexta-feira, 27 de janeiro de 2023

Executar trabalhos U-SQL em Python, R e C# – Azure Data Lake Analytics

https://learn.microsoft.com/pt-br/azure/data-lake-analytics/data-lake-analytics-u-sql-develop-with-python-r-csharp-in-vscode Saiba como usar o code-behind com Python, R e C# ao enviar o trabalho no Azure Data Lake.
Published Date : sexta-feira, 27 de janeiro de 2023