SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

The Database Weekly Update for June 30, 2008

By Steve Jones, 2008/06/30

Total article views: 20 | Views in the last 30 days: 1

Building on a Budget

Wikipedia runs a large site that serves lots, and lots of requests. In fact, they get a decent number from me when I'm researching editorials and my kids think "everything" is on Wikipedia, their first site of choice for looking things up.

They have a nice article on their infrastructure, which includes 80,000 queries / sec. That's a pretty high load, higher than I've worked on for one service. However unlike Google, Microsoft, and others, they don't have a huge budget to spend on hardware. It's an interesting look at how they do a lot with a little and might be something those smaller companies out there should think about.

The Impedance Mismatch

There's a war going on about the Entity Framework v1 and what some people consider issues with its implementation. I'm not really sure technically what's important and what's a problem, but I do know a few things. One is that any "new" technology isn't completely thought out. Some of the pros and cons I've seen written about EF are similar to what I saw on .NET, especially ASP.NET, VB, and other technologies in the past. At this point, NO ONE has really used the technology that much and can't say for sure what's best, what's needed, and what problems might occur. It takes years for the technology to mature and application to grow and succeed for fail over time.

I did see agreat blog post from Stephen Forte that I think has a great point. All these technologies to make life easier for developers, especially the object based ones, should be moving closer to the database not further away. I know this isn't the path of least resistance and most profit, but it's the one I think we should move towards.

SQL Server 2008

It's getting close. I know we've heard this before, but I'm starting to see quite a few Connect items marked as "will not get fixed by RTM", meaning that it's too close to the end for these items to be fixed. I even heard about a bug that was fixed, but it couldn't be included in the final build, which is in testing. Apparently only critical bugs (data loss, large scale effect) will get fixed right now.

That's good and bad. It seems like SQL Server 2005 hasn't been out that long, but we're closing on 3 years. And with SQL Server 2000 (mainstream) support done, there are lots of people needing to think about upgrading to either 2005 or 2008 (hint, choose 2008).

Lots of blog posts and more and more articles are appearing on the new version. This week I saw some interesting ones on Auditing, Powershell, XML changes, TDE, and more. I'd check those out and see if there's a feature in there that might make a compelling business case for your enterprise.

Steve Jones

Steve's Pick of the Week

Unusual data center access - I am not really sure what to write here, but it's pretty funny. At the very least it's worth checking out the image.


The Voice of the DBA Podcasts

The podcast feeds are now available at sqlservercentral.podshow.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Incompetech. Kevin Macleod has some great compositions in all genres of music. Check him out at www.incompetech.com.

Incompetech

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

By Steve Jones, 2008/06/30

Total article views: 20 | Views in the last 30 days: 1
Your response
 
 
Related tags

Database Weekly    
Editorial    
 
Related content

Feature (In)Complete

By Steve Jones | Category: Editorial
(not yet rated) | 67 reads

The Exceptional DBA

By Tony Davis | Category: Editorial
| 324 reads

No XP, but Look Forward To 7

By Steve Jones | Category: Editorial
(not yet rated) | 106 reads

Behind the Curtain

By Steve Jones | Category: Editorial
(not yet rated) | 24 reads
Already registered?  

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

  

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com