SQLite

SQLite [http://www.sqlite.org/] is an embeddable SQL database engine which can perform upto two times faster [http://www.sqlite.org/speed.html] than PostgreSQL and MySQL for many common operations. With a small memory footprint and?support for databases upto 2 terabyte, its an ideal option for embedded…

ASP.NET Exposed Roadshow and VS.NET Automation Samples

Maybe I’ve mentioned this one before but its worth it!?The creators of ASP.NET are coming to a city near you. This is your chance to receive FREE, in-depth training on Microsoft’s web development platform.?So do go catch the ASP.NET Exposed Roadshow [http://www.asp.…

C# Class Generator and World's Largest Databases

C# Class Generator [http://www.csharpfriends.com/demos/csharp_class_generator.aspx] – is a pretty simple web-based utility which?automagically [http://www.dict.org/bin/Dict?Form=Dict2&Database=*&Query=automagically] generates a complete C# class (and the Data Access?Tier methods) from specified field inputs. Also: Survey…

SQL Server 2000 Reporting Services

Have you tried the beta release of SQL Server 2000 Reporting Services [http://www.microsoft.com/sql/reporting/] yet? If so, please leave a comment on what you think of it. How does it compare to Crystal Reports 9 [http://www.crystaldecisions.com/products/crystalreports/net/default.asp]? By the…

MySQL Gotchas

Anyone using MySQL [http://www.mysql.com] as a primary or secondary database system must checkout the MySQL Gotchas [http://sql-info.de/mysql/gotchas.html] (a list of features or functions which work as advertised – but not as expected). MySQL can be accessed from VB.NET using some managed class…

.NET Tools and BizTalk

A friend from work sent me this list of Companion Tools for .NET development [http://www.csharpfriends.com/statics/tools.aspx]. For anyone into BizTalk (2002 or 2004b [http://www.microsoft.com/biztalk/beta/] ), you must checkout the BizTalk User Group [http://www.biztalkug.com/]. Its a growing community with…

Network Ports, LCIDs and SQL ParseName

Here’s an Excel spreadsheet [http://www.microsoft.com/downloads/details.aspx?familyid=e114b7e5-400f-45b6-9e1c-50968a0cc729&displaylang=en] illustrating network ports used by Microsoft products. The spreadsheet shows what network ports are used by the system services utilized by the Microsoft Windows Server System products. And there’s a List of…

xp_dirtree and Dynamic Page Title

The xp_dirtree extended procedure in SQL Server (7.0 and 2000) will list the subdirectories in the specified directory. Usage: EXEC master.dbo.xp_dirtree ‘C:Windows’ As I learnt today, the title (browser window title) of an ASP.NET page can be changed programatically. Here how … In the…