Tuesday, October 14, 2025
Home Blog Page 261

SQL Server – Dealing with NULL values when sorting

When working with NULL values, it’s important how you deal with NULL records in your database. This example walks through and explains how to sort and separate NULL and non-NULL values. This example should work with all database types including MySQL, MS SQL, and postgreSQL.

SQL Server: Enable and Disable Triggers

If we have a trigger and want to prevent it from running, we can either delete the trigger or disable it temporarily. With the trigger disabled, it will not function. We have three ways to enable/disable a trigger in SQL Server by using a graphical option or by using a query editor.

Google Hangouts for Android: Mute Notifications or Block Contacts

If you are annoyed by repeatedly receiving notifications of a conversation or by a person on Google Hangouts, you can turn off the notices and block the person.

IE6: Images Will Save Only as a Bitmap (*.bmp)

If Internet Explorer will only let you save an image file as a bitmap, here is how to fix it.

How to Enable Remote Desktop Web Connections in Windows XP Professional

0

This tech-recipe explains how to install and enable the Remote Desktop Web Connection add-in. With a remote desktop web connection, you can access your PC from any PC that has Internet Explorer 5.0 or higher. This is useful for those of us with pocket PCs or PDAs or for those who want to access their PCs from a coffeeshop (i.e., macs).

Opening Blocked Attachments with Outlook 2003

Outlook 2003 allows the user to use a registry key to open up access to blocked attachments.

Windows: Expand the Functionality of \’My Computer\’

If you frequently use the My Computer window, then you should expand the functionality to your liking. You can add Administrative Tools, Printers and Fax Devices, Scheduled Tasks, Network Connections, the Recycle Bin, and My Network Places to the window by using this tweak.

XP: What is the Msocache Folder and How Do I Remove It?

Local Install Source copies Office installation source files from the Microsoft Office 2003 installation media into a hidden folder on the hard drive called the Msocache folder. This tutorial describes how to remove this folder.

Windows 8: Allow Applications to Display Notifications on the Lock Screen

Having important notifications displayed on your lock screen is a good way always to be informed of what you need to do. Simply glance at your lock screen to know exactly what is going on.

Android: Invert the Color of the Screen

Inverting the screen color on a smartphone provides better screen visibility when in sunlight, without having to increase the screen’s brightness.

Solve: Can’t connect to local MySQL server through socket /tmp/mysql.sock

A frequent error message received when using the mysql command line utility is: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ While this error message can be frustrating, the solution is simple.

Windows XP: Disable Indexing Service

As its name indicates, the Indexing Service indexes contents and properties of files on local and remote computers and provides rapid access to files through flexible querying language. This service is a major resource hog and should be disabled.

Stay Connected

16,985FansLike
2,458FollowersFollow
61,453SubscribersSubscribe

Latest Articles

Latest Reviews

Latest Comments

error: Content is protected !!