SSWUGtv With Stephen Wynkoop Be sure to check out this edition of SSWUGtv where Devin Knight provides some great tips when selecting a Reporting Tool for your application. Check it Out! Model Drive Design and Data Driven Design Recently I have been discussing the merits of each of these application design methodologies. Many people are not even aware that there […]

SignalR Last night I attended a demonstration of SignalR by Jeremiah Billmann of Skyline Technology. This was the presentation he had made recently at “That Conference”. What a blast. SignalR is not a product for every web site or web server based application; but when you need what it can do, it really rocks. I describe SignalR as an Event […]

Slipstream Install Are you tired of installing SQL Server software and then immediately having to go back and apply service pack updates? There is some great news for you. Microsoft has made it possible to update your original install package with the changes in a service pack from the same release version. In certain scenarios, this is the only way […]

Final Data Hoarding Thoughts Jim writes today with insights gained by decades of consulting. I think he summarizes the whole topic quite nicely. In short, data hoarding is one of the lower priority issues compared to many other initiatives we have to manage for a business. The risk is not as high as the reward. The cost of removing the […]

Data Hoarding Experiences Based on personal experience consulting with many different companies, conversations with who knows how many IT Professionals, and even responses from you, our readers, it appears that there is enough data hoarding going on to start a reality TV series. Data Hoarding, to me, could be defined as Retaining data in original transaction form, on active data […]

Hording Data I recently read yet one more article on the need to meet massive scale storage requirements, and how current technologies are not able to scale with reasonable performance to terabyte, petabyte or even larger scales. Who needs this kind of storage? How big does a company have to be in order to require a terabyte of storage? Have […]

Favorite Reads Following is my list of books I keep near at hand as reference or personal study. Many times I will read a book through not with the intention of complete comprehension; my goal is to understand the contents of the book and get the big picture. Later I will drill into content attempting to implement examples or build […]

It’s not “Enterprise Transform and Load” John Writes: Just a point of correction: in your opening paragraph you stated "One of my favorites was how to test ETL (Enterprise Transform and Load) and Queries." ETL actually stands for "Extract, Transform and Load", unless you are referring to something that is Agile specific, which would seem confusing to me as a […]

Mocks for SQL One of the best books I have read in the last decade is Agile Database Warehousing. It has a lot of great content beyond Agile techniques. One of my favorites was how to test ETL (Enterprise Transform and Load) and Queries. What is common about ETL, TSQL Queries and MDX Queries is that they all have input […]

Mocks for SQL Mocking is not a term usually heard in conjunction with SQL development. An object oriented program may use a mock to emulate data returned from a database in order to test the program without requiring a database to be present. The mock simply acts as a substitute for the database engine. Why not use a mock when […]