If you are receiving this error:
The Web application at <URL> could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

Are you having problems with Facebook games on Facebook using IE9 or Firefox 4? Another solution…

So I figured something out recently, if you need the hardware acceleration turned on (I have to admit it is a nice thing to have) in your web browser, the problem might be related to your graphics driver. Most laptops today use the Intel graphics drivers. Go to http://downloadcenter.intel.com/ to download the latest drivers (Microsoft’s Windows Update is a little behind on this) then follow the on-screen installation steps. If you are unsure which drivers you have on your system they have a utility that can help you, simply go to http://www.intel.com/p/en_US/support/detect.

If this is not the case for you I recommend going to my previous post, which is still very useful if you are not using an Intel chipset.

Upsizing Access Databases to SQL Server?

If you are like me you have had one or two very small Access databases that have grown and need SQL Server’s power. Naturally you run the upsizing wizard and move over all your tables. This allows you to keep the Access fron-end and have a rip-roaring SQL Server in the back-end. Here are a couple things to look out for:

Careful with the Switchboard

Migrating the switchboard table over to SQL Server is a good idea if you want have many people using the Access database front-end. If you can figure out the switchboard table, you can modify your switchboard using this table.

If you migrate the switchboard table to SQL Server, you can no longer use the Switchboard Manager

To get around this issue, you have have to modify the table directly.

Timestamps: Problems Updating Data

Be sure that you include a timestamp on your tables, Access needs these if it is going to make some DML changes to your data. I believe although couldn’t find verification that it uses timestamps on the tables as a locking mechanism and reduces contention.

New Problem, Indexes

Primary keys do not come over appropriately. They come over as unique non-clustered indexes, not clustered. This means your data can be stored out of order on disk, which is very inefficient for larger tables. Delete these indexes and create primary keys for them!

Lastly, any changes made to indexes (creating, altering, dropping) will need the Access front end to be updated. Be sure to refresh your linked tables in the linked table manager.

Are you having problems with Facebook games on Facebook using IE9 or Firefox 4?

Here is what I found. These guys (Microsoft and Mozilla) got something right in their browsers; giving the browsers direct access to the graphics card.

So this is really good most of the time, pages will act more responsive.

And now…

Adobe has to get with it, Flash games aren’t displaying properly with the new browsers.

The solution in IE9 is to go into Internet Options (click on the gear icon on the right side of the window) > Advanced Tab. Then check the tab the Graphics Acceleration option to use software rendering.

In Firefox 4, go into Options > Advanced > General tab. Then uncheck the “Use hardware acceleration when available” box.

These solutions will allow the games to work a little better, but general web pages might not be as responsive.

SQL Server DAC (Dedicated Administrator Connection)

Have you ever had a query go rogue? CPU at pegged at 100%? This will help!

Note: This is only for SQL Server 2005 and later…

There is some groundwork to do.

Setting up the DAC

Run these statements as an administrator:

sp_configure'remote admin connections',1
GORECONFIGUREGO

This will enable the ability to connect to the server.

Using DAC When IT Matters!

You can do two things use sqlcmd to connect to the SQL Server or a query window (not the Object Browser). The trick is before the name of the server prefix the name of the server with admin:.

Example:

admin:servername

A note of interest, you are limited by what you can do in this mode. Nothing that needs to store temporary tables and things like that. You can even use this if you do something terrible like corrupt the master or tempdb databases.