All I Want for Christmas is a Clean Database I was reading an advertisement from Melissa Data regarding tools they have for data cleansing. They have tools for verifying and standardizing all kinds of data about people and organizations. As I was reading the ad, it reminded me of a project I worked on years ago when I first completed […]

SSWUGtv With SSWUG Founder, Stephen Wynkoop Happy Holidays from SSWUG! ….and join the rest of the community with some Cloud homework. Watch the Show Wrap Up – Software Testing Over the years, software testing has become a passion with me; primarily automated unit testing. I first experienced automated unit tests working with a team of 14 developers and 20 QA […]

Testing – The Final Query Today I want to finish the journey into testing you SQL code. I started with a customer request for a report of the history of the last 12 months of hiring broken out by department. I chose to use the Adventureworks database in order to demonstrate the code. First we created a table value function […]

Requirements are the Foundation of Good Software As we have been reviewing techniques for writing test cases as early as possible in the development cycle, Alex is reminded of a software development approach for gathering more complete requirements. Alex writes: I have spent many years in software development and there is one approach to software development that I always wanted […]

Testing Your Table Value Function Yesterday we reviewed how we could write a test case for a Table Value Function without first writing the function. Today we are going to demonstrate a couple options for writing the function. You should be able to use the tests demonstrated in yesterdays editorial to test the resulting function. In my databases I always […]

Testing From Requirements I have folks say to me frequently that they cannot begin testing until the coding has been completed. I agree that you cannot complete testing until the code is completed. However, you can begin testing even before the code has been started. In fact, all you really need to begin testing are the requirements. I’m going to […]

Taking Advantage of Multiple CPUs A few months back I wrote about the Map Reduce pattern made popular by Google. It is one example of techniques taking advantage of multi core and/or multi CPU hardware. Map reduce takes work and shards it, distributes the work close to the data, retrieves the results from each of the processes and stiches the […]

SSWUGtv With Stephen Wynkoop How safe is your Cloud, public or private? Do you know what you can do to be sure? Todays show with Patrick Townsend is packed full of answers for anyone using the Cloud! Watch the Show Computer Architecture Changes From Hardware Advancements – Parallel Programming Today I would like to conclude this series of editorials on […]

Excess Computing Capacity Usages – Virtual Machines We’ve been discussing some of the changes we have seen in information technology implementations due to the increasing capacity and reduced cost of computers and networks. We considered multi-layered software applications as a continuing emerging strategy. Another strategy that continues to emerge with higher capacity hardware is Virtual Machines. When virtual machines first […]

Using extra computing capacity Older computer systems required optimized code and hardware capacity in order to produce the quickest results. Those familiar with the CRAY super computers know what this is about. The CRAY was designed physically to have the shortest wires to different components in order to get optimum performance from all subsystems. Today we have multi-gigabit network speeds […]