Check out http://blogs.technet.com/b/heyscriptingguy/archive/2011/05/02/use-powershell-to-report-sql-server-backup-status.aspx

Yes, but you need 1434 which is what SQL Browser listens on.

netsh firewall set portopening UDP 1434 "SQL Browser"

I would check that you also have UDP 1434 open through the firewall. This is required for the SQL Browser which gets used anytime you attempt to connect to a...

It might be worth checking that your SQL Service account has the ability to read attributes of Active Directory and therefore find users.

I would recommend you do a little investigation and look for scripts that check for long running jobs. I have no doubt there are some on this site. From there...

Truncating the log is very much a misnomer. As Jason states, the log is broken into smaller virtual log files (VLF) which are sized depending upon the initial size of...

dan-572483 (7/3/2012)

---

Nicholas,

Just curious, what are the specs on your laptop & VMs? I've thought about clustering VMs on my home computer for self-training purposes, but I'm concerned about...

You're far better off triaging the issue while the job is running slow. Look into issues around blocking, disk contention, page allocation problems in Tempdb.

What do the wait stats on the server show at the times when the job is running slow? Are you having blocking issues maybe?

With PowerShell you can get a count of rows in a flat file using

(Get-Content "file.txt").Count

You only have physical reads when SQL has to go and retrieve the data from disk. If the data is already in cache then you won't have any of those....

And if you mean build a cluster on a single machine by creating multiple virtual hosts (for testing purposes as you'd never want to do that in production) then the...

You are facing that the wrong way.

A cert should be based upon the information that you already know. You gain the experience and knowledge and then get the certification as...

Or use PowerShell http://sirsql.net/blog/2011/6/21/set-the-sql-tcpip-port-with-powershell.html

Or you could have two int and an xml or varchar(max) or varbinary(max) or text or image column. Each of those LOB columns can store up to 2GB of data...