Category Archives: Microsoft SQL Server

  1. Generic Dynamic SQL Stored Procedure

    5

    July 22, 2013 by Kenneth Fisher

    Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
    Continue reading

    Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , , , ,

  2. Amusing SQL Trick – Hide yourself from SQL Server

    1

    July 17, 2013 by Kenneth Fisher

    I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead …
    Continue reading

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

  3. Scripting a partitioned table or index, a caution.

    14

    July 15, 2013 by Kenneth Fisher

    I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First …
    Continue reading

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

  4. Ordering steps in a SQL Agent job

    2

    July 8, 2013 by Kenneth Fisher

    Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is …
    Continue reading

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

  5. Writing Dynamic SQL (A how to)

    6

    July 1, 2013 by Kenneth Fisher

    A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
    Continue reading

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

  6. Using OUTPUT to back up a change

    2

    June 26, 2013 by Kenneth Fisher

    How will you back out if your change doesn’t work?! Always take a backup! There should always be a back …
    Continue reading

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

  7. Metadata Functions (OBJECT_NAME for example)

    Leave a comment

    June 24, 2013 by Kenneth Fisher

    What is a metadata function? According to BOL a metadata function is one that returns data about the database or …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , , , ,

  8. Disaster Recovery’s big brother Operational Recovery

    15

    June 20, 2013 by Kenneth Fisher

    I’m going to get slammed for the title by someone but I stand by it. First some definitions. Disaster Recovery …
    Continue reading

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

  9. ORDER BY the numbers

    17

    June 17, 2013 by Kenneth Fisher

    Have you ever needed to order by a calculated column? You might have written it something like this: Did you …
    Continue reading

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

  10. Best practice recommendations for writing Dynamic SQL

    16

    June 12, 2013 by Kenneth Fisher

    Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
    Continue reading

    Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | 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