Make IT Complete

Technical Ramblings From an IT Professional

Entries for May, 2009

Auto Delete Content In Drupal

I have a client that wants to have content posted on his site automatically deleted when it reaches 30 days.  His site is built using Drupal and using the hook_cron() will let the scheduled cron job process the node deletions.
I created a Drupal module and in the .module file added function profeng_cron() as the hook [...]

Design Pattern for Database Incremental Loads.

http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/05/21/ssis-design-pattern-incremental-loads.aspx

MySite Clean Up

http://httpcode.com/blogs/PermaLink,guid,1cef79c3-bfeb-4eee-99ac-1c8b6050cf2b.aspx

Configure Outlook for Your Email Account

Follow the attached instructions to configure Outlook for your email account.
outlook-configuration-settings

Display the Item ID Number in SharePoint Lists

http://pathtosharepoint.wordpress.com/2009/01/18/item-id-in-display-and-edit-forms/

Where does a SharePoint Server Store the Name of the Config Database

WSS 2.0 and SPS 2003:      HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\Secure\ConfigDb
WSS 3.0 and MOSS 2007:   HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDb

List all the databases on SQL Server

List all the database on SQL Servers.
—-SQL SERVER 2005 System Procedures
EXEC sp_databases
EXEC sp_helpdb

—-SQL 2000 Method still works in SQL Server 2005
SELECT name
FROM sys.databases

SELECT name
FROM sys.sysdatabases