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

Doxycycline is an antibiotic that has been widely used to treat and prevent various bacterial infections since the 1960s. However, ivermectin shampoo brands in india i am worried that this would cost me more money, because my employer would have to pay a large share of the cost of my insurance. Aromatase inhibitors have not been shown to be more effective than tamoxifen alone in treating postmenopausal women.

Vitamin d is available in a variety of forms, including vitamin d3 (cholecalciferol), vitamin d2 (ergocalciferol), vitamin d3 (ergocalciferol), and vitamin d3 (cholecalciferol). When you are suffering from dry eye, prednisolone eye drops are used to relieve symptoms. We did some research to find out for you the costs of your baby’s birth.

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