Thursday, May 2, 2019

No bootable medium found!” error in Virtual Box

I was using Ubuntu on Virtual Box, I was constantly getting errors
"Fatal: No bootable medium found! System halted."

I used VM to install and test new software programs before I put those in my daily work horse. Long story short.

Change the Setting to below it should work


Wednesday, May 1, 2019

User ‘public’ does not have permission to run DBCC showfilestats for database ‘ testing’


User ‘public’ does not have permission to run DBCC showfilestats for database ‘ testing’
This error message is raised when your user account does not have the db_owner role of a database meaning you are not the owner of the database; and you try to open the properties dialog box of a database in SSMS 2008.

User ‘<User>’ does not have permission to run DBCC showfilestats for database ‘<Database Name> ‘.
Cause:
This happens when you right click on a database in SSMS and click properties of the database; In response SQL Server 2008 runs the DBCC SHOWFILESTATS command to fetch the UsedSpace property and the AvailableSpace property. Because the user is not the db_owner, the user does not have permission to run the DBCC SHOWFILESTATS command. Therefore, the user cannot open the Properties dialog box in SSMS 2008.

Resolution:

Processing Cube Dimension Incrementally

I didn't find much about how to process dimensions incrementally in a cube. To be clear, I am focusing on processing cube dimensions not dimension table. I have seen and work with different setting of the cube and work with "Process Update".

This process the data incrementally in the Cube dimensions.



If you using SSIS drag and drop analysis service item and set the setting as "Process Update".


Popular Posts