Monthly Archives: August 2016

Filtering Objects with DLM Dashboard

Posted on August 31, 2016 by

I’ve been looking at some of the features of DLM Dashboard as I go through work building database development pipelines. In this post I wanted to cover one of the lesser used features, filtering objects. Note: DLM Dashboard is a … Continue reading →

Posted in Blog | Tagged , , ,

Rogue Algorithms

Posted on August 31, 2016 by

This editorial was originally published on Sept 5, 2-12. It is being re-published as Steve is on vacation. I have always thought that computers do some amazing things, but they tend to do what we tell them to do, even … Continue reading →

Posted in Editorial | Tagged

Finding out Who’s Touching Your Database at DevConnections

Posted on August 30, 2016 by

I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready … Continue reading →

Posted in Blog | Tagged , , ,

Avoiding Stored Procedures

Posted on August 30, 2016 by

This editorial was originally published on Aug 13, 2012. It is bein re-published as Steve is on vacation. I ran across this piece from a developer on why he avoids stored procedures and thought it made some good arguments. The … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Separate Accounts

Posted on August 29, 2016 by

This editorial was originally published on Aug 10, 2012. It is being re-run as Steve is on vacation. Many years ago I worked in a small company that only had about 5 or 6 servers. We had one system administrator … Continue reading →

Posted in Editorial | Tagged

Up, Up, and Away

Posted on August 26, 2016 by

I’m leaving tonight. Not forever, but for a couple of weeks. While that’s not a big deal for many people, I’ve rarely been away from home for more than a week. My longest business trips have been 11 days. Short, … Continue reading →

Posted in Editorial | Tagged | 1 Comment

Better Coding

Posted on August 25, 2016 by

When the census was last taken in the US, it was still mostly a paper affair. My wife and I sat down with the form, filled it out, and mailed it back to the US government. While much of the … Continue reading →

Posted in Editorial

SQL Saturday–Viking Edition

Posted on August 25, 2016 by

I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side trip on Friday before the actual event. The actual training will be at the Noroff campus in Oslo. This is … Continue reading →

Posted in Blog | Tagged , ,

Output into a Table–#SQLNewBlogger

Posted on August 24, 2016 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I often see people struggling to use triggers for auditing, or having issues with building them to handle multi … Continue reading →

Posted in Blog | Tagged , ,

The Future for Database Administrators

Posted on August 24, 2016 by

I’ve been working in technology for over 25 years. As I look forward in time, I suspect I have less time left in a data professional career than I’ve already experienced. That’s fine, and while I don’t plan on retiring … Continue reading →

Posted in Editorial | Tagged