Tag Archives: microsoft sql server

  1. Clean out all bad characters from a string.

    3

    March 25, 2015 by Kenneth Fisher

    I have a customer who is having a problem with a load. He is getting a fair number of bad …
    Continue reading

  2. 0 to Speaker

    10

    March 23, 2015 by Kenneth Fisher

    Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I …
    Continue reading

  3. Why not NOLOCK?

    4

    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    Continue reading

  4. There are #temp tables and then there are ##temp tables.

    Leave a comment

    March 16, 2015 by Kenneth Fisher

    Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly …
    Continue reading

  5. Using Solutions in SSMS

    3

    March 11, 2015 by Kenneth Fisher

    There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, …
    Continue reading

  6. Who’s using that database?

    Leave a comment

    March 9, 2015 by Kenneth Fisher

    A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
    Continue reading

  7. I want to blog but …

    Leave a comment

    March 4, 2015 by Kenneth Fisher

    I don’t know how to get started. Pretty simple. There are a number of free blogging sites out there. Personally …
    Continue reading

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

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

    6

    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

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

Follow

Get every new post delivered to your Inbox.

Join 680 other followers