Monthly Archives: April 2016

  1. Certificates, Proxies and Jobs! Oh My!

    2

    April 27, 2016 by Kenneth Fisher

    Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need …
    Continue reading

  2. Get your SQL Server MCSA without taking the BI exam.

    2

    April 25, 2016 by Kenneth Fisher

    I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new …
    Continue reading

  3. Why my primary test environment is case sensitive.

    1

    April 20, 2016 by Kenneth Fisher

    Me: I think I’m going create a new playground instance. Myself: Make sure you use a case sensitive (CS) collation …
    Continue reading

  4. How do I rename a column?

    2

    April 18, 2016 by Kenneth Fisher

    Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to …
    Continue reading

  5. Modulo!

    7

    April 14, 2016 by Kenneth Fisher

    I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even …
    Continue reading

  6. The risks of Delayed Durability

    1

    April 12, 2016 by Kenneth Fisher

    It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about …
    Continue reading

  7. Name the schema when you create an object (or else)

    1

    April 6, 2016 by Kenneth Fisher

    This is one of those frequently ignored best practices. When you create an object, specify the schema where it will …
    Continue reading

  8. Complex/Conditional ORDER BYs

    1

    April 4, 2016 by Kenneth Fisher

    Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed. …
    Continue reading

  9. 4

    April 1, 2016 by Kenneth Fisher

    I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t …
    Continue reading

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

Join 2,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013