SQLite

SQLite is an embeddable SQL database engine which can perform upto two times faster 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 and?small to medium-scale deployments. And SQLite works like a…

C# Class Generator and World's Largest Databases

C# Class Generator – is a pretty simple web-based utility which?automagically generates a complete C# class (and the Data Access?Tier methods) from specified field inputs. Also: Survey Results for the Largest SQL Server Databases?… how does 5.3 tera-byte sound? Wait, there’s more … the…

SQL Server 2000 Reporting Services

Have you tried the beta release of SQL Server 2000 Reporting Services yet? If so, please leave a comment on what you think of it. How does it compare to Crystal Reports 9? By the way, the Crystal Reports .NET enterprise reporting solution videos (WMV) present a good overview –…

MySQL Gotchas

Anyone using MySQL as a primary or secondary database system must checkout the MySQL Gotchas (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 libs like MySQL Connexion, dotData or ADO.NET ODBC?…

.NET Tools and BizTalk

A friend from work sent me this list of Companion Tools for .NET development. For anyone into BizTalk (2002 or 2004b), you must checkout the BizTalk User Group. Its a growing community with lots of technical articles, whitepapers, tools?and jobs. I had some training on BizTalk about 1.5…

Network Ports, LCIDs and SQL ParseName

Here’s an Excel spreadsheet 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 Locale ID (LCID) Values as Assigned by Microsoft. It lists…

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…