SQL Server

SSAS

SQL Server Analysis Services References

Detailed Descriptions of each of the built in Data Mining Algorithmshttps://docs.microsoft.com/en-us/analysis-services/data-mining/data-mining-algorithms-analysis-services-data-mining Creating and Managing SubCubesSubCubes only exist for the duration of a session/connection so use for context not securityhttps://docs.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/building-subcubes-in-mdx-mdx Cube Securityhttps://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services/Measure and Dimension Security (14:30) https://www.youtube.com/watch?v=NlNw3wYbh8E

Transact-SQL

SQL Formatting Trick

I learned a very useful T-SQL script formatting trick today. I often talk about formatting and commenting for the “person from mars” which is usually “you” coming back to look at your code 3 years from now having forgotten everything you ever knew about this project and learned better ways to do everything that was …

SQL Formatting Trick Read More »

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

This is an error that you get when you try to view the built-in reports in SQL Server 2008 when the database compatibility is set to anything less than 2005(90). To fix this and make the built-in reports work: Right click on the database Select properties On the options tab change the compatibility level to …

Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Read More »

Shopping Cart