This is for anything related to the site.
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. ...
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 SQLTeam.com username and password. So I had to make SQLTeam.com an OpenID provider. When you get to the main login screen just enter “http://openid.sqlteam.com” in the text box. After clicking the Login button you’ll be taken to the SQLTeam OpenID page. Here...
I stared SQLTeam.com 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 http://stackoverflow.com with interest. It has a couple...
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.
I wanted to congratulate Derek Comingore on being named an MVP. He's a regular blogger here on SQLTeam.com on Business Intelligence topics. It's great to see community participation acknowledged by Microsoft.
If you're reading this post on the actual SQLTeam.com 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,...
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...
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.
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.
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.
Test. Yes, another infamous test post.
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.
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?
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!
I deleted about 300 spam messages today. It also updated post counts. What a pain.
Last year Joel (of JoelOnSoftware.com) 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...