Tag Archives: administration

T-SQL Tuesday #67 – Extended Events for DBCC

It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland on Extended Events. You can read the invite, and whether you can participate today or not, write your blog and … Continue reading

Posted in Blog | Tagged , , , | Comments Off on T-SQL Tuesday #67 – Extended Events for DBCC

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