Monthly Archives: July 2013

Deploying SSIS package using Deployment Manifest with screenshots

The post Deploying SSIS package using Deployment Manifest with screenshots can help you to deploy SSIS package using deployment manifest. To demonstrate this I have created a simple ETL package to load data from a Flat file to SQL Server … Continue reading

Posted in MSBI, SQL Server DBA, SSIS | Tagged , , , , , , , , , | 11 Comments

Download SQL Server 2014 – New features added in SQL Server 2014

Download SQL Server 2014 – New features added in SQL Server 2014 Microsoft Announced SQL Server 2014. I just came across through the below links. Download SQL Server 2014 CTP1 What’s New in SQL Server 2014 – MSDN   New … Continue reading

Posted in Miscellaneous, SQL Development, SQL Server DBA | Tagged , , , , , | 3 Comments

SP_SPACEUSED is giving wrong counts

SP_SPACEUSED is giving wrong counts !!! SP_SPACEUSED: is a system stored procedure and used to capture number of rows, total size, data and index size information. Sometimes SP_SPACEUSED may give incorrect information or SP_SPACEUSED  give wrong counts. Below are some … Continue reading

Posted in SQL Development | Tagged , , , , , , , , | 1 Comment