Tag Archives: software development

Considering Other Views

I love my Pebble 2 watch. It’s simple, the charge lasts for days, and it does what I want out of a device. However, it’s a device that isn’t made anymore, and after a fall, I have a crack in … Continue reading

Posted in Editorial | Tagged | 1 Comment

Small Changes and Big Impacts

I’ve been doing some work with RLS lately (Row-Level Security). I think this is one of the most useful features added in SQL Server 2016, and I wish it had been available earlier in my career. I’ve had the need … Continue reading

Posted in Editorial | Tagged | Leave a comment

Great Developers Use Source Control

I was rewatching Ike Ellis (b|t) talk on the habits of Great SQL Developers from SQL in the City 2018, and his first item was “Use Source Control“. I happen to agree with Ike, which is why I’m writing this, and I … Continue reading

Posted in Editorial | Tagged , | Leave a comment

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

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 ,

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 ,

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