Yesterday I posted a line [http://weblogs.asp.net/ashben/archive/2004/01/29/64327.aspx] on the Matisse Database [http://www.matisse.com/], said to be The Ultimate .NET Database [http://www.matisse.com/pdf/product_information/Whitepapers/DotNETarticle.pdf] (PDF). Comments [http://weblogs.asp.net/ashben/archive/2004/…
Stuart Langridge [http://www.kryogenix.org/], writes about why he doesn’t like databases [http://www.kryogenix.org/days/2004/01/17/databases] and why to “use the filesystem as your database” (in context to the backend of a blog, I guess). IMO, it may hold some value to design…
DavidM [http://weblogs.sqlteam.com/davidm/] is running some interesting notes on DataTable Relational Operators (in C#) — Introduction [http://weblogs.sqlteam.com/davidm/posts/717.aspx], JOIN [http://weblogs.sqlteam.com/davidm/posts/748.aspx], UNION [http://weblogs.sqlteam.com/davidm/posts/724.aspx], DISTINCT helper method [http://weblogs.sqlteam.…
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…
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…
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…
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…
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…