Wait statistic are a fundamental concept of any RDBMS. Let’s review some basics of troubleshooting performance issues with wait statistics.Read More »
A couple of months ago, VMware released a new white paper called “Architecting Microsoft SQL Server on VMware vSphere”. Published in August 2018, it spells out the best practices for running SQL Server on vSphere. Twenty years ago VMware launched and forever changed the compute world.
SQL Server and VMware go together like peanut butter and jelly. Read on to look into the details…
The SQL Server Error Log is one of the most useful thing to troubleshoot database server issues. System errors get logged here along with a host of other useful information.
Read on to see how to understand, analyze, and manage the SQL Server Error Log…
Last week I invited you to share a story of a project gone mad – a death march project that you participated in or were impacted by.
If you haven’t already read the invitation please read it first: T-SQL Tuesday #107 Invitation: Death March
Now let’s see a summary of this month’s submissions!
“Tell me your project horror stories – the worse the better”
Through some redaction, slight change of facts, and creative control with some details I will protect the innocent; and in this case, the guilty as well.
If you don’t have time to read my lengthy exposition then please skip down to the section titled “The Making of a Death March Project”.
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!
I like Halloween so I find myself getting mentally ready each year about a couple of months prior. My mind turns to horrors and I must warn wary travelers in DBA-land about an evil I see all too often – shrinking a database.
I know this has been done to death but I still see it. Gather around the fire as I tell you the ills of shrinking database files.