The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,880 other followers

Archive for September 7th, 2010

SQL Server: Google search tip for MSDN

Posted by jpluimers on 2010/09/07

When searching on MSDN for SQL Server syntax related things, you often get results matching other languages or frameworks.

For instance, searching for INSERT site:msdn.microsoft.com gets other results having to do with the .NET Framework. Those usually are not relevant to SQL Server.

Google search can be tweaked to limit your search results: there is a nice Google search help page on this.
The above search phrase already includes a the site: prefix to limit the results to the msdn.microsoft.com domain.

There are a few tricks to limit the search phrase even further:

  1. Add “SQL Server” to your search phrase:
    “SQL Server” INSERT site:msdn.microsoft.com
    Microsoft always had the “SQL Server” in their Books Online topics.
    This way, you will find SQL Server 2000 and SQL Server Compact Edition information now as well as more current SQL Server versions.
  2. Add “Transact-SQL” to your search phrase:
    “Transact-SQL” INSERT site:msdn.microsoft.com
    Microsoft started to suffix SQL Server T-SQL keywords with “(Transact-SQL)” for the Books Online in November 2008 (covering SQL Server 2005) to make finding results easier.
    This way you will favour topics for SQL Server 2005 and up.

Luckily the MSDN site has done a lot of SEO, so even if you don’t add these two to your search phrase, SQL Server relevant results end up pretty high in the result list.
They strive to get the SQL Server 2008 R2 Books Online topics as high in the ranking as possible.

If you want to search for specific versions of SQL Server, then it is easiest to use this Microsoft SQL Server Library page to begin your search.

Conclusion:

Depending on what kind of search results you are interested in, you might want to extend your search phrase a bit.

–jeroen

Posted in Database Development, Development, Google, Power User, SQL Server | Leave a Comment »

 
%d bloggers like this: