This talk is geared towards developers who maybe aren’t so familiar or comfortable with Query Plans, IO Statistics, SQL Profiler or the concepts of tuning queries. We cover some basics (Indexing, SARGable Queries, Statistics, Some “Worst Practices”, some general concepts for performance minded development) and then play with some sample queries. The purpose of the [...]
This presentation is aimed at the starting DBA, accidental DBA or developer having to wear a DBA hat occasionally. It was written to hopefully convey the important order of operations to a DBA just starting out and walk through the “itties” of Database Administration.
Related Blog Posts At StraightPath Solutions
Tips for SQL Server DBAs Starting Out [...]