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