Документация Майкрософт — новейшие статьи
Теперь техническая документация Майкрософт размещена на сайте docs.microsoft.com. Мы модернизировали не только веб-интерфейс, но и методы создания и поддержки материалов, которые помогают вам обучаться, развертывать решения и управлять ими. Это централизованное расположение для всего содержимого, связанного с технологиями Майкрософт. Чтобы вы не пропустили самые актуальные новости и интересные публикации на сайте docs.microsoft.com, мы предусмотрели для вас возможность выбрать требуемый веб-канал.
Selected Feed: SQL
Error message "com.databricks.sql.cloudfiles.errors.CloudFilesIOException: Failed to write to the schema log at location". Databricks notebook is encountering an issue while writing to the schema log in Databricks Cloud Files. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1179238/error-message-com-databricks-sql-cloudfiles-errors Hello everyone and nice to meet you! :-) Does anyone have any clue of what could be the issue with the following error message? It is concerning configuring schema inference and evolution in Auto Loader Configure schema inference and evolution in Auto Loader - Azure Databricks | Microsoft Learn Specifically when running something similar to the following commands in a python file in terraformPublished Date : 28 марта 2023 г.
Can I move an SQL elastic pool from a DTU based model to a Hyperscale Serverless model ? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193513/can-i-move-an-sql-elastic-pool-from-a-dtu-based-mo Hi we have 8 databases sitting in a 200 DTU elastic pool - 7 of the databases are small and aren't used much one is large in comparison (~900Gb) and heavily used in an overnight batch process and occasionally during the day. We are now getting to the limits of the size we can use in an elastic pool and it makes sense to move this to hyperscale, ideally serverless hyperscale as we think this may give us the best flexibility in terms scalability going forward. The serverless option looks good in terms of costing for what we are doing where the database is quiet most of the day and busy for about 1-2 hours a day. However I cannot see an option to move the elastic pool to hyperscale (see image attached) - is this available for elastic pools - if not - is the best option to move the all the databases individually to serverless hyperscale or maybe just the busy larger one and the other 7 to some minimal other service ? Many thanks, RichardPublished Date : 28 марта 2023 г.
Synapse Analytics pipeline error: ErrorCode=PolybaseOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse. Operation: 'Polybase operation'.,Source=Microsoft.Data - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193520/synapse-analytics-pipeline-error-errorcode-polybas Hello there! I try to copy SQL server tables to a SQL pool using a pipeline of Synapse Analytics and a Copy data activity, but I receive this error message: Synapse Analytics pipeline error: ErrorCode=PolybaseOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse. Operation: 'Polybase operation'.,Source=Microsoft.Data I use the PolyBase method and enable the staging in the Copy data activity to optimize the performance. The Bulk insert method completes the run without error, but it's too slow (some tables reach millions of rows). Thank you for the help! Regard, FabioPublished Date : 28 марта 2023 г.
Where can I buy license SQL server 2017 Standard - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193409/where-can-i-buy-license-sql-server-2017-standard I have an azure virtual machine running SQL server 2017 Express on windows server 2016 data center. Now I want to upgrade to the standard edition, where can I buy a license?Published Date : 28 марта 2023 г.
saving png image to the database - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192697/saving-png-image-to-the-database I am trying to save a .png image to the database. I have a field in database called sign with type varbinary(max) and I have following in the Model: public partial class EmployeeInfo { } below is my view: SignaturedataURL is already getting saved in the database as you can see: I want to save a .png image to the database. I have the following code in my controller: string path = Path.GetTempPath(); Instead of saving Signature.png to this path, I want to save signature.png to the database field Sign[]. How can I save the .png to the database field "sign".Published Date : 28 марта 2023 г.
validate jwt tokens inside stored procedure - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193552/validate-jwt-tokens-inside-stored-procedure Hi I have an azure api (web api) that access an azure sql database. The access to azure sql is secured by the user managed identity of the api service. As an additional security layer i want to pass the bearer access token to a stored procedure and validate. Is there any SQL Server built-in functionality to validate an AzureAD access token and extract claims and scopes? regards, BSDBPublished Date : 28 марта 2023 г.
How to use Dataflows/CDC feature in data factory with Self hosted Integration Runtime - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193589/how-to-use-dataflows-cdc-feature-in-data-factory-w Hello team, I wanted to use CDC feature of Azure Data factory. We have a on-premise SQL server we are connecting to through Self hosted integration runtime(SHIR). Is it possible to use CDC or Data flows with SHIR. If not, is there a workaround for it. Or can we connect to on-premise SQL through Azure Integration runtime? Also, I am not sure if it is correct to use Azure Integration runtime to connect to on-prem SQL server or not ThankyouPublished Date : 28 марта 2023 г.
Constraints when using Microsoft Defender for Cloud and Azure Sentinel and Azure Arc against on-premises outside of Azure - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192709/constraints-when-using-microsoft-defender-for-clou I would like to use Microsoft Defender for Cloud and Azure Sentinel and Azure Arc to protect on-premises servers that exist outside of Azure. Microsoft Defender for Cloud and Azure Sentinel and Azure Arc features fall into which of the following categories? ・A function that can be used for on-premises servers that exist outside of Azure ・Functions that cannot be used ・For on-premises use, VPN Gateway or Azure ExpressRoute to connect on-premises to the Azure virtual network I have been unable to understand what features of Microsoft Defender for Cloud and Azure Sentinel and Azure Arc are available for on-premises servers that reside outside of Azure. Can you please tell me in detail.🥺Published Date : 28 марта 2023 г.
From Azure to PowerBI cloud cost management reporting - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193734/from-azure-to-powerbi-cloud-cost-management-report Thesis writer issue is "How can we fetch the data from Azure to Power BI, which was not included in Azure Cost management connector to Power Bi and how are we able to separate some sort of Netapps between our business areas. In Power BI Data hub we are able to pick up several datasets and one of them might be a connector to Azure Cost Management and other one, as a more detailed data we need, could be a Powershell coded REST API call to Azure SQL server." Any recommendation of best practices?Published Date : 28 марта 2023 г.
Reporting Services exception logged when calling Extensions rest api - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193698/reporting-services-exception-logged-when-calling-e Whenever a user calls the "Reports/api/v2.0/Extensions" GET method of reporting services Rest API, the following error is logged in the ReportingServicesService log file: library!ReportServer_0-1!472c!03/28/2023-09:32:14:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly Microsoft.ReportingServices.Cloud.DataExtensions, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. The system cannot find the file specified. at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String name) --- End of inner exception stack trace ---;extensionfactory!ReportServer_0-1!472c!03/28/2023-09:32:14:: e ERROR: Exception caught instantiating DAX report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. The system cannot find the file specified. And I checked my "C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\rsreportserver.config", there's no DAX extension at all, so I was wondering what it's instantiating DAX report server extension and how can I remove it or how to get rid of this error log Thanks in advance.Published Date : 28 марта 2023 г.
How to execute SP_SET_SESSION_CONTEXT from dataflow - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192126/how-to-execute-sp-set-session-context-from-dataflo Hi everyone, In my database i have RLS setup using session variables. i need to execute "EXEC SP_SET_SESSION_CONTEXT" every time before getting data. based on the session variables values SQL server return the data. How can I execute "EXEC SP_SET_SESSION_CONTEXT" in ADF dataflow. Please anybody help me out on this.Published Date : 28 марта 2023 г.
can we pump sql table in azure cognitive search using C# code? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192502/can-we-pump-sql-table-in-azure-cognitive-search-us can we pump the SQL table in azure cognitive search using the C# code? One approach is available to add JSON format documents in the azure cognitive search index on Microsoft learning document. But can we do this by writing a SQL query and the index should be created in the same format as the SQL column with all the records?Published Date : 28 марта 2023 г.
Rename a column name (containing dot in it) of a table - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190667/rename-a-column-name-(containing-dot-in-it)-of-a-t I want to change a column name of a table . But issue is that column name is containing dot in it . which is creating issue while I am executing below statement.:- I can not drop the table as it contains huge and important dataPublished Date : 28 марта 2023 г.
SSMS- I want to pickup only first record and remove duplicate values from the column - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193417/ssms-i-want-to-pickup-only-first-record-and-remove I am using SQL Server 2019, I have a table which has attendance data. In this attendance column there are multiple attendance entries for the same employee ID but I want to pickup only first entry when he swiped in and remaining entries I want to delete other entries. ex- 2023-03-23 21:07:47.000 2023-03-23 02:27:38.000 from above column (datetime data type) I want only '2023-03-23 02:27:38.000' and i want to delete other entries. This is not static.Published Date : 28 марта 2023 г.
Auto-pause not turning on for serverless database - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193574/auto-pause-not-turning-on-for-serverless-database I have a serverless database in which the Auto-pause delay is not turning on, I have selected 1 hour and 2 hours and when the update completes it shows 0 days, 0 hours, 0 minutes. What cold be the reason for this? It is set as "General Purpose (most budget friendly, serverless computer), Standard Series (Gen5), Max Vcores 80, min vCores 10. LuisPublished Date : 28 марта 2023 г.
Azure Subscription: The client 'live.com#' with object id '' does not have authorization to perform action - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193583/azure-subscription-the-client-live-com-with-object When I try to open my azure subscription I get the following Info: The client 'live.com#' with object id '' does not have authorization to perform actionPublished Date : 28 марта 2023 г.
Do we have direct connector to connect delta share(Delta table) and load data into Azure SQL database? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191312/do-we-have-direct-connector-to-connect-delta-share Description: Using Delta Share Concept, we tried to load the data from Data brick notebook by creating Delta Share CatLog. Data provider has given the delta table access to Data receiver. However this approach need to built Data brick Notebook and need additional maintenance also data receiver has not installed data brick workspace. To overcome this additional activities, we need direct connector to connect delta share CatLog and load into our Destination Azure SQL database table. Also, Is there any 3rd party tool available? so that we can connect directly to delta share(Delta table) and load data directly into Azure SQL?Published Date : 28 марта 2023 г.
How to generate a JSON file in ADF from SQL table source based on a pre-defined JSON structure? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193503/how-to-generate-a-json-file-in-adf-from-sql-table Hi There, I'm trying to create a JSON file based ofa pre-defined structure. The source is a existing SQL Table in Azure. To achieve this i've uploaded the json file to the datalake and created a 'dataset' to that file. In a copy activity the mapping schema loads propperly and I can even map the fields as I need. However when I run the activity an error occurs no matter what I try. The unfortunate thing is that the error does not contain any message. The JSON structure looks like below. In which the 'field' fields need to be populated from the SQL Table. Does anyone have any experience in mapping SQL table source to JSON sink? Any help would be greatly appreciated.Published Date : 28 марта 2023 г.
Installing mssql in Ubuntu 22.04 - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193556/installing-mssql-in-ubuntu-22-04 Hi all, Is mssql server installation is supported in Ubuntu 22.04 officially as of today. If yes would someone please provide the steps?. I followed other threads but could not succeed till now.Published Date : 28 марта 2023 г.
Logic Apps (consumption) Manged Identity with Azure SQL DB doesn't work with consistency - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193701/logic-apps-(consumption)-manged-identity-with-azur Logic Apps (consumption) Manged Identity with Azure SQL DB doesn't work with consistency. Hi, I have 2 Logic Apps (in consumption plan) in different recourse groups, both are connected with Azure SQL DB on Managed Identity. And trying to execute some store procedures. One works perfectly but another doesn't. Ubale to figure out the issues, can someone please explain this behaviour and suggest an alternative solution? Thanks & Regards, Deepak Shaw.Published Date : 28 марта 2023 г.
Reuse deleted records - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193599/reuse-deleted-records Does deleting a record from a clustered table on a SQL database allow the deleted space to be reused if I insert a new record. If it not what additional steps would be needed to reuse that space.Published Date : 28 марта 2023 г.
Учебник. Создание веб-API с помощью ASP.NET Core
https://learn.microsoft.com/ru-ru/aspnet/core/tutorials/first-web-api Узнайте, как создать веб-API с помощью ASP.NET Core.Published Date : 28 марта 2023 г.
How to delete all configuration and apps created with this POST Description Softwares in Windows 11 22H2 version OS ? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193575/how-to-delete-all-configuration-and-apps-created-w SQL Server 2022 Express Edition and SQL Management Studio 19.0.2Published Date : 28 марта 2023 г.
can noit create database snapshot in sql-server 2019 - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193242/can-noit-create-database-snapshot-in-sql-server-20 in my work ,. I use sql-server 2019 and create a database named DB_TeachingMS , and I want create a database snapshot but I meet this problem, It always tiped me , must need all files to create a snapshot of database; I was very curios of this problem; I immeditely need your help ,thanksPublished Date : 28 марта 2023 г.
SSIS Package is not loading in VS2019 - The Argument type "System.__ComObject' cannot be converted into parameter type "Microsoft.SqlServer.Dts.Pipleline.Wrapper.IDTSPipeline100' - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193444/ssis-package-is-not-loading-in-vs2019-the-argument Hi All, We are trying to migrate SSIS 2014 packages to SSIS 2019. We are using Package Deployment Model only. Under one solution we have multiple Projects and under one projects we have 4-5 packages. I selected one project, and in properties I changed to Target server version from 2014 to 2019. It converted all 5 packages under that project successfully. 4 out of 5 packages are opening without any issue. But I am not able to open 1 package, firstly it takes lot of time to open the package and then it fails to open it with the following error message - This package has script tasks, which is using some dlls also. Can anybody suggest what is the issue. Our aim is to just lift and shift the packages from 2014 to 2019 without breaking the functionality. We are not aiming to use any of the new features.Published Date : 28 марта 2023 г.
SQL Server Agent is not expanding and Jobs are not visible - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193524/sql-server-agent-is-not-expanding-and-jobs-are-not Hi, We are not able to expand the SQL SERVER Agent. It is taking very long time. It is throwing below error. Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476 ADDITIONAL INFORMATION: Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-1222-database-engine-error -- If the Agent opens No jobs are visible. Kindly help me to fix the issue. Thanks, JoPublished Date : 28 марта 2023 г.
script to find the frequent used login information in the sql - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193522/script-to-find-the-frequent-used-login-information Hi, Kindly some one share the script or query to get the login information used for the sql database in the instance. InstanceName,DatabaseName,HostName,LoginName,Program,date used etc Thanks, JoPublished Date : 28 марта 2023 г.
I want to use Azure SQL Migration with Data Studio, error i see is "[renderer1] [error] An unknown error occurred. Please consult the log for more details." - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193527/i-want-to-use-azure-sql-migration-with-data-studio Hi, we are in a process to migrate a OnPremise SQL Server 2019 with Azure SQLData Studio. I have a default database "AdventureWorks2019" with a Full and Log Backup into a Azure Storage Blob. Backup of the database is fine, backup is encrypted. With the help of Azure SQL Data Studio, i could create a Migration with all information required. All preflight checks are fine, i can select the storage account, the blob and the container with the backup files. Data Migrations starts and after a few minutes it´s stalled. The state is Restoring (1 warninig), Duration is at 2.5hrs now. The only warnings i see in the logs and in the Developer Ext. Log Files is this ... main.log sharedprocess renderer1 Where is this log File? Please consult the log for more details. All other logs under AppData\Roaming\azuredatastudio\logs\20230327T162645 have a file size of ZeroPublished Date : 28 марта 2023 г.
How to fix report Builder Output header - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191932/how-to-fix-report-builder-output-header We have created a report using SSRS, query output looks correct. But when the report is exported in CSV only one of the column is giving wrong output. The report when exported in PDF has no issues.Published Date : 28 марта 2023 г.
Copy Dataverse data from ADLS Gen2 to Azure SQL DB leveraging Azure Synapse Link template in Synapse not working for multiple entities - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193468/copy-dataverse-data-from-adls-gen2-to-azure-sql-db Hi, Issues I was facingPublished Date : 28 марта 2023 г.
ADF Copy data activity issue from SQL Managed Instance to ADLS (Operation on target Source to ADLS failed: Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException) - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193347/adf-copy-data-activity-issue-from-sql-managed-inst Hello, I am encountering issue with the Copy activity in ADF with error message as below: Operation on target Source to ADLS failed: Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The file operation is failed, upload file failed at path: '[adls folder path]/data_31ccf4f0-8158-4109-908a-9ef4d936cc7d_59742144-0846-4d35-bc76-79558ed27ad6_00000.parquet'.,Source=Microsoft.DataTransfer.Common,''Type=System.Data.SqlClient.SqlException,Message=Transaction (Process ID 117) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.,Source=.Net SqlClient Data Provider,SqlErrorNumber=1205,Class=13,ErrorCode=-2146232060,State=52,Errors=[{Class=13,Number=1205,State=52,Message=Transaction (Process ID 117) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.,},],' Sometimes the run is successful but sometimes it will run into the error as mentioned above. Can someone kindly help advise on it? Thank you.Published Date : 28 марта 2023 г.
Data Flow failed with : Livy Id=[0] Job failed during run time with state=[dead]. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1189896/data-flow-failed-with-livy-id-(0)-job-failed-durin Dataflow that pulls data from Azure sql database got failed with below error. I am executing the Dataflow inside a loop to pull multiple table from azure sql database. for few tables dataflow was running perfectly and after that it got failed. Livy Id=[0] Job failed during run time with state=[dead]. I have attached a log for dataflow. Azure-IR-11-application_1678861376088_0001-Driver (stderr) - stderr-2023-03-15-09.logPublished Date : 28 марта 2023 г.
External table 'RetailDB.dbo.Product' is not accessible because content of directory cannot be listed - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193289/external-table-retaildb-dbo-product-is-not-accessi So I want to ingest data in a lake database table in Azure Synapse Studio, but I'm getting this error. "External table 'RetailDB.dbo.Product' is not accessible because content of directory cannot be listed" Even though the networking is set to All Networks for my data lake storage account. This is a part of exercise https://microsoftlearning.github.io/dp-203-azure-data-engineer/Instructions/Labs/04-Create-a-Lake-Database.html . Please Help!!Published Date : 27 марта 2023 г.
Включение BitLocker с помощью MBAM в составе развертывания Windows - Microsoft Desktop Optimization Pack
https://learn.microsoft.com/ru-ru/microsoft-desktop-optimization-pack/mbam-v25/how-to-enable-bitlocker-by-using-mbam-as-part-of-a-windows-deploymentmbam-25 Включение BitLocker с помощью MBAM в составе развертывания WindowsPublished Date : 27 марта 2023 г.
Отчеты с разбивкой на страницы в Power BI: Часто задаваемые вопросы - Power BI
https://learn.microsoft.com/ru-ru/power-bi/paginated-reports/paginated-reports-faq В этой статье содержатся ответы на часто задаваемые вопросы об отчетах с разбивкой на страницы. Это отчеты с широкой поддержкой форматирования и идеальной попиксельной оптимизацией для печати или создания PDF.Published Date : 27 марта 2023 г.
Связи 'многие ко многим' в Power BI Desktop - Power BI
https://learn.microsoft.com/ru-ru/power-bi/transform-model/desktop-many-to-many-relationships Узнайте, как использовать связи с кратностью "многие ко многим", чтобы упростить создание моделей данных, содержащих два или более источников данных в Power BI Desktop.Published Date : 27 марта 2023 г.
Настройка области параметров в отчете с разбивкой на страницы - Power BI
https://learn.microsoft.com/ru-ru/power-bi/paginated-reports/parameters/customize-parameters-pane-report-builder Узнайте, как настроить панель параметров при создании отчетов с разбивкой на страницы с параметрами в Power BI Report Builder.Published Date : 27 марта 2023 г.
Виртуальная сеть Azure. Вопросы и ответы
https://learn.microsoft.com/ru-ru/azure/virtual-network/virtual-networks-faq Ответы на наиболее часто задаваемые вопросы о виртуальных сетях Microsoft Azure.Published Date : 27 марта 2023 г.
Приступая к работе с SAP на виртуальных машинах Azure
https://learn.microsoft.com/ru-ru/azure/sap/workloads/get-started Сведения о работе решений SAP на виртуальных машинах в Microsoft Azure.Published Date : 27 марта 2023 г.
Определяемые пользователем функции JavaScript в Azure Stream Analytics
https://learn.microsoft.com/ru-ru/azure/stream-analytics/stream-analytics-javascript-user-defined-functions Эта статья содержит вводные сведения о определяемых пользователем функциях JavaScript в Stream Analytics.Published Date : 27 марта 2023 г.
Требования и рекомендации для больших томов
https://learn.microsoft.com/ru-ru/azure/azure-netapp-files/large-volumes-requirements-considerations Описание требований и рекомендаций, которые необходимо учитывать перед использованием больших томов.Published Date : 27 марта 2023 г.
Разрешение имен в Служба приложений - Azure App Service
https://learn.microsoft.com/ru-ru/azure/app-service/overview-name-resolution Общие сведения о том, как работает разрешение имен (DNS) для приложения в Служба приложений Azure.Published Date : 27 марта 2023 г.
Tutorial - Web app accesses SQL Database as the user - Azure App Service
https://learn.microsoft.com/en-us/azure/app-service/tutorial-connect-app-access-sql-database-as-user-dotnet Secure database connectivity with Azure Active Directory authentication from .NET web app, using the signed-in user. Learn how to apply it to other Azure services.Published Date : 27 марта 2023 г.
Диски ценовой категории 'Ультра' для виртуальных машин — управляемые диски Azure - Azure Virtual Machines
https://learn.microsoft.com/ru-ru/azure/virtual-machines/disks-enable-ultra-ssd Сведения о дисках ценовой категории "Ультра" для виртуальных машин AzurePublished Date : 27 марта 2023 г.
Обеспечение высокого уровня доступности SAP HANA на виртуальных машинах Azure под управлением SLES
https://learn.microsoft.com/ru-ru/azure/sap/workloads/sap-hana-high-availability Обеспечение высокого уровня доступности SAP HANA на виртуальных машинах Azure в SUSE Linux Enterprise ServerPublished Date : 27 марта 2023 г.
Convert integer data type to time - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193636/convert-integer-data-type-to-time My table lists the date and time fields as integer data types. I need to convert them to normal date formats. I have the date field done. How can I convert the time field with SQL?Published Date : 27 марта 2023 г.
How to have excel macros working under Azure Active Directory Authentication in a normal .NET Web Application Project? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1189273/how-to-have-excel-macros-working-under-azure-activ We have a .NET Web Application running on latest technology stack wherein it uses SQL Server in the back-end and MS Blazor in the front-end. Also some portion of front-end exist in excel since we are using some macros to accomplish functionalities like filling up the grid cells of excel sheet using the JSON returned from the Web API call. The Web API call has been implemented using Azure AD integrated authentication. Now we wish the macros to also use Azure AD Authentication. Please help us with some pointers or some concept related help or reference to other portal altogether or a better idea to accomplish the whole thing in the better new way. Thanks and RegardsPublished Date : 27 марта 2023 г.
Data factory run issue - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192115/data-factory-run-issue We have a Data Factory Pipeline which reads a CSV from a location, manipulates the data through three Data Flows and writes the data to an Azure SQL db. The process was initially drafted with a static CSV in Blob Storage since its long term source was not available. We now have access to the same file but live via SFTP. We’ve created a new Dataset specifying all the SFTP information including passphrase and key file. The file can be previewed through the Preview Data option SFTP access is via a whitelist and all Data Factory - AustraliaEast IP’s have been added We’ve switched the Data flow source from the old Blob dataset to the new SFTP dataset and run the pipeline We get the following error message Operation on target AddNewAssets failed: {"StatusCode":"DF-Executor-InvalidPath","Message":"Job failed due to reason: at Source 'TIALRMExport': Path /saas-out/CES/Assets/ALRM/TI_ALRM_Export.csv does not resolve to any file(s). Please make sure the file/folder exists and is not hidden. At the same time, please ensure special character is not included in file/folder name, for example, name starting with _","Details":""} Drilling in further the pipeline fails at the very first step, reading the source Dataset in the first Data flow The Dataset can be previewed so we don’t understand why it doesn’t exist when it comes to running the pipeline Is it down to the special character in the folder name? Would this allow the data to be previewed but not run? Thanks for any guidance given PaulPublished Date : 27 марта 2023 г.
Критические изменения в EF Core 7.0 (EF7) — EF Core
https://learn.microsoft.com/ru-ru/ef/core/what-is-new/ef-core-7.0/breaking-changes Полный список критических изменений, внесенных в Entity Framework Core 7.0 (EF7)Published Date : 27 марта 2023 г.
Поставщик базы данных Microsoft SQL Server — создание значений — EF Core
https://learn.microsoft.com/ru-ru/ef/core/providers/sql-server/value-generation Шаблоны создания значений, относящиеся к поставщику базы данных Entity Framework Core SQL ServerPublished Date : 27 марта 2023 г.
Сопоставления функций — поставщик Azure Cosmos DB — EF Core
https://learn.microsoft.com/ru-ru/ef/core/providers/cosmos/functions Сопоставления функций поставщика EF Core для Azure Cosmos DBPublished Date : 27 марта 2023 г.
Новые возможности EF Core 6.0
https://learn.microsoft.com/ru-ru/ef/core/what-is-new/ef-core-6.0/whatsnew Обзор новых возможностей в EF Core 6.0Published Date : 27 марта 2023 г.
Реконструирование — EF Core
https://learn.microsoft.com/ru-ru/ef/core/managing-schemas/scaffolding/ Реконструирование модели на основе существующей базы данных с помощью Entity Framework CorePublished Date : 27 марта 2023 г.
Unable to connect SQL server to Azure ML pipeline? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/775844/unable-to-connect-sql-server-to-azure-ml-pipeline Hi, I am trying to connect sql server using pyodbc and to extract some procedure for Azure ML pipeline. Since I am not able to install pyodbc library in Azure ML, pipeline connection is not happening. Kindly let me know is there any alternative method to connect sql server and execute the procedure. Code is as bellow conn = pyodbc.connect(Published Date : 27 марта 2023 г.
Разработка кода в записных книжках Databricks — Azure Databricks
https://learn.microsoft.com/ru-ru/azure/databricks/notebooks/notebooks-code Узнайте, как редактировать код в записных книжках Databricks. Узнайте об автозавершении и автоматическом форматировании кода. Сведения об журнале версий записной книжки.Published Date : 27 марта 2023 г.
Бессерверные вычисления — Azure Databricks
https://learn.microsoft.com/ru-ru/azure/databricks/serverless-compute/ Узнайте о версии бессерверных вычислений архитектуры платформы Azure Databricks и различиях между бессерверной и классической архитектурой.Published Date : 27 марта 2023 г.
Настройка брандмауэров службы хранилища Azure для разрешения доступа из бессерверных хранилищ SQL — Azure Databricks - Databricks SQL
https://learn.microsoft.com/ru-ru/azure/databricks/sql/admin/serverless-firewall Узнайте о настройке брандмауэров службы хранилища Azure для поддержки бессерверных хранилищ SQL.Published Date : 27 марта 2023 г.
Фильтры запросов — Azure Databricks - Databricks SQL
https://learn.microsoft.com/ru-ru/azure/databricks/sql/user/queries/query-filters Узнайте о фильтрах запросов в Databricks SQL.Published Date : 27 марта 2023 г.
Ноябрь 2021 г. – Azure Databricks
https://learn.microsoft.com/ru-ru/azure/databricks/release-notes/product/2021/november Заметки о выпуске за ноябрь 2021 г., касающиеся новых функций и улучшений Azure Databricks.Published Date : 27 марта 2023 г.
Databricks Runtime 3.5 LTS (не поддерживается) — Azure Databricks
https://learn.microsoft.com/ru-ru/azure/databricks/release-notes/runtime/3.5 Заметки о выпуске Databricks Runtime 3.5 на платформе Apache Spark.Published Date : 27 марта 2023 г.
Апрель 2018 г. — Azure Databricks
https://learn.microsoft.com/ru-ru/azure/databricks/release-notes/product/2018/april Заметки о выпуске новых функций и улучшений Azure Databricks, апрель 2018 г.Published Date : 27 марта 2023 г.
March 2023 - Azure Databricks
https://learn.microsoft.com/en-us/azure/databricks/release-notes/product/2023/march March 2023 release notes for new Azure Databricks features and improvements.Published Date : 27 марта 2023 г.
Change data capture with Delta Live Tables - Azure Databricks
https://learn.microsoft.com/en-us/azure/databricks/delta-live-tables/cdc Learn how to use change data capture with Azure Databricks Delta Live TablesPublished Date : 27 марта 2023 г.
Новый редактор записных книжек (общедоступная предварительная версия) — Azure Databricks
https://learn.microsoft.com/ru-ru/azure/databricks/notebooks/notebook-editor Узнайте, как использовать новый редактор записных книжек на основе VS Code, поддерживающий предложения кода IntelliSense и автозавершение, проверку переменных, свертывание кода и различия.Published Date : 27 марта 2023 г.
Read Delta Sharing shared tables using Apache Spark DataFrames - Azure Databricks
https://learn.microsoft.com/en-us/azure/databricks/external-data/deltasharing Learn how to read tables Delta Sharing shared tables using Apache Spark Dataframes in Azure Databricks.Published Date : 27 марта 2023 г.
How to change connection retry options for SQL pool? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193415/how-to-change-connection-retry-options-for-sql-poo Periodically we receive an error 'The SQL pool is warming up'. Changing ConnectionRetryCount and ConnectRetryInterval as suggested in this documentation doesn't help. As you can see default connection timeout (15 seconds) is used instead of the one defined in the connection string (30 seconds) and there are no retries: I'm using Microsoft.Data.SqlClient v 5.0.1 and Dapper 2.0.123. Connection string:Published Date : 27 марта 2023 г.
Azure VPN Gateway Traffic Selector mismatch drop package from ADF managed virtual network - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191889/azure-vpn-gateway-traffic-selector-mismatch-drop-p Hello, I want to access on-prem data to use in Azure Data Factory data-flows but it looks like self-hosted Integration Runtime is not able to run data-flows. That said, I followed this tutorial to configure Azure IR in a managed virtual network and then connect to on-prem. https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server In this scenario, I created a V-Net as the tutorial says, but with an additional config. The forwarding is done to a peered network and that network has a VPN connected to on-prem. This is the architecture: My problem is that from VMs placed in the net 192.168.21.0/24 I am able to connect to on-prem but the packages coming from Azure IR (10.250.4.0) are droped by the TS (Traffic selector) in VPN Gateway I tried adding custom traffic selectors to the connection, but still not working. This is the configuration of the connection. Anyone has experienced this situation or similar? Thank you,Published Date : 27 марта 2023 г.
How to setup custom database for ambari in HDInsight? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193625/how-to-setup-custom-database-for-ambari-in-hdinsig Hi, I am creating a hadoop cluster in HDInsight. For ambari I created an Azure SQL Database and during the creation I selected not to use existing data. But when I want to create the cluster and try to select the database, I am facing this warning: I am still getting the error even after I authenticate. Any advice? Regards.Published Date : 27 марта 2023 г.
error with the code: Exit code (Decimal): -2068119551 installing SQL Server 2022 Express Edition ?, i attach the sumarry.txt context in this post message - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192676/error-with-the-code-exit-code-(decimal)-2068119551 i believe the summary.txt file is the unique file that says summary in this folder path: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230323_170145 Summary_renoa_C-_a4__T__20230323_170145 and that file content what says there; i beleive that because the window that showed me the error code said that the SQL Server installation registry folder was located in that folder pathPublished Date : 27 марта 2023 г.
Connect to source database and delete any missing keys from data lake in Azure Synapse Notebook - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192653/connect-to-source-database-and-delete-any-missing I am pulling data from a source system that will randomly have rows deleted and I'd like to reconcile the data lake with the source system by deleting those rows in the data lake. The source system is a Azure SQL Managed Instance I'm also pulling table changes by using a ROWVERSION column on the source table. This allows me to only pull updates and inserts, not deletes. I pull the source changes and deletes into my bronze layer and from there I apply those changes to the silver layer. I'm hoping I don't have to pull all the keys from the source table into the bronze layer, but that I can dynamically query the source table and delete keys that were deleted in the source in the Silver layer parquet files. In SQL this would look like this: How would I connect to the source server in a Synapse Notebook and then join the Silver destination parquet file to run a delete like above?Published Date : 27 марта 2023 г.
WinRM cannot process the request. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193591/winrm-cannot-process-the-request I have local admin right on all remote servers that I'm trying to query the expiring certificate. I'm also able to query this same remote server for their Sql Server version by using Invoke-Sqlcmd -query "select @@version" -ServerInstance $dbName however, for querying the cert with Invoke-Command I got the following error. This the code. On the remote server, winRM is enabled and running.Published Date : 27 марта 2023 г.
Переход на оптимизацию планирования для сводного планирования - Supply Chain Management | Dynamics 365
https://learn.microsoft.com/ru-ru/dynamics365/supply-chain/master-planning/new-master-planning-engine В этой статье приводятся сведения о новом механизме сводного планирования, оптимизации планирования, и о миграции с существующего механизма.Published Date : 27 марта 2023 г.
Business continuity and disaster recovery - Finance & Operations | Dynamics 365
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/sysadmin/business-continuity-disaster-recovery This article describes the business continuity and disaster recovery that Microsoft provides for production instances of Microsoft Dynamics 365 SaaS applications if an Azure region-wide outage occurs.Published Date : 27 марта 2023 г.
sql server xpath query with namespace nodes does not return result - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193600/sql-server-xpath-query-with-namespace-nodes-does-n Greetings... I am using a sql server query with xmlnamespaces but does not return results at all. Output: Query:Published Date : 27 марта 2023 г.
Adal Error while trying to configure Azure AD user and Azure Sql Authentication to make my connection string password less - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192998/adal-error-while-trying-to-configure-azure-ad-user Hi there, I'm trying AD integrated authentication between my .net app and azure SQL. The app is running on a Azure VM that is joined to an Azure AD domain (Domain Services) on IIS. I am getting Adal Error while trying to configure Azure AD user and Azure Sql Authentication to make connection my string password less Error : One or More errors, AdalException: Integrated Windows authentication supported only in federation flow. This is how my connection string looks : <add name="primary" connectionString="Server=tcp:XXXXX;Initial Catalog=XXXXX;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication='Active Directory Integrated';" />Published Date : 27 марта 2023 г.
Настройка группы автоматической отработки отказа - Azure SQL Database
https://learn.microsoft.com/ru-ru/azure/azure-sql/database/auto-failover-group-configure-sql-db Узнайте, как настроить группу автоматической отработки отказа для отдельной базы данных или для базы данных в пуле в Базе данных SQL Azure с помощью портала Azure и PowerShell.Published Date : 27 марта 2023 г.
Перенос экземпляра отказоустойчивого кластера - SQL Server on Azure VMs
https://learn.microsoft.com/ru-ru/azure/azure-sql/migration-guides/virtual-machines/sql-server-failover-cluster-instance-to-sql-on-azure-vm Узнайте, как создать и запустить высокодоступное решение экземпляра отказоустойчивого кластера Always On в SQL Server на виртуальных машинах Azure с помощью службы "Миграция Azure".Published Date : 27 марта 2023 г.
Использование Управление уязвимостями Microsoft Defender с Microsoft Defender для облака
https://learn.microsoft.com/ru-ru/azure/defender-for-cloud/deploy-vulnerability-assessment-defender-vulnerability-management Включение, развертывание и использование Управление уязвимостями Microsoft Defender с Microsoft Defender для облака для обнаружения слабых мест в Azure и гибридных компьютерахPublished Date : 27 марта 2023 г.
Схема событий журнала действий Azure - Azure Monitor
https://learn.microsoft.com/ru-ru/azure/azure-monitor/essentials/activity-log-schema Описание схемы событий для каждой категории в журнале действий Azure.Published Date : 27 марта 2023 г.
Выполнение действий в Центре резервного копирования - Azure Backup
https://learn.microsoft.com/ru-ru/azure/backup/backup-center-actions В этой статье объясняется, как выполнять действия с помощью Центра резервного копирования.Published Date : 27 марта 2023 г.
Настройка ключей, управляемых клиентом, для Azure API для FHIR
https://learn.microsoft.com/ru-ru/azure/healthcare-apis/azure-api-for-fhir/customer-managed-key Использование собственной ключевой функции, поддерживаемой в Azure API для FHIR, с помощью Azure Cosmos DBPublished Date : 27 марта 2023 г.
Новые возможности в Azure Site Recovery - Azure Site Recovery
https://learn.microsoft.com/ru-ru/azure/site-recovery/site-recovery-whats-new Содержит сводку по новым функциям и последним обновлениям в службе Azure Site Recovery.Published Date : 27 марта 2023 г.
Названия продуктов и идентификаторы планов служб для лицензирования - Microsoft Entra
https://learn.microsoft.com/ru-ru/azure/active-directory/enterprise-users/licensing-service-plan-reference Сопоставление идентификаторов для управления лицензированием Azure Active Directory на портале Azure, в Центре администрирования Microsoft 365, в PowerShell или Microsoft GraphPublished Date : 27 марта 2023 г.
How to deploy Mediasoup service on Azure? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/283071/how-to-deploy-mediasoup-service-on-azure Hello, I am having some doubts. If you know anything regarding following issues, kindly please help. 2) I have AppService and Azure SQL server instance running on Azure where the .Net Application is running. The mediasoup streaming service needs to communicate with the AppService and the SQL database. How can this be done? 3) Also, mediasoup server needs to store the streaming data which will be accessed by .Net application from AppService. What is the good way to this? Can it be done using Azure Blob Storage Account?Published Date : 27 марта 2023 г.
Parsing JSON column in SQL Server Table - JSON text is not properly formatted. Unexpected character '.' is found at position 0. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193458/parsing-json-column-in-sql-server-table-json-text Dear Team, Below is my one of JSON Column Name is "VARIALBLES" from the SQL Server table, {"EmbedContextParameters":null,"PipeData":{"First Name":"Rajkumar","Last Name":"Govindaraj","ID":"","FormType":"LeadArtist","ESubDept":"","Programme":"Kusama","ProjectCode":"AX-1234","RoleList":"","locale":"en-us"}} Remaining colunms Email, Gender, etc,. as normal. And, I'm trying to explode new columns from the one of Json column in a Sql Server table. Below is my code that i tried and keep getting same error msg like in below, Msg 13609, Level 16, State 4, Line 76 JSON text is not properly formatted. Unexpected character '.' is found at position 0. Please help me someone to solve this problem.Published Date : 27 марта 2023 г.
Microsoft Certified: Azure for SAP Workloads Specialty - Certifications
https://learn.microsoft.com/ru-ru/certifications/azure-for-sap-workloads-specialty/ Для реализации решений архитекторы или инженеры Azure по рабочим нагрузкам SAP сотрудничают с администраторами облака, администраторами облачных баз данных и непосредственно клиентами.Published Date : 27 марта 2023 г.
ADF data flow Sink failed due to Nulls in specific column, insert error to sink enabled with staging - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190100/adf-data-flow-sink-failed-due-to-nulls-in-specific Hello, In a data factory pipeline, the following dataflow returns the below error, when trying to insert to the sink. The sink exports to Az SQL DW - synapse SQL Pool, and the mapped column in DW, does not have any NULLs. The pipeline trigger fail is intermittent. Staging is enabled on the sink, and is using the sink schema. Error: Cannot insert the value NULL into column 'Column', table 'tempdb.dbo.********'; column does not allow nulls. INSERT fails. (The column, is also listed as one of the key columns in the sink settings) 6 columns Alter row transformation from source: upsertif --> true() Sink settings: Sink type: Dataset schema drift enabled 2 Key columns Schema mapping done manually. Update method: Only allow upsert is enabled Full error: Operation on target upsertsyncplanrequestsToDW failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'sink1': [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'columnx', table 'tempdb.dbo.sometable_sdf615e6_9'; column does not allow nulls. INSERT fails. Additional error <2>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated., SqlState: 01000, NativeError: 3621 ","Details":"java.sql.BatchUpdateException: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'columnx', table 'tempdb.dbo.sometable_sdf615e6_9'; column does not allow nulls. INSERT fails. Additional error <2>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated., SqlState: 01000, NativeError: 3621 \n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1886)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter.executeBatchSQLs(JDBCStore.scala:575)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter.executeSQL(JDBCStore.scala:550)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$executeTableOpAndPostSQL$1.apply$mcV$sp(JDBCStore.scala:644)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$executeTableOpAndPostSQL$1.apply(JDBCStore.scala:644)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$execute"} Thanks in advance. Any suggestions please.Published Date : 27 марта 2023 г.
When deployed my SSIS package does not return any rows or errows from the Excel datasource - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192838/when-deployed-my-ssis-package-does-not-return-any I have created a package which gets rows from an Excel file, transforms them and writes them into a SQL Server. But the problem is that when being executed from SSDT it returns data, but when being executed using a SQL Server Agent it does not write rows neither does it return an error. The only process that returns is a error is SSAS, because it can't find any rows. My situation: Does someone now a probable resolution to my problem? It is really annoying, beacuase I can't debug this any further.Published Date : 27 марта 2023 г.
Report Wizard missing in VS2022 - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193495/report-wizard-missing-in-vs2022 In VS2022 I downloaded and installed the Microsoft RDLC Report Designer 2022 but I still can't find the report.Published Date : 27 марта 2023 г.
SQL Server 2022 install on Windows 10 fails with error that .NET is not installed, but it is installed and up to date - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192625/sql-server-2022-install-on-windows-10-fails-with-e I have installed SQL Server 2022 Developer edition successfully on a Windows 10 and 11 virtual machine. The issue is that I cannot install it on a physical machine. During the install, I get the following fatal error. I have tried to install the latest .NET Framework, and my OS says it's already installed. I tried to install 4.0 .NET and the message is that it's included with my installed version. I tried to install 2.0 .NET framework, and the installer doesn't launch. The error's help link is dead. I've attached the log file.Published Date : 27 марта 2023 г.
Первое знакомство с развертыванием - Visual Studio (Windows)
https://learn.microsoft.com/ru-ru/visualstudio/deployment/deploying-applications-services-and-components Сведения о вариантах развертывания приложений из среды Visual Studio.Published Date : 27 марта 2023 г.
Azure Virtual network web app to public Azure storage account Static website latency issues, - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191616/azure-virtual-network-web-app-to-public-azure-stor We are using Azure virtual network and with in Vnet has Wepapp service and my SQL database. We have public static website azure storage account deployed UI code. If we try to access API with in UI application facing latency issue and we tried the same in azure bastion server working as we expected. What we need to do know, suggest your answersPublished Date : 27 марта 2023 г.
how can use variable in odbc source - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190699/how-can-use-variable-in-odbc-source hello, i want to set variable from execute sql task and using this variable odbc source in data flow task. How can doing this? I set variable but when i running package gets variable empty error. Can you help me?Published Date : 27 марта 2023 г.
DNS resolve sql server Service Containers failed in self-hosted agent pipeline - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193345/dns-resolve-sql-server-service-containers-failed-i created a sql server Service Containers in a linux self-hosted agent used shell to check connectivity is successful. Connection to localhost 1433 port [tcp/ms-sql-s] succeeded! Server: 127.0.0.53 Address: 127.0.0.53#53 Non-authoritative answer: Name: localhost Address: 127.0.0.1 Name: localhost Address: ::1 but in later task alway got connection refused com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". does anyone who has the same situation?Published Date : 27 марта 2023 г.
Unable to see SQLSecurityAuditEvents logs for ResourceType MANAGEDINSTANCES - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193479/unable-to-see-sqlsecurityauditevents-logs-for-reso Hi All, We have enabled Diagnostic setting on our SQL Managed instances using Azure policy. But we are not receiving the SQLSecurityAuditEvents for ResourceType MANAGEDINSTANCES. We are getting logs for ResourceType SERVERS/DATABASES, but not for MANAGEDINSTANCES. attached is the capture.jpg screenshot of one sql maanged instance DiagnosticSetting Page: So the question is, are the SQLSecurityAuditEvents for ResourceType MANAGEDINSTANCES available in log analytic workspace, if yes, how do we see them? Below is the query we are using, we get no results.Published Date : 27 марта 2023 г.
How to fix a missing ntprint.inf_amd64 within driverstore from blocking cumulative updates on Server2019 - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193174/how-to-fix-a-missing-ntprint-inf-amd64-within-driv Issue I'm having on one server Windows 2019 with Sql Server installed. This Windows Server 2019 will not install cumulative updates. Windows update gives a low knowledge value error 0x80070003. Troubleshooting / DISM does not find anything. Setupapi.dev logfile shows During the "Uninstall Driver Updates Stage" that a file c:\windows\system32\Driverstore\filerepository\ntprint.inf_amd64_2097e02ea77b432e\ntprint.inf is not found. Then the cumulative update decides to roll back. (That directory is not present, a similar newer version is present on other 2019 servers c:\windows\system32\Driverstore\filerepository\ntprint.inf_amd64_bfd583806467d1ba\ntprint.inf ) But windows server nor knowledgebase provides a method to repair / replace this file or install a more modern version in it's place. Is there any way to repair or replace, update this driver package? "Microsoft WIndows Core Printer Driver Package" is the header from it's equivalent on a different server. Or remove mention of it from whatever hive it's mentioned by, so the monthly cumulative update isn't failing to uninstall it, and giving up. Listed in the registry is a HKEY_USERS.Default\Software\Microsoft\TelemeteryClient\ThrottleStore\watson\generic\generic\pnpdriverimporterror\p1x64p20000000020p3ntprint.infp46e27f686b............. The cause might be something else, but this reports the same issue with a 2012 server. I lack the identical version of the microsoft core print driver to drop into place. https://social.technet.microsoft.com/Forums/ie/en-US/5fa8b2d5-bb37-4fa0-be05-986bb55515e6/cannot-apply-update-packages-rolling-back?forum=winserver8genPublished Date : 27 марта 2023 г.
fix data base engine failed due to log on potentials..potentials - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1193219/fix-data-base-engine-failed-due-to-log-on-potentia Hi sir I am trying to installling on SQL server it shows data base engine failed due to logon potentialsPublished Date : 27 марта 2023 г.
Оптимизация сбора статистики запросов — База данных Azure для PostgreSQL — гибкий сервер
https://learn.microsoft.com/ru-ru/azure/postgresql/flexible-server/how-to-optimize-query-stats-collection В этой статье описывается, как оптимизировать сбор статистики запросов на гибком сервере База данных Azure для PostgreSQLPublished Date : 27 марта 2023 г.
Что такое кэш Azure для Redis?
https://learn.microsoft.com/ru-ru/azure/azure-cache-for-redis/cache-overview Узнайте о том, как использовать Кэш Azure для Redis для обеспечения кэширования содержимого, кэширования сеансов пользователей, организации очереди для заданий и сообщений, а также распределенных транзакций.Published Date : 27 марта 2023 г.
Перемещение виртуальных машин Azure между регионами с помощью Azure Resource Mover
https://learn.microsoft.com/ru-ru/azure/resource-mover/tutorial-move-region-virtual-machines Сведения о перемещении виртуальных машин Azure в другой регион с помощью Azure Resource MoverPublished Date : 27 марта 2023 г.