I'll still stand that allowing someone to modify code on the server is a fundamental design flaw. It's reality, but it's a problem.

The live code is on the server, but...

If backup exec writes the backup time before it's finished, that's an issue. Certainly you might not be able to rely on this for restores at that point.

I think Idera,...

I'm sure that's my...

Edge has a number of issues, but it's such a low priority that we aren't spending significant time working around it.

sqlcmd -S servername -E -d Databasename -i c:\abc.sql -o c:\abc.txt

The first link on Medium works for me. If this is a problem, I'm not sure why. I don't think I've ever registered with Medium.

The Wall St Journal one works...

It shouldn't be an issue, but I'll have to check. This is a bit old and I'm not sure the last time it was updated.

I don't believe SQL is...

From a software engineering perspective, I think it's a design mistake. We are storing the source code along with the compiled code, when there's no reason to do so. We...

First, you'll need to allow either 1433 (not recommended) or another port that forwards to 1433 on the firewall. I wouldn't open 1433 since lots of bots scan that port....

I'm not completely sure what you mean here. Are you doing backups with SQL Server as "backup database mydb to disk = 'xx.bak'?

I'm assuming you do this for transaction logs...

There are also lots of scripts on this site in the script library[/url].

SQL Monitor from Redgate is fairly lightweight, and includes some baseline monitoring of things by default, but you can add new ones as needed.

http://www.red-gate.com/products/dba/sql-monitor/

disclosure, I work for Redgate.

You can...

Orlando Colamatteo (2/2/2016)

---

Andy Warren (2/2/2016)

---

I'm interested in the why. I like source control, use it all the time for code. Why isn't it used as naturally/often for the database? Is...

Robert, I'd...