Category Archives: SQLServerPedia Syndication

  1. Port numbers and SQL Server

    Leave a comment

    March 30, 2015 by Kenneth Fisher

    I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
    Continue reading

  2. Clean out all bad characters from a string.

    9

    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

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

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

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

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

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

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

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

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

Follow

Get every new post delivered to your Inbox.

Join 695 other followers