Tag Archives: SSMS

  1. Some of my favorite SSMS Keyboard shortcuts

    2

    July 29, 2015 by Kenneth Fisher

    I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of …
    Continue reading

  2. SSMS 2015

    Leave a comment

    July 16, 2015 by Kenneth Fisher

    Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10 …
    Continue reading

  3. Adding a new keyboard shortcut in SSMS.

    4

    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

  4. Modifying the “New Query” template.

    7

    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

  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. Using T-SQL to populate a Central Management Server

    2

    November 17, 2014 by Kenneth Fisher

    We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
    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 797 other followers