SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost
I was asked to be interviewed for an article on Microsoft SQL Server by OdenJobs.com. They have just posted the interview of myself and Christian Lefter, Andew Fyer, Namwar Rizvi, Brent Ozar, Brian Kelly, Chris Shaw, and Pinal Dave. Part 1: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost […]
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 […]