Last week, as the first North East blizzard of 2016 approached, my inner hermit rejoiced at the prospect of being stuck at home, and having the opportunity of tackling those chores that are frequently put on the back burner when outside shinny things are dangled in from of me. Jonas was the perfect opportunity to finish … More Focus – Pocus
On the previous post, we moved validation functionality to the Scraping object. The resulting function was this: There is still too much going on. The next step is to extract a method to process the items on the list, I called this method ScrapeStockData The resulting function would be, you can get an idea of … More Refactoring IV – Finally There
On the previous post I moved URL parsing code by extending the StockData class and creating a property called Url, now we are left with this code, but if you look at the highlighted code, there are way too many things happening here!. First you see negotiations between StockData and TickerData, validations. This functionality needs to be moved … More Refactoring III -Why is this here?
On my previous post, I started refactoring a function that reads stock and dates, checks the data against Yahoo Finance and returns some data. In this function, I take the Stock Ticker and the data and parse the URL to be evaluated by our web scrapper object. Now, this code can be taken out of … More Refactoring II- Encapsulating
Refactoring is an important process to crafting readable and maintainable code. Functions should follow the single responsibility principle – a function should do one thing and one thing only and should have few lines of code. Like with everything, you should apply this with measure and wisdom. I was asked to write a function that … More Refactoring I -Convert Linq Anonymous Types to List
The Problem My client wants to backup all the databases in their MS SQL Server Server – 1,000 large databases – to a shared network drive. I want to run a script, get coffee and come back to check when the backup is completed. Solution Created a script to backup all the databases on the … More SQL-Transact Backup all Databases In a MS SQL Server
Last weekend we went with friends on a skiing trip to the Poconos, Pennsylvania. Our trip was a simple one and half hour drive from North New Jersey to just over the Delaware Gap – the border between Pennsylvania and New Jersey. On our way down, our driver and co-pilot took out their respective iPhones and … More Three GPS systems – One destination
The Problem A client sent me an excel sheet with financial information classified in columns where each column header was a date and the values associated with that date were listed below I needed to insert the information to a normalized table with the following columns: Client Account EntryDate Value The Solution Step 1 Loaded … More Transact-SQL Server – Transposing a table
The obligatory reflection on what have we accomplished in 2015 … always a sticky question. But if keep it to my book, training and research, it does not look that bad, I managed to keep the momentum going. Software Development Cracking the coding Interview – Gayle Laakman This is a great book with brain teasers and … More Books every software developer should read in 2016 – if you have not done so
Serendipituos Code 