Tech Tips, Tricks & Trivia

According to Tim O'Reilly 's whitepaper , a company that has most of the seven features listed below may be considered Web 2.0 compliant. * Services, not packaged software, with cost-effective scalability * Control over unique, hard-to-recreate data sources that get richer as more people use them * Trusting users as co-developers * Harnessing collective intelligence * Leveraging the long tail through customer self-service * Software above the level of a single device * Lightweight user interfaces, development models, AND business models

SourceForge features the best projects picked each month based on their quality and success as an Open Source project in Project of the Month . Projects like FCKeditor , a XHTML-compliant online text editor by Frederico Caldeira Knabben, that was featured on that list is good stuff for hobbyists and application developers to check. There are also other good Open Source WYSIWYG Web Editors available on the Web to choose.

While deploying applications, you may require details of the SQL Server edition or other properties, like I did when I had to find if the latest Service Packs were installed and this function is useful to know: SELECT SERVERPROPERTY('ProductLevel') Edition ProductVersion ServerName Collation Engine Edition InstanceName IsClustered IsFullTextInstalled IsIntegratedSecurityOnly IsSingleUser IsSyncWithBackup LicenseType MachineName NumLicenses ProcessID