Ray K (5/18/2012)

---

Been quiet here lately! How about we stir up the pot?

Let's see . . . how about the following hypothetical situation . . .

You're the manager....

Not 1999?

("we're gonna party like...

Hmm, I thought that Compare would work against a script. I see an option against source control, which doesn't help, but you can compare against a backup.

If you copied your...

The load would be when your backups run on the primary. What is the workload like?

Check basic perfmon (CPU, pages/sec, disk IO) while people are working, and then when...

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...