Category Archives: SQL Server

Microsoft introduced some major changes in SQL Server Integration Services with SQL Server 2012. Brand new “SSISDB” database launched as SSIS catalog “A New repository database of Integration Services”. This new repository database brings a lot of abilities for developers, testers and administrators. Prior to SQL 2012 all SSIS packages are stored either in MSDB … Continue reading →

Issue : One email report is working fine from long time but suddenly it failed today with below error. Error : Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes. Solution : Email report is failing at send mail because file attachment size is … Continue reading →

Issue: SQL Server Integration Service (SSIS) 2016 unable to connect from SQL Server Management Studio (SSMS) 17.0. Error: Connecting to the Integration Services service on the computer "<Server Name>" failed with the following error: "The specified service does not exist as an installed service.” This error can occur when you try to connect to a … Continue reading →

Steps to configure schedule SSAS Cube \ OLAP database backups :- 1. For each SQL Server Analysis Services Environment. In order to create recovery strategy, we need to have backups of the metadata that describes the databases. SQL Agent jobs must be created to run backups remotely. Typically, one of the SQL Server Engine that … Continue reading →

DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used to create read only copy of an existing database. Cloned database includes the schema and statistics of the source database but no data. · Source database should be online & readable while creating clone database. … Continue reading →