the easiest way I've found to troubleshoot failed login attempts is to query the error log like:
EXEC xp_readerrorlog 0, 1, N'Login Failed';

I've always told people that half of my job is trying to get the technology to do what it's supposed to do!  Of course the other half is trying to figure...

I tend to paste everything into Notepad and then copy and paste it into the forums from there.  I've seen it do strange things even if I'm copying and pasting...

Do you compress the tables in your staging area?  I've seen some significant space savings using PAGE level compression on the tables in our data warehouse staging area, ranging anywhere...

It definitely makes sense to have some sort of offsite copy of your backups, will be useful for disaster recovery scenarios.

how reliable and fast is your connection to AWS?  It seems like that could be a liability in directly storing backups there.  To make sure backups run fast, I'd store...

OK maybe I oversimplified, technically Windows does start using the page file before all physical memory is used up.  The main point I was trying to make is that SQL...

I'd agree with Luis on this.  Looking at the execution plan, everything is a table scan which tells me there's no clustered indexes, everything is a heap with all the...

Are you trying to discover what computers on your local network have SQL Server installed on them?  Then maybe you could use something like this free tool from Idera: