Category Archives: Security

  1. How do I let someone execute a SQL Agent job they don’t own?

    2

    April 15, 2019 by Kenneth Fisher

    In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
    Continue reading

  2. Can SQL Ids be used on an instance with Windows Authentication only?

    2

    April 11, 2019 by Kenneth Fisher

    tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not …
    Continue reading

  3. Using the Microsoft Authenticator app to log into Azure

    Leave a comment

    February 25, 2019 by Kenneth Fisher

    So I was trying to work on a blog post about the new truncation error this morning and realized I …
    Continue reading

  4. Why do I (they) own that database?

    2

    February 20, 2019 by Kenneth Fisher

    Ever looked at the list of databases and wonder why you own one of them? Or why some other user …
    Continue reading

  5. Controlling the firewall for an Azure SQL DB via T-SQL

    2

    January 16, 2019 by Kenneth Fisher

    The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I …
    Continue reading

  6. How do I grant permissions to view users and their permissions?

    1

    September 17, 2018 by Kenneth Fisher

    tl;dr; VIEW DEFINITION Every now and again you’ll have a user that needs to be able to see what permissions …
    Continue reading

  7. Balancing Security Concerns.

    2

    July 12, 2018 by Kenneth Fisher

    I have a presentation I do every now again on security basics that I’m actually quite proud of. One of …
    Continue reading

  8. Be our guest, be our guest, put our database to the test.

    3

    June 25, 2018 by Kenneth Fisher

    When I think of the public role I often think of the guest database principal (user) at the same time. …
    Continue reading

  9. The public role

    2

    May 23, 2018 by Kenneth Fisher

    A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t. …
    Continue reading

  10. Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101

    1

    April 10, 2018 by Kenneth Fisher

    Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
    Continue reading

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

Join 2,492 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013