Featured Article(s)
Do You Use Like? Here are some tips that can help
When using the LIKE clause in your TSQL, there are things you can do to make it more efficient, and things you can do to make it work much harder than needed. Here are some tips to help address these issues.
Ethics Revisited
Within the last few years, there has been more and more focus on who has access to what data. 10 years ago it was common that professionals who developed had access to production data. There are arguments for it, arguments like "if data can alter a data flow path then current data is needed for valid testing and development of new code."
No matter the adjustments in the law, there are still permission levels that will leave either a person or a group of people with the keys to the kingdom. With this level of permissions eventually trust comes into the picture. There is trust in someone on the staff that they will make the right decisions when no one is watching.
The question is: how can we as a group of professionals manage the trust? There have been some who have already violated this. There are the bonding options and insurance options and that may protect the company to a point of financial loss, but what protects the data? How does your company handle this and what do you think we can do together to set the expectations high?
Email me and let me know your thoughts. (chris@sswug.org)
Did you know?
Custom database roles can be created to manage permissions in the database. There is no like feature on the server level however scripts can be used to apply permissions consistency.