THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Did You Know? You, too, can be a Geek!

 

Danny Gould has a new (beta) version of his Internals Viewer, that you can download from Codeplex at http://www.codeplex.com/InternalsViewer

I've just started playing around with it, and the coolest thing is that it integrates right with your Management Studio!

The codeplex site include a Troubleshooting Guide and a User Guide.

It does look like it can display SQL Server 2008 data pages that have been compressed. For pages with ROW compression you'll be able to see the data, but for PAGE compression, no translation is done.

You can also request to have information from the transaction log displayed, but it's not the same as the 3rd party log reader tools, in that it doesn't give you the complete set of values that were inserted  or deleted.

I'm still exploring its nuances, and now you can too!

 

Have fun!

~Kalen

Published Tuesday, December 30, 2008 8:33 PM by Kalen Delaney
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Brennan Gordon said:

Kalen

On the subject of 3rd Party log reader tools, is there one that you recommend?

December 31, 2008 2:12 AM
 

AaronBertrand said:

Brennan, Apex SQL Log or Lumigent Log Explorer.  I'm not sure if they have updated for SQL Server 2008 yet; you'll need to check their web sites.  http://www.apexsql.com and http://www.lumigent.com/

December 31, 2008 10:03 AM
 

George Kwofie said:

pls i will like us talk about sql mail me to have yr e-mail

thanks

January 5, 2009 8:40 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Favorite Non-technical Sites or Blogs

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement