Category Archives: SQLServerPedia Syndication

  1. Bulk insert and an identity column

    Leave a comment

    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

  2. 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

  3. 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

  4. Oh Query, Query, Query

    Leave a comment

    November 28, 2018 by Kenneth Fisher

    I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week. …
    Continue reading

  5. My backup script (where, how, how big, etc.)


    November 26, 2018 by Kenneth Fisher

    A while back I wrote about how to find where your backups are. And I’ve also written about I use …
    Continue reading

  6. The Cloud and Shadow IT.


    November 21, 2018 by Kenneth Fisher

    Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck. …
    Continue reading

  7. Dealing with multiple AD accounts


    November 19, 2018 by Kenneth Fisher

    To help promote the seperation of duties one of the things my company has done is to divide our permissions …
    Continue reading

  8. T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108


    November 13, 2018 by Kenneth Fisher

    Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a …
    Continue reading

  9. Missing those we’ve lost


    November 7, 2018 by Kenneth Fisher

    It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to …
    Continue reading

  10. SQL Homework – November 2018 – Constraints


    November 5, 2018 by Kenneth Fisher

    You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed …
    Continue reading

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

Join 2,470 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013