You can't make a .bak file at SQL Server 2012 and expect to restore it in SQL Server 2008.

You could migrate from the existing database to an empty database with Red Gate SQL Data Compare however.

When you cannot ping into a new VMware VM...

try setting the "Network Adapter" setting for the VM at the left nav to "Bridged"

When adding a NOT NULL column to a database table...

...expect your app to break. The logic for doing inserts into such a table needs love.

When you cannot open a file share on the network from a VMware VM...

Try the following command line command:

net use \\abc123\whatever

 
 

Then, try again.

Turn off automatic updating of Windows.

Type "Update" at the Start Menu and then pick "Change Settings" at the left of the box which appears. This seemed applicable in Windows Server 2008 R2. I don't seem to have the actual administrative privileges to make the change however.

SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Database Mail XPs' by using sp_configure. For more information about enabling 'Database Mail XPs', search for 'Database Mail XPs' in SQL Server Books Online.

To get around this goofy gremlin in SSMS, open the Object Explorer and expand "Management." You will see "Database Mail" inside and if you right-click upon it and pick "Configure Database Mail" you will be allowed to walk through a wizard to set up an email account. This has a more verbose explanation of the same thing.

console.log("foo", "bar", "baz", "qux");

Adding extra parameters to console.log in JavaScript will just ask it to log extra things. All of the things logged will appear horizontally on the same line sequentially as they were handed in with a single space between each item like so:

foo bar baz qux