Month: August 2017

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 exists but is something other than gmail, the click the 3 dots and click Remove. If it is missing, do the following.
    a) Bring up your gmail in a Chrome Tab.
    b) Open the javascript console in Chrome (ctrl-shift-j) and enter the folowing:
    navigator.registerProtocolHandler(“mailto”,”https://mail.google.com/mail/?extsrc=mailto&url=%s“,”Gmail”)
    c)
 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

SQL Server Reporting Services (SSRS) – Order by different values from the same database table column

Let’s say you want to order your data in your tablix by last name, but you want certain names to be sorted first.

1) Double click the first grouping under Row Groups.
2) Select ‘Sorting’.
3) Click the ‘Add’.
4) Click the Expression button.
5) Add the following expression.

=switch(

Fields!last_name.Value = "SMITH", 1,

Fields!last_name.Value = "JONES", 2,

Fields!last_name.Value = "WILLIAMS", 3)

Now, all persons will be sorted by SMITH, then JONES, then WILLIAMS.

But, what about the rest of the data. How can you get the rest of last name to be sorted ascending like such:

SMITH
JONES
WILLIAMS
ANDERSON
DAVIS
EDWARDS
etc.

You can use a CASE statement in the SQL instead like this:

SELECT * FROM NAME_TABLE
ORDER BY
(CASE WHEN NAME_LAST= 'SMITH' THEN 1
           WHEN NAME_LAST = 'JONES' THEN 2
           WHEN NAME_LAST = 'WILLIAMS' THEN 3
          ELSE 4 END), NAME_LAST

SQL Server Management Studio – Get metadata on mdf database files

In SQL Server Management Studio, you can run the following commands against your MDF database files to get metadata information.

--SQL Server DBCC CHECKPRIMARYFILE with Option = 0
--First, we will use it with zero to check if it is the primary file if so it will return 1 otherwise 0.
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',0) WITH NO_INFOMSGS
--Determine version of mdf file
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',2) WITH NO_INFOMSGS
--To check logical name, size, maxsize, status and physical name of all files
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',1) WITH NO_INFOMSGS
--Checks the logical name, status and path of all files
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',3) WITH NO_INFOMSGS

Here are the output results:

Google Calendar: Recover a Deleted Google Calendar Event

You can see your Trash from Google Calendar on your computer. In Trash, you can:

See deleted events for 30 days
Restore deleted events
Delete events forever

In https://calendar.google.com

Click the drop-down to the right of the calendar you want to work with.

Select ‘View Trash’.

To restore an event, click the checkbox to the left of the event and click the ‘Restore selected events’ button.

To delete an event(s) permanently, click the checkbox(es) to the left of the event(s) and click the ‘Delete forever’ button.