Category Archives: SSMS

  1. Adding a new keyboard shortcut in SSMS.

    2

    July 6, 2015 by Kenneth Fisher

    I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. …
    Continue reading

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

  3. Modifying the “New Query” template.

    6

    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

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

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

  6. Using Solutions in SSMS

    3

    March 11, 2015 by Kenneth Fisher

    There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, …
    Continue reading

  7. Database default locations

    4

    September 29, 2014 by Kenneth Fisher

    One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
    Continue reading

  8. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  9. Escaping from a runaway Logon trigger

    1

    May 19, 2014 by Kenneth Fisher

    Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
    Continue reading

  10. Granting or denying permissions to all of the tables within a database

    2

    May 15, 2014 by Kenneth Fisher

    When granting or denying permissions to the tables within a database you have two options. You can either add the …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 791 other followers