SQL Server


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


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 »

What is SQL Server

If you are reading this post you have of course heard the term DataBase‚Ķ Depending who you are and what you do for a living that term may or may not mean anything to you. If you are a DBA (DataBase Administrator) look away! This post is not for you. lol This post is intended …

What is SQL Server 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