You mean human beings accessing accounts they shouldn't using tools the shouldn't be using in a manner that has not been authorised?  There is legitimate monitoring software to provide governance...

I heard Simon Munroe's presentation when SQL Bits was held in Westminster.  At the time I asked if NOSQL should really be NORDBMS and was told no.  Now that so...

I find that ORMs are like all tools.  Used properly they work as intended.  I've only seen them used properly in demonstrations, never in real life.

I always think...

I got on fine with SSMS.  I disliked having to skip across to BIDS to do stuff.  I meant to use the Red-Gate SSMS plug-in project to see if I could...

I work with a number of databases and also database tools.  Some expect a semi-colon terminator, others don't.

One of the reasons that the NOSQL crowd started adopting a...

I just say I program computers for 'x' and turn the conversation back to their interests.

It depends entirely on the use case.
If you have a dimensional data mart then it's probably heavily denormalised
For systems such as SAS analytics they thrive on heavily denormalised...

I've just got back from a 2 week cruise around Scotland, Iceland and Ireland.  I deliberately didn't take any form of electronic device, didn't watch the news, avoided the onboard...

This article on using npm packages to steal data pretty much sums up the risks.  I believe the techniques used in the article have recently been

I find a lot of business requirements for data involve testing and experimentation.  They don't know what they don't know and want to explore the data.  They are not yet...

My experience has been that data and data objects are retained so long that there is fear and doubt as to whether they can be deprecated or purged.  Similarly applications...

When I think of schemaless data I think of data persisted to a storage medium where that storage medium has no concept of a schema.  It is the responsibility of...