Monthly Archives: May 2016

The report server cannot open a connection to the report server database

One of the student asked me while connecting to report server url, he was prompted the error as “The report server cannot open a connection to the report server database” Looking at the error, it states that the report server database … Continue reading

Posted in SSRS | Leave a comment

Backup and Restore Database without non clustered indexes

In this post, I’m going to demonstrate how to take backup of database without considering non clustered indexes. Before describing how to eliminate index data from backups, it’s first important to point out that a non clustered index contains simply a … Continue reading

Posted in Backup & Recovery, Database Administration | Leave a comment

How to deploy SSIS package to SQL Server 2012 SSISDB Catalog

In this post, I’m going to present how to deploy SSIS package to SQL Server 2012 integration services catalog. Create SSIS catalog After step 1 you can see SSIS catalog name called “SSISDB”  created. Right click and create a folder “TestSSISPackages” … Continue reading

Posted in SSIS | Leave a comment

Database size report for multiple database on multiple servers

As a DBA, you are responsible for monitoring the growth of the databases on multiple servers in different environments. There are many ways we can achieve this, my requirement was to use linked servers to get the databases size of all the … Continue reading

Posted in T-SQL | Leave a comment

T-SQL Script to find Free space By Database

This is one of the handy script to find the free space by each database. This is useful when you troubleshoot the database space issues. Hope you enjoyed the post! Cheers Ramasankar Molleti LinkedIn: LinkedIn Profile Twitter: Twitter      

Posted in T-SQL | Leave a comment

Enable Instant File Initialization is easy in SQL Server 2016

Starting from SQL Server 2005, Microsoft introduced a feature called Instant File Initialization. By default, when you create a database, add a new data file, increase the size of an existing file,  in SQL Server first initialized by filling the files with … Continue reading

Posted in Database Administration | Leave a comment

Merge Statement to perform insert , update and delete in one statement

This example, demonstrate how to perform insert, update and delete on single statement using MERGE. If you are a Database Developer/BI expert, you would need to refresh the target table to match the source tables periodically. Prior to SQL Server … Continue reading

Posted in T-SQL | Leave a comment