Development Links

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
As editor and main contributor to, 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.
    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