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...

More than a decade ago, I worked almost exclusively from home for a handful of years and would not consider it time well spent career wise. In organizations where most...

Regardless of what data warehousing tools you choose (if any); the majority of your human resource time will be spent gathering requirements, documenting requirements, team status meetings, troubleshooting source data...