SQL Object Search
Tuesday, August 08, 2006
SQL Object Search Screenshot
As promised, here is a screenshot of the latest version of SQL Object Search.
Click to see the full size image.
Saturday, August 05, 2006
Welcome to the SQL Object Search blog
Hi there,
Let me introduce myself. My name is Marcel Isler. I'm a software engineer and I have been in this field for nearly 25 years now. I started writing software when I was 15 years old and it has been my occupation and my passion ever since then.
I've been using many different programming languages and C# 2.0 has become my current favorite. I've also been working with many different SQL databases in the course of my career and I'm currently working on projects that use Microsoft SQL Server 2000 and 2005.
I started writing SQL Object Search about 5 months ago when I had to do some investigation on SQL code usage in fairly large databases with around 2000 stored procedures per server. Not being able to easily find references to other stored procedures, tables, views and functions was very frustrating and there were barely tools available to do the job and the ones that I could find didn't work the way I was envisioning how the process should work.
I am now at the point where I have a small group of beta testers using the software on a daily basis and the feedback has been very positive. I plan to have the final release version ready by early September 2006.
Here are a few highlights of SQL Object Search:
Well, I think that's it for today... I'm going to take some screenshots and post them in the next few days.
Thanks for reading and I hope you are just about as excited about this tool as I am :)
Let me introduce myself. My name is Marcel Isler. I'm a software engineer and I have been in this field for nearly 25 years now. I started writing software when I was 15 years old and it has been my occupation and my passion ever since then.
I've been using many different programming languages and C# 2.0 has become my current favorite. I've also been working with many different SQL databases in the course of my career and I'm currently working on projects that use Microsoft SQL Server 2000 and 2005.
I started writing SQL Object Search about 5 months ago when I had to do some investigation on SQL code usage in fairly large databases with around 2000 stored procedures per server. Not being able to easily find references to other stored procedures, tables, views and functions was very frustrating and there were barely tools available to do the job and the ones that I could find didn't work the way I was envisioning how the process should work.
I am now at the point where I have a small group of beta testers using the software on a daily basis and the feedback has been very positive. I plan to have the final release version ready by early September 2006.
Here are a few highlights of SQL Object Search:
- Search for text inside of table definitions, view definitions, stored procedures, functions and triggers inside of all the databases of a server instance.
- Fast searches, usually within 2 seconds.
- Four search modes allow the user to search for very specific patters, i.e. contains, starts with, ends with and exact matches. This is done case insensitive and on a word basis.
- Intuitive Windows User Interface, with features similar to Visual Studio 2005, i.e. docking of the different window components, persistence of the window layout between sessions and so on.
- SQL Syntax coloring of the source code just like in Query Analyzer.
- Search result window with sorting and filter capability.
- Connect to Microsoft SQL Server 2000 and 2005 using Windows or SQL authentication.
- No code needs to be installed on the SQL Server itself.
Well, I think that's it for today... I'm going to take some screenshots and post them in the next few days.
Thanks for reading and I hope you are just about as excited about this tool as I am :)
