After upgrading from sql2008 to sql2014, the code-behind of the rdl report used to convert RTF to Text was failing and displaying #Error instead of the converted text. There are numerous reasons this can happen, but for me, it was …
Author: James
Windows 10 – Create local account – Transfer data to and from iPhone/iPad
The purpose of this is allow the iPad and Windows 10 to communicate back and forth data without using AirDrop or wiring up the iPad.
1) Create a folder on Windows 10 to pass data back and forth from Windows …
iPhone – Wi-Fi Calling stops working
If you can’t turn on or use Wi-Fi Calling, make sure that your carrier offers Wi-Fi Calling and that your devices have the latest software. Then, follow these steps if you can’t turn on Wi-Fi Calling or make a Wi-Fi …
Windows 10 – Enable Hibernate in Elevated Command Prompt
powercfg -h on …
Windows 10 – USB Safe to remove Notification missing
If you encounter this issue, you can reset this in registry as follows:
In the registry editor, search for HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Notification\Settings\Microsoft.Explorer.Notification….
There may be multiple items. Click each until you find one that states has a REG_DWORD with a value = …
Windows 10 – Can’t login to Xbox Live with Windows 10 Live Account via the Xbox or Xbox Accessories windows application
The problem I was having is that it recognized my profile by showing my avatar and the Let’s Play button, but when I clicked the button, I got an error message stating that I couldn’t sign into Xbox live for …
Windows 10 Update Error (0x800705b4)
This problem I probably caused by shutting down my computer in the middle of the new Windows Version 1903 update. An hour after restarting my computer to complete the install, my computer seemed to be hung and never loaded up …
File Explorer: Show/Hide libraries in the left pane
Right mouse click in the white space below the Tree View on the left pane of File Explorer and uncheck ‘Show libraries’.
Do want to also hide ‘Network’ your ‘name’ shortcut, Network, Control Panel, and Recycle Bin? Uncheck ‘Show all …
SQL Server Management Studio – Using Row_Number, Partition, and filtering on Row_number
Let’s say you want to retrieve only the first row of each question type from the question type table. The 3rd SQL statement will give you your results, but let’s explain each of 3 SQL statements.
select RowNumber, question_type from…
SQL Server Management Studio – Retrieve one child row regardless of number of grand children from another child table with or without filtering
Let’s say you want to report on each child row, but you only want to see one row based on a grand child row with filtering on the grand child row. The following SQL will not work, but instead gets …