Well... a ton of logins might be the way to go. You need to isolate the security so that each thing, define thing, can only do the minimum needed to...

I have been aware of containers for quite a while and started to look into them several times now. The idea is to experiment in a small way, just...

Most businesses seem to be moving to, or have long been in, a hybrid situation with more than one database management system, some things in the cloud, some things local....

So, my current thought processes around this are simple (most of my thought processes are simple). Is the primary use of the data aggregations & large sets or is it...

This “little” problem is also the likely reason why about 80% of all my briefcase listings are now gone. They really need to...

These things spin up and shut down so fast that they don’t exist long enough to hack even if they contained something to hack and for most apps they...

If you truly need 5 9s of up time, the hardware is still out there and available. I was talking to someone last week who had the need for a...

What problem are you trying to solve? It's very hard to understand which solution is better when we don't have a clue what problem the solution is solving.

I work for Redgate, so I'm VERY biased, however...

I agree with @crow1969. It's not the exact solution you're looking for. It only catches certain code smells, but it...

Do not upgrade to 2014 if you can absolutely avoid it. The issue is that 2014 introduces a new cardinality estimation engine. However, it doesn't introduce any tools to deal...

It'll do the job. It's not how I'd do it. I would capture the metrics through extended events. The reason for this is, depending on where you run it and...

This is not a homework service. We'll help. We won't do all the work. Try it. Tell us where you get stuck. Show your work. We'll help you fix it...

Without the structure and the execution plan, I'm guessing here.

Yes, if you're trying to squeeze more performance, a covering index may be the way to go.