THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Kalen Delaney

Geek City: My New Favorite Tool - SQL Internals Viewer

At least, I think it might become my new favorite tool.  J

One of my readers created a tool to graphically display database storage internals, like allocation information, actual page contents, etc. This is just the tool I would have wanted to write if I ever got back to doing any programming. Here's what the author, Danny Gould, says:

The application acts as a viewer for database internals, including pages and allocation structures. I’ve created it with the aim of it helping people learn and investigate internals. There is more information about it at its website, www.sqlinternalsviewer.com I’ve really enjoyed creating the application and I continue to learn from developing it. I plan to create some online tutorials on how to use it.

Danny would love to get feedback on the tool, as well as suggestions for enhancements. As a sneak preview, here's an image of the tool from the main page of the web site:

Allocation Map showing IAM selected in the Database Browser
Allocation Map showing IAM selected in the Database Browser

 

Have fun!

~Kalen


Published Thursday, July 19, 2007 8:52 PM by Kalen Delaney

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

 

Chuck said:

wow.

July 19, 2007 11:47 PM
 

Brennang said:

Fantastic! Not sure what I will use it for but very cool. I expect, as a teacher, you would find it extremely useful.

July 20, 2007 5:21 AM
 

Adam Machanic said:

Cool!  Looks similar to the SQL File Explorer app that used to be available (alas, the domain is now dead so I guess that app gone)...

July 20, 2007 9:03 AM
 

Jason Haley said:

July 20, 2007 9:06 AM
 

Impedance Mismatch said:

Apprendo giusto ora dal blog di Kalen che Danny Gould ha scritto un tool davvero bellissimo, che mette

July 20, 2007 11:26 AM
 

K. Brian Kelley - Databases, Infrastructure, and Security said:

First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's...

July 20, 2007 3:39 PM
 

Kalen Delaney said:

Danny Gould was very impressed by the interest in his SQL Internals tool from readers of my blog , so

July 30, 2007 11:13 PM
 

Navrang said:

What the hell is this

December 4, 2007 12:49 PM
 

Sherry said:

Mujhe kuch nahi pata

December 4, 2007 12:49 PM
 

Kalen Delaney said:

I know, I said that about the SQL Internals Viewer , and that of course was amazing, but very limited

April 1, 2008 3:00 AM
 

Kalen Delaney said:

I know, I said that about the SQL Internals Viewer , and that of course was amazing, but very limited

April 2, 2008 7:58 PM
 

Other Blogs we recommend (SSQA.net) said:

I know, I said that about the SQL Internals Viewer , and that of course was amazing, but very limited

April 16, 2008 12:45 PM
 

Mathieu Isabel said:

This is a very interesting tool! I love the feature where you can execute a SQL statement and see the impact on the indices by viewing the transaction log. This should definitely be part of SSMS! I know that SSMS uses the VS shell, is there any way to extend SSMS functionnality in the same way it's done in VS?

April 21, 2008 11:18 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

Favorite Non-technical Sites or Blogs

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