Wednesday, April 27, 2005

Step-by-Step Guide: Time Management

Time management is a mandatory subject everyone of us needs to learn one day or other. Many times I have had problems taking too many tasks in my head. There is an online guide on effective time management. You can check it here.


Friday, April 22, 2005

Memory management in Yukon

Check out slava oaks blog on internals of SQL Server 2005 (Code named: Yukon). Its really extensive and informative. I have decided to go through his blog more frequently :)

Thursday, April 21, 2005

Viewing the source code of SP in Yukon

Let us look into the way of displaying the definition of user defined stored procedure and system stored procedure in Sql Server 2005 (code named yukon).

In Sql Server 2000 we would use the sp_helptext to view the source code of both user defined and system stored procedure. But that isn't completely true in Yukon.

User defined stored procedure
In Yukon to view the source code of user defined stored proc use the following code snippet

sys.sp_helptext ProcedureName
sp_helptext ProcedureName

System stored procedure

In Sql server 2000 to view the source code of system stored procedure we use the following syntax

use master
sp_helptext sp_help

But sp_helptext cannot be used to display the definition of system objects in Yukon. So for system stored procedures use the following syntax.

Select object_definition (object_id ('sys.sp_helptext')) as 'Source of Sp_helptext'

Wednesday, April 20, 2005

Mr. Grimes’ Farewell (his last article)

For those who doesn't know who Dr. Grimes is ...

"Dr. Richard Grimes, who is one of the famous exponent of Microsoft technologies like ATL, WTL, COM, COM+ and.NET. He has written many books and articles on these techologies and a regular speakers in Microsoft conferences. One of the books he has written in .NET is 'Developing applications With Visual Studio.NET'. He has worked closely with Microsoft teams".

Recently (in Feb 2005), he stepped down from his post of writing articles and speaking about .NET technology and the reasons he gives as somebody who has closely worked with Microsoft is interesting. The article is published in Dr. Dobb's Journal. For .NET developers, this article gives information on the future Microsoft is planning for .NET. As a developer working in .NET technologies, I found this article informative. Here is the url of the article.