1. Zero to Speaker pt 2

    3

    June 29, 2015 by Kenneth Fisher

    A few months ago I wrote a post about the fact that I had actually submitted a session to PASS …
    Continue reading

  2. Which user function do I use?

    Leave a comment

    June 24, 2015 by Kenneth Fisher

    Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you …
    Continue reading

  3. Copying a TDE database from one instance to another

    Leave a comment

    June 22, 2015 by Kenneth Fisher

    I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
    Continue reading

  4. Pass TV

    3

    June 17, 2015 by Kenneth Fisher

    Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an …
    Continue reading

  5. Rename a database

    3

    June 15, 2015 by Kenneth Fisher

    Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s …
    Continue reading

  6. Modifying the “New Query” template.

    5

    June 11, 2015 by Kenneth Fisher

    TLDR; Search for and modify the sqlfile.sql file. During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET …
    Continue reading

  7. A walk-through of creating the Activity Tracking template using Extended Events.

    2

    June 9, 2015 by Kenneth Fisher

    It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started …
    Continue reading

  8. Clean up all (most) of the orphans on an instance

    3

    June 3, 2015 by Kenneth Fisher

    Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone …
    Continue reading

  9. Yet one more quick and easy performance tuning setting

    1

    June 1, 2015 by Kenneth Fisher

    I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS …
    Continue reading

  10. Multiple Windows Groups with different default databases

    2

    May 28, 2015 by Kenneth Fisher

    A question came up at work the other day, mostly as a mind game, but you never know it might …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 791 other followers