The four types of DBCC Database Console Commands: maintenance, miscellaneous, informational and validation, with a couple of examples of each from MSDN.
SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
Msg 7411 says the server is not configured for RPC. A Jr. DBA I am training found the fix on his own: turn the RPC option from False to True.
What RESTORE VERIFYONLY Checks and What It Misses
RESTORE VERIFYONLY checks backup readability and checksums, but it cannot prove a full restore or healthy data; pair it with restore tests.
SQL SERVER – Three T-SQL Script to Create Primary Keys on Table
Three T-SQL scripts to create primary keys: two while creating the table and one with ALTER TABLE later, where the column must first be NOT NULL.
SQL SERVER – 2005 – Driver for PHP Community Technology Preview (October 2007)
Microsoft released the SQL Server 2005 Driver for PHP CTP, a free PHP 5 extension to read and write SQL Server data. I include the install steps.
SQL SERVER – Explanation and Understanding NOT NULL Constraint
What a NOT NULL constraint does and two ways to add one: when the table is created, or after the table is created. My example covers both.
SQL SERVER – Three Rules to Use UNION
The three rules to use UNION from Ben Forta’s T-SQL book: two or more SELECT statements, the same columns in the same order, and compatible data types.
SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation
SQL Server 2005 ships with risky features off. The Surface Area Configuration tool turns them on or off, and here is what replaced it later.
SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards
Pre-code review tips for DBAs: why I check stored procedures on our development server every day for coding standards, with a link to my full article.
SQL SERVER – T-SQL Script to Add Clustered Primary Key
A Jr. DBA asked me three times in one day how to create a clustered primary key, so I gave him this ALTER TABLE example. He never asked again.