Monthly Archives: June 2015

  1. Zero to Speaker pt 2

    6

    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?

    1

    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

    9

    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.

    9

    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.

    4

    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

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

Join 1,597 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013