Powered by discountASP.NET
referal ID: sdtref
Why recommend discountASP.NET?

Archives
Steve Trefethen Steve's RSS Feed Subscribe or via email
What's this?
Contact me Send mail to the author(s)
About Me
View my LinkedIn profile

Add to Google
Subscribe with Bloglines
MCP Microsoft Certified Professional

Falafel Software
ActiveFocus Project Management Solution by Falafel Software
Online or OnSite TestComplete Training
Blogroll
Recent Comments
My Online Tools
Stats
Total Posts: 460
This Year: 65
This Month: 1
This Week: 2
Comments: 1616
Tags
Disclaimer
The posts on this weblog are provided �AS IS� with no warranties, and confer no rights. The opinions expressed herein are my own personal opinions and do not represent my employer�s view in any way.
My most popular blog posts (Q1 2008)
# Monday, June 23, 2008

For me Google Reader just gained some serious competition in feedly

Posted @ 10:12PM by Steve Trefethen

Categories: Tools

Tags:

If you haven’t checked out feedly and you’re a blog/RSS reader you definitely should. It’s a Firefox 3.0 plugin that has some really cool features and turns your feeds into a magazine style web page.

[Updated: June 24, 2008] I should mention that this is really functioning as an alternative UI for Google Reader rather than a replacement since it updates Google Reader as I'm reading items.

 feedly Firefox plugin

# Tuesday, June 17, 2008

SQL Server Index Nightmare

Posted @ 11:21PM by Steve Trefethen

Categories: Tips | Tools

Tags:  | 

The other day I discovered one of the MSSQL tables I’m using heavily at the moment had 214 indices! There were about 20 with sensible names and the rest were all named similar to _dta_index_SA_OrderHeader_5_499519046__K1_2_6_9_13. I mentioned this issue to John Waters in the office today which elicited a nice laugh until I sent him this screenshot:

SQL Manager 2008 Lite

While I’m not exactly new to MSSQL I’m no expert though fortunately Falafel has a few experts on staff and John’s one of them. He dug into the problem answering the what, where and how to deal them, feel free to click through if that’s what you need.

Had I not blogged back in February asking about MSSQL tools this problem would likely have gone undetected for a lot longer. Microsoft’s Management Studio doesn’t show these so called Hypothetical Indices so you have no way of knowing your table/DB is being impacted by them. Ironically, they’re created by the Index Tuning Wizard. Anyway, one commenter to my post mentioned EMS Database Management Solutions (a mouthful notwithstanding whatever EMS stands for) SQL Manager 2008 for which there is a freeware download. SQL Manager’s treeview provides a wealth of information including counts for things like indices which allowed me to easily stumble upon the problem.

All in all, there were 500+ of these indices hanging around but thanks to SQL Manager no longer!

# Sunday, May 11, 2008

Generating MSDN style documentation using Sandcastle

Posted @ 11:34PM by Steve Trefethen

Categories: Tools

Tags:

ScrewTurn wiki with hosted MSDN style API documentation

To the right is a screenshot of MSDN style documentation created using Microsoft’s SandCastle and SandCastle Help File Builder (SHFB) which is generated as part of a Continuous Integration build running under CruiseControl.NET shown here hosted within a page on a ScrewTurn wiki at a client’s site.

The documentation was created for the EDI Invoicing system I developed. Originally, I’d simply followed the Thoughtworks style for documenting Tasks and Source Control providers but that proved rather time consuming and required a fair amount of hand editing. Using this mechanism the documentation on the wiki is always up-to-date and I don’t have to worry about maintaining lots of static content.

SandCastle Help File Builder to the Rescue

SandCastle Help File Builder GUI

Rather than using SandCastle, Microsoft’s oh-so-slowly-developing documentation tool for managed code, Eric Woodruff has created SHFB which gives SandCastle the user experience you’d expect from Microsoft itself. (btw, if you’re a Borland fan be sure to check out Eric’s Turbo Vision page for a trip down memory lane)

SHFB allows you to create a project, select the desired assemblies, and generated web based MSDN style documentation easily. In fact, SHFB allows you to select from three different web site styles. Be sure to read the Links to Resources section as there are a number of additional tools required. Of course, the same thing is possible with SandCastle itself and if you’re up for it check out this post for details.

Generating API Doc Under Continuous Integration

Since I didn’t want to have to manually regenerate the documentation I setup a CruiseControl.NET task to handle creating the documentation web site which also uses SHFB and looks like this:

<exec executable="C:\Program Files\EWSoftware\SHFB\SandcastleBuilderConsole.exe"> <baseDirectory>c:\work\utilities\edi\help</baseDirectory> <buildArgs>vtalk.shfb</buildArgs> <buildTimeoutSeconds>2400</buildTimeoutSeconds> </exec>

Adding this as a task ensures that the documentation is never out of date with the one minor downside being that the documentation isn’t available during the build but that’s really minor.

Conclusion

If you’ve been holding off using SandCastle or have been looking for tools to make it easier be sure to give SHFB a try as it worked like a charm for me.

What’s your experience with SandCastle been like? Have you tried it?

# Monday, March 03, 2008

ScrewTurn the perfect small business wiki

Posted @ 1:00PM by Steve Trefethen

Categories: Hosting | Open Source | Tools

Tags:  |  | 

If you haven’t taken a look at ScrewTurn wiki you should. In two words, it rocks!

Why?

I think this wiki engine can easily serve as a starting point for a flexible small business web site.

I’m personally using this wiki engine on my own web site not to mention Falafel Software is using it as an internal company wiki. I’ve also installed it at a client location and it’s been well received and used daily.

If your company needs help getting this wiki or an entire web site setup feel free to contact me.
# Wednesday, February 20, 2008

What do you use to explorer an MSSQL database?

Posted @ 4:36PM by Steve Trefethen

Categories: Tools

Tags:

Having left CodeGear back in July and having now been out in the "real world" doing consulting for awhile I’m wondering what do MS SQL developers use to explore a SQL server database?

If you’re answer is SQL Server Management Studio (SSMS) that’s not what I’m looking for and I find it really lacking in numerous areas. I’m looking for something that includes things like:

  • Ability to view details of a table’s structure (column types, size etc.) without having to "design" the table
  • Ability to view the details of a foreign keys without having to "design" the table
  • Provide a "favorites" list where I can tag any entity in the DB as a "favorite"
  • Context menus that include a Copy command for selected items like table names, SPROCs etc.
  • A real Properties window unlike SSMS which displays properties of whatever the selected item is not just what’s in one window. Server explorer in VS.NET works the way I’d like but it’s missing on a table for keys, constraints, triggers, indexes...
  • Counts of objects (tables, fields, indices etc.)

The system I’m working has 100’s of tables, SPROCs etc. and is large which makes spelunking slow and tedious. I know Delphi includes the Database Explorer but that requires a full Delphi license and while I have a licensed copy I don’t want to install the entire IDE just for that.

So, what do you use?