Month: March 2006

SharePoint–Using SQL Queries to Help Admin a Farm

Despite Microsoft’s insistence that one should never query a content database directly, I still find that SQL is a powerful tool that allows me to quickly gain an understanding of how my farm, web applications, and sites are being utilized by the enterprise.  Until I get a tool that lets me do this in the Microsoft “recommended” manner, I’ll stick with them… just need to remember that when querying the data I really want to make sure that I always use dirty reads by utilizing the “with (nolock)” hint so I’m not locking the database during normal activity hours....

Read More

Visual Studio–VSTO vs VSTA

Do you know the difference between VSTO and VSTA? Did you already hear about MAF? Check out Andrew’s latest post! Synopsis: VSTO was originally designed to support the building of managed extensions to Office applications. Visual Studio Tools for Applications (VSTA) was branched from VSTO with the aim of providing the same kind of support for all applications, managed or unmanaged. At the heart of VSTA is the Managed Add-in Framework (MAF). MAF is an architectural framework, with basic implementation in WinFx. In COM, version-resilience was achieved through late-bound automation interfaces, where all parameters were coerced into VARIANTs. In MAF, a similar model applies, using runtime reflection in place of IDispatch, and using a constrained set of parameter types (simple value types, strings, enums, contracts, serializable structs). A contract is represented by the IContract interface, defined in System.Addin.Contract.dll. So to boil it down to a nutshell, MAF can be seen as the .NET equivalent of...

Read More