Using my Work Log I mentioned yesterday that keeping my work log has helped me to manage my time more efficiently. It helps because I can’t remember everything I have done from day to day…they all just kind of meld into one another. So, using my log I can look at my work log history. I find that I am […]

Keeping a Work Log Recently I have begun keeping a work log for those times when I pick up ad-hoc requests to get tasks done that are not part of my current planned work load. I’m operating as a cloud architect and DBA on an Agile development team . However, we often have needs for maintenance tasks or requests to […]

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 […]