Ugh! Finally I got my new hosting space so that I don’t get anymore MySQL errors and have to do constant table repair commands, which would often fail with a datawrite operations because of the temporary allocation required to run them. Yea!
So I went from this tragedy

To being in the green (or blue [...]

Continue Reading This Article...

Today I went to the last lecture that concluded my foundational MBA course at USC (actually I am still in the lecture hall while I am writing this). The title of the lecture sounded intimidating: The Degradation of Empirical Software Development Management Techniques. Yikes. However extensive and unapproachable the title made [...]

Continue Reading This Article...

A friend just asked me the way to cast a SPList To a SPDocumentLibrary so that he could access the document library specific attributes for document library objects. This is one way of doing it:
PLAIN TEXT
C#:

public static SPWeb GetWeb(string url)

{

using (SPSite site = new SPSite(url))

{

using (SPWeb web = site.OpenWeb())

{

return web;

}

}

}

 

public static SPDocumentLibrary CastDocumentLibrary(string url, string [...]

Continue Reading This Article...

So, today one of my friends asked me if I knew how to return the names of all the fields in a table using a stored procedure so that he could build the names into a generic string collection. This is how you do it:
PLAIN TEXT
SQL:

CREATE PROCEDURE [dbo].[GetColumnNames] @tableName VARCHAR(50)

AS

SELECT  name

FROM    syscolumns

WHERE   id = OBJECT_ID(@tableName) [...]

Continue Reading This Article...

I was at a small lecture at USC yesterday for a foundational MBA course where the subject of the talk was varying management approaches across assorted industries when dealing with common software management. It was a brilliant discussion, very well thought out by Professor Ashby of the Economics Department. I really enjoyed the latter section [...]

Continue Reading This Article...