Siddharth Mehta posted an article on Siddharth Mehta's Blog - Dec 1, 2009, 5:41 pm
Comparative study is one of the best ways to benchmark, compare and conclude right option for the right job. I came across an interesting comparative study of size of data that gets created by results...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 23, 2009, 5:09 pm
Today on 24-Nov0-2009, my first article has been published on SQLServerCentral.com. And I feel extremely happy and excited about this. Many a times I get confronted by an expectation that I need to pu...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 19, 2009, 9:15 am
Powerpivot resources are now out and available for public download. The long awaited learning material on Powerpivot is now available online on BOL, and can be accessed from here. Download instructio...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 18, 2009, 6:25 pm
Today all the 2010 version of products got released, and made available for public download. If you carefully study the preliminary requirements of the new line of products, most of them are shifting ...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 13, 2009, 8:41 am
Data Analysis Expressions ( DAX ) is the new query language or expression language of Powerpivot. It also has a rich set of functions which are almost similar to Excel functions. A dictionary of all t...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 12, 2009, 5:17 pm
... Folks can be proud now as they have reserved a seat on this space.All the components of the Powerpiovt architecture i.e. Excel, Powerpivot, AMO and ADOMD.Net are implemented and works in-process...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 11, 2009, 5:29 pm
A new SSIS Task is available on codeplex, named SSIS ReportGenerator Task. As described on it's homepage, the description about this task is : "SSIS Task for SQL Server 2008 to create Reports from...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 11, 2009, 6:44 am
SyncToy 2.1 is a free application that synchronizes files and folders between locations. Typical uses include sharing files, with other computers and creating backup copies of files and folders. In pr...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 9, 2009, 11:28 am
I worked on a Performancepoint last year for one of the end-to-end cycle of BI Implementation using the Monitoring and Analytics Module. There were quite a lot of shortcoming and it seemed very appare...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 8, 2009, 11:03 am
For those who are new to Performance Management, there is a FREE and useful course for Dashboard basics. This course would also give insight on how a Performancepoint Dashboard can help business. Chec...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 5, 2009, 4:01 pm
BIDS and SSMS are not always sufficient for any MS BI Project. Right from the documentation that might be required just for compliance to tools that are able to fill up the gaps that SSMS or BIDS leav...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 5, 2009, 3:54 pm
Below is the excerpt from the Microsoft Technet site, where I found the below information regarding the free download of this e-book: This book is a guide for database administrators who implement or ...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Nov 1, 2009, 5:50 pm
I started working on a task to create a report that can be used in SSMS to keep track of SSIS packages and profile them. Jamie Thomson has written a code snippet that I would be using as a starting po...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 29, 2009, 6:11 pm
Today on 29th Oct 2009, I had a chance to present the use of a tool called RSScripter for deployment of SSRS Reports at London SQL Server Users Group. SQL Server MVP Jamie Thomson presented a nice ses...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 22, 2009, 5:24 pm
Most of those who know what is a Dashboard and/or a Key Performance Indicator (KPI), must have read some bookish examples where the book explains that it's similar to the Dashboard available in yo...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 20, 2009, 5:52 am
I posted yesterday regarding the entry of a new tool called powerpivot, but I didn't realize that its Gemini. After a post from Chris Webb's blog, I read it from a post on Microsoft Sharepoint...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 19, 2009, 6:26 pm
... . BI Offerings from PowerPivot: Give users the best data analysis tool available: Build on the familiarity of Excel to ... BI applications in SharePoint, including automatic data refresh, data p...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 14, 2009, 9:10 am
Recently, I came across a very good article on SSRS Performance Analysis by Tom Mills using a tool called Fiddler. As the homepage of this tool states, "Fiddler is a Web Debugging Proxy which logs all...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 13, 2009, 6:38 pm
Less often I have seen Data source Views (DSV) getting used in an SSIS solution. The biggest trait of DSV is that, once its defined, it doesn't get refreshed by itself. In a way it is desireable, ...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 6, 2009, 2:10 pm
1) Many a times columns are compared with some value to determine a column value. But if the column contains NULL values, this component would break as it would not be able to make a comparison. So al...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Oct 4, 2009, 6:02 pm
I have worked on data migration projects where I have been a part of data cleansing activities using SSIS. One of the reader of my blog, requested me to post some tutorials on Data Cleansing. So based...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Sep 28, 2009, 10:35 am
There are many ways of importing data into SQL Server, depending upon the source from where data is to be imported. When working with legacy systems or non-relational systems like SAP, CRM application...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Sep 24, 2009, 4:48 pm
Import Export Wizard in SQL Server 2008 has nice improvements over what was available in SQL Server 2005, but still there's more that can and should be done to cater the requirements of the real w...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Sep 23, 2009, 6:21 am
Another Ebook bundle from Red-Gate.com containing some of the best technical material of SQL Server 2005 and SQL Server 2008 for free. It also includes one of the must have books for those preparing f...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Aug 28, 2009, 8:07 am
Today while browsing Internet to hunt food for my brain, I came across a very nice article by Jorg Klein on How to read a zip file in SSIS. Before reading the article, even I thought that the author m...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Aug 27, 2009, 8:25 am
Dimensional Modeling is one of the areas where many of the aspirants want to migrate. I know many SQL developers who wish to learn dimensional modeling, but are not able to find out a starting point. ...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Aug 25, 2009, 6:57 pm
Today, this is my first post on Microsoft's new flagship tool for the theme / concept called self-service analysis - project gemini. I have read a couple of articles from OLAP report and others. I...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Aug 18, 2009, 6:47 pm
I have been working since a few months on using SSIS with SAP. Generally while working with the functional consultants, it can be a very hard time getting the architecture in shape keeping in view the...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Aug 10, 2009, 10:25 am
While designing a package in BIDS, one of the issues faced is BIDS getting very slow. This can be experienced by symptoms like for example, while trying to place a control on the package, it takes a f...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Aug 7, 2009, 4:27 am
One of the things that I have learned and experienced in my career is, IT cannot work in isolation. One needs to be versatile to understand and learn technology, to grow big. It need not be a universa...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Aug 3, 2009, 4:45 am
I have always been a very big admirer of visuals that Proclarity Analytics provides. The different variety of graphs that it provides for analysis are amazing. Recently, I stumbled upon an add-in that...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Jul 31, 2009, 1:20 pm
Top Performance Counters for Analyzing SQL Server Performance Issues using Performance Monitor SQL Server 2008 Performance Management Data Warehouse Learn how to migrate your DTS packages to SSIS SQL...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Jul 27, 2009, 6:00 pm
Recently I stumbled upon some interesting SQL Server 2008 data warehousing screencast by Eric Hanson. Eric Hanson is the principal program manager for SQL Server data warehousing. Below mentioned are ...
Comment - Like

Siddharth Mehta posted an article on Siddharth Mehta's Blog - Jul 20, 2009, 9:57 am
BIDS Helper is such a great tool that needs no introduction for MS BI Professionals , or rather I would like to used the word "Product" for it to honour its value. I feel that sooner or later, Microso...
Comment - Like