Drew Furgiuele shows how easy it is to create a dashboard widget in SQL Operations Studio:
Before we go on, now’s your chance to name your widget. In my code above, I highlighted some of the changes I made. Also notice that this widget has a path to the query file we created; if this file doesn’t exist (or you can’t read from the path it exists on), it’ll stop working. Just a heads-up.
I named it something meaningful (but hey, do you), and I changed the vertical and horizontal size of the widget to be a little easier to read. Once you’re done, it’s time to add your widget to the dashboard.
I think people are going to like this product once it matures a bit. This kind of flexibility without having to drop into .NET is great for DBAs for whom C# is a little intimidating.