CScript and RunAsAdmin

February 4, 2013

I had written a script a while back which would set the TCP/IP port for a SQL Server instance. Before …

What IP are you listening on SQL

January 30, 2012

This is probably the easiest question to answer for any SQL Server DBA. And this is one of those scenarios …

September 15, 2010

A reply to a Tweet on #sqlhelp prompted me to look this up. The question was on finding out the …

April 8, 2010

I had previously blogged on how to change the password of SQL Server 2005 and SQL Server 2000 instances using …

March 19, 2010

I have had multiple questions on how to enumerate SQL instances in your complete environment to run maintenance operations from …