Category Archives: Security

  1. SA Spoof


    September 8, 2016 by Kenneth Fisher

    This is nothing new but it’s still a fun idea. The problem: The vendor app we just purchased (and are …
    Continue reading

  2. Cloud Security


    August 22, 2016 by Kenneth Fisher

    In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those …
    Continue reading

  3. Write-Only permissions


    August 11, 2016 by Kenneth Fisher

    Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other …
    Continue reading

  4. Using impersonation to allow a task without granting the required permission.


    August 1, 2016 by Kenneth Fisher

    I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can …
    Continue reading

  5. Grant Deny Revoke


    May 4, 2016 by Kenneth Fisher

    It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them. …
    Continue reading

  6. Certificates, Proxies and Jobs! Oh My!


    April 27, 2016 by Kenneth Fisher

    Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need …
    Continue reading

  7. I’m presenting for the Pass Security Virtual Chapter!


    March 23, 2016 by Kenneth Fisher

    Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter. …
    Continue reading

  8. What permissions do I need?

    Leave a comment

    March 16, 2016 by Kenneth Fisher

    Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
    Continue reading

  9. You don’t need to be a sysadmin


    March 10, 2016 by Kenneth Fisher

    Hey, I need sysadmin access to ServerA. Ok. Why do you need sysadmin? Well I need to be able to …
    Continue reading

  10. How do I grant someone the ability to create a stored procedure?


    March 2, 2016 by Kenneth Fisher

    The question of How to grant the ability to create/alter stored procedures and views came up today on It’s …
    Continue reading

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

Join 1,580 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013