Monthly Archives: July 2010

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 »

Share and Enjoy

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 »

Share and Enjoy

Category: SQL