Sorry, SQLSophist, this slipped through the cracks.

Please take it if you want.

How about two child packages that do

- load a simple file (assume an Excel file, simple format, same name,...

sebmr2 (5/18/2012)

---

All in all, this has worked well for us. Only problem is it leaves a physical copy of the password in the hands of the developer which may not...

TravisDBA (5/18/2012)

---

I also use KeePass2. It generates very strong passwords for me and I can safely store them in KeePass as well and I always have them in case someone...

baxterr (5/18/2012)

---

Generally, I do my best to never let a SQL login have any sort of elevated privs on a database let alone the server. We still have one...

My apologies.

BULK INSERT is a T-SQL command that essentially does what the command line tool, bcp, does.

BCP - http://msdn.microsoft.com/en-us/library/ms162802.aspx

When in doubt, pop open books online and search. The www version...

I see the WMI query article and I'll get to it. Right now I have 16 in queue, up from 8 on Monday, and I went through 4 this week....

It's just a default setting. SQL Server puts the default port for the "default" instance at 1433. For any named instance, regardless of whether it's the first or second installation...

You can run BCP without a format file and it will help you create one, guessing at the columns.

Why am I not surprised.

LOL, I always use Apr 1 for my birthday. Get lots of well wishes...

Backup compression isn't available in every edition of SQL Server.

The CPU cost is the main thing, and it's not horrible, but it depends on when you do it and...

SQL Kiwi (5/17/2012)

---

Steve Jones - SSC Editor (5/17/2012)

---

Zip, gender, birthdate gets some crazy % identified, or closely identified. Add in one other thing and I think it gets to like...

You shouldn't have to explicitly. It does have to be open, but if you just ran this, then the SMK should automatically open it.

If this is all your code,...

Short answer: my boss wanted the StackExchange style forums on the site

Long Answer: my boss made us implement the StackExchange style Q&A, which I think has merits. As Grant, Lynn,...

I use WordPress.com at http://www.voiceofthedba.com

1. Used the Titan theme from Theme Foundary. Didn't spend a lot of time looking around though. After seeing 5 or 10, my eyes start to...