Ok, I took a bit of liberty with the title...... I found this blog entry today as I was doing a bit of research on denormalization techniques for an article I'm writing. I found this to be humourous!

 

 

 

I've been spending some time lately (in between traveling and playing architect dude for our AD module) researching issues around scaling database systems. I've come across a couple of really impressive articles from the SQL team on MSDN on this subject. It's nice to see some of the quality coming out of the SQL team lately, good job guys!

 

Here is an article on scalability with SQL 2005: http://msdn.microsoft.com/architecture/learnmore/default.aspx?pull=/library/en-us/dnbda/html/ScalOutSQL.asp

 

And here is an article that gets to the heart of the matter: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/dataoutsideinside.asp

 

 

There is a new "edition" of SQL Server that is nearing the release stage, which just might be the missing link in the whole SQL Server story. SQL Server Everywhere is essentially a port of the embedded SQLCE but setup as a desktop/mobile platform.

 

The team has just started a new blog, located here: http://blogs.msdn.com/sqlservereverywhere/default.aspx

 

 

I came across this article today in some stuff I was reading.. Not a bad KB/Q/Whatever...

 

 

Basically it talks about TempDB needing to be as fast and efficient as possible. This is especially true if you're using SQL Server for ECM...