Good article, Steve. Here's my $0.02 worth. I think adopting new technologies is more than whether or not you can add it, want to experiment with it, etc. Often its...

I'll try the Import Wizard for SQL Express.

OK, I've made a little progress. When I looked at the data I saw that the first line had the column names in it. I don't work much with CSV...

How do I find that out?

I finally figured out that I could get to the Import and Export Data app from the SQL Server 2012 programs on my PC. I've exported the table I want...

Miles Neale (5/7/2014)

---

Read it, Loved it, and have only one complex thought. If the manager is not technical that manager must listen and understand when the Tech Professional describes...

That quote by David Lee Roth is very good.

WOW, Steve, great post! There's a lot I could say, relevant to what you said, but I don't think it would necessarily be a good thing to say. I'll just...

Steve, I agree with your article, but with the caveat that I agree mainly in principle. I've been in my current job for many years. It wasn't what I wanted,...

Ah, that makes sense, Keith, thank you.

And sorry that I didn't post the table definitions as well as some data, to get a feel for what the query would likely...

Hi Luis,

I like your two solutions. Especially the first one, which I take to be an example of using a common table expression. I've heard of CTE's, but have never...

I've never heard of sp_WhoIsActive. I've done a quick search and found some information on it. I've downloaded it, too, but WOW, is the stored procedure big!

Markus (4/1/2014)

---

I guess it depends on when you say you have Mgt Studio open... are you just connected or did you have an open query or something?

I know if you...

When I run the batch file and redirect it's output, the first thing I see is this:

The contents of the output.txt file are...

sreekanth bandarla (3/11/2014)

---

I think, That's where you are having issues with. Type it manually and let me know how it goes...

syntax:

sqlcmd -S .\SQLEXPRESS -E -Q "EXEC master..sp_BackupDatabases @backupLocation='C:\SQLBackups\', @backupType='F'" -o...