An Easy Way for SSAS Batch Processing
Batch processing is available in Analysis Services. Which means we can send multiple processing commands to the server in just a…
Archive
Category: Administartion
How to manage the user access rights to see database views but not source tables using T-SQL
Problem: There is a group of users that are not intended to have direct read access to the database tables.…
How to query extended properties
If you are working in a company that your managers are getting database documentation seriously, thumbs up! One of the…
How to store a SQL Server database diagram into a file and share it with others?
Sometimes you might feel you need to store the database diagrams in a file basis. I’ve faced to this feeling…