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

If you can, use Windows Auth for your apps. No major flaws reported, and it can be secured well.

OAuth is another: http://oauth.net/

If you need to build something else into an...

Sean Redmond (2/2/2016)

---

Hi Steve,

On the other hand, for my day-to-day work, I don't do this. I'm not often at my home computer and others use it too. I prefer the...

mike.gallamore (2/2/2016)

---

Rocket science always makes me laugh. It's turtles all the way down of course so you can always get more and more detailed. But the basic physics of rocket...

I don't think you can do this in a single statement. I might be wrong, but I suspect you could drop the results into a temp table, then query that...

I'm in agreement with most people that changes should go through development. I agree nothing should happen on production. I think that the true version of your code is what's...