Archive for April, 2009

Configure linked servers for Excel and MS SQL Server in MS SQL Server 2005

Linked servers allows
A linked server configuration allows Microsoft® SQL Server™ to execute commands against OLE DB data sources on different servers
Quote from MSDN

This way we have an abstract layer to other data sources (different from MS SQL Server) and we can connect them using T-SQL of MS SQL Server and only one instance of it. [...]

MS Technology Specialist: WSS 3.0 - Application Development

Last Friday, I passed MCTS: WSS 3.0 - Application Development successfully. I’d like to share my experience with this exam in this post.
First of all, it was really hard to prepare myself for the exam because I’ve started to learn and practice WSS 3.0 last December. I’ve passed several Microsoft exams and this one was [...]