Facebook – Not Getting Chrome Notifications

Some documentation states to enter m.facebook.com and when the popup box comes up to allow notifications, click Allow. I have done that, and it still doesn’t work. Here is how I fixed it.

If entering m.facebook.com doesn’t bring up the popup to allow notifications, then enter the following:
Hopefully, this will fix it for you as it did for me.

Google Chrome – Open Dialog Box cause Chrome to Freeze or Crashes

Lately, for me, Chrome freezes immediately after opening the ‘Open Dialog Box’ when attempting to attach a file to an email or during the process of attaching the file to an email. This can happen in any web application using Chrome when using the ‘Open Dialog Box’ (And possibly the ‘Save Dialog Box’.

I have found (for me) that turning off Hardware Acceleration in Chrome fixes the problem.

Google Chrome
 
1) Click Settings
2) Scroll to the bottom and click Advanced Settings.
3) Under the ‘System’ section, turn off ‘Use hardware acceleration when available’.
4) Relaunch Chrome.

WordPress – Remove Email and URL in Comment Section, and Add Plugin to Remove Hyperlink from URL Placed in Comment Textbox

  1. In the Discussion Settings, uncheck the checkbox that states “Comment author must fill out name and email”.

2) Edit the function.php file in your File editor and add the three functions to the bottom of the php file shown in the image below:

// Add this function to functions.php to remove the url from the comments section
function crunchify_disable_comment_url($fields) { 
 unset($fields['url']);
 return $fields;
}
add_filter('comment_form_default_fields','crunchify_disable_comment_url');

// Add this function to functions.php to remove the email from the comments section
function crunchify_disable_comment_email($fields) { 
 unset($fields['email']);
 return $fields;
}
add_filter('comment_form_default_fields','crunchify_disable_comment_email');

// Add this function to functions.php to remove text below the Leave a Reply title
function custom_comment_form_defaults($defaults){
 $defaults['comment_notes_before'] = '';
 return $defaults;
}
add_filter( 'comment_form_defaults', 'custom_comment_form_defaults' );

3) Add a plugin called “Comment Link Remove”.

4) Edit the options of the Comment Link Remove settings by checking the checkboxes for “Remove hyper-link from comment AUTHOR”, and “Disable turning URLs into hyper-links in comments”

Plugins – iThemes Security – How to enable/disable the file editor (to edit WordPress php files)

With the iThemes Security plugin, there is an option to turn off the php Editor.

In the Dashboard, click Security, then Settings in the far left column.

Under WordPress Tweaks, click the Configure Settings button

Check or Uncheck the Disable File Editor checkbox.

Once disabled, the Editor sub menu is now gone.

Microsoft Visual Studio – How to Delete rdl.data Files in BIDS

An rdl.data file will be created each time when the report is viewed with different input parameters. The data file caches the data so running the report again in the IDE with no changes to the parameter data will render quickly.

To delete the files, add an external tool to Visual Studio that you can execute to delete all rdl.data files.

#1 Click Tools and then External Tools…
#2 If tools already exist, click the Add button, else go to step 3.
#3 Enter the following into the provided textboxes and click OK.

#4 At any time while in a BIDS Visual Studio Solution, click Tools and then ‘Clear Report Data Cache’ to delete the files.

Windows 10: Windows Update Error or Loop

Download and install the Windows Update Troubleshooter from Microsoft that will fix your Windows Update issues:

https://support.microsoft.com/en-ph/help/4027322/windows-windows-update-troubleshooter

If that fails, you can always delete the downloaded files and start over.

(From Microsoft):

Whenever Windows updates website scans and install any updates or patches, it gets stored on the below location.
%windir%\softwaredistribution\download

Depending upon the updates different folders gets created on the above location.

For clearing the contents of the softwaredistribution folder, try the below commands on the command prompt.

net stop wuauserv
rmdir %windir%\softwaredistribution  /s /q
net start wuauserv

exit

Microsoft Visual Studio – Debugging doesn’t start

There have been many suggestions to get this working. I will give you three that worked for me in the order they should be tried.

  1. Restart your computer. Some of the projects files run in the background. Stop them if you know what they are. Restarting is not necessary just end their tasks) and then try again.
  2. Go to Solution Explorer, right-click your project go to properties, click Debug, at the bottom there is a check box, click the check box to ‘Enable SQL Server Debugging’.
  3. Go to Solution Explorer, right-click your project go to properties, click Debug, at the bottom there is a check box, un-check the check box that states ‘Enable the Visual Studio hosting process’.

Google Chrome – MailTo Handler Doesn’t Work in Google Chrome

Add missing protocol mail handler in chrome settings manually in order to for a gmail compose window to appear when clicking a mailto:xxxxxxx@xxxxx.com link on a web site.

Google Chrome
 
1) Click Settings
2) Scroll to the bottom and click Advanced Settings.
3) Under Privacy, click Content Settings.
4) Scroll down and click Manage Handlers.
5) If the mailto handler is missing, do the following.
    a) Bring up your gmail in a Chrome Tab.
    b) Paste the following into the URL of that tab:
    javascript:navigator.registerProtocolHandler(“mailto”,”https://mail.google.com/mail/?extsrc=mailto&url=%s“,”Gmail”)
    Note: Before hitting enter, if the first part of the url, “javascript:” was trimmed off, just type it back and then hit enter. The handler icon should show up to the right of the address bar. Click it.
 Choose the ‘Allow’ radio button and click done.
    c) Go back to your Manage Handlers and the mailto handler should now be there pointing to mail.google.com.

SQL Server Management Studio – Order by different columns based on values in the different columns

Wrap your head around this one!

Here is an example of an order by in a SQL Statement that shows how specific you can get when ordering your data.
order by location_3,
case 
 when location_3 ='c' then
 case 
 when location_4 = '1' then location_5
 when location_4 in('2','3') then name_last
 else location
 end

when location_3 ='d' then name_last

when location_3 ='e' then
 case 
 when location_4 = '1' then location_5
 when location_4 in('2','3','4','5') then name_last
 else location
 end

when location_3 ='f' then
 case 
 when location_4 in('1','2','3') then name_last
 when location_4 in('4','5') then location_5
 else location
 end

when location_3 ='g' then
 case 
 when location_4 in('1','2','4','5') then name_last
 when location_4 = '3' then location_5
 else location
 end

else location
end