ranimsbi.blogspot.com
MS BI TOOLS: February 2011
http://ranimsbi.blogspot.com/2011_02_01_archive.html
8220;I am a slow walker, but I never walk backwards- Abraham Lincoln”. Saturday, February 26, 2011. Pivots with Dynamic Columns in SQL Server 2005. PIVOT allows you to turn data rows into columns. For example, if you have a table like this (I use only three months here for simplicity):. Month SaleAmount - - - - - - - - - - - - - - January 100 February 200 March 300. Suppose we wanted to convert the above into this:. We can do this using the PIVOT operator, as follows:. However I need to construct this qu...
ranimsbi.blogspot.com
MS BI TOOLS: Common SQL Server Reporting Services Challenges
http://ranimsbi.blogspot.com/2011/02/common-sql-server-reporting-services.html
8220;I am a slow walker, but I never walk backwards- Abraham Lincoln”. Friday, February 25, 2011. Common SQL Server Reporting Services Challenges. In every business there are several different groups of report users, from chief executives, to business analysts, to operational staff, who all need access to reliable and current data in order to track overall business performance, investigate the effectiveness of individual business functions, or simply for ad-hoc day-to-day reporting. Following is the list...
ranimsbi.blogspot.com
MS BI TOOLS: Adding columns to SSRS 2005 report Dynamically
http://ranimsbi.blogspot.com/2011/02/adding-columns-to-ssrs-2005-report.html
8220;I am a slow walker, but I never walk backwards- Abraham Lincoln”. Saturday, February 26, 2011. Adding columns to SSRS 2005 report Dynamically. I have a stored procedure that generates a list of columns and the associated data. The number of columns (and their names) may change from time to time. Because remote machine is in accessible. so Currently there are over 500 columns in the dataset. I cannot drag/drop 500 plus field onto the report and do an. Value), "Show Min and Max Values", " ). Subscribe...
ranimsbi.blogspot.com
MS BI TOOLS: SSAS::::MDX Optimization Techniques: Segregating DISTINCT COUNT
http://ranimsbi.blogspot.com/2011/02/ssasmdx-optimization-techniques.html
8220;I am a slow walker, but I never walk backwards- Abraham Lincoln”. Thursday, February 24, 2011. SSAS: : MDX Optimization Techniques: Segregating DISTINCT COUNT. Initial Approach via MDX. Let’s initialize the MDX Sample Application, the platform from which we perform many practice exercises within the articles of our series. (We choose it because any organization that has installed MSAS has access to the Sample Application). We will create our initial query by taking the following steps:. We will begi...
jamesserra.com
SQL Server 2012: Blog Posts | James Serra's Blog
http://www.jamesserra.com/denali
James Serra's Blog. Big Data and Data Warehousing. A list of all the links of my blog posts about SQL Server 2012 (codenamed “Denali”):. Jumping from SSIS 2008 to SSIS 2012. SQL Server 2012: New Business Intelligence features. SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine. Microsoft Data Quality Services in SQL Server 2012. Microsoft Master Data Services in SQL Server 2012. SQL Server 2012: Certification Upgrade Info. SQL Server 2012: Installing on a Virtual Machine. SQL Server 201...
jamesserra.com
How an MPP appliance solution can improve your future | James Serra's Blog
http://www.jamesserra.com/archive/2015/05/how-an-mpp-appliance-solution-can-improve-your-future
James Serra's Blog. Big Data and Data Warehousing. SQL Server 2016 public preview arriving this summer. What is Microsoft Azure Stream Analytics? How an MPP appliance solution can improve your future. May 27, 2015. Massive parallel processing ( MPP. Is the future for data warehousing. So what is MPP? Microsoft has an MPP appliance called the Analytics Platform System. Looking at the value over time for a MPP appliance vs a SMP solution:. Cumulative 3-year Cash Flow – $152M,. The bottom line is that for b...
jamesserra.com
Big Data | James Serra's Blog
http://www.jamesserra.com/archive/category/big-data
James Serra's Blog. Big Data and Data Warehousing. Category Archives: Big Data. PASS Summit Announcements: Microsoft Professional Program for Big Data. November 15, 2016. Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set of blogs covering the major announcements. Next up is the Microsoft Professional Program for Big Data. A few months back, … Continue reading →. April 29, 2016. What is Polyglot Persistence? July 1, 2015. May 27, 2015.
jamesserra.com
What is Polyglot Persistence? | James Serra's Blog
http://www.jamesserra.com/archive/2015/07/what-is-polyglot-persistence
James Serra's Blog. Big Data and Data Warehousing. What is Microsoft Azure Stream Analytics? Microsoft Azure Data Catalog →. What is Polyglot Persistence? July 1, 2015. Which is the idea that applications should be written in a mix of languages to take advantage of the fact that different languages are suitable for tackling different problems. A guideline on the database type to use based on the functionality of the data:. Rapid Access for reads and writes. No need to be durable. RDBMS (if modest),.
jamesserra.com
SSAS error when processing the cube | James Serra's Blog
http://www.jamesserra.com/archive/2011/05/ssas-error-when-processing-the-cube
James Serra's Blog. Big Data and Data Warehousing. Dirty looking SQL, MDX, or DAX? DBA’s, want to earn the big bucks? Learn BI →. SSAS error when processing the cube. May 13, 2011. Every couple of weeks I see this SSAS error when processing one of my cubes:. Internal error: Invalid enumeration value. Please call customer support! Is not a valid value for this element. Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, ‘? SSAS File System Error. James is ...
businessintelligence-solutions.com
Extreme performance with xVelocity: is VertiPaq faster than ColumnStore Index or just different?
http://www.businessintelligence-solutions.com/extreme-performance-xvelocity-vertipaq-faster-columnstore-index-different
Extreme performance with xVelocity: is VertiPaq faster than ColumnStore Index or just different? Extreme performance with xVelocity: is VertiPaq faster than ColumnStore Index or just different? Posted in Business Intelligence Blog. I was preparing a nice post about how the new technologies of SQL Server 2012 could make a huge improvement on your DB queries and performance, more specifically about the well known “ColumnStore Index” ( xVelocity memory optimized ColumnStore index). Has shown 100X improvement.
SOCIAL ENGAGEMENT