Looking for a job or a candidate? Here are my links to SQL Server interview questions and answers, SQL Server related jobs and a DBA job description.
SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance
Twelve tips for better SQL Server 2005 query performance, from execution plans and covering indexes to avoiding cursors, using APPLY and archiving old data.
SQLAuthority News – SQL SERVER Database Administrator Job Description
An updated SQL Server Database Administrator Job Description: support for the database environment, new technology, reliability and long-term planning.
SQL SERVER – Four Basic SQL Statements – SQL Operations
The four basic SQL statements are SELECT, UPDATE, INSERT and DELETE. A short note on what each one does, with a link to my one page FAQ sheet for full syntax.
SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article
Reader Praveen Barath adds his own query optimization tips to my rules of thumb: tune only working code, write repeated statements identically and more.
SQL Server – Good Articles on Database Collation
Database Collation defines default character comparison rules for a database. I also inspect the columns and expressions involved.
What to Alert On, and What to Let Sleep
Make SQL Server alerting actionable by tying thresholds to impact, checking missing work, reducing duplicates, and reviewing every overnight call.