SQLintersection session – SQLintersection Closing Panel and RunAs Radio Recording

I attended the SQL intersection conference in November 2014 in Las Vegas, Nevada.  I am including my notes from the sessions in this blog, primarily for my own reference later.  For anyone that comes across these notes, please take them with a grain of salt – I may very easily have misheard something or have written it down incorrectly.

Session Title:  SQLintersection Closing Panel and RunAs Radio Recording

SQL Server Compliance Guide (for 2008 security, mostly still applies)

    • 2014 improvements include separation of duties, etc.
  • Multi-master replication guide
  • Google “call me maybe” + another platform (especially NoSQL) (blog about trying to break systems)
  • Filestream whitepaper; also blog on filestream
  • Worst SQL Server advice?
    • If you see CXPACKET waits, set maxdop = 1
    • PLE 300 is bad
    • Put a non-clustered idx on every column

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.