Mar 28 2009

Compression and performance tricks for SQL Server 2008

Published by gojko under news

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 »

No responses yet

Nov 13 2008

SqlServer Central article on DbFit

Published by gojko under news

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.

No responses yet

Jan 07 2008

Initial support for SqlServer 2000 in DbFit

Published by gojko under dbfit

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

2 responses so far