A Bundle of Changes

Multiple Defaults

Adding Multiple Columns

Dropping Columns

Implementing Reporting Application Enhancements with No Downtime

The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.

Create a view to Alter a Table and Add three Columns

I am teaching a database class at Queens College. The project entails the truncation of all of the data and loading new data into the  existing database "BIClass" from a single of the flattened data. One of the tasks of the project was to add these three additional columns to each of the tables (AlterTableAddColumnsUserAuthorizationKeyAndTwoTimeStamps): […]

Quickly Dropping Columns

Dropping Constraints 3

Dropping Columns 2

Dropping Columns 1