Agreed. Elasticity rather than cost is very often the clincher when it comes to cloud. But whether cloud or on-prem it seems to me that most of the...

However, while that is certainly true and very valuable to companies of that size, most companies will never come close to needing the requirements that Amazon, EBay, and...

I check almost everything I can think of every day.

we used to call it a daily health check.

Every day I add a new check to the job and export the...

all of the important innovations in data management over the last 6-10 years have happened outside the core "SQL DBMS" space. I suspect that will continue to be the...

lol.....

It is because they are successful. DBA aren’t skillful enough to take it to that level and develop an installer or whatever is needed so they are no longer...

I know it sounds simple, but I use Amazon AWS and Azure servers for my home lab

I Have a work provided MSDN and Amazon account. I can log on using...

Once the system is in production, it becomes very hard to change anything, from security to code, without lots of testing and approvals. I find that often trying to work...

if you set your profiler trace to write to a table rather than a file but don't execute it, ...just script it out

once you create the trace in script form...

profiler might be better for this since you want the sql text

i'm assuming it's a data change not a structure change you are auditing? if it's a structure (DDL) change...

I've found with Transactional replications I've measured our on premise database in England replicated to an azure database in Ireland at normally 6 seconds

1-2 seconds from publisher to distributor and...

I tried this once using mirroring with snapshots... the report started the snapshot which worked really well.

except.... we had to run 2 16 core enterprise editions.  (you couldn't run the...

for 20 seconds latency I cannot see anything but transactional replication working....

Grant - feel free to give me another option as I'm out of ideas for a system to get...

That something compiles or does not throw a syntax error is hardly the same thing as unit testing.  That is the bare minimum lazy developers do to say...

Excellent post, Steve.  What we need now is someone that's an expert in QA or an expert system designer to provide people that write requirements with knowledge and techniques...