Tuesday, April 15, 2014

SQL Server Agent Job and SQLCMD

Have you ever encountered missing database backup or maintenance plan didn't complete as it was scheduled, especially error was encountered? This post discusses a behavior difference between SQL Server agent using T-SQL type and SQLCMD with CmdExec type.

Tuesday, April 1, 2014

SQL Server 2014 RTM Release!

Microsoft releases SQL Server 2014 RTM to public today! Yes, it's April Fool day, I know what you thinking but this is real. This post discuss different ways of getting the software.

Tuesday, March 25, 2014

Use PowerShell To Test Port

There are times when we need to identify or troubleshoot if firewall exception is configured correctly and the desired remote server port is open. Often time, I have seen IT Professional use Telnet or PuTTY to test. However, there is another way to do it with PowerShell.

Monday, March 24, 2014

PowerShell Cim Cmdlet to PowerShell 2.0 or older

Starting in PowerShell 3.0, Microsoft introduces a new set of cmdlets to manage servers or devices that complies to DMTF standards. These new set of cmdlets, CIM (Common Information Model (CIM) Cmdlets allow IT professional to better manage their data center especially when it consists of servers from different vendors.

Friday, March 21, 2014

Enable PowerShell Double-Hop Remoting

When working with PowerShell, there are cases when there is a need to remote into a computer with PowerShell session and perform tasks against another computer. These are some of the typical double hop scenario common in PowerShell.