posts - 230, comments - 423, trackbacks - 27

My Links



Follow billgraziano on Twitter

Article Categories


Post Categories


SQL Server

Site Related

This is for anything related to the site.
Almost a week with Ask SQLTeam

I launched the updated Ask SQLTeam almost a week ago and I’ve noticed a few interesting things. First, a big thank you to the people answering questions.  As people answer questions and their answers are voted up they get “reputation”.  Right now the top 3 users in terms of reputation are mrdenny, Kristen and TG.  Overall 27 people have earned the “Teacher” badge.  That means they’ve answered at least one question that someone else voted up.  Anyone that has earned 15 “reputation points” can vote up answers.  When your answer is voted up you get 10 reputation points. ...

posted @ Tuesday, October 13, 2009 7:42 AM | Feedback (1) | Filed Under [ Site Related ]

Logging into Ask SQLTeam using your forum account

Last week we launched Ask SQLTeam as an alternative to our forums.  One of the interesting features of the site is that it uses OpenID as a login mechanism.  Google and Yahoo both support OpenID and you can use them to login.  What I really wanted was a way to login using a username and password.  So I had to make an OpenID provider. When you get to the main login screen just enter “” in the text box. After clicking the Login button you’ll be taken to the SQLTeam OpenID page.  Here...

posted @ Tuesday, October 13, 2009 6:52 AM | Feedback (1) | Filed Under [ Site Related ]

Announcing the return of Ask SQLTeam

I stared nearly ten years ago.  I wanted to build a place where people could learn about SQL Server.  In the early days we had something called "Ask SQLTeam".  People could submit questions and we'd use those to get ideas for articles.  We tried to answer as many as we could on the site.  Gradually the flood of questions became too much and that changed into the forums you see on the site today. Today we're bringing Ask SQLTeam back.  But in a different way. I've watched the success of with interest.  It has a couple...

posted @ Wednesday, October 07, 2009 10:27 AM | Feedback (2) | Filed Under [ Site Related ]

My apologies for the broken newsletter links

I use a custom application to generate the SQLTeam newsletter each week.  It pulls out the blog posts I’ve flagged during the week and some recent forum posts.  This week I was in the process of making some updates to the software and so I used my shiny new beta code.  And in the process I broke all the links to the newsletter posts.  My apologies.  I’ll get it right next week.

posted @ Tuesday, September 29, 2009 12:26 PM | Feedback (0) | Filed Under [ Site Related ]

Congratulations Derek

I wanted to congratulate Derek Comingore on being named an MVP.  He's a regular blogger here on on Business Intelligence topics.  It's great to see community participation acknowledged by Microsoft.

posted @ Thursday, October 02, 2008 7:48 AM | Feedback (1) | Filed Under [ Miscellaneous Site Related ]

Crossing a Threshold

If you're reading this post on the actual Weblogs homepage you'll notice that the count of posts now says 1,000.  I'm happy to say that 90% of those posts have come from other people.  Three weeks from now is the four year anniversary of starting these blogs.  My goal in starting this group blog was to give smart people a place to say interesting things.  We certainly have smart people and they do say interesting things. So a great big thanks to Mark, Mladen, Jeff, Tara, Brett, David, Damian, Chris, Davide, Travis, Derrick, Rob, Randy, Jon,...

posted @ Wednesday, September 05, 2007 12:49 PM | Feedback (2) | Filed Under [ Site Related ]

Blog at SQLTeam = Earn some cash

If you visit the blogs of Jeff Smith and Mladen Prajdić you'll notice they are now running the same ads as the main site.  They were both running generic Google ads prior to this.  We were able to tweak a SubText skin in order to pull ads from my ad server.  The biggest benefit is that their revenue more than tripled and their ads are better targeted at their readers.  If you're a blogger here on the site please contact me if you're interested.  You do need  a certain minimum level of traffic and you need to be posting regularly.  In order...

posted @ Wednesday, August 08, 2007 7:04 AM | Feedback (0) | Filed Under [ Site Related ]

Blog Updates

I finally updated the software on this site to the latest SubText build.  That has better software to prevent spam.  I also updated the CAPTCHA to be case-insensitive and deleted over 40,000 pieces of spam from our comments.  I still have a little ways to go on the spam removal.  That will happen over the next few days.

posted @ Saturday, January 27, 2007 5:17 PM | Feedback (1) | Filed Under [ Site Related ]

Weblog Software Upgraded

I've upgraded the weblog software on the site to SubText.  All the feeds should stay the same.  Most of the blogs will look nicer once the posters choose a new skin.  We should also see less spam on the site.  Please let me know if you find anything broken.

posted @ Friday, September 15, 2006 8:16 PM | Feedback (15) | Filed Under [ Site Related ]

Stupid Spammers

And in this case it's stupid in terms of not smart instead of people I don't like. Although I still don't like them. Adding the CAPTCHA test to the comment page has greatly reduced the amount of spam the blogs receive. Now these morons are filling out the other form on my blog and posting spam that way. Unfortunately that's my "Contact Me" page. So instead of posting comment spam they're sending me an email. Morons.

posted @ Saturday, November 19, 2005 9:59 AM | Feedback (1) | Filed Under [ Site Related ]


Test.  Yes, another infamous test post.

posted @ Friday, November 18, 2005 2:53 PM | Feedback (1) | Filed Under [ Site Related ]

Blog Errors (Updated)

The blogs are throwing errors when you try to view an individual post.  I'm working on it and I'll have more information once I figure out what's going on.  UPDATE:  I saved the web.config file to the web site.  That apparently caused the app to reset itself just enough to fix the problem.  I also change QUEUESTATS to false in .TEXT's web config.   I'm told that should prevent the problem in the future.  Thanks to Andrew Connell for both of those suggestions.

posted @ Monday, November 14, 2005 10:58 AM | Feedback (1) | Filed Under [ Site Related ]

Spam still sucks

This just amazes me.  I just deleted over 1,000 spam posts from the various comments.  Are these being manually entered?  Are these people that stupid?

posted @ Sunday, July 24, 2005 8:04 PM | Feedback (3) | Filed Under [ Site Related ]

Anti-Spam Measures

I've finally put up a CAPTCHA test for comment posting.  This should reduce the amount of comment spam we've been getting.  All the credit goes to Davide Mauri for creating a detailed list of instructions for implementing this in .TEXT.  You can find the details on his other blog.  Previously I had restricted comments on posts older than 30 days.  I've removed that restriction.  Please let me know if there are any problems or if something doesn't look quite right. I want to add that this uses a great HIP control by Kevin Gearing. Thanks Kevin!

posted @ Monday, May 30, 2005 9:45 AM | Feedback (10) | Filed Under [ Site Related ]

Spam Cleanup

I deleted about 300 spam messages today.  It also updated post counts.  What a pain.

posted @ Sunday, May 08, 2005 2:13 PM | Feedback (2) | Filed Under [ Site Related ]

Making Sense of MSDN

Last year Joel (of wrote an article that had a little blurb on the “MSDN Way” of doing things.  That basically amounted to always using the newest, fanciest tools to solve a problem.  Why use VB6 and SQL Server when you can use C#, SharePoint, BizTalk, XML, Web Services and SQL Server to accomplish the exact same thing.  I chuckled at that but basically agreed with his characterization of MSDN.  I'm still a big fan of the magazine though.  Tomorrow's C#, SharePoint, etc. is today's VB6 and SQL Server.  It's a great place to get a handle on what's...

posted @ Thursday, May 05, 2005 12:21 AM | Feedback (5) | Filed Under [ SQL Server Stuff Site Related ]

Powered by:
Powered By Subtext Powered By ASP.NET