Browse by Tags

• 24hop
• collation
• community
• indexing
• lobsterpot
• pivotviewer
• powershell
• sql

• 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, Read More... Posted Thursday, May 19, 2011 3:35 PM by Rob Farley | 3 Comments Filed under: sql, community, sqlbits, sqlpass, 24hop

• 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 Read More... Posted Monday, January 03, 2011 4:54 PM by Rob Farley | 5 Comments Filed under: sql, indexing, powershell, sqlbits, sqlpass, collation

• 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 Read More... Posted Wednesday, December 29, 2010 1:50 PM by Rob Farley | 1 Comments Filed under: sql, sqlbits, sqlpass, lobsterpot, pivotviewer

• 24 Hours of PASS – sargability resources

  I just did a talk for 24 Hours of PASS on Sargability . I’ve done this talk before (about five months ago at the user group I run and at the PASS AppDev Virtual Chapter ). There are a number of useful resources out there about sargability. I’ve blogged Read More... Posted Friday, September 17, 2010 12:33 PM by Rob Farley | 0 Comments Filed under: sql, sqlbits, sqlpass