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