How does large on-prem SQL database with multiple files fill up
I got a large database with one filegroup having multiple data files spread across 2 disks. But one of the 2 disks is larger than other, with all data files on both disks have Autogrowth disabled, and the value "is_autogrow_all_files" is set…
Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.
Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…
Will the MS SQL Server 2022 STD License and Windows Server 2019 OS License works on same Hardware after System motherboard get replaced
Hello, I had a HP Proliant ML30 Server running Windows Server 2019 STD and MS SQL Server 2022 STD running with license. Recently the motherboard got issue and HP said to get it replaced. So i have a question about its license if it will work normally…
Contact Microsoft support
How can i contact Microsoft for direct support for my issue?
Connect to Linked Server Database using Azure Data Factory
Hi! I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?
Migrate On prem to Azure Sql Managed instance
I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance. I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without…
Can i use SQL 2022 Express edition in production environment for my small business?
Can i use SQL 2022 Express edition in production environment for my small business?
unable to connect to our reports from ssrs
We are unable to connect to our Microsoft 2019 reporting server reports after installing certificate. I have try connect with with these option: http://ip/reports http://servername/reports I was also altered rsrepotsser.config file to get things…
SQL Server Express 2022 Reinstall
Hi I have a question regarding the install process of SQL Server 2022 Express. I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled SQL…
syspolicy_event_queue disabled automatically
The msdb service broker queue syspolicy_event_queue is disabled automatically, messages are not processed and keep growing until taking full drive space. Here is the error message from Log File Viewer : I have sql server 2022, CU12. I have executed the…
SQL server backup in a 2019 VM to s3 using backup URL
Hi I have set up a Windows Server 2019 VM with SQL server 2016. I want to take the backup of SQL server in AWS S3. It should have monitoring and auditing capability and cost effective and secure. I have looked at below…
How can you enforce restrictions on user access to a database table, preventing indirect access through views, procedures, or GUI operations, without relying on SQL scripts?
The question is about securing access to a database table in such a way that restrictions apply even when users access the data indirectly through views, procedures, or GUI operations, all without using SQL scripts.
Tail log backup
Are tail log backups supported only in Full Recovery model?
GDR upgrade path question
I have a SQL Server updated to version 15.0.4326.1, which is on the GDR path but on a GDR + CU version. Can I install the next update on the GDR path to go to version 15.0.2110.4 that is GDR only, or do I have to install the next GDR + CU update?
How to subscribe to Microsoft for CU updates
I will like to subscribe to Microsoft so that I can get the latest CU patches immediately Microsoft have a release. How do I go about this? Please can someone send the SPECIFIC LINK to get this done
How to Fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
I am doing a Import Data from an Excel spreadsheet to a table. I get the following message : Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. What will resolve this error?
connect to server
TITLE: Connect to Server Cannot connect to.... ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is…
Azure Data Share to Share data from Azure Managed Instance SQL Server
As part of my migration project requirements, I am looking to share data from my source system which is in Azure MI SQL Server and to the target system which is also in Azure MI SQL Server. I need to share the source data which is in Azure MI SQL Server…
Use SSMA for DB2 to Migrate AIX DB2 11.5.9 to SQL Server 2019
Is it possible to use the SSMA tool to migrate an AIX DB2 (Big endian) to Windows SQL Server 2019 (little endian)?
TITLE: Microsoft SQL Server 2014 Setup ------------------------------ The following error has occurred: An error occurred during the installation of assembly 'Microsoft.VC80.CRT,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchite
i am unable to download it , i am gettimg an error