The most often asked question when configuring a firewall for SQL Server access is what ports are used by SQL Server? If your SQL Server uses default port numbers, it's important to have TCP port 1343 & UDP port 1344 at the minimum opened. The … [Continue reading]
How to Make Links to Apple’s AppStore
A special link that's clickable on any iOS devices such as iPod, iPhone, or iPad and go straight to Apple's Appstore can be built via iTunes Link Maker (Create links for the iTunes Store, the App Store, the iBookstore, and the Mac App Store).The … [Continue reading]
How to Force WWW to Your Domain URL
One important aspect of SEO basics is that we use "WWW Resolve" on our domain name. While we know that domain.com and www.domain.com may be pointing to the same website, search engines don't know that and they will treat them as two duplicate … [Continue reading]
How to Activate Google 2-Step Verification
With a huge increase in email accounts getting hacked, you need more than just a strong password to protect them. Fortunately for Gmail users, Google provides a "2-step verification" that will tell you by either sending a text message to your … [Continue reading]
Removing _x0022_ Character Issue in SQL Server and SSIS
Just recently after an a production database upgrade to a 64-bit SQL Server 2008 R2 RTM (from SQL 2000), the same SSIS 2008 package that exports data from SQL Server 2000 to a flat file (csv/txt) started to wrap all data fields with _x0022_ … [Continue reading]