Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Site Related Discussions
 Searching SQL Server sites

Author  Topic 

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2006-10-25 : 08:44:27
I've been playing around with Google's customized search feature. I've used it to build a tool to search certain SQL Server sites. Is this something worth linking to from the site? Are there other sites or blogs I should be searching? I'm considering removing the Microsoft sites and only searching community sites.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-25 : 08:53:22
hell yes!!!

sqlteam of course.
asp.net
sqlservercentral.com
sel-server-performance.com
codebetter.com
sqlblog.com
all sql server product team's blogs
http://blogs.conchango.com/default.aspx <- great SSIS resource
http://www.sqldts.com/
http://jasonhaley.com/blog/default.aspx <- has links but they're great

i'm sure there are more i'm forgetting



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2006-10-25 : 09:05:34
I've added a few of those sites. Some you listed were general programming sites. I added the SQL Server specific ones. I may build another one for developer focused searches. Keep posting sites you like!

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-10-25 : 09:36:49
How can I add this search as content on my custom google home page. I'll gladly give you the adsense revenue ...

Jay White
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-10-25 : 09:39:20
Some more ...

http://blogs.msdn.com/bartd/default.aspx
http://blogs.msdn.com/craigfr/default.aspx
http://blogs.msdn.com/khen1234/default.aspx
http://blogs.msdn.com/ianjo/default.aspx
http://www.sqlskills.com/

Jay White
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-25 : 10:05:55
here's a .net search engine
http://www.google.com/coop/cse?cx=014414512506709758688%3Alw8tquo75fu



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-10-25 : 10:27:18
How about having it search the SQL Server Books Online Sites?




CODO ERGO SUM
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-10-28 : 03:27:54


It should also pre-filter questions about formatting data and answer "Do this in your client application" ...
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-28 : 07:11:58
quote:
Originally posted by Kristen



It should also pre-filter questions about formatting data and answer "Do this in your client application" ...


Clever Idea

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-10-28 : 12:50:01
I think the sqlserver forum on dbforums would be worth adding:

http://www.dbforums.com/forumdisplay.php?f=7


SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-10-28 : 14:20:54
"Clever Idea"

Thanks, I nicked it from a mate of mine ...
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2006-10-28 : 14:59:05
I've cleaned this up a little and given it a new home.

http://mssqlsearch.cleardata.biz/default.htm
http://mssqlsearch.sqlteam.com/

Test it out and let me know what you think. If it looks interesting I'll include it in the main site.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-10-28 : 15:22:02
Blimey, even scrolls the SQLTeam pages to the right place ...

I searched for "xxyyzz" (well, "Bollocks" too, of course!)

Can you make it ignore POST.ASP pages? (which Snitz ought really to meta-tag as NOINDEX - another story that one, of course).

Example:

"I am setting up a new server and we need to migrate the sql server 2000 databases"

you need the quotes! the result:

http://www.sqlteam.com/Forums/post.asp?method=ReplyQuote&REPLY_ID=145097&TOPIC_ID=44537&FORUM_ID=6

is the type of thing I find annoying (the regular http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=44537 is found too, but often comes later in the listings IME)

Appending:

-inurl:"post.asp"

fixes this for a manual search, dunno if you can "hide" that within the COOP config?

I think there should be a more results per page - I favour more scrolling over paging - I reckon 50 / page would be OK, but certainly less that 20 or 25 seems to few per page - to me anyway.

Looks really good & useful; cheers Graz.

Kristen
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2006-10-28 : 15:42:03
Weird. POST.ASP is removed in robots.txt. I've removed it from the search results. Google actually required a case-sensitive URL to remove this. That makes no sense.

Right now there isn't a way to change the number of results per page.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2006-10-28 : 19:08:57
And it should be available at http://mssqlsearch.sqlteam.com/ by now.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-10-29 : 01:19:57
You planning to put it here:

http://www.sqlteam.com/search.asp

too? (or is it already reachable from SQLTEAM via a link that I'm too stupid to see? )

Kristen
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2006-10-29 : 10:08:02
I'm not sure yet. I may do something a little more site specific for that.

-Bill

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -