sorry, that proc is huge and references views which have functions etc...

that was the first thing I tried

In my place of work we have "internal customers"

our departments cross charge each other (it makes no sense to me) but our marketing team have a budget that they can...

I don't think that you can get a 1 minute diagnosis on a newish system.

Even the best of us get surprised by  the way things manage to go wrong...

I love SQL compare - but we need the SDK back...I used it in 1 company to compare our release code to 200 servers (casino memberships) to ensure all code...

Thanks Grant - that was my suspicion

is there any way to get this parameterised without shouting at 40 developers and the entire team at Microsoft that built MS Access?

Thanks for the article. 1 Trillion rows caught my attention. How would you compare and RDBMS row to a NoSQL row. Can I consider a NoSQL "row" as a...

thanks for the correction … my bad

interesting - and majorly worrying

quite a few are based around facial recognition.

some of what we do is eye tracking for adverts (for example percentage of people who look up at...

I'd avoid the trigger

just based on the fact that it will fire (even if it does nothing) on every modification action to the data on that table  (depending on how...

I can give a really good example of why "well written" unit tests are valuable.... it's not about new code

imagine you have a table of people and there is a...

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