Some SQL Server 2005/2008/2012 documents and links.



Section 1. My own notes:

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

Overview of some often used TSQL statements, scripts, tips (html)


1.2. Some simple pointers to keep SQL Server Up and Running:

Just a few Tips.


1.3. SQL Server 2012 AlwaysOn Cluster:

Some quick notes on SQL Server 2012 AlwaysOn Clusters (html)


1.4. Some notes on Performance:

Simple note on SQL Server Performance - the Physical stuff (indexes, waits, IO, mem etc..) (html)
Simple note on SQL Server Performance - Query design and tuning (html)
Simple note on DBCC commands related to memory and caches (html)


1.5. SQL Server Trace Flags:

Trace Flags (.txt file)


1.6. Very simple Introductions SQL Server BI tools and DWH:

Simple intro SQL Server Analysis Services SSAS (also with a bit DataWare House technology) (html)
Simple intro SQL Server Reporting Services SSRS (html)
Simple intro SQL Server Integration Services SSIS (html)


1.7. Overview SQL Server Versions and builds:

Quick Overview SQL Server Versions and builds (html)


1.8. How BLOBs are handled:

Simple note on storage and handling of BLOBs (html)


1.9. Some quick notes on Backup and Restore (html):

Some quick notes on Backup and Restore (html)


1.10. Reviving SQL accounts:

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


1.11. Installing a modified "sp_help_revlogin":

If you don't have it, here is "sp_help_revlogin" 2005/2008/2012 (.txt)


1.12. Some simple quick admin queries (.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.13. Quickly export all tables from a database to flat files using bcp:

Export all tables from a database to flat files (.txt file)


1.14. Some notes on handling corruption (html):

Some notes on SQL Server corruption (html)


1.15. 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, Excel format)
Listing of some SQL Server 2008 facts & structures (for exam 70-432, Excel format)


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

Quick and very simplified Introduction in SQL Server 2005 (Excel format)
Quick and very simplified Introduction in Data Imports/Exports SQL Server 2005/2008 (Excel format)


1.17. Notes on SPN, Kerberos, Delegation:

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


1.18. Older DBA stuff:

DBA queries and tips used in older versions (.txt)


1.19. SQL Server miniposters:

-- Dictionary/SystemViews:

Overview of dictionary SQLServer 2005/2008 with respect to Locks and Sessions. (Excel format)
Overview of dictionary SQLServer 2005/2008 with respect to Accounts. (Excel format)
Overview of dictionary SQLServer 2005/2008 with respect to Objects (tables, indexes etc..). (Excel format)
Overview of dictionary SQLServer 2005/2008 with respect to Backups and Jobs (msdb database). (Excel format)
All of the above in a HTML webpage.


-- Other:

Overview of some "Traditional" Imports/Exports SQLServer 2005/2008/2012 (Excel format)
Overview of some "Traditional" Imports/Exports SQLServer 2005/2008/2012 (in HTML)


Section 2. Other links:





Last update: 27 March, 2015