Last Updated on 4th October 2010 1:30 p.m.
This page contains all the useful url references and resources that have been used as reference material for my presentations. If you have attended any presentations I have given, then please check them out since they may be of use to you as supporting material.
Presentation given at SQLBits 7
“Thinking outside the Box. Learning a little about a lot” URL References
Becoming a DBA 2.5
Generalizing Specialists: Improving Your IT Career Skills
DBA 2.0 by Joel Goodman and Harald van Breederode
Virtual Oracle DBA 2.0
Resources for the accidental DBA
Accidental DBA – Paul Randal, Kimberly Tripp
SQL Server Enterprise name resolution strategies
Related to DNS redirection :-
How DNS query works
How DNS Works
TCP/IP Fundamentals for Microsoft Windows – Host Name Resolution
Related to DNS/ Kerberos redirection issues (mentioned in my session) :-
Understanding Kerberos and NTLM authentication in SQL Server Connections
“Cannot Generate SSPI Context” error message, more comments for SQL Server
SQL Linked Server Query failed with “Login failed for user …”
SQL Server 2005 connectivity error messages
Error 18452 / Login failed The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
Login failed. (Microsoft SQL Server, Error: 18452)
How to troubleshoot the “Cannot generate SSPI context” error message
Related to Application based Connection String redirection :-
SqlConnection.ConnectionString Property
Related to Database Mirroring redirection :-
How to: Remove Database Mirroring (Transact-SQL)
ALTER DATABASE Database Mirroring (Transact-SQL)
Related to Native Client redirection :-
How to: Set a SQL Server Alias (SQL Server Management Studio)
SQL Server Configuration Manager
Troubleshooting: Timeout Expired
Configuring How Often to Update Group Policy Security Settings
Group Policy Resources
How to create a custom ADM template?
How do I setup a simple port forward on Windows Server 2003?
Connecting to SQL Server over the Internet
Inside ADM and ADMX Templates for Group Policy
Creating Custom ADM Templates
How to add, modify, or delete registry subkeys and values by using a registration entries (.reg) file
Distributing Registry Changes
Other
Connecting to an Instance of SQL Server
Create your own private VSAN & VCluster :-
What Is a Storage Area Network
How do I… Install, configure, and use Microsoft’s iSCSI initiator?
iSCSI Cluster Support: Frequently Asked Questions
How to: Create a New SQL Server Failover Cluster (Setup)
Failover Cluster Step-by-Step Guide: Configuring a Two-Node File Server Failover Cluster
MS Cluster Server Troubleshooting and Maintenance
Virtual Server Host Clustering Step-by-Step Guide for Virtual Server 2005 R2
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1
Setup Microsoft Windows 2008 R2 Failover Cluster in VMware Workstation
Fail Instances between separate Clusters :-
Windows 2008/ Windows 2008 R2 CNO Recovery
Recovering Active Directory Domain Services
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
Recovering Deleted Items in Active Directory
How to create a Windows Server 2008 Cluster within Hyper-V using simulated iSCSI storage
Use the CLR to manage the OS from SQL :-
fn_fixeddrives() : an alternative for xp_fixeddrives – this is an alternative to my implementation.
Using the CLR from SQL Server 2005/ 2008
Understanding CLR Integration in SQL Server 2005
CLR Integration Programming Model Restrictions
Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
SQL #
Creating SQL Server User-Defined Functions
Creating SMO Programs
SQL Server Management Objects (SMO)
