Monthly Archives: December 2012

  1. Red errors in the results pane

    3

    December 19, 2012 by Kenneth Fisher

    Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed …
    Continue reading

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

  2. Generating multiple SQL statements from a query

    2

    December 17, 2012 by Kenneth Fisher

    Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can …
    Continue reading

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

  3. Where is my backup?

    10

    December 12, 2012 by Kenneth Fisher

    We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working …
    Continue reading

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

  4. Copying Connection Managers in SSIS

    Leave a comment

    December 10, 2012 by Kenneth Fisher

    Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit …
    Continue reading

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

  5. Logins vs Users

    20

    December 3, 2012 by Kenneth Fisher

    Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems. …
    Continue reading

    Category: DMV, Microsoft SQL Server, Security, SQLServerPedia Syndication | 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,755 other subscribers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013