Archives
Blogroll
- BioTeck.NET
- Calvyn/IT Engineer
- Certless Designer
- DJ Equipment by Serato
- Documentation
- Dreamnetworkz
- e-leaguers – Web design
- easy make money online
- Gadget news, Tech blog
- GaryOoi
- GeekAdviser.com
- Heartbeat
- iappsgeek
- increase traffic free
- Jayce Ooi’s Paradise
- PhotoshopSlave
- Plugins
- Portachi web directory
- Pricing Strategies
- Software Tips
- Tech At Hand Dot Net | Philippines
- techetron.com
- Technology Bloggers
- Themes
- Wordpress Blog Tips
Database Archive
-
SQL Server 2005 Database Autogrowth option is a bug
Posted on December 7, 2010 | 1 CommentWhen maintaining a SQL Server database, you have the option to select if you want to restrict the growth of a database or transaction log or give SQL Server the liberty to grow automatically without setting a restriction. You select unrestricted file growth when you... -
Here’s a SQL Server Tip
Posted on July 29, 2010 | 2 CommentsHow many times have you asked this question when you run a query. How do I copy the query result with the column names into Microsoft Excel? In the SQL Server Management Studio, in the Tools menu, select Tools > Options > SQL Server >... -
SQL xp_findnextmsg and xp_readmail
Posted on November 15, 2009 | 2 CommentsIf you use SQL mail, you can read the messages in the SQL inbox stack and do stuff with them. Recently I had to use SQL scripting to find messages in the SQL inbox, read the message, determine if it is a text or html... -
SQL Server Integration Services is the new Data Transformation tool for SQL Server
Posted on December 27, 2008 | No CommentsI wrote this post months ago but didn’t get around to publish it. I know that SQL Server 2008 is now an available product but many of us are still using SQL Server 2005 and have created a lot Data Transformation Services (DTS) in the... -
Database Mail vs SQL Mail in SQL Server 2005
Posted on October 29, 2008 | 1 CommentSQL Mail was what one would use to send emails from SQL Server in the SQL Server 2000 version. But in SQL Server 2005, SQL Mail is considered legacy. Microsoft introduced a better email component called Database Mail for SQL Server 2005. In SQL Mail,...












