Monthly Archives: November 2009

As an IT Professional

Posted on November 30, 2009 by

>Simple tip to increate your value in IT Industry 1. Expand your contact list 2. Participate in group activities 3. Improve Public Speaking skill 4. Contribue your industry experience in technical blogs 5. Be ACTIVE in All the above

Posted in Uncategorized | Leave a comment

A Book of MVP’s

Posted on November 27, 2009 by

>PASS 2009 has one special memory. A team of 53 MVP’s has contributed to the community and for our society. The contribution is The Book, named ‘SQL SERVER MVP’s Deep Dives’. It has published by Manning Publishing Co.,. Every copy … Continue reading →

Posted in PASS | Tagged | Leave a comment

Undocumented Stored Procedures

Posted on November 27, 2009 by

>Following are the Undocumented stored procedures, which are not recommended to execute on production environment. Some of the useful and safe SP’s are given below. EXEC sp_fileexistEXEC xp_cmdshellEXEC sp_msforeachdbEXEC sp_msforeachtableEXEC sp_who, sp_who2EXEC sp_msdependencies–Windows RegistryEXEC xp_regreadEXEC xp_regwrite EXEC xp_regdeletekey EXEC xp_regdeletevalue … Continue reading →

Posted in SQL Server | Tagged , | Leave a comment

Spatial Data

Posted on November 26, 2009 by

SQL Server has introduced Spatial Datatype (Geometry, Geography) in the SQL Server 2008 release. They are enhancing the feature to store , view and edit spatial data in SQL Server database. MapPoint is the tool used to view and edit … Continue reading →

Posted in SQL Server | Tagged , , | Leave a comment