Azure files

2016-06-11 Thread Greg Keogh
Is anyone here using Azure files and mounting shares are drive letters? I ask because this feature could be a great way of migrating one of our legacy apps into Azure. Web searches hint that you both can and can't map an Azure file share as a drive on your desktop PC. Some say that Windows 10 suppo

Re: Azure files

2016-06-11 Thread David Connors
It is for use within azure only. You can attach the shares to VMs. It also has a lot of other caveats re single identity to connect to it so no acls etc. On Sun, 12 Jun 2016, 9:18 AM Greg Keogh wrote: > Is anyone here using Azure files and mounting shares are drive letters? I > ask because this

Re: Azure files

2016-06-11 Thread Greg Keogh
> > It is for use within azure only. You can attach the shares to VMs. It also > has a lot of other caveats re single identity to connect to it so no acls > etc. > Thanks for confirming that, which I suspected. There are many web pages where people do suggest that you can mount the shares on your d

SQL Server Collation

2016-06-11 Thread Greg Keogh
I'm installing SQL Server 2016 Express for the first time to try it out. It's asking me for a default collation and its default is Latin1_General_Cl_AS. Is this a good default, or are there better choices? I know it might be a complicated argument. I thought I'd check first with the SQL boffins in

RE: SQL Server Collation

2016-06-11 Thread 罗格雷格博士
The SQL collations are only there for backwards compatibility and should have stopped being the default many versions ago. We always teach admins to use the Windows collations (ie: ones without a SQL prefix) rather than the SQL collations. Now that Latin1_General_CI_AS has become the default, I