SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Idera SQL Check

Creating an SMO Dashboard - Part 1

Tim Mitchell shows us how to build a basic web based dashboard that returns some useful information about our servers and databases using SMO (SQL Management Objects) and a bit of .net code. Part 2 is available for viewing as well

Duration:
3 mins 11 secs
Skill Level:
200
Rating:
4.23 out of 5
Publish Date:
September 09, 2008
Creating an SMO Dashboard - Part 1 You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Tim Mitchell
Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.

References



Comments
MattP on 4/8/2009
Volume was very low and difficult to hear, without turning up PC volume to max.

Mark Weichman on 4/8/2009
would like to see more sessions on things to do with SMO...starting from the basics

Ahmad Elayyan on 4/8/2009
excellent !!!! 100%. i loved this demo.

Brian K McDonald on 4/8/2009
I figured there would be gauge's, charts, graph's, images, etc. to show some of the metrics. Don't most dashboards have some of these?

Don Weigend on 4/8/2009
The volumn of this video was very low making it hard to hear. Most of your videos have a good volumn level but it would be nice if the volumn could be regulated somehow so this problem doesn't come up again.

Carla Wilson on 4/8/2009
Very nice. Just starting to learn about SMO. Any chance that for some of these videos, the code could be offered from a link on the video's page?

Holck on 4/8/2009
When you said Dashboard, I was expecting something prettier. Basically you gave a lesson in ADO.NET. I'd at least expect charts or, even if you didn't build them in the video, some examples of what you can do with SMO Dashboards.

7727CACFEB on 4/8/2009
nice, excellent tutorial.

Lance on 4/9/2009
Not enough background was discussed first

Ludwig on 4/18/2009
good job...

01EFFB45CF on 8/29/2009
Great start in SMO. I am a newb to SMO.

Raghu ram on 12/2/2009
Great help to explore

Steve Harrell on 4/19/2011
I've noticed in the entire series Tim doesn't show the necessary includes or using statements. In most cases, it's not hard to figure out but for example working with Agent jobs, you need an additional using statement. For DBAs not familiar with writing C#, that extra info could save quite a bit of time!

Tom Graves on 8/5/2011
I don't see a video on installing or setting up the SMO references. Visual Studio 2010 defaults to filter out all but the .NET 4 libraries, and I haven't been able to find where the smo dll is supposed to come from. A video on setting up the dll and references would certainly be helpful.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions