Friday, March 19, 2010

Windows Powershell

Last few days I spent most of the time on my personal development to learn and understand about Windows Powershell; Microsoft new scripting language. I’ve not being used any scripting language extensively. But now I understand how much power will bring to a DBA by learning this kind of a scripting language. 

You may be thinking why do you need a scripting language while having most powerful user friendly GUIs in Windows. Ok. I also thought the same way before I learning Powershell.
There are couple of reasons why you should use Powershell. I’m sure there are many more;

Friday, March 12, 2010

Configure Windows Firewall for SQL Server 2008

You will find this article very useful if your planing to install SQL Server 2008 on Windows 2008 server. Once you have installed SQL Server and if you try to log into the server remotely, it will fail. I too have faced this issue recently. Configuration of Windows Firewall comes into action at this time. 

How to interpret Disk Latency

I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...