Microsoft Docs - 최신 문서
Microsoft 기술 문서가 이전된 docs.microsoft.com에서는 콘텐츠용 웹 환경뿐 아니라 솔루션을 학습, 관리 및 배포하는 데 사용하는 콘텐츠를 만들고 지원하는 방법을 현대화했습니다. 이는 Microsoft 기술과 관련된 모든 것을 위한 원스톱 상점입니다. docs.microsoft.com에서 새롭고 흥미로운 내용을 최신 상태로 유지할 수 있도록 귀하를 위한 전용 피드를 만들었습니다.
Selected Feed: SQL
is there any certification on Microsoft portal for hands on learning of SQL ? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1185325/is-there-any-certification-on-microsoft-portal-for I want to do a certification from Microsoft on SQL. Can anyone let me know the learning path do the same.Published Date : 2023년 3월 23일 목요일
combine 2 columns to one and pivot - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192686/combine-2-columns-to-one-and-pivot How do I combine 2 columns to 1 and pivot that table. Suppose my table looks like this and I want it to look like thisPublished Date : 2023년 3월 23일 목요일
Duplicate name issue when using System Managed Identity with SQL - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1166668/duplicate-name-issue-when-using-system-managed-ide We have recently started using System Managed Identities for our app services to access our Azure SQL databases. Our Azure AD app registrations use the same name as the app service, so the application object service principal has the same name as the SMI service principal. When our DBA tries to create the user (i.e. "CREATE USER...") in the database they receive this error. Principal 'xxxx' has a duplicate display name. Make the display name unique in Azure Active Directory and execute this statement again. We have found that we can get around this error by temporarily renaming the app registration name on the "Branding & Properties" page, which allows the DBA to successfully execute "create user...". Once this is complete we restore the original app name. While the error message indicates that the display name must be unique, we wouldn't expect to be able to restore the name. Although our naming standards might be unconventional (to have the same name for the app service and application object), since our workaround essentially allows the SMI service principal object to have the same name as the application object then the "CREATE USER..." command should complete without giving the error, and without having to rename the registration. Our workaround seems kludgey, so we wanted to know if this behavior is expected or if this could be a bug somewhere.Published Date : 2023년 3월 23일 목요일
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 : 2023년 3월 23일 목요일
Windows 2019, AD Connect 2.1.20.0 - How to resolve Unable to display Connector run summary? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190103/windows-2019-ad-connect-2-1-20-0-how-to-resolve-un I've not been able to resolve this message. Today I also received 3 new Event ID's related. I had completed a in place AD Connect upgrade to 2.1.20.0, one because it was outdated and 2 because of another popup message " Synchronization Server Manager - Unable to display Connector run summary. I've run the troubleshooting wizard, everything came back good. I've spent all day trying to locate possible solutions and have not been able to . Any suggestions would be extremally helpful and appreciated. Thank you WadePublished Date : 2023년 3월 23일 목요일
SQL Management Studio Query Designer not working - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192671/sql-management-studio-query-designer-not-working I cannot get SSMS to auto link tables anymore in the Query Designer, I have completely removed it, deleted the folders and reinstalled and it still won't work. Below are pictures to show you what I mean. This is a PC where it is working and my PC where it just stopped working out of the blue today. I have copied over the settings (import/export) from the PC that is working to mine and that did not fix it.Published Date : 2023년 3월 23일 목요일
Can't set primary key without dropping and re-creating table - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192563/cant-set-primary-key-without-dropping-and-re-creat Hi, I am using SQL Server Standard (64-bit), version 11.0.7507.2 (when I go to Help | About, it is shown as SQL Server 2012). I have a table that has just one record. This table has no primary key. I'd like to make one column the Primary Key. In the single record in this table, this column has a value that is not Null. In SQL Server Management Studio, I opened the table in Design View. I right-clicked on the column I want to make the Primary Key, and chose "Set Primary Key". When I try to save my modified table design, I get the following message: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option Prevent saving changes that require the table to be re-created. Currently, there are people using a Microsoft Access Front-end application that has linked tables that are connected to tables in the SQL Server Database (including the table for which I'd like to set a Primary Key). If possible, I'd like to set the Primary Key in a way that would (1) not require me to force all users to close the client application and (2) not require me to re-enter all the data that is stored in the one record of this table. This table stores "Preferences" that affect how the application works, but that are not changed regularly. I have no concern that data in the table will be in the process of being changed while I am attempting to set the Primary Key. The only reason I want to set the Primary Key is because I suspect the fact that there is currently no Primary Key is resulting in the linked table in the Access front end application not being updateable. (The fact that this table is currently not updateable from the front end application is another reason why I am certain that none of the active client connections will be making changes to this data.) Any advice as to the best way I can go about making this change will be greatly appreciated. Thanks in advance, PaulPublished Date : 2023년 3월 23일 목요일
Log Parser - How to parse IIS Logs with and without X-Forwarded-For - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192581/log-parser-how-to-parse-iis-logs-with-and-without I have IIS logs dating back to 2013. About a month ago, we switched to add X-Forwarded-For data to the IIS logs and now the files have the "_x.log" extension. I am writing these logs to a SQL Server table. I am able to parse the previous, non-X-Forwarded-For logs using -i:IISW3C and can use -iCheckPoint for these logs. The problem is, when it gets to the "_x.log" files, it generates parsing errors. I am able to parse the "_x.log" files using -i:W3C", but I cant use -icheckpoint with "W3C" it seems. I am not concerned about the non-"_x.log" files as they are historical and I can put them in their own folder and run "-i:IISW3c" on them and have their own SQL table, but the "_x.log" files, I need to use a checkpoint in order to schedule a batch file to run in real time and update my database table that includes X-Forwarded-For Is there a workaround for this or something I am missing?Published Date : 2023년 3월 23일 목요일
SQLServer mangement studio connection error - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192583/sqlserver-mangement-studio-connection-error When I click to open a new query SSMS return an error like image bellow. If I click 'ok I am able to run any query. This error occur even when I right click on SQLQuery window and chose a new connection. All the SSMS configurations are defaultedPublished Date : 2023년 3월 23일 목요일
sp_send_dbmail inside a logon trigger. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192655/sp-send-dbmail-inside-a-logon-trigger hello, im using a simple logon trigger to check a SQL Login id, if its not a windows id and if its coming from particular workstation then raiserror and send email. Trigger is getting fired however email is not sent. This is the script. I have also tried logging this data by inserting hostname and login name in the table however sometimes it inserts the data sometimes it doesnt. Can someone tell me what am i doing wrong? Thank youPublished Date : 2023년 3월 23일 목요일
SSIS Script Task - Edit Script not working - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1030851/ssis-script-task-edit-script-not-working This is a common recurring issue on Microsoft SSIS Projects development IDE on Visual Studio Community 2019 (Windows 10): given a Script Task the edit button that should open a Visual Studio Intance (VSTA) to work on C# code do not react to the click. There are plenty of threads on internet about this topic, which is very common each Visual Studio new upgrade or whatever: but this time none of the above is enough to solve. I am running VS 2019 Community 16.11.19 the latest version available as of today; ***UPDATE: after reinstalling Sql Server Integration Service Projects a click on the edit button opens an instance of Visual Studio but it is empty, the code is not availablePublished Date : 2023년 3월 23일 목요일
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 : 2023년 3월 23일 목요일
Copying data from synapses serverless SQL pool view to tables in the pool - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190269/copying-data-from-synapses-serverless-sql-pool-vie Hi , I have created views for all D365 F&O tables in synapses serverless SQL pool using the CDMUtil solution . I am looking to transform the data from views to table in the same or a different DB , i.e. cache mechanism, to reduce the cost of call the views over and over again while reporting . Is there any procedure to achieve this .Published Date : 2023년 3월 23일 목요일
How to backup the SQL Server resource itself not the databases? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192615/how-to-backup-the-sql-server-resource-itself-not-t Pretty basic scenario, someone deletes a SQL Server by accident or maliciously, doesn't matter which. What happens to all of my databases? What about all of the settings in the SQL Server resource (allowed networks, etc.)? How do I backup this SQL Server itself not just my databases?Published Date : 2023년 3월 23일 목요일
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 : 2023년 3월 23일 목요일
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 : 2023년 3월 23일 목요일
Azure Data Factory Salesforce connector - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/65489/azure-data-factory-salesforce-connector I am using the ADF Salesforce connector to query a Salesforce table. I am able to execute a query that uses the SOQL syntax, but SOQL does not offer SELECT * so I am attempting to use the SQL format as described by the ADF Docs here: Copy activity properties For a full list of sections and properties that are available for defining activities, see the Creating pipelines article. Properties like name, description, input and output tables, and various policies are available for all types of activities. The properties that are available in the typeProperties section of the activity, on the other hand, vary with each activity type. For Copy Activity, they vary depending on the types of sources and sinks. In copy activity, when the source is of the type RelationalSource (which includes Salesforce), the following properties are available in typeProperties section: COPY ACTIVITY PROPERTIES Property Description Allowed values Required query Use the custom query to read data. A SQL-92 query or Salesforce Object Query Language (SOQL) query. For example: select * from MyTable__c. No (if the tableName of the dataset is specified) Source: https://learn.microsoft.com/en-us/azure/data-factory/v1/data-factory-salesforce-connector#copy-activity-properties When I write the query as "SELECT *" I get an error stating: ERROR [HY000] [Microsoft][Salesforce] (120) SOQL_FIRST mode prepare failure: SOQL error: [Microsoft][SQLEngine] (31480) syntax error near 'Select *<<< ??? >>> From Account This error clearly indicates to me that ADF is using a SOQL query. I would like to use a SQL query but I cannot find any documentation that explains how to do so. Anyone know how to do this? Or is the documenation inaccurate?Published Date : 2023년 3월 23일 목요일
Access Control - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192501/access-control Good morning, I am working on a .NET Core 6, SQL Server project and I need some idea of how to implement permissions by fields, let me explain: in a form, for example, that has [Name, Surname, Date, Address, Gender] to be able to assign in an access screen the next. And then apply it to the Razor frontend Thanks in advancePublished Date : 2023년 3월 23일 목요일
Unable to Update Record in Access Database Using C# and OleDb - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192622/unable-to-update-record-in-access-database-using-c Hello, I am working on a Windows Forms application using C# and the .NET Framework, and I have encountered an issue when trying to update a record in an Access database. I'm using OleDb to connect to the Access database, and I can successfully insert new records, but when I try to update an existing record, it fails, and no rows are affected. Here's my database schema for the MedicalHistory table: Here's the C# code I'm using to update the record: I've tested the same UPDATE query directly in Access, and it works as expected. However, when executed through the C# code, it doesn't update the record and no rows are affected. I've already tried the following: None of these attempts resolved the issue. Could anyone please help me understand what might be causing the problem, or suggest any additional steps I can take to troubleshoot and fix the issue? Note: I've been using GPT-4 to help me code & debug this but it eventually suggested I turn to the developer forums (I've never experienced that!). Also thought Id get it to write me joke about my problem, here you go. Why did the developer turn to ChatGPT for help with their code? Because they thought it was a "GPT" (Great Programming Teacher)! But when ChatGPT said to ask other devs, the developer couldn't help but laugh, realizing that even the Great Programming Teacher sometimes needs a "human touch" in debugging! 😄Published Date : 2023년 3월 23일 목요일
Best approach to learning database queries with MVC Core and EF - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192230/best-approach-to-learning-database-queries-with-mv What's the best way to learn MVC Core/EF DB queries in C#? I'm learning on my own, and I read through whatever I can find online. I know T-SQL very well, but I don't know how to translate that into a Core project. For example, I know the following statement well: SELECT * FROM Inventory Where Id = @myId. Then I found a correlary statement online: Inventory myinv = mydb.Inventory.FirstOrDefault(p => p.Id == Id); That's great, and works well. But I have no idea how to build upon and expand these kind of queries. Is there a master, super-hero book out there for DB queries? Or an online master class somewhere? Or what? All I know right now is to ask you all, and I must be tiring you out!Published Date : 2023년 3월 23일 목요일
ADF load data to Rest API Sink - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192624/adf-load-data-to-rest-api-sink My data is present in Azure SQL Database table, and I have to PUT the data in Blackline API in text format, using ADF Blackline API example : https://developer.blackline.com/docs/data-ingestion-accounts-api/1/routes/dataingestion/accounts/put URL : https://{environment}.api.blackline.com/dataingestion/accounts Content-Type : "text/plain" example body for PUT method: "3000 Account-DI-02 AS020 1102 BK 12111 Test Bank Account Cash A Asset TRUE TRUE GBP USD 6/30/2014 34664.86 23058.37 34664.86 IMPCash 2 IMPCash 3 IMPCash 4 IMPCash 5 IMPCash 6" So without the header the values only I have to send to an API using PUT method. Please suggest if this is doable with ADF or help me with some alternate solution.Published Date : 2023년 3월 23일 목요일
Migrate MSAccess forms, reports and modules to Web - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/975566/migrate-msaccess-forms-reports-and-modules-to-web Over many years I have designed an increasingly sophisticated program with MSAccess 2019 Front End and SQL 2019 Back End. What will be a practical migration of all the Front End forms, reports, and modules to a web base program? Is the migration of SQL 2019 to Azure a good solution for the Back End database? Thanks, NorbertPublished Date : 2023년 3월 23일 목요일
검사 및 수집 - Microsoft Purview
https://learn.microsoft.com/ko-kr/azure/purview/concept-scans-and-ingestion 이 문서에서는 Microsoft Purview의 검사 및 수집에 대해 설명합니다.Published Date : 2023년 3월 23일 목요일
MECM won't import drivers? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1185988/mecm-wont-import-drivers I'm getting an error when trying to import drivers to MECM. I will attach a screenshot and my DriverCatalog.log. This is a new install of MECM. I just need to make sure the boot image has the network driver for the device I am imaging so I can do PXE booting. I read a guide about a similar issue and it showed how to make sure the SQL database is not in read-only mode and how to set trustworthy to on for the database. I looked at it in sql studio and made sure the database was all set. Any help would be appreciated. Thank you. DriverCatalog.logPublished Date : 2023년 3월 23일 목요일
ADFS W2019 in Azure HA design - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190930/adfs-w2019-in-azure-ha-design Hi there we have a biz requirement to build ADFS w/ W2019, due to existing legacy components we won't be using AAD. FOr our ADFS build what we want to acheive is to build ADFS across 2 different Azure regions to delivery HA - we are considering either an Active- Standby design or Active-Active. Any suggestions on how this can be achieved? I understand due to the SQL requirements of ADFS having the ADFS run between 2 different Azure regions may increase complexity with the SQL and we can't use SQL PAAS either but would like to hear everyone's thoughts. Is SRM also an option? We are considering to look at Azure traffic manager to manage the A/A or A/S traffic. This ADFS will be both internal and external facing so will need WAP as well.Published Date : 2023년 3월 23일 목요일
Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult Windows Installer SDK. Please help me... - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192416/exit-code-(decimal)-2068052377error-description-in After multiple efforts with Installing SQL Express I was at first stuck during installation at point CPU_64 Issue which after multiple online searches and deep cleaning I was able to remove all issues and all partial installed SQL components from previous attempts. Now when I do the installation it completes and gives me the error Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult Windows Installer SDK. Please help me... However in the file located in C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230323_100644 I am not able to see the issue... i doesnt allow me to attache the file so here is its context: ;SQL Server 2022 Configuration File [OPTIONS] ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Use the /ENU parameter to install the English version of SQL Server on your localized Windows operating system. ENU="True" ; Setup roles install SQL Server in a predetermined configuration. ROLE="AllFeatures_WithDefaults" ; Indicates whether the supplied product key is covered by Service Assurance. PRODUCTCOVEREDBYSA="False" ; Specifies that SQL Server Setup should not display the privacy statement when ran from the command line. SUPPRESSPRIVACYSTATEMENTNOTICE="False" ; Setup will not display any user interface. QUIET="True" ; Setup will display progress only, without any user interaction. QUIETSIMPLE="False" ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block. UIMODE="AutoAdvance" ; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found. UpdateEnabled="False" ; If this parameter is provided, then this computer will use Microsoft Update to check for updates. USEMICROSOFTUPDATE="False" ; Specifies that SQL Server Setup should not display the paid edition notice when ran from the command line. SUPPRESSPAIDEDITIONNOTICE="False" ; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services. UpdateSource="MU" ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install shared components. FEATURES=SQLENGINE ; Displays the command line parameters usage. HELP="False" ; Specifies that the detailed Setup log should be piped to the console. INDICATEPROGRESS="True" ; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine (SQL), or Analysis Services (AS). INSTANCENAME="SQLEXPRESS" ; Specify the root installation directory for shared components. This directory remains unchanged after shared components are already installed. INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" ; Specify the root installation directory for the WOW64 shared components. This directory remains unchanged after WOW64 shared components are already installed. INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will incorporate the instance ID of the SQL Server instance. INSTANCEID="SQLEXPRESS" ; Startup type for the SQL Server CEIP service. SQLTELSVCSTARTUPTYPE="Automatic" ; Account for SQL Server CEIP service: Domain\User or system account. SQLTELSVCACCT="NT Service\SQLTELEMETRY$SQLEXPRESS" ; Specify the installation directory. INSTANCEDIR="C:\Program Files\Microsoft SQL Server" ; Agent account name. AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" ; Auto-start service after installation. AGTSVCSTARTUPTYPE="Disabled" ; Startup type for the SQL Server service. SQLSVCSTARTUPTYPE="Automatic" ; Level to enable FILESTREAM feature at (0, 1, 2 or 3). FILESTREAMLEVEL="0" ; The max degree of parallelism (MAXDOP) server configuration option. SQLMAXDOP="0" ; Set to "1" to enable RANU for SQL Server Express. ENABLERANU="True" ; Specifies a Windows collation or an SQL collation to use for the Database Engine. SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" ; Account for SQL Server service: Domain\User or system account. SQLSVCACCOUNT="NT Service\MSSQL$SQLEXPRESS" ; Set to "True" to enable instant file initialization for SQL Server service. If enabled, Setup will grant Perform Volume Maintenance Task privilege to the Database Engine Service SID. This may lead to information disclosure as it could allow deleted content to be accessed by an unauthorized principal. SQLSVCINSTANTFILEINIT="True" ; Windows account(s) to provision as SQL Server system administrators. SQLSYSADMINACCOUNTS="LAPTOP-AHI7BVCQ\nefel" ; The number of Database Engine TempDB files. SQLTEMPDBFILECOUNT="1" ; Specifies the initial size of a Database Engine TempDB data file in MB. SQLTEMPDBFILESIZE="8" ; Specifies the automatic growth increment of each Database Engine TempDB data file in MB. SQLTEMPDBFILEGROWTH="64" ; Specifies the initial size of the Database Engine TempDB log file in MB. SQLTEMPDBLOGFILESIZE="8" ; Specifies the automatic growth increment of the Database Engine TempDB log file in MB. SQLTEMPDBLOGFILEGROWTH="64" ; Provision current user as a Database Engine system administrator for SQL Server 2022 Express. ADDCURRENTUSERASSQLADMIN="True" ; Specify 0 to disable or 1 to enable the TCP/IP protocol. TCPENABLED="0" ; Specify 0 to disable or 1 to enable the Named Pipes protocol. NPENABLED="0" ; Startup type for Browser Service. BROWSERSVCSTARTUPTYPE="Disabled" ; Use SQLMAXMEMORY to minimize the risk of the OS experiencing detrimental memory pressure. SQLMAXMEMORY="2147483647" ; Use SQLMINMEMORY to reserve a minimum amount of memory available to the SQL Server Memory Manager. SQLMINMEMORY="0"Published Date : 2023년 3월 23일 목요일
SQL Event Action ID and Class Type for Create and Drop Index showing Wrong - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192514/sql-event-action-id-and-class-type-for-create-and SQL Server 2022 Tool : SQL Server Management Studio Version 19 Windows Version : 10 Hi Team, Please help me on the below Query Query: SQL Event Action ID and Class Type for Create and Drop Index shows AL (Expected Action ID=CR) and U (Expected class type=IX), Please help on why the action id is coming as AL instead of CR and Class type IX instead of U Screenshots attached below Create Index Action Id and Class type on Event Viewer Drop Index Action Id and Class Type on Event Viewer Thanks in AdvancePublished Date : 2023년 3월 23일 목요일
SCCM Reports disappearing from console intermittently but working fine from SSRS web portal. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1082393/sccm-reports-disappearing-from-console-intermitten SCCM Reports disappearing from console intermittently but working fine from SSRS web portal. Recently installed SCCM 2207 Server. Issue: SCCM Reports appears in console for few seconds & then disappears and console shows "no items found", reappears after refreshing console multiple times & disappears again after few seconds. At the same time, below error gets generated in event viewer repetitively. Please help, need to fix this issue ASAP. System.Net.WebException\r\nThe underlying connection was closed: An unexpected error occurred on a receive.\r\n at System.Net.HttpWebRequest.GetResponse() at Microsoft.ConfigurationManagement.Reporting.Utility.GetFavoriteReportId() at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.FavoritesReportDisplayHelper.FavoriteReportIcon(IResultObject resultObject, String assemblyMethod, AssemblyDescription& resourceAssembly) at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.FavoritesReportDisplayHelper.ShowFavoriteReportIcon(Object sender, ScopeNode scopeNode, IResultObject resultObject, AssemblyDescription& resourceAssembly)\r\nSystem.IO.IOException\r\nUnable to read data from the transport connection: An existing connection was forcibly closed by the remote host.\r\n at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)\r\nSystem.Net.Sockets.SocketException\r\nAn existing connection was forcibly closed by the remote host\r\n at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)\r\n If i try to run report when its visible in console, (sometime) it runs properly but after some time it throws below error. The underlying connection was closed: An unexpected error occurred on a receive. ------------------------------- Microsoft.ConfigurationManagement.ManagementProvider.SmsException The underlying connection was closed: An unexpected error occurred on a receive. Stack Trace: at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters() at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject) at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) ------------------------------- System.Net.WebException The underlying connection was closed: An unexpected error occurred on a receive. Stack Trace: at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters() at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject) at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) ------------------------------- System.IO.IOException Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. Stack Trace: at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters() at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject) at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) ------------------------------- System.Net.Sockets.SocketException An existing connection was forcibly closed by the remote host Stack Trace: at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters() at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject) at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) ------------------------------- Thanks, MGPublished Date : 2023년 3월 23일 목요일
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 : 2023년 3월 23일 목요일
Azure Data Factory - On premise integration runtime for Multiple on-premise db servers. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192095/azure-data-factory-on-premise-integration-runtime Hi. I have the following scenarios: I have a pipeline that consumes data from an on-premises SQL server through an Integration runtime installed on that server. So far, so good. The thing is that the company has n system with the same database schema in different on-premise servers, and I want to re-use the same pipelines, datasets, and dataflows. I know I can parametrize the linked service but those servers are in different networks => I can't reuse the same integration runtime. My initial Idea was to create an integration run-time by the on-premise server (this is done), but now I face the problem that I can't dynamically tell the pipeline which integration runtime to use. I can't use the approach of replacing it in the pipelines, because those are **not different environments. (**In fact, I have it in place for my UAT, and PROD environment.) I could achieve this if I make the on-premise servers visible within the on-premise infrastructure and then yes, make parametrize the linked server, but I don't like the idea of forcing on-premise architecture (related to all the servers) because of that issue. Is there any idea? Thank you in advance!Published Date : 2023년 3월 23일 목요일
How to check backup retention period of a database via TSQL query - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192156/how-to-check-backup-retention-period-of-a-database Hi, I want to check the backup retention period of an already configured backup set in SQL server How can i check using TSQL query ThanksPublished Date : 2023년 3월 23일 목요일
Understanding CAL - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/214332/understanding-cal I would like to know what are the differences between Windows CAL and Windows CAL Remote Desltop. What is the difference between them? Why I need both for Citrix access? May i use a CAL for different servers? that is user "user1" would access to server "server 1" and "server2", how many cals does he need? 1 or 2? What is the aim of sql cal? Is for accessing a user to the sql server but do i need more cals such as Remote Desktop and Windows CAL? if i use a web app to access to the sql server do i need another cal? is there a number of cal included in the sql server license?Published Date : 2023년 3월 23일 목요일
is CVE-2022-37434 relevant for ODBC Driver for SQL Server? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192454/is-cve-2022-37434-relevant-for-odbc-driver-for-sql Hi, our Black Duck Binary Analysis reported ODBC Driver for SQL Server as security risk as it contains zlib library version 1.2.11 which contains vulnerability described in CVE-2022-37434. we would like to ask if this vulnerability is relevant for ODBC driver (if odbc driver uses inflateGetHeader call) and if it is relevant when we can expect new version of ODBC Driver for SQL Server with updated zlib to be released. Regards, Cernansky SAP Business One DeveloperPublished Date : 2023년 3월 23일 목요일
Fail to create a new database at Japan East region in Azure - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191680/fail-to-create-a-new-database-at-japan-east-region I can?t choose the field of compute+storage when I tried to create Azure SQL Single Database. The error message says ?Unable to retrieve the pricing configuration data for this region at this moment. Please retry.?. Can someone help me fix this issue? Thanks.Published Date : 2023년 3월 23일 목요일
SharePoint OnPremise application | Documents not getting searched - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192019/sharepoint-onpremise-application-documents-not-get Hi, We have an application hosted in SharePoint On Premise server. We are using SharePoint 2013. We have an issue in which there are some documents which are not getting searched as seen below. Can you let us know on how the issue can be rectified ? Regards, Nebu Thomas MathewPublished Date : 2023년 3월 23일 목요일
Subscriber database grows abnormaly - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1089264/subscriber-database-grows-abnormaly Hello, I have a problem with one of three Merge-replication subscribers. I synchronize four SQL Server 2016 with Merge-Replication over https. At one subscriber does the database grows abnormally to the other subscribers. On this server does the user works the whole time. Here the database sizes of the different servers: Publischer: 4GB Subscriber 1: 4GB Subscriber 2: 4GB Subscriber 3: 14GB I have already deleted, recreate the database and reinitialize the synchronization to this subscriber. After 10 hours has the database again 14GB. Does anybody have an idea why the third subscriber doing something like this? Thanks, StefanPublished Date : 2023년 3월 23일 목요일
Azure Data Factory Copy From SQL On premise to Azure Postgres? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192427/azure-data-factory-copy-from-sql-on-premise-to-azu Hi I am trying to do a simple copy actitivity in Azure Data Factory Data Pipelines. The source is a SQL On premise database. I can preview data fine. The Sink is a Azure Postgresql Cluster. The test connection returns with success. When I try to execute the pipeline it returns an error: 'Type=System.Net.Sockets.SocketException,Message=No connection could be made because the target machine actively refused it,Source=Npgsql,' If I change the Source to a CSV file everything works fine. I would prefer not to stage the data as files in Storage Lake if possible. Why do I get this error? Thanks in advancePublished Date : 2023년 3월 23일 목요일
azure sql database PAAS instance - system tables inaccessible - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192388/azure-sql-database-paas-instance-system-tables-ina I spined up Azure SQL Database which is PAAS instance only. I tried accessing System tables, but to my surprise they were not available. Please suggest-Published Date : 2023년 3월 23일 목요일
Subscription migration to different Tenant - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192136/subscription-migration-to-different-tenant Is it possible to migrate below resources in a subscription from one tenant to another tenant. We are planning subscription migration from one tenant to different tenant I have gone through below documentation https://learn.microsoft.com/en-us/azure/role-based-access-control/transfer-subscription but it doesnt talk about below resource and what additional things i need to take care before and after subscription migration to new tenant. 1- App service, app gateway 2- Private end point 3- SQL server and database 4- bastion 5- application insight 6- restore point collection 7- event hub name space 8- loganalytics workspace 9- function app 10 - recovery service vault Could you please let me know is it possible to migrate these resources and things that need to take care prior to migration.Published Date : 2023년 3월 23일 목요일
maximum number of on-premise database as sync member - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192402/maximum-number-of-on-premise-database-as-sync-memb Failed to perform data sync operation: Cannot create sync member 'EVAN-VMWARE' because the maximum number of on-premise database as sync member can be created under a sync group is 5 for Basic sync group I only 1 member now , cannot add second.Published Date : 2023년 3월 23일 목요일
How do I delete rows with certain characters in the data flow? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192076/how-do-i-delete-rows-with-certain-characters-in-th I want to delete this '?' row in the image in the data flow. Is there a better way to do this?Published Date : 2023년 3월 23일 목요일
How to fix MSSQL_101 "INSERTABLE columns list or UPDATABLE column list or key column list is not properly passed to the stored procedure." in Data Flow Sink? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1189803/how-to-fix-mssql-101-insertable-columns-list-or-up I am trying to load CSV rows from Data Lake into an Azure SQL Database. I use the upsert functionality of the data flow and parameterize it to be able to load the same data into different tables. this is how i designed my data flow: In the alter row activity i set UpsertIf to true() and allowed only upserts in the sink and added the corresponding key columns. When I run this i get the following error: Error code: DFExecutorUserError Failure type: User configuration issue Details: Job failed due to reason: at Sink 'sink1': ERRORCODE:MSSQL_101, STAGE:INPUT-VALIDATION, MESSAGE:INSERTABLE columns list or UPDATABLE column list or key column list is not properly passed to the stored procedure. The thing is that in some tables the data is upserted without any problems and in a few tables this issue comes up. Any suggestions on how to fix it? Thanks for your input! :)Published Date : 2023년 3월 23일 목요일
Restoring full backup of TDE database to alternate server. The media family is incorrectly formed. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192284/restoring-full-backup-of-tde-database-to-alternate I am trying to restore a full backup of a TDE encrypted database to an alternate server. I overwrite an existing database on the destination server - but the restore fails even if I try creating a new database. Prior to encrypting the databases, I was able to do this without any errors. I have imported the certificate from the source server to the destination server and generated the database encryption key from the certificate using the same algorithm as was used for the encryption key on the source server. The passwords for the the Master Key are different between the two servers. The password used to encrypt the certificate backup file on the source server is different from the password for the Master Key. When I created the certificate on the destination server, I gave it the same name as the certificate on the source server and used the password for the source certificate to decrypt. Source: Destination: I used the following options when generating the database backup: COPY_ONLY, NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, COMPRESSION I copied the .bak file to the destination server with a simple robocopy command. I tried to restore the database to the destination server with the following options: FILE=1, NOUNLOAD, REPLACE The restore operation fails with the message: "The media family on device 'D:\Backup\SourceDB.bak' is incorrectly formed. SQL Server cannot process this media family." and the database gets stuck in a (Restoring...) state. My research to this point has found three suggested causes for the error: Is the slight difference in the SQL Server versions enough to cause this error? Have I done something incorrectly in the encryption and/or backup-restore process? Any solutions or advice would be greatly appreciated.Published Date : 2023년 3월 23일 목요일
Error code =Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191841/error-code-microsoft-datatransfer-common-shared-hy Using a Copy Activity in ADF to copy a xlxs file to azure sql: Request URL: https://xxxxxxxxx.sharepoint.com/sites/Dataetc/_api/Web/GetFileByServerRelativePath(decodedurl='/sites/Dataetc/Billing/2023-02/Book1.xlsx')/$value Error: ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)Published Date : 2023년 3월 23일 목요일
How to fix this net framework error - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192213/how-to-fix-this-net-framework-error [ ](https://filestore.community.support.microsoft.com/api/images/ed0512c7-59a9-424c-852b-851af871195f?upload=true&fud_access=wJJIheezUklbAN2ppeDns8cDNpYs3nCYjgitr%2bfFBh2dqlqMuW7np3F6Utp%2fKMltnRRYFtVjOMO5tpbpW9UyRAwvLeec5emAPixgq9ta07Dgnp2aq5eJbnfd%2fU3qhn543qL0%2flZZboh5q1FH69AgT1W9W91zV43bPAPSKQkVsA7S6TbtqAhpEvWi3YU6fpOB7etEa6BW6rr6XWJzl2bFod6uBc24oSBv%2fRb05ga0oKSJYVGs9ZYm4oXNGeGywMzdbOtMC17vyllv423PgKHlog%2fuzfAkFuoqkoVFlXKa9r0weyr5zA6sG%2bq%2fOFVUU9YJhQlIsgWCA0jQniHL63%2b7bR2TFcD2k7p2uYHLVYVYxHyDqbSYcBiuazbuAaet54i%2bLRlaNQSaWBe11nqYqjS%2f6V314FnlwbJZQDSPm2GiBKQ%3d)Published Date : 2023년 3월 23일 목요일
SQL : Based on the DATE run the query and insert data into table and create stored procedure. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192374/sql-based-on-the-date-run-the-query-and-insert-dat HI All - Below is my current Query: The query runs daily now and appends the data into the Table1 but the problem is if the query runs on the same day twice or thrice it should truncate the data loaded on the same day. Lets say the query ran today at 8 AM and it inserted data into Table1 with the SnapShotDatetime of 03/22/2022 8: 00 AM But if the user wants us to re-run the query again at 1pm, it should truncate the data loaded ONLY on same day ( 8 AM) and then run the query and load the latest data at 1 pm. Similarly if the query/job runs at 10 pm then it should the 1 pm data.. Could you please help on how to do this in the query and create the final stored procedure so i can set it up as a SQL agent job. Thank youPublished Date : 2023년 3월 23일 목요일
Table option is not availble in design part in M S Visual studios 2022 community. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191458/table-option-is-not-availble-in-design-part-in-m-s The table option is not available in the design part of the M S Visual studios 2022 community. I have installed M S Visual Studios and this INSERT TABLE OPTION is available in 2019 but it's not available in 2022. I want to use M S Visual Studios 2022, Tell me about the changes I should make to make that option available.Published Date : 2023년 3월 23일 목요일
How do you impersonate as a different user/service id and then try and connect to sql server using windows authentication? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192013/how-do-you-impersonate-as-a-different-user-service This is my connection string Data Source =server;Initial Catalog=Database;Trusted_Connection=True;MultipleActiveResultSet=true;Integrated Security=SSPI; After establishing the connection string I am trying to test connection and here instead of it using my id to check whether I have access to the server I need it to check for the service id I am providing to test and establish connectionPublished Date : 2023년 3월 23일 목요일
How to pass a dynamic parameter as SQL query in for SQL dataset in Azure Data Flow? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/794352/how-to-pass-a-dynamic-parameter-as-sql-query-in-fo I am trying to run dynamic queries with a parameter in Azure Data Flow but I continue to get the "Column operands are not allowed in literal expressions" error. The parameter value is "SELECT * FROM Table WHERE Column in ('D1234','D1234','D1234','D8585','D6565','D7777','D4949','D2066','D2259','D5432')". I have tried all the ways to enter this parameter value, "{$parameter1}", {$parameter1}, $parameter1, ($parameter1) and I still continue to get the frustrating error. I have looked at all the documentation and forums relating to this issue but all of them continue to suggest the same ways I have tried to enter the value and none of it works. Any assistance would be greatly appreciated.Published Date : 2023년 3월 23일 목요일
Configure SQL warehouses - Azure Databricks - Databricks SQL
https://learn.microsoft.com/en-us/azure/databricks/sql/admin/create-sql-warehouse Learn about SQL warehouse requirements, how to configure and manage SQL warehouses using the Databricks SQL UI, and advance configuration options.Published Date : 2023년 3월 23일 목요일
Ensure Event processing in order - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190418/ensure-event-processing-in-order I have a Topic in Azure Service bus which is subscribed by an external process to write (insert or update) data in the message to a database (SQL Server). I noticed that at times, two different messages with the same database key could arrive/publish in the topic at the same time resulting in one of the message being inserted in the DB table and the other being errored with 'duplicate key' on the table. Is there a way I can add some extra latency in the Topic (Subscription) to ensure messages are processed/consumed in order and with some wait time? Any alternate services in Azure (like Event Hub or Storage Queue) that could handle this requirement better? Thanks in advance!Published Date : 2023년 3월 23일 목요일
Azure data factory, self hosted IR copy activity fails - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192301/azure-data-factory-self-hosted-ir-copy-activity-fa Hi I'm trying to create a copy activity with the self-hosted IR connected to on-premise oracle db and the destination is azure SQL db. i have installed self-hosted IR and the linked service for oracle db is working fine and i can preview the data from the tables. but during the copy activity fails and says the connection is not established. and in the IR config. manager the https proxy should be enabled or direct access has to be set up .. thanks in advancePublished Date : 2023년 3월 23일 목요일
Installation failed after downloading on windows 11 for microsoft sql server 2022 Exit Code (Decimal) 2061893606 - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192330/installation-failed-after-downloading-on-windows-1 Hi all I urgently need help with the following: Whilst trying to download and install Microsoft SQL Server 2022 on my Samsung laptop with the following specs: Processor12th Gen Intel(R) Core(TM) i5-1235U, 1300 Mhz, 10 Core(s), 12 Logical Processor(s) BIOS Version/Date American Megatrends International, LLC. P08CFG.033.220913.HQ, 13/09/2022 System Type x64-based PC OS Name Microsoft Windows 11 Home Version 10.0.22621 Build 22621 I experienced the following error during the installation: Summary_PoojiesLaptop_20230322_205449 SystemConfigurationCheck_Report - shows no errors. System Configuration Check Report for Microsoft SQL Server 2022_files.pdf Thanks, PoojaPublished Date : 2023년 3월 23일 목요일
deploying win form app with sql server express and create the database of the project on the client machine during installation - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192146/deploying-win-form-app-with-sql-server-express-and Hello guys how are you doing , i have developed my first winform application i created a database in SQL server management studio and everything is working well on my computer , now i want to deploy the application to be working on the client machine so i need to include the sql server as well as creating the database during the installation . i have managed i have tried to copy the mdf file of the database on the client machine and attach it using SQL server management studio and it worked fine , so my question is .... how to make the setup files create and include the mdf file in the right directory ?? so i do not need to install sql server managemnt on the client machine and copy the mdf file manually !! i was thinking the whole operation should be executed during installation and no need for extra unPublished Date : 2023년 3월 23일 목요일
???????????? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192354/question-1192354 ?????????????Published Date : 2023년 3월 23일 목요일
Questions about MS SQL licensing. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192045/questions-about-ms-sql-licensing We are looking to introduce Windows Server Standard and SQL Server Standard. I will be installing it on a 20core server. This is a role that temporarily aggregates data from another server and sends it to another server. In this case, should we use SQL Server/CAL. Should I purchase CALs for the number of servers and developers involved? Or should I purchase it for the total number of members? Also, if we downsize SQL Server to 10 core via Hyper-V and purchase it as a core license, what are the required licenses?Published Date : 2023년 3월 23일 목요일
ERR_HTTP2_PROTOCOL_ERROR only for /ReportServer URL but not for /Reports URL - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192315/err-http2-protocol-error-only-for-reportserver-url I have a wildcard cert stored in the Certs database on my Windows 2022 Data Center host. I configured SQL Server Reporting Services 2017 so that both the Web Service URL and Web Portal URL have the wildcard cert connected and port 443 is specified for All IPv4. Here is the configuration for the Web Service URL: Here is the configuration for the Web Portal URL: If I then use the https://hostname.nwm.doe.gov/Reports URL, it all works however if I use the https://hostname.nwm.doe.gov/ReportServer URL, I get this error: Clicking on the i to the left of the URL gives this information: This site does not have a certificate. plus some additional information about security. Can anyone give me a hint on why the /ReportServer virtual directory doesn't see the certificate?Published Date : 2023년 3월 23일 목요일
SSMS Azure connection error - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192236/ssms-azure-connection-error I want to connect my DB with SSMS to the AZURE container, somehow I get the operating system error 50(request not supported). I set up a container, SAS key and the Azure Storage Acc. This is for an university project and I am not that advanced in SQL Server management. Every help is welcomePublished Date : 2023년 3월 23일 목요일
How to access to on premise SQL server from an Azure VM - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192168/how-to-access-to-on-premise-sql-server-from-an-azu I have set up a virtual machine (VM) on Microsoft Azure and I need to access an SQL Server instance that is located on my private network. Currently, access to this SQL Server instance is restricted to connections originating from within the local network or through a VPN connection. However, I do not want to set up a new VPN on my private network in order to access the SQL Server instance from the Azure VM. I have already attempted to set up an hybrid connection manager on a server that is on the same network as my SQL server. This hybrid connection manager uses an Azure Relay Service, but I have been unable to get my Azure VM to communicate with the Azure Relay Service. My end goal is to be able to access the SQL Server instance from the Azure VM without having to install a VPN. What are my options to achieve this? Can I configure some kind of secure connection between the Azure VM and the SQL Server instance using the Azure Relay Service? If so, what steps do I need to follow to set this up? Thank you! ThomasPublished Date : 2023년 3월 23일 목요일
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 : 2023년 3월 23일 목요일
개체 이름 지정에 대한 제한 사항 및 규칙 - Azure DevOps
https://learn.microsoft.com/ko-kr/azure/devops/organizations/settings/naming-restrictions 길이, 고유성 및 특수 문자별로 조직, 프로젝트, 태그, 템플릿 등과 같은 개체의 레이블 지정 일관성에 대한 요구 사항입니다.Published Date : 2023년 3월 23일 목요일
How to Display multiple columns in WinForms combobox? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192007/how-to-display-multiple-columns-in-winforms-combob This picture is Access 2010.Data come from SQL. I tried to move to Winform. I know how to bind data sources. Can WinForms combobox do the same? Show 3 columns and titles, When a row is selected, return only Plan_no. I am new, maybe I need more detailed examples or code. Thank you so much.Published Date : 2023년 3월 23일 목요일
Azure Data Factory - Copy Activity fails intermittently with "Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation" - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191853/azure-data-factory-copy-activity-fails-intermitten Azure Data Factory - Copy Activity fails intermittently with the following error message: Operation on target SqlServer_to_ADLS failed: Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Upload file failed at path devlake/jbtrn_owner_alloc\jbtrn_owner_alloc.parquet.,Source=Microsoft.DataTransfer.Common,''Type=System.Data.SqlClient.SqlException,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.),Source=.Net SqlClient Data Provider,SqlErrorNumber=64,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=64,State=0,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.),},],''Type=System.ComponentModel.Win32Exception,Message=The specified network name is no longer available,Source=,' Source: SqlServer Target: Azure Data lake Gen 2. Steps already tried that didn't help: Things to note: The part that is not clear is if the error is occurring on the source SQL database or the Azure Data Lake Storage.Published Date : 2023년 3월 23일 목요일
In windows server 2019 install sql service, Terminal service and domain controller, so how can i migrate vm to azure vm with all existing licesnce. - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191433/in-windows-server-2019-install-sql-service-termina how to migrate windows server 2019 AWS VM with installed Domain controller, SQL, and Terminal services to azure VM with all existing licenses. Regards Ram WaghmarePublished Date : 2023년 3월 22일 수요일
Azure Data Factory - Copy Data Task - Upsert not working as intended? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1190854/azure-data-factory-copy-data-task-upsert-not-worki How is an Upsert in Azure Data Factory supposed to work? This is the source data: This is the sink data I get after the first run of the Copy Data Activity, with Upsert activated and the first 2 columns as keys: I thought I would end up with just one record per key combination. Something like this: 79540;20230316;1 79560;20230316;2 79530;20230316;3 It even gets worse if I run the pipeline a second time. I then get this: I now have twice as many records as before and at this point, the data is useless and wrong. This the source tab in the Copy Data Activity: This is the query: SELECT taxonomie_id,dim_date, screenPageViews FROM stg0_ga4.dateScreenPageViews_Page ORDER BY 2 DESC,1 DESC; This is the sink configuration: What am I doing wrong? Do I missunderstand the concept of the upsert functionality? Thank you very much!Published Date : 2023년 3월 22일 수요일
Cant get all the data from rest api to Sql using adf - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191642/cant-get-all-the-data-from-rest-api-to-sql-using-a HI I am trying to load data from Rest ApI into Azure Sql db using ADF. Its only showing 100 rows in sql table. Preview data Snippet How should I setup the pagination to get entire data regards, NarenPublished Date : 2023년 3월 22일 수요일
자습서: SSMS를 사용하여 첫 번째 관계형 데이터베이스 디자인 - Azure SQL Database
https://learn.microsoft.com/ko-kr/azure/azure-sql/database/design-first-database-tutorial SQL Server Management Studio를 사용하여 Azure SQL Database에서 첫 번째 관계형 데이터베이스를 디자인하는 방법을 알아봅니다.Published Date : 2023년 3월 22일 수요일
Log Replay Service 개요 - Azure SQL Managed Instance
https://learn.microsoft.com/ko-kr/azure/azure-sql/managed-instance/log-replay-service-overview Azure SQL Managed Instance의 Log Replay Service에 대해 알아봅니다.Published Date : 2023년 3월 22일 수요일
How to do manual backup of Azure Sql database and restore it in a elastic standard Sql server - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191873/how-to-do-manual-backup-of-azure-sql-database-and Hi there, I am having two elastic standard SQL servers in Azure (one for test & one for live ). I'm moving one my AdventureWorksDB(for reference) from test server to live sever in order for the first time live application setup. Steps followed: By logging into test sever using SSMS instance, I am taking backup(.bacpac) file of one of my AdventureWorksDB & storing it in storage container by clicking on Export data-tier application & now I logged into live instance using ssms and when I right click on AdventureWorksDB (which is newly created using elastic pool & other required settings without schema & data ) , if I right click there is no option to restore or import data-tier application, The only option I am left with is to right click on databases and click on Import Data-tier Application But if I do so , A new AdventureWorksDB*21_*03_2022 is getting created which is not part of the elastic pool , which doesn't serve my purpose . could someone help me on thisPublished Date : 2023년 3월 22일 수요일
LINQ to SQL 변환 - Azure Cosmos DB for NoSQL
https://learn.microsoft.com/ko-kr/azure/cosmos-db/nosql/query/linq-to-sql 지원되는 LINQ 연산자 및 LINQ 쿼리가 Azure Cosmos DB의 SQL 쿼리에 매핑되는 방법을 알아봅니다.Published Date : 2023년 3월 22일 수요일
Azure 리소스 로그 지원 서비스 및 스키마 - Azure Monitor
https://learn.microsoft.com/ko-kr/azure/azure-monitor/essentials/resource-logs-schema Azure 리소스 로그에 대해 지원되는 서비스 및 이벤트 스키마에 대해 알아봅니다.Published Date : 2023년 3월 22일 수요일
Azure VM에서 성능 모니터링 - Azure Application Insights - Azure Monitor
https://learn.microsoft.com/ko-kr/azure/azure-monitor/app/azure-vm-vmss-apps Azure 가상 머신 및 가상 머신 확장 집합에 대한 애플리케이션 성능 모니터링.Published Date : 2023년 3월 22일 수요일
자습서: Microsoft Azure Maps를 사용하여 매장 로케이터 웹 애플리케이션 만들기 - Microsoft Azure Maps
https://learn.microsoft.com/ko-kr/azure/azure-maps/tutorial-create-store-locator Microsoft Azure Maps를 사용하여 매장 로케이터 웹 애플리케이션을 만드는 방법에 대한 자습서입니다.Published Date : 2023년 3월 22일 수요일
StorSimple 8000 시리즈 솔루션 개요
https://learn.microsoft.com/ko-kr/azure/storsimple/storsimple-overview StorSimple 계층화, 디바이스, 가상 디바이스, 서비스, 스토리지 관리에 대해 설명하고 StorSimple에서 사용하는 주요 용어를 소개합니다.Published Date : 2023년 3월 22일 수요일
자습서: 웹 서비스를 Bing Maps에서 Microsoft Azure Maps로 마이그레이션
https://learn.microsoft.com/ko-kr/azure/azure-maps/migrate-from-bing-maps-web-services Bing Maps에서 Microsoft Azure Maps로 웹 서비스를 마이그레이션하는 방법에 대한 자습서.Published Date : 2023년 3월 22일 수요일
Download SQL Serve 2008 Standard Edition R2 - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1191549/download-sql-serve-2008-standard-edition-r2 I am looking for MS SQL 2008 R2 Standard Edition download media to support a legacy application but can't find it. Would be great if someone could help. ThanksPublished Date : 2023년 3월 22일 수요일
Azure App Service에 ASP.NET Core 앱 배포
https://learn.microsoft.com/ko-kr/aspnet/core/host-and-deploy/azure-apps/ 이 문서에는 Azure 호스트 및 배포 리소스의 링크가 포함됩니다.Published Date : 2023년 3월 22일 수요일
Install-Package : Dependency loop detected for package 'Microsoft.SqlServer.SqlManagementObjects' - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192303/install-package-dependency-loop-detected-for-packa Hi, I'm having a rough time trying to install SQL SMO to a server. This is my first time trying Nuget. Previously I would use the .msi. I'm running the following from Admin PowerShell ISE: I'm receiving the following error: With the verbose flag enabled, I see the following package is seemingly tried twice (the second time is when the process aborts and the error is thrown): System.Memory. Any help will be appreciated! Thanks, Taarik.Published Date : 2023년 3월 22일 수요일
시험 DP-100: Azure에서 데이터 과학 솔루션 설계 및 구현 - Certifications
https://learn.microsoft.com/ko-kr/certifications/exams/dp-100 시험 DP-100: Azure에서 데이터 과학 솔루션 설계 및 구현Published Date : 2023년 3월 22일 수요일
How can we add multiple IP addresses to the firewall rules on Azure SQL Server? - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1192266/how-can-we-add-multiple-ip-addresses-to-the-firewa How can we add multiple IP addresses or IP address in CIDR to the firewall rules on Azure SQL Server?Published Date : 2023년 3월 22일 수요일
DataCoverageDefinition.Description 속성 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.datacoveragedefinition.description 디자인 타임에 개발자와 SQL Server Management Studio 같은 관리 도구의 관리자에게 표시되는 DataCoverageDefinition에 대한 설명입니다.Published Date : 2023년 3월 22일 수요일
Hierarchy.Description 속성 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.hierarchy.description 개발자에게는 디자인 타임에 표시되고 관리자에게는 SQL Server Management Studio와 같은 관리 도구에 표시되는 계층의 설명입니다.Published Date : 2023년 3월 22일 수요일
ModelRole.Description 속성 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.modelrole.description 디자인 시에는 개발자에게 표시되고, 관리 도구(예: SQL Server Management Studio)에서는 관리자에게 표시되는 역할에 대한 설명입니다.Published Date : 2023년 3월 22일 수요일
CalculationItem.Description 속성 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.calculationitem.description 디자인 타임에 개발자와 SQL Server Management Studio 같은 관리 도구의 관리자에게 표시되는 CalculationItem에 대한 설명입니다.Published Date : 2023년 3월 22일 수요일
Server.ProductName 속성 (Microsoft.AnalysisServices.Core)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.core.server.productname Analysis Services 인스턴스가 설치된 SQL Server 제품의 이름에 대한 읽기 전용 권한을 가져오거나 설정합니다.Published Date : 2023년 3월 22일 수요일
Partition.Description 속성 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.partition.description 디자인 시 개발자에게 표시되고, 관리 도구(예: SQL Server Management Studio)에서 관리자에게 표시되는 파티션에 대한 설명입니다.Published Date : 2023년 3월 22일 수요일
DataSourceProtocol.SqlAnywhere 필드 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.datasourceprotocol.sqlanywhere sql-anywherePublished Date : 2023년 3월 22일 수요일
DataSourceProtocol 클래스 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.datasourceprotocol 가능한 DataSource.Protocol 값Published Date : 2023년 3월 22일 수요일
DatasourceIsolation 열거형 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.datasourceisolation 데이터 원본에 대해 명령을 실행할 때 SQL 문의 잠금 동작을 제어합니다.Published Date : 2023년 3월 22일 수요일
ActionType 열거형 (Microsoft.AnalysisServices)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.actiontype Action 속성의 형식을 정의합니다.Published Date : 2023년 3월 22일 수요일
ProviderDataSource.Isolation 속성 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.providerdatasource.isolation 데이터 원본에 대해 명령을 실행할 때 SQL 문의 잠금 동작을 지정합니다. 유효한 값에는 커밋된 트랜잭션에서만 읽을 수 있는 ReadCommitted(기본값) 또는 트랜잭션 측면에서 일관되지 않은 트랜잭션에서 문을 읽을 수 있는 Snapshot이 포함됩니다.Published Date : 2023년 3월 22일 수요일
Column.DataCategory 속성 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.column.datacategory 열 형식에 따라 사용자 지정 동작을 추가할 수 있도록 열에 포함된 데이터의 형식을 지정합니다. 248개의 가능한 값이 있습니다. 첫 번째 10개는 Invalid (-1), All (1), Regular (2), Image (3), ImageBMP (4), ImageGIF (5), ImageJPG (6), ImagePNG (7), ImageTIFF (8), ImageURL (9), Id (10)입니다. 나머지는 MSDN에서 MS-SSAS-T SQL Server Analysis Services 테이블 형식 프로토콜 설명서를 참조하세요.Published Date : 2023년 3월 22일 수요일
DataItem.Format 속성 (Microsoft.AnalysisServices)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.dataitem.format DataItem 값에 대한 서식 속성을 가져오거나 설정합니다.Published Date : 2023년 3월 22일 수요일
DataSource 클래스 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.datasource 테이블 형식 Model에 대한 가져오기, 새로 고침 또는 DirectQuery 작업의 외부 데이터 원본에 대한 열린 연결을 정의합니다.Published Date : 2023년 3월 22일 수요일
ScalarMiningStructureColumn.Validate 메서드 (Microsoft.AnalysisServices)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.scalarminingstructurecolumn.validate ScalarMiningStructureColumn 개체가 유효한지를 나타냅니다.Published Date : 2023년 3월 22일 수요일
Level 클래스 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.level 클라이언트 애플리케이션에 대한 논리적 계층 드릴다운 경로를 제공하는 계층의 수준을 나타냅니다. Hierarchy 개체의 자식입니다. 수준은 열의 값을 기반으로 합니다.Published Date : 2023년 3월 22일 수요일
DataCoverageDefinition 클래스 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.datacoveragedefinition 테이블 형식 DataCoverageDefinition 개체입니다. 이 개체에 정의된 식은 파티션의 데이터에 대한 힌트를 제공합니다.Published Date : 2023년 3월 22일 수요일
KPI 클래스 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.kpi 핵심 성과 지표 개체를 나타냅니다. Measure 개체의 자식입니다.Published Date : 2023년 3월 22일 수요일
NamedExpression 클래스 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.namedexpression 하나 이상의 파티션에서 사용할 수 있는 명명된 식입니다.Published Date : 2023년 3월 22일 수요일
Hierarchy 클래스 (Microsoft.AnalysisServices.Tabular)
https://learn.microsoft.com/ko-kr/dotnet/api/microsoft.analysisservices.tabular.hierarchy 클라이언트 애플리케이션에 대한 논리적 계층 드릴다운 경로를 제공하는 수준 컬렉션을 나타냅니다. Table 개체의 자식입니다.Published Date : 2023년 3월 22일 수요일