Category: code

Limit users who can log in using Remote Desktop

By default, all Administrators can log in to Remote Desktop. If you have multiple Administrator accounts on your computer, you should limit remote access only to those accounts that need it. If Remote Desktop is not used for system administration, remove all administrative access via RDP and only allow user accounts requiring RDP service. For Departments that manage many machines… Read more →

Tips for Sql query performance

The following are a list of good practices I follow when querying large sets of data. SELECT * Avoid selecting all columns from a table. Queries should explicitly list each column it requires Changing column definitions on the underlying tables can have an adverse effect on dependencies such as views, name clashes etc Avoid reading and returning unnecessary data Can… Read more →

How to download a nupkg file

You can download nupkg files by navigating directly to the url using the syntax: nuget.org/api/v2/package/<xyw> where <xyz> is the name of the package you are seeking e.g. nuget.org/api/v2/package/NuGet.CommandLine. You can also request earlier versions of the package by specifying the version in the url e.g. http://www.nuget.org/api/v2/package/NuGet.CommandLine/2.8.6/ Read more →