Monthly Archives: March 2013

  1. How do I move a SQL login from one server to another without the password?

    16

    March 25, 2013 by Kenneth Fisher

    This is an uncommon task but one that does turn up every once in awhile. A SQL login has to …
    Continue reading

  2. Using Templates

    2

    March 18, 2013 by Kenneth Fisher

    Templates are one of those really handy tools that most DBAs I know of have either never heard of or …
    Continue reading

  3. The STUFF function

    17

    March 14, 2013 by Kenneth Fisher

    While I was at the 2011 Pass Summit I was given the following piece of code to create a comma …
    Continue reading

  4. What is mssqlsystemresource?

    1

    March 4, 2013 by Kenneth Fisher

    If you are lucky you’ve never seen an error along the lines of: But let’s face it, luck runs out. …
    Continue reading

  5. Script to clean up “Windows” logins no longer in AD

    14

    March 1, 2013 by Kenneth Fisher

    I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get …
    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