MDX Implementing Logical AND On Members of the Same Hierarchy
Tuesday, December 24, 2013
by jsalvo
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
MDX Implementing Logical OR On Members of Different Hierarchies
Saturday, December 14, 2013
by jsalvo
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
MDX Order by Multiple Criteria
Saturday, December 7, 2013
by jsalvo
The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on a numeric (or string) expression. The syntax of the Order function is displayed below:
SQL Server Data Mining: Time Series Algorithm Tips
Tuesday, December 3, 2013
by jsalvo
The sqlserverdatamining site has a wealth of information related to many of the SQL Server data mining algorithms. The ‘Tips and Tricks’ section of the site is especially useful. An online forecasting tutorial covering the Time Series algorithm is also available at http://technet.microsoft.com/en-us/library/ms169846.aspx.
DSC Windows Feature Web-Ftp-Service
Tuesday, December 3, 2013
by asalvo
This week I've started learning/using Desired State Configuration. I'm sure I will be blogging about it more in the coming weeks, but for now here is a quick overview of installing the FTP Role Feature. One of the built in resources for DSC is WindowsFeature which allows you to enable different features and roles on Windows. A DSC configuration file might look something like this: