Posts in Uncategorized

Pay the Piper – Software Licensing and Audits

Once upon a Wikipedia safari, I found myself sucked into the article on the Pied Piper of Hamelin. I read that contrary to popular belief, the expression “pay the piper” actually comes not from the Pied Piper, but from the phrase “He who pays the piper calls the tune.” You learn something new every day, I thought to myself. You see, over the years, I have advised employers, clients, and contemporaries that when it comes to software licensing, it is best to “pay the piper.” It was an expression I learned as a kid in the Boston area. Keep reading…

Altering Stored Procedure Families Programatically

Reprinted with permission from owner. Original at http://nlsimmons.com/SQLScraps/

Alter every stored procedure in a database that fits a given criteria

Recently I had to search for, and update, hard-coding server references for every stored procedure in a database. This amounted to altering over 60 stored procedures. Instead of going through each stored procedure, one-by-one, I used the following code to accomplish the task:

Keep reading…

We're Here To Help.

Database problem? Tell us a little bit about it.

Name*

Email*

Subject

Message*

captcha

* Required