T-SQL Tuesday Logo

T-SQL Tuesday #107 Invitation: Death March

There is a famous book in our field written in the 2000’s by Ed Yourdon called “Death March“. In it he details the phenomenon in project management of death march software projects. He observed a trend in organizations who plan software projects to estimate so poorly that completion becomes overwhelming and unlikely.

More companies than ever before could be considered “software companies”. Project planning hasn’t gotten much better over time and we still have terribly managed projects. The best reason to explain this I found on Quora – Why are software development task estimations regularly off by a factor of 2-3? In particular, read the answer by Michael Wolfe midway through the page. It is both a humorous and scary analogy.

On this month of Halloween we are going to discuss our death march project horrors!

Read More »

Prison Window

The Prisoners Dilemma of Defect Disclosure

Cory Doctorow wrote an excellent piece about the disclosure of software security defects. The post “Telling the Truth About Defects in Technology Should Never, Ever, Ever Be Illegal. EVER.” spells out the current predicament and suggests a way forward.

This topic is contemporary, impactful, and fascinating. It spans various domains such as InfoSec, free speech, censorship, and private corporate rights

Read on as I analyze the article and offer my thoughts about security vulnerability disclosures.

Feature Image Attribution and License.

Read More »

Insert table from Excel to write SQL

How to Insert Into a Table Using Excel to Write SQL

Today I want to show off a quick trick I learned many years ago that is useful to this day.

The Scenario: you have a spreadsheet, CSV file, or some other delimited flat file and need to load that into a database. There are many options to load data into SQL Server; however, a quick method I am fond of is to use Microsoft Excel and manipulate the data to craft insert statements then paste into SSMS and execute.

Read on to see how to parse and load a CSV flat file, character delimited flat file, and columnar text.

Read More »