Category Archives: Microsoft SQL Server

  1. Model database

    Leave a comment

    January 28, 2013 by Kenneth Fisher

    Most DBAs have at least some idea what the system databases are for. Master has the list of databases & …
    Continue reading

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

  2. IsMSShipped

    3

    January 23, 2013 by Kenneth Fisher

    I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t …
    Continue reading

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

  3. My view isn’t reflecting changes I’ve made to the underlying tables.

    8

    January 20, 2013 by Kenneth Fisher

    Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change. …
    Continue reading

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

  4. Using New Horizontal/Vertical Tab Groups

    9

    January 14, 2013 by Kenneth Fisher

    This isn’t really one of those features of SSMS that I’ve used a great deal. At least didn’t until recently. …
    Continue reading

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

  5. What port is my instance listening on?

    8

    January 8, 2013 by Kenneth Fisher

    I just had the interesting task of finding the port number that one of the instances I deal with is …
    Continue reading

    Category: DMV, Microsoft SQL Server, Settings, SQLServerPedia Syndication | Tags: , , , , , , , ,

  6. How I like to learn a t-sql command

    11

    January 7, 2013 by Kenneth Fisher

    Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands …
    Continue reading

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

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

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

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

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

« Older Entries
Newer Entries »

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,975 other subscribers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013