Monthly Archives: May 2015

Changing NULL to NOT NULL – Dealing with Data

Posted on May 25, 2015 by way0utwest

I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple way. However I didn’t cover some of the cases where you have data in the column, or other restrictions that … Continue reading →

Posted in Blog | Tagged , | Comments Off on Changing NULL to NOT NULL – Dealing with Data

Unit Testing in Philadelphia

Posted on May 22, 2015 by way0utwest

I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an all day, paid for event, that looks at how you can use a framework to write unit tests for your … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Unit Testing in Philadelphia

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