1. SQL Judo’s Monthly Challenge – March 2014 – Powershell something

    Leave a comment

    March 2, 2015 by Kenneth Fisher

    Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
    Continue reading

  2. Using sp_DBPermissions and sp_SrvPermissions v6.0

    Leave a comment

    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

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

    1

    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

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

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

    34

    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

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

    1

    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

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

    7

    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

  8. Dealing with layered function calls

    4

    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

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

  10. A quick email interview of Pass President Thomas LaRock

    2

    January 28, 2015 by Kenneth Fisher

    Back in December I had the thought that it would be fun to do an email interview with someone. As …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 651 other followers