SQL Server Management Studio – Split a Table Column into Two Columns Before and After a Specific Character

Let’s say you have a column on your table named name_title that contains an employee’s name and their title separated by a comma as such: ‘John Doe, Manager’.

The LEFT method will grab everything to the left of the comma ‘,’ and call it Name.
The REPLACE method will grab everything to the right of the comma ‘,’ and call it Title.

Your search results will contain two columns as such:

Name    | Title
------------------
John Doe  Manager

Here is the T-SQL below:

SELECT LEFT(name_title, CHARINDEX(',', name_title) - 1) AS Name, REPLACE(SUBSTRING(name_title, CHARINDEX(',', SystemVname_titlealue), LEN(name_title)), ',', '') AS Title
FROM name_table where key = 1

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’.