Back in my direct mail days it was standard practise to put seed names and addresses into customer lists so that we could tell if our list was being used...

So much of the internet depends on OpenSSL as we found with the Heart Bleed vulnerability. I don't think that OSS is any less or more secure. I've certainly seen...

SQL Slammer hit a lot of stuff behind the firewall.  All it took was one exposed MSDE machine inside the network and it sprawled across the SQL Servers within the...

When building a Hadoop stack we ran into a lot of problems with different versions of the components not talking to each other.  That is why Hortonworks, Cloudera and MapR...

http://www.sqlservercentral.com/stairway/105855/ dispels...

The examples are on a clustered index.  Try it on a non-clustered index and also on an unindexed column.

When transitioning to a code review regime it is important to look at what works and what doesn't. The code review is to improve code but you also have to...

http://www.sqlservercentral.com/stairway/105855/ answered a lot of concerns for me.
The gap for me was the way that user defined aggregates worked. http://www.sqlservercentral.com/articles/SQLCLR/71942/
I had hoped to make a lot of...

If you understand the limitations of table variables then you have a tool you understand. You will understand when they will cause problems and when they won't. I don't shy...

I am not optimistic.  Shadow IT presents immense risk from a data security and compliance perspective.  The problem is that Shadow IT is often sanctioned by people with spending authority...

Wait until i write up the experiment for which I went to all this trouble to build these functions.  All will become clear