Tag Archives: security

  1. UDP vs TCP

    3

    June 7, 2017 by Kenneth Fisher

    If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance …
    Continue reading

  2. Simple Security Report

    2

    May 1, 2017 by Kenneth Fisher

    Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over …
    Continue reading

  3. sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

    5

    March 27, 2017 by Kenneth Fisher

    It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
    Continue reading

  4. Server level database permissions

    4

    February 14, 2017 by Kenneth Fisher

    Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a …
    Continue reading

  5. My SQL logins don’t work. Again.

    Leave a comment

    January 25, 2017 by Kenneth Fisher

    My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one …
    Continue reading

  6. Why won’t my SQL Logins work?

    10

    January 12, 2017 by Kenneth Fisher

    I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
    Continue reading

  7. It greatly pleases me to announce, HAL0003!

    25

    November 23, 2016 by Kenneth Fisher

    I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal …
    Continue reading

  8. Is it safe to grant Administer Bulk Operations?

    4

    November 10, 2016 by Kenneth Fisher

    First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are …
    Continue reading

  9. SA Spoof

    14

    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

  10. Cloud Security

    1

    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

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

Join 1,663 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013