A short introduction to partitioning in SQL Server 2005: very large tables and indexes are split into smaller parts by ranges, across filegroups, for performance.
Checking Every Database for Risky Settings
Find risky settings across every SQL Server database, including AUTO_SHRINK, AUTO_CLOSE, page verification, recovery model, and ownership.
SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working
My Remote Desktop copy paste stopped working both ways while I worked on a remote SQL Server. Restarting did not help, but the fix at the end of the post did.
SQL SERVER – Get a Row Per File of a Database as Stored in the Master Database
Each database has at least two files. This quick script on sys.master_files returns a row per file of a database, just as it is stored in master.
SQL SERVER – Introduction to Statistical Functions – VAR, STDEVP, STDEV, VARP
VAR, STDEVP, STDEV and VARP are statistical functions that also fit the aggregate function definition. A quick AdventureWorks example shows all four.
SQL SERVER – Introduction to Aggregate Functions
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.