The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

    • RT @AndSimonSaid: Mijn baas werkt thuis en vraagt me haastig via whatsapp dat ik haar om drie uur moet bellen. Lijkt best serieus dus om dr… 2 hours ago
    • RT @samgerrits: Precies een jaar geleden trok ik aan de bel om een ernstig besmettelijke SARS variant die ik "SARS 2.0" noemde. Om politiek… 2 hours ago
    • @CBoonacker Ik had een minder loodzwaar traject toegewenst. Kennelijk niet gelukt. Daarom veel sterkte. 2 hours ago
    • RT @locuta: Navalny is naar de gevangenis gestuurd waar eerder Magnitsky door de Russische overheid werd vermoord. Hij moet daar 30 dagen b… 2 hours ago
    • RT @claudiadebreij: Dit is zoooo South Park 🤪 ‘Just wanna let you guys know, this is THE sacredest place.’ 2 hours ago
  • My Flickr Stream

  • Pages

  • All categories

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

    Join 2,229 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: