Tag Archives: software development

Considering Other Views

Posted on April 12, 2018 by

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

Posted on March 27, 2018 by

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

Posted on March 15, 2018 by

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

Posted on February 20, 2018 by

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

Posted on January 16, 2018 by

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

Posted on January 8, 2018 by

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

Posted on December 4, 2017 by

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

Posted on November 21, 2017 by

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

Posted on October 9, 2017 by

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

Posted on October 4, 2017 by

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