How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website.
Hi, How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website. Please Help
SQL Server
SQL Server Reporting Services
SQL Server Analysis Services
Transact-SQL
Best Practice to Decide Partition Table in SQL Server
Hi All, We have a database on SQL server with a large size (about 20 TB) and we plan to partition the existing tables in the database. but we are still confused to determine whether to partition the table, whether it should be partitioned…
SQL Server
SQL Server Analysis Services
Transact-SQL

Incorrect final summation in tabular model
Good day. I encountered a problem with incorrect aggregation. There is a dimension in the system with a hierarchy built in it. During aggregation, incorrect summation of data for hierarchy members occurs. At the same time, with each processing on the…
SQL Server Analysis Services
Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length
Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…
Azure Synapse Analytics
SQL Server Analysis Services
Best Way to Sync/Mirror a Database Without Primary Keys to Azure Analytics (Fabric, Synapse, Databricks)?
I’m exploring solutions to sync/mirror an external database (SQL Server/Azure SQL DB) to Azure analytics services (Microsoft Fabric, Synapse, Databricks), but my source tables do not have primary keys (PKs). Current Challenges: Explored Synapse sync…
SQL Server Analysis Services

How to create ISAPI Filter in visual studio 2012 onwards
Hi Team, We are using MSMD Pump for our analysis services. where, it is hosted on IIS and shared URL to users those are accessing our cubes without having explicit access on our cube server. But now we have a requirement to track all the request…
SQL Server Analysis Services
Windows Server

IDbConnection error on process SASS database caused by Windows updates
Hello, At some point, our developer instance of Analysis Services started to give an error: Errors in the high-level relational engine. . The exception was raised by the IDbConnection interface. It does not contain any on what is wrong with it. It…
SQL Server Analysis Services
Windows Server

Discrepancy Between Installer name and Product Version of Microsoft Analysis Services OLE DB Provider
Hi Team, We are 3rd party patch provider like PatchMyPC or ManageEngine where we are providing the metadata on how to deploy the application silently. Please refer - https://adaptiva.com/products/onesite-patch We recently accessed the latest download…
SQL Server Analysis Services
Does SQL Server 2012 Standard Edition support Server Level Auditing
Does SQL Server 2012 Standard Edition support Server Level Auditing
SQL Server Analysis Services
Error 1067 when trying to run SQL server
When trying to run SQL server I get Error 1067: The process terminated unexpectedly. Event viewer is showing Event ID 9012 saying "There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on C:"…
SQL Server Analysis Services
SQL Server Analysis server services not starting
Consultants have deployed an SQL Server upgrade but they are pushing back on me because two services won't start (Error 5 - Access Denied). I am not experienced much in SQL and not at all in Analysis Services so I don't know what changes can…
SQL Server
SQL Server Analysis Services
Analysis Services Processing Task: Error A connection cannot be made
Hi, We are executing an SSIS package.. it fails with the below error Analysis Services Processing Task: Error A connection cannot be made. Ensure that the server is running. We have a separate SSAS instance on this server which is up and running.…
SQL Server Analysis Services
Problem upgrading encryption for multidimensional analysis services database in SQL 2022
I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…
SQL Server
SQL Server Analysis Services
use the SAS tokens to read files stored in a container?
Hi, I'm trying to figure out how to use the SAS tokens to read files stored in a container. Could someone guide me on the correct way to use these tokens?
SQL Server Analysis Services
how to change tabular mode to multidimensional model?
Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?
SQL Server Analysis Services
Azure SQL Database Data IO Usage frequently spiking to 100% and staying there unpredictably
Our database is having an issue with DTU percentage spiking to 100% during bursts of high traffic to our webapp. There is a stored procedure that runs on almost every page on our site that we are aware needs to be optimized, and we have taken some steps…
SQL Server Analysis Services
The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long.
My Wordpress website was down due to "Error establishing a database connection" I then went forward to "restart" my Azure Database for MySQL flexible server and this process has been going forever and I don't know what to do... this…
SQL Server Analysis Services
How to install an SQL server app
I just bought an HP computer with Windows 11. I am trying to install an SQL server app.Takes forever to "configure" the services. Could anyone help, please? Thank you
SQL Server Analysis Services
Unable to find MicrosoftML R package for ML Services on Sql Server 2022
Hello, I am trying to upgrade my database to Sql Server 2022 from Sql Server 2017. My database uses ML services, including both RevoScaleR and MicrosoftML R packages. I followed the installation steps for ML Services for Sql Server 2022 from here:…
SQL Server Analysis Services
unable see data in external created based on tab delimited file
I am able to query an external table made of tab delimited file via spark engine but unable to see any data when queried from SSMS Error faced in sql: Started executing query at Line 1 Warning: No datasets were found that match the expression…