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