-
Archives
- February 2015
- August 2014
- December 2012
- October 2012
- July 2012
- May 2012
- February 2012
- January 2012
- December 2011
- July 2011
- March 2011
- September 2010
- August 2010
- July 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
-
Meta
Category Archives: SQL
Here be dragons
I like maps. I wasn’t sure why maps appealed to me until it dawned on me one day that maps are a form of data visualization. The phrase “here be dragons” was used by mapmakers many years ago in reference … Continue reading
Posted in SQL
Comments Off on Here be dragons
Testing SCDs
An SCD is a slowly changing dimension in a data warehouse. There are three different forms of SCDs. SCD1 overwrites data, SCD2 maintains historical data and SCD3 maintains some of the data. SCDs and testing in a data warehouse is … Continue reading
Posted in software testing, SQL
Comments Off on Testing SCDs
The ripple effects of cascade delete
The topic of a cascade delete came up on a project the other day and I was surprised to find one of the project members wasn’t familiar with the term or the concept. I thought I would share a short … Continue reading
Posted in SQL
Comments Off on The ripple effects of cascade delete
Linguistic heuristics
Searching. I’m currently testing a product that has a search feature. I’ve tested search functionality before but not a multilingual search engine that utilizes two different search engines based on the language selected. Nor have I previously worked with a … Continue reading
Posted in heuristics, software testing, SQL
Comments Off on Linguistic heuristics
Dining philosophers and semaphores
Multi-user testing has been on my mind recently. I’ve tested three different applications within the last two months for MU issues and in all three applications I’ve found defects. One book I’m currently reading is The Little Book of Semaphores … Continue reading
Posted in SQL
Comments Off on Dining philosophers and semaphores
Data type testing
Testing input fields based on the object’s data type in the database isn’t testing I hear discussed. But each data type has its own boundaries. Each major database vendor maintains different data types and data types change with database versions. … Continue reading
Posted in SQL
Comments Off on Data type testing
SQL Intuition
I noticed a missing distinct clause on a SQL statement a couple of days ago. Not the most amazing find but its small discovery got me thinking about something I do while testing. I think about the SQL. Sometimes I … Continue reading
Posted in SQL
Comments Off on SQL Intuition