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 » t-sql tuesday   (RSS)
Showing page 2 of 4 (40 total posts)
  • Cloud – the forecast is improving

    There is a lot of discussion about “the cloud”, and how that affects people’s data stories. Today the discussion enters the realm of T-SQL Tuesday, hosted this month by Jorge Segarra. Over the years, companies have invested a lot in making sure that their data is good, and I mean every aspect of it – the quality of it, the security of it, the ...
    Posted to Rob Farley (Weblog) by rob_farley on November 11, 2013
  • Not-so-dirty SQL hacks

    Using a hammer to push in a screw isn’t a good idea, no matter how good the hammer is. We all know that. and yet there are times when we get frustrated at the ‘right tool’ and opt for the one that will work. Unfortunately, there are plenty of examples in the IT space – the topic of which is this month’s T-SQL Tuesday, hosted by Rick Krueger ...
    Posted to Rob Farley (Weblog) by rob_farley on September 9, 2013
  • Filegroups and Non-Clustered Indexes

    Let’s start with some basics and then jump in a bit deeper, for this post to go with the 40th T-SQL Tuesday, hosted this month by Jen McCown. SQL Server holds data, and that data is stored physically in files. Of course, in the database world we think of the data as living in tables*, so naturally there must be some sort of mapping between the ...
    Posted to Rob Farley (Weblog) by rob_farley on March 11, 2013
  • Behind the scenes of PowerShell and SQL

    Every year, PowerShell increases its stranglehold on the Windows Server system and the applications that run upon it – with good reason too. Its consistent mechanisms for interaction between its scripting interface and the underlying systems make it easy for people to feel comfortable, and there is a discoverability that has been lacking in many ...
    Posted to Rob Farley (Weblog) by rob_farley on February 11, 2013
  • Joins in single-table queries

    Tables are only metadata. They don’t store data. I’ve written something about this before, but I want to take a viewpoint of this idea around the topic of joins, especially since it’s the topic for T-SQL Tuesday this month. Hosted this time by Sebastian Meine (@sqlity), who has a whole series on joins this month. Good for him – it’s a great ...
    Posted to Rob Farley (Weblog) by rob_farley on December 10, 2012
  • When someone deletes a shared data source in SSRS

    SQL Server Reporting Services plays nicely. You can have things in the catalogue that get shared. You can have Reports that have Links, Datasets that can be used across different reports, and Data Sources that can be used in a variety of ways too. So if you find that someone has deleted a shared data source, you potentially have a bit of a horror ...
    Posted to Rob Farley (Weblog) by rob_farley on October 8, 2012
  • Tricks? In T-SQL?

    Four years ago, I was preparing to speak at TechEd Australia. I’d been asked to give a session on “T-SQL Tips and Tricks”, but I’d pushed back and we’d gone with “T-SQL Tips and Techniques” instead. I hadn’t wanted to show Tricks, because despite being a fan of ‘magicians’ (like Tommy Cooper) I feel like the trickery should disappear with the ...
    Posted to Rob Farley (Weblog) by rob_farley on August 13, 2012
  • MERGE gives better OUTPUT options

    MERGE is very cool. There are a ton of useful things about it – mostly around the fact that you can implement a ton of change against a table all at once. This is great for data warehousing, handling changes made to relational databases by applications, all kinds of things. One of the more subtle things about MERGE is the power of the OUTPUT ...
    Posted to Rob Farley (Weblog) by rob_farley on June 11, 2012
  • Analytic functions – they’re not aggregates

    SQL 2012 brings us a bunch of new analytic functions, together with enhancements to the OVER clause. People who have known me over the years will remember that I’m a big fan of the OVER clause and the types of things that it brings us when applied to aggregate functions, as well as the ranking functions that it enables. The OVER clause was ...
    Posted to Rob Farley (Weblog) by rob_farley on April 9, 2012
  • Be the surgeon

    It’s a phrase I use often, especially when teaching, and I wish I had realised the concept years earlier. (And of course, fits with this month’s T-SQL Tuesday topic, hosted by Argenis Fernandez) When I’m sick enough to go to the doctor, I see a GP. I used to typically see the same guy, but he’s moved on now. However, when he has been able to ...
    Posted to Rob Farley (Weblog) by rob_farley on March 12, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement