Trouble reading cosmos DB account without key based authentication
I recently disabled localauth (key based authentication) in Cosmos DB account. Now, I am not able to access it, neither through data explorer nor through https://cosmos.azure.com/?feature.enableAadDataPlane=true. I am getting this error: principal does…
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?
Trouble Retrieving Feature Flag Configuration Setting: Getting a "404 Not Found" Error
Hello, I'm encountering an issue while trying to retrieve a configuration setting using the following code: Response<ConfigurationSetting> response = client.GetConfigurationSetting(FeatureFlagConfigurationSetting.KeyPrefix +…
Databricks jobs are failing with the insufficient privileges error
When running the jobs in databrick user is getting the insufficient privilege error, but user do have all the privileges like select, read_metadata, modify, create and owner as well on the respective database.
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…
I changed my account to an internal account by accident on Azure
I was playing around with permission in Azure and ended up changing the main account to internal instead of external. I cannot access my account any more, and can't even create a request and a phone call to my regional office just told me me to create…
Sharepoint JSON Formatting for dates that is past due for 3 days from the current working date
Hi, For your assistance, please. I'm having another problem on my other Sharepoint list that I'm creating. I'd need to have a particular cell to be highlighted as red if it is already beyond the current date (weekends and holidays should not be…
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)?
2016 smtp rely server I need to migrate to 2019
Hello, I have a server 2016 with SMTP setup on it and I need to migrate it to server 2019. Is there an easy way to do this?
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
How to grant permission to the keyvault to fetch secrets.
I am trying to change the connection to the DB by using the keyvault -instead of hardcoding everything. I've seen then you can retrieve all of the "secrets" by generating your client (with the key vault) and then simply call the…
How to solve secondary availability group is an unhealthy status in SQL server distributed availability group?
Hello, I would like to help one thing that is my SQL server issue. When I create distributed availability group, secondary available group is show an unhealthy status in SQL server Clustering. Please see the below photo. I already alter in secondary AG…
Lsass.exe error causing machines to restart - EventID 1000
Hello! My organization has recently encountered an issue in Windows 10 with lsass.exe failing and causing machines to restart, seemingly at random. This is happening to multiple computers. I would great appreciate some help in figuring out what is…