Hi Jason,
Thank you for sharing the links! Some of them I found very interesting. Like that one about SQL backup compression. What do you think about this? Worth having it? My tests showed it's reasonable to have compression applied during backup. But I'm pretty new to SQL Server 2008 and SQL as such. I've tested what I think is the latest publicly available build of SQL Server 2008. It works great and compression is good. However it's kind irritating that I didn't find a reliable management system there. So I struggled with sqlcmd and scripts for about a week or so and finally found it really boring and not cost effective to experiment any further. I believe it will make sense experimenting with it again when it is released. But for now it's of no practical use for me. That experience led me to find another way to manage SQL. I came across Litespeed from Scriptlogic and it has great compression. You know I haven't found how I can manipulate compression parameters in SQL server. Maybe it's just the version that I used, maybe it will be available only from within the SQL Management Studio. I don' t know. But I like the reach in Litespeed's configuration settings. I can choose from a dozen of compression settings. I currently have a medium performance server here so it was really helpful to have that flexible configuration. I've been able to compress large and middle databases with a compression ratio of mid-size DB being higher than that I've got from implementing compression in SQL Server. And I also achieved a ratio about the same percentage that I've got with SQL Server 2008 but in much less time when I compressed my large DB with Litespeed. How do you like new SQL server? I believe it' s great but I really would love to have management facilities that useful and easy to use like I've found in Litespeed. I love when I don't need to crawl all day long though the options to configure something. In LightSpeed you don't have to browse through tabs to do everything because you can follow wizards.
Thanks for your work. Please keep the list updated!
David
mailto:david.kjelsson@live.com