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