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