1. #SQLCareer 4/4 January 2nd 2019

    Leave a comment

    January 10, 2019 by Kenneth Fisher

    Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be …
    Continue reading

  2. Automation starts by doing something once, very very carefully: T-SQL Tuesday #110

    5

    January 8, 2019 by Kenneth Fisher

    After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s …
    Continue reading

  3. SQL Homework – January 2019 – Baselines

    Leave a comment

    January 2, 2019 by Kenneth Fisher

    Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
    Continue reading

  4. Using Microsoft Learn

    3

    December 31, 2018 by Kenneth Fisher

    I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows …
    Continue reading

  5. Identity in a SELECT

    4

    December 19, 2018 by Kenneth Fisher

    Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here? …
    Continue reading

  6. Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

    4

    December 17, 2018 by Kenneth Fisher

    Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error …
    Continue reading

  7. Bulk insert and an identity column

    1

    December 12, 2018 by Kenneth Fisher

    TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file …
    Continue reading

  8. Moving SSISDB is not as easy as it sounds

    Leave a comment

    December 10, 2018 by Kenneth Fisher

    We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016 …
    Continue reading

  9. UDL files and connection strings

    Leave a comment

    December 5, 2018 by Kenneth Fisher

    A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and …
    Continue reading

  10. SQL Homework – December 2018 – Configure SSMS

    Leave a comment

    December 3, 2018 by Kenneth Fisher

    I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
    Continue reading

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

Join 2,484 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013