Tag: SQL server

TechEd: SQL Virtualization and Management Best Practices (MDC-B328)

June 4, 2013

This session focused on how to manage a virtualized SQL workload with system center. By using VMM, Operations Manager, and other SC components, you can automate, monitor, and easily deploy new SQL instances in a cookie cutter manner. This session applies to you whether you use VMware or Hyper-V hypervisors....

Scripting SQL Server Firewall Rules

February 15, 2010

On servers that are running Windows server 2008 or later, you can take advantage of the built-in two-way firewall. SQL server firewall rules can be pretty easily created through the GUI, but it can be a bit tedious. So I wrote a little batch file that asks you for an IP...