Tag Archives: sql server

Finding Production Drift

Posted on June 2, 2015 by way0utwest

A few years ago when I started delivering presentations about automating database delivery with Grant Fritchey, I was surprised by something. We were rehearsing a talk and Grant mentioned that there were really only two places where we knew the … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Finding Production Drift

Native Audits

Posted on May 22, 2015 by way0utwest

As our databases contain more and more information, it is becoming increasingly more common to implement some sort of auditing feature to ensure that our data is not being inappropriately accessed or altered. It’s not only the management of our … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Native Audits

DB_Owner Querying for Database Options

Posted on May 21, 2015 by way0utwest

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

Posted on May 21, 2015 by way0utwest

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