We have a development server that was initially setup with SQL Server 2008 SP2 Standard Edition. Is it possible to upgrade that edition to 2008 R2 Developer Edition so we can play with the extra features in Developer Edition?
I have multiple sites setup on IIS 6 with host headers. One of those sites has an SSL certificate installed. So now if any of the non-SSL-enabled sites is requested with HTTPS it loads the SSL-enabled site and gives a security warning.
How can I prevent the non-SSL sites from loading anything if they are requested with https? I would prefer it to throw the standard "Server not found" message. Is that possible?
I see lots of information about enabling http compression for server responses but what about for incoming requests. Wouldn't it make sense for the browsers to compress large form posts before sending them to the server?
Another example is a REST web service that we use. We have to send frequent PUT requests with large XML files (10+ MB) and would definitely see some bandwidth/speed benefits on both sides.
So is this a solved problem on the server side or does each web application have to handle it individually?
I'm a programmer/DBA by accident and we're running SQL Server 2005 with Performance Dashboard for basic monitoring. The server has been up for a few weeks and now we can't drill into certain reports. Is there any way to reset these reports without a complete reboot?
edit: I bet the error message would help.
I get this when I drill into the CPU graph: Error: Difference of two datetime columns caused overflow at runtime.