Viewing 15 posts - 13,801 through 13,815 (of 39,919 total)
GilaMonster (5/23/2012)
dwain.c (5/22/2012)Perhaps the next time someone asks a really silly SQL question, someone will suggest this to solve their problem:
EXEC xp_cmdshell 'format c:\'
No, because chances are someone (the OP...
May 23, 2012 at 9:28 am
richj-826679 (5/23/2012)
May 23, 2012 at 9:25 am
Your Name Here (5/23/2012)
Just about everything I know about PowerShell I've learned from writing scripts to automate a task.
That's a great tool, and a great feeling, I'm sure.
May 23, 2012 at 9:22 am
Frank Bazan (5/23/2012)
One thing that these tools will often lead to though, is a dulling of your core skills and situational awareness.
Very true. You should know how to do things,...
May 23, 2012 at 9:21 am
Wouldn't that be?
Mr or Mrs or Miss or Ms 500
Too long, and to be honest, didn't think about it. Plus, could you get to 500 home runs if you weren't...
May 23, 2012 at 9:11 am
SMTP is the protocol for sending mail.
SNMP is a network management protocol.
Database Mail will send across SMTP.
May 22, 2012 at 4:17 pm
You can integrate VCS with SQL Compare (also from Red Gate) to build a set of change scripts from source control.
May 22, 2012 at 2:47 pm
Gianluca Sartori (5/22/2012)
May 22, 2012 at 2:35 pm
I tend to be with Sean. I'd do this:
Table1
ID INT
more columns
Table2
ID INT
FKID INT
where I'd name the FKID something that makes sense.
Or more formally:
Create table Customers (
CustomerID int
, CustomerName...
May 22, 2012 at 11:59 am
Just an FYI, I tend to use semi-colons separately. Just for ease of editing and working.
alter database MyDb set read_only
;
go
select name
from sys.databases
where name not in ('master', 'msdb')
;
That way...
May 22, 2012 at 11:46 am
OK, some more details. Apparently we have everything:
VM Workstation
vCloud director
Lab Manager
SCVMM 2008
ESXi HyperVisors
OpenSack
Physical Machines - we have some of these.
The tools above are used in different areas for...
May 22, 2012 at 10:07 am
All VCS software is similar and works well for what we tend to do with SQL objects. However for the most part it's a manual process for the check-in/check-out.
If...
May 22, 2012 at 8:31 am
Replication.
Replicate out from the Reference db to the other dbs, moving those common objects.
May 21, 2012 at 5:12 pm
ankitb
We mostly use SCVMM at Red Gate, with the rare Hyper-V console management.
May 21, 2012 at 5:07 pm
Viewing 15 posts - 13,801 through 13,815 (of 39,919 total)