Browse by Tags

• community
• denali
• indexing
• sql
• sqlpass
• t-sql tuesday

• Data, Information and Knowledge

  Hopefully my connection is slightly better during today’s keynote than it was during yesterday’s, when “Live Blogging” didn’t really cut it. The PASS staff saw the problem and have resolved it (thanks guys!). Quentin Clark has jumped on stage to talk Read More... Posted Friday, October 14, 2011 4:50 AM by Rob Farley | 1 Comments Filed under: sql, community, sql improvements, sqlpass

• SQL + Hadoop news

  I’m at the PASS Summit, and announcements are coming out nice and fast. One of the big ones that has just been made is that SQL Server will work much more closely with Apache Hadoop. Amazing stuff, that I think helps people realise that Microsoft is very Read More... Posted Thursday, October 13, 2011 4:07 AM by Rob Farley | 1 Comments Filed under: sql, community, sql improvements, sqlpass

• Sometimes it’s the little things...

  The easiest way to convince someone to use SSMS 2008 over SSMS 2005 was to right-click on a results grid. They’d see “Copy with Headers” in the context menu and be sold immediately. I’d happily show them that they could configure this option in SSMS 2005, Read More... Posted Tuesday, August 30, 2011 11:10 PM by Rob Farley | 8 Comments Filed under: sql, sql improvements, denali

• Denali’s Management Studio for CTP3 playing nice with others (almost)

  Until recently, I’d only done stuff with Denali on a dedicated box. But this weekend, I took the plunge and installed SSMS on a machine that has older versions of SQL Server installed on it. You can download Denali from this link . I’ve only installed Read More... Posted Monday, August 29, 2011 6:40 PM by Rob Farley | 0 Comments Filed under: sql, sql improvements, denali

• My favourite feature of SQL 2008 R2

  Interestingly, my favourite new feature of SQL Server 2008 R2 isn’t any of the obvious things.  You may have read my recent posts about how much I like some of the new Reporting Services features, such as the map control. Or you may have seen my Read More... Posted Tuesday, June 08, 2010 12:09 PM by Rob Farley | 1 Comments Filed under: sql, t-sql tuesday, sql improvements

• SARGable functions in SQL Server

  (Reposted from my msmvps.com blog ) SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries. Incidentally – SARGable Read More... Posted Friday, January 22, 2010 3:51 PM by Rob Farley | 2 Comments Filed under: sql, indexing, sql improvements