Category Archives: Computers

MongoDB and SSIS

Below is a very simple proof of concept that I’ve been batting around in my head awhile. There is much talk of the validity of MongoDB (http://mongodb.com) and even of it’s replacing SQL Server. I am in no way advocating this. MongoDB is great for some applications, but not a full ACID compliant database in… Read More »

Favorite SQL Server Tools

Built into 2008 is a nice little tool called Activity Monitor. If you have SSMS 2008 simply open it, right-click on the top level server name and select “Activity Monitor”. With Activity Monitor you can get real-time data on Processes, Wait Tasks, and I/O. A very handy and quick view of your SQL Server(s). Also,… Read More »

Category: SQL

Varnish Proxy

So one of the more interesting projects in my opinion is the Varnish Cache project (http://varnish.projects.linpro.no/). Now I know I’m supposed to be this pro-Microsoft guy now what with all the certs and working with it day in and out, but the budget crunch has hit us pretty hard. So, when the GIS guys needed… Read More »