Tuesday, September 28, 2010

Sql Stripes 2010

Going through my LinkedIn updates, I noticed that a former colleague of mine updated his profile, so I jumped in to check it out, and saw that in addition to the minor update - he added at some point in the past that he developed an new  SQL Server management tool.

Thinking back, I remembered that he was always into developing these types of tools, and that he always had a touch for GUI (being a DBA that is not a given :-( ), so I jumped right in and downloaded the tool from his website http://www.sqlstripes.com (fully functional version).

I have quite a few SQL Server databases that I need to manage/monitor on a regular basis, some are production some are dev/qa and all need to be monitored (especially the Dev ones) to see problems as they occur, usually I would connect via Remote Desktop and look at the activity monitor... In the past and also currently I have been reviewing monitoring tools by red gate and others, but they all work on an event concept (i.e. when a configured situation happens we will send you a notification) - and that always seemed not enough (although powerful and helpful).

This tool is something else, yes it can send alerts (and apparently even speak them out, though I suspect this feature isn't much used, although in a NOC scenario it has a potential). Here everything is graphical, green and red lights, numbers, pie charts and more - you can actually see the state of the server or database, all in one screen (for as many servers/databases as you'd like). The information displayed is the stuff you need... Not only that, but to collect this data by yourself you'd need to go through multiple scripts and remember tons of commands - and then parse out the useful data - this tool does this for you, and nicely.

A sample screen shot
Just a quick (and not complete) list of nice data you get with this:
Per server: status (green/red) of Ping, Agent,Jobs,Service,Locks, Memory, diskspace, cpu, OS, SQL Server version...
Per Database: Sizes, quick log trunacate, object counts
Quick view of job list, failed jobs

So, I just downloaded and started playing with it today, I haven't checked for "bad things" such as faulty data or unwanted load on the servers (in short how good this really is). Just to clarify, this review wasn't invited, just a spur of the moment - since I saw it and decided to give it a go. 

The price is not cheap, but when I consider medium/large organizations or even small if you have more than 5 servers to manage, this tools can save a lot of man hours wasted on connecting/disconnecting to servers all day to check what's going on - gives you a live monitor of the system (like a pulse monitor)

Adi, if you read this - good job! 

Mini Measure Shot Glass

One of other hobbies is the kitchen, cooking, baking, whatever and like all geeks I love gadgets! however in the kitchen my focus is usable gadgets and not toys - so this is one I am going to have soon!

Kolder Original Mini Measure, Multi-Purpose Measuring Glass

The measuring shot glass or in another even cuter version

I like it because it doesn't take a lot of space, and replaces the standard measuring spoon set you usually have in one tool (and I can buy several for not mixing wet and dry ingredients). Another use for this is giving children medicine - in their own neat glass (instead of forcing a spoon down their throat).

Original Via: Cool Tools, found the other while searching for a cheaper version

Sunday, September 5, 2010

MongoDB is Web Scale

This is way funny not to share with you, obviously highly geek content, and web developer geek content at that - I loved it. Reminded me of some people I'd rather not know... but I do.