In the code world, an index could still be a source file that is part of the source system when compiled and or executed as part of the application. Therefore,...

I for sure am loving the Azure platform. I've obviously mentioned it many times over in other threads, but just to emphasize some more, I've fully migrated to Azure Data...

In the data warehouse side, it makes sense to use surrogate keys and replace all natural keys. I don't really deal with PII data, but even in cases where I...

Maybe it's too early for me being I just woke up, but you can put as many Azure SQL Databases on the calculator as you want in meaning, you aren't...

Had this exact same argument with a friend on Facebook like two days ago. He honestly said A) MongoDB is amazing and B) all of this should live in the...

I use Python with Linux for SQL Server. This is where I just install pymssql module with Python 2.7 and connect directly to the server.

http://www.pymssql.org/en/stable/

I'm using pretty much Power BI for the the visualization side. It's a pretty good tool and has an in-memory engine that helps keep the data stored in bulk as...

I guess in a perfect world, you would have a operational database that functions as the main source for the application. In your case, this would be a normalized database...