You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server
SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren’t compatible. You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won’t be able to be deployed to the SQL 2005 report server. With enough major editing of the SQL 2008 report you can convert it […]
How to setup SQL 2008 BIDS to use VB.NET as the default scripting language
If you are like me and don’t know anything about C#, and you don’t want to have to change the script language every time to create a .NET script from C#.NET to VB.NET you can change the default. Open BIDS, and select Tools > Options. On the menu on the left select “Business Intelligence Designers” then “Integration […]
Back to Basics: The BACKUP DATABASE command
Now that you have objects created within your database, and data within the tables you need to secure your database in case of a server failure or accidental data deletion. This would be done by taking backups of the database. Backups are taken by using the BACKUP DATABASE command. The frequency that full backups are […]
A better way to index text data
Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for. However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server. This post shows a couple of techniques which can be used to increase index performance which decreasing the storage requirement.