Tag Archives: software development

Virtual Data

Yesterday I republished an editorial from 2014 for the holiday. The topic was production subsets of data, which has been something that many data professionals have struggled with for years. Many of us have built scripts to delete, change, obfuscate, or alter … Continue reading

Posted in Editorial | Tagged , , , | Leave a comment

Customize Software or Process

Many of us work with software and often wish that we something was designed differently. I’m sure many of us feel the same way about our database schemas, which is usually even harder to change. In any case, we often … Continue reading

Posted in Editorial | Tagged | Leave a comment

It’s the Engineers

There are all sorts of articles and blogs on the Internet that try and teach you how to use a particular technique or technology to solve a problem. Plenty of this information is well written, and showcases the knowledge of … Continue reading

Posted in Editorial | Tagged , | Leave a comment

A Christmas Bug

It’s not really a big deal for me, despite the fact that I travel to Europe in a few days for two weeks. At least, I’m fairly confident this won’t be an issue for me. A few of my fellow #sqlfamily might … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Avoiding Development Taxes

When I first worked in an environment where multiple developers needed to release software, I found too many rules and constraints for smooth development. The process was developed by one person, or for one application, and somehow expanded to encompass … Continue reading

Posted in Editorial | Tagged

Don’t Use Code Coverage

I got asked in a seminar recently how to perform code coverage for T-SQL. There aren’t a lot of options, but there is a project from Ed Elliot called SQLCover that looks to examine how much of your code gets called from … Continue reading

Posted in Editorial | Tagged ,

Rewrite Your Code Tomorrow

One of the things that many developers learn over time is that they write better code with practice. In fact, some of the time a developer will find that if they write a bit of code to solve a problem, … Continue reading

Posted in Editorial | Tagged

I Will Write Bad Code

I’ll write bad code. I know it will happen. I’ll produce a bad query, incorrect logic, or the wrong data transformation being returned. This won’t be a malicious act. It might be because of ignorance, or perhaps just a simple … Continue reading

Posted in Editorial | Tagged ,

Database Development Made Easy

I ran across this post on developing database with SSDT. It has a lot of steps, and reading through it, I find this to make some sense, but I’m not sure I think this is easy. I can see why developers … Continue reading

Posted in Editorial | Tagged , | 4 Comments

Use More Pull Requests

I noticed a short while back that Books Online is on github. You can fork the code and make corrections to pages and then submit a pull request. This is the model that many OSS projects use, including the amazing DBATools project. … Continue reading

Posted in Editorial | Tagged , | 1 Comment