Tuesday, December 09, 2003

Ever wanted an easy to adapt menu in .NET. Here's a great article by Scott Mitchell.

ASP.NET Home: Building an ASP.NET Menu Server Control (ASP.NET Technical Articles)

Tuesday, October 21, 2003

Working on a little project for people to send in their CV's through the website. I'm using XML as the database. In my quest for information I came across this article.

307029 - HOW TO: Transfer XML Data to Microsoft Excel 2002 by Using Visual C# .NET

Wednesday, October 15, 2003

New to Object Oriented Programming?
Check this out:
DotNetJunkies: The Quick and Dirty .NET Guide to C#/VB Object-Oriented Programming
Ever wondered what is in your SQL Server's cache and how many times a cached item is used?
Check out the master..syscacheobjects table.

If you want to work with the database name just join the table with the sysdatabases.dbid field.

eg.

SELECT master..sysdatabases.name, master..syscacheobjects.objtype,
master..syscacheobjects.cacheobjtype, master..syscacheobjects.usecounts,
master..syscacheobjects.[sql] FROM master..syscacheobjects
INNER JOIN master..sysdatabases ON master..syscacheobjects.dbid = master..sysdatabases.dbid
WHERE sysdatabases.name = 'yourdbname'
GROUP BY master..syscacheobjects.objtype, master..sysdatabases.name, master..syscacheobjects.cacheobjtype, master..syscacheobjects.status, master..syscacheobjects.[sql], master..syscacheobjects.usecounts
ORDER BY master..syscacheobjects.usecounts DESC
You've probably all heard about WinFS, the next generation file system from Microsoft. Well, here's a very interesting story:
Microsoft unpacks details of Longhorn storage | CNET News.com


"Think of WinFS as pulling together relational database technology, XML database technology, and file streaming that a file system has," he said. "It's a (storage) format that is agnostic, that is independent of the application."

Tuesday, October 14, 2003

I found a nice blog post about .NET 2.0. It looks very promising, lets hope they live up to their promises.

Edgar Sanchez's .NET Blog