Tag Archives: SSMS

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

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

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

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

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

  6. The default autogrowth settings do NOT come from the Model database.

    1

    April 28, 2014 by Kenneth Fisher

    I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed …
    Continue reading

  7. :CONNECT in SSMS

    7

    March 13, 2014 by Kenneth Fisher

    Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from …
    Continue reading

  8. Check your SQL Agent history settings before it’s too late!

    3

    February 10, 2014 by Kenneth Fisher

    A little while back I was doing some research into a failed job and ran into a slight problem. The …
    Continue reading

  9. SSMS Shortcuts and more

    Leave a comment

    December 23, 2013 by Kenneth Fisher

    I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs. …
    Continue reading

  10. Connection options in SSMS

    Leave a comment

    November 18, 2013 by Kenneth Fisher

    When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 718 other followers