How to turn off automatic spelling correction in OS X

OS X 10.10 Yosemite turns on auto spelling correction on by default in all applications (Mail, iMessage, Safari, etc.).

To turn it off, go to System Preferences -> Keyboard. Then select Text tab and un-check “Correct spelling automatically” option.

OSX autocorrect

Advertisements

SQL Server Reporting Services – Report Manager returns 404 page not found

Today I was setting up new development environment with SQL Server 2014 and SSRS. After setting it up, I tried to connect to Report Manager (via URL specified in Reporting Services Configuration Manager) but I was constantly getting 404 page not found error.

Turns out that by default all unencrypted connections are being redirected to HTTPS, and since development machine I was using did not have SSL set up, I was getting 404 errors. Unfortunately Report Manager does not provide an option to turn off secure connection – the only way to do this is to change a setting in RSReportServer.config file manually.

Setting that needs chaning in RSReportServer.config file is called SecureConnectionLevel, and value needs to be set to 0 (by default value is 2, which means that secure connection is required).

Once setting is changed, save config file and restart reporting server.

How to disable lock screen in Windows 10

If you would rather have login screen displayed on Windows 10 boot instead of lock screen, you can change a registry setting to disable lock screen.

Open Regedit and navigate to

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Personalization

Note: if you don’t see Personalization key, just create it.

Inside Personalisation key create new DWORD value called NoLockScreen. Edit NoLockScreen and set value to 1 do disable lock screen. If you wish to enable it again, just change the value to 0 or delete NoLockScreen DWORD.

Windows 3.11 on iOS

Here is a quick tutorial on how to emulate Windows 3.11 on iOS. This should also work with any other DOS-based version of windows. To get emulation up and running, you will need jailbroken device.

First, you’ll need to install DOSPAD, MS-DOS emulator based on DOSBox. You won’t find it in main Cydia repository, so you’ll need to add custom repository. Open Cydia, then go to Sources. Select Edit and then Add, and enter http://cydia.myrepospace.com/Jujul98. Once repository source has been added, tap on it, select All Packages and then select DOSPAD to install it.

Once DOSPAD is installed, you’ll have a working MS-DOS environment in which to install Windows 3.11. DOSPAD mounts Documents folder as C:\ drive, so to get new files to access from emulator just copy them via SSH/FTP to Documents folder.

Now you’ll need installation files for Windows 3.11. Create install directory and copy all installation files in there. If you don’t have original Windows 3.11 floppies, Google is your friend. Copy install folder to Document folder on iPhone/iPad. Open DOSPAD an run setup from install directory. Go through Windows installation process (shouldn’t take long) and once it’s finished you’ll have working Windows 3.11 installation.

Wind311oniOS

How to attach MS SQL Server database (mdf file) without corresponding log (ldf) file

When attaching SQL Server database, you should have database file (mdf) and transaction log file (ldf). If transaction log file is missing, you won’t be able to attach database through SQL Server Management Studio.

You can, however, attach database with mdf only file using a system stored procedure. This will only work if database you are trying to attach has been shut down gracefully, without an abrupt shutdown (power outage, server crashes, etc.). In this case SQL Server will try to recreate ldf file, and if successful it will attach the database.

Use the following system stored procedure call to attach mdf file.

USE [master]
GO
EXEC sp_attach_single_file_db @dbname='MyDatabase',
@physname=N'C:\FileLocationPath\MyDatabase.mdf'
GO

If SQL Server was successful in attaching the database, you should see the following message in messages output tab:

File activation failure. The physical file name "C:\OriginalLDFFilePath\MyDatabase.ldf" may be incorrect.
New log file 'C:\FileLocationPath\MyDatabase.ldf' was created.

Refresh databases list in SQL Server Management Studio, and newly attached database will be on the list.

How to manually install deb package on jailbroken iPhone or iPad

If you have jailbroken iDevice, apart from using Cydia and various package repositories, you can also download and install .deb packages manually.

First, go to Cydia and download Filza file browser app (its free).

Then download deb package (if downloading in Safari, after tapping download link, select Open in “Filza”).

You should see downloaded package in Filza. Tap on it to open information screen, and select Install.

Once installation is done (you’ll see bash-4.0# prompt in terminal) select Respring. This will reset springboard and show application on your home screen.

If the application doesn’t show up on home screen (or if all jailbreak apps disappear from home screen – don’t panic), it means that the app does not support iOS version that you have on your device. Open Cydia, select “Installed” option at bottom menu and then select “Recent” at the top. Tap on the application you just installed and select “Remove”. Also use this method to remove any custom installed apps that you don’t want on your device any more.

Visual Studio 2015 – Disable file preview on single click

Visual Studio 2015 opens files for preview by default when you click on a file in solution explorer.

If you wish to disable this, go to Tools -> Options, and under Environment select “Tabs and Windows” settings. Under “Preview Tab” section, deselect “Allow new files to be opened in the preview tab” option and click on OK. Now when you click on a file in solution explorer it won’t open in preview tab.

This also applies to Visual Studio 2012 and 2013.

VS2015TabsAndWindowsSetting