June 2006 - Posts

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

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.

 

Posted 18 June 2006 21:42 by simonsabin | with no comments
Filed under:

TechEd is almost over and there hase been some great content for all aspects of development. Those of you that didn't get approval from your boss if you really are interested in the content and weren'tjust after a holiday ;) you can watch most (if not all the sessions) via on demand webcasts. The list is here

Blogs

I mentioned previously The Storage Engine Team's blog. The content is great, much of it is in BOL or common sense but even so many people don't know it. The lastest few posts ("Why are you backing up your database","When should you rebuild the transaction log" and "Which part of 'REPAIR_ALLOW_DATA_LOSS' isn't clear") all concentrate on looking after your data and making sure you have a copy safe, don't loose it and don't corrupt it. Your data is the most precious thing for your business. I remember an paper on 9/11 that said 80% of business in the two towers collapsed as a result because they could not recover their data. Everything except your data can be replaced.

Some interesting posts explaining how SQL Server Setup works in terms of add/remove programs and best practices for setting up domain groups on you SQL 2005 Cluster

Linq, DLINQ and entities

You must have noticed all the stuff coming out of TechEd about LINQ, DLINQ and something new Entities. Whilst I think these are great for ensuring their will be plenty of SQL performance tuning work in the future, the benefits from a rapid development are huge. Alex Barn has provided a few links including one to a Channel9 video

CTP feast.

Data Dude CTP is now available here

SQL Everywhere CTP.

Everything Else

If you hadn't heard Bill Gates is stepping down as Chief Software Architect to concentrate on his foundation.

Posted 16 June 2006 08:35 by simonsabin | with no comments
Filed under:

TechEd is bringing some great things out of the Microsoft closet, Data Dude and Sql Everywhere being 2 see below for downloads.

Thanks to Itzik for pointing out the undocumented DBCC command FLUSHPROCINDB, which frees compiled plans for a specific database

Bugs and Suggestions

The Product Feedback Centre is no more. If you wish to post bugs/suggestions against a Microsoft product then you need to go to http://Connect.microsoft.com

Blogs

The Storage Engine Team (aka Paul Randal) has started the series on DBCC. First up is CHECKDB and consistency. Fantastic post interesting to see that something new in 2000 was re-written for 2005. Second is PAGE, yep this is a Microsoft person blogging about an undocumented (but heavily used as Paul explains) command. This blog is essential reading for anyone wanting to now the ins and outs of SQL Server.

CTP feast.

Data Dude CTP is supposed to be available today, I was hoping to provide a public link but unfortunately it isn't available and only available to MSDN scubscribers (according to ScottGu)

SQL Everywhere is also available as a CTP. It is the new mobile edition of SQL Server that is loaded in memory, so think of it like dbf files or other non-service based databases. (Thanks to Dan for pointing this out) Also check out Steve Lasker's post on SQL Everywhere

This is the first of hopefully a series of summaries of whats happening in the SQL world.

I've can't start this without mentioning Data Dude. The new SKU of VS for Database Developers. The CTP has been signed off and will be available at Tech Ed. It should be available for download on 11th June.

I downloaded and listenened to the .Net rocks show with  Kimberley Tripp its very funny. She aludes to many of the recent announcements like Data Dude, Performance Server also mentioned is testing so lets see whats coming out for that.

Any of you still using SQL Server 6.0 well Kimberley wants to know when you're going to SQL 2005

Another great post from the craig on how a query really works (Building blocks of Query Execution), if you classify your self as a SQL geek this is a must read post.

New forum for those of you, and lets hope thats everyone, who is interest in disaster recovery.

If you haven't heard support for SQL 2000 is ending as of June 2006, or not if you've already read the other posts.

Events

I will be joining Chris Webb for the first of the UK BI Usergroup meetings on the 22 June. Please feel free to come along its completely free.

New Blogs

Bill Lin - Microsoft ADO.Net team

Tony Rogerson - SQL Server MVP, UK SQL Server Usergroup founder

Craig Freedman - Microsoft SQL Team

SQL Server Storage Team

Thats all for now.