Been working a lot with Azure Data Warehouse, so knew this one pretty easy.

I surely choose ROUND_ROBIN a lot for a number of tables where I just don't...

Likely something in video gaming like I was doing prior to what I'm doing today. I'm only in data because of accidental reasons, then I fell in love.

I think it's pretty straight forward, but unfortunately, a lot of companies blur the lines because of resource issues. In meaning, the DBA still gets stuck with all the developer...

I agree with Phil.

You're getting too hung up on the fact that the data from each customer is being used for the same business case. You're treating it...

I'm sure others more familiar with SSIS and Excel could help more.

But for an alternative, I normally use Python for such tasks because it allows you to load...

I feel that data structure and scalability will be the prime areas for most of us who will work in these areas. For example, being able to computate billions of...

I for one enjoy style guides that address common optimization areas that people forget are overlook due to lazyness. I have not had the opportunity to create one for SQL,...

Almost all of my database related interviews have been the same typical questions and trick questions about functions, indexing, backups, and so forth. More or less looking to know if...

WITH Rows AS
(
     SELECT *, ROW_NUMBER() OVER (PARTITION BY BINARY_CHECKSUM(*) ORDER BY BINARY_CHECKSUM(*)) AS [Count]
     FROM Table
)
     DELETE...

I absolutely love my Lenovo Yoga Pro (Tablet/Laptop). It's been my machine for the past 3 years now at work. Slim, silver, beast.

The idea of dumping and pumping data right into a visualization at the speed of some of these platforms is pretty appealing (at least to analytics who are constantly shifting...