What is the difference between DBMS and RDBMS? An RDBMS adds tables with enforced relationships, plus the constraints and security a plain DBMS lacks.
SQL SERVER – 2005 – Licensing Model Compared to Other Database Products
How does the SQL Server 2005 Licensing Model compare with other database products? I share a chart and table showing it is feature rich and far cheaper.
SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP
Takayuki Hoshino’s top 10 best practices for SQL Server Maintenance for SAP: daily full backups, frequent log backups, DBCC CHECKDB, statistics and index care.
SQL SERVER – Generic Architecture Image
A Generic Architecture image of SQL Server I found on Wikipedia, with a short note on physical storage in MDF and LDF files and how data is grouped logically.
SQL SERVER – Database Interview Questions and Answers Complete List
My Database Interview Questions and Answers series in one list, from the introduction through part 6, plus a complete list download and a link to the update.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.
SQLAuthority News – Best Articles on SQLAuthority.com
Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility
A list of my best articles so far, from killing all processes in a database and shrinking the log file to deleting duplicate rows and UNION vs UNION ALL.