Crystal Report: First page is always blank with sub-report

Steps to resolve the issue:

a). Right-click and choose "Format Object".



b). In "Format Editor" > "Common" > Un-tick "Keep Object Together". Click "OK" to save the changes.



c). Repeat step [a] and step [b] on all sub-reports.

d). Preview the report now, first page should not be blank anymore.

Request was blocked due to exceeding usage of resource 'Concurrency' in namespace 'VSID'

When you try to connect to your TFS at visualstudio.com, you received this error message: Request was blocked due to exceeding usage of resource 'Concurrency' in namespace 'VSID'.

Better check status of visualstudio.com at here: https://status.dev.azure.com/

Specified key was too long; max key length is 767 bytes

Getting this error "Specified key was too long; max key length is 767 bytes" from your MySQL?

Here is the solution:

• Simple, just upgrade your MySQL to at least version 5.7.30.

You may download the GA releases from here: https://dev.mysql.com/downloads/mysql/

The 'vfpoledb.1' provider is not registered on the local machine.

Not able to find the solution for this error message "The 'vfpoledb.1' provider is not registered on the local machine."?

Here is the solution:

1. Download the msi file from here, https://www.microsoft.com/en-us/download/details.aspx?id=14839, and make sure you install as Everyone. If you choose Only Me, you will hit the same error message.
2. Build your application, regardless it is a web application or desktop application, in x86 mode.

Happy coding!

Want to know your MySQL database size?

Well, you can try the script below:

Select
table_schema As "Database Name",
Round(Sum(data_length + index_length) / 1024 / 1024, 2) As "Database Size in MB"
From information_schema.Tables
Where table_schema = 'xxxxx'
Group By table_schema
Order By table_schema;

It takes years to output data via Microsoft SQL Server BCP (Bulk Copy Program utility)?

If you are using Microsoft SQL Server BCP (Bulk Copy Program) utility, or a.k.a. XPShellCmd, and you found that your scripts take forever to execute.

Solution:

a). Always make sure your Select statement comes with NoLock for each tables.

It takes years to sign in Skype for Business?

This issue in fact bugs me for months, and it only happens on my personal laptop (a Windows 10). It won't go away even I have cleared the cache for Skype for Business, delete the sign in information, etc.

Until I checked the tracing log file, and it mentioned that there is a loop while accessing my Wi-Fi adapter, I start to narrow down the possible root cause: Network adapter.

And finally I managed to get it fixed, by turning off Internet Protocol Version 6 (IPv6).