Welcome in Dinesh Patel Blog

MOLAP - The partition storage mode is standard MOLAP. Proactive caching is disabled. You need to process the partition to refresh data. Scheduled MOLAP - Same as MOLAP except that the server will process the partition on a daily schedule. Automatic MOLAP - The default silence interval is set to 10 seconds. As a result, the server will not react if the data change batches are fewer than 10 seconds apart. If there is not a period of silence, the server will start processing the cache in 10 minutes. Medium-latency MOLAP - Similar to Automatic MOLAP except that the MOLAP cache expires in 4 hours. Low-latency MOLAP - The MOLAP cache expires in 30 minutes.   Real-time HOLAP - As with standard HOLAP, partition data is stored in the relational database, and aggregations are stored in the cube. Aggregations are rebuilt as soon as a data change notification is received. Real-time ROLAP - As with standard ROLAP, partition data and aggressions are stored in the ...

Mobile BI http://www.mobiweave.com/#/bi

Master Data Services in SQL Server 2012 Use the following resources to help understand, install, configure, manage, and troubleshoot Master Data Services (MDS) in SQL 2012. What is MDS? How do I use MDS? Resources for an MDS Deployment Frequently Asked Questions Additional Resources What is MDS? Master Data Services Overview What's New for Master Data Services 2012 How Do I Use MDS? MDS One-Day Course Topic  Material Duration Master Data Services Overview Video  |  Slides 45 min Managing Data Warehousing Dimensions with MDS, Part 1 Video  |  Slides 15 min Managing Data Warehousing Dimensions with MDS, Part 2 Video 15 min Data Loading via Entity Based Staging (EBS) Video  |  Slides 30 min MDS Hierarchies and Collections Video  |  Slides 30 min Business Rules and Workflow in MDS Video  |  Slides 30 min MDS Model Migration and Upgrade Video  |  Slides 30 min Security Features a...

Who Should Read This Guide This guide is intended for software architects and developers who are developing Business Intelligence applications on the Microsoft .NET Framework using SQL Server 2005 - Integration Services, Analysis Services, Reporting Services and Microsoft Office . What You Must Know To most effectively use this guidance, you should already have experience using SQL Server 2005, .NET development techniques and technologies. You should be familiar with general distributed application architecture challenges, and, if you have already implemented business intelligence solutions, you should know your own application architecture and deployment pattern. Where we are               We are in the early stage of Business intelligence architecture guide. This guide address architectural and design aspects of Business intelligence. We anticipate gaps in this guide as we are doing release at the very early stage....

MSDN Virtual Labs for Developers: SQL Server 2005 Virtual Labs: http://msdn.microsoft.com/en-us/aa740409.aspx MSDN Virtual Lab Express: What's new in SQL Server 2005   MSDN Virtual Lab: Mapping Your Objects to Database Tables with LINQ to SQL MSDN Virtual Lab: Using the Microsoft SQL Server 2005 Data Mining Add-Ins for the 2007 Microsoft Office System MSDN Virtual Lab: Getting Started with Microsoft Visual Studio Team Edition for Database Professionals MSDN Virtual Lab: SQL Server 2005 Hosted Trial MSDN Virtual Lab: SQL Server 2005 Integration Services MSDN Virtual Lab: SQL Server 2005- Introduction to SQL Server Management Studio MSDN Virtual Lab: Analysis Services in SQL Server 2005 MSDN Virtual Lab: SQL Server 2005 Reporting Services MSDN Virtual Lab: SQL Server 2005 Report Builder MSDN Virtual Lab: SQL Server 2005 Report Viewer Controls MSDN Virtual Lab: SQL Server 2005 Service Broker MSDN Virtual Lab: SQL Server 2005 and ADO.NET (Lab A) MSDN Virtual ...