Does ADO.NET support multi-subnet failover for SQL connections, and how does this feature compare to ODBC's multi-subnet failover support?
I am using ADO.NET for SQL connections. Does ADO.NET support multi-subnet failover? I understand that ODBC supports multi-subnet failover. Can you explain the difference between ADO.NET and ODBC in this regard?
SSIS 2019 - Identify and Redirect Duplicate Values in Data Flow
Hello, To be clear this is not a requirement to identify and redirect or dedupe rows in the data flow task leveraging the Sort Transformation. Instead, the requirement is to identify the duplicate values in a column then handle affected rows…
How to show "Design a new Report" in Report Viewer tool in Microsoft Visual Studio 2022. Need help ASAP.
I already search some tutorials in youtube but i cant find anything. In my machine, i cant see the "Design a new Report" in Report viewer tool like i saw in my tutorial video that i follow in youtube. i will paste pictures so you can see it. I…
where do I download a copy of sql server MDM for testing
I AM TRYING TO SHOW A CLIENT WHAT MDM FOR SQL SERVER CAN DO.
Licensing for read a database master in sql server always on
Good morning, I'm wondering about the licenses to have on the nodes of an Always On cluster. We have the main node and two passive secondary nodes. In order to monitor the good state of a cluster I made a procedure stored in the master database which…
Slow queries to INFORMATION_SCHEMA after upgrade to SQL 2022
Hello! We have a Microsoft SQL Server 2022 (RTM-CU12-GDR) (KB5036343) - 16.0.4120.1 (X64) Mar 18 2024 12:02:14 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 22.04.4 LTS) <X64> We are selecting a scalar…
Mssql express installation failure
I am trying to install sql express on my laptop but i am unable to i have attached the error message and error file Summary_DESKTOP-JU2JTT1_20240604_154222.txt
System Database Backups for Azure SQL Managed Instance
I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…
sql 2022 python310 ML
Hello , I'm trying to make python and Machine learning working with SQL server 2022 by following this guide: https://learn.microsoft.com/en-us/sql/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022?view=sql-server-ver16 …
how to schedule power bi reports for email delivery?
how to schedule power bi reports for email delivery?
Why is my AdventureWorks not coming with the tabels included
When I download Adventureworks are renew, there are no tables included, any help would be great: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms The OLTP one Many thanks
Return End of String Between 2 Brackets - SSIS Derived Column Expression
Hello, The difficulty of extracting the error column name in an SSIS data flow is widely recognized. To meet the requirement of minimizing scripting transforms/components, I cannot use a complex scripting solution to identify error columns in the…
left and right join
Hi, table 1 Table 2 select A.* from table1a LEFT join table2 b on a.col1=b.col1 output: which is correct but on right join it shows above results how to calculate this join and how it will react on NULL and blank
Table was last accessed in SQL Server database
Hi All, We have SQL Server DB with 1000+ tables. We are planning to rename unused tables as a _temp and delete _temp tables from DB after few weeks If there is no issues/complaints from users. This exercise is to reduce DB size from TB to GB and reduce…
increase in database size
Hi All, We have a 2 TB disk to stored of the sql database files. db has 3 data files and 1 log file. log file is stored on a different drive. The issue is with the data file drive. Current disk usage (E:\ drive) reached is 1.20 TB out of 2TB. After…
indexes - cleanup
Hi All, Need some suggestions on how to disable or drop some of the unused indexes? Regards, Sam
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…
How to copy an SSAS cube
Good day, I have a cube in SSAS for one financial period, that I wish to replicate for a new financial period, how can I achieve this? Please assist Many thanks
Cannot connect to SQL Database. Please contact SQL server team for further support
Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…