Some SQL Server 2005 / 2008 documents and links.



Section 1. My own notes:

1.1. Overview of some often used TSQL statements and scripts:

Overview of some often used TSQL statements and scripts (html, version 3.5)
Some quick notes on Backup and Restore (html, version 1.0)


1.2. Reviving SQL accounts:

Reviving SQL accounts, after moving, or backup/restore, of a database on another machine


1.3. Some simple quick admin queries (or notes) for 2005/2008 (.txt files):

A few queries showing sessions and blocked sessions
A few queries showing backup history from the MSDB database
A few queries showing index information (number of rows, fragmentation etc..)
A few queries showing database file info (sizes,paths,%free/%full etc..)
A few queries showing SQL Server waits
A few examples how to alter and add objects
A short note describing SQL Server backup and restore using TSQL


1.4. Overview SQL Server Versions and builds:

Overview SQL Server Versions and builds (.txt file)


1.5. SQL Server Trace Flags:

Trace Flags (.txt file)


1.6. Some notes on handling corruption on 2005/2008 (html):

Some notes on SQL Server corruption (v. 1.1)


1.7. Performance Notes 2005/2008 (html) :

Some SQL Server performance considerations (v. 2.9)


1.8. Exam Preparation support files for exams 70-431 / 70-432 (in Excel format):

Listing of some SQL Server 2005 facts & structures (for exam 70-431, 5.5 MB, version 3.8)
Listing of some SQL Server 2008 facts & structures (for exam 70-432, 9 MB, version 0.8)


1.9. A few very simple and short tutorials (in Excel format):

Quick and very simplified Introduction in SQL Server 2005, version 4.3
Quick and very simplified Introduction in Data Imports/Exports SQL Server 2005/2008, version 2.3


1.10. Notes on SPN, Kerberos, Delegation:

Simple note on Service Principal Name (SPN), Delegation, and related problems (txt file)


1.11. Older DBA stuff:

DBA queries and tips used in older versions


Section 2. Working Docs:

2.1. A few short notes on clustering:

Some notes on Win2K3/Win2K8 Cluster architecture, repair, and commands (html)
Some notes on Win2K3/Win2K8 clustering (Excel)


Section 3. Other links:

3.1. A few selected technical articles on performance 2005/2008:

More depth on SQL Server performance discussions: Microsoft Technet article
Great site with good queries (you need to search around a bit)
SQL Server disk storage design considerations: Microsoft Technet article
more depth on the specifics on TEMPDB: Microsoft Technet article
Top 10 SQL Server performance issues in DW
Top 10 SQL Server performance issues in OLTP


3.2. How to script your Database and objects:

Using Management Studio
Using SQLPUBWIZ (1)
Using SQLPUBWIZ (2)
Download SQLPUBWIZ from Microsoft


3.3. A few selected articles on 2005/2008 Clustering:

- Easy to read overviews installing Win2K3 + SQL 2K5 cluster:

How to Cluster Windows Server 2003
How to cluster SQL server 2005 on Windows Server 2003

- Easy to read overview installing Win2K8 + SQL 2K8 cluster:

Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 3
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4

- Specials with installing Win2K8 + SQL 2K8 cluster:

Slipstream SQL2K8 plus SP1
Slipstream SQL2K8R2 plus SP1
All about the Quorum
ERROR When installing SQL2K8 on Win2K8 Cluster: The cluster either has not been verified.... error

- Some "account/authentication/spn" problems during cluster setup (Win2kx & SQL 2005):

Set spn for remote authentication
Kerberos authentication problems and SPN issues


3.4. A few selected technical articles or utils on internals 2005/2008:

Download the Internals Viewer from "internalsviewer.codeplex.com"
Sheets on concurrency
SQL Server forensics (1)
SQL Server forensics (2)
Types of SQL Server pages


Section 4. SQL Server 2008 R2 "Parallel Datawarehouse":

1. Some documents describing SQL2K8 R2 Parallel Datawarehouse






Last update: 15 Februari, 2012

By
antapex.org