Missing Power View button in Excel 2013

Excel 2013 --> File --> Options

Overlapping content following the Microsoft Report Viewer control

The trick to avoid this behavior is to use the parameter: SizeToReportContent, such that:


<rsweb:ReportViewer ID="ReportViewer_Main" runat="server" Height="1250px" Width="700px" SizeToReportContent="True">
.
.
.
</rsweb:ReportViewer>








Assembly=Microsoft.ReportViewer.WebForms
Version=11.0.0.0

Calling MS SQL Server user defined functions with default parameters

User Defined Function Call:

SELECT *
FROM udf_TestDef(1, DEFAULT)

Yes!! You have to insert the term default literary!

User Defined Function Sample:

CREATE FUNCTION [dbo].[udf_TestDef]
(
@Param INTEGER
@IsBigContainerPhoto BIT = 0
)
RETURNS TABLE
AS
RETURN
(
.
.
.

Excel 2013: Removing a defined named range\data table

For normally defined name:
1) Formulas menu.
2) Name Manager.
3) Select the range and delete.


In my case that was a result of a query which generated the named data table:
1) Select the range from the drop down list beside the formula bar.
2) Right click on any cell within that range, and select:
Table --> Convert to Range

The reason I wanted to get rid of that named table in the first place was that filtering and sorting the data inside it was separated from the main sheet.

Tip: Creating Apple ID without entering credit card information

1) Start from the App Store from your device.

2) Try to install a free application.

3) When prompted to enter your Apple ID, select the option for creating a new account.

4) Fill in your information. Moreover, you will find an option for the payment which is "None". 

This option is unavailable when you try to create your Apple ID the regular way through the website.


The following are the detailed instructions from Apple knowledge base:
http://support.apple.com/kb/ht2534

Default value for SQLServerDatasource string parameter must contain a default value to be passed as empty string!

Scenario:
- FormView in edit mode with SQLServerDatasource update statement set to a stored procedure which contains a string, nvarchar(max), parameter.
- Within the aspx file, the default parameter value = ""
- Parameter is data binded to an empty TextBox.
- FormView is submitted for update.

Observation:
- Stored procedures string parameters when defaulted as empty strings, they are not passed to the stored procedure, rather than passed as empty strings.

Workaround# 1:
- Insert a space with the parameter default value in the aspx file such that:
default = " " rather than default = " ".

Workaround# 2:
- Handling the event SQLServerDataSource.Updating, so that to manually add a space within the parameter value when the TextBox.Text value is empty.


- Visual Studio 2013, version 12.0.30110.00 Update 1
- .NET Framework 4.0

Unable to download a pdf file using Internet Explorer over a secure SSL channel

That came out as a reported bug from one of my clients and it fairly took a significant trials and errors to figure out that it is an issue associated with Internet Explorer and not my project!!

http://support.microsoft.com/kb/2549423/en-gb

Moving a window across multiple screens on windows OS

While the window is active:

Windows keyboard button +(right or left) direction key