Monthly Archives: March 2013

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

    18

    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

    Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: , , , , , ,

  2. Using Templates

    3

    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

    Category: Microsoft SQL Server, SQLServerPedia Syndication, SSMS | Tags: , , ,

  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

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , , ,

  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

    Category: Backups, Microsoft SQL Server, SQLServerPedia Syndication, System Databases | Tags: , ,

  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

    Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: , , , , ,

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

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

Join 3,753 other subscribers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013