My webshow chatroom wrote a book together

Outline for a new book, written by SQLSoldier, Kevlar, nic, SQLHA, and SQLPoolBoy2:

 

  1. How to connect to the database from PowerPoint
  2. So will a backup shrink a database or t-log?
  3. Who needs a Transaction Log anyway
  4. How to piss your DBA off with LEFT OUTER JOINs
  5. If Microsoft put Auto-Shrink in, they meant for you to use it!
  6. Auto-Close…the cool kids use it, why don’t you?
  7. Maintenance Plans – Just Check all the boxes
  8. SMO – it’s not JUST for backups
  9. There’s no such thing as SQLOS
  10. BI – SQL Swings Both Ways
  11. Views inside views inside views inside views inside views inside views inside…  A Russian nesting doll approach to development.
  12. How to cluster SSRS and SSIS
  13. SQL Editions and why you only need the Web one
  14. Using Developer Edition on your workstation as a production server
  15. Technically you can have up to 128 underscores in an object name
  16. Triggers:  your hidden friends.
  17. calling your table [TRUNCATE TABLE ORDERS] just for shits n giggles
  18. Security is for Pussies
  19. 32,767 Databases Per Instance – Consolidate Supremely
  20. Just delete the log file, SQL will rebuild it.
  21. SQL Injection is best performed with a turkey baster.
  22. GUID based development techniques
  23. Fragmentation Problems – Get an SSD!
  24. Index, Shmindex
  25. Drive consolidation – put your data, logs & backups on disk to save costs
  26. why you use varchar(max) for all of your column needs.
  27. Put all your blobs in the DB. DBs love the size.

Leave a Reply

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