I rarely ever think about what I would do if I won a multi-million dollar lottery. The probability that I would die in a car crash before the year ends...

Typically you will start by loading data from either a flat file or a SQL query from a source database into a flat staging table (ColumnStore is good for this)....

I'm currently happy in my work, broadly speaking, but I know a lot of folks aren't. But don't just play the cards you're initially given; whether or not you're happy...

So, this would be a scenario where you need to merge from a source table to a target table, but the source database is non-SQL Server? On the source table,...

If they insist on having a login to the 'SA' account, then you can play the role of a malicious genie by renaming the original SA account and then creating...

Another way to gently remind your coworker about the dangers of leaving PC unlocked is to add the following URL redirects to their '%windir%\System32\drivers\etc\hosts' file. 

RateMyPoo.com   google.com
RateMyPoo.com  ...

If you don't really know T-SQL programming or database design / tuning, then even a moderately sized database (ie: 100 GB) is going to seem like Big Data (at least...