How to disable lower case letters on keyboard in iOS 9

One of the features of iOS 9 is that keyboard now shows lower case letters when shift key is not pressed. This makes the keyboard display match how letters are being typed on the screen. Some people may prefer keyboard which works the same way it did in previous versions of iOS – always showing capital letters.

Luckily, you can change this behaviour. Go to Settings -> Accessibility -> Keyboard and turn off Show Lower Case Keys option.

Keyboard on your device will now only show upper case letters.

Disable page breaks in SQL Reporting Services (SSRS)

In some situations you may wish to disable page breaks in SSRS report, such as when displaying report as part of web page (for example, inside SharePoint).

To do this, you need to set Interactive Height to 0.

Select Report Properties, and go to InteractiveSize property. Change height to 0. You’ll get a message saying “Setting interactive height to 0 may have a performance impact.”. Click OK to close the message. Save your report and run it – page breaks are now gone.

SSRS

T-SQL – Select Max or Min value from a list of values

If you need to select max or min value from a list of values, you can use the code below. Advantage of this code snippet is that it doesn’t use any temp tables or user defined functions, and it also works if one or more values are NULL.

SELECT MAX(n)
FROM (VALUES (12), (4), (5), (19), (2), (21), (0), (NULL)) AS i(n)

Returned result will be 21.

SELECT MIN(n)
FROM (VALUES (12), (4), (5), (19), (2), (21), (0), (NULL)) AS i(n)

Returned result will be 0.

You can use variables in place of hard coded values above. All variables used must be of the same type. Variables can contain null values.

SELECT MAX(n)
FROM (VALUES (@MyVar1), (@MyVar2), (@MyVar3), (@MyVar4)) AS i(n)
SELECT MIN(n)
FROM (VALUES (@MyVar1), (@MyVar2), (@MyVar3), (@MyVar4)) AS i(n)

How to fix no sound over HDMI on Raspberry Pi

Some TVs / monitors won’t play sound over HDMI when using Raspberry Pi, even if sound from other devices plays fine.

First thing to do is to change the setting to force sound over HDMI using configuration tool. Start configuration tool from terminal by typing

sudo raspi-config

Select option 8 (Advanced Options) from the menu and then select Audio option. Select option to force audio over HDMI and exit configuration tool. You should now have sound over HDMI.

If method above still didn’t help, you’ll need to edit configuration file manually. Go to terminal and navigate to /boot directory. Then edit config.txt file by typing

sudo pico config.txt

Find a line with

hdmi_drive=2

and uncomment it (remove # in front). Reboot Raspberry Pi and you should have HDMI sound.

How to add new desktop shortcut on Raspberry Pi

To add a new desktop shortcut in Raspbian, right click on the desktop and create new file with “desktop” extension, e.g. MyApp.desktop.

Once you’ve created the file, open it in text editor and add the following content

[Desktop Entry]
Name=App Name
Comment=Some comment
Icon=/usr/share/pixmaps/openbox.xpm
Exec=/usr/bin/myapp
Type=Application
Encoding=UTF-8
Terminal=false

Name – application name
Comment – you can put any comment you wish
Icon – path to icon file to be used for the shortcut
Exec – path to application executable

Save the file and you can use new shortcut to launch your application.

How to enable remote desktop on Raspberry Pi

If you want to connect to your Raspberry Pi device remotely and use the desktop, you can do this by installing xrdp.

Xrdp is implementation of Microsoft’s RDP protocol, and it will allow you to connect to Raspberry Pi device using Microsoft’s remote desktop connection app, jut like you would connect from one Windows machine to another.

To install xrdp under Raspbian, open terminal and type

sudo apt-get install xrdp

This will install xrdp and start the service. After installation is complete, you can connect to a remote desktop session.