Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Wednesday, 6 July 2011

More SQL Server 2008 Reading

More articles to read to expand your SQL knowledge which may help through the administration certification process.

Configuring linked servers for delegation
http://msdn.microsoft.com/en-us/library/ms189580.aspx

Linking Servers
http://msdn.microsoft.com/en-us/library/ms188279.aspx

Distributed Queries
http://msdn.microsoft.com/en-us/library/ms188721.aspx

Guidelines for using Distributed Queries
http://msdn.microsoft.com/en-us/library/ms175129.aspx

Troubleshooting SQL Server 2005/2008 Query Performance/Scalability Issues
http://sqlcat.com/files/folders/280/download.aspx

A cheat sheet for SQL Server developers
http://www.dotnet4all.com/snippets/2008/04/factsheet-for-sql-server-developers.html
http://www.pinaldave.com/sql-download/SQLServerCheatSheet.pdf

Filestream Overview
http://technet.microsoft.com/en-us/library/bb933993.aspx

Using filestream with other SQL Server Features
http://msdn.microsoft.com/en-us/library/bb895334.aspx

Administering Servers by using Policy Based Management
http://technet.microsoft.com/en-us/library/bb510667.aspx

Kerberos Authentication and SQL Server
http://technet.microsoft.com/en-us/library/cc280744.aspx

Alter Database Set options
http://msdn.microsoft.com/en-us/library/bb522682.aspx

DDL Triggers and Logon triggers
http://blogs.technet.com/b/vipulshah/archive/2007/12/04/ddl-triggers-and-logon-triggers.aspx

Introduction to Change Data Capture in SQL Server 2008
http://www.bradmcgehee.com/2010/04/an-introduction-to-sql-server-2008-change-data-capture/

Enabling change data capture
http://msdn.microsoft.com/en-us/library/cc627369.aspx

Examples of Restore Sequences for Several Restore Scenarios
http://technet.microsoft.com/en-us/library/ms190960.aspx

Policy Based Management Security
http://sqlserver-qa.net/blogs/sql2008/archive/2009/02/23/4979.aspx
http://sqlserver-qa.net/blogs/sql2008/archive/2008/10/13/4895.aspx

Generic T-SQL Query Collector Type
http://technet.microsoft.com/en-us/library/bb630356.aspx

Max degree of Parallelism option
http://technet.microsoft.com/en-us/library/ms181007%28SQL.90%29.aspx

Ownership chains
http://msdn.microsoft.com/en-us/library/ms188676.aspx

Trustworthy database property
http://technet.microsoft.com/en-us/library/ms187861.aspx

Using Mirrored Backup Media Sets
http://msdn.microsoft.com/en-us/library/ms175053.aspx

Verifying backups
http://msdn.microsoft.com/en-us/library/ms189587.aspx

Considerations for restoring the model and msdb database
http://msdn.microsoft.com/en-us/library/ms190749.aspx

Resource Governor concepts
http://technet.microsoft.com/en-us/library/bb934084.aspx

Distributed Transactions
http://msdn.microsoft.com/en-us/library/ms188386.aspx

How it works SQL Server 2005 NUMA Basics
http://blogs.msdn.com/b/psssql/archive/2008/01/24/how-it-works-sql-server-2005-numa-basics.aspx

How to Configure SQL Server to use soft NUMA
http://msdn.microsoft.com/en-us/library/ms345357.aspx

Alter server configuration
http://msdn.microsoft.com/en-us/library/ee210585.aspx

Understanding how to set the sql server I/O Affinity Option
http://support.microsoft.com/kb/298402

How it works IO Affinity mask should I use it
http://blogs.msdn.com/b/psssql/archive/2010/11/19/how-it-works-io-affinity-mask-should-i-use-it.aspx

How it works soft NUMA I/O completion thread. lazy writer workers and memory nodes
http://blogs.msdn.com/b/psssql/archive/2010/04/02/how-it-works-soft-numa-i-o-completion-thread-lazy-writer-workers-and-memory-nodes.aspx

Filestream Design and Implementation Considerations
http://sqlcat.com/whitepapers/archive/2011/02/22/filestream-design-and-implementation-considerations.aspx

Introducing the sql server 2008 performance data collector
http://www.bradmcgehee.com/wp-content/uploads/presentations/Mastering%20the%20SQL%20Server%202008%20Performance%20Data%20Collector.pdf

No comments:

Post a Comment

Note: only a member of this blog may post a comment.