SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

A Bad Report Card

By Steve Jones, 2008/03/24

Total article views: 48 | Views in the last 30 days: 1

I always looked forward to report cards as a kid, seeing them as validation that I'd accepted the challenge of doing well in school. It helps that I enjoyed school and learning in general and if it had paid better, I'd have stayed in college forever :)

Now I'm in the database world and while I have regular reviews from an employer, it's not the same. However it is a report and I have almost always gotten positive ones in my career. And apparently I'm doing better than the FCC. In the linked article, the US GAO has issued a report on the FCC (another government department), criticizing their data management and controls, saying it's unable to even determine what is wrong. As you might expect, the FCC says the report is based on old information and they've made changes.

But how would any of you like to get a report like this about your performance in the data world?

I'm actually not sure what to make of this. The report doesn't say that the FCC as an organization is doing a bad job, but rather that there isn't enough information collected, or properly collected to determine if work is being done properly. It's a similar complaint that I hear about Connect in that comments aren't always being properly used when items are closed.

It seems that a lot of what the FCC isn't doing is properly controlling and using their data. There aren't the feedback looks, checks, reports, and other tools in place that allow this organization to determine how well they are meeting their goals.

In other words, I think they're missing some Business Intelligence type reporting and alerting that would analyze the data.

I'm haven't been a proponent of the BI-hype, mostly because I think it's difficult, especially when I see many DBAs struggling with the simpler database engine, it's expensive (even though it's cheaper with SQL Server), and it requires a long term investment. My feeling is that most companies with a quarter-to-quarter or yearly view will struggle with a multi-year BI system investment.

However in this case, with profitability not an issue, a long term mission, and the need to be accountable for their actions, a strong BI solution would be a great asset to this, and many other, governmental institutions. Hopefully the FCC is working on this and the next time I hear about them it will be a success story in achieveing their goals.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.podshow.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

By Steve Jones, 2008/03/24

Total article views: 48 | Views in the last 30 days: 1
Your response
 
 
Related Articles
BLOG

Chad Miller - Powerscripting Podcast 2

I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcas...

FORUM

Information about reports ran

Information about reports ran

SCRIPT

Listing Subscribed SSRS Reports including Parameters & their Values

This script will allow user to analysis their Subscribed Reports.

BLOG

SQL Musings - Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...

BLOG

SQL Musings - Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

Tags
editorial    
 
Contribute

Free registration required...

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Login (existing users)

Login

Email:   Password:   Remember me: Forgotten your password?

Register (new users)

Register

Email:   Password:
Confirm:

Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com