Category Archives: Database

Anything regarding database from SQL, Oracle to mySQL

Cannot load script for execution after migrating your SSIS Package to a new SQL Server version

You are migrating your SSIS Packages from an old version SQL Server to a new SQL Server version, it worked perfectly fine before but once it was deployed on the new environment you get an error similar to this one. Message Executed as user: YourDomainYourUser. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for… Read More »

Workaround for Adding Encrypted Databases by a Database Master Key on High Availability Groups without a password

Have you ever encountered this error when you are trying to add a database on your Always On Availability Groups? “This database is encrypted by database master key, you need to provide valid password when adding it to the availability group.” You get this on the Wizard after warning you that a Password is required… Read More »

Make SharePoint 2010/2013 Mirroring Aware

To make your Sharepoint database reliable you need to mirror it, meaning what ever happens on SQL Server A will be mirrored or replicated on SQL Server B and it’s quite easy to achieve you just need two steps to do it. First is to mirror your SQL Server databases, you can achieve that all… Read More »

TAB Delimited Export in SSRS

Ever wondered how do you export TAB delimited reports in SSRS? It’s quite easy as you can configure SSRS to export it using the CSV render inside the ReportingServices rendering engine of SQL server.  You can do that by updating the rsreportserver.config file which can be found in the following path C:\Program Files\Microsoft SQL Server\MSRS{YourSQLServerVersion}.MSSQLSERVER\Reporting… Read More »