Fin Table By Value
Hello, I have an Network Performance Monitoring tools, and i create custom script to get some values for windows server. The script is run successful and return a value let say 565523. The problem is i want to make custom report and the vendor is not…
![](https://techprofile.blob.core.windows.net/images/zCxR1gzTUkeGX5-wM6PGoA.png?8DB52A)
![](https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953)
SQL Distinct
Hello, I have record like below pic and need to filter so the output only have one record for each NodeID and sort by InstallDate. How I can do this by SQL?
![](https://techprofile.blob.core.windows.net/images/zCxR1gzTUkeGX5-wM6PGoA.png?8DB52A)
![](https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953)
Add nodes to failover cluster
Hi All i am using windows server 2022, i want to add two nodes to failover cluster manager(these will be sql nodes). my VMs are hosted on azure, i am using quorum as cloud witness(i.e storage account). When adding nodes to windows 2019 cluster i used the…
SQL71501: Error validating element while activating always encrypted
I was activating always encryted in my database when this error showed: Error SQL71501: Error validating element [dbo].[VIEW_NAME]: View: [dbo].[VIEW_NAME] contains an unresolved reference to an object. Either the object does not exist or the reference…
Loading of OLTP In-Memory DBs in SQL 2022 on Ubuntu really slow
We've started using OLTP In-Memory tables (schema durability only) in a small DB (DB properties show 137 MB of Row data, 1GB of In-Memory data, BAK size of 152MB) and the recovery times (either restarting the SQL service or restoring the DB from a BAK…
SQL Server Management Studio 18 remember password not working?
With one of the latest updates of SSMS 18 (I'm now on 18.6), the remember password feature does not seem to work anymore. Am I missing something? Cheers, Galletto
![](https://techprofile.blob.core.windows.net/images/8YhZgP8_AwAAAAAAAAAAAA.png?8D84F1)
ApplicationName in project connection manager
We have a large number of packages within an SSIS project and these make use of project connection managers. I would like to change the ApplicationName property of the connection string to reflect which package it is coming from as this will be useful…
ADX/KQL through SQL linked server
Hello, Recently we have created a linked server in SQL Server and connection operates well. This link server targets an ADX cluster, and a named database.Nevertheless, I admit that I am quite familiar with SQL language, but I never been able to retrieve…
VS2019 - Connection Managers not saving passwords
I have an issue where passwords are not saving in the connection managers in my solution. I am able to add in the password and test it, then I ok it, however, when I go back in the password has disappeared. I have done some reading on this and one…
Is there support for SQLCMD in ODBC Driver 18?
Hi, Do you know when there will be support for SQLCMD using ODBC Driver 18? Currently only Version 17 supports SQLCMD looking at documentation.…
Track data
Hi How can I track the data changes of a heavily used table in AG without performance impact in SQL 2017 and SQL 2022 Thanks
SQL Data Migration Assistant, what actually happens during migration?
Migrating in-house SQL 2014 databases to a new, in-house SQL 2019 server. Reading all the documentation I don't see where it explains what happens to the source databases during the migration process. Are they backed up, then taken offline/detached and…
MDX request to System SSAS cube does not display the results
Hello, I'm trying to do some requests to analyse the usage of our cubes. All requests on $SYSTEM.DISCOVER_SESSIONS made in Microsoft SQL Server Studio or even in PowerShell are working well. However, everytime I try to request…
SQL Procedure getting exit upon called
I have a sql stored procedure created which will be getting invoked for multiple tables and column sequence wise.There are multiple DDL scripts which have procedure call and these scripts will get executed via sqlcmd command.So there is a folder X which…
Connection between on-premises SQL server with Azure data factory
I tried to connect my local SQL server to Azure data factory but getting this error. Credentials are ok I double checked it Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'localhost', Database: 'XXXXXXXXXX',…
Shrink Logs for a Database in Single Recovery mode
Dear All : i have an instance containing many databases, 3 databases have a big transaction log (12 GB, 9 GB, 4 GB) and consuming space from the partition. the 3 databases are simple recovery way. is there a way to shrink the log for these databases to…
MICROSOFT SQL SERVER ERROR
SQL cannot attach a specific database and it show the logs has been corrupted, how could I resolve this w/out restoring the backup see the attach photo for your reference
![](https://techprofile.blob.core.windows.net/images/c1a58ec1-0037-47f5-a6ca-7f79a74b715e_Sassan.jpg)
Unable to download SQL Server Master Data Services Add-in for Excel Plugin
Does anyone know of a working download link for the SQL Server Master Data Services Add-in for Excel? I receive an "Internal Server Error" when attempting to download from both the Microsoft Learn and Microsoft Download Center links. Any…
![](https://techprofile.blob.core.windows.net/images/SClx3RWTrEKkXmthAyq7Tw.png?8DC805)
Multiple Users Read/Write to same SQL record
Hello, I have a pretty simple database that is read and written to through an asp.net c# website. Users see a grid with data and they can open a record to make changes. More than one user can open that same record, and what I am finding out is that when…
![](https://techprofile.blob.core.windows.net/images/SClx3RWTrEKkXmthAyq7Tw.png?8DC805)
Use SQL Server 2022 License Key to Install SQL Server 2019
Hi, I have installed SQL Server 2019 on our cloud EC2 Windows server machine using the SQL Server Evaluation Edition with a 180-day free trial. We intend to purchase the SQL Server 2022 Standard Edition key. Can we use this key to activate the SQL Server…
![](https://techprofile.blob.core.windows.net/images/SClx3RWTrEKkXmthAyq7Tw.png?8DC805)