Browse by Tags

• 24hop
• collation
• community
• indexing
• lobsterpot
• partner network
• pivotviewer
• powershell
• sql
• sqlpass
• t-sql tuesday

• 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: 24hop, community, sql, sqlbits, sqlpass

• 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: collation, indexing, powershell, sql, sqlbits, sqlpass

• 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: lobsterpot, pivotviewer, sql, sqlbits, sqlpass

• SARGability isn’t about the left-hand side

  This month’s T-SQL Tuesday has me caught slightly unawares. I’m in the UK, having come over for SQLBits , and I’m left writing this with only a few hours to go. The theme this time is on misconceptions in SQL, and this fits nicely with SARGability – one Read More... Posted Wednesday, October 13, 2010 10:10 AM by Rob Farley | 0 Comments Filed under: indexing, sql, sqlbits, t-sql tuesday

• Time away from a growing company

  At LobsterPot , I’m very blessed to have excellent staff working for me. Someone asked me just today why we haven’t grown more than we have in the past year, but in just over a year I’ve brought on 3 staff members and have another one starting next month. Read More... Posted Tuesday, September 21, 2010 3:14 PM by Rob Farley | 1 Comments Filed under: lobsterpot, partner network, sqlbits

• 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

• Something for everyone at the SQLBits Training Day

  Of course, the one not to miss is the one I’m doing, on Fixing Queries with Advanced T-SQL Techniques , but actually, they’re all excellent. For example, Simon’s just blogged that Buck Woody’s seminar topic has changed . Instead of being on career development, Read More... Posted Friday, September 03, 2010 5:03 PM by Rob Farley | 1 Comments Filed under: community, sql, sqlbits

• Q&A about my SQLBits precon

  I received an email from someone who’s trying to decide whether or not to register for my precon at SQLBits 7 next month. He’s already coming to the event (which should be a given for anyone who can make it), but he was trying to work out a few things Read More... Posted Wednesday, September 01, 2010 12:42 AM by Rob Farley | 0 Comments Filed under: sql, sqlbits

• SQLBits pre-con – Fixing Queries with Advanced T-SQL

  I’m giving a pre-con seminar at SQLBits 7 on September 30 this year in York (the Old one, in Yorkshire – similar to the New one, but with different songs ). Let me quickly explain a few things about it – to help you persuade your boss to let you attend Read More... Posted Wednesday, July 28, 2010 11:50 PM by Rob Farley | 0 Comments Filed under: community, sql, sqlbits