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 » T-SQL Tuesday   (RSS)
Showing page 1 of 12 (112 total posts)
  • Will 2015 be a big year for the SQL community?

    In Australia, almost certainly yes. Australia recently saw two Azure data centres open, meaning that customers can now consider hosting data in Azure without worrying about it going overseas. Whether you’re considering SQL Database or having an Azure VM with SQL on it, the story has vastly improved here in Australia, and conversations will go ...
    Posted to Rob Farley (Weblog) by rob_farley on December 8, 2014
  • Learning through others

    This PASS Summit was a different experience for me – I wasn’t speaking. I’ve presented at three of the five PASS Summits I’ve been to, where the previous one I’d not spoken at was 2012, while I was a PASS Director (and had been told I shouldn’t submit talks – advice that I’d ignored in 2013). I have to admit that I really missed presenting, both ...
    Posted to Rob Farley (Weblog) by rob_farley on November 11, 2014
  • T-SQL Tuesday #59: My Hero!

    This month's edition of T-SQL Tuesday is being hosted by Tracy McKibben (T|B). I was challenged by Aaron Bertrand (T|B) to participate in this T-SQL Tuesday. I instantly knew what and who I wanted to write about, but my schedule being what it is prevented me from writing the blog entry until straight up at midnight. (Originally ...
    Posted to Kevin Kline (Weblog) by KKline on October 15, 2014
  • T-SQL Tuesday #56 : Assumptions

    This month's T-SQL Tuesday is about assumptions in SQL Server. Over on our new consolidated team blog at SQL Sentry, I discuss the following assumptions I come across with relative frequency: Case will always short circuit A seek is better than a scan, always A query without ORDER BY will always order by _________ SQL Server's defaults are ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 8, 2014
  • SSIS Lookup transformation in T-SQL

    There is no equivalent to the SSIS Lookup transformation in T-SQL – but there is a workaround if you’re careful. The big issue that you face is about the number of rows that you connect to in the Lookup. SQL Books Online (BOL) says: If there is no matching entry in the reference dataset, no join occurs. By default, the Lookup transformation ...
    Posted to Rob Farley (Weblog) by rob_farley on July 8, 2014
  • SQL 2014 does data the way developers want

    A post I’ve been meaning to write for a while, good that it fits with this month’s T-SQL Tuesday, hosted by Joey D’Antoni (@jdanton) Ever since I got into databases, I’ve been a fan. I studied Pure Maths at university (as well as Computer Science), and am very comfortable with Set Theory, which undergirds relational database concepts. But I’ve ...
    Posted to Rob Farley (Weblog) by rob_farley on June 9, 2014
  • When is your interview?

    Sometimes it’s tough to evaluate someone – to figure out if you think they’d be worth hiring. These days, since starting LobsterPot Solutions, I have my share of interviews, on both sides of the desk. Sometimes I’m checking out potential staff members; sometimes I’m persuading someone else to get us on board for a project. Regardless of who is on ...
    Posted to Rob Farley (Weblog) by rob_farley on May 12, 2014
  • Tricks in T-SQL and SSAS

    This past weekend saw the first SQL Saturday in Melbourne. Numbers were good – there were about 300 people registered, and the attendance rate seemed high (though I didn’t find out the actual numbers). Looking around during the keynote, I didn’t see many empty seats in the room, and I knew there were 300 seats, plus people continued to arrive as ...
    Posted to Rob Farley (Weblog) by rob_farley on April 7, 2014
  • Scans are better than Seeks. Really.

    There are quite a few reasons why an Index Scan is better than an Index Seek in the world of SQL Server. And yet we see lots of advice saying that Scans are bad and Seeks are good. Let’s explore why. Michael Swart (@MJSwart) is hosting T-SQL Tuesday this month, and wants people to argue against a popular opinion. Those who know me and have heard ...
    Posted to Rob Farley (Weblog) by rob_farley on March 11, 2014
  • Victims of success

    I feel like every database project has major decisions now, which are remarkably fundamental to the direction that’s going to be taken. And it’s almost as if new options appear with ever-increasing frequently. Consider a typical database project, involving a transactional system to support an application, with extracts into a data warehouse ...
    Posted to Rob Farley (Weblog) by rob_farley on February 10, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement