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

Multi Server Administration Poster

Details about the configuration of Multi Server Management for looking the the health resources of SQL Servers.

Performance Data Collection Poster

A summary of the key features

Policy Based Management Poster

A summary of the key requirement.

Central Mangement Server Poster

A summary of functionality.

 

The Complex Interactions of Database Systems

Research Event: Tuesday 14 June 2011
Presentation Abstract:

This presentation provides an insight into my research field of interest which is focused upon the complex interactions of database systems. It draws together details from the current technical and non technical field and the findings from conducting a literature review. There is lack of research in the specific field of study which crosses multiple field boundaries.

Relational database systems have expanded to include large volumes of structured and unstructured data; there has been a rapid change in usage, demand for data, information and knowledge.  Database administrators need to manage technical components to respond to requirements with influence from many areas including cultural, economic, political etc. This led to research questions into a system of interest which could benefit the industry as a whole.

The sequential mixed methods design is to be used to investigate how the interaction of complex systems affects the management of database systems. An aim of this research is to gain an understanding of how improvement and innovation could emerge from database management systems.

Wordle Word Clouds