Category Archives: Microsoft SQL Server

  1. Uniquifier is a rather unique word isn’t it?

    3

    September 18, 2017 by Kenneth Fisher

    tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny …
    Continue reading

  2. Help! My query is too fast!

    1

    September 14, 2017 by Kenneth Fisher

    Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of …
    Continue reading

  3. Turn on/off Azure VMs with Powershell

    Leave a comment

    September 12, 2017 by Kenneth Fisher

    T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked …
    Continue reading

  4. There EXISTS a place where SELECT 1/0 doesn’t return an error.

    3

    September 7, 2017 by Kenneth Fisher

    Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical …
    Continue reading

  5. SQL Homework – September 2017 – Create a home lab

    Leave a comment

    September 5, 2017 by Kenneth Fisher

    As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something …
    Continue reading

  6. Create an empty table from a SELECT statement but without the IDENTITY.

    3

    August 28, 2017 by Kenneth Fisher

    A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like …
    Continue reading

  7. Changing the version of an SSIS package.

    2

    August 23, 2017 by Kenneth Fisher

    Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say …
    Continue reading

  8. Deploy an SSIS project to the SSIS catalog.

    Leave a comment

    August 21, 2017 by Kenneth Fisher

    You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project …
    Continue reading

  9. Creating an SSIS project

    Leave a comment

    August 16, 2017 by Kenneth Fisher

    Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open …
    Continue reading

  10. Installing the (currently) latest Data Tools

    5

    August 14, 2017 by Kenneth Fisher

    I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills …
    Continue reading

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

Join 1,682 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013