Sunday 30 June 2013

Organizing my iPhone sceens

That's my own settings for stting up my iPhone sceen, I do not recommend any of those applications, I just want to share with you how I organize my screens so that I would be the most productive on using them:

Screen #1: My handy most important apps.


Screen #2: Includes those which doesn't fit in the main screen and those apps which I regularly use; however, immediate access is not a priority.


 Screen #3: Those apps I sometimes tools, and they are mostly utilities. The iPhone folder contains those apps which I rarely use, or which I would hope to delete (Review my other post)


 Screen #4: Very Rarely used, but might be of value at times. For example the iBooks is not very useful at iPhone screen size, but  sometimes I get into the mode of reading a page or so!


 Screen #5: Those are my travel utilities which I use only on\during my trips.


Screen #6: Very few games and those apps which I try for some time before placing them in their permanent location.










Configuring Microsoft Outlook 2013 IMAP for free Yahoo mail acount

Please configure on your own responsibility, since I am not sue whether that is a supported configuration or not!






Thanks to the below forum:
http://social.technet.microsoft.com/Forums/office/en-US/0111c5c2-9350-464a-8950-cc0cd23a039e/yahoo-imap-settings-for-outlook-2010-on-windows-7

Problem uninstalling Nero 7 Demo



 The following endless uninstall dialogue was the main issue when trying to uninstall the application:



Dowloaded Nero Clean Tools 5








 Light of hope...


Voila!




Although it is not nice to either have issues or incompatibility issues with your software; but it is decent to have at least workarounds to keep the ball rolling!

Thanks Nero!

Saturday 29 June 2013

Feature I would like to see in iOS: Removing built in applications

For example, I do not find a value for me for any of the below marked applications; however, still I have no way of removing them from my iOS device!


Thursday 27 June 2013

Success Story: Software upgrade with no business disruption!

Business Case:
- Obsolete S\W product that requires maintenance\upgrade to maintain business efficiency.

Requirements:
- New reporting requirements which could not be easily developed within the old system. (High Priority)
- New bug fixes and requirements which could not be easily developed within the old system. (Medium\Low Priority)

Challenges:
- All existing data to be maintained.
- All existing data to be migrated as the seed for the data in the new system.
- Insufficient resources to build\purchase a new replacement.

Solution Workaround, short term:
- Reports developed directly from the old DB and delivered to the business unit.

(Some time...)

Solution Workaround, Medium term:
- Developing a new DB as an infrastructure for the new system.
- Developing and deploying an integration service to migrate scheduled update from the old to the new DB.
- Developing and deploying the new reports using state-of-the art technology and based on the new DB.

(A year or so here...)

Solution, Long term: 
- Building a new replacement S\W with all the new requirements.
- Depreciating the migration service.
- Depreciating the old S\W.

Monday 24 June 2013

Feature I would like to see back in YouTube iPhone application: Streaming through Apple Composite AV Cable

I used to have video streamed from YouTube on my iPhone to my car stereo using the Apple Composite AV Cable, this was in previous versions till the iOS 6 release, then YouTube no longer streams video through this cable :'(


Very annoying really to miss a feature through a software upgrade! 

your current security settings do not allow you to download from this location

Problem:

Solution:

Thursday 20 June 2013

Apple FaceTime versus Google Hangouts on iOS 6

In my first review for a replacement to Apple FaceTime that would be compatible on Android devices as well as Apple's, I was excessively receiving the below message using Google Hangouts, using two separate
accounts for each of my iPhone 4S and iPad Retina.


Of course, Facetime was doing so fine with both. At least it works.
After succeeding to set a connection using Google Hangouts for only two participants, the modest video quality was so apparent in comparison to FaceTime.

Hard Luck Google, my first experience with Google hangouts was far from my expectations from a released product, not even a beta!


Tuesday 18 June 2013

Wednesday 12 June 2013

Options for accessing \ reporting for SharePoint Lists

My research revealed that there is no built in feature to do it, so you have to implement your own technique. I have got into the following options, with my recommendation for the first one:

1) SSIS

2) Using the supported .NET API's for SharePoint.

3) Linked server:



Feature I would like to see in iOS: Enhanced update process

Being able to use the applications while updates are being downloaded, I can tolerate the installation time which is usually seconds while I can see no value in waiting for the download which can take much longer time!


Monday 10 June 2013

Feature I would like to see in iOS 6: Setting the first day of the week

Setting the first day of the week:
For example, my week in Egypt starts in Sunday rather than Monday.


Nothing here:


Synchronizing Internet Explorer favorites across different devices and different browsers easily

Surprisingly enough using Apple iCloud desktop is the easiest way to do so.



Custom SQL exceptions (error messages) to end users

Protected Sub FormView_Paper_ItemInserted(sender As Object, e As FormViewInsertedEventArgs) Handles FormView_Paper.ItemInserted
       
    If Not IsNothing(e.Exception) Then
            Dim DoDisplayCustomError As Boolean = False

            Dim SQLError As System.Data.SqlClient.SqlException
            If e.Exception.Source = ".Net SqlClient Data Provider" Then
                SQLError = DirectCast(e.Exception, SqlException)
                If SQLError.ErrorCode = -2146232060 Then
                    DoDisplayCustomError = True
                    ' Develop ur message display function!
                    Me.CurrentMasterPage.DisplayError("Missing Mandatory fields", "Fill in all mandatory fields.")
                End If
            End If

            If Not DoDisplayCustomError Then
                Me.CurrentMasterPage.DisplayError(e.Exception)
            End If
            e.ExceptionHandled = True
            e.KeepInInsertMode = True
        Else
            Response.Redirect("OtherPage.aspx")
        End If
    End Sub

Maintain FormView values on validation errors

Protected Sub FormView_Paper_ItemInserted(sender As Object, e As FormViewInsertedEventArgs) Handles FormView_Paper.ItemInserted

If Not IsNothing(e.Exception) Then
   
    e.ExceptionHandled = True
    e.KeepInInsertMode = True

End If

End Sub

Sunday 9 June 2013

Generating a sequence of numbers using SQL Select statement

SELECT (Tens.N + Units.N) NN
FROM
(
SELECT 0 N
UNION SELECT 1 N
UNION SELECT 2 N
UNION SELECT 3 N
UNION SELECT 4 N
UNION SELECT 5 N
UNION SELECT 6 N
UNION SELECT 7 N
UNION SELECT 8 N
UNION SELECT 9 N
)Units
CROSS JOIN
(
SELECT 0 N
UNION SELECT 10 N
--UNION SELECT 20 N
--UNION SELECT 30 N
--UNION SELECT 40 N
--UNION SELECT 50 N
--UNION SELECT 60 N
--UNION SELECT 70 N
--UNION SELECT 80 N
--UNION SELECT 90 N
)Tens

-----
NN
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

Thanks for:
http://sqlmag.com/t-sql/generating-sequences-t-sql

Saturday 8 June 2013

Feature I would like to see in: my mobile device

Token generator application for accessing the corporate VPN network, rather than having to hold another piece of H\W with me everywhere just for this purpose!!

Wednesday 5 June 2013

SQL: Get aggregates for multiple values from the same table

Table Doc

ID Version
--  --
1  1
1  2
1  3*
2  1
2  2*
3  1
3  2*
4  1
4  2
4  3
4  4*
5  1*

To get maximum versions for each document

SELECT D.ID, D.Version
FROM Doc D 
INNER JOIN (SELECT ID, MAX(Version) FROM Doc GROUP BY ID) DM ON D.ID = DM.ID



Thanks Dinos for the inspiration!



Tuesday 4 June 2013

Apple TV 2nd Gen: Sleep Now!

Press the middle (Select) button in the remote for 5 seconds.

SSRS Error: The EnableHyperlinks property has not been set for this report



    An error occurred during local report processing.
    • Report 'x' contains hyperlinks. The EnableHyperlinks property has not been set for this report
    •  


Report Viewer Properties: