How to Optimize iPhone, iPad and iPod Performance

1. Close Apps Running in the Background On an iOS 10/9/8 device, when you tap the home button to leave an app, you do not “close” that app. In fact, all apps continue to run in the background, and certain apps (social media, apps with “push” notifications, streaming music apps) take up a good chunk of battery when they are running. If you close them when they’re not in use, you could save more battery and RAM to make…

Read More

What is – DML, DDL, DCL and TCL – Introduction

DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements DDL DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples: CREATE, ALTER, DROP statements DCL DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database…

Read More

Posted in SQL Tagged Comments Off on What is – DML, DDL, DCL and TCL – Introduction
The feed does not have subscriptions by email enabled – FeedBurner

If you see the FeedBurner error message above, this means that you need to enable the subscription by email option in your FeedBurner account settings. It could also mean that you have not obtained the correct FeedBurner ID. How to fix: –  Login at http://feedburner.google.com/ and select your feed. – Go to the “Publicize” tab. – Open the “Email Subscriptions” section on the left. – Make sure that “Email Subscriptions” are enabled Image:

Read More

Posted in Blogs Tagged , Comments Off on The feed does not have subscriptions by email enabled – FeedBurner
Find Duplicate Values with SQL Script

Let’s assume that data has been entered in a table and now you want to find if a table column have duplicated values. Here is an SQL script to join data from one table for comparison purpose. The table must have a primary key column (unique column) and the second column for comparison. Here is a sample script: Details: – DWDOCID is the primary key column – AIXFlag, is just a fixed value (optional) – SAMPLEEN is the table…

Read More

FORMAT Function for Transact-SQL – T-SQL

Returns a value formatted with the specified format and optional culture in SQL Server 2016. Use the FORMAT function for locale-aware formatting of date/time and number values as strings. FORMAT ( value, format ) Return Types:  nvarchar or null The length of the return value is determined by the format. Remarks:   FORMAT returns NULL for errors other than a culture that is not valid. For example, NULL is returned if the value specified in format is not…

Read More