Query SQL Server Version

select
SERVERPROPERTY('ProductVersion') as ProductVersion,
SERVERPROPERTY('ProductLevel') as ProductLevel,
SERVERPROPERTY('Edition') as Edition

Windows Mobile Device Center no longer works after Creator's Edition in Win10

https://www.youtube.com/watch?v=VHI4dwVbGbI

Server 2012 RDS ‘there are no Remote Desktop License Servers available to provide a license.’

http://www.stopdoingitwrong.co.uk/server-2012-rds-there-are-no-remote-desktop-license-servers/

You verify your configuration is as expected, that you have valid CALs installed on a Server 2012 terminal server licensing server and that the RD Licensing Diagnoser doesn’t report any errors.

The issue may be that there is a bug with Server 2012 RDS session hosts where they will not look to the licensing server for CALs when the grace period ends. Microsoft are reportedly aware of this but as yet there is no KBA or hotfix for it.

The solution is to open the registry editor on the affected session hosts and browse to the following:

HKLM\System\CurrentControlSet\Control\Terminal Server\RCM

If the ‘GracePeriod’ key exists you will need to delete it.

How can an unauthenticated user access a windows share?

http://serverfault.com/questions/51635/how-can-an-unauthenticated-user-access-a-windows-share

In my case, enabling the guest account and adding Everyone did not help (with a share on an older box with Windows Server 2008 SP2 in a domain and a Windows Server 2012 R2 machine from outside of the domain). After following the excellent guide posted by Nikola Radosavljevic, anonymous access finally worked in my scenario. Summary of steps: Adding Everyone, Guest and ANONYMOUS LOGON to the permissions of the share. Open the Group Policy Editor (e.g. by running gpedit.msc) Computer Configuration -> Windows Settings -> Security Settings -> Local Policies -> Security Options Accounts: Guest account status: Enabled Network access: Let Everyone permissions apply to anonymous users: Enabled Network access: Restrict anonymous access to Named Pipes and Shares: Disabled Network access: Shares that can be accessed anonymously: YOUR_SHARE_NAME

Windows 10 Cannot Access SMB Network

1. https://www.itechtics.com/enable-gpedit-windows-10-home/



2. https://techjourney.net/cannot-connect-to-cifs-smb-samba-network-shares-shared-folders-in-windows-10/

SQL data Type to C# data Type

http://stackoverflow.com/questions/425389/c-sharp-equivalent-of-sql-server-datatypes

SQL CLR types for Report Viewer 2012 -Error

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

http://serverfault.com/questions/465722/install-sql-clr-types-report-viewer-2012-on-sql-2008-server