use master
go
exec sp_databases
go
Need to find out where the files are on disk?
SELECT [name] [Database], [filename] [File Path]
FROM master..sysdatabases
Comments [0]
If you have been struggling like me to make your sites XHMTL compliant you realize that it’s not an easy task. Most of the changes are straight forward if you have a validation tool. I code a lot of sites in Visual Studio 2005 and it will complain like crazy if you have invalid XHTML. Hence I try not to write invalid XHMTL because I hate errors and warnings and will compulsively try to make my pages as valid as humanly possible.
One of the areas where I’ve had the most trouble with this is create bookmarks with anchor tags. Most of the examples I’ve seen use the name tag on an anchor so that you can link to it using something like http://example.com/test/#somebookmark. I think this is an underused feature of html as it makes navigation much better and faster, plus it is much easier to link into a page at just the right point with something like this.
When using XHTML you should not use the name attribute as it has been deprecated. Instead you should use the handy id attribute. The id attribute will work exactly the same way and has the benefit of being compliant. Plus you get additional validation of making sure each element has a distinct id. This was a problem with some sites I’ve seen that use name. I see the same name used all over the place. This makes linking to the element somewhat difficult and error prone.
On a related note, did you know that most modern browsers can link directly to any element that has a valid id attribute? This is very handy as you want have to include anchor tags all over you html just to get convenient linking.
Bad: Test
Better: Test
Best: <p id="bookmarkid">the element i actually want bookmarked can be linked to directly</p>
Comments [0]
Here is an easy article on setting up multiple machines for Remote Desktop access.
Check out the article for a lot more info.
Comments [0]
IF (SELECT is_broker_enabled
FROM sys.databases
WHERE database_id = DB_ID()) = 0
ALTER DATABASE yourdatabasenamehere
SET ENABLE_BROKER
WITH ROLLBACK IMMEDIATE
The if statement checks to see if the broker is already running. If it is not then it attempts to enable it. The WITH statement will rollback any other pending transactions that may be blocking this transactions. This is important because if you run this statement without WITH ROLLBACK IMMEDIATE then it may seem that the batch will not complete. Again, this is because other transactions or services like SQL Server Agent may be blocking.
Comments [0]
One argument script pimps use frequently is that it doesn’t matter what tools a contractor uses to build a house as long as the finished product is the same.
The problem with this argument is that the premise and the analogy are flawed. Comparing the language to the tools is not quite accurate. The language is more aptly compared to the building materials used instead of the tools. The tools would instead include things like the IDE. With the analogy corrected we now see that the choice of building material is very important. Using 2x4's instead 2x6's will have a big impact on insulation properties (thicker wall cavities) and cost.
Is this important? Absolutely!
Unfortunately, too many scripting language fans (script pimps) make the same
flawed analogy in order to justify the use of their pet language instead of a
higher performance language like C++ (or C#, Java, etc). Scripting
languages like Ruby are slower then compiled languages. Also their nature precludes them from having
good IDE support. This is because much
of the meaning (context) can’t be derived until runtime so things like IntelliSense
become difficult if not impossible to implement.
Following the scripter’s analysis we are supposed to assume that scripting languages allow faster construction which I would say is another falsehood. Yes, some contractors might be able to cut wood just as fast with a handsaw but most want to use as much automation as possible. Hence, table saws, compound miter saws with laser guides, etc. These automation tools are closer to Visual Studio than VIM.
In my experience with Ruby (among other languages) I found
that the resulting programs were usually slower, which a scripting language
will be by its nature. I also found that
the emperor wears no clothes!
Shockingly, developing in a scripting language is slower because of the
lack of automation tools. Example, try
to find all references to variable in a Ruby on Rails project. Now try the same thing in a C# project using
Visual Studio. In Visual Studio it’s a
right click and “Find All References”.
In VIM you could search for the references but you don’t have any
support for context. You don’t know that
is the only reference to that variable.
You are using a handsaw instead of the best tools available.
I'm sorry but reality demands that 1 = 1 and slower is slower and speed is
important.
Comments [0]
So armed with this new knowledge I went in search of some pre-shrunk versions of the Prototype and Scriptaculous JavaScript Libraries. This is what I found. I still need to test the library but it seems promising. I will keep you posted.
Comments [0]
If you followed the standard progression you probably started with this MSDN article on URL Rewriting. This implementation works fairly well in ASP.NET 1.x. However, I've run into problems using this implementation in ASP.NET 2.0 with output caching. For some reason it breaks output caching.
So what is the solution?
Well I'm glad you asked. I've found a solution that works quite well with ASP.NET 2.0 and output caching. The UrlRewritingNet.UrlRewrite assembly provides all the features of the original URL Rewriter mentioned above but also fixes the problems with output caching plus adds some interesting features like redirecting and programmatic access to the rewrite rules at runtime (say that ten times fast!).
I'm currently using this on http://www.whatsyour20.com and I must say it works quite well. I also like the fact that it is an active project and it even has a bug tracker system. There is also a forum for this project. That's always a good sign.
Enjoy!
Comments [0]
You get HttpCompress from www.blowery.org/code/httpcompressionmodule.html. This is a module that sits inline and handles compression of your .aspx pages and any other mime type that may be handled by ASP.NET. This is a pretty good work around if you don't have permission to IIS to enable HTTP Compression there. Of course that would be a better solution but many hosters won't enable it because of the possible CPU consumption issues. Oh well, get around them by implementing your own solution!
I know dasBlog uses it in the 1.9.x version. WhatsYour20.com is also using it at this time.
It's been around for awhile, it's configurable and it's easy to use.
Give it a try and speed up your site today!
One caveat is testing it using ASP.NET Development Server. Check out the link for more info.
Comments [0]
This video suggests we are being overrun by immigrants and that our population will sky rocket because of their birth rates.
Now I’m somewhat of the opinion that more people are better because you have more innovation etc, but I also believe we are experiencing some problems from this mass human migration.
I wonder if the pressure on the bottom end of the housing market is driving up prices and that the huge number of new laborers in the job market is keeping wages stagnant. So we will experience higher costs from housing and other sources as we compete for scarcer resources (oil, natural gas, land) while having less money in real terms.
As a Libertarian where do I stand on this? As I stated previously I think more people can spur innovation and can be a boon to the economy. This of course assumes that new immigrants don't require many services from the government which unfortunetaly is not the case in our socialist country. We provide many services to these people and their dependants. So in a free society law abiding people should be able to come and go as they see fit. However when these people expect/require services and violate the law to get here, by definition I have a problem with that.I have no problem with admitting an unlimited number of PhD's into this country for instance. I have a slight problem though admitting an unlimited number of gardeners and meat cutters that will require my assistance because the Left in this country has decided to use the police power of the state to ensure my money can be forcefully taken from me and restributed to the "poor" (poorer then whom?) and "those less fortunate" (less fortunante the whom?).
So because many of these people will be entitled to the wealth of the current citizens I don't believe the pure Libertarian argument would apply in this situation.
Here is the link, hang in there the beginning is slow but the visuals are worth it ( kind of like an acid trip ;) ):
Visual Demonstration of Immigration to the US
Comments [0]
In your web.config you should add an exclude statement to exclude the WebResource.axd path:
<httpCompress preferredAlgorithm="gzip" compressionLevel="high">
<excludedMimeTypes>
<add type="image/jpeg" />
<add type="image/gif" />
<add type="image/png" />
</excludedMimeTypes>
<excludedPaths>
<add path="WebResource.axd"/>
</excludedPaths>
</httpCompress>
Comments [0]
