Database Presentations

Presentations on SQL Server

Database performance for Software Developers

Covers the following:

• How SQL Server executes queries
• Execution Plans
• Simple monitoring
• Indexing

Learning to talk to Developers

Helps DBAs understand developers. Covers the following topics:

• What communication issues exist between devs and DBAs
• Cultural issues in organisations
• Developer knowledge
• DBA knowledge

Top Database Performance Techniques

A top 10 of simple techniques to get your database humming.

• Keep tables small
• Only select the required columns
• Only get the rows required
• Create indexes
• Identifying unused indexes
• Avoid implicit conversions
• Avoid looping if possible
• Use union or AND instead of OR
• Avoid wildcards at the start of strings
• Join with inner join instead of where