GDPR took effect on May 25, 2018. About 6 months have passed and we are starting to see some of the impact of the legislation. Read on as I analyze the impact of GDPR and tell my story of the Foodland Robot!
How to Analyze the SQL Server Error Log
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…
National Cyber Security Awareness Month – Low Hanging Fruit
Since 2004 the Department of Homeland Security has organized October as National Cyber Security Awareness Month. The goal is to promote cyber security to help keep Americans safe online. Fast forward 14 years and the security landscape has only become more dangerous. More opportunities exist for online abuses than ever before. The proliferation of internet connected devices that comprise the IOT creates additional attack surfaces which often have security as an afterthought instead of baked into the design.
Today I want to focus on the low hanging fruit i.e. the easy wins we can achieve to significantly improve our online safety and security. Read on to see the simple things most people can do to improve their situation.
T-SQL Tuesday #107 Round Up: Death March Project
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!
I’m Speaking – SQL Saturday Charlotte 2018!
On Saturday October 20th I will be speaking at SQL Saturday Charlotte on the topic of Database Corruption! Preventing Disaster to your Database.
Hope to see you there!
T-SQL Tuesday #107 – My Death March Project
This month I have the honor of hosting T-SQL Tuesday #107 about Death March Projects. The topic for this months T-SQL Tuesday #107 (hosted by yours truly Blog/Twitter) is:
“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”.
Blogiversary #2 – Climbing the Blog Ladder
Last month marked the 2 year point for my blog. At times like this I like to reflect on the past so I don’t forget it – even better to learn something from it.
Read on to hear about my last year in blogging!
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!
Stop and Think Before You Shrink – Shrinking a SQL Server Database
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.
I’m Speaking – SQL Saturday San Diego 2018!
On Saturday September 22nd I will be speaking at SQL Saturday San Diego presenting on 2 fun topics:
- Database Corruption! Preventing Disaster to your Database
- Environmental SQL Server Troubleshooting
Read on about my presentations…