I've worked at a software as a service company that faced the problem of one database for all their customers vs. separate database for each customer, and even though the...

I agree that you'll probably want to update DimEmployee daily.  I'd imagine that there are potentially other fact tables that would be able to take advantage of the data within...

Are your databases using the FULL recovery model?  In addition to taking full database backups nightly, you should be taking periodic transaction log backups:
https://technet.microsoft.com/en-us/library/ms190440(v=sql.105).aspx
A good place to...

Here's an example based on an application I worked on recently to maybe help you understand.  This just supported a small web application but similar ideas could be applied to...

I don't have quite that many SSIS packages, but I do follow a similar methodology, using SQL Server Agent to coordinate multiple related or dependent packages into one "job".  It...

In a number of places I've worked, the "database developers" have really just been ".Net developers" that also just happen to work on the databases too.  In this kind if...

unfortunately a limitation of SQL Agent alerts is that it will only send a notification if it is one of the "logged" errors:

SELECT

This could...

if you don't want to go the Azure route but still want to try SQL Server 2016, you can get the Developer Edition for free with a Visual Studio Dev...