I saw that error the other day. The messages started appearing in the sql server log across all servers. It resulted from a misconfiguration in the server side component of...

There is a lot of snake oil when it comes to the promotion of IoT, Big Data, and social media. It's the applications and the people behind them that have...

Unlike Google, FaceBook and Cambridge Analytica; most organizations are not in the business of stockpiling data. A restraunt chain or furniture manufactorer is not in the data business any more...

PRINT @@SERVERNAME to confirm you're connected to the correct server.

I believe that Big Data is to a large extent over-hyped. Storage and analytics software providers are kind of like the guys who were selling shovels during the California gold...

It would be helpful if the concept of assertions were introduced formally into the T-SQL programming language, not just for development purposes but also as a sanity check in production....

You can leverage the BINARY_CHECKSUM() function to hash a GUID into an INT. However, keep in mind that the cardinality of a 4 byte integer is significantly lower than a...

There is a trial version of Enterprise edition. Also, starting with SQL Server 2016, the Developer edition is free. Developer edition has all the features of Enterprise edition but is...

Of course what you're struggling with here is a denormalized table design, specifically a multi-part policy code column where attributes must be parsed at runtime. I wouldn't remove the original...