Sure way to failure: Activating iMessage or FaceTime while roaming!

Unfortunately, iOS7 was released while I was abroad, so without any bad intentions I backed up my data and upgraded exactly on 20th September. Everything was OK and iMessage\FaceTime had no problems since they were already functioning in my home country.

Things started to happen when I noticed that iMessage was not activated for my phone number and it was only working for my e-mail, so I turned it off\on, which actually was not the case. I only turned it off, and when trying to turn it on, a message appeared confirming a message to be sent for Apple for activation and kept waiting for activation, hours passed and no reply.


A visit to Apple store advised me to approach Apple support on the Internet
http://www.apple.com/support !!!which I have followed and created two cases, where I was informed that they won't be able to help me unless I spend a day waiting for confirmation for my activation request!!! And directed me to a troubleshooting page: http://support.apple.com/kb/ts4268 which included steps that require at least one more day.

Fed up, I dropped again by Apple store which changed my device!!! Voila, still not functioning!!

Finally, with no more time to waste on this, I returned home with my issue and trying to activate, and the next time I checked my phone, they were both activated!

It is worth adding that, as per my monthly invoice, the activation message was never sent from my iPhone while I was abroad!

Understanding Microsoft SQL Server permissions

Below is a very good article about the permissions check order. Also explains chaining; when an object accesses another object.

http://technet.microsoft.com/en-us/library/dd283095(v=sql.100).aspx
Although the article was for SQL Server 2008, most concepts are still valid for 2012 version.

MS SQL Server: Changing database diagram ownership

- Current user to be removed from the DB to be able to transfer object ownership!!
- Ownership can now be transferred to members of the db_owbner role.


For me, I just cannot get the rational behind this restriction!


For actually changing the object ownership:
http://support.microsoft.com/kb/275312/en-gb

Tip (MS Excel): To skip empty cells

To skip empty cells and to get directly to the next non-empty cell:

Keyboard Shortcut:
Ctrl + one of the 4 arrow keys (in the direction required) 

Tip: Syncing Internet Explorer Favorites (Windows 7) across different machines using Dropbox

1) Goto IE Favorites folder.

2) Change Folder Location to Dropbox "Favorites" folder.

Note: Don't forget to create the new folder  "Favorites", so that the bookmark files are not moved to the root Dropbox folder.

 3) Select the just created "Favorites" folder within Dropbox.

 4) Move all files and subfolders.

Note: In case you want to sync your bookmarks with Apple Safari bookmarks, you can still use iCloud, and selecting Internet Explorer Bookmarks for syncing.

--Update 02/10/2013----
iCloud 3.0 caused the return of my deleted files.
When I uninstalled it, everything went smooth! Of course, your bookmarks are now no longer synchronized by Safari :(
--------------------------



Applied on :
Windows 7 Professional SP1
Internet Explorer 10.0.9
Dropbox 2.0.22
iCloud 3.0

Apple: USB Power Adapter Takeback Program

Yes, it is true and I got my 3rd party USB power adapter replaced for half the price of a new one!

How is that? Can you recall the incident of the Chinese lady who died through an electric shock while talking through the iPhone 5 while it is being charged?! Apple is trying to show that they care.

Thanks Apple.

http://www.apple.com/support/usbadapter-takeback

Starting August 16, 2013  and is valid until October 18, 2013

Business Tip: One of the 3 biggest corporates for...

Keep in mind when;

a corporate representative declares that his corporate is one of the biggest 3 in that business, make sure that this corporate is the third!!!

SharePoint 2010: Adding KPI Indicators icons to custom list

 Snap from expected output:

1) Add indicator column as a calculated column with this formula.


Formula Field:
=IF(Status="Pending","<DIV><IMG src='/_layouts/images/KPIDefault-1.gif' /></DIV>",
IF(Status="Special","<DIV><IMG src='/_layouts/images/KPIDefault-2.gif' /></DIV>",
IF(Status="Closed","<DIV><IMG src='/_layouts/images/KPIDefault-0.gif' /></DIV>")))


2) Add the following script in the HTML after editing the page and adding a new ContentEditor:
Using calculated columns to write HTML
-- Quote From blog.PathToSharePoint.com:
<script type="text/javascript">
//
// Text to HTML
// Feedback and questions: Christophe@PathToSharePoint.com
//
var theTDs = document.getElementsByTagName("TD");
var i=0;
var TDContent = " ";
while (i < theTDs.length) {
try {
TDContent = theTDs[i].innerText || theTDs[i].textContent;
if ((TDContent.indexOf("<DIV") == 0) && (TDContent.indexOf("</DIV>") >= 0)) {
theTDs[i].innerHTML = TDContent;
}
}
catch(err){}
i=i+1;
}
//
// ExpGroupRenderData overwrites the default SharePoint function
// This part is needed for collapsed groupings
//
function ExpGroupRenderData(htmlToRender, groupName, isLoaded) {
var tbody=document.getElementById("tbod"+groupName+"_");
var wrapDiv=document.createElement("DIV");
wrapDiv.innerHTML="<TABLE><TBODY id=\"tbod"+ groupName+"_\" isLoaded=\""+isLoaded+ "\">"+htmlToRender+"</TBODY></TABLE>";
var theTBODYTDs = wrapDiv.getElementsByTagName("TD"); var j=0; var TDContent = " ";
while (j < theTBODYTDs.length) {
try {
TDContent = theTBODYTDs[j].innerText || theTBODYTDs[j].textContent;
if ((TDContent.indexOf("<DIV") == 0) && (TDContent.indexOf("</DIV>") >= 0)) {
theTBODYTDs[j].innerHTML = TDContent;
}
}
catch(err){}
j=j+1;
}
tbody.parentNode.replaceChild(wrapDiv.firstChild.firstChild,tbody);

}</script>
-- Un-quote from blog.PathToSharePoint.com:





Tip:
This solution did not work on grouping by list! HTML string was displayed instead of the icons!
Tried applying this then grouped; however, it did not work either.

You get the following on grouping: