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 is not accessible by the report server. Let us see the SQL Server report server configurationContinue reading “The report server cannot open a connection to the report server database”
Monthly Archives: May 2016
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 copy of the rows from its associated table, sorted differently by the index’s keys toContinue reading “Backup and Restore Database without non clustered indexes”
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” Now create a visual studio SSIS integration sample package. For the purpose ofContinue reading “How to deploy SSIS package to SQL Server 2012 SSISDB Catalog”
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 linked servers and email the report to DBA group. Here is the script i haveContinue reading “Database size report for multiple database on multiple servers”
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
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 zeros. File initialization causes these operations to take longer. However, when data is written toContinue reading “Enable Instant File Initialization is easy in SQL Server 2016”
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 2008, you would need to perform this task by writing separate T-SQL logic for insert, deleteContinue reading “Merge Statement to perform insert , update and delete in one statement”
Tempdb Enhancements in SQL Server 2016
Tempdb Trace Flags 1117 and 1118 are no longer needed in SQL Server 2016. 1117 flag is controlled by the AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES option of ALTER DATABASE and 1118 flag is controlled by the SET MIXED_PAGE_ALLOCATION option of ALTER DATABASE. What are these Trace Flags TRACE FLAG 1117 – GROW ALL FILES IN A FILE GROUPContinue reading “Tempdb Enhancements in SQL Server 2016”
Powershell Script to Backup the file system folders/files to Azure blob storage
One of the requirement from the customer was backup the important application files to azure blob storage and delete the backups older than 7 days. I have written a below script to automate the task. Hope you enjoyed the post! Cheers Ramasankar Molleti LinkedIn: LinkedIn Profile Twitter: Twitter
Fix – Availability Group Listener Failed with the message WSFC could not bring the network name resource
One of the common issue I and my team have encountered several times when we setup availability group listener in SQL Server as below Msg 19471, Level 16, State 0, Line 2 The WSFC cluster could not bring the Network Name resource with DNS name ‘<DNS name>’ online. The DNS name may have been takenContinue reading “Fix – Availability Group Listener Failed with the message WSFC could not bring the network name resource”
Ramasankar Molleti Blog 