24 September 2019
24 September 2019

SQL Server Management Studio is as Relevant as Ever

After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management Studio, is about to go out of style. SSMS is no longer the cool new kid on the block: Microsoft has shown consistent effort to develop their new tool, Azure Data Studio (formerly known as SQL Operations Studio), … Read more
12 August 2019
12 August 2019

Hiding What You Shouldn’t See

Back when I was working on a master’s degree, one of our professors told us a story about a colleague who learned how to navigate the Unix system. She was so thrilled about learning this new skill that, in her exuberance, she stumbled upon some hidden human resource files containing confidential information. Eventually, an administrator … Read more
12 June 2019
12 June 2019

Building a Great Technical Team

The process of putting together a team of technical people once was largely centered around getting a group of similarly minded people. How people worked was valued more than how well they could accomplish their job. Finding people who could work together smoothly was a big focus when picking new team members, and was a … Read more
28 May 2019
28 May 2019

Innovation: A Double-edged Sword

We humans have been the most successful animals on earth. We’ve accomplished this by changing the environment to suit our needs instead of always adapting ourselves to fit the environment. We use tools, we invent, and we solve problems. Of course, many other species use crude tools, but none have done anything like inventing computers, … Read more
30 April 2019
30 April 2019

What is Automation?

Today I got a bit closer to a meaningful definition of automation as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing. Why should licensing an automation product be related to the number of users? … Read more
17 April 2019
17 April 2019

The Future of Medicine

If you are a Star Trek fan, you’ve seen the future of medicine, or at least how the writers imagine it will be. Painless, needleless injections are given by hypospray devices, right through clothing with no chance of cross-contamination. The medical tricorder provides an accurate diagnosis in seconds. Broken bones, illnesses, and injuries are quickly … Read more
12 March 2019
12 March 2019

Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

“There are only two hard things in Computer Science: cache invalidation and naming things”Phil Karlton I’m terrible at naming things. I recently wrote some quick code to reproduce a design problem and demonstrate several options for solutions, and later realized that I’d named my objects dbo.Foo, dbo.FooFoo, and dbo.Wat. But I feel strongly about a … Read more
04 March 2019
04 March 2019

Celebrating Women in Tech

NASA recently named a facility in honour of Katherine Johnson, the mathematician who performed the calculations for space flights in the 50s and 60s. She was one of the “human computers” whose stories were made famous by the movie Hidden Figures just a few years ago. Until that movie was released, the contributions of these … Read more