Using profiler, extended events etc reveals what is being thrown at the DB but not how it is assembled.  How it is assembled is important because you need to know...

Google Dremel.  They are also quite active in developing artificial intelligence.

In an OLTP setting I would prefer stored procs.
In a data science/BI scenario it is a much more free-flowing environment so much wider ranging access is required.  I have...

The thing I like about Redgate Source Control is that it introduces a mechanism to put the data in smaller tables under source control as well.  This means that rebuilding...

If I have a password manager on my local workstation and its files are not stored in the cloud then surely the risk of using a password manager is low?

I think people are beginning to realise just how much damage malicious activity can do.   I think there is burgeoning awareness of what machine learning can reveal about individuals from...

I try and keep an open mind with new ideas, especially as some of those ideas are actually old ideas in a new context.

I find it useful to...

I think bcp could do with enhancements.  As a high speed import/export tool it has served me well.  The ability to handle parquet/Orc files would be fantastic.  Far more cross...

They have their uses but in my experience are rarely driven by requirements.  The ones I've seen tend to be massively over engineered and have been put in place by...