I want to come up with the minimal set of queries that return the databases and tables in a Microsoft SQL Server instance, on as many versions of SQL Server as possible. I'm not sure if I should half-answer my own question, but here's what I think I need for 2000 and 2005. Ideally I'd go back further, but I don't have access to older ve...
I have been given the task of either finding or developing a metadata repository for our development group. Since we work for a government agency, there is little or no money available for purchasing an off-the-shelf solution. And, since I am a developer as well, I would rather not build a new system if I don't have to. We would like ...
I'm trying to turn Etags off on iis 6 since I'm load ballancing multiple servers, I don't want the etag to become a problem. ...
I was mildly surprised recently to discover that my carefully crafted xml comments weren't showing up in intellisense for my colleagues. Having always used the associated assemblies with project references, I hadn't realised that you had to export the .xml document as well to access this information. This led me to wondering how the .Ne...
I'm regularly creating an XSD schema by transforming a proprietary data model of a legacy system. This works out pretty good. However, the legacy system only allows me to specify very basic attributes of a parameter, such as the data type (int, string etc.). I would like to enhance the XSL transformation with a mechanism that allows me ...
Hi, the title sums it up really. Using the standalone exiftool program to dump all image metadata to a console I can see a line Color Space Data : RGB It looks like this is taken from the ICC-header I want to get the same data programatically in java. I've tried the drew noakes library and the Sanselan library, but neither give me a val...
I have a fair number of Python scripts that contain reusable code that are used and referenced by other Python scripts. However, these scripts tend to be scattered across different directories and I find it to be somewhat tedious to have to include (most often multiple) calls to sys.path.append on my top-level scripts. I just want to pro...
Hello all. I have a list of URLs and am trying to collect their "descriptions." By description I mean what comes up, for example, if you Googled the link. For example, http://stackoverflow.com">Google: http://stackoverflow.com shows the description as A language-independent collaboratively edited question and answer site for ...
I'm working on a small project to help me tag content on Flickr. I've been looking through the API and there's obvious ways to search for tagged content, but not a simple way of finding what content hasn't been tagged (without just looping through image ID's till I find one with no tag). Has anyone come across this in the past and foun...
Hi There... Im running a project on a PostGres database and need to retrieve the comments on columns within the DB to be used as table headings and such. I have seen that there are a couple of built in functions (pg_description and col_description) but i haven't been able to find examples on how to use them and playing around with them ...
Scenario: there is an Adobe Flex 3 project which uses several third-party libraries and components in the form of SWC files. How can we know "what is inside" those SWC files? Specifically, how can I make sure that the project uses the latest versions of all those components? According to official Adobe Flex 3 help, "you can define" (si...
We have a database that persist our metadata and data. Our metadata is produced buy a dedicated team, using a Web application on the development server, and is a critical part of our application. Then the customer generates data according to this metadata. We already version the database schema, and all schema change. The next step is...
Is it possible to add a "metadata"-like description or comments to a table in Microsoft SQL 2000 and above? How would you do this through the CREATE TABLE statement? Is it possible to add a description or comment to fields? How do you query this info back in MSSQL 2000? 2005? ...
I'm learning how to use greasemonkey and was wondering what the @namespace metadata part is used for. Does it have to be a web address or can it be a folder/directory on my computer? Does it even need to be filled in or can I just ignore it? Thanks for the help :) ...
I work for an organization where we take raw MPEG-2 video files of lectures from academic institutions and make them available on our website in a variety of formats. Right now the workflow for turning the MPEG-2 into audio (MP3) and video (MP4), uploading to iTunes U, YouTube, etc. is extremely tedious. I would like to automate this pro...
I have an archive of Dilbert cartoons, and would like to organize them in a way, that I can find the one I need based on something on the order of a keyword search. I am looking for suggestions on a reasonable way to accomplish that programatically. I am leaning towards perl for an implemenation. ...
I use SVN as source control system and I wonder how to compare directories while ignoring any metadata differences. Is there a way to tell svn diff to compare only the actual content and ignore any metadata? I mean metadata like SVN properties, etc, that don't affect the file content. Assume file X has an additional property in branch ...
I've been using mutagen for reading and writing MP3 tags, but I want to be able to embed album art directly into the file. ...
I was thinking of writing a PHP script that would analyse a CMS'd page's content (i.e. database field) and then auto-generate (X)HTML META description & keyword tags, but as always there's no point reinventing the wheel so I'm wondering if anyone knows of such a beastie? The former I imagine would be something like a relatively straight...
How do you find which SPs are declared WITH RECOMPILE, either in INFORMATION_SCHEMA, sys.objects or some other metadata? (I'm adding some code to my system health monitoring and want to warn on ones which are declared that way where it is not justifiable.) Note: I'm not looking for general text search for 'WITH RECOMPILE' - I can alrea...