Follow the procedure below to back up your SQL Azure hosted database to a SQL Server 2008 R2 database. Keep…
Tag Archives: SQL
How to: Copy/Move a Sitefinity 5.2 project from one server to another (Access DB / SQL Server DB)
Sitefinity 5.2 allows you to quite easily move projects from server to server. 1. If you’re using an Access database,…
How to: Update XSD queries
Working with an .XSD (XML schema file) in Visual Studio may be easy at first but, it might give you…
Quick tip: Get a list of all accessible SQL Servers
Open up the terminal and type either of the following two commands: 1. osql –L or 2. sqlcmd –L…
How to: Troubleshoot error message “This control does not allow connection strings with the following keywords: ‘Integrated Security’, ‘Trusted_Connection’.”
One of the things that you will be tempted to attempt quite early in your SharePoint 2010 journey, is to…
How to: Install and use Reporting Services with SharePoint 2007
Here is an impeccable guide on how to work with Reporting Services in SharePoint 2007. The following are the steps…
How to: Backup and restore a SQL Server 2008 database through the SQL Management Studio
SQL Management Studio offers an easy and straightforward way to back-up databases and restore them to another server. Just follow…
How to: Sort and Reverse a DataTable
In order to sort/order the rows of a DataTable, we need to pass them through to an array of DataRow…
How to: Troubleshoot “Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.”
Working with DataSets, you might face this error message that will keep you from using code that you knew was…