Category Archives: Editorial

The Traveling Data Professional

It’s summertime in the Northern hemispheres, and a time when much of the world takes their holiday time away from work. Most kids are out of school for at least part of the June/July/August time period. With many of us … Continue reading

Posted in Editorial | Tagged | 1 Comment

Backup Plans for Data Loss

The British Airways computer failure has been on my mind for a few weeks. It seems like such an epic failure in 2017 from a high public company that many, many people depend on. I still struggle to believe the … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Migrating Schema Between Platforms

PostgreSQL is a popular relational database, one that was designed to be an object relational system, based on standards, and allowing for extensibility. I’ve always thought this was a great system, exceeding SQL Server in some ways, though falling short … Continue reading

Posted in Editorial | Leave a comment

DevOps Can Help

Amazon had a load balancer failure in 2012. The analysis of the event shows that there were missing data in the devices that caused issues. The restore of data from these devices is complex, way more complex with less mature … Continue reading

Posted in Editorial | Tagged | Leave a comment

The Need for DRE

“Today’s database professionals must be engineers, not administrators” That’s a quote from an interview at O’Reilly on Database Reliability Engineering. I don’t want to quibble about whether those of us working in technology are engineers in name or not, but … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

Your Job Description

In every job I’ve ever held, there’s been some scope creep in my duties. No matter what I think my job is, I end up handling tasks in very different areas. While bartending, I’ve had to cook food a few … Continue reading

Posted in Editorial | Tagged | Leave a comment

Securing the Things

I would venture to guess that a lot of the data that will be produced in the next few years will come from various “things” that are implemented by companies, users, and governments. We tend to refer to the Internet … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Software Has Bugs

Every once in awhile I have someone I meet complaining about software quality, usually with regards to some piece of Microsoft software. I’ll invariably hear how there shouldn’t be bugs in SQL Server or Windows, and Microsoft isn’t testing their … Continue reading

Posted in Editorial | Tagged , | Leave a comment

SQL Server is Getting Smarter

There’s been a lot of press and media about Microsoft on the AI and machine learning work they’re heavily investing in. From Cognitive Services to Cortana to Bots, Microsoft is really investing in developers and applications that will perform detailed … Continue reading

Posted in Editorial | Tagged , | Leave a comment

The Poor State of Secure Coding

Security is becoming a bigger issue all the time. More companies are getting hacked and losing control of data. It seems every week there’s a new disclosure from some firm. Recently OneLogin had a breach, which is very disturbing as … Continue reading

Posted in Editorial | Tagged , | Leave a comment