.. Finally we get to cost. Linux gets adopted a lot because it’s free. I looked on Azure at the time I wrote this and a D15 v2 instance...

As database professionals we should not feel obliged to "toe the line" or "jump on the bandwagon" when it comes to IoT, Social Media, or even Big Data. Other professions...

The index process may not be slow but rather stalled in some type of blocked state. Use SP_WHO2 while it's running to confirm.

For traditional RowStore tables, it depends on the column definition, data types, and other factors like compression, page fill, and fragmentation. I once say a table with only about 150,000...

From a performance, security, usability, and maintainability perspective; stored procedures clearly have an advantage over embedded or ad-hoc SQL. My approach to answering this questions would be to think of...

Back in the early 2000's, many of us were still using Windows Remote Desktop across a 56 Kbps dial-up modem connection, but what constitutes a slow internet connection today is...

Transactions represents your user table which I'm loading with mockup rows.

This situation about the VCS database not getting backed up properly; I suspect that's common. The problem is that for many organizations the VCS is not treated with the same...

I believe there is a huge potential for the Internet Of Things to revolutionize industries like: weather prediction, land management, transportation, and healthcare (chronic condition monitoring). I'd love to be...