DCA-Link

Merge Replication v Sync Services
Deciding Which Technology to Use
"Sync Services for ADO.NET provides the flexibility of a programming model like offline datasets and a richer synchronization feature set like that found in replication. Sync Services for ADO.NET functionality is superior to RDA. Replication is intended for database administrators and is designed primarily to synchronize SQL Server databases. Replication provides significant functionality with configuration available through wizards, stored procedures, and its own API. Sync Services for ADO.NET is intended for developers and supports heterogeneous databases and synchronization over services, such as Windows Communication Foundation (WCF). If an application involves synchronizing with non-SQL Server databases or if an application must have separate components to enable synchronization over different transports or services, use Sync Services for ADO.NET.

"For some applications, the decision to use a technology is easy: If you must synchronize a data source other than a SQL Server database, Sync Services for ADO.NET is the solution. If you are a database administrator who wants to configure synchronization without much programming, replication might be a better choice. Ultimately, you must carefully consider the application requirements and determine whether the Sync Services for ADO.NET API is the appropriate technology to use. If you want to move beyond replicating a schema and its data from one database to another, we recommend that you use Sync Services for ADO.NET."

Quoted from the article.

• Read the full article here. Microsoft Sync Framework / Comparing Sync Services for ADO.NET to Other Technologies.

Windows XP SP3 and Office 2003 Support Ends April 8, 2014
Why, What, How to Migrate

• Read the article here.
• End of Windows XP Support Countdown.
• Upgrading to Windows 7? Microsoft recommends that you download and run the: Windows 7 Upgrade Advisor.
• Upgrading to Windows 8? Microsoft recommends that you download and run the: Windows 8 Upgrade Assistant.

Using SqlBulkCopy To Perform Efficient Bulk SQL Operations
importing data files into SQL Server

Scott Mitchell shows how to import large amounts of spreadsheet data into a web database via a web page.
• Article and sample code here.
• .NET Framework Class Library: SqlBulkCopy Class
• About Scott Mitchell
email: mitchell@4GuysFromRolla.com
Blog: www.ScottOnWriting.net
As editor and main contributor to 4GuysFromRolla.com, a popular ASP.NET resource website, Scott Mitchell has authored more than a thousand articles on Microsoft web technologies since 1998. In addition to his vast collection of online articles, Scott has written six previous books on ASP and ASP.NET: Sams Teach Yourself Active Server Pages 3.0 in 21 Days (Sams); Designing Active Server Pages (O’Reilly); ASP.NET: Tips, Tutorials, and Code (Sams); ASP.NET Data Web Controls Kick Start (Sams); Teach Yourself ASP.NET in 24 Hours (Sams); and Teach Yourself ASP.NET 2.0 in 24 Hours (Sams). Scott has also written a number of magazine articles and is a regular columnist for Microsoft’s MSDN Magazine. Scott’s nonwriting accomplishments include speaking at numerous ASP.NET user groups and conferences across the country. Scott regularly teaches classes on ASP.NET and related web technologies at the University of California–San Diego University Extension. Scott also works as an independent software developer.

Laptop Display Resolutions
Making sense of it all

Running the Retina MacBook Pro at Full 2880x1800 Resolution.

TIPS: EXCEL
Convert alpha to numbers in Excel

Type 1 in any blank cell.
Copy the cell.
Select the range of cells needing to be converted to numbers.
Select from Home / Paste / paste special / operation / multiply /
Click OK
The selected values are converted to numbers.

10 Super Neat Ways to Clean Data in Excel

Optimize Internet Speed
Adjust the MTU Setting

| Network speed optimization - MTU size - The Tech Guy - Liron Segev: Web / Youtube

Nov 30, 2020 #TheTechieGuy
There is a BIG difference between a working internet connection and an optimized fast internet connection that is geared for speed!
Today I am going to show you a simple setting that anyone can do that took me from 150Mbps to 450Mbs.

Here are the commands you will need:
To calculate the MTU size:
ping thetechieguy.com -f -l 1492

To see the MTU size on your computer:
netsh interface ipv4 show subinterfaces

To set the MTU size:
netsh int ipv4 set subinterface “Ethernet” mtu=1500 store=persistent

Note:
If you are using WiFi, instead of Ethernet, use whatever the interface say eg "Wi-Fi"
To reset it in case it didn't work or you want to start again just set it back to 1500

Dell Support
• Precision M4800
| Precision 3540 Mobile Workstation

Microsoft Download Notifications
• Office and home

Junk Email Filter update
• MS Outlook
• Outlook 2003 Junk Email Filter (KB892236)

Diagnostics
• WinMTR – Free Network Diagnostic Tool

Firewall scans
• HackerWatch.org
• Gibson Shields Up
• port scanner

Data Breech Email Monitor
• LifeLock
• FireFox Monitor

Virus & Ad/Spyware Information Centers
• ComCast.Net Security
• Spyware Information Center
• Spyware Name Search
• Wildlist Org Int'l
• Checkmark Certified
• ICSA Certified
• Virus Bulletin

Network Tools (Linksys Router)
• Linksys Smart Wi-Fi Setup & Admin
• Admin access: Login | How to access the router’s web interface

Broadband meters
• broadbandReports.com
• vonage
• Sprint (download speed only)
• TestMyNet
• SpeedTest.Net
• SpeakEasy.Net
• Surfboard signal / local

Updates
• Java version check / Java.com
• JavaTester / Michael Horowitz
• What Version / whatversion.net
• Java download
• Adobe / Flash & Reader
| Adobe Flash Ctrl Panel
• Shockwave Flash / version check
• Microsoft Secuity Essentials
• iTunes

• Social Media
| twitter: Manage Filter / unfollow mgmt ||| CrowdFire ||| TinyURL
• Social Media Plugins
| ShareThis

Web Analytics
| Alexa
| Domain Estimator

System File Lookups
| file.net
| file extensions

| Microsoft Office Outlook Connector 12.1
With Microsoft Office Outlook Connector, you can use Microsoft Office Outlook 2003 or Microsoft Office Outlook 2007 to access and manage your Microsoft Windows Live Hotmail or Microsoft Office Live Mail accounts, including e-mail messages, contacts and calendars for free!
| Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats [compatibility pack] [sp1]

Publications
| eWeek
| PDA Today

Computer Upgrades
| 4 All Memory

Open Source Tools
| Foxit Reader / pdf reader
| NotePad++ / smart text editor
| Inkscape / Open Source vector graphics editor

PDF Document Publishing Tools
| pdf995

email Conversion/Migration Tools
| Emailchemy
| TranSend
| Entourage Email Archive X

Open Office Suite
A free complete and excellent office productivity suite from Sun.
| Windows version
| Macintosh version

Trying to replace Adobe CS?
| What Photoshop's Move to the Cloud Actually Means for You
| Build Your Own Adobe Creative Suite with Free and Cheap Software
| GIMP / Replacement for Photoshop
| Scribus / Replacement for InDesign
| Inkscape / Replacement for Illustrator
| Lightworks / Replacement for Premier
| VideoLAN Movie Creator / Replacement for Premier
| KompoZe / Replacement for Dreamweaver
| Wax / Replacement for After Effect

Blockchain
| VIDEO: Understand the Blockchain in Two Minutes
| VIDEO: The Bitcoin and Blockchain Technology Explained
| CODE: A Guide to Building Your First Decentralized Application / a voting app
| CODE: Developing Blockchain Software
| CODE: Creating a blockchain with Javascript (Blockchain, part 1)
| WEBSITE: IFTF.org

Electronic Warranties
| Square Trade

Remote Support
| LogMeIn Rescue
| TotalConnectComfort
| WiFi7DayTouchscreenThermostat

Mobile Dev Tools
| Mobile Frameworks Comparison Chart

iPhone / developer
| Apple iOS Dev Center
| Apple Dev Member Center

Laptop Deals
| Refurbished Apples: 15" 17"

GPS
| Garmin: Map Updates / login

Streaming
| Pair YouTube/Roku
| chrome://plugins/
| chrome://conflicts/

Calculators
| Algebra
| Scientific

Printer Tips
| Brother printers mfc9330cdw toner reset

LEGAL FORMS
| Illinois Tax POA / IL-2848
| IL-2848, Power of Attorney
| IL-2848 Form

WebSites
| Live Nation
| Tour Designs
| Wright & Company