Visual Studio 2017 | Start every solution from the jump list as Administrator

Even if you add the setting to start VS2017 as ad Administrator, it doesn’t do that when accessing solutions from the jump list. To get that going, you need to add a registry key, which is fairly straightforward.

Due to WordPress security reasons, I can’t upload the file here, so just go ahead and create a Registration Entries file (.reg) using the content below and run it as admin… simple!

NOTE: For x64 and other versions of Visual Studio, modify the path name accordingly.

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers]
"C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\Professional\\Common7\\IDE\\devenv.exe"="~ RUNASADMIN"

 

SQL | Find all tables that have varbinary datatype (or any data type)

This came in handy when I had to find all the tables in a database that had ‘varbinary’ datatype columns. You can replace the ‘varbinary’ text to find any type you are looking for.

SELECT 
      table_name [Table Name], column_name [Column Name]
FROM 
      information_schema.columns 
WHERE 
      DATA_TYPE  = 'varbinary'

Twitter Bootstrap Modal immediately disappearing issue

If you face a  problem where, as soon as you click on the button for a modal popup, the modal fades in and then immediately disappears, then the problem is because this is typical behaviour for loading the Modal plugin JavaScript twice. Please check to make sure that you have either bootstrap.js OR bootstrap-modal.js, but not both. The former includes the latter.