This is a pretty good article on DNS Doctoring:

This is a pretty good article on DNS Doctoring:

http://secret-epedemiology-statistic.org.ua/1587052091/ch05lev1sec7.html

How-to Add a SQL Server SPN

From a command prompt, enter the following:

To create an SPN for the NetBIOS name of the SQL Server use the following command:
setspn -A MSSQLSvc/{SQL Server computer name}:1433 {Domain\Account} 

To create an SPN for the FQDN of the SQL Server use the following command:
setspn -A MSSQLSvc/{SQL Server FQDN}:1433 <Domain\Account>

Testing for AD Replication Issues

Run this command from a command prompt to find replication issues in a formatted table form.

repadmin /replsum /bysrc /bydest /sort:delta

Find System Uptime from Command Line

To find the system uptime, you can use this simple command from a command prompt.  It uses SystemInfo to find the last System Boot Time.

systeminfo | find "System Boot Time:"

How do I find the Domain Controllers for a domain a server is joined to?

1. Start -> Run -> nslookup   
2. set type=all
3. _ldap._tcp.dc._msdcs.DOMAIN_NAME

Replace DOMAIN_NAME with actual domain name