SSWUGtv – New Employee Risk With Stephen Wynkoop Should you take on a promising employee that you know you’ll have to spend substantial time training, but could pay off? Laura Rose shares her experience with us on this edition of SSWUGtv. Watch the Show Where Do We Go From Watson A frequent topic I have with software professionals is the […]

Readers Notes on Unique Keys for Multiple DataCenters Today we have some responses from folks having to implement multiple datacenters with unique keys. Giles: First, thanks for all the good articles you provide every day! Using a GUID to identify a record can produce some problems if you don’t take care of the function used to generate the GUID! From […]

Reverse Sharding Data When you shard data you find a differentiation factor in the data to distribute the data. Today I am going to finish up on this series of merging data from distributed data stores into a single data store through replication. The issue we have been discussing is how to generate primary keys in remote data stores allowing […]

SSWUGtv – Should you Buy a Surface Tablet? With Stephen Wynkoop Before you go and buy the Surface tablet, listen to Steve’s thoughts on it — it might surprise you! Watch the Show Replicating Data from Multiple Locations to a Centralized Database Yesterday we started this discussion regarding replicating data from multiple locations into a single centralized database. The question […]

Unique Keys with Multiple Database Replication One system I worked on years ago had a central database containing the contents of all regional databases aggregated into a single database through replication. The architecture was perfect for the company. Regional databases contained data required for regional operations without overhead of accessing the entire corporate data. Because their data storage was local, […]

Continuous Integration Continuous Integration is a popular process where software is developed incrementally, and each increment is integrated into the package as a whole. You’ll find this techniques for many different software development lifecycles because it is not constrained to a specific flow. The only constraint is that each incremental software aspect is completed it is rolled into the current […]

Continuous Integration Continuous Integration is a popular process where software is developed incrementally, and each increment is integrated into the package as a whole. You’ll find this techniques used for many different software development lifecycles because it is not constrained to a specific flow. The only constraint is that as each incremental software aspect is completed it is rolled into […]

Maintain Performance Statistics If you maintain a history of the performance statistics on your database servers there are a number of uses for that data. Here is a quick brainstorm of things I have done or read that others are doing. When performance appears to degrade you can compare it to a baseline and historical trend to determine possible causes […]

Year End Tasks It’s time for that annual reminder to do some system maintenance. Make sure your backups and alerts are in place. You’re going to want to be on holiday, away from the office and the stresses found there. So, make sure your backups are working correctly. Make sure your automated processes are working. Make sure your alerts are […]

Data Transfer Objects Microsoft Dot Net uses Data Transfer Objects as a technique for packaging and serializing data to and from their web server systems. Some applications may even use DataSets as a Data Transfer Object http://msdn.microsoft.com/en-us/library/ff649325.aspx. Other implementations may use a class, multiple or complex classes with collections. I have seen WCF tend to lean towards Class based DTOs […]