Anith Gopal

Lots of interesting posts by computer science teachers last week. And some news from various sources to share.

Last week someone on the SIGCSE mailing list mentioned that they learned to program in FORTRAN, using punch cards on an IBM 1130 . Well so did I and I said so.

A little-known fact about MS-DOS is that it allowed spaces in file names. Sure, you were limited to 8.3, but a file called ” LOOK AT.ME ” was legal in MS-DOS, and you could indeed create such a file. Good luck finding programs that didn’t treat you as insane when you asked for that file, though.

I’ve seen a few people get confused over what this error message in the Reporting Services log file indicates. This message is generated when the Reporting Services web server detects that an HTTP request has experienced a remote disconnect.  In practice, this means that we queried the property HttpResponse.IsClientConnected and it returned false. So how does this work exactly, and are all requests subject to this kind of check?

Microsoft Help 3.0 is the latest help platform.  It will be used in Visual Studio 2010 and later released with other products and eventually opened up to all Windows ISVs!  In three words Help 3 is: simple. fast.

Vance Morrison, a CLR architect, recently gave an interview to Channel 9 where he walks through the history of the CLR (he’s been on our team since it’s very beginning), the upcoming version, his favorite features in CLR v4, and what the future looks like. He also talks about concurrency (and the role that CLR plays), aspects of type inheritance, and his thoughts on blurring the difference between abstract base classes and interfaces. If you’re going “What does that even mean?”, go ahead and watch the video here

Hi, When I came across the article at MSDN How to: Programmatically Export the Crawl History to a CSV File  I thought I would never create such a tool just for that specific feature, as you end up with additional requirements in order to create an admin tool.

We have an SSIS package which connects to FoxPro Database. When we run the package, it gets the data from FoxPro database, Sorts it and uploads the data back to the SQL Server

The total space used by tempdb equal to the User Objects plus the Internal Objects plus the Version Store plus the Free Space. Use the Below Quer to Track what is consuming Space in Temp Db. =============================================================== SELECT SUM(unallocated_extent_page_count) AS [free pages], (SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB], SUM(version_store_reserved_page_count) AS [version store pages used], (SUM(version_store_reserved_page_count)*1.0/128) AS [version store space in MB], SUM(internal_object_reserved_page_count) AS [internal object pages used], (SUM(internal_object_reserved_page_count)*1.0/128) AS [internal object space in MB], SUM(user_object_reserved_page_count) AS [user object pages used], (SUM(user_object_reserved_page_count)*1.0/128) AS [user object space in MB] FROM sys.dm_db_file_space_usage;         Which Query and Session in Consuming the space in TempDB ==============================================   SELECT R1.session_id, R1.request_id, R1.Task_request_internal_objects_alloc_page_count, R1.Task_request_internal_objects_dealloc_page_count, R1.Task_request_user_objects_alloc_page_count, R1.Task_request_user_objects_dealloc_page_count, R3.Session_request_internal_objects_alloc_page_count , R3.Session_request_internal_objects_dealloc_page_count, R3.Session_request_user_objects_alloc_page_count, R3.Session_request_user_objects_dealloc_page_count, R2.sql_handle, RL2.text as SQLText, R2.statement_start_offset, R2.statement_end_offset, R2.plan_handle FROM (SELECT session_id, request_id, SUM(internal_objects_alloc_page_count) AS Task_request_internal_objects_alloc_page_count, SUM(internal_objects_dealloc_page_count)AS Task_request_internal_objects_dealloc_page_count, SUM(user_objects_alloc_page_count) AS Task_request_user_objects_alloc_page_count, SUM(user_objects_dealloc_page_count)AS Task_request_user_objects_dealloc_page_count FROM sys.dm_db_task_space_usage GROUP BY session_id, request_id) R1 INNER JOIN (SELECT session_id, SUM(internal_objects_alloc_page_count) AS Session_request_internal_objects_alloc_page_count, SUM(internal_objects_dealloc_page_count)AS Session_request_internal_objects_dealloc_page_count, SUM(user_objects_alloc_page_count) AS Session_request_user_objects_alloc_page_count, SUM(user_objects_dealloc_page_count)AS Session_request_user_objects_dealloc_page_count FROM sys.dm_db_Session_space_usage GROUP BY session_id) R3 on R1.session_id = R3.session_id INNER JOIN sys.dm_exec_requests R2 ON R1.session_id = R2.session_id and R1.request_id = R2.request_id OUTER APPLY sys.dm_exec_sql_text(R2.sql_handle) AS RL2;

Partial Classes and Methods (C# Programming Guide)…( read more )

We have a new look. Happy times.

Our first official Singapore Web Slice for Golden Village is now live at http://www.gv.com.sg .  Add the slice from IE8 from the “Now Showing” section, and you’ll be able to see and buy tickets for the latest movies showing at Singapore’s top movie chain at a click….( read more )