Monthly Archives: July 2013

Deploying SSIS package using Deployment Manifest with screenshots

Creating SSIS Deployment Manifest Deploying SSIS package using Deployment Manifest with screenshots To demonstrate SSIS package deployment manifest with screenshots I have created a test package on dummy source and destination databases. The package ETL data between source and destination … Continue reading

Posted in MSBI, SQL Server DBA, SSIS | Tagged , , , , , , , , , | 9 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