SQL Tips for novices

Before you ask, I definitely count myself as a novice when it comes to SQL. Nevertheless, here are a few SQL tips I have picked up along the way… Enable SQL to communicate through the Windows Firewall SQL Database netsh advfirewall firewall add rule name=SQLPort dir=in protocol=tcp action=allow localport=1433 remoteip=localsubnet profile=DOMAIN SQL Browser netsh advfirewall …