Mitchell Data Base

We have an MS-Access 2016 application that runs on a terminal server which we are upgrading from 2008 R2 to 2012. The prelim testing was don...

If you've worked with SQL Server for a while, you're familiar with the syntax: ALTER TABLE table_name DROP COLUMN column_name E...

I am working with SSIS to import an Excel file into SQL Server. Not being an SSIS expert, I usually use the import wizard in SSMS which lets...

One of the features of SSMS 2008R2 is the Utility Explorer window, which "connects to Database Engine instances to provide a tree view ...

Tortoise SVN is one of the popular source-control systems, which we use at our office. If you've used this product, when you commit you...

SQL Server has an undocumented stored procedure sp_who2 that provides information about the connections to the database. Recently I have b...

Let's say that you have the same table that exists in two different schemas - A.my_table B.my_table ...and you want to write a quer...

MS-Access tab controls offer a method to present multiple groups of similar data, making it easy for user to locate specifics within an intu...

The code has been updated again, this time instead of using sp_columns we are using the system tables directly. This provides access to addi...

Way back in April 2009, I had published the original version of my stored procedure wm_columns which can be used instead of sp_help or sp_co...