Tag Archives: administration

DB_Owner Querying for Database Options

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. What can a user with the db_owner database role do? I assumed anything inside of the database (create/alter objects, … Continue reading

Posted in Blog | Tagged , , , | Comments Off on DB_Owner Querying for Database Options

Naming Confusion

When I first worked in a corporation that had many servers, I had to learn the encoding of our systems. We had SUIS01, SUIS02, NAIS01, NAOP01, etc. Each name designated a location and department, but no information as to what … Continue reading

Posted in Editorial | Tagged , | Comments Off on Naming Confusion

Controlling Alerts

None of us likes to be on call for our organizations. Late night phone calls, especially for something silly like adding a new user to a system or rebooting a machine, can make for irritable employees in the morning. Too … Continue reading

Posted in Editorial | Tagged , | Comments Off on Controlling Alerts

Getting Database Properties – DatabasePropertyEx()

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had someone ask me a question about security recently, and while working through the answer, I ran across … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Getting Database Properties – DatabasePropertyEx()