Using SMO 2012 to trouble shoot support issues

  • Peter Bannister

    SSC-Addicted

    Points: 461

    Comments posted to this topic are about the item Using SMO 2012 to trouble shoot support issues

    I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz

  • RichB

    SSCrazy Eights

    Points: 9651

    Wouldn't it be easier to have an admin server in your datacenter hooked up with Terminal Services and a copy of 2012 on it? You could then also use it as a central management server and whatnot, and only need to vpn in and rdp to it?

  • Peter Bannister

    SSC-Addicted

    Points: 461

    Hi Rich,

    sure it would!

    However, like I said at the bottom of the article, it was a little contrived to highlight certain parts of SMO.

    Cheers

    Peter

    I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz

  • derek.colley

    SSCrazy Eights

    Points: 8040

    Ooooooo....

    I think if I found one of my developers using SMO to access database objects directly, that person would be found hanging from a cross in the morning.

    This situation is exactly what having an API full of stored procedures is for. The devs should never be querying base tables directly, or updating database / server level settings.

    Any dev wishing to try using a programmatic interface to access SQL Server would also likely run into permission problems, as the credentials they have may not have permissions on various objects.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

  • Basit Farooq

    Ten Centuries

    Points: 1151

    Nice article.

    Regards,

    Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

    http://basitaalishan.com
  • Peter Bannister

    SSC-Addicted

    Points: 461

    Hi Derek,

    I dont think I would use SMO for general "day to day" tasks.

    However, if you are looking to automate operational tasks or integrate from a line of business application then this is a great tool to have in your bag.

    Cheers

    Peter

    I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply