Forums (RSS 2.0)" href="http://www.simple-talk.com/community/forums/rss.aspx?ForumID=-1&Mode=0" />
Click here to monitor SSC

SQL Cop Review

Last post 02-10-2012, 7:46 AM by Anonymous. 7 replies.
Sort Posts: Previous Next
  •  01-19-2012, 3:58 AM Post number 105544

    SQL Cop Review

  •  01-20-2012, 2:50 PM Post number 105574 in reply to post number 105544

    SQL Cop checks

    Grant, thank you for the review of SQLCop. One thing I wished you had mentioned was that we (at lessthandot.com) are willing to add additional checks to SQLCop. If there are any checks that you (or anyone else) thinks would be a worthy addition, please post it here: http://forum.lessthandot.com/viewforum.php?f=145
  •  01-24-2012, 1:52 PM Post number 105652 in reply to post number 105544

    Additional Checks

    I didn't know that. That's great to know.
  •  02-01-2012, 2:17 PM Post number 105777 in reply to post number 105544

    Checks

    Why in the world enabling CLR is a smell or lapse in best practice???
  •  02-02-2012, 5:59 AM Post number 105802 in reply to post number 105544

    CLR

    Personally, I don't think it is, but a lot of DBAs do. Also some companies consider it a security risk. I understand why they have it, but I don't agree with it.
  •  02-02-2012, 10:09 AM Post number 105813 in reply to post number 105544

    Re: CLR

    I'd be happy to be alerted if CLR has been enabled as our company policy dictates that we have it switched off in production servers as a security risk.
  •  02-02-2012, 2:02 PM Post number 105816 in reply to post number 105544

    CLR smells

    1. SQL Server DBAs should take example from every other vendor that has code running inside the engine (MySQL has C extensions...).
    2. SQL Server DBAs should know they are still running and will be running in SQL Server 2012:
    - to be deprecated but not yet, extended stored procedures
    - stored procedures based on cursors and C/C++ code
    3. .NET CLR is by those standards, a perfume!
  •  02-10-2012, 7:46 AM Post number 105962 in reply to post number 105544

    SQL Cop

    Thanks! Good stuff as always!
View as RSS news feed in XML