Monthly Archives: February 2015

  1. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

  2. Tales of a DBA fed up with NOLOCK. Part 2

    7

    February 23, 2015 by Kenneth Fisher

    Feb 16, 2015 Dear Diary, A few weeks back I introduced HAL002 to a database managed by some annoying devs. …
    Continue reading

  3. Test your UPDATEs and DELETEs before you run them

    14

    February 18, 2015 by Kenneth Fisher

    This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you …
    Continue reading

  4. Tales of a DBA fed up with NOLOCK. Part 1

    40

    February 16, 2015 by Kenneth Fisher

    Nov 12, 2014 Dear Diary, They asked for help again. Every now and again everything slows down and they see …
    Continue reading

  5. TSQL Tuesday #63 – How do you manage security: Rollup

    2

    February 12, 2015 by Kenneth Fisher

    When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was …
    Continue reading

  6. TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

    9

    February 10, 2015 by Kenneth Fisher

    So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it …
    Continue reading

  7. Dealing with layered function calls

    5

    February 5, 2015 by Kenneth Fisher

    T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are …
    Continue reading

  8. TSQL Tuesday #63 – How do you manage security?

    26

    February 3, 2015 by Kenneth Fisher

    Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought …
    Continue reading

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

Join 2,151 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013