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.