Monthly Archives: May 2013

  1. Backup a password, change it, then restore it.

    2

    May 30, 2013 by Kenneth Fisher

    A couple of months ago I talked about moving a login from one server to another without the password. The …
    Continue reading

  2. Using CROSS APPLY to calculate an aggregate across a single row.

    2

    May 28, 2013 by Kenneth Fisher

    I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last …
    Continue reading

  3. Using CROSS APPLY instead of a calculated variable

    3

    May 22, 2013 by Kenneth Fisher

    Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working …
    Continue reading

  4. The many uses of CROSS APPLY

    2

    May 20, 2013 by Kenneth Fisher

    Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the …
    Continue reading

  5. CREATE SCHEMA can do what?!?!?

    4

    May 15, 2013 by Kenneth Fisher

    So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t …
    Continue reading

  6. Dragging a name from the object explorer to a query window

    5

    May 13, 2013 by Kenneth Fisher

    In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that …
    Continue reading

  7. Free SQL Books

    4

    May 8, 2013 by Kenneth Fisher

    I was looking for a way to put BOL on my Kindle when I found a few good links I …
    Continue reading

  8. GO

    3

    May 6, 2013 by Kenneth Fisher

    Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in …
    Continue reading

  9. Comparing an inner join vs a subquery

    11

    May 2, 2013 by Kenneth Fisher

    I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing …
    Continue reading

  10. Well I finally passed the 70-451

    7

    May 1, 2013 by Kenneth Fisher

    So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,597 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013