Mareo Code

I always wanted to have automatic build version increment for my apps and libraries to avoid setting it manually again and again. Additionally there should be support inside Visual Studio and  possibility for custom settings because I like the “date signing” where 3 last fields are just YYYY-MM-DD.

A dream come true ;) in form of Build Version Increment add-in for Visual Studio 2005/2008. This great add-in is very simple in use but do exactly what everyone developer needs. Add-in webpage: http://autobuildversion.codeplex.com/

My screenshots should say everything. Enjoy!

Read more…

I have downloaded the newest version of well known free documentation tool called GhostDoc and by chance I notest that company which is a owner of GhostDoc made some very nice free e-book about .NET Coding Guidelines (for C#/VB).

There is about 100 pages of good coding practices. You can download e-book (pdf) here (enter as email whatever you want and download will start)

Below table of contents.

Update: There is also another very good document about code styling. Provided by IDesign company and used by great free VS add-in Code Style Enforcer. You can download this doc here
Read more…

Don’t “waste” your time to write or use some custom code, SP etc. Just download this great, freeware tool xSQL Object Search and enjoy his fast work and advanced search options.

This is a standalone file, no installation required.

From authors webpage: http://www.xsqlsoftware.com/Product/Sql_Database_Object_Search.aspx

xSQL Object Search is a free SQL tool that provides for locating database objects by checking their names and/or definition against a search criteria. You can search on one or multiple databases simultaneously, select from various search options, search for all or specific objects types, export the results to output files and more. Supports SQL Server 2008 and SQL Server 2005.

Requirements

xSQL Object Search runs on Windows operating systems, client and server, that have the .NET framework 2.0 installed.

Features

Search on one or all databases – choose to find the objects that meet the search criteria on one database or on all databases in the selected SQL Server.

Support all types of database objects – from tables and views to CLR objects and Xml Schema Collections, you can search all database object types.

Search the name or the definition – choose to search on the name of the objects, the T-SQL statement definition of the objects or on both.

A range of search options

• Exact: Searches for objects whose name or definition is exactly the same as the search text.
• Starts With: Locates objects whose name or definition starts with the specified search text.
• Ends With: Locates objects whose name or definition ends with the specified search text.
• Contains: Locates objects whose name or definition contains the specified search text.
• SQL Server Expression: Locates objects based a SQL Server expression. Any SQL Server functions and operators that can be used in the “where clause” of a query can participate in the SQL Server Expression criteria.
• Regular Expression: Locates objects whose name or definition meets a regular expression pattern.

View object definition – view the T-SQL statement that defines the object with a click of a button.

Export search results – easily export the result of the search to a comma-separated-value file.

Simple and intuitive interface – a very simple interface allows you to finish your task with very few clicks. Asynchronous operations provides for a smooth search with status messages and counts.

Sometimes we need some application which allow us to send some messages, files to recipients automatically based on our settings. It is especially helpful if we set up low-cost scenario. For example: SQL Server Express (it means no SQL Agent and DTS export/import functionality, Database Mail module etc.)

From few freeware programs which I tested I would like to recommend you BEEE (Better Email Enable Everything). It is Free for commercial and personal use.

It is not longer supported by producent but it is still available for download from their webpage. Old doesn’t mean weak or poor functionality. This program is really brillant and works like a charm!

BEEE feature list:

- Easily email multiple files and/or entire folders
- Run multiple instances of BEEE at the same time
- Run BEEE in the background (from your system tray)
- Command line options allow for easy integration with most application software that can run executables (e. g. task schedulers)
- Build-in ZIP compression, encryption and password protection of the attachments !
- Email indirectly via MAPI enabled email clients (e.g. Outlook, Outlook Express or Eudora)
- Specify individual email addresses for each file within the file name!
- Send to email lists, e.g. to automate dispatch of newsletters
- Free for private and commercial use !

Runs on Win 95, 98, ME, NT and Win 2000/XP/2003 ! (also Windows Server 2000 and 2003) I didn’t test it on Windows Server 2008 but should also work fine.

BEEE can also monitor particular folder for files (you can define mask for filenames and extension) and after file detection in directory will send files automatically to defined destination.

Application download, more info and free commercial licence key