THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL » sqlpass   (RSS)
Showing page 2 of 3 (27 total posts)
  • SQL Server MVP Deep Dives Vol 2 – get my chapter free

    Yes, the SQL book I was involved in two years ago has a sequel. In the first book, I wrote chapters 7 and 40, and was one of 53 MVPs that contributed. And the proceeds went to War Child. Yes, none of the MVPs who wrote, edited, etc, got any royalties – that all went to charity. This time, I wrote just one chapter (chapter 2), but there have been ...
    Posted to Rob Farley (Weblog) by rob_farley on September 29, 2011
  • More free training from PASS

    Yeah, alright. I know PASS puts on heaps of free training all the time. There are meetings around the world all the time, as held by hundreds of chapters. Seriously, there’s over 240 chapters in the world. If you figure that they typically have a 2 hour meeting once a month, that makes over 480 hours of training per month. That’s an average over ...
    Posted to Rob Farley (Weblog) by rob_farley on August 31, 2011
  • New PASS Summit speakers that deserve votes

    I’m not going to ask you to vote for the abstracts that I submitted for the PASS Summit. I’m not even going to mention the abstracts that Roger and Ashley submitted. I figure if you’re reading this, you may have already read the post I wrote about them, back before SQLPASS had said that there’d be voting. Instead, I’m going to pick a few people ...
    Posted to Rob Farley (Weblog) by rob_farley on May 18, 2011
  • LobsterPot submissions for SQLPASS

    My guys are great! When PASS started accepting abstract submissions for their Summit (in October this year), some of the LobsterPot employees immediately started looking into ideas for talks they could do. We rate communication as one of our key values at LobsterPot, and all my staff are keen presenters. Roger Noble was at the PASS Summit ...
    Posted to Rob Farley (Weblog) by rob_farley on May 6, 2011
  • Using SQL Execution Plans to discover the Swedish alphabet

    SQL Server is quite remarkable in a bunch of ways. In this post, I’m using the way that the Query Optimizer handles LIKE to keep it SARGable, the Execution Plans that result, Collations, and PowerShell to come up with the Swedish alphabet. SARGability is the ability to seek for items in an index according to a particular set of criteria. If you ...
    Posted to Rob Farley (Weblog) by rob_farley on January 3, 2011
  • Visualising data a different way with Pivot collections

    Roger’s been doing a great job extending PivotViewer recently, and you can find the list of LobsterPot pivots at http://pivot.lobsterpot.com.au Many months back, the TED Talk that Gary Flake did about Pivot caught my imagination, and I did some research into it. At the time, most of what we did with Pivot was geared towards what we could do for ...
    Posted to Rob Farley (Weblog) by rob_farley on December 28, 2010
  • My Lightning Talk in MP3 format

    Download it now via http://bit.ly/RFCollation  Lots of people tell me they wish they’d heard my Lightning Talk from the PASS Summit. This was the one that was five minutes, in which I explained Collation using examples comparing US English, UK English and Australian English. At the end, I showed my Arsenal thongs. You can see a picture of ...
    Posted to Rob Farley (Weblog) by rob_farley on December 23, 2010
  • Collation errors in business

    At the PASS Summit last month, I did a set (Lightning Talk) about collation, and in particular, the difference between the “English” spoken by people from the US, Australia and the UK. One of the examples I gave was that in the US drivers might stop for gas, whereas in Australia, they just open the window a little. This is what’s known as a ...
    Posted to Rob Farley (Weblog) by rob_farley on December 13, 2010
  • The Incredible Shrinking Execution Plan script

    I just got out of my SQLPASS session, and have uploaded the script from that to the LobsterPot site. The following link should get you there: http://www.lobsterpot.com.au/sqlpass_IncredibleShrinkingExecutionPlan.txt I’ve uploaded it as plain text, to make life easier for my host. Enjoy!
    Posted to Rob Farley (Weblog) by rob_farley on November 10, 2010
  • In my presentation

    So I’m in the middle of a presentation at SQLPASS, and thought I’d just write a blogpost. (Here’s the key – it’s the Zoom function) My session is on the Incredible Shrinking Execution Plan, and the basic idea behind it is to demonstrate stuff that the Query Optimizer can do to avoid work. It’s much like some of the people I’ve worked with over ...
    Posted to Rob Farley (Weblog) by rob_farley on November 10, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement