Gojko Adzic

At the SQLBits Goes Forth conference in Manchester today, Ramesh Meyyappan demonstrated impacts of some new SQL Server 2008 features on query performance. One topic he tackled in particular is compression, offering advice when to apply it and when not to apply it. Continue Reading »

Solomon Rutzky wrote a nice article on DbFit for SQLServer Central. The article focuses on the use of DbFit for database unit testing for SQL Server.

Read the full article SQLServer Central.

Great news – SQLServer 2000 is now supported in DbFit. The only limitation, compared to Sql Server 2005, is that tables and procedures must be fully qualified (defined as schema.name), if there is an object of the same name in the current user’s schema and in dbo. The next official release will include sql server support — until then, you can download the binaries from Sourceforge: dbfit-dotnet-20080107.zip

the complete package, with acceptance tests, can also be downloaded from here: dbfit-complete-20080107.zip

For sqlserver 2000, use dbfit.SqlServer2000Test instead of dbfit.SqlServerTest.

Many thanks to Oscar Centeno for his help on implementing and testing support for Sql Server