SqlNews

Its been almost a month since the Storage Engine Blog was started and as Kimberley Tripp has mentioned its a must read. I am still waiting for a post that I haven't found interesting.

The posts continue on how to manage your database, repairing, recovery etc. Whats great about the posts so far is that they address those situations that we rarely find ourselves in. With the better hardware we have nowadays some people will not have a corruption in years. However when one occurs it generally requires action quickly. However chosing the right course of action is a tricky one, repair, recovery and the different options for each of those. There is often quite a bit of pressure at this time and so newsgroups and the internet are often our friend. The Storage Engine posts are clearing up many bad statements made on newsgroups.

Operations

• Don't dettach a corrupt database if you want to keep your job
• To DBCC or not DBCC 

Programming

• Impersonation in SQL CLR - This is a real gotcha and is a must read for anyone intending on using SQL CLR and need the ins and outs of security
• Similiar to a previous post about versioning in SQL CLR. As one would expect SQL doesn't use .Net assemblies like every other .Net App, its much more stringent - Assembly Redirection in SQL CLR
• Entity framework in ADO.Net If you're into ORM then this is a must, along with DBA's that want to resolve the performance issues :)

If you're wondering what the title is all about its a bit of scottish from Paul Randalls post on the new emergency mode. English dialects are great Bill Brysons book The Mother Tongue is great on this.