SQL Server 2008 | Big Data, Data Analytics and Data Science

SELECT * Vs SELECT Column Name in SQL Server Query

September 2, 2012 Sandip Shinde 4 comments

People always keep saying do not use SELECT * exercise SELECT <column names> instead. But no one put more light on this and this becoming myth in SQL Server and other database management systems. Here are couple of reasons why should we avoid SELECT * and go with SELECT <column names>

Connect Analysis Services 2008/2005 from Different Domain Use

January 15, 2011 Sandip Shinde Leave a comment

In one of my project I was working with Remote client. Basically, SQL Server 2008 Analysis Services Objects were available at Remote server. Me & my team were developing Reports on that SSAS with SQL Server 2008 Reporting Services. Read more…