What are Aggregate Functions in SQL Server? The Books Online definition, the full list, and the NULL and GROUP BY rules that candidates often miss.
SQL SERVER – 2005 Best Practices Analyzer (January 2008)
The SQL Server 2005 Best Practices Analyzer checks your settings against Microsoft recommendations. Here is how I read its report without blind changes.
SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer
A sample Job Description of Database Administrator (DBA) or Database Developer, covering standards, security, testing, installs and the other duties of the role.
Auditing Who Has sysadmin
Audit who has sysadmin in SQL Server, including direct members and Windows groups, then investigate nested access and forgotten logins.
SQL SERVER – What is – DML, DDL, DCL and TCL – Introduction and Examples
What are DML, DDL, DCL and TCL? A short introduction to the four groups of SQL commands, with examples like SELECT, CREATE, GRANT and COMMIT.
SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet
Why does a DELETE on large recordset time out? When you want every row gone, use TRUNCATE instead, but keep in mind it resets the identity value.
SQLAuthority News – Good Motivational Quotes for Interviews
A running list of motivational quotes for anyone heading to a job interview, collected over the years. Send me your favorite and I will add it.