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